indexes.yml

# A goal with the indexes is to have them general-purpose enough to not need
# frequent changing with stylesheet changes, but to be usable with many
# versions, and potentially other styles.

point:
  # The point table is small, but so are the partial indexes
  place:
    where: place IS NOT NULL
  water_barrier:
    where: waterway IN ('dam', 'weir', 'lock_gate', 'waterfall')
  barrier_entrance:
    where: barrier IN ('entrance')
  trees:
    where: ("natural" IN ('tree', 'shrub'))
line:
  name:
    where: name IS NOT NULL
  ferry:
    where: route = 'ferry'
  river:
    where: waterway = 'river'
  water_barrier:
    where: waterway IN ('dam', 'weir', 'lock_gate')
  tree_rows:
    where: ("natural" = 'tree_row' OR barrier = 'hedge')
polygon:
  # The polygon table is by far the largest, and generally the slowest
  name:
    where: name IS NOT NULL
  nobuilding:
    where: building IS NULL
  military:
    where: landuse = 'military'
  water:
    # The indentation here makes sense in the SQL output
    where: |-
      waterway IN ('dock', 'riverbank', 'canal')
          OR landuse IN ('reservoir', 'basin')
          OR "natural" IN ('water', 'glacier')
  way_area_z6:
    where: way_area > 59750
  water_barrier:
    where: waterway IN ('dam', 'weir', 'lock_gate')
roads:
  # The roads table only has a subset of data, so it's just got some low-zoom
  # indexes and some fairly selective ones for high zoom
  admin_low:
    where: boundary = 'administrative' AND admin_level IN ('0', '1', '2', '3', '4')
  admin:
    where: boundary = 'administrative'
  roads_ref:
    where: highway IS NOT NULL AND ref IS NOT NULL