Advertisement
Guest User

Untitled

a guest
Jan 21st, 2017
143
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.47 KB | None | 0 0
  1. # export mysql database into shapefile
  2. ogr2ogr out_shapes MYSQL:gis,user=root,password=password
  3.  
  4. # import shapefile into mysql
  5. 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
  6.  
  7. # reproject spatial reference from WGS 84 UTM 48S to Geographic Lattitide/Longitude Coordinate System
  8. ogr2ogr -f "ESRI Shapefile" target_file.shp source_file.shp -s_srs EPSG:32748 -t_srs EPSG:4326
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement