We're using Rails 4, PostgreSQL 9.3.4, and PostGIS 2.1.2.
createdb -E UTF8 template_postgis
createlang -d template_postgis plpgsq
psql -d template_postgis -c "CREATE EXTENSION postgis WITH SCHEMA public;"
dancingfrog
/ ngx-lua.sh
Last active
May 3, 2016 22:24
— forked from hit9/ngx-lua.sh
THANK YOU FOR MAKING THIS! UPDATE: Assumes nginx source has been already been downloaded to working directory using $ apt-get source nginx
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/sh | |
| # Script to compile nginx on ubuntu with lua support. | |
| # Assumes that nginx source is already present in current working dir, after running... | |
| # | |
| # $ apt-get source nginx | |
| # | |
| # ... and that nginx-<version>/debian/rules has been updated with | |
| # the desired options, including those passed to ./configure | |
| # |
dancingfrog
/ geoserver
Last active
September 26, 2022 22:14
— forked from naholyr/_service.md
Sample /etc/init.d script for running GeoServer as a service
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/sh | |
| ### BEGIN INIT INFO | |
| # Provides: GeoServer | |
| # Required-Start: $local_fs $network $named $time $syslog | |
| # Required-Stop: $local_fs $network $named $time $syslog | |
| # Default-Start: 2 3 4 5 | |
| # Default-Stop: 0 1 6 | |
| # Description: Starts and stops the GeoServer, which should be located at /usr/share/geoserver | |
| ### END INIT INFO |
dancingfrog
/ LocalTimezoneDatabase.mkd
Created
April 6, 2016 21:58
— forked from revans/LocalTimezoneDatabase.mkd
This is a pretty rough explanation, with some examples, of how to setup a PostgreSQL database with PostGIS, and build your timezone table that you can query, given a latitude and longitude.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /*Sidebar*/ | |
| #sidebar{} /*General sidebar style*/ | |
| #sidebar #working-set-header{} /*"Working files" header*/ | |
| #sidebar #open-files-container{} /*Working files style*/ | |
| #sidebar #open-files-container ul li.selected a{} /*Selected working file*/ | |
| #sidebar #open-files-container ul li.selected a span.extension{} /*Selected working file's extension*/ | |
| #sidebar #open-files-container ul li .file-status-icon{} /*Icon next to a file, dot, X etc.*/ | |
NewerOlder