mirror of
https://github.com/gravitystorm/openstreetmap-carto.git
synced 2025-09-24 09:32:54 +02:00
50 lines
2.1 KiB
SQL
50 lines
2.1 KiB
SQL
-- These are indexes for rendering performance with OpenStreetMap Carto.
|
|
-- This file is generated with scripts/indexes.py
|
|
|
|
CREATE INDEX planet_osm_line_ferry
|
|
ON planet_osm_line USING GIST (way)
|
|
WHERE route = 'ferry' AND osm_id > 0;
|
|
CREATE INDEX planet_osm_line_label
|
|
ON planet_osm_line USING GIST (way)
|
|
WHERE name IS NOT NULL OR ref IS NOT NULL;
|
|
CREATE INDEX planet_osm_line_river
|
|
ON planet_osm_line USING GIST (way)
|
|
WHERE waterway = 'river';
|
|
CREATE INDEX planet_osm_line_waterway
|
|
ON planet_osm_line USING GIST (way)
|
|
WHERE waterway IN ('river', 'canal', 'stream', 'drain', 'ditch');
|
|
CREATE INDEX planet_osm_point_place
|
|
ON planet_osm_point USING GIST (way)
|
|
WHERE place IS NOT NULL AND name IS NOT NULL;
|
|
CREATE INDEX planet_osm_polygon_admin
|
|
ON planet_osm_polygon USING GIST (ST_PointOnSurface(way))
|
|
WHERE name IS NOT NULL AND boundary = 'administrative' AND admin_level IN ('0', '1', '2', '3', '4');
|
|
CREATE INDEX planet_osm_polygon_military
|
|
ON planet_osm_polygon USING GIST (way)
|
|
WHERE (landuse = 'military' OR military = 'danger_area') AND building IS NULL;
|
|
CREATE INDEX planet_osm_polygon_name
|
|
ON planet_osm_polygon USING GIST (ST_PointOnSurface(way))
|
|
WHERE name IS NOT NULL;
|
|
CREATE INDEX planet_osm_polygon_nobuilding
|
|
ON planet_osm_polygon USING GIST (way)
|
|
WHERE building IS NULL;
|
|
CREATE INDEX planet_osm_polygon_water
|
|
ON planet_osm_polygon USING GIST (way)
|
|
WHERE waterway IN ('dock', 'riverbank', 'canal')
|
|
OR landuse IN ('reservoir', 'basin')
|
|
OR "natural" IN ('water', 'glacier');
|
|
CREATE INDEX planet_osm_polygon_way_area_z10
|
|
ON planet_osm_polygon USING GIST (way)
|
|
WHERE way_area > 23300;
|
|
CREATE INDEX planet_osm_polygon_way_area_z6
|
|
ON planet_osm_polygon USING GIST (way)
|
|
WHERE way_area > 5980000;
|
|
CREATE INDEX planet_osm_roads_admin
|
|
ON planet_osm_roads USING GIST (way)
|
|
WHERE boundary = 'administrative';
|
|
CREATE INDEX planet_osm_roads_admin_low
|
|
ON planet_osm_roads USING GIST (way)
|
|
WHERE boundary = 'administrative' AND admin_level IN ('0', '1', '2', '3', '4');
|
|
CREATE INDEX planet_osm_roads_roads_ref
|
|
ON planet_osm_roads USING GIST (way)
|
|
WHERE highway IS NOT NULL AND ref IS NOT NULL;
|