Skip to content

Instantly share code, notes, and snippets.

@RP-3
Last active December 27, 2020 08:44
Show Gist options
  • Save RP-3/0c4419276b6c05bc80cc5c9c36add4f1 to your computer and use it in GitHub Desktop.
Save RP-3/0c4419276b6c05bc80cc5c9c36add4f1 to your computer and use it in GitHub Desktop.
Useful GIS manipulation commands
#convert SRID to _______ outputDirectory inputShapefileWithAdjacent .dbf, .prj, .shx files
ogr2ogr -t_srs EPSG:4326 ~/Desktop/london_boroughs greater_london_const_region.shpu
#convert to psql
# creating tables where necessary
# inputShapefileWithAdjacent .dbf, .prj, .shx files
# piping the output to this postgis database
shp2pgsql -c ~/Desktop/london_boroughs/greater_london_const_region.shp | psql -d os_boundaries
# BotsonGIS cheatsheet
http://www.bostongis.com/pgsql2shp_shp2pgsql_quickguide.bqg
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment