natural-earth.toml

# t-rex configuration

[service.mvt]
viewer = true

[[datasource]]
dbconn = "postgresql://pi@%2Frun%2Fpostgresql/naturalearth4"
name = "pg"
default = true

[grid]
predefined = "web_mercator"

[[tileset]]
name = "ne"
attribution = "Natural Earth v4"
extent = [-179.97277, -83.05457, 179.99366, 83.23559]

[[tileset.layer]]
name = "country_label_points"
geometry_field = "wkb_geometry"
geometry_type = "POINT"
fid_field = "ogc_fid"
srid = 3857
buffer_size = 0
[[tileset.layer.query]]
# ne_10m_admin_0_label_points
minzoom = 1
maxzoom = 10
sql = """SELECT wkb_geometry, ogc_fid, sr_subunit, scalerank FROM ne_10m_admin_0_label_points WHERE scalerank < !zoom! AND wkb_geometry && !bbox!"""

[[tileset.layer]]
name = "state_label_points"
geometry_field = "wkb_geometry"
geometry_type = "POINT"
fid_field = "ogc_fid"
srid = 3857
buffer_size = 0
[[tileset.layer.query]]
# ne_10m_admin_1_label_points
minzoom = 1
maxzoom = 10
sql = """SELECT wkb_geometry, ogc_fid, adm0_sr, name, scalerank FROM ne_10m_admin_1_label_points WHERE scalerank < !zoom! AND wkb_geometry && !bbox!"""

[[tileset.layer]]
name = "boundary_lines_land"
geometry_field = "wkb_geometry"
geometry_type = "MULTILINESTRING"
fid_field = "ogc_fid"
srid = 3857
buffer_size = 0
simplify = true
[[tileset.layer.query]]
# ne_110m_admin_0_boundary_lines_land
minzoom = 0
maxzoom = 2
sql = """SELECT wkb_geometry, ogc_fid, featurecla, name, min_zoom FROM ne_110m_admin_0_boundary_lines_land WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""
[[tileset.layer.query]]
# ne_50m_admin_0_boundary_lines_land
minzoom = 3
maxzoom = 4
#Tegola: dont_simplify = true
sql = """SELECT wkb_geometry, ogc_fid, featurecla, name, min_zoom FROM ne_50m_admin_0_boundary_lines_land WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""
[[tileset.layer.query]]
# ne_10m_admin_0_boundary_lines_land
minzoom = 5
maxzoom = 10
sql = """SELECT wkb_geometry, ogc_fid, featurecla, name, min_zoom FROM ne_10m_admin_0_boundary_lines_land WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""

[[tileset.layer]]
name = "boundary_lines_disputed"
geometry_field = "wkb_geometry"
geometry_type = "MULTILINESTRING"
srid = 3857
buffer_size = 0
simplify = true
query_limit = 1000
[[tileset.layer.query]]
# ne_50m_admin_0_boundary_lines_disputed_areas
minzoom = 3
maxzoom = 4
sql = """SELECT wkb_geometry, ogc_fid, featurecla, name, min_zoom FROM ne_50m_admin_0_boundary_lines_disputed_areas WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""
[[tileset.layer.query]]
# ne_10m_admin_0_boundary_lines_disputed_areas
minzoom = 5
maxzoom = 10
sql = """SELECT wkb_geometry, ogc_fid, featurecla, name, min_zoom FROM ne_10m_admin_0_boundary_lines_disputed_areas WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""

[[tileset.layer]]
name = "parks_and_protected_lands_area"
geometry_field = "wkb_geometry"
geometry_type = "MULTIPOLYGON"
srid = 3857
buffer_size = 1
simplify = true
query_limit = 1000
[[tileset.layer.query]]
# ne_10m_parks_and_protected_lands_area
minzoom = 5
maxzoom = 10
sql = """SELECT wkb_geometry, ogc_fid, featurecla, name FROM ne_10m_parks_and_protected_lands_area WHERE wkb_geometry && !bbox!"""

[[tileset.layer]]
name = "parks_and_protected_lands_line"
geometry_field = "wkb_geometry"
geometry_type = "MULTILINESTRING"
srid = 3857
buffer_size = 0
simplify = true
query_limit = 1000
[[tileset.layer.query]]
# ne_10m_parks_and_protected_lands_line
minzoom = 5
maxzoom = 10
sql = """SELECT wkb_geometry, ogc_fid, featurecla, name FROM ne_10m_parks_and_protected_lands_line WHERE wkb_geometry && !bbox!"""

[[tileset.layer]]
name = "parks_and_protected_lands_point"
geometry_field = "wkb_geometry"
geometry_type = "POINT"
srid = 3857
buffer_size = 0
query_limit = 1000
[[tileset.layer.query]]
# ne_10m_parks_and_protected_lands_point
minzoom = 5
maxzoom = 10
sql = """SELECT wkb_geometry, ogc_fid, featurecla, name FROM ne_10m_parks_and_protected_lands_point WHERE wkb_geometry && !bbox!"""

[[tileset.layer]]
name = "map_units"
geometry_field = "wkb_geometry"
geometry_type = "MULTILINESTRING"
srid = 3857
buffer_size = 0
simplify = true
query_limit = 1000
[[tileset.layer.query]]
# ne_10m_admin_0_boundary_lines_map_units
minzoom = 5
maxzoom = 10
sql = """SELECT wkb_geometry, ogc_fid, featurecla, min_zoom FROM ne_10m_admin_0_boundary_lines_map_units WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""

[[tileset.layer]]
name = "boundary_lines_maritime"
geometry_field = "wkb_geometry"
geometry_type = "MULTILINESTRING"
srid = 3857
buffer_size = 0
simplify = true
query_limit = 1000
[[tileset.layer.query]]
# ne_50m_admin_0_boundary_lines_maritime_indicator
minzoom = 3
maxzoom = 4
sql = """SELECT wkb_geometry, ogc_fid, featurecla, min_zoom FROM ne_50m_admin_0_boundary_lines_maritime_indicator WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""
[[tileset.layer.query]]
# ne_10m_admin_0_boundary_lines_maritime_indicator
minzoom = 5
maxzoom = 10
sql = """SELECT wkb_geometry, ogc_fid, featurecla, min_zoom FROM ne_10m_admin_0_boundary_lines_maritime_indicator WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""

# Not used in style
# [[tileset.layer]]
# name = "countries"
# geometry_field = "wkb_geometry"
# geometry_type = "MULTIPOLYGON"
# srid = 3857
# buffer_size = 1
# simplify = true
# query_limit = 1000
# [[tileset.layer.query]]
# # ne_110m_admin_0_countries
# minzoom = 0
# maxzoom = 2
# sql = """SELECT wkb_geometry, ogc_fid, featurecla, name, name_long, abbrev, adm0_a3_un AS adm0_a3, min_zoom, min_label, max_label FROM ne_110m_admin_0_countries WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""
# # ? "adm0_a3_is, adm0_a3_us, adm0_a3_un, adm0_a3_wb"
#     # sql = "SELECT ST_AsBinary(wkb_geometry) AS geometry, ogc_fid, featurecla, name, name_long, abbrev, adm0_a3, min_zoom, min_label, max_label FROM ne_110m_admin_0_countries WHERE min_zoom <= !ZOOM! AND wkb_geometry && !BBOX!"
# [[tileset.layer.query]]
# # ne_50m_admin_0_countries
# minzoom = 3
# maxzoom = 4
# sql = """SELECT wkb_geometry, ogc_fid, featurecla, name, name_long, abbrev, adm0_a3_un AS adm0_a3, min_zoom, min_label, max_label FROM ne_50m_admin_0_countries WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""
# # ? "adm0_a3_is, adm0_a3_us, adm0_a3_un, adm0_a3_wb"
#     # sql = "SELECT ST_AsBinary(wkb_geometry) AS geometry, ogc_fid, featurecla, name, name_long, abbrev, adm0_a3, min_zoom, min_label, max_label FROM ne_50m_admin_0_countries WHERE min_zoom <= !ZOOM! AND wkb_geometry && !BBOX!"
# [[tileset.layer.query]]
# # ne_10m_admin_0_countries
# minzoom = 5
# maxzoom = 10
# sql = """SELECT wkb_geometry, ogc_fid, featurecla, name, name_long, abbrev, adm0_a3_un AS adm0_a3, min_zoom, min_label, max_label FROM ne_10m_admin_0_countries WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""
# # ? "adm0_a3_is, adm0_a3_us, adm0_a3_un, adm0_a3_wb"
#     # sql = "SELECT ST_AsBinary(wkb_geometry) AS geometry, ogc_fid, featurecla, name, name_long, abbrev, adm0_a3, min_zoom, min_label, max_label FROM ne_10m_admin_0_countries WHERE min_zoom <= !ZOOM! AND wkb_geometry && !BBOX!"

