Ross, Okay, I see what you're saying here: take the centerpoints of all of the polygons, and select out the ones that are east of some easternmostpoint, west of some westermost point etc. But how could I get the easternmost and westernmost points... I suppose I'll have to do the calculation to figure out based on the original centerpoint... Yeah, that's possible.
I'll go make that work, thanks for the help. Sure would be easier if I could just use a mySQL distance function though. Dominic On Jun 10, 11:09 am, Rossko <[email protected]> wrote: > > Originally, I had thought that I would create a separate SQL query > > based on distance – say select all OGC_GEOM polygons that have their > > centerpoint within 1000 feet of the centerpoint of the parcel I am > > currently working with. > > Assuming you have some kind of geo-location info in your database, > just search it within a simple rectangular bound based on the map > viewport. > select polys where (eastbound < polypointlong AND polypointlong < > westbound) AND ( latitude stuff) > to illustrate the principle. You'd want to select unique polys as > you'll get multiple hits. > > cheers, Ross K --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Maps API" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Google-Maps-API?hl=en -~----------~----~----~----~------~----~------~--~---
