Dean Kramer deanohyeah
deanohyeah
/ Create a migration
Last active
December 20, 2015 12:39
This file contains 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
| dropdb <name> | |
| createdb <name> | |
| django-admin.py syncdb | |
| ## loads db | |
| pg_restore --verbose --clean --no-acl --no-owner -h localhost -U dkramer -d migrate_test ~/Desktop/b009.dump | |
| fake it |
deanohyeah
/ Create a migration
Created
August 1, 2013 00:29
This file contains 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
| dropdb <name> | |
| createdb <name> | |
| django-admin.py syncdb | |
| - loads db | |
| pg_restore --verbose --clean --no-acl --no-owner -h localhost -U dkramer -d migrate_test ~/Desktop/b009.dump | |
| fake it |
This file contains 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
| pg_ctl -D /usr/local/var/postgres9 -l /usr/local/var/postgres9/server.log start |
deanohyeah
/ gist:5551067
Last active
December 17, 2015 04:29
This file contains 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
| <?xml version="1.0" encoding="UTF-8"?> | |
| <!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd"> | |
| <plist version="1.0"> | |
| <dict> | |
| <key>KeepAlive</key> | |
| <true/> | |
| <key>Label</key> | |
| <string>homebrew.mxcl.postgresql</string> | |
| <key>ProgramArguments</key> | |
| <array> |
This file contains 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
| fix projection if needed | |
| ogr2ogr -t_srs EPSG:4326 output.shp input.shp | |
| convert to geojson | |
| ogr2ogr -f GeoJSON output.shp input.shp |
This file contains 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
| @font-face{font-family:'icomoon';src:url("http://seattletimes.com/css/2013/fonts/icomoon.eot");src:url("http://seattletimes.com/css/2013/fonts/icomoon.eot?#iefix") format("embedded-opentype"),url("http://seattletimes.com/css/2013/fonts/icomoon.svg#icomoon") format("svg"),url("http://seattletimes.com/css/2013/fonts/icomoon.woff") format("woff"),url("http://seattletimes.com/css/2013/fonts/icomoon.ttf") format("truetype");font-weight:normal;font-style:normal}[data-icon],[class^="icon-"]:before,.icon-square:before,.Internal:before,.Related_story:before,.icon-external:before,.External:before,.icon-photo:before,.Photograph:before,.Photo_Gallery:before,.icon-print:before,.Print:before,.icon-video:before,.Video:before,.King_Video:before,.AP_video:before,.Graphic_Animation:before,.icon-chart:before,.icon_character{font-family:'icomoon';speak:none;font-weight:normal;-webkit-font-smoothing:antialiased;color:#bc5c23;content:attr(data-icon)}[class^="icon-"]:before,.icon-square:before,.Internal:before,.Related_story:before |
NewerOlder