[postgis-users] Attribute query at lat./long. coordinate

[Peter Weilandt]

I came across PostGIS in my search for a tool to use in a website.  I want to develop a website that will use a coordinate (lat & long), which is easily obtained from a user on the client side by clicking on a Google map, and then transferring this coordinate to the server side where it will be used to  query 4 shapefiles, with each shapefile containing many (800+) overlapping polygons, extracting the values from 4 fields of the attribute table for each polygon that contains this coordinate (drill-down results), saving these values in tabular format for immediate processing, and then returning derived values to the user on the client side. There is no map generation required, only extracting data from the attribute table. This sounds simple in concept, but is PostGIS a tool that can accomplish the query portion of this process and, if so, are there any examples showing the code to use for such a query?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20111127/ae57129d/attachment.html>