MySQL Forums
Forum List  »  PostgreSQL

Points within Polygons
Posted by: John Beck
Date: February 22, 2008 08:36AM

I have successfully imported an ersi shapefile into a spatial indexed mysql table. I would like to use that table to store the polygons. I then have a 2nd table that stores x,y data of points. I need to select the rows of the points that fall within the polygons from the 1st table and give the selected row the polygon id in which it falls. I use php to run my queries. Should I use the spatial index table or is there an easier way to conduct this query? Any help would be appreciated.

Options: ReplyQuote

Written By
Points within Polygons
February 22, 2008 08:36AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.