pieterjandesmedt
commented
9 years ago This might work:
{
"bounds": [
2.4747,
49.3054,
7.4625,
53.7568
],
"center": [
4.3835,
50.8198,
8
],
"format": "png8",
"interactivity": false,
"minzoom": 0,
"maxzoom": 18,
"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",
"Stylesheet": [
"palette.mss",
"base.mss",
"roads.mss",
"labels.mss"
],
"Layer": [
{
"Datasource": {
"dbname": "osm",
"extent": "-20037508.34 -20037508.34 20037508.34 20037508.34",
"file": "layers/land/ae26f3ca-10m-land.shp",
"id": "land",
"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"
},
"class": "shp",
"geometry": "polygon",
"id": "land",
"name": "land",
"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": "layers/processed_p/7f5a1dfb-coastline-good.shp"
},
"class": "shp",
"geometry": "polygon",
"id": "processed_p",
"name": "processed_p",
"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": {
"file": "layers/shoreline_300/ab6b4f6f-shoreline_300.shp"
},
"class": "shp",
"geometry": "polygon",
"id": "shoreline_300",
"name": "shoreline_300",
"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": "geometry",
"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 geometry, type, area\n FROM osm_landusages_gen0\n ORDER BY area DESC\n) AS data",
"type": "postgis",
"user": "postgres"
},
"class": "",
"geometry": "polygon",
"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": "3857",
"status": "on"
},
{
"Datasource": {
"dbname": "osm",
"extent": "-20037508.34,-20037508.34,20037508.34,20037508.34",
"geometry_field": "geometry",
"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 geometry, type, area\n FROM osm_landusages_gen1\n ORDER BY area DESC\n) AS data",
"type": "postgis",
"user": "postgres"
},
"class": "",
"geometry": "polygon",
"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": "3857",
"status": "on"
},
{
"Datasource": {
"dbname": "osm",
"extent": "-20037508.34,-20037508.34,20037508.34,20037508.34",
"geometry_field": "geometry",
"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 geometry, type, area\n FROM osm_landusages\n ORDER BY area DESC\n) AS data",
"type": "postgis",
"user": "postgres"
},
"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": "3857",
"status": "on"
},
{
"Datasource": {
"dbname": "osm",
"extent": "-20037508.34,-20037508.34,20037508.34,20037508.34",
"geometry_field": "geometry",
"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 geometry, type\n FROM osm_waterways\n WHERE type IN ('river', 'canal')\n) AS data",
"type": "postgis",
"user": "postgres"
},
"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": "3857",
"status": "on"
},
{
"Datasource": {
"dbname": "osm",
"extent": "-20037508.34,-20037508.34,20037508.34,20037508.34",
"geometry_field": "geometry",
"key_field": "",
"table": "( SELECT geometry, type\n FROM osm_waterways\n WHERE type IN ('river', 'canal', 'stream')\n) AS data",
"type": "postgis",
"user": "postgres"
},
"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": "3857"
},
{
"Datasource": {
"dbname": "osm",
"extent": "-20037508.34,-20037508.34,20037508.34,20037508.34",
"geometry_field": "geometry",
"key_field": "",
"table": "( SELECT geometry, type\n FROM osm_waterways\n WHERE type IN ('river', 'canal', 'stream', 'ditch', 'drain')\n) AS data",
"type": "postgis",
"user": "postgres"
},
"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": "3857"
},
{
"Datasource": {
"dbname": "osm",
"extent": "-20037508.34,-20037508.34,20037508.34,20037508.34",
"geometry_field": "geometry",
"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 geometry\n FROM osm_waterareas\n WHERE area > 10000\n) AS data",
"type": "postgis",
"user": "postgres"
},
"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": "3857",
"status": "on"
},
{
"Datasource": {
"dbname": "osm",
"extent": "-20037508.34,-20037508.34,20037508.34,20037508.34",
"geometry_field": "geometry",
"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 geometry\n FROM osm_waterareas\n WHERE area > 1000\n) AS data",
"type": "postgis",
"user": "postgres"
},
"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": "3857",
"status": "on"
},
{
"Datasource": {
"dbname": "osm",
"extent": "-20037508.34,-20037508.34,20037508.34,20037508.34",
"geometry_field": "geometry",
"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 geometry\n FROM osm_waterareas\n) AS data",
"type": "postgis",
"user": "postgres"
},
"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": "3857",
"status": "on"
},
{
"Datasource": {
"dbname": "osm",
"extent": "-20037508.34,-20037508.34,20037508.34,20037508.34",
"geometry_field": "geometry",
"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 geometry, type, round(st_area(geometry)) as area\nfrom osm_landusages\norder by area desc) as landusages",
"type": "postgis",
"user": "postgres"
},
"class": "",
"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"
},
{
"Datasource": {
"dbname": "osm",
"extent": "-20037508.34,-20037508.34,20037508.34,20037508.34",
"geometry_field": "geometry",
"key_field": "",
"table": "( SELECT geometry, type, name, area\n FROM osm_buildings\n) AS data",
"type": "postgis",
"user": "postgres"
},
"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": "3857"
},
{
"Datasource": {
"dbname": "osm",
"extent": "-20037508.34,-20037508.34,20037508.34,20037508.34",
"geometry_field": "geometry",
"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 geometry, type\n FROM osm_aeroways\n) AS data",
"type": "postgis",
"user": "postgres"
},
"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": "3857",
"status": "on"
},
{
"Datasource": {
"dbname": "osm",
"extent": "-20037508.34,-20037508.34,20037508.34,20037508.34",
"geometry_field": "geometry",
"key_field": "",
"table": "( SELECT geometry, type, 0 as bridge, access, render, layer, tunnel,\n CASE\n WHEN type IN ('motorway', 'trunk') THEN 'motorway'\n WHEN type IN ('primary', 'secondary') THEN 'mainroad'\n WHEN type IN ('motorway_link', 'trunk_link', 'primary_link', 'secondary_link', 'tertiary', 'tertiary_link', 'residential', 'unclassified', 'road', 'living_street') THEN 'minorroad'\n WHEN type IN ('service', 'track') THEN 'service'\n WHEN type IN ('path', 'cycleway', 'footway', 'pedestrian', 'steps', 'bridleway') THEN 'noauto'\n WHEN type 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 osm_roads WHERE tunnel = 1\n UNION ALL\n SELECT *, '2_line' AS render FROM osm_roads WHERE tunnel = 1\n UNION ALL\n SELECT *, '3_inline' AS render FROM osm_roads WHERE tunnel = 1\n ) AS tunnels\n ORDER BY layer ASC, render ASC\n) AS data",
"type": "postgis",
"user": "postgres"
},
"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": "3857"
},
{
"Datasource": {
"dbname": "osm",
"extent": "-20037508.34,-20037508.34,20037508.34,20037508.34",
"geometry_field": "geometry",
"key_field": "",
"table": "( SELECT geometry \n FROM osm_transport_points \n WHERE type = 'turning_circle'\n) AS data",
"type": "postgis",
"user": "postgres"
},
"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": "3857"
},
{
"Datasource": {
"dbname": "osm",
"extent": "-20037508.34,-20037508.34,20037508.34,20037508.34",
"geometry_field": "geometry",
"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 geometry, type, name\n FROM osm_waterways\n WHERE type IN ('canal', 'river', 'stream') \n AND name IS NOT NULL\n) AS data",
"type": "postgis",
"user": "postgres"
},
"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": "3857",
"status": "on"
},
{
"Datasource": {
"dbname": "osm",
"extent": "280092.036848666,6357264.62490127,715400.978350158,6716105.79236794",
"geometry_field": "",
"id": "roads_high",
"key_field": "",
"project": "osm-bright",
"srs": null,
"table": "( SELECT geometry, type, tunnel, bridge, access, 'fill' AS render,\n CASE\n WHEN type IN ('motorway', 'trunk') THEN 'motorway'\n WHEN type IN ('primary', 'secondary') THEN 'mainroad'\n WHEN type IN ('motorway_link', 'trunk_link', 'primary_link', 'secondary_link', 'tertiary', 'tertiary_link', 'residential', 'unclassified', 'road', 'living_street') THEN 'minorroad'\n WHEN type IN ('service', 'track') THEN 'service'\n WHEN type IN ('path', 'cycleway', 'footway', 'pedestrian', 'steps', 'bridleway') THEN 'noauto'\n WHEN type IN ('light_rail', 'subway', 'narrow_gauge', 'rail', 'tram') THEN 'railway'\n ELSE 'other' END AS stylegroup\n FROM osm_roads\n WHERE bridge = 0\n AND tunnel = 0\n ORDER BY z_order\n) AS data",
"type": "postgis",
"user": "postgres",
"extent_cache": "auto"
},
"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",
"extent": [
2.5161095766132484,
49.48327596118606,
6.426556331260057,
51.53290743807125
],
"advanced": {}
},
{
"Datasource": {
"dbname": "osm",
"extent": "280092.036848666,6357264.62490127,715001.503436492,6716105.79236794",
"geometry_field": "",
"key_field": "",
"table": "( SELECT geometry, type\n FROM osm_roads_gen1\n WHERE type IN ('motorway', 'trunk', 'primary', 'secondary', 'motorway_link', 'trunk_link')\n) AS data",
"type": "postgis",
"user": "postgres",
"extent_cache": "auto"
},
"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",
"extent": [
2.5161095766132484,
49.48327596118606,
6.422967787054373,
51.53290743807125
],
"advanced": {}
},
{
"Datasource": {
"dbname": "osm",
"extent": "280092.036848666,6357264.62490127,715001.503436492,6716105.79236794",
"geometry_field": "geometry",
"key_field": "",
"table": "( SELECT geometry, type\n FROM osm_roads_gen0\n) AS data",
"type": "postgis",
"user": "postgres",
"extent_cache": "auto"
},
"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",
"extent": [
2.5161095766132484,
49.48327596118606,
6.422967787054373,
51.53290743807125
],
"advanced": {}
},
{
"Datasource": {
"dbname": "osm",
"extent": "-20037508.34,-20037508.34,20037508.34,20037508.34",
"geometry_field": "geometry",
"key_field": "",
"table": "( SELECT geometry \n FROM osm_transport_points \n WHERE type = 'turning_circle'\n) AS data",
"type": "postgis",
"user": "postgres"
},
"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": "3857"
},
{
"Datasource": {
"dbname": "osm",
"extent": "-20037508.34,-20037508.34,20037508.34,20037508.34",
"geometry_field": "geometry",
"id": "bridge",
"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 geometry, type, bridge, access, render, layer, 0 as tunnel,\n CASE\n WHEN type IN ('motorway', 'trunk') THEN 'motorway'\n WHEN type IN ('primary', 'secondary') THEN 'mainroad'\n WHEN type IN ('motorway_link', 'trunk_link', 'primary_link', 'secondary_link', 'tertiary', 'tertiary_link', 'residential', 'unclassified', 'road', 'living_street') THEN 'minorroad'\n WHEN type IN ('service', 'track') THEN 'service'\n WHEN type IN ('path', 'cycleway', 'footway', 'pedestrian', 'steps', 'bridleway') THEN 'noauto'\n WHEN type 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 osm_roads WHERE bridge = 1\n UNION ALL\n SELECT *, '2_line' AS render FROM osm_roads WHERE bridge = 1\n UNION ALL\n SELECT *, '3_inline' AS render FROM osm_roads WHERE bridge = 1\n ) as bridges\n ORDER BY layer ASC, render ASC\n) AS data",
"type": "postgis",
"user": "postgres"
},
"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": "3857",
"status": "on"
},
{
"Datasource": {
"dbname": "osm",
"extent": "-20037508.34,-20037508.34,20037508.34,20037508.34",
"geometry_field": "geometry",
"key_field": "",
"table": "(select geometry, type,\n\tCASE\n\t\tWHEN type IN ('toll_booth', 'stile', 'gate', 'horse_stile','lift_gate', 'kissing_gate','cattle_grid','entrance') THEN 'gate'\n\t\tWHEN type IN ('block', 'bollard', 'chain', 'cycle_barrier', 'spikes', 'fence', 'wire_fence','yes') THEN 'divider'\n\tEND AS stylegroup\nFROM osm_barrierpoints\n) AS data",
"type": "postgis",
"user": "postgres"
},
"class": "",
"geometry": "point",
"id": "barrier_points",
"name": "barrier_points",
"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": "3857"
},
{
"Datasource": {
"dbname": "osm",
"extent": "-20037508.34,-20037508.34,20037508.34,20037508.34",
"geometry_field": "geometry",
"id": "barrier_lines",
"key_field": "",
"project": "osm-bright",
"srs": null,
"table": "(SELECT geometry, type,\n\tCASE \n\t\tWHEN type IN ('city_wall', 'fence', 'retaining_wall', 'wall', 'wire_fence', 'yes') THEN 'fence'\n\t\tWHEN type IN ('gate', 'spikes', 'bollard', 'lift_gate', 'kissing_gate') THEN 'gate'\n\t\tWHEN type IN ('hedge') THEN 'hedge'\n\tEND AS stylegroup\nFROM osm_barrierways\n) AS data",
"type": "postgis",
"user": "postgres"
},
"class": "",
"geometry": "linestring",
"id": "barrier_lines",
"name": "barrier_lines",
"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": "3857"
},
{
"Datasource": {
"dbname": "osm",
"extent": "-20037508.34,-20037508.34,20037508.34,20037508.34",
"geometry_field": "geometry",
"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 geometry, type, name, z_order, population\n FROM osm_places\n ORDER BY z_order, population DESC NULLS LAST\n) AS data",
"type": "postgis",
"user": "postgres"
},
"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": "3857",
"status": "on"
},
{
"Datasource": {
"dbname": "osm",
"extent": "282809.106347055,6360412.64913114,713434.245774134,6711293.66519934",
"geometry_field": "geometry",
"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 type, name, area, 'land' AS stylegroup,\n ST_Centroid(geometry) AS geometry\n FROM osm_landusages\n WHERE name IS NOT NULL\n AND geometry && !bbox!\n AND type IN (\n 'cemetery', 'college', 'commercial', 'common', 'garden', 'golf_course',\n 'hospital', 'industrial', 'library', 'park', 'pedestrian', 'place_of_worship',\n 'playground', 'school', 'sports_center', 'stadium', 'theatre', 'university' )\n AND geometry && !bbox!\n AND ST_IsValid(geometry)\n\n UNION ALL\n\n SELECT type, name, area, 'water' AS stylegroup,\n ST_Centroid(geometry) AS geometry\n FROM osm_waterareas\n WHERE name IS NOT NULL\n AND type in ( 'water', 'basin' )\n AND geometry && !bbox!\n AND ST_IsValid(geometry)\n\n UNION ALL\n\n SELECT 'building' AS type, name, area, 'building' AS stylegroup,\n ST_PointOnSurface(geometry) AS geometry\n FROM osm_buildings\n WHERE name IS NOT NULL \n AND geometry && !bbox!\n AND type NOT IN ('station', 'railway_station', 'train_station')\n AND ST_IsValid(geometry)\n\n ORDER BY area DESC\n) AS data",
"type": "postgis",
"user": "postgres",
"extent_cache": "auto"
},
"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": "3857",
"status": "on",
"extent": [
2.5405174271974267,
49.50164465053372,
6.408888871931876,
51.50600882114008
],
"advanced": {}
},
{
"Datasource": {
"dbname": "osm",
"extent": "283291.950993127,6358183.52586995,713339.800510403,6715507.03258528",
"geometry_field": "",
"id": "admin",
"key_field": "",
"table": "(SELECT * FROM osm_admin WHERE admin_level < 5 AND admin_level > 2) AS data",
"type": "postgis",
"user": "postgres",
"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",
"extent_cache": "auto"
},
"class": "",
"geometry": "polygon",
"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",
"extent": [
2.5448548944516443,
49.488638451379394,
6.408040455692654,
51.529561382324395
],
"srs-name": "900913",
"advanced": {}
},
{
"geometry": "point",
"extent": [
2.4475000000000082,
49.50644750000042,
6.408039499999978,
51.5329075000011
],
"Datasource": {
"type": "postgis",
"table": "( SELECT name, type, ST_Centroid(ST_Collect(geometry)) as geometry\nFROM osm_transport_points\nWHERE type in ('bus_stop','station','tram_stop')\nGROUP BY name, type\n) AS data",
"key_field": "",
"geometry_field": "",
"extent_cache": "auto",
"extent": "272454.453716538,6361235.95589152,713339.694123181,6716105.80345038",
"dbname": "osm",
"user": "postgres"
},
"id": "public_transport",
"class": "",
"srs-name": "3857",
"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": "public_transport"
},
{
"Datasource": {
"dbname": "osm",
"extent": "-3028844.9259554,3848157.11253681,5129595.80718925,11459927.3677084",
"geometry_field": "geometry",
"id": "motorway_label",
"key_field": "",
"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 geometry, type, coalesce(name,ref) as name, ref, oneway, CHAR_LENGTH(ref) AS reflen\n FROM osm_motorways\n WHERE type IN ('motorway', 'trunk','primary')\n AND (name IS NOT NULL OR ref IS NOT NULL)\n) AS data",
"type": "postgis",
"user": "postgres",
"extent_cache": "auto"
},
"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",
"extent": [
-27.208576902135956,
32.64408638123322,
46.07994314953517,
71.1679012733936
],
"advanced": {}
},
{
"Datasource": {
"dbname": "osm",
"extent": "281352.57600585,6358937.52871736,715001.503436492,6711622.95729261",
"geometry_field": "geometry",
"id": "mainroad_label",
"key_field": "",
"project": "osm-bright",
"srs": null,
"table": "( SELECT geometry, type, name, oneway\n FROM osm_mainroads\n WHERE name IS NOT NULL OR oneway <> 0\n) AS data",
"type": "postgis",
"user": "postgres",
"extent_cache": "auto"
},
"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",
"extent": [
2.5274331925245437,
49.49303819617417,
6.422967787054373,
51.507849989991115
],
"advanced": {}
},
{
"Datasource": {
"dbname": "osm",
"extent": "-20037508.34,-20037508.34,20037508.34,20037508.34",
"geometry_field": "geometry",
"id": "minorroad_label",
"key_field": "",
"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 geometry, type, name, oneway\n FROM osm_minorroads\n WHERE name IS NOT NULL OR oneway <> 0\n) AS data",
"type": "postgis",
"user": "postgres"
},
"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": "3857",
"status": "on"
},
{
"extent": [
2.5448548944516443,
49.488638451379394,
6.408040455692654,
51.529561382324395
],
"Datasource": {
"type": "postgis",
"table": "(SELECT * FROM osm_admin WHERE admin_level = 2) AS data",
"key_field": "",
"geometry_field": "",
"extent_cache": "auto",
"extent": "283291.950993127,6358183.52586995,713339.800510403,6715507.03258528",
"dbname": "osm",
"user": "postgres",
"id": "country_borders",
"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"
},
"id": "country_borders",
"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": "country_borders"
}
],
"scale": 1,
"metatile": 15,
"attribution": "Data © OpenStreetMap (and) contributors, CC-BY-SA",
"description": "",
"name": "Blossom"
}
The
project.mmlfile currently contains tables generated for the osm2pgsql mapping, but not the imposm mapping. This limits the use of this theme on an Ubuntu server running the (much faster) imposm importer.Suggestion: create a
project.mmlfile for the imposm mapping as well (following the 7 steps listed here)