Created
August 5, 2011 23:50
-
-
Save springmeyer/1128793 to your computer and use it in GitHub Desktop.
osm.xml converted to carto using https://github.com/rundel/carto-generator
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Stylesheet": [ | |
| "style.mss" | |
| ], | |
| "Layer": [ | |
| { | |
| "id": "world", | |
| "name": "world", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "file": "/Users/dane/src/osm_mapnik3/world_boundaries//shoreline_300", | |
| "type": "shape" | |
| } | |
| }, | |
| { | |
| "id": "coast-poly", | |
| "name": "coast-poly", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "file": "/Users/dane/src/osm_mapnik3/world_boundaries//processed_p", | |
| "type": "shape" | |
| } | |
| }, | |
| { | |
| "id": "builtup", | |
| "name": "builtup", | |
| "srs": "+proj=merc +datum=WGS84 +over", | |
| "Datasource": { | |
| "file": "/Users/dane/src/osm_mapnik3/world_boundaries//builtup_area", | |
| "type": "shape" | |
| } | |
| }, | |
| { | |
| "id": "necountries", | |
| "name": "necountries", | |
| "srs": "+init=epsg:4326", | |
| "Datasource": { | |
| "file": "/Users/dane/src/osm_mapnik3/world_boundaries//110m_admin_0_boundary_lines_land.shp", | |
| "type": "shape" | |
| } | |
| }, | |
| { | |
| "id": "nepopulated", | |
| "name": "nepopulated", | |
| "srs": "+init=epsg:4326", | |
| "Datasource": { | |
| "encoding": "latin1", | |
| "file": "/Users/dane/src/osm_mapnik3/world_boundaries//10m_populated_places.shp", | |
| "type": "shape" | |
| } | |
| }, | |
| { | |
| "id": "landcover", | |
| "name": "landcover", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,aeroway,amenity,landuse,leisure,man_made,military,\"natural\",power,tourism,name,highway,\n case when religion in ('christian','jewish') then religion else 'INT-generic'::text end as religion\n from planet_osm_polygon\n where landuse is not null\n or leisure is not null\n or aeroway in ('apron','aerodrome')\n or amenity in ('parking','university','college','school','hospital','kindergarten','grave_yard')\n or military in ('barracks','danger_area')\n or \"natural\" in ('field','beach','desert','heath','mud','wood','sand','scrub')\n or power in ('station','sub_station','generator')\n or tourism in ('attraction','camp_site','caravan_site','picnic_site','zoo')\n or highway in ('services','rest_area')\n order by z_order,way_area desc\n ) as leisure\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "landcover_line", | |
| "name": "landcover_line", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way\n from planet_osm_line\n where man_made='cutline'\n ) as leisure\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "sports_grounds", | |
| "name": "sports_grounds", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,leisure,\n case when leisure='pitch' then 2\n when leisure='track' then 1\n else 0 end as prio\n from planet_osm_polygon\n where leisure in ('sports_centre','stadium','pitch','track')\n order by z_order,prio,way_area desc\n ) as sports_grounds\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "water-lines-casing", | |
| "name": "water-lines-casing", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,waterway\n from planet_osm_line\n where waterway in ('stream','drain','ditch')\n and (tunnel is null or tunnel != 'yes')\n ) as water_lines", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "water_areas", | |
| "name": "water_areas", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,\"natural\",waterway,landuse,name\n from planet_osm_polygon\n where waterway in ('dock','mill_pond','riverbank','canal')\n or landuse in ('reservoir','water','basin')\n or \"natural\" in ('lake','water','land','glacier','mud','bay')\n order by z_order,way_area desc\n ) as water_areas", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "water-areas-overlay", | |
| "name": "water-areas-overlay", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,\"natural\"\n from planet_osm_polygon\n where \"natural\" in ('marsh','wetland')\n order by z_order,way_area desc\n ) as water_areas", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "glaciers-text", | |
| "name": "glaciers-text", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,name,way_area\n from planet_osm_polygon\n where \"natural\"='glacier'\n order by way_area desc\n ) as glaciers", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "water-lines-low-zoom", | |
| "name": "water-lines-low-zoom", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,waterway\n from planet_osm_line\n where waterway='river'\n ) as water_lines", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "water_lines", | |
| "name": "water_lines", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,waterway,disused,lock,name,\n case when tunnel in ('yes','true','1') then 'yes'::text else tunnel end as tunnel\n from planet_osm_line\n where waterway in ('weir','river','canal','derelict_canal','stream','drain','ditch','wadi')\n and (bridge is null or bridge not in ('yes','true','1','aqueduct'))\n order by z_order\n ) as water_lines", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "dam", | |
| "name": "dam", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,name from planet_osm_line where waterway='dam') as dam", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "marinas-area", | |
| "name": "marinas-area", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way from planet_osm_polygon where leisure ='marina') as marinas\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "piers-area", | |
| "name": "piers-area", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,man_made from planet_osm_polygon where man_made in ('pier','breakwater','groyne')) as piers\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "piers", | |
| "name": "piers", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,man_made from planet_osm_line where man_made in ('pier','breakwater','groyne')) as piers\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "locks", | |
| "name": "locks", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,waterway from planet_osm_point where waterway='lock_gate') as locks\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "tunnels", | |
| "name": "tunnels", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,highway from planet_osm_line where highway in ('motorway','motorway_link','trunk','trunk_link','primary','primary_link','secondary','secondary_link','tertiary','tertiary_link','residential','unclassified') and tunnel in ('yes','true','1') order by z_order) as roads\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "citywalls", | |
| "name": "citywalls", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "(select way from planet_osm_line where \"historic\"='citywalls') as citywalls", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "castle_walls", | |
| "name": "castle_walls", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "(select way from planet_osm_line where \"historic\"='castle_walls') as castle_walls", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "castle_walls", | |
| "name": "castle_walls", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "(select way from planet_osm_polygon where \"historic\"='castle_walls') as castle_walls", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "landuse_overlay", | |
| "name": "landuse_overlay", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,landuse,leisure\n from planet_osm_polygon\n where landuse = 'military' or leisure='nature_reserve'\n ) as landuse_overlay\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "turning_circle-casing", | |
| "name": "turning_circle-casing", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select distinct on (p.way) p.way as way,l.highway as int_tc_type\n from planet_osm_point p\n join planet_osm_line l\n on ST_DWithin(p.way,l.way,0.1)\n join (values\n ('tertiary',1),\n ('unclassified',2),\n ('residential',3),\n ('living_street',4),\n ('service',5)\n ) as v (highway,prio)\n on v.highway=l.highway\n where p.highway='turning_circle'\n order by p.way,v.prio\n ) as turning_circle\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "footbikecycle-tunnels", | |
| "name": "footbikecycle-tunnels", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "clear-label-cache": true, | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,highway,horse,foot,bicycle from planet_osm_line where highway in ('bridleway','footway','cycleway','path') and tunnel in ('yes','true','1') order by z_order) as roads\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "tracks-tunnels", | |
| "name": "tracks-tunnels", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,tracktype from planet_osm_line where highway='track' and tunnel in ('yes','true','1')) as tracks\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "line_features", | |
| "name": "line features", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,barrier,\"natural\",man_made from planet_osm_line where barrier is not null or \"natural\" in ('hedge','cliff') or man_made='embankment') as roads\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "polygon_barriers", | |
| "name": "polygon barriers", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,barrier,\"natural\" from planet_osm_polygon where barrier is not null or \"natural\"='hedge') as barriers\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "highway-area-casing", | |
| "name": "highway-area-casing", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,highway,railway from planet_osm_polygon\n where highway in ('residential','unclassified','pedestrian','service','footway','track','path','platform')\n or railway='platform'\n order by z_order,way_area desc) as roads\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "minor-roads-casing", | |
| "name": "minor-roads-casing", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,highway,\n case when tunnel in ('yes','true','1') then 'yes'::text else tunnel end as tunnel,\n case when service in ('parking_aisle','drive-through','driveway') then 'INT-minor'::text else service end as service\n from planet_osm_line\n where highway in ('motorway','motorway_link','trunk','trunk_link','primary','primary_link','secondary','secondary_link','tertiary','tertiary_link','residential','unclassified','road','service','pedestrian','raceway','living_street')\n order by z_order) as roads\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "highway-area-fill", | |
| "name": "highway-area-fill", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,highway,railway,aeroway from planet_osm_polygon\n where highway in ('residential','unclassified','pedestrian','service','footway','living_street','track','path','platform','services')\n or railway='platform'\n or aeroway in ('runway','taxiway','helipad')\n order by z_order,way_area desc) as roads\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "buildings-lz", | |
| "name": "buildings-lz", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,building,railway,amenity from planet_osm_polygon\n where railway='station'\n or building in ('station','supermarket')\n or amenity='place_of_worship'\n order by z_order,way_area desc) as buildings\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "buildings", | |
| "name": "buildings", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,aeroway,\n case\n when building in ('residential','house','garage','garages','detached','terrace','apartments') then 'INT-light'::text\n else building\n end as building\n from planet_osm_polygon\n where (building is not null\n and building not in ('no','station','supermarket')\n and (railway is null or railway != 'station')\n and (amenity is null or amenity != 'place_of_worship'))\n or aeroway = 'terminal'\n order by z_order,way_area desc) as buildings\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "turning_circle-fill", | |
| "name": "turning_circle-fill", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select distinct on (p.way) p.way as way,l.highway as int_tc_type\n from planet_osm_point p\n join planet_osm_line l\n on ST_DWithin(p.way,l.way,0.1)\n join (values\n ('tertiary',1),\n ('unclassified',2),\n ('residential',3),\n ('living_street',4),\n ('service',5)\n ) as v (highway,prio)\n on v.highway=l.highway\n where p.highway='turning_circle'\n order by p.way,v.prio\n ) as turning_circle\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "tracks-notunnel-nobridge", | |
| "name": "tracks-notunnel-nobridge", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,tracktype from planet_osm_line where highway='track' and (bridge is null or bridge in ('no','false','0')) and (tunnel is null or tunnel in ('no','false','0'))) as tracks\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "minor-roads-fill", | |
| "name": "minor-roads-fill", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,highway,horse,bicycle,foot,construction,aeroway,\n case when tunnel in ('yes','true','1') then 'yes'::text else tunnel end as tunnel,\n case when bridge in ('yes','true','1','viaduct') then 'yes'::text else bridge end as bridge,\n case when railway in ('spur','siding')\n or (railway='rail' and service in ('spur','siding','yard'))\n then 'spur-siding-yard'::text else railway end as railway,\n case when service in ('parking_aisle','drive-through','driveway') then 'INT-minor'::text else service end as service\n from planet_osm_line\n where highway is not null\n or aeroway in ('runway','taxiway')\n or railway in ('light_rail','narrow_gauge','funicular','rail','subway','tram','spur','siding','platform','disused','abandoned','construction','miniature')\n order by z_order) as roads\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "ferry-routes", | |
| "name": "ferry-routes", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way from planet_osm_line where route='ferry' ) as routes\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "aerialways", | |
| "name": "aerialways", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,aerialway from planet_osm_line where aerialway is not null) as aerialways\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "roads", | |
| "name": "roads", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,highway,\n case when tunnel in ('yes','true','1') then 'yes'::text else tunnel end as tunnel,\n case when railway='preserved' and service in ('spur','siding','yard') then 'INT-preserved-ssy'::text else railway end as railway\n from planet_osm_roads\n where highway is not null\n or (railway is not null and railway!='preserved' and (service is null or service not in ('spur','siding','yard')))\n or railway='preserved'\n order by z_order\n ) as roads\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "waterway-bridges", | |
| "name": "waterway-bridges", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "(select way,name from planet_osm_line where waterway='canal' and bridge in ('yes','true','1','aqueduct') order by z_order) as water", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "access-pre_bridges", | |
| "name": "access-pre_bridges", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,access,highway,\n case when service in ('parking_aisle','drive-through','driveway') then 'INT-minor'::text end as service\n from planet_osm_line\n where access is not null and highway is not null\n and (bridge is null or bridge not in ('yes','true','1','viaduct'))\n ) as access\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "direction_pre_bridges", | |
| "name": "direction_pre_bridges", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,\n case when oneway in ('yes','true','1') then 'yes'::text else oneway end as oneway\n from planet_osm_line\n where oneway is not null\n and (highway is not null or railway is not null or waterway is not null)\n and (bridge is null or bridge not in ('yes','true','1','viaduct'))\n ) as directions\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "bridges_layer0", | |
| "name": "bridges_layer0", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,highway,aeroway,horse,bicycle,foot,tracktype,\n case when railway in ('spur','siding')\n or (railway='rail' and service in ('spur','siding','yard'))\n then 'INT-spur-siding-yard'::text else railway end as railway\n from planet_osm_line\n where (highway is not null\n or aeroway in ('runway','taxiway')\n or railway in ('light_rail','subway','narrow_gauge','rail','spur','siding','disused','abandoned','construction'))\n and bridge in ('yes','true','1','viaduct')\n and (layer is null or layer = '0')\n order by z_order\n ) as roads\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "bridges_access0", | |
| "name": "bridges_access0", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,access,highway,\n case when service in ('parking_aisle','drive-through','driveway') then 'INT-minor'::text end as service\n from planet_osm_line\n where access is not null and highway is not null\n and bridge in ('yes','true','1','viaduct')\n and (layer is null or layer in ('-5','-4','-3','-2','-1','0'))\n ) as access\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "bridges_directions0", | |
| "name": "bridges_directions0", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,\n case when oneway in ('yes','true','1') then 'yes'::text else oneway end as oneway\n from planet_osm_line\n where oneway is not null\n and (highway is not null or railway is not null or waterway is not null)\n and bridge in ('yes','true','1','viaduct')\n and (layer is null or layer in ('-5','-4','-3','-2','-1','0'))\n ) as directions\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "bridges_layer1", | |
| "name": "bridges_layer1", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,highway,aeroway,horse,bicycle,foot,tracktype,\n case when railway in ('spur','siding')\n or (railway='rail' and service in ('spur','siding','yard'))\n then 'INT-spur-siding-yard'::text else railway end as railway\n from planet_osm_line\n where (highway is not null\n or aeroway in ('runway','taxiway')\n or railway in ('light_rail','subway','narrow_gauge','rail','spur','siding','disused','abandoned','construction'))\n and bridge in ('yes','true','1','viaduct')\n and layer = '1'\n order by z_order\n ) as roads\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "bridges_access1", | |
| "name": "bridges_access1", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,access,highway,\n case when service in ('parking_aisle','drive-through','driveway') then 'INT-minor'::text end as service\n from planet_osm_line\n where access is not null and highway is not null\n and bridge in ('yes','true','1','viaduct')\n and layer = '1'\n ) as access\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "bridges_directions1", | |
| "name": "bridges_directions1", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,\n case when oneway in ('yes','true','1') then 'yes'::text else oneway end as oneway\n from planet_osm_line\n where oneway is not null\n and (highway is not null or railway is not null or waterway is not null)\n and bridge in ('yes','true','1','viaduct')\n and layer = '1'\n ) as directions\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "bridges_layer2", | |
| "name": "bridges_layer2", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,highway,aeroway,horse,bicycle,foot,tracktype,\n case when railway in ('spur','siding')\n or (railway='rail' and service in ('spur','siding','yard'))\n then 'INT-spur-siding-yard'::text else railway end as railway\n from planet_osm_line\n where (highway is not null\n or aeroway in ('runway','taxiway')\n or railway in ('light_rail','subway','narrow_gauge','rail','spur','siding','disused','abandoned','construction'))\n and bridge in ('yes','true','1','viaduct')\n and layer = '2'\n order by z_order\n ) as roads\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "bridges_access2", | |
| "name": "bridges_access2", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,access,highway,\n case when service in ('parking_aisle','drive-through','driveway') then 'INT-minor'::text end as service\n from planet_osm_line\n where access is not null and highway is not null\n and bridge in ('yes','true','1','viaduct')\n and layer = '2'\n ) as access\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "bridges_directions2", | |
| "name": "bridges_directions2", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,\n case when oneway in ('yes','true','1') then 'yes'::text else oneway end as oneway\n from planet_osm_line\n where oneway is not null\n and (highway is not null or railway is not null or waterway is not null)\n and bridge in ('yes','true','1','viaduct')\n and layer = '2'\n ) as directions\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "bridges_layer3", | |
| "name": "bridges_layer3", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,highway,aeroway,horse,bicycle,foot,tracktype,\n case when railway in ('spur','siding')\n or (railway='rail' and service in ('spur','siding','yard'))\n then 'INT-spur-siding-yard'::text else railway end as railway\n from planet_osm_line\n where (highway is not null\n or aeroway in ('runway','taxiway')\n or railway in ('light_rail','subway','narrow_gauge','rail','spur','siding','disused','abandoned','construction'))\n and bridge in ('yes','true','1','viaduct')\n and layer = '3'\n order by z_order\n ) as roads\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "bridges_access3", | |
| "name": "bridges_access3", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,access,highway,\n case when service in ('parking_aisle','drive-through','driveway') then 'INT-minor'::text end as service\n from planet_osm_line\n where access is not null and highway is not null\n and bridge in ('yes','true','1','viaduct')\n and layer = '3'\n ) as access\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "bridges_directions3", | |
| "name": "bridges_directions3", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,\n case when oneway in ('yes','true','1') then 'yes'::text else oneway end as oneway\n from planet_osm_line\n where oneway is not null\n and (highway is not null or railway is not null or waterway is not null)\n and bridge in ('yes','true','1','viaduct')\n and layer = '3'\n ) as directions\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "bridges_layer4", | |
| "name": "bridges_layer4", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,highway,aeroway,horse,bicycle,foot,tracktype,\n case when railway in ('spur','siding')\n or (railway='rail' and service in ('spur','siding','yard'))\n then 'INT-spur-siding-yard'::text else railway end as railway\n from planet_osm_line\n where (highway is not null\n or aeroway in ('runway','taxiway')\n or railway in ('light_rail','subway','narrow_gauge','rail','spur','siding','disused','abandoned','construction'))\n and bridge in ('yes','true','1','viaduct')\n and layer = '4'\n order by z_order\n ) as roads\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "bridges_access4", | |
| "name": "bridges_access4", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,access,highway,\n case when service in ('parking_aisle','drive-through','driveway') then 'INT-minor'::text end as service\n from planet_osm_line\n where access is not null and highway is not null\n and bridge in ('yes','true','1','viaduct')\n and layer = '4'\n ) as access\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "bridges_directions4", | |
| "name": "bridges_directions4", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,\n case when oneway in ('yes','true','1') then 'yes'::text else oneway end as oneway\n from planet_osm_line\n where oneway is not null\n and (highway is not null or railway is not null or waterway is not null)\n and bridge in ('yes','true','1','viaduct')\n and layer = '4'\n ) as directions\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "bridges_layer5", | |
| "name": "bridges_layer5", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,highway,aeroway,horse,bicycle,foot,tracktype,\n case when railway in ('spur','siding')\n or (railway='rail' and service in ('spur','siding','yard'))\n then 'INT-spur-siding-yard'::text else railway end as railway\n from planet_osm_line\n where (highway is not null\n or aeroway in ('runway','taxiway')\n or railway in ('light_rail','subway','narrow_gauge','rail','spur','siding','disused','abandoned','construction'))\n and bridge in ('yes','true','1','viaduct')\n and layer = '5'\n order by z_order\n ) as roads\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "bridges_access5", | |
| "name": "bridges_access5", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,access,highway,\n case when service in ('parking_aisle','drive-through','driveway') then 'INT-minor'::text end as service\n from planet_osm_line\n where access is not null and highway is not null\n and bridge in ('yes','true','1','viaduct')\n and layer = '5'\n ) as access\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "bridges_directions5", | |
| "name": "bridges_directions5", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,\n case when oneway in ('yes','true','1') then 'yes'::text else oneway end as oneway\n from planet_osm_line\n where oneway is not null\n and (highway is not null or railway is not null or waterway is not null)\n and bridge in ('yes','true','1','viaduct')\n and layer = '5'\n ) as directions\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "trams", | |
| "name": "trams", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,railway,bridge from planet_osm_line where railway='tram' and (tunnel is null or tunnel not in ('yes','true','1'))) as trams\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "guideways", | |
| "name": "guideways", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way from planet_osm_line where highway='bus_guideway' and (tunnel is null or tunnel not in ('yes','true','1'))) as guideways\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "admin-01234", | |
| "name": "admin-01234", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,admin_level\n from planet_osm_roads\n where \"boundary\"='administrative'\n and admin_level in ('0','1','2','3','4')\n ) as admin", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "admin-5678", | |
| "name": "admin-5678", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,admin_level\n from planet_osm_roads\n where \"boundary\"='administrative'\n and admin_level in ('5','6','7','8')\n ) as admin", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "admin-other", | |
| "name": "admin-other", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,admin_level\n from planet_osm_roads\n where \"boundary\"='administrative'\n and (admin_level is null or admin_level not in ('0','1','2','3','4','5','6','7','8'))\n ) as admin", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "placenames-large", | |
| "name": "placenames-large", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,place,name,ref\n from planet_osm_point\n where place in ('country','state')\n ) as placenames", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "placenames-capital", | |
| "name": "placenames-capital", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,place,name,ref\n from planet_osm_point\n where place in ('city','metropolis','town') and capital='yes'\n ) as placenames", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "placenames-medium", | |
| "name": "placenames-medium", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,place,name\n from planet_osm_point\n where place in ('city','metropolis','town','large_town','small_town')\n and (capital is null or capital != 'yes')\n ) as placenames", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "placenames-small", | |
| "name": "placenames-small", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,place,name\n from planet_osm_point\n where place in ('suburb','village','large_village','hamlet','locality','isolated_dwelling','farm')\n ) as placenames", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "amenity-stations", | |
| "name": "amenity-stations", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,name,railway,aerialway,disused\n from planet_osm_point\n where railway in ('station','halt','tram_stop','subway_entrance')\n or aerialway='station'\n ) as stations\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "amenity-stations-poly", | |
| "name": "amenity-stations-poly", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,name,railway,aerialway,disused\n from planet_osm_polygon\n where railway in ('station','halt','tram_stop')\n or aerialway='station'\n ) as stations\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "amenity-symbols", | |
| "name": "amenity-symbols", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select *\n from planet_osm_point\n where aeroway in ('airport','aerodrome','helipad')\n or barrier in ('bollard','gate','lift_gate','block')\n or highway in ('mini_roundabout','gate')\n or man_made in ('lighthouse','power_wind','windmill','mast')\n or (power='generator' and power_source='wind')\n or \"natural\" in ('peak','volcano','spring','tree','cave_entrance')\n or railway='level_crossing'\n ) as symbols", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "amenity-symbols-poly", | |
| "name": "amenity-symbols-poly", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select *\n from planet_osm_polygon\n where aeroway in ('airport','aerodrome','helipad')\n or barrier in ('bollard','gate','lift_gate','block')\n or highway in ('mini_roundabout','gate')\n or man_made in ('lighthouse','power_wind','windmill','mast')\n or (power='generator' and power_source='wind')\n or \"natural\" in ('peak','volcano','spring','tree')\n or railway='level_crossing'\n ) as symbols", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "amenity-points", | |
| "name": "amenity-points", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,amenity,shop,tourism,highway,man_made,access,religion,waterway,lock,historic,leisure\n from planet_osm_point\n where amenity is not null\n or shop is not null\n or tourism in ('alpine_hut','camp_site','caravan_site','guest_house','hostel','hotel','motel','museum','viewpoint','bed_and_breakfast','information','chalet')\n or highway in ('bus_stop','traffic_signals','ford')\n or man_made in ('mast','water_tower')\n or historic in ('memorial','archaeological_site')\n or waterway='lock'\n or lock='yes'\n or leisure in ('playground','slipway')\n ) as points", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "amenity-points-poly", | |
| "name": "amenity-points-poly", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,amenity,shop,tourism,highway,man_made,access,religion,waterway,lock,historic,leisure\n from planet_osm_polygon\n where amenity is not null\n or shop is not null\n or tourism in ('alpine_hut','camp_site','caravan_site','guest_house','hostel','hotel','motel','museum','viewpoint','bed_and_breakfast','information','chalet')\n or highway in ('bus_stop','traffic_signals')\n or man_made in ('mast','water_tower')\n or historic in ('memorial','archaeological_site')\n or leisure='playground'\n ) as points", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "power_line", | |
| "name": "power_line", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "(select way from planet_osm_line where \"power\"='line') as power_line", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "power_minorline", | |
| "name": "power_minorline", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "(select way from planet_osm_line where \"power\"='minor_line') as power_minorline", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "power_towers", | |
| "name": "power_towers", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "(select way from planet_osm_point where power='tower') as power_towers", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "power_poles", | |
| "name": "power_poles", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "(select way from planet_osm_point where power='pole') as power_poles", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "planet_roads_text_osm_low_zoom", | |
| "name": "planet roads text osm low zoom", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,highway,ref,char_length(ref) as length\n from planet_osm_roads\n where highway in ('motorway','trunk','primary')\n and ref is not null\n ) as roads\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "highway-junctions", | |
| "name": "highway-junctions", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,ref,name\n from planet_osm_point\n where highway='motorway_junction'\n ) as junctions\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "planet_roads_text_osm", | |
| "name": "planet roads text osm", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,highway,aeroway,name,ref,char_length(ref) as length,\n case when bridge in ('yes','true','1') then 'yes'::text else bridge end as bridge\n from planet_osm_line\n where waterway IS NULL\n and leisure IS NULL\n and landuse IS NULL\n and (name is not null or ((highway is not null or aeroway is not null) and ref is not null))\n ) as roads\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "text", | |
| "name": "text", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,amenity,shop,access,leisure,landuse,man_made,\"natural\",place,tourism,ele,name,ref,military,aeroway,waterway,historic,'yes'::text as point\n from planet_osm_point\n where amenity is not null\n or shop in ('supermarket','bakery','clothes','fashion','convenience','doityourself','hairdresser','department_store','butcher','car','car_repair','bicycle','florist')\n or leisure is not null\n or landuse is not null\n or tourism is not null\n or \"natural\" is not null\n or man_made in ('lighthouse','windmill')\n or place='island'\n or military='danger_area'\n or aeroway='gate'\n or waterway='lock'\n or historic in ('memorial','archaeological_site')\n ) as text\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "text-poly", | |
| "name": "text-poly", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,aeroway,shop,access,amenity,leisure,landuse,man_made,\"natural\",place,tourism,NULL as ele,name,ref,military,waterway,historic,'no'::text as point\n from planet_osm_polygon\n where amenity is not null\n or shop in ('supermarket','bakery','clothes','fashion','convenience','doityourself','hairdresser','department_store', 'butcher','car','car_repair','bicycle')\n or leisure is not null\n or landuse is not null\n or tourism is not null\n or \"natural\" is not null\n or man_made in ('lighthouse','windmill')\n or place='island'\n or military='danger_area'\n or historic in ('memorial','archaeological_site')\n ) as text\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "area-text", | |
| "name": "area-text", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,way_area,name\n from planet_osm_polygon\n where name is not null\n and (waterway is null or waterway != 'riverbank')\n order by z_order,way_area desc\n ) as text\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "interpolation_lines", | |
| "name": "interpolation_lines", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way from planet_osm_line where \"addr:interpolation\" is not null) as interpolation\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "housenumbers", | |
| "name": "housenumbers", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,\"addr:housenumber\" from planet_osm_polygon where \"addr:housenumber\" is not null and building is not null\n union\n select way,\"addr:housenumber\" from planet_osm_point where \"addr:housenumber\" is not null\n ) as housenumbers\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "housenames", | |
| "name": "housenames", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,\"addr:housename\" from planet_osm_polygon where \"addr:housename\" is not null and building is not null\n union\n select way,\"addr:housename\" from planet_osm_point where \"addr:housename\" is not null\n ) as housenames\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "misc_boundaries", | |
| "name": "misc_boundaries", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,way_area,name,boundary from planet_osm_polygon where boundary='national_park') as boundary\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| }, | |
| { | |
| "id": "theme_park", | |
| "name": "theme_park", | |
| "srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over", | |
| "Datasource": { | |
| "dbname": "osm_belgium", | |
| "estimate_extent": "false", | |
| "extent": "-20037508,-19929239,20037508,19929239", | |
| "host": "", | |
| "password": "", | |
| "port": "", | |
| "table": "\n (select way,name,tourism from planet_osm_polygon where tourism='theme_park') as theme_park\n ", | |
| "type": "postgis", | |
| "user": "postgres" | |
| } | |
| } | |
| ] | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment