Skip to content

Instantly share code, notes, and snippets.

@zackad

zackad/ogr2ogr.sh

Last active March 9, 2021 20:03
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 3 You must be signed in to fork a gist
  • Save zackad/87f2b301b245e0a4a31b5231882b5c31 to your computer and use it in GitHub Desktop.
Save zackad/87f2b301b245e0a4a31b5231882b5c31 to your computer and use it in GitHub Desktop.
Download ZIP
ogr2ogr cheatsheet
Raw
ogr2ogr.sh
# 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