Hello, I'm developing a website that uses the google maps API. The objective of the site is to have users (which can login) to submit different types of geographic data(markers).
I have a mysqlphp database to store the users information, however i have been trying to find the best way to store the geographic data and i'm having problems deciding. Even if this question is not directly linked to the google maps api, if you could spare some minutes to help me it would be very nice :). In my first approach each user had an xml file for the geographic data ( so i wouldn't pass the limit of 1mb file of the api), but i wanted to implement a function where users could select an area and all the geographic data from all the users in the system which was on the that area bounds would be displayed. This would imply i would open all the xml files which is not viable. I could put the geographic data on a database and this problem would be over, however if i wanted to add the possibility of the user to submit new kinds of geographic data (e.g a polyline or a polygon or even other kind of object defined in a xml) i had to alter my database, whereas using an xml this would only mean a new node. Do u guys have any suggestion on how could i solve this problem? data where users can login and submit different types of data. They can submit text comments about geographic data or simply insert geographic data. The inserted geographic data can be a simple gmarker or an array of markers, for a gpolygon. My main doubt is how to represent the geographic data in a php mysql database or using an xml file per user. >From this description it would seem a database would be the best option for this problem. However if i would want to add a new type of geographic data, e.g. a polyline, with a xml this would be very easy, it would be just adding a new node. Whereas using a php/mysql approach this would be a task that would require me to alter my database. My question is if anyone has got a better sugestion My question is not directly connected to the google maps api but if anyone can help me i would be greatly --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
