Last active
March 9, 2021 20:03
-
-
Save zackad/87f2b301b245e0a4a31b5231882b5c31 to your computer and use it in GitHub Desktop.
ogr2ogr cheatsheet
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
# export mysql database into shapefile | |
ogr2ogr out_shapes MYSQL:gis,user=root,password=password | |
# import shapefile into mysql | |
ogr2ogr -f MySQL MySQL:database_name,user=root,password=password my_shapefile.shp -nln table_name -a_srs EPSG:4326 -update -overwrite -lco engine=MYISAM | |
# reproject spatial reference from WGS 84 UTM 48S to Geographic Lattitide/Longitude Coordinate System | |
ogr2ogr -f "ESRI Shapefile" target_file.shp source_file.shp -s_srs EPSG:32748 -t_srs EPSG:4326 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment