Okay team. So: here’s what I want to do. Presently I am generating beautiful polygons. I am working from an assessors base map. I have a search function that is able to identify and pull up the individual parcel I am interested in looking at. What I now want to do is add all other parcels within that same viewing window.
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. Unfortunately, I can’t do that – because mySQL doesn’t have the distance spatial function implemented anywhere but in their help files. How have other people overcome this obstacle? I have considered a second alternative, which is to hard-code the parcels adjacent to each parcel in a separate field. So parcel 1 would have 2,3,4,5,6 in its adjacent_parcels field and I’d call that field and then create a select query for polygons with 2,3,4,5,6 in the where clause. This would work, however it doesn’t allow for an adaptable system as new parcels are added, whereas a query based on a distance function would. I bet this problem has been encountered before: is there any method within the API that can help? I would be absolutely delighted to receive any and all suggestions. The most recent version of my map is as follows: http://freeforthepicking.com/imagery/kmlmap6.7.SITUS.php Try account 1101850 or an address at 1025 Burwell to see what it does. Thanks for your thoughts everybody! Dominic --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
