zeitiger
/ gist:a57ead8904ee9a6ec4c3
Created
March 9, 2016 08:21
How to convert shp to geojson under Mac OS X
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
| #install gdal | |
| brew install gdal | |
| #convert 1:1 | |
| ogr2ogr -f "GeoJSON" file.geojson file.shp | |
| #convert loose, higher tolerance in simplify reduce files size and lost data precision | |
| ogr2ogr -simplify 0.000001 -f "GeoJSON" file.geojson file.shp |
spalladino
/ mysql-docker.sh
Created
December 22, 2015 13:47
Backup and restore a mysql database from a running Docker mysql container
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
| # Backup | |
| docker exec CONTAINER /usr/bin/mysqldump -u root --password=root DATABASE > backup.sql | |
| # Restore | |
| cat backup.sql | docker exec -i CONTAINER /usr/bin/mysql -u root --password=root DATABASE | |