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

maning sambale emmanuel.sambale at gmail.com
Wed Apr 24 11:52:59 UTC 2013

Dear Eugene,

Thank you for looking at the data.

On Wed, Apr 24, 2013 at 1: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.

Agree.  For areas with highres imagery we can just copy the tags and
use a polygon for the school grounds.

> 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?
Yes the SCHOOL_ID is an official reference number corresponding to a a
Region/Province and School Division.
Is the ref=* tag the correct place for this?

My proposal is:
1. Subset the data into smaller chunks say 500 schools for each file.
2. Prepare a list in the wiki to download the data.
3. Wiki gets updated if someone will edit one file by adding his
username in the table.
4. In JOSM, load the data a separate layer from the OSM data.
Edit/trace school grounds, buildings, foootways in the OSM layer.
Copy-paste tags
from the deped school layer to OSM layer.  Assign a changeset a
specific comment for this upload.  (This is also possible in P2).
5. Update the wiki by adding the changeset number if the data import
is finished.

Make sense?

For DepEd,  we will proved an extract of OSM schools data as a shapefile.

"Freedom is still the most radical idea of all" -N.Branden
wiki: http://esambale.wikispaces.com/
blog: http://epsg4253.wordpress.com/

More information about the talk-ph mailing list