New answers tagged point-in-polygon
I had a tool I made that basically did this, so I just tweaked it a little to fit what you need. It's called Calculate Point Statistics, and you can download it here: http://ianbroad.com/downloads/CalculatePointStatistics.tbx Source code: http://ianbroad.com/downloads/scripts/CalculatePointStatistics.py It takes an input Polygon and Point feature class ...
Seeing as you have Info (Advanced) level of license you can use the cool geoprocessing toys. Get the values of the polygons onto the points either by spatial join, identity or intersect. I think that intersect would be my choice. This will generate a point for each intersection i.e. if a point falls in more than one buffer then there will be one instance ...
Would be more efficient with EXISTS I think since it can stop after first positive. Though Martin's answer should work as well SELECT boundary.* FROM boundary WHERE EXISTS (SELECT location.geom FROM location WHERE ST_Intersects(boundary.geom,location.geom) );
Try something like this SELECT DISTINCT ON (boundary.id) boundary.* FROM boundary, location WHERE ST_Intersects (boundary.geom, location.geom) [paul ramsey made an improvement, but forgot the I in ID]
You chose the wrong argument order. This is correct the ST_Contains function ST_contains(bar.hull,ST_GeomFromText('POINT (34.8039 32.1049)'))
Top 50 recent answers are included