CPAD_2020a_SuperUnits

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

40 rows where MNG_AGENCY = 577

This data as json, geojson, copyable, CSV (advanced)

Suggested facets: ACCESS_TYP

id ▼ ACCESS_TYP PARK_NAME PARK_URL SUID_NMA MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP AGNCY_WEB LAYER ACRES LABEL_NAME YR_EST geometry
2 Open Access 1 Arcata Community Forest http://www.cityofarcata.org/departments/environmental-services/city-forests/trail-map 295 1432 Arcata, City of 577 City 2 City Agency 2 http://www.cityofarcata.org/rec City 2 636.027 Arcata Community Forest   <Binary: 1,412 bytes>
1209 Open Access 1 Arcata Plaza   15571 1432 Arcata, City of 577 City 2 City Agency 2 http://www.cityofarcata.org/rec City 2 1.009 Arcata Plaza   <Binary: 132 bytes>
1545 Open Access 1 Arcata Ball Park   15568 1432 Arcata, City of 577 City 2 City Agency 2 http://www.cityofarcata.org/rec City 2 4.155 Arcata Ball Park   <Binary: 308 bytes>
1546 Open Access 1 Arcata Community Park   15569 1432 Arcata, City of 577 City 2 City Agency 2 http://www.cityofarcata.org/rec City 2 30.41 Arcata Community Park   <Binary: 680 bytes>
1553 Open Access 1 Arcata Marsh & Wildlife Sanctuary   15570 1432 Arcata, City of 577 City 2 City Agency 2 http://www.cityofarcata.org/rec City 2 316.549 Arcata Marsh & Wildlife Sanctuary   <Binary: 4,996 bytes>
1844 Open Access 1 Bayside Park   15898 1432 Arcata, City of 577 City 2 City Agency 2 http://www.cityofarcata.org/rec City 2 4.741 Bayside Park   <Binary: 244 bytes>
2082 Open Access 1 Bloomfield Park   16169 1432 Arcata, City of 577 City 2 City Agency 2 http://www.cityofarcata.org/rec City 2 0.227 Bloomfield Park   <Binary: 132 bytes>
2477 Open Access 1 Cahill Park   16657 1432 Arcata, City of 577 City 2 City Agency 2 http://www.cityofarcata.org/rec City 2 0.726 Cahill Park   <Binary: 164 bytes>
2889 Open Access 1 Chevret-Vaissade Park   17186 1432 Arcata, City of 577 City 2 City Agency 2 http://www.cityofarcata.org/rec City 2 1.48 Chevret-Vaissade Park   <Binary: 308 bytes>
3401 Open Access 1 D Street Linear Park   17890 1432 Arcata, City of 577 City 2 City Agency 2 http://www.cityofarcata.org/rec City 2 1.238 D Street Linear Park   <Binary: 474 bytes>
4035 Open Access 1 Ennes Park   18680 1432 Arcata, City of 577 City 2 City Agency 2 http://www.cityofarcata.org/rec City 2 4.671 Ennes Park   <Binary: 292 bytes>
4740 Open Access 1 Greeniview Park   19481 1432 Arcata, City of 577 City 2 City Agency 2 http://www.cityofarcata.org/rec City 2 0.358 Greeniview Park   <Binary: 164 bytes>
6007 Open Access 1 Larson Park   21039 1432 Arcata, City of 577 City 2 City Agency 2 http://www.cityofarcata.org/rec City 2 2.178 Larson Park   <Binary: 340 bytes>
6126 Open Access 1 Mountain View Park   22560 1432 Arcata, City of 577 City 2 City Agency 2 http://www.cityofarcata.org/rec City 2 0.262 Mtn. View Park   <Binary: 164 bytes>
7849 Open Access 1 Pacific Union Park   23307 1432 Arcata, City of 577 City 2 City Agency 2 http://www.cityofarcata.org/rec City 2 4.152 Pacific Union Park   <Binary: 196 bytes>
8601 Open Access 1 Redwood Park   24251 1432 Arcata, City of 577 City 2 City Agency 2 http://www.cityofarcata.org/rec City 2 2.691 Redwood Park   <Binary: 359 bytes>
9026 Open Access 1 Rotary Park   24701 1432 Arcata, City of 577 City 2 City Agency 2 http://www.cityofarcata.org/rec City 2 0.278 Rotary Park   <Binary: 132 bytes>
9344 Open Access 1 Vinum Park   27151 1432 Arcata, City of 577 City 2 City Agency 2 http://www.cityofarcata.org/rec City 2 0.09 Vinum Park   <Binary: 132 bytes>
9579 Open Access 1 Shay Park   25378 1432 Arcata, City of 577 City 2 City Agency 2 http://www.cityofarcata.org/rec City 2 4.664 Shay Park   <Binary: 292 bytes>
9966 Open Access 1 Stewart Park   25847 1432 Arcata, City of 577 City 2 City Agency 2 http://www.cityofarcata.org/rec City 2 1.299 Stewart Park   <Binary: 324 bytes>

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE [CPAD_2020a_SuperUnits] (
   [id] INTEGER PRIMARY KEY,
   [ACCESS_TYP] INTEGER,
   [PARK_NAME] TEXT,
   [PARK_URL] TEXT,
   [SUID_NMA] INTEGER,
   [MNG_AG_ID] INTEGER,
   [MNG_AGENCY] INTEGER,
   [MNG_AG_LEV] INTEGER,
   [MNG_AG_TYP] INTEGER,
   [AGNCY_WEB] TEXT,
   [LAYER] INTEGER,
   [ACRES] FLOAT,
   [LABEL_NAME] TEXT,
   [YR_EST] INTEGER
, "geometry" GEOMETRY,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_CPAD_2020a_SuperUnits_LAYER]
    ON [CPAD_2020a_SuperUnits] ([LAYER]);
CREATE INDEX [idx_CPAD_2020a_SuperUnits_MNG_AG_TYP]
    ON [CPAD_2020a_SuperUnits] ([MNG_AG_TYP]);
CREATE INDEX [idx_CPAD_2020a_SuperUnits_MNG_AG_LEV]
    ON [CPAD_2020a_SuperUnits] ([MNG_AG_LEV]);
CREATE INDEX [idx_CPAD_2020a_SuperUnits_MNG_AGENCY]
    ON [CPAD_2020a_SuperUnits] ([MNG_AGENCY]);
CREATE INDEX [idx_CPAD_2020a_SuperUnits_ACCESS_TYP]
    ON [CPAD_2020a_SuperUnits] ([ACCESS_TYP]);