kgjenkins/count_within_distance.md

Created March 3, 2016 16:34

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/kgjenkins/992fc7b9f494f16e8e7b.js"></script>
Save kgjenkins/992fc7b9f494f16e8e7b to your computer and use it in GitHub Desktop.

Count polygons within a given distance of each feature

Raw

Given a layer called parcels that has a column called abandoned (0 or 1), we add a column called abandoned70ft and to store the number of abandoned parcels within 70 feet.

UPDATE parcels
SET abandoned70ft = (
  SELECT count(*)
  FROM parcels a
  WHERE a.abandoned = 1
  AND ST_Distance(parcels.the_geom::geography, a.the_geom::geography)*3.28084 < 70
)