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

[maning sambale]

> It might be better to divide the data also along geographical lines. For
> example, by provinces and then divide the data per province into smaller
> chunks like Ilocose Norte 1, Ilocos Norte 2, etc.
>
> I think chunks of 100 is much more manageable. I certainly don't think I can
> process 500 schools in 1 or 2 sittings.

Here's a screenshot of the splitted data in 100 nodes
https://docs.google.com/file/d/0B-2WZQ1DwK_xRFpKcHJyaEh6REE/edit?usp=sharing
https://docs.google.com/file/d/0B-2WZQ1DwK_xa0pkQ2tpNmhacGc/edit?usp=sharing

The ES shapefile is ~190 tiles.

> I suggest to add the upload=false XML attribute to the OSM files to avoid
> accidentally uploading it to OSM.
Yes, the ogr2osm script adds this.  But the splitter I use doesn't
will investigate further.


--
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

Re: [talk-ph] Land area of the Philippines

[Jim Morgan]

tutubi wrote, On Thursday, 25 April, 2013 09:58 AM:
> land area may vary, depends whether it was measured during high tide or low 
> tide too

I was about to make the same joke! But then I did a quick back-of-an-envelope 
calculation and found out it wouldn't actually make that much difference:

Let's assume the Philippines is a rectangle, 300km x 1000km. And lets assume 
that the tide going from "in" to "out" exposes an average of 10m of extra 
beach. So now our rectangle is 300.02 x 1000.02, which is only an extra 26 km2 
of area. 

OK, so its obviously not the correct figure, but I think it gives something of 
the right magnitude. :-) 

Jim 

-- 

   datalude: information security
   e: j...@datalude.com
   Philippines: +63 2 403 1311 / mob: +63 917 849 3939
   Hong Kong: +852 5125 3392 
   w: http://www.datalude.com/ 

___
talk-ph mailing list
talk-ph@openstreetmap.org
http://lists.openstreetmap.org/listinfo/talk-ph

Re: [talk-ph] Land area of the Philippines

[Noli Sicad]

> Parang tanong lang sa Miss Universe ah :)

Approximately. blah blah :-)

Noli

___
talk-ph mailing list
talk-ph@openstreetmap.org
http://lists.openstreetmap.org/listinfo/talk-ph

Re: [talk-ph] Land area of the Philippines

[maning sambale]

Unless they tell you the scale, don't trust the numbers.  Its a
fractal problem. http://en.wikipedia.org/wiki/Coastline_paradox

On Thu, Apr 25, 2013 at 10:09 AM, rem zamora  wrote:
> Parang tanong lang sa Miss Universe ah :)
>
>
> On Thu, Apr 25, 2013 at 9:58 AM, tutubi 
> wrote:
>>
>> Eugene,
>>
>> land area may vary, depends whether it was measured during high tide or
>> low tide too
>>
>> :)
>>
>>
>> ---
>> I explore, therefore I blog!
>>
>> http://www.backpackingphilippines.com
>>
>> http://www.facebook.com/backpackingPhilippines
>> http://www.twitter.com/backpackPH
>>
>> On Apr 25, 2013, at 7:51 AM, Eugene Alvin Villar  wrote:
>>
>> I think most of you already know that the Philippines is supposed to have
>> a land area of 300,000 km². This is what is stored in the United Nations:
>> http://unstats.un.org/unsd/demographic/products/dyb/dyb2009-2010/Table03.pdf
>>
>> However, the National Statistical Coordination Board says its 343,448.32
>> km²: http://www.nscb.gov.ph/view/geography.asp
>>
>> Confusingly, the Philippine Information Agency used to say it its website
>> that the area is 299,764 km².
>> http://web.archive.org/web/20090302131341/http://www.pia.gov.ph/philinfo/default.asp?fi=about&i=geography
>>
>> :-)
>>
>> ___
>> 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
>>
>
>
>
> --
> Rem Zamora
> Photojournalist
> +63-917-592-74-33
> -link to my photos-
>
>
>
> ___
> 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

Re: [talk-ph] Land area of the Philippines

[rem zamora]

Parang tanong lang sa Miss Universe ah :)


On Thu, Apr 25, 2013 at 9:58 AM, tutubi
wrote:

> Eugene,
>
> land area may vary, depends whether it was measured during high tide or
> low tide too
>
> :)
>
>
> ---
> I explore, therefore I blog!
>
> http://www.backpackingphilippines.com
>
> http://www.facebook.com/backpackingPhilippines
> http://www.twitter.com/backpackPH
>
> On Apr 25, 2013, at 7:51 AM, Eugene Alvin Villar  wrote:
>
> I think most of you already know that the Philippines is supposed to have
> a land area of 300,000 km². This is what is stored in the United Nations:
> http://unstats.un.org/unsd/demographic/products/dyb/dyb2009-2010/Table03.pdf
>
> However, the National Statistical Coordination Board says its 343,448.32
> km²: http://www.nscb.gov.ph/view/geography.asp
>
> Confusingly, the Philippine Information Agency used to say it its website
> that the area is 299,764 km².
> http://web.archive.org/web/20090302131341/http://www.pia.gov.ph/philinfo/default.asp?fi=about&i=geography
>
> :-)
>
> ___
> 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
>
>


-- 
Rem Zamora
Photojournalist
+63-917-592-74-33
-link to my 
photos-
___
talk-ph mailing list
talk-ph@openstreetmap.org
http://lists.openstreetmap.org/listinfo/talk-ph

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

[lrazafindrazay]

Yes, the School_ID is official ID.

On Apr 24, 2013, at 12:49 AM, "Eugene Alvin Villar"  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  
> 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
>>  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 
>> > Date: Tue, Jan 10, 2012 at 4:01 PM
>> > Subject: ideas on importing deped schools db to OSM
>> > To: Rally de Leon , Eugene Alvin Villar 
>> > 
>> >
>> >
>> > 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.6129203
>> >   Y (Real) =   11.5076500
>> >   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@openstreetmap.org
>> http://lists.openstreetmap.org/listinfo/talk-ph
> 
> 
___
> 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

Re: [talk-ph] Land area of the Philippines

[tutubi]

Eugene, 

land area may vary, depends whether it was measured during high tide or low 
tide too

:)


---
I explore, therefore I blog!

http://www.backpackingphilippines.com

http://www.facebook.com/backpackingPhilippines
http://www.twitter.com/backpackPH

On Apr 25, 2013, at 7:51 AM, Eugene Alvin Villar  wrote:

> I think most of you already know that the Philippines is supposed to have a 
> land area of 300,000 km². This is what is stored in the United Nations: 
> http://unstats.un.org/unsd/demographic/products/dyb/dyb2009-2010/Table03.pdf
> 
> However, the National Statistical Coordination Board says its 343,448.32 km²: 
> http://www.nscb.gov.ph/view/geography.asp
> 
> Confusingly, the Philippine Information Agency used to say it its website 
> that the area is 299,764 km². 
> http://web.archive.org/web/20090302131341/http://www.pia.gov.ph/philinfo/default.asp?fi=about&i=geography
> 
> :-)
> ___
> 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

[talk-ph] Land area of the Philippines

[Eugene Alvin Villar]

I think most of you already know that the Philippines is supposed to have a
land area of 300,000 km². This is what is stored in the United Nations:
http://unstats.un.org/unsd/demographic/products/dyb/dyb2009-2010/Table03.pdf

However, the National Statistical Coordination Board says its 343,448.32
km²: http://www.nscb.gov.ph/view/geography.asp

Confusingly, the Philippine Information Agency used to say it its website
that the area is 299,764 km².
http://web.archive.org/web/20090302131341/http://www.pia.gov.ph/philinfo/default.asp?fi=about&i=geography

:-)
___
talk-ph mailing list
talk-ph@openstreetmap.org
http://lists.openstreetmap.org/listinfo/talk-ph

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

[Eugene Alvin Villar]

Hello,

On Wed, Apr 24, 2013 at 7:52 PM, maning sambale
wrote:

