[Talk-ca] GeoBase PostGIS & OpenStreetMap

[Sam Vekemans]

1st a little wiki (so others can try to understand) :)
http://en.wikipedia.org/wiki/PostGIS
As i saw that on GeoBase that its part of the Open Geospatial
Consortium<http://en.wikipedia.org/wiki/Open_Geospatial_Consortium>

... something that the folks on the OSGeo discussion list talk about (that
im still trying to wrap my head around) -- fortunately they saw my email,
and posted the announcement on their site, so people in that community are
aware.  We just have to ask the right questions. :)

.. Anyway, a google search and this came up. Talking about how to make
postGIS Database. (perhaps the one who posted this article can help?)
http://oegeo.wordpress.com/2008/03/07/turning-openstreetmap-into-a-wfs/

and here is the OpenStreetMap perspective of PostGIS
http://wiki.openstreetmap.org/wiki/PostGIS

I do know that in the UK they have their street numbering system all set up,
so perhaps there is someone that can assist further? (i would call out, but
i don't know how to ask :@)

And as far as including / excluding areas. .. remember that it might
be possible to make boxes even smaller. .. but your right, this doesn't help
for street numbering.
And using a layer for tracing wont help either.

So from your idea i got:
1. Merging the OSM reference id# database (our big Canada file) with the
GeoBase dataset onto a separate PostGIS database.
2. Purging the results of close lines/nodes. (street names maybe?) ...
creating a GeoBase/OSM database. Where it just looks for that, and removes
the extra OSM stuff that it doesnt need.
3. Then importing it back to OSM.  .. purging it with the original OSM Id's.
Am i following that right?

Cheers,
Sam
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/talk-ca/attachments/20081205/fc8cc3b3/attachment.html>