6 housenumber

Lukas Martinelli edytuje tę stronę 2016-12-08 11:02:37 +00:00

Spis treści

• Fields
• housenumber
• Mapping Diagram
• ETL Diagram
• SQL

Everything in OpenStreetMap which contains a addr:housenumber tag useful for labelling housenumbers on a map. This adds significant size to z14. For buildings the centroid of the building is used as housenumber.

Fields

housenumber

Value of the addr:housenumber tag.

Mapping Diagram

ETL Diagram

SQL

SELECT geometry, housenumber FROM layer_housenumber(ST_SetSRID('BOX3D(-20037508.34 -20037508.34, 20037508.34 20037508.34)'::box3d, 3857 ), 14)