> Dear Eugene,
>
> Thank you for looking at the data.
>
> On Wed, Apr 24, 2013 at 1:49 AM, Eugene Alvin Villar 
> 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.
>

I guess the next discussion is what tags do we include? I don't think we
need to include the school region+division+district. The school_id should
be enough. If you know relational databases, then the school_id functions
as an ID to rows on another table.

Also, the brgy_code and muni_code is not needed. (But I think these match
the Philippine Standard Geographical Code?
http://www.nscb.gov.ph/activestats/psgc/ )


>  > 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?
>

Yes I think so. The ref=* tag is meant to store the reference/ID number for
objects. For elementary and high schools, it makes sense to use the
official ID assigned by DepEd for the ref=* tag.


> My proposal is:
> 1. Subset the data into smaller chunks say 500 schools for each file.
>

It might be better to divide the data also along geographical lines. For
example, by provinces and then divide the data per province into smaller
chunks like Ilocose Norte 1, Ilocos Norte 2, etc.

I think chunks of 100 is much more manageable. I certainly don't think I
can process 500 schools in 1 or 2 sittings.

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).
>

I suggest to add the upload=false XML attribute to the OSM files to avoid
accidentally uploading it to OSM.

Eugene


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.
>
> --
> cheers,
> maning
>
___
talk-ph mailing list
talk-ph@openstreetmap.org
http://lists.openstreetmap.org/listinfo/talk-ph

[talk-ph] OpenStreetBugs-like functionality is now on the main OSM website!

[Eugene Alvin Villar]

Hi guys,

Some of you may know about OpenStreetBugs:
http://openstreetbugs.schokokeks.org/?lat=14.6&lon=121.05&zoom=14

It's a 3rd-party website where people can easily submit bug reports on the
map. For example: "this building no longer exists". For mappers, it's also
a quick way of placing notes and things to do in case you don't have time
right now to do some map editing.

Many OSM developers have been hard at work in bringing OpenStreetBugs'
functionality to the OSM website and they have now put it up live! The
feature is now called Notes.

Here's an example of a note: http://www.openstreetmap.org/?note=175

You can add a note by zooming into an area then clicking the "Add a note"
link on the bottom-right corner of the map.

You can view all the notes on the map by hovering your mouse pointer over
the layer selector on the top-right corner of the map and then ticking the
"Browse Notes" checkbox.

Unfortunately (or fortunately?) all the data from OpenStreetBugs was not
(yet?) imported into the main OSM website.

Have fun adding notes!
___
talk-ph mailing list
talk-ph@openstreetmap.org
http://lists.openstreetmap.org/listinfo/talk-ph

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

[maning sambale]

Dear Eugene,

Thank you for looking at the data.

On Wed, Apr 24, 2013 at 1:49 AM, Eugene Alvin Villar  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.

--
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

[talk-ph] Fwd: [HOT] Senior Field Coordinator Open Cities Initiative in Bangladesh and Sri Lanka

[maning sambale]

HOT job and opportunity to travel to Bangladesh and Sri Lanka.


-- Forwarded message --
From: Kate Chapman 
Date: Wed, Apr 24, 2013 at 4:10 PM
Subject: [HOT] Senior Field Coordinator Open Cities Initiative in
Bangladesh and Sri Lanka
To: hot 


Hi All,

We have a new contract position for the Open Cities Initiative through
the Global Facility for Disaster Reduction and Recovery (GFDRR) at the
World Bank.

This position will travel to Bangladesh and Sri Lanka in June/July of
this year to provide workshops and technical assistance to partners
(governments/NGOs/Universities) that are part of the beginning OSM
communities in Bangladesh and Sri Lanka. That individual will then
provide technical support to those groups for the next six months
through a variety of online communication tools (mailing
lists/Skype/Facebook/etc).

For more information see the position posting here:
http://hot.openstreetmap.org/senior_field_coordinator_bangladeshsri_lanka

Best,

-Kate

___
HOT mailing list
h...@openstreetmap.org
http://lists.openstreetmap.org/listinfo/hot



--
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