[[tileset.layer]]
name = "admin_0_map_subunits"
geometry_field = "wkb_geometry"
geometry_type = "MULTIPOLYGON"
srid = 3857
buffer_size = 1
simplify = true
query_limit = 1000
[[tileset.layer.query]]
# ne_50m_admin_0_map_subunits
minzoom = 3
maxzoom = 4
sql = """SELECT wkb_geometry, ogc_fid, featurecla, min_label, max_label, min_zoom, type, abbrev FROM ne_50m_admin_0_map_subunits WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""
# "min_zoom, type, abbrev" | have been added to bench sql
    # sql = "SELECT ST_AsBinary(wkb_geometry) AS geometry, ogc_fid, featurecla, min_label, max_label, min_zoom, type, abbrev FROM ne_50m_admin_0_map_subunits WHERE min_zoom <= !ZOOM! AND wkb_geometry && !BBOX!"
[[tileset.layer.query]]
# ne_10m_admin_0_map_subunits
minzoom = 5
maxzoom = 10
sql = """SELECT wkb_geometry, ogc_fid, featurecla, min_label, max_label, min_zoom, type, abbrev FROM ne_10m_admin_0_map_subunits WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""
# "min_zoom, type, abbrev" | have been added to bench sql
    # sql = "SELECT ST_AsBinary(wkb_geometry) AS geometry, ogc_fid, featurecla, min_label, max_label, min_zoom, type, abbrev FROM ne_10m_admin_0_map_subunits WHERE min_zoom <= !ZOOM! AND wkb_geometry && !BBOX!"

[[tileset.layer]]
name = "admin_1_lines"
geometry_field = "wkb_geometry"
geometry_type = "MULTILINESTRING"
srid = 3857
buffer_size = 0
simplify = true
query_limit = 1000
[[tileset.layer.query]]
# ne_110m_admin_1_states_provinces_lines
minzoom = 0
maxzoom = 2
sql = """SELECT wkb_geometry, ogc_fid, featurecla, name, adm0_name, min_zoom FROM ne_110m_admin_1_states_provinces_lines WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""
[[tileset.layer.query]]
# ne_50m_admin_1_states_provinces_lines
minzoom = 3
maxzoom = 4
sql = """SELECT wkb_geometry, ogc_fid, featurecla, name, adm0_name, min_zoom FROM ne_50m_admin_1_states_provinces_lines WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""
[[tileset.layer.query]]
# ne_10m_admin_1_states_provinces_lines
minzoom = 5
maxzoom = 10
sql = """SELECT wkb_geometry, ogc_fid, featurecla, name, adm0_name, min_zoom, min_label FROM ne_10m_admin_1_states_provinces_lines WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""

[[tileset.layer]]
name = "populated_places"
geometry_field = "wkb_geometry"
geometry_type = "POINT"
srid = 3857
buffer_size = 0
simplify = true
query_limit = 1000
[[tileset.layer.query]]
# ne_110m_populated_places
minzoom = 0
maxzoom = 2
sql = """SELECT wkb_geometry, ogc_fid, featurecla, name, min_zoom FROM ne_110m_populated_places WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""
[[tileset.layer.query]]
# ne_50m_populated_places
minzoom = 3
maxzoom = 4
sql = """SELECT wkb_geometry, ogc_fid, featurecla, name, min_zoom FROM ne_50m_populated_places WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""
[[tileset.layer.query]]
# ne_10m_populated_places
minzoom = 5
maxzoom = 10
sql = """SELECT wkb_geometry, ogc_fid, featurecla, name, min_zoom FROM ne_10m_populated_places WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""

[[tileset.layer]]
name = "roads"
geometry_field = "wkb_geometry"
geometry_type = "MULTILINESTRING"
srid = 3857
buffer_size = 0
simplify = true
query_limit = 1000
[[tileset.layer.query]]
# ne_10m_roads
minzoom = 3
maxzoom = 10
sql = """SELECT wkb_geometry, ogc_fid, name, min_zoom, min_label, type, label, label2, featurecla FROM ne_10m_roads WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""
# type, label, label2, featurecla | were added to bench sql
    # sql = "SELECT ST_AsBinary(wkb_geometry) AS geometry, ogc_fid, name, min_zoom, min_label, type, label, label2, featurecla FROM ne_10m_roads WHERE min_zoom <= !ZOOM! AND wkb_geometry && !BBOX!"

[[tileset.layer]]
name = "urban_areas"
geometry_field = "wkb_geometry"
geometry_type = "MULTIPOLYGON"
srid = 3857
buffer_size = 1
simplify = true
query_limit = 1000
[[tileset.layer.query]]
# ne_10m_urban_areas
minzoom = 5
maxzoom = 10
sql = """SELECT wkb_geometry, ogc_fid, min_zoom FROM ne_10m_urban_areas WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""

[[tileset.layer]]
name = "geographic_lines"
geometry_field = "wkb_geometry"
geometry_type = "MULTILINESTRING"
srid = 3857
buffer_size = 0
simplify = true
query_limit = 1000
[[tileset.layer.query]]
# ne_50m_geographic_lines
minzoom = 3
maxzoom = 4
sql = """SELECT wkb_geometry, ogc_fid, name FROM ne_50m_geographic_lines WHERE wkb_geometry && !bbox!"""
[[tileset.layer.query]]
# ne_10m_geographic_lines
minzoom = 5
maxzoom = 10
sql = """SELECT wkb_geometry, ogc_fid, name FROM ne_10m_geographic_lines WHERE wkb_geometry && !bbox!"""

[[tileset.layer]]
name = "coastline"
geometry_field = "wkb_geometry"
geometry_type = "MULTILINESTRING"
srid = 3857
buffer_size = 0
simplify = true
query_limit = 1000
[[tileset.layer.query]]
# ne_110m_coastline
minzoom = 0
maxzoom = 2
sql = """SELECT wkb_geometry, ogc_fid, featurecla, min_zoom FROM ne_110m_coastline WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""
[[tileset.layer.query]]
# ne_50m_coastline
minzoom = 3
maxzoom = 4
sql = """SELECT wkb_geometry, ogc_fid, featurecla, min_zoom FROM ne_50m_coastline WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""
[[tileset.layer.query]]
# ne_10m_coastline
minzoom = 5
maxzoom = 10
sql = """SELECT wkb_geometry, ogc_fid, featurecla, min_zoom FROM ne_10m_coastline WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""

[[tileset.layer]]
name = "antarctic_ice_shelves_lines"
geometry_field = "wkb_geometry"
geometry_type = "MULTILINESTRING"
srid = 3857
buffer_size = 0
simplify = true
query_limit = 1000
[[tileset.layer.query]]
# ne_50m_antarctic_ice_shelves_lines
minzoom = 3
maxzoom = 4
sql = """SELECT wkb_geometry, ogc_fid, min_zoom FROM ne_50m_antarctic_ice_shelves_lines WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""
[[tileset.layer.query]]
# ne_10m_antarctic_ice_shelves_lines
minzoom = 5
maxzoom = 10
sql = """SELECT wkb_geometry, ogc_fid, min_zoom FROM ne_10m_antarctic_ice_shelves_lines WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""

[[tileset.layer]]
name = "antarctic_ice_shelves_polys"
geometry_field = "wkb_geometry"
geometry_type = "MULTIPOLYGON"
srid = 3857
buffer_size = 1
simplify = true
query_limit = 1000
[[tileset.layer.query]]
# ne_50m_antarctic_ice_shelves_polys
minzoom = 3
maxzoom = 4
sql = """SELECT wkb_geometry, ogc_fid, min_zoom FROM ne_50m_antarctic_ice_shelves_polys WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""
[[tileset.layer.query]]
# ne_10m_antarctic_ice_shelves_polys
minzoom = 5
maxzoom = 10
sql = """SELECT wkb_geometry, ogc_fid, min_zoom FROM ne_10m_antarctic_ice_shelves_polys WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""

[[tileset.layer]]
name = "marine_polys"
geometry_field = "wkb_geometry"
geometry_type = "MULTIPOLYGON"
srid = 3857
make_valid = true
buffer_size = 1
simplify = true
query_limit = 1000
[[tileset.layer.query]]
# ne_110m_geography_marine_polys
minzoom = 0
maxzoom = 2
sql = """SELECT wkb_geometry, ogc_fid, name, min_label, max_label FROM ne_110m_geography_marine_polys WHERE min_label::integer <= !zoom! AND wkb_geometry && !bbox!"""
[[tileset.layer.query]]
# ne_50m_geography_marine_polys
minzoom = 3
maxzoom = 4
sql = """SELECT wkb_geometry, ogc_fid, name, min_label, max_label FROM ne_50m_geography_marine_polys WHERE min_label::integer <= !zoom! AND wkb_geometry && !bbox!"""
[[tileset.layer.query]]
# ne_10m_geography_marine_polys
minzoom = 5
maxzoom = 10
sql = """SELECT wkb_geometry, ogc_fid, name, min_label, max_label FROM ne_10m_geography_marine_polys WHERE min_label::integer <= !zoom! AND wkb_geometry && !bbox!"""

[[tileset.layer]]
name = "elevation_points"
geometry_field = "wkb_geometry"
geometry_type = "POINT"
srid = 3857
buffer_size = 0
simplify = true
query_limit = 1000
[[tileset.layer.query]]
# ne_50m_geography_regions_elevation_points
minzoom = 3
maxzoom = 4
sql = """SELECT wkb_geometry, ogc_fid, featurecla, name, elevation, min_zoom FROM ne_50m_geography_regions_elevation_points WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""
[[tileset.layer.query]]
# ne_10m_geography_regions_elevation_points
minzoom = 5
maxzoom = 10
sql = """SELECT wkb_geometry, ogc_fid, featurecla, name, elevation, min_zoom FROM ne_10m_geography_regions_elevation_points WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""

[[tileset.layer]]
name = "geography_regions_points"
geometry_field = "wkb_geometry"
geometry_type = "POINT"
srid = 3857
buffer_size = 0
simplify = true
query_limit = 1000
[[tileset.layer.query]]
# ne_10m_geography_regions_points
minzoom = 5
maxzoom = 10
sql = """SELECT wkb_geometry, ogc_fid, featurecla, name, min_zoom FROM ne_10m_geography_regions_points WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""

[[tileset.layer]]
name = "geography_regions_polys"
geometry_field = "wkb_geometry"
geometry_type = "MULTIPOLYGON"
srid = 3857
buffer_size = 1
simplify = true
query_limit = 1000
[[tileset.layer.query]]
# ne_110m_geography_regions_polys
minzoom = 0
maxzoom = 2
sql = """SELECT wkb_geometry, ogc_fid, featurecla, name, min_label, max_label FROM ne_110m_geography_regions_polys WHERE min_label::integer <= !zoom! AND wkb_geometry && !bbox!"""
[[tileset.layer.query]]
# ne_50m_geography_regions_polys
minzoom = 3
maxzoom = 4
sql = """SELECT wkb_geometry, ogc_fid, featurecla, name, min_label, max_label FROM ne_50m_geography_regions_polys WHERE min_label::integer <= !zoom! AND wkb_geometry && !bbox!"""
[[tileset.layer.query]]
# ne_10m_geography_regions_polys
minzoom = 5
maxzoom = 10
sql = """SELECT wkb_geometry, ogc_fid, featurecla, name, min_label, max_label FROM ne_10m_geography_regions_polys WHERE min_label::integer <= !zoom! AND wkb_geometry && !bbox!"""

[[tileset.layer]]
name = "rivers_lake_centerlines_scale_rank"
geometry_field = "wkb_geometry"
geometry_type = "MULTILINESTRING"
srid = 3857
buffer_size = 0
simplify = true
query_limit = 1000
[[tileset.layer.query]]
# ne_50m_rivers_lake_centerlines_scale_rank
minzoom = 3
maxzoom = 4
sql = """SELECT wkb_geometry, ogc_fid, featurecla, name, min_label, min_zoom, strokeweig FROM ne_50m_rivers_lake_centerlines_scale_rank WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""
[[tileset.layer.query]]
# ne_10m_rivers_lake_centerlines_scale_rank
minzoom = 5
maxzoom = 10
sql = """SELECT wkb_geometry, ogc_fid, featurecla, name, min_label, min_zoom, strokeweig FROM ne_10m_rivers_lake_centerlines_scale_rank WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""
[[tileset.layer]]
name = "rivers_north_america"
geometry_field = "wkb_geometry"
geometry_type = "MULTILINESTRING"
srid = 3857
buffer_size = 0
simplify = true
query_limit = 1000
[[tileset.layer.query]]
# ne_10m_rivers_north_america
minzoom = 5
maxzoom = 10
sql = """SELECT wkb_geometry, ogc_fid, featurecla, name, min_label, min_zoom, strokeweig FROM ne_10m_rivers_north_america WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""

[[tileset.layer]]
name = "rivers_europe"
geometry_field = "wkb_geometry"
geometry_type = "MULTILINESTRING"
srid = 3857
buffer_size = 0
simplify = true
query_limit = 1000
[[tileset.layer.query]]
# ne_10m_rivers_europe
minzoom = 5
maxzoom = 10
sql = """SELECT wkb_geometry, ogc_fid, featurecla, name, min_label, min_zoom, strokeweig FROM ne_10m_rivers_europe WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""

[[tileset.layer]]
name = "rivers_lake_centerlines"
geometry_field = "wkb_geometry"
geometry_type = "MULTILINESTRING"
srid = 3857
buffer_size = 0
simplify = true
query_limit = 1000
[[tileset.layer.query]]
# ne_110m_rivers_lake_centerlines
minzoom = 0
maxzoom = 2
sql = """SELECT wkb_geometry, ogc_fid, featurecla, name, min_label, min_zoom FROM ne_110m_rivers_lake_centerlines WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""
[[tileset.layer.query]]
# ne_50m_rivers_lake_centerlines
minzoom = 3
maxzoom = 4
sql = """SELECT wkb_geometry, ogc_fid, featurecla, name, min_label, min_zoom FROM ne_50m_rivers_lake_centerlines WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""
[[tileset.layer.query]]
# ne_10m_rivers_lake_centerlines
minzoom = 5
maxzoom = 10
sql = """SELECT wkb_geometry, ogc_fid, featurecla, name, min_label FROM ne_10m_rivers_lake_centerlines WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""

[[tileset.layer]]
name = "lakes_historic"
geometry_field = "wkb_geometry"
geometry_type = "MULTIPOLYGON"
srid = 3857
buffer_size = 1
simplify = true
query_limit = 1000
[[tileset.layer.query]]
# ne_10m_lakes_historic
minzoom = 5
maxzoom = 10
sql = """SELECT wkb_geometry, ogc_fid, featurecla, min_zoom FROM ne_10m_lakes_historic WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""

[[tileset.layer]]
name = "lakes"
geometry_field = "wkb_geometry"
geometry_type = "MULTIPOLYGON"
srid = 3857
buffer_size = 1
simplify = true
query_limit = 1000
[[tileset.layer.query]]
# ne_110m_lakes
minzoom = 0
maxzoom = 2
sql = """SELECT wkb_geometry, ogc_fid, featurecla, name, min_zoom, min_label FROM ne_110m_lakes WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""
[[tileset.layer.query]]
# ne_50m_lakes
minzoom = 3
maxzoom = 4
sql = """SELECT wkb_geometry, ogc_fid, featurecla, name, min_zoom, min_label FROM ne_50m_lakes WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""
[[tileset.layer.query]]
# ne_10m_lakes
minzoom = 5
maxzoom = 10
sql = """SELECT wkb_geometry, ogc_fid, featurecla, name, min_zoom, min_label FROM ne_10m_lakes WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""

[[tileset.layer]]
name = "lakes_north_america"
geometry_field = "wkb_geometry"
geometry_type = "MULTIPOLYGON"
srid = 3857
buffer_size = 1
simplify = true
query_limit = 1000
[[tileset.layer.query]]
# ne_10m_lakes_north_america
minzoom = 5
maxzoom = 10
sql = """SELECT wkb_geometry, ogc_fid, featurecla, name, min_zoom, min_label FROM ne_10m_lakes_north_america WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""

[[tileset.layer]]
name = "lakes_europe"
geometry_field = "wkb_geometry"
geometry_type = "MULTIPOLYGON"
srid = 3857
buffer_size = 1
simplify = true
query_limit = 1000
[[tileset.layer.query]]
# ne_10m_lakes_europe
minzoom = 5
maxzoom = 10
sql = """SELECT wkb_geometry, ogc_fid, featurecla, name, min_zoom, min_label FROM ne_10m_lakes_europe WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""

[[tileset.layer]]
name = "reefs"
geometry_field = "wkb_geometry"
geometry_type = "MULTILINESTRING"
srid = 3857
buffer_size = 0
simplify = true
query_limit = 1000
[[tileset.layer.query]]
# ne_10m_reefs
minzoom = 5
maxzoom = 10
sql = """SELECT wkb_geometry, ogc_fid, featurecla, min_zoom FROM ne_10m_reefs WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""

[[tileset.layer]]
name = "playas"
geometry_field = "wkb_geometry"
geometry_type = "MULTIPOLYGON"
srid = 3857
buffer_size = 1
simplify = true
query_limit = 1000
[[tileset.layer.query]]
# ne_10m_playas
minzoom = 5
maxzoom = 10
sql = """SELECT wkb_geometry, ogc_fid, featurecla, min_zoom, name FROM ne_10m_playas WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""

[[tileset.layer]]
name = "glaciated_areas"
geometry_field = "wkb_geometry"
geometry_type = "MULTIPOLYGON"
srid = 3857
make_valid = true
buffer_size = 1
simplify = true
query_limit = 1000
[[tileset.layer.query]]
# ne_110m_glaciated_areas
minzoom = 0
maxzoom = 2
sql = """SELECT wkb_geometry, ogc_fid, featurecla, min_zoom FROM ne_110m_glaciated_areas WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""
[[tileset.layer.query]]
# ne_50m_glaciated_areas
minzoom = 3
maxzoom = 4
sql = """SELECT wkb_geometry, ogc_fid, featurecla, min_zoom FROM ne_50m_glaciated_areas WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""
[[tileset.layer.query]]
# ne_10m_glaciated_areas
minzoom = 5
maxzoom = 10
sql = """SELECT wkb_geometry, ogc_fid, featurecla, min_zoom FROM ne_10m_glaciated_areas WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""

[[tileset.layer]]
name = "land"
geometry_field = "wkb_geometry"
geometry_type = "MULTIPOLYGON"
srid = 3857
make_valid = true
buffer_size = 1
simplify = false
query_limit = 1000
[[tileset.layer.query]]
# ne_110m_land
minzoom = 0
maxzoom = 2
sql = """SELECT wkb_geometry, ogc_fid, featurecla, min_zoom FROM ne_110m_land WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""
[[tileset.layer.query]]
# ne_50m_land
minzoom = 3
maxzoom = 4
sql = """SELECT wkb_geometry, ogc_fid, featurecla, min_zoom FROM ne_50m_land WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""
[[tileset.layer.query]]
# ne_10m_land
minzoom = 5
maxzoom = 10
#sql = """SELECT wkb_geometry, ogc_fid, featurecla, min_zoom FROM ne_10m_land WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""
sql = """SELECT ST_Multi(ST_Union(f.geom)) as wkb_geometry, featurecla, min_zoom FROM
         (SELECT (ST_Dump(wkb_geometry)).geom AS geom, featurecla, min_zoom FROM ne_10m_land_subdivided
          WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!
         ) AS f
         GROUP BY featurecla, min_zoom"""

[[tileset.layer]]
name = "minor_islands"
geometry_field = "wkb_geometry"
geometry_type = "MULTIPOLYGON"
srid = 3857
buffer_size = 1
simplify = true
query_limit = 1000
[[tileset.layer.query]]
# ne_10m_minor_islands
minzoom = 5
maxzoom = 10
sql = """SELECT wkb_geometry, ogc_fid, featurecla, min_zoom FROM ne_10m_minor_islands WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""

[[tileset.layer]]
name = "ocean"
geometry_field = "wkb_geometry"
geometry_type = "MULTIPOLYGON"
srid = 3857
buffer_size = 1
simplify = false
[[tileset.layer.query]]
# ne_110m_ocean
minzoom = 0
maxzoom = 2
sql = """SELECT wkb_geometry, ogc_fid, featurecla, min_zoom FROM ne_110m_ocean WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""
[[tileset.layer.query]]
# ne_50m_ocean
minzoom = 3
maxzoom = 4
#sql = """SELECT wkb_geometry, ogc_fid, featurecla, min_zoom FROM ne_50m_ocean WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""
sql = """SELECT ST_Multi(ST_Union(wkb_geometry)) as wkb_geometry, featurecla, min_zoom
         FROM ne_50m_ocean_subdivided
         WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!
         GROUP BY featurecla, min_zoom"""
[[tileset.layer.query]]
# ne_10m_ocean
minzoom = 5
maxzoom = 10
#sql = """SELECT wkb_geometry, ogc_fid, featurecla, min_zoom FROM ne_10m_ocean WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!"""
sql = """SELECT ST_Multi(ST_Union(wkb_geometry)) as wkb_geometry, featurecla, min_zoom
         FROM ne_10m_ocean_subdivided
         WHERE min_zoom::integer <= !zoom! AND wkb_geometry && !bbox!
         GROUP BY featurecla, min_zoom"""

[cache.file]
base = "/tmp/mvtcache"
baseurl = "http://example.com/tiles"

[webserver]
# Bind address. Use 0.0.0.0 to listen on all adresses.
bind = "127.0.0.1"
port = 6767
#cache_control_max_age = 43200

[[webserver.static]]
path = "/map"
dir = "./maps/"