Skip to content

Instantly share code, notes, and snippets.

@mccraigmccraig

mccraigmccraig/import.sh Secret

Created April 7, 2017 17:36
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mccraigmccraig/40b1675f6eb01cd3fcd0cf41bf9cf168 to your computer and use it in GitHub Desktop.
Save mccraigmccraig/40b1675f6eb01cd3fcd0cf41bf9cf168 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
import.sh
# import to PostGIS
# regions (MultiPolygons)
shp2pgsql -s 4258:4326 -d -I NUTS_RG_03M_2010.shp nuts_2010_rg | psql -d clustermap2
# attributes (data only, joins to regions)
shp2pgsql -s 4258:4326 -W LATIN1 -n -d NUTS_AT_2010.dbf nuts_2010_at | psql clustermap2
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment