Hey All, OK..I asked this before, but my small project that turned into a slightly bigger project just became huge (by my standards). Below is a brief summary of what we have and what we need. And, btw, we are moving our website to Drupal in the next few weeks if that matters AND we have our sales team on SalesForce. We have: Postgres with PostGIS on a BIG machine (dual quads, 32GB Ram, tons of storage, running XP) We have geo data for TONS of locations in the US along with a neighborhood shapes file. We also have the tiger data for city/zip shapes. What we need to do: 1. Display the existing territories of our clients. These shapes are defined in PostGIS in their standard format. 2. Allow our sales consultants to define new client territories by neighborhood, city, zip or polygon. -2a. We want to have the ability to display the neighborhood/city/ zip shapes by choice (i.e. a button for each) -2b. Once an area is selected we want to query our location DB to give us a count of three different types of businesses. We'll actually use the zip/city values in the tables to do the query because the tiger shapes aren't quite perfect but we'll use the shape as the selection option. 3. After an area or multiple areas are selected we need to save the selection to a table to "reserve" the area. Each save will create a new value with the shapes having dependent values assigned to them. (i.e. save123 and save123.1 , save123.2 , etc.)
Now...if that wasn't enough...they also want version history. So, we could go back into the saved file and "rollback" to a previous selection. Finally...our current site is standard HTML and I'm in the process of upgrading to a Drupal platform. So, I'm debating if it would be easiest to build this mash in Drupal or just to it in SalesForce Apex. I hope this all made sense...I don't want to be too wordy and loose attention but I hope I didn't miss anything. Thanks to everyone for the previous help and thanks in advance to anyone who has some ideas now. D --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
