Skip to content

Instantly share code, notes, and snippets.

💭
Is your pen smarter than a 5th grader?

Gary Pinkham gpinkham

💭
Is your pen smarter than a 5th grader?
  • Pinkham Software
  • Boston
Block or report user

Report or block gpinkham

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@gpinkham
gpinkham / gist:6dc1a029b9cc25c23fb9fe2b79d2ffd8
Created Nov 7, 2016
Sample of some GIS analysis with PostGIS
View gist:6dc1a029b9cc25c23fb9fe2b79d2ffd8
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)
You can’t perform that action at this time.