[talk-ph] Fwd: ideas on importing deped schools db to OSM

[maning sambale]

Elementary and high school, I can't remember now which one is blue or red :)

I can share the data so you can evaluate as well.

Maning Sambale (mobile)
On Apr 6, 2013 11:34 AM, "Wayne Manuel" <wdmanuel at gmail.com> wrote:

> What are the blue and red dots?
>
>
>
> Wayne Manuel
>
>
> On Fri, Apr 5, 2013 at 6:17 PM, maning sambale <emmanuel.sambale at gmail.com
> > wrote:
>
>> Hi,
>>
>> This has been in my Inbox for more than a year.  Forwarding to the
>> list for public discussion and next steps.
>>
>> Data coverage is here:
>>
>> https://docs.google.com/file/d/0B-2WZQ1DwK_xZFBhQmRQTC1rUXM/edit?usp=sharing
>>
>> Incidentally, I found this slide today:
>> http://www.slideshare.net/rexsgalos/school-mapping-deped
>>
>>
>> ---------- Forwarded message ----------
>> From: maning sambale <emmanuel.sambale at gmail.com>
>> Date: Tue, Jan 10, 2012 at 4:01 PM
>> Subject: ideas on importing deped schools db to OSM
>> To: Rally de Leon <ralleon at gmail.com>, Eugene Alvin Villar <
>> seav80 at gmail.com>
>>
>>
>> Dear Rally and Eugene,
>>
>> Sharing this to you before sending to the list.
>>
>> I had a phone conversation with the DepEd Officer who is managing the
>> the DepEd School Mapping project and they gave a go signal to import
>> the school point data into OSM.  The data covers 30% of all public
>> schools in the country.  (See attached sample image).
>>
>> Summary stats:
>> Elementary schools: ~12,000 locations
>> HS: ~2,000
>>
>> Sample attributes:
>> OGRFeature(deped_es_loc):12571
>>   REGION (String) = Region VIII
>>   DIVISION (String) = Biliran
>>   DISTRICT (String) = Cabucgayan
>>   LEGDIST_ID (Integer) = 0
>>   SCHOOL_ID (String) = 120792
>>   SCHOOL_NAM (String) = Langgao ES
>>   X (Real) =      124.612920000000003
>>   Y (Real) =       11.507650000000000
>>   NO_STREET (String) = -
>>   BRGY_CODE (Integer) = 87803008
>>   BRGY_NAME (String) = Brgy Langgao
>>   MUNI_CODE (Integer) = 87803000
>>   MUNI_NAME (String) = Cabucgayan
>>   PROV_NAME (String) = Biliran
>>   POINT (124.61292 11.50765)
>>
>>
>> Any idea on how we can add this to OSM?  What I have in mind are:
>>
>> * No direct import!  Create subsets of the data and allow individual
>> mappers to add them.
>> * How to detect duplicates/existing?
>> * What tags should be added.  If there is an existing node in OSM
>> should we update the tags to include other important data from deped?
>> * How do we "give back" the data to DepEd including our own data from OSM?
>>
>>
>> --
>> 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 at openstreetmap.org
>> http://lists.openstreetmap.org/listinfo/talk-ph
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/talk-ph/attachments/20130406/a1d10ab6/attachment.html>