[OSM-talk] House Numbers

Frederik Ramm frederik at remote.org
Mon Jan 7 15:01:10 GMT 2013


Hi,

On 01/07/2013 02:48 PM, Christian Quest wrote:
> Regarding housenumbers, I'm trying to render them with only the ones
> around street corners at some zoom level.

You could try to make a layer that returns the house number plus the 
count of highway=residential ways within n metres of the house number 
(e.g. count(*) from planet_osm_line other where 
st_dwithin(this.way,that.way,n)).

That would of course not be perfect...

I'd also be interested in trying to align house numbers to the matching 
street so that they have an equal distance and the same angle as the 
street. Also a difficult problem.

Bye
Frederik

-- 
Frederik Ramm  ##  eMail frederik at remote.org  ##  N49°00'09" E008°23'33"



More information about the talk mailing list