* Michal Migurski <m...@stamen.com> [2011-09-07 09:13 -0700]: > This kind of thing [joining roads with similar names] really needs to be > applied all-at-once to a large dataset, because it can really mess with > tile boundaries when done at render-time.
I'd be interested in any view-based solutions people have come up for merging road names. I've tried three different approaches that all fall short one way or another. I can generate an auxilary table with the merged geometries, but that won't be updated by the minutely updates. I've tried setting up recursive queries to spider their way along the extents of connected identically-named roads, but that gets really slow and I never got it working quite right. What I've settled on is running an ST_Collect() across all the ways in the current metatile's bbox, but that, as you note, makes for a lot of artifacts at tile boundaries. -- ...computer contrarian of the first order... / http://aperiodic.net/phil/ PGP: 026A27F2 print: D200 5BDB FC4B B24A 9248 9F7A 4322 2D22 026A 27F2 --- -- Sometimes I wonder if cows are really free. -- Bucky Menchaca ---- --- -- _______________________________________________ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk