98 different cities should login and make there own info about there toilets. I have only real content for Københavns kommune. Odense and Roskilde is just TEST data.
Table term_data
tid vid name weight
6 2 Københavns kommune 0
7 2 Odense kommune 1
8 2 Roskilde kommune 2Table content_type_copenhagen
Because ALL the info from the different toilet goes into this same content type I can use this to make my Google Maps API and I use it without any map module - you can see it here http://www.tinemuller.dk/test_drupal/ for radius and for Københavns kommune http://www.tinemuller.dk/test_drupal/node/6. There will be a map for every 98 cities and all the info in the radius map.
I have exported the table for content_type_copenhagen to this online SpreadSheet http://spreadsheets.google.com/ccc?key=tAzYrxzQL7eBno8eU4bTlXg&hl=en_GB#... just to show you the data.
Now to my question: Every 98 cities have there own role/permissions and just fill out the data and save, delete, update and it's showed directly on the different maps. That's how I made it. But what if the cities want to use their OWN data and maybe use it to a map on their own site - what is the best way to do this? There is a problem because ALL the cities data is in the same table and you will see this if you look under field_city_value.
Could Services be used or what do you suggest? Hope I have explained it so you understand what I mean. :-)
edited 23.00: This is the code http://www.tinemuller.dk/test_drupal/sites/all/maps/scripts/get_xml.php?... and http://www.tinemuller.dk/test_drupal/sites/all/maps/scripts/get_xml.php?... from which a guy I know is trying to make an Android and Iphone applikation but maybe it also could be made with Services module too?
Comments
In the top of the site there
In the top of the site there is a link to http://www.tinemuller.dk/test_drupal/list_koebenhavn and at the bottom is an RSS button that link to http://www.tinemuller.dk/test_drupal/list_koebenhavn_feed and this is ONLY for this one city. Would it be possible for the cities to get the info from this file into there own site and use the data?
services
Yes, from my understanding of Services, it will do the job for you. It is for getting data directly out of the individual nodes, or views, or what have you...so you can format the way you want your data coming out. But given that the data is all of a consistent format then it should be easy to document it and let the various cities utilise the feed. Or they can just use what RSS produces.
Oh, and good on you for helping Danes find the toilet. I hope your site is also used at DrupalCon Copenhagen!
~Don't procrastinate NOW!!! Do it tomorrow.~