On Feb 4, 2:01 pm, Nhoc6131 <[email protected]> wrote: > Hello all, I've been lurking here for awhile. > > I work for a small city Police Department that is trying to get > involved in using Crime Mapping for Analysis. > > My partner and I are tasked with this with several constraints. We > can't use mySQL or anything server side stuff. So we have to basically > construct this with just html javascript hard coded stuff. > > We have a log of crimes, with several headings such as Date Time > Location Beat Number and Crime Elements > > We have an excel file that has all this information in. It is very > formatted for visual consumption. It would be great if we could use > the data from the excel file, plot the locations on the map and be > able to sort the data displayed based on the headers of the excel > (Date Time, Location Beat.. etc etc) > > Now I can do this i just need some help here and there. We've already > got a map established where it sumbits multiple addresses, geocodes > it, plots its, and then puts it in a table under the map. > > So were trying to jump to the next step being the Excel file. > > If it matters this will be for private consumption with in the > department and doesnt need to be fancy for the viewing public. > > Thanks so much.
This search may help you: http://groups.google.com/group/Google-Maps-API/search?group=Google-Maps-API&q=google+spreadsheet+geocode&qt_g=Search+this+group If you can load the excel spreadsheet into a google spreadsheet, this may help too: http://apitricks.blogspot.com/2008/10/geocoding-by-google-spreadsheets.html -- Larry --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
