[Talk-ca] call for help, importing roads

Adam Dunn dunnadam at gmail.com
Wed Mar 17 21:47:09 GMT 2010

Hi, I was kind of hoping someone more knowledgeable in GIS programming
would've responded first for the following reasons: geobase2osm.py is an
integral part of the whole roadmatching process for Canada, and it's a very
Canadian-specific script (there are chunks of code that deal with naming of
major trunks on a province-by-province basis using if-else programming).

Also, I don't have much experience programming GIS stuff. For example, the
Canadian way of doing this uses EPSG 3348 for projection [1]. I did some
Google searching, and it looks like you would want to use EPSG 4191 for the
Albania area (see [2]), but 2462 might also the one you want to use ([3],
although it looks like you get weird projected bounds with it). I don't know
why this reprojection is really even necessary. When you look at EPSG 3348
(the Canadian one), the projected bounds are really weird there as well, so
maybe it has to be done just to match up with NRN. If the Albania dataset is
already in Lat/Long and 4191 is in Lat/Long and OSM is in Lat/Long, maybe
you don't need to reproject at all? Someone with more GIS knowledge should

You'll also want a script to automatically convert various attributes in the
shp file to tags that are used by OSM. For example, I opened up the
Roads_OSM.shp file in OpenJUMP (just the way it is, no changes or
reprojections or anything), and I see that one road has the following
ID: 175879.0
Type: Well-Kept Gravel Road
Category: 2
Cat2: 20
Shape_Leng: 0.0
Shape_Le_1: 774.851
ET_ID: 167693

Most of these you probably won't care about, but Type: Well-Kept Gravel Road
should be converted to
and highway=unclassified or residential or track=* depending on what the
Category: 2 and Cat2: 20 mean.

Another road has Type: Dwelling Area Road, which would probably be

I've also seen Type: Village Road, Type: Railway, Type: Seasonal Road, and
Type: National Asphalted Road.

You can see where geobase2osm.py makes similar mappings for Canada, by
looking at lines 63 to 77 in geobase2osm.py [4].

None of the roads I sampled had names associated with them (even the
national highway, the name was blank). You'll probably have to match up road
names to the roads using one of the other data sets?

I would like to help out more, but I'm afraid I don't have the experience. I
could lend a hand in modifying the SQL tables and geobase2osm.py, but I
would be of limited help there, and I haven't a clue how you would get road
names imported. You'll want more expertise help in getting the proper

[1] http://spatialreference.org/ref/epsg/3348/
[2] http://spatialreference.org/ref/epsg/4191/
[3] http://spatialreference.org/ref/epsg/2462/


On Wed, Mar 17, 2010 at 12:31 PM, Sam Vekemans <acrosscanadatrails at gmail.com
> wrote:

> Hi Adam,
> James is looking to use RoadMatcher, i know its on the wiki, but that
> page needs to be fixed.
> Would you be able to explain it?
> Personally, i now favour tracing WMS, but for massive areas
> RoadMatcher is the way to go :-)
> Also, Robert (Bob) Shand from PEI is currently Itching to also learn
> how its done.
> Cheers,
> Sam
> ---------- Forwarded message ----------
> From: Michael Barabanov <michael.barabanov at gmail.com>
> Date: Wed, 17 Mar 2010 12:13:39 -0700
> Subject: Re: [Talk-ca] call for help, importing roads
> To: "jamesmikedupont at googlemail.com" <jamesmikedupont at googlemail.com>
> Cc: talk-ca at openstreetmap.org
> Sounds like you just need to convert SHP to OSM. Then you can upload from
> JOSM. There's a script here (though I haven't tried it):
> http://redmine.yellowbkpk.com/projects/list_files/geo
> On Mon, Mar 15, 2010 at 12:48 PM, jamesmikedupont at googlemail.com <
> jamesmikedupont at googlemail.com> wrote:
> > Hi,
> > I have been talking to Sam V. who mentioned that you guys are experts in
> > openjump for road importing.
> > before I dig too deep into this myself, let me ask if anyone can help me
> > with my current problem:
> >
> > I have these files from a public domain source, projected into Lat/Lon
> >
> > http://xhema.flossk.org:8080/mapdata/03/MapAction/tpginc/
> >
> > [image: [ ]] LL_Roads_OSM.dbf<
> http://xhema.flossk.org:8080/mapdata/03/MapAction/tpginc/LL_Roads_OSM.dbf
> >05-Mar-2010
> > 07:48 53M  [image: [ ]]LL_Roads_OSM.prj<
> http://xhema.flossk.org:8080/mapdata/03/MapAction/tpginc/LL_Roads_OSM.prj>05-Mar-2010
> 07:48 143
> >   [image: [ ]]LL_Roads_OSM.shp<
> http://xhema.flossk.org:8080/mapdata/03/MapAction/tpginc/LL_Roads_OSM.shp>05-Mar-2010
> 07:48
> > 35M  [image: [ ]]LL_Roads_OSM.shx<
> http://xhema.flossk.org:8080/mapdata/03/MapAction/tpginc/LL_Roads_OSM.shx>05-Mar-2010
> 07:48
> > 1.5M
> > They are from http://tpginc.net/gis/albania/albania.php
> >
> > we would like to find the new roads that are not in OSM and import them.
> > Can anyone help? can you tell me exactly what software to install, I am a
> > bit confused my the many pages and broken links I found for jump.
> >
> > thanks,
> > mike
> >
> > _______________________________________________
> > Talk-ca mailing list
> > Talk-ca at openstreetmap.org
> > http://lists.openstreetmap.org/listinfo/talk-ca
> >
> >
> --
> Twitter: @Acrosscanada
> Blog:  http://Acrosscanadatrails.blogspot.com
> Facebook: http://www.facebook.com/sam.vekemans
> Skype: samvekemans
> OpenStreetMap IRC: http://irc.openstreetmap.org
> @Acrosscanadatrails
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/talk-ca/attachments/20100317/bb3818ef/attachment.html>

More information about the Talk-ca mailing list