I've spent some time this morning getting the aussie highway shields to render again, this time it doesn't need/care about addr:* tags it uses the Australian country boundary to figure this out.
Also MABC routes don't need a network=* tag, it gets copied from the ref=* tag if needed. select way,case when network is not null then network else substring(ref, 1) end as network,ref,char_length(ref) as length from planet_osm_line where route='road' and ref is not null and st_within(way, (select way from planet_osm_polygon where name='Australia' and boundary='administrative' and admin_level='2')) I'm still looking at the name stuff, as that doesn't seem to be rendering still. _______________________________________________ Talk-au mailing list [email protected] http://lists.openstreetmap.org/listinfo/talk-au

