CPAD_2020a_SuperUnits

Table actions

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

15,638 rows

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: ACCESS_TYP, LAYER

MNG_AG_LEV 8 ✖

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
0 Open Access 1 Kern River Parkway Park http://www.bakersfieldcity.us/recreation/Kern_River_Parkway.htm 425 1019 Bakersfield, City of 244 City 2 City Agency 2 http://www.bakersfieldcity.us/recreation/ City 2 1162.384 Kern River Parkway Park 0 <Binary: 9024 bytes>
1 Open Access 1 Deer Canyon Park http://www.anaheim.net/comm_svc/parks/parkDetail.asp?dir=park_deer_canyon_preserve 129 1006 Anaheim, City of 57 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 287.621 Deer Canyon Park   <Binary: 3828 bytes>
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: 1412 bytes>
3 Open Access 1 Modini Mayacamas Preserves http://egret.org/visit_modini_mayacamas 383 3005 Audubon Canyon Ranch 814 Non Profit 6 Non Profit - Conservation 12 http://www.egret.org Non Governmental Organization 10 1279.161 Modini Mayacamas Preserves   <Binary: 964 bytes>
4 Open Access 1 Kennedy Gardens Large   33476 1451 Calexico, City of 596 City 2 City Agency 2 http://www.calexicorecreation.org/parks City 2 4.156 Kennedy Gardens Large   <Binary: 228 bytes>
5 Open Access 1 Vintage Meadows Park   33477 1059 Cloverdale, City of 404 City 2 City Agency 2 http://www.cloverdale.net/index.aspx?nid=152 City 2 3.513 Vintage Meadows Park   <Binary: 196 bytes>
6 Open Access 1 Wright's Field   399 3007 Back Country Land Trust 148 Non Profit 6 Non Profit - Land Trust 10 http://www.bclt.org/ Non Governmental Organization 10 231.174 Wright's Field   <Binary: 695 bytes>
7 Open Access 1 Water Dog Lake Canyon http://www.belmont.gov/Home/Components/FacilityDirectory/FacilityDirectory/10/702 534 1025 Belmont, City of 194 City 2 City Agency 2 http://www.belmont.gov/city-hall/park-and-recreation City 2 276.47 Water Dog Lake Canyon 1975 <Binary: 3220 bytes>
8 Restricted Access 2 Dayton Heights Elementary School Park   31937 2361 Los Angeles Unified School District 605 Special District 4 School District 21 http://home.lausd.net/ Special District 4 0.517 Dayton Heights Elementary School Park   <Binary: 132 bytes>
9 Open Access 1 Asby Park   15644 1208 Modesto, City of 510 City 2 City Agency 2 http://www.modestogov.com/prnd/ City 2 0.745 Asby Park   <Binary: 228 bytes>
10 Open Access 1 McKegney Green   31739 1348 Tiburon, Town of 477 City 2 City Agency 2 http://www.ci.tiburon.ca.us/ City 2 11.486 McKegney Green   <Binary: 436 bytes>
11 Open Access 1 Richardson Bay Lineal Park   31740 1348 Tiburon, Town of 477 City 2 City Agency 2 http://www.ci.tiburon.ca.us/ City 2 11.346 Richardson Bay Lineal Park   <Binary: 1226 bytes>
12 Open Access 1 South of the Knoll Park   31741 1348 Tiburon, Town of 477 City 2 City Agency 2 http://www.ci.tiburon.ca.us/ City 2 6.521 South of the Knoll Park   <Binary: 356 bytes>
13 Open Access 1 Cucamonga/Demens Creek Trail Rest https://www.cityofrc.us/cityhall/cs/parks/trails/cucamonga.asp 31742 1263 Rancho Cucamonga, City of 192 City 2 City Agency 2 http://www.cityofrc.us/cityhall/cs/parks/default.asp City 2 0.299 Cucamonga/Demens Creek Trail Rest   <Binary: 132 bytes>
14 Open Access 1 Highlands Subdivision Open Space   31738 1348 Tiburon, Town of 477 City 2 City Agency 2 http://www.ci.tiburon.ca.us/ City 2 3.056 Highlands Subdivision OS   <Binary: 180 bytes>
15 Open Access 1 30th Street Mini Park   15192 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 0.23 30th Street MP   <Binary: 132 bytes>
16 Open Access 1 Skyline Wilderness Park http://www.skylinepark.org/ 835 2268 Napa County Regional Park and Open Space District 108 Special District 4 Recreation/Parks District 4 http://napaoutdoors.org/ Special District 4 1021.301 Skyline Wilderness Park 1983 <Binary: 980 bytes>
17 Open Access 1 Blackie's Pasture   31743 1348 Tiburon, Town of 477 City 2 City Agency 2 http://www.ci.tiburon.ca.us/ City 2 15.478 Blackie's Pasture   <Binary: 1044 bytes>
18 Restricted Access 2 Captain Aaron J. Contreras Memorial Park   31744 6111 Paloma del Sol Homeowners Association 1070 Private 7 Home Owners Association 15 http://www.palomadelsol.net/ Private 14 9.172 Captain Aaron J. Contreras Memorial Park   <Binary: 644 bytes>
19 Restricted Access 2 Del Cerro Park   31745 6074 Home Owners Association - Unknown Name 629 Private 7 Home Owners Association 15   Private 14 4.766 Del Cerro Park   <Binary: 292 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]);