Skip to content

Instantly share code, notes, and snippets.

@gpinkham

gpinkham/gist:6dc1a029b9cc25c23fb9fe2b79d2ffd8

Created November 7, 2016 16:53
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 gpinkham/6dc1a029b9cc25c23fb9fe2b79d2ffd8 to your computer and use it in GitHub Desktop.
Save gpinkham/6dc1a029b9cc25c23fb9fe2b79d2ffd8 to your computer and use it in GitHub Desktop.
Download ZIP
Sample of some GIS analysis with PostGIS
Raw
gistfile1.txt
This is using Land Use Data from MA Essex County and National PowerPlant data. Transform the Point Geometry of the
powerplant to Polygon Geometry so it matches the Land Use Geometry..
select e.gid, e.lu05_desc, area, len from landuse2005_poly_esse e left join powerplants_us_201603 p on ST_DWithin(e.geom, ST_TRANSFORM(p.geom,26986), 50) where p.statename = 'Massachusetts'and p.tech_desc like '%Solar Photovoltaic%' and e.lucode = 6;
gid | lu05_desc | area | len
-------+-----------+---------------+---------------
17425 | Open Land | 14549.1102768 | 490.826119918
46015 | Open Land | 11932.5353651 | 702.019288855
(2 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment