Data Dictionary

Column Type Label Description
id int4

Parks, Forestry and Recreation Unique Identifier of the parent asset

asset_id int4

Parks, Forestry and Recreation Unique Identifier of the asset

location text

Name of the parent asset

alternative_name text

Is comprised of the name of the parent asset and a descriptor of the location

type text

Drinking Water Fountain, Bottle Filling Station, Dog Fountain

location_details text

A detailed description of where to find the asset

url text

A link to the webpage of the parent asset

address text

Street address of the park, where the drinking water source is located.

PostedDate timestamp

Date status was posted

AssetName text

This asset's name

Reason text

Reason for a particular status

Comments text

Open field for comments on this asset

Status text
  • 0 = closed
  • 1 = open
  • 2 = service alert
geometry text

Additional Information

Field Value
Data last updated June 12, 2024
Metadata last updated May 9, 2025
Created June 12, 2024
Format GeoJSON
License License not specified
Datastore activeTrue
Datastore cache{'CSV': {'4326': '68c4058e-14ed-47e1-b00b-58caaa1fc8d9', '2952': 'a2fb7dc7-f705-45df-a9af-7946e579c1a8'}, 'SHP': {'4326': '3f60d9f7-5d8e-4898-a474-eac79faa2b8a', '2952': 'e98cd44a-8988-445d-9f0b-c8e7be09ca4b'}, 'GPKG': {'4326': '47e6865d-2a7d-4a64-8a11-11a596f7ff20', '2952': '012bb99a-9121-4a30-b100-4864d7476576'}, 'GEOJSON': {'4326': '328b3a18-9c21-4a3a-b0b7-0016e1cf1776'}}
Datastore cache last update3 hours ago
Extract jobAirflow: Integration Pipeline parks-drinking-fountains
Has viewsTrue
Id446a7745-78fb-4e37-b6c8-71f9967e09eb
Is previewTrue
Package idf614d4d3-594a-4f78-8473-faaa17269c67
Position8
Stateactive
Url typedatastore
Extract Job Airflow: Integration Pipeline parks-drinking-fountains
Is Datastore Cache File?
Datastore Cache
  1. CSV
  2. SHP
  3. GPKG
  4. GEOJSON
Datastore Cache Last Updated
Datastore resource's ID