Hi Rally, Earlier I've actually thought of a better way than the spreadsheet to populate the WLM geo-database: create a web map application, where you can simply drag and drop a marker over the location of a site. But since creating such an app takes time, this Google Docs spreadsheet is a temporary measure.
I envision the web map app to be something like this: 1. Left half is a table listing all the sites. The list can be filtered by location, completion status, etc. 2. Top-right quarter is where you edit the details of the site (address, etc.) You click on the left half table to select the site to be edited. 3. Bottom-right quarter is the map where you can drag a marker to locate the site. The map can be switched between OSM and Google Maps tiles. What do you think? :) Eugene On Wed, Apr 11, 2012 at 11:48 AM, Rally de Leon <rall...@gmail.com> wrote: > I've tried editing just now and it looks like GoogleDoc approach is > better, considering that any newbie can point-and-click on either OSM > or Google Map, > press permalink, then cut & paste the lat long info into the > GoogleDocs spreadsheet. The GoogleMap & OSM links are auto-generated. > Coolness :-) > > All can see the progress of the project immediately. We can fill-up > the address information. > > Then maybe, we can reinsert the crowd-sourced address data gathered > here back to OSM via the available map editors. > > By then, the unmapped POI's from the list can be hunted down on field > by mappers using GPS; then put the 'source' as gps or mapper. We > finish the project early... > > We should have done this a long time a go :-) > > On Wed, Apr 11, 2012 at 11:23 AM, Ed Garcia <eppgar...@gmail.com> wrote: >> Guys, >> >> My two centavos worth ... >> >> would it not be easier if we just place a special tag on such POIs on OSM >> (maybe NCCA=yes or some other tag) then harvest them all via OSMosis later? >> That way, it eliminates transcribing errors. >> >> :>) ed >> >> >> On Wed, Apr 11, 2012 at 10:59 AM, maning sambale >> <emmanuel.samb...@gmail.com> wrote: >>> >>> I added a few. Will add more later. >>> >>> On Wed, Apr 11, 2012 at 1:20 AM, Eugene Alvin Villar <sea...@gmail.com> >>> wrote: >>> > By the way, as a test, I've started adding some coordinates obtained >>> > from OSM. Check out some of the sites in Baguio and Ilocos Norte in >>> > the list. >>> > >>> > >>> > On Wed, Apr 11, 2012 at 1:01 AM, Eugene Alvin Villar <sea...@gmail.com> >>> > wrote: >>> >> Hi guys, >>> >> >>> >> I have created a public spreadsheet for the WLM sites: >>> >> >>> >> https://docs.google.com/spreadsheet/ccc?key=0AtokxpcNebAxdGJSMFRqX3F5Q3pZd2JpTGxJYThlOGc >>> >> >>> >> It seems crowdsourcing this task is the way to go and using the usual >>> >> geo-research methodologies (OSM, Google, Panoramio, Wikimapia, >>> >> WaypointsDotPH, etc.) >>> >> >>> >> Eugene >>> >> >>> >> >>> >> On Tue, Apr 10, 2012 at 8:15 PM, Ed Garcia <eppgar...@gmail.com> wrote: >>> >>> Nice! That's a very good tip. Thanks Jim >>> >>> >>> >>> >>> >>> On Tue, Apr 10, 2012 at 3:04 PM, Jim Morgan <j...@datalude.com> wrote: >>> >>>> >>> >>>> Ed Garcia wrote, On Tuesday, 10 April, 2012 02:37 PM: >>> >>>> > Anyway, I have been locating many of these sites lately by using >>> >>>> > combined panoramio, google earth, wikimapia. Latest ones are some >>> >>>> > POIs in >>> >>>> > Cagayan Valley. Most often, I see some of these monuments tagged >>> >>>> > in >>> >>>> > panoramio photos that are linked to GE. >>> >>>> >>> >>>> Google Maps (not Earth) has a feature where you can right click on >>> >>>> any >>> >>>> point on the map, and select "What's Here?". That puts a large green >>> >>>> arrow >>> >>>> on the map. If you then click on the arrow it will pop up the >>> >>>> co-ordinates >>> >>>> (in decimal as well as degrees, minutes, seconds). Thought that was >>> >>>> quite >>> >>>> handy. And also, as you're placing the arrow yourself, then you're >>> >>>> not >>> >>>> stealing any info from the Google database, so I imagine you can use >>> >>>> this >>> >>>> information unrestricted. >>> >>>> >>> >>>> Jim >>> >>>> >>> >>>> -- >>> >>>> >>> >>>> datalude: information security >>> >>>> e: j...@datalude.com >>> >>>> Philippines: +63 2 403 1311 / mob: +63 917 849 3939 >>> >>>> Hong Kong: +852 6489 4132 >>> >>>> w: http://www.datalude.com/ >>> >>>> >>> >>>> _______________________________________________ >>> >>>> talk-ph mailing list >>> >>>> talk-ph@openstreetmap.org >>> >>>> http://lists.openstreetmap.org/listinfo/talk-ph >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> -- >>> >>> website administrator: >>> >>> - www.waypoints.ph >>> >>> - reeflife.eppgarcia.com >>> >>> >>> >>> PADI Divemaster #491048 >>> >>> >>> > >>> > _______________________________________________ >>> > talk-ph mailing list >>> > talk-ph@openstreetmap.org >>> > http://lists.openstreetmap.org/listinfo/talk-ph >>> >>> >>> >>> -- >>> cheers, >>> maning >>> ------------------------------------------------------ >>> "Freedom is still the most radical idea of all" -N.Branden >>> wiki: http://esambale.wikispaces.com/ >>> blog: http://epsg4253.wordpress.com/ >>> ------------------------------------------------------ >>> >>> _______________________________________________ >>> talk-ph mailing list >>> talk-ph@openstreetmap.org >>> http://lists.openstreetmap.org/listinfo/talk-ph >> >> >> >> >> -- >> website administrator: >> - www.waypoints.ph >> - reeflife.eppgarcia.com >> >> PADI Divemaster #491048 >> >> _______________________________________________ >> talk-ph mailing list >> talk-ph@openstreetmap.org >> http://lists.openstreetmap.org/listinfo/talk-ph >> > _______________________________________________ talk-ph mailing list talk-ph@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk-ph