CPAD_2020a_Units
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7 rows where MNG_AGENCY = 460
This data as json, geojson, copyable, CSV (advanced)
Suggested facets: DES_TP
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [CPAD_2020a_Units] (
[id] INTEGER PRIMARY KEY,
[ACCESS_TYP] INTEGER,
[UNIT_ID] INTEGER,
[UNIT_NAME] TEXT,
[SUID_NMA] INTEGER,
[AGNCY_ID] INTEGER,
[AGNCY_NAME] INTEGER,
[AGNCY_LEV] INTEGER,
[AGNCY_TYP] INTEGER,
[AGNCY_WEB] TEXT,
[LAYER] INTEGER,
[MNG_AG_ID] INTEGER,
[MNG_AGENCY] INTEGER,
[MNG_AG_LEV] INTEGER,
[MNG_AG_TYP] INTEGER,
[PARK_URL] TEXT,
[COUNTY] INTEGER,
[ACRES] FLOAT,
[LABEL_NAME] TEXT,
[YR_EST] INTEGER,
[DES_TP] INTEGER,
[GAP_STS] TEXT
, "geometry" GEOMETRY,
FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]),
FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]),
FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]),
FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]),
FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]),
FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]),
FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]),
FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]),
FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]),
FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id])
);
CREATE INDEX [idx_CPAD_2020a_Units_DES_TP]
ON [CPAD_2020a_Units] ([DES_TP]);
CREATE INDEX [idx_CPAD_2020a_Units_COUNTY]
ON [CPAD_2020a_Units] ([COUNTY]);
CREATE INDEX [idx_CPAD_2020a_Units_MNG_AG_TYP]
ON [CPAD_2020a_Units] ([MNG_AG_TYP]);
CREATE INDEX [idx_CPAD_2020a_Units_MNG_AG_LEV]
ON [CPAD_2020a_Units] ([MNG_AG_LEV]);
CREATE INDEX [idx_CPAD_2020a_Units_MNG_AGENCY]
ON [CPAD_2020a_Units] ([MNG_AGENCY]);
CREATE INDEX [idx_CPAD_2020a_Units_LAYER]
ON [CPAD_2020a_Units] ([LAYER]);
CREATE INDEX [idx_CPAD_2020a_Units_AGNCY_TYP]
ON [CPAD_2020a_Units] ([AGNCY_TYP]);
CREATE INDEX [idx_CPAD_2020a_Units_AGNCY_LEV]
ON [CPAD_2020a_Units] ([AGNCY_LEV]);
CREATE INDEX [idx_CPAD_2020a_Units_AGNCY_NAME]
ON [CPAD_2020a_Units] ([AGNCY_NAME]);
CREATE INDEX [idx_CPAD_2020a_Units_ACCESS_TYP]
ON [CPAD_2020a_Units] ([ACCESS_TYP]);