Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I am new to PostGIS.

I am working on a project, for this i need to find out abutter notification that generates a list of properties within the buffer zone from the selected property with user input distance in radius and generate a mailing list of each property displayed by the buffer result.

we are using Geoserver server and postgis. need to do this on the server side coding and display result in openlayer viewer. Can anyone guide me with postgis spatial query to find this parcels from the selected parcels. Distance measured for this is from the parcel outline not from the center of property.

Thanks in advance for your assistance.

share|improve this question

1 Answer 1

The first steps to to perform this process are:

SELECT 
 a.abutters, 
 ST_Intersection(a.geom, ST_Buffer(b.geom, 1000)) as plot
 ST_Distance(a.geom, b.geom) as distance_to_project
FROM 
 addresses as a,
 project as b
WHERE
 ST_Intersects(a.geom, ST_Buffer(b.geom, 1000)) -- assuming a 1000m radius

This will give you a list of abutters, the plots that are affected, and the distance. This assumes that you have two tables addresses and project both which have a geometry column called geom.

share|improve this answer
    
Thanks Djq. I will try and update my findings –  Bob Mar 24 '13 at 23:20
    
ST_DWithin is a better choise than the combination of intersects and buffer since buffering is a quite expensive operation. –  Nicklas Avén Mar 25 '13 at 7:53

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.