[OSM-talk] TIGER 101

[Ben Gimpert]

On Thu, 30 Nov 06 @06:36pm, raphael Jacquot wrote:
> Andy Robinson wrote:
> >>>data I don't see node displacement at junctions exceeding 1 metre (in
> >>fact
> >>>significantly smaller if not the same lat and lon) so I'm guessing that
> >>many
> >>>of the street junctions do have the same lat/lon or at least very close
> >>to
> >>>it. Its very unlikely that there is a problem combining points that are
> >>>within that sort of radius anyway.
> >>>
> >>>Cheers
> >>>
> >>>Andy
> >>>
> >>>Andy Robinson
> >>>Andy_J_Robinson at blueyonder.co.uk
> >>I'll be trying to do something about this this week end...
> >
> >You thinking of doing it pre or post import to the db?
> >
> >Cheers
> >
> >Andy
> 
> I was thinking of importing the whole thing in a big ass postgis db 
> before shipping everything to the osm db

That would be good -- best of luck!  (Seriously, I mean it.)

Every time you encounter a TIGER lat/long point, you'll need to do a
search across the lat/long of already-imported nodes within, say, a 1000
miles.  (Beware of very long, straight rural roads.)  If you find a node
with the same lat/long -- where "same" is some function incoporating the
rural-ness of the area -- then you can reuse that node.

It sounds do-able, but at this point I am most definitely bowing out.

		Cheers,
		Ben