search

OSMBrasil / Geolog-PMSP

1 stars 2 forks source link

Generate addresses ranges parallels #6

Open vgeorge opened 9 years ago

vgeorge commented 9 years ago

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 commented 9 years ago

What are parallels?

vgeorge commented 9 years ago

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 commented 9 years ago

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 commented 9 years ago

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