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

lrazafindrazay at worldbank.org lrazafindrazay at worldbank.org
Thu Apr 25 02:00:37 UTC 2013


Yes, the School_ID is official ID.

On Apr 24, 2013, at 12:49 AM, "Eugene Alvin Villar" <seav80 at gmail.com> wrote:

> We should not import the data straight out. I've checked some of the data and some of them are located on the road in front of the school and not on the school itself.
> 
> Also, I think we can provide our own value to the data. Instead of adding nodes corresponding to the data points, let's trace the actual school area and add buildings as well. For this, we need to intersect the DepEd data with the Bing imagery outlines.
> 
> For data located in areas without Bing imagery (or other hi-res), I think we can import as nodes.
> 
> 
> Question: is the SCHOOL_ID attribute an official ID that we can use for the ref=* tag? Or is this just a database primary key ID?
> 
> 
> 
> On Tue, Apr 16, 2013 at 6:43 PM, maning sambale <emmanuel.sambale at gmail.com> wrote:
>> Dear everyone,
>> 
>> I created a wiki page for documenting the discussion related to this data:
>> 
>> http://wiki.openstreetmap.org/wiki/WikiProject_Philippines/Data_import/DepEd_Schools
>> 
>> Feel free to improve and update as we progress with the discussion
>> here in the list.
>> 
>> Below is a sample of the data for Metro Manila.  This is a
>> straightforward translation from shapefile to osm file using ogr2osm.
>> We should agree on the proper tags if we intend to import this to OSM.
>>  You can load the OSM file in JOSM or Potlatch 2 to compare the
>> accuracy of the data.
>> 
>> This is just a sample data for review, PLEASE DO NOT UPLOAD THIS FILE
>> INTO OSM DB!
>> https://docs.google.com/file/d/0B-2WZQ1DwK_xTUl5MVQ1SUdoQkE/edit
>> 
>> 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/
>> > ------------------------------------------------------
>> 
>> 
>> 
>> --
>> 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
> 
> ________________________
_______________________
> 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/20130424/e7e5dd85/attachment-0001.html>


More information about the talk-ph mailing list