Generate addresses ranges parallels

[vgeorge]

After importing into PostGIS, I was able to generate parallels for segments using this query:

select ST_OffsetCurve((ST_LineMerge(geom)),0.00004, 'quad_segs=4 join=round') as geom into paralela from geolog limit 1;

It is posible to trim the ways by using ST_LineSubstring. We need to know how to translate 5 meters to fractions of segment length.

It's a start, but I think we can use PostGIS to generate all parallels we need.

[alexandre-mbm]

What are parallels?

[vgeorge]

We are going to use address interpolation to import the data:

http://wiki.openstreetmap.org/wiki/Addresses#Using_interpolation

We will have the interpolation ways by generating parrallels of street segments provided at the shapefile.

[willemarcel]

I changed the projection parameters in the wiki https://wiki.openstreetmap.org/wiki/Geolog_PMSP_Import#The_data

In some areas the geolog data is a bit similar to OSM, in others there is some meters of difference. We will have a lot of work to fix the data, but I think that our work will be easier with the parallels.

[willemarcel]

In the postgis SQL query I think the arguments 'quad_segs=4 join=round' are not needed.