PostGIS Data Layers

Data layers from PostGIS tables require additional connection parameter.

"dbs": "XYZ"

The dbs key value must match a database connection in the environment settings. The key value XYZ requires a database connection DBS_XYZ.

"table": "schema.eu_nuts_lv0"

The table value must match a table in the database defined by the dbs parameter. The table name can be prefixed with a schema separated from the table name with a dot.

"tables": {
  "6": "eu_nuts_lv0",
  "7": "eu_nuts_lv0",
  "8": "eu_nuts_lv0",
  "9": "eu_nuts_lv0",
  "10": "eu_nuts_lv0",
  "11": "eu_nuts_lv0",
  "12": "eu_nuts_lv0",
  "13": "eu_nuts_lv0",
  "14": "eu_nuts_lv0",
  "15": null
}

A tables object can be provided instead of the table key. With a single table key the layer will be visible on all zoom levels in a locale. It is possible to set a tables object with key value/pairs defining which table should provide the data at the zoom level represented by the key.

Setting a null value will prevent the layer to be visible on the zoom level and beyond the defined range.

PostGIS data layers also require a geometry field to be defined in the layer settings. The definition of the geometry field varies with the layer format.