Series of simple example PostgreSQL/PostGIS scripts that geographers (or anyone) might find useful
Latest commit 144f3d4 Nov 13, 2016 @bspauld committed on GitHub Update README.md
quick update to the text. Added new link
Permalink
Failed to load latest commit information.
Images
CalculateAreaPostGIS.sql
CalculateBufferPostGIS.sql Update CalculateBufferPostGIS.sql Nov 11, 2016
CalculateCentroidPostGIS.sql Update CalculateCentroidPostGIS.sql Nov 11, 2016
CalculateExtentPostGIS.sql update code Nov 12, 2016
CalculateLengthPostGIS.sql
CheckInvalidGeomPostGIS.sql Create CheckInvalidGeomPostGIS.sql Nov 13, 2016
CreatePostGISDB.sql Update CreatePostGISDB.sql Nov 11, 2016
FixInvalidPostGIS.sql
GeomContainsPostGIS.sql Create GeomContainsPostGIS.sql Nov 12, 2016
GeomDifferencePostGIS.sql Update GeomDifferencePostGIS.sql Nov 12, 2016
GeomIntersectPostGIS.sql Intersect features using PostGIS Nov 11, 2016
GeomUnionPostGIS.sql Create GeomUnionPostGIS.sql Nov 12, 2016
LoadShapefilePostGIS.md Update LoadShapefilePostGIS.md Nov 11, 2016
MultiPointtoLine_PostGIS.sql First commit of MultiPointtoLine_PostGIS.sql Nov 4, 2016
README.md

README.md

PostGIS for the Geographer

Series of simple example PostgreSQL/PostGIS scripts that geographers (or anyone) might find useful.

New scripts will be added over the next couple weeks, that use sample data that is available below.

All scripts and tables used here are based on the GEOMETRY data type

Data used in scripts and tutorials can be downloaded here (it's a 28mb zip). All data originally downloaded from Natural Earth's awesome website

If there are any specific PostgreSQL/PostGIS scripts you would like to see, shoot me a message @GISDoctor.

Boundless also has a really good intro to PostGIS workshop - check it out here.