Skip to content
Permalink
master
Switch branches/tags

Name already in use

A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Are you sure you want to create this branch?

osm-bright/osm-bright/osm-bright.osm2pgsql.mml

Go to file
 
 
Cannot retrieve contributors at this time
587 lines (587 sloc) 27.8 KB
Raw Blame
Open in GitHub Desktop
{
"Layer": [
{
"Datasource": {
"dbname": "osm",
"extent": "-20037508.34 -20037508.34 20037508.34 20037508.34",
"file": "http://data.openstreetmapdata.com/simplified-land-polygons-complete-3857.zip",
"srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over",
"type": "shape"
},
"class": "shp",
"geometry": "polygon",
"id": "land-low",
"name": "land-low",
"srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over",
"srs-name": "900913",
"status": "on"
},
{
"Datasource": {
"file": "http://data.openstreetmapdata.com/land-polygons-split-3857.zip",
"type": "shape"
},
"class": "shp",
"geometry": "polygon",
"id": "land-high",
"name": "land-high",
"srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over",
"srs-name": "900913",
"status": "on"
},
{
"Datasource": {
"dbname": "osm",
"extent": "-20037508.34 -20037508.34 20037508.34 20037508.34",
"geometry_field": "way",
"id": "landuse_gen0",
"key_field": "",
"project": "osm-bright-imposm",
"srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over",
"table": "( SELECT way, way_area AS area, COALESCE(landuse, leisure, \"natural\", highway, amenity, tourism) AS type\n FROM planet_osm_polygon\n WHERE way_area > 100000\n ORDER BY way_area DESC\n) AS data",
"type": "postgis"
},
"class": "",
"geometry": "multipolygon",
"id": "landuse_gen0",
"name": "landuse_gen0",
"srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over",
"srs-name": "900913",
"status": "on"
},
{
"Datasource": {
"dbname": "osm",
"extent": "-20037508.34 -20037508.34 20037508.34 20037508.34",
"geometry_field": "way",
"id": "landuse_gen1",
"key_field": "",
"project": "osm-bright-imposm",
"srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over",
"table": "( SELECT way, way_area AS area, COALESCE(landuse, leisure, \"natural\", highway, amenity, tourism) AS type\n FROM planet_osm_polygon\n WHERE way_area > 10000\n ORDER BY way_area DESC\n) AS data",
"type": "postgis"
},
"class": "",
"geometry": "multipolygon",
"id": "landuse_gen1",
"name": "landuse_gen1",
"srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over",
"srs-name": "900913",
"status": "on"
},
{
"Datasource": {
"dbname": "osm",
"extent": "-20037508.34 -20037508.34 20037508.34 20037508.34",
"geometry_field": "way",
"id": "landuse",
"key_field": "",
"project": "osm-bright-imposm",
"srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over",
"table": "( SELECT way, way_area AS area, COALESCE(landuse, leisure, \"natural\", highway, amenity, tourism) AS type\n FROM planet_osm_polygon\n ORDER BY way_area DESC\n) AS data",
"type": "postgis"
},
"class": "",
"geometry": "polygon",
"id": "landuse",
"name": "landuse",
"srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over",
"srs-name": "900913",
"status": "on"
},
{
"Datasource": {
"dbname": "osm",
"extent": "-20037508.34 -20037508.34 20037508.34 20037508.34",
"geometry_field": "way",
"id": "waterway",
"key_field": "",
"project": "foss4g-2011",
"srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over",
"table": "( SELECT way, waterway AS type\n FROM planet_osm_line\n WHERE waterway IN ('river', 'canal')\n) AS data",
"type": "postgis"
},
"class": "",
"geometry": "linestring",
"id": "waterway_low",
"name": "waterway_low",
"srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over",
"srs-name": "900913",
"status": "on"
},
{
"Datasource": {
"dbname": "osm",
"extent": "-20037508.34 -20037508.34 20037508.34 20037508.34",
"geometry_field": "way",
"key_field": "",
"table": "( SELECT way, waterway AS type\n FROM planet_osm_line\n WHERE waterway IN ('river', 'canal', 'stream')\n) AS data",
"type": "postgis"
},
"class": "",
"geometry": "linestring",
"id": "waterway_med",
"name": "waterway_med",
"srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over",
"srs-name": "900913"
},
{
"Datasource": {
"dbname": "osm",
"extent": "-20037508.34 -20037508.34 20037508.34 20037508.34",
"geometry_field": "way",
"key_field": "",
"table": "( SELECT way, waterway AS type\n FROM planet_osm_line\n WHERE waterway IN ('river', 'canal', 'stream', 'ditch', 'drain')\n) AS data",
"type": "postgis"
},
"class": "",
"geometry": "linestring",
"id": "waterway_high",
"name": "waterway_high",
"srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over",
"srs-name": "900913"
},
{
"Datasource": {
"dbname": "osm",
"extent": "-20037508.34 -20037508.34 20037508.34 20037508.34",
"geometry_field": "way",
"id": "water_gen0",
"key_field": "",
"project": "foss4g-2011",
"srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over",
"table": "( SELECT way, \"natural\" AS type, way_area AS area\n FROM planet_osm_polygon\n WHERE (\"natural\" IN ('water', 'pond')\n OR waterway IN ('basin', 'canal', 'mill_pond', 'pond', 'riverbank', 'stream'))\n AND way_area > 10000\n) AS data",
"type": "postgis"
},
"class": "",
"geometry": "polygon",
"id": "water_gen0",
"name": "water_gen0",
"srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over",
"srs-name": "900913",
"status": "on"
},
{
"Datasource": {
"dbname": "osm",
"extent": "-20037508.34 -20037508.34 20037508.34 20037508.34",
"geometry_field": "way",
"id": "water_gen1",
"key_field": "",
"project": "foss4g-2011",
"srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over",
"table": "( SELECT way, \"natural\" AS type, way_area AS area\n FROM planet_osm_polygon\n WHERE (\"natural\" IN ('water', 'pond')\n OR waterway IN ('basin', 'canal', 'mill_pond', 'pond', 'riverbank', 'stream'))\n AND way_area > 1000\n) AS data",
"type": "postgis"
},
"class": "",
"geometry": "polygon",
"id": "water_gen1",
"name": "water_gen1",
"srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over",
"srs-name": "900913",
"status": "on"
},
{
"Datasource": {
"dbname": "osm",
"extent": "-20037508.34 -20037508.34 20037508.34 20037508.34",
"geometry_field": "way",
"id": "water",
"key_field": "",
"project": "foss4g-2011",
"srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over",
"table": "( SELECT way, way_area AS area\n FROM planet_osm_polygon\n WHERE \"natural\" IN ('water', 'pond')\n OR waterway IN ('basin', 'canal', 'mill_pond', 'pond', 'riverbank', 'stream')\n) AS data",
"type": "postgis"
},
"class": "",
"geometry": "polygon",
"id": "water",
"name": "water",
"srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over",
"srs-name": "900913",
"status": "on"
},
{
"Datasource": {
"dbname": "osm",
"extent": "-20037508.34 -20037508.34 20037508.34 20037508.34",
"geometry_field": "way",
"id": "landuse_overlays",
"key_field": "",
"project": "osm-bright-imposm",
"srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over",
"table": "( SELECT way, way_area AS area, COALESCE(leisure) AS type\n FROM planet_osm_polygon\n WHERE leisure = 'nature_reserve'\n ORDER BY way_area DESC\n) AS data",
"type": "postgis"
},
"class": "",
"geometry": "polygon",
"id": "landuse_overlays",
"name": "landuse_overlays",
"srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over",
"srs-name": "900913"
},
{
"Datasource": {
"dbname": "osm",
"extent": "-20037508.34 -20037508.34 20037508.34 20037508.34",
"geometry_field": "way",
"id": "admin",
"key_field": "",
"project": "osm-bright-imposm",
"table": "( SELECT way, admin_level\n FROM planet_osm_line\n WHERE boundary = 'administrative'\n AND admin_level IN ('2','3','4')\n) AS data",
"type": "postgis"
},
"class": "",
"geometry": "linestring",
"id": "admin",
"name": "admin",
"srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over",
"srs-name": "900913"
},
{
"Datasource": {
"dbname": "osm",
"extent": "-20037508.34 -20037508.34 20037508.34 20037508.34",
"geometry_field": "way",
"key_field": "",
"table": "( SELECT way, \"building\" AS type\n FROM planet_osm_polygon\n WHERE building NOT IN ('', '0','false', 'no')\n ORDER BY ST_YMin(ST_Envelope(way)) DESC\n) AS data",
"type": "postgis"
},
"class": "",
"geometry": "polygon",
"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.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over",
"srs-name": "900913"
},
{
"Datasource": {
"dbname": "osm",
"extent": "-20037508.34 -20037508.34 20037508.34 20037508.34",
"geometry_field": "way",
"id": "aeroway",
"key_field": "",
"project": "foss4g-2011",
"srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over",
"table": "( SELECT way, aeroway AS type\n FROM planet_osm_line\n WHERE aeroway IN ('apron', 'runway', 'taxiway')\n) AS data",
"type": "postgis"
},
"class": "",
"geometry": "linestring",
"id": "aeroway",
"name": "aeroway",
"srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over",
"srs-name": "900913",
"status": "on"
},
{
"Datasource": {
"dbname": "osm",
"extent": "-20037508.34 -20037508.34 20037508.34 20037508.34",
"geometry_field": "way",
"id": "tunnel",
"key_field": "",
"project": "osm-bright-master",
"srs": null,
"table": "( SELECT way, COALESCE(highway, railway) AS type, 0 AS bridge, access, render, layer, 1 as tunnel,\n CASE\n WHEN highway IN ('motorway', 'trunk') THEN 'motorway'\n WHEN highway IN ('primary', 'secondary') THEN 'mainroad'\n WHEN highway IN ('motorway_link', 'trunk_link', 'primary_link', 'secondary_link', 'tertiary', 'tertiary_link', 'residential', 'unclassified', 'road', 'living_street') THEN 'minorroad'\n WHEN highway IN ('service', 'track') THEN 'service'\n WHEN highway IN ('path', 'cycleway', 'footway', 'pedestrian', 'steps', 'bridleway') THEN 'noauto'\n WHEN railway IN ('light_rail', 'subway', 'narrow_gauge', 'rail', 'tram') THEN 'railway'\n ELSE 'other' END AS stylegroup\n FROM (\n SELECT *, '1_outline' AS render FROM planet_osm_line\n WHERE tunnel NOT IN ('', '0', 'no')\n UNION ALL\n SELECT *, '2_line' AS render FROM planet_osm_line\n WHERE tunnel NOT IN ('', '0', 'no')\n UNION ALL\n SELECT *, '3_inline' AS render FROM planet_osm_line\n WHERE tunnel NOT IN ('', '0', 'no')\n ) AS tunnels\n ORDER BY layer ASC, render ASC\n) AS data",
"type": "postgis"
},
"class": "",
"geometry": "linestring",
"id": "tunnel",
"name": "tunnel",
"srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over",
"srs-name": "900913"
},
{
"Datasource": {
"dbname": "osm",
"extent": "-20037508.34 -20037508.34 20037508.34 20037508.34",
"geometry_field": "way",
"id": "turning_circle_case",
"key_field": "",
"project": "osm-bright-master",
"srs": null,
"table": "( SELECT way \n FROM planet_osm_point \n WHERE highway = 'turning_circle'\n) AS data",
"type": "postgis"
},
"class": "",
"geometry": "point",
"id": "turning_circle_case",
"name": "turning_circle_case",
"srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over",
"srs-name": "900913"
},
{
"Datasource": {
"dbname": "osm",
"extent": "-20037508.34 -20037508.34 20037508.34 20037508.34",
"geometry_field": "way",
"id": "roads_high",
"key_field": "",
"project": "osm-bright-master",
"srs": null,
"table": "( SELECT way, COALESCE(highway, railway) AS type, 0 AS tunnel, 0 AS bridge, access, 'fill' AS render,\n CASE\n WHEN highway IN ('motorway', 'trunk') THEN 'motorway'\n WHEN highway IN ('primary', 'secondary') THEN 'mainroad'\n WHEN highway IN ('motorway_link', 'trunk_link', 'primary_link', 'secondary_link', 'tertiary', 'tertiary_link', 'residential', 'unclassified', 'road', 'living_street') THEN 'minorroad'\n WHEN highway IN ('service', 'track') THEN 'service'\n WHEN highway IN ('path', 'cycleway', 'footway', 'pedestrian', 'steps', 'bridleway') THEN 'noauto'\n WHEN railway IN ('light_rail', 'subway', 'narrow_gauge', 'rail', 'tram') THEN 'railway'\n ELSE 'other' END AS stylegroup\n FROM planet_osm_line\n WHERE (highway IS NOT NULL OR railway IS NOT NULL)\n AND (tunnel IS NULL OR tunnel = 'no')\n AND (bridge IS NULL OR bridge = 'no')\n ORDER BY z_order\n) AS data",
"type": "postgis"
},
"class": "",
"geometry": "linestring",
"id": "roads_high",
"name": "roads_high",
"srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over",
"srs-name": "900913"
},
{
"Datasource": {
"dbname": "osm",
"extent": "-20037508.34 -20037508.34 20037508.34 20037508.34",
"geometry_field": "way",
"key_field": "",
"table": "( SELECT way, highway AS type\n FROM planet_osm_roads\n WHERE highway IN ('motorway', 'trunk', 'primary', 'secondary', 'motorway_link', 'trunk_link')\n) AS data",
"type": "postgis"
},
"class": "",
"geometry": "linestring",
"id": "roads_med",
"name": "roads_med",
"srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over",
"srs-name": "900913"
},
{
"Datasource": {
"dbname": "osm",
"extent": "-20037508.34 -20037508.34 20037508.34 20037508.34",
"geometry_field": "way",
"key_field": "",
"table": "( SELECT way, highway AS type, bridge, tunnel\n FROM planet_osm_roads\n WHERE highway IN ('motorway', 'trunk')\n) AS data",
"type": "postgis"
},
"class": "",
"geometry": "linestring",
"id": "roads_low",
"name": "roads_low",
"srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over",
"srs-name": "900913",
"status": "on"
},
{
"Datasource": {
"dbname": "osm",
"extent": "-20037508.34 -20037508.34 20037508.34 20037508.34",
"geometry_field": "way",
"key_field": "",
"table": "( SELECT way \n FROM planet_osm_point\n WHERE highway = 'turning_circle'\n) AS data",
"type": "postgis"
},
"class": "",
"geometry": "point",
"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.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over",
"srs-name": "900913"
},
{
"Datasource": {
"dbname": "osm",
"extent": "-20037508.34 -20037508.34 20037508.34 20037508.34",
"geometry_field": "way",
"id": "bridge",
"key_field": "",
"project": "osm-bright-master",
"srs": null,
"table": "( SELECT way, COALESCE(highway, railway) AS type, 1 AS bridge, access, render, layer, 0 as tunnel,\n CASE\n WHEN highway IN ('motorway', 'trunk') THEN 'motorway'\n WHEN highway IN ('primary', 'secondary') THEN 'mainroad'\n WHEN highway IN ('motorway_link', 'trunk_link', 'primary_link', 'secondary_link', 'tertiary', 'tertiary_link', 'residential', 'unclassified', 'road', 'living_street') THEN 'minorroad'\n WHEN highway IN ('service', 'track') THEN 'service'\n WHEN highway IN ('path', 'cycleway', 'footway', 'pedestrian', 'steps', 'bridleway') THEN 'noauto'\n WHEN railway IN ('light_rail', 'subway', 'narrow_gauge', 'rail', 'tram') THEN 'railway'\n ELSE 'other' END AS stylegroup\n FROM (\n SELECT *, '1_outline' AS render FROM planet_osm_line\n WHERE bridge NOT IN ('', '0', 'no')\n UNION ALL\n SELECT *, '2_line' AS render FROM planet_osm_line\n WHERE bridge NOT IN ('', '0', 'no')\n UNION ALL\n SELECT *, '3_inline' AS render FROM planet_osm_line\n WHERE bridge NOT IN ('', '0', 'no')\n ) AS bridges\n ORDER BY layer ASC, render ASC\n) AS data",
"type": "postgis"
},
"class": "",
"geometry": "linestring",
"id": "bridge",
"name": "bridge",
"srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over",
"srs-name": "900913",
"status": "on"
},
{
"Datasource": {
"dbname": "osm",
"extent": "-20037508.34 -20037508.34 20037508.34 20037508.34",
"file": "http://mapbox-geodata.s3.amazonaws.com/natural-earth-1.4.0/cultural/10m-populated-places-simple.zip",
"srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over",
"type": "shape"
},
"class": "",
"geometry": "point",
"id": "ne_places",
"name": "ne_places",
"srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over",
"srs-name": "autodetect"
},
{
"Datasource": {
"dbname": "osm",
"extent": "-20037508.34 -20037508.34 20037508.34 20037508.34",
"geometry_field": "way",
"id": "place",
"key_field": "",
"project": "foss4g-2011",
"srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over",
"table": "( SELECT way, place AS type, name, z_order, population\n FROM planet_osm_point\n WHERE place in ('country', 'state', 'city', 'town', 'village', 'hamlet', 'suburb', 'neighbourhood', 'locality')\n ORDER BY population DESC NULLS LAST\n) AS data",
"type": "postgis"
},
"class": "",
"geometry": "point",
"id": "place",
"name": "place",
"srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over",
"srs-name": "900913",
"status": "on"
},
{
"Datasource": {
"dbname": "osm",
"extent": "-20037508.34 -20037508.34 20037508.34 20037508.34",
"geometry_field": "way",
"id": "landuse_label",
"key_field": "",
"project": "foss4g-2011",
"srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over",
"table": "( SELECT COALESCE(landuse, leisure, \"natural\", highway, amenity, tourism) AS type,\n name, way_area AS area,\n ST_PointOnSurface(way) AS way\n FROM planet_osm_polygon\n WHERE name IS NOT NULL\n AND way && !bbox!\n AND ST_IsValid(way)\n\n UNION ALL\n\n SELECT 'building' AS type, name, way_area AS area,\n ST_PointOnSurface(way) AS way\n FROM planet_osm_polygon\n WHERE name IS NOT NULL\n AND building NOT IN ('', 'no', '0', 'false')\n AND way && !bbox!\n AND ST_IsValid(way)\n ORDER BY area DESC\n) AS data",
"type": "postgis"
},
"class": "",
"geometry": "point",
"id": "area_label",
"name": "area_label",
"srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over",
"srs-name": "900913",
"status": "on"
},
{
"Datasource": {
"dbname": "osm",
"extent": "-20037508.34 -20037508.34 20037508.34 20037508.34",
"geometry_field": "way",
"id": "motorway_label",
"key_field": "",
"project": "foss4g-2011",
"srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over",
"table": "( SELECT way, highway AS type, name, ref, oneway, CHAR_LENGTH(ref) AS reflen\n FROM planet_osm_line\n WHERE highway IN ('motorway', 'trunk')\n AND (name IS NOT NULL OR ref IS NOT NULL)\n) AS data",
"type": "postgis"
},
"class": "",
"geometry": "linestring",
"id": "motorway_label",
"name": "motorway_label",
"srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over",
"srs-name": "900913",
"status": "on"
},
{
"Datasource": {
"dbname": "osm",
"extent": "-20037508.34 -20037508.34 20037508.34 20037508.34",
"geometry_field": "way",
"id": "mainroad_label",
"key_field": "",
"project": "foss4g-2011",
"srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over",
"table": "( SELECT way, highway AS type, name, oneway\n FROM planet_osm_line\n WHERE (name IS NOT NULL OR oneway IN ('yes', 'true', '1', '-1'))\n AND highway IN ('primary', 'secondary', 'tertiary')\n) AS data",
"type": "postgis"
},
"class": "",
"geometry": "linestring",
"id": "mainroad_label",
"name": "mainroad_label",
"srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over",
"srs-name": "900913",
"status": "on"
},
{
"Datasource": {
"dbname": "osm",
"extent": "-20037508.34 -20037508.34 20037508.34 20037508.34",
"geometry_field": "way",
"id": "minorroad_label",
"key_field": "",
"project": "foss4g-2011",
"srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over",
"table": "( SELECT way, highway AS type, name, oneway\n FROM planet_osm_line\n WHERE (name IS NOT NULL OR oneway IN ('yes', 'true', '1', '-1'))\n AND highway IN ('residential', 'unclassified', 'road', 'living_street', 'unknown')\n) AS data",
"type": "postgis"
},
"class": "",
"geometry": "linestring",
"id": "minorroad_label",
"name": "minorroad_label",
"srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over",
"srs-name": "900913",
"status": "on"
},
{
"Datasource": {
"dbname": "osm",
"extent": "-20037508.34 -20037508.34 20037508.34 20037508.34",
"geometry_field": "way",
"id": "waterway_label",
"key_field": "",
"project": "foss4g-2011",
"srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over",
"table": "( SELECT way, waterway AS type, name\n FROM planet_osm_line\n WHERE waterway IN ('canal', 'river', 'stream') \n AND name IS NOT NULL\n) AS data",
"type": "postgis"
},
"class": "",
"geometry": "linestring",
"id": "waterway_label",
"name": "waterway_label",
"srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over",
"srs-name": "900913",
"status": "on"
},
{
"geometry": "point",
"extent": [
-122.85990918289764,
47.38001179491598,
-121.86970418303555,
47.842970094896586
],
"Datasource": {
"type": "postgis",
"table": "( SELECT way, railway AS type, name, z_order \n FROM planet_osm_point \n WHERE railway = 'station'\n ORDER BY z_order NULLS LAST\n) AS DATA \n",
"key_field": "",
"geometry_field": "way",
"extent": "-20037508.34 -20037508.34 20037508.34 20037508.34",
"dbname": "osm"
},
"id": "train_stations",
"class": "",
"srs-name": "900913",
"srs": "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over",
"advanced": {},
"name": "train_stations"
}
],
"Stylesheet": [
"palette.mss",
"base.mss",
"roads.mss",
"labels.mss"
],
"attribution": "Data \u00a9 OpenStreetMap (and) contributors, ODbL",
"bounds": [
-180,
-85.0511,
180,
85.0511
],
"center": [
0,
20,
4
],
"description": "",
"format": "png",
"interactivity": false,
"maxzoom": 18,
"minzoom": 0,
"name": "OSM Bright",
"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 +wktext +no_defs +over"
}