×

datastores:
  - name: postgresql
    id: vector-database-0
    host: pg
    user: postgres
    password: XXX
    database: postgres
layers:
  - id: historical_counties_by_year
    pattern: historical_counties_{year}
    paramValidator:
      "year": "^[0-9]{4}$"
    provider:
      name: postgismvt
      datastore: vector-database-0
      table: public.histcounties
      gid: id_num
      geometry: geom
      extent: 1024
      buffer: 0.25
      attributes:
        - "full_name"
      filter: "to_date({layer.year}, 'yyyy') BETWEEN start_date AND end_date"
      sourcesrid: 4326