CPAD_2020a_SuperUnits

Table actions

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

10,210 rows where MNG_AG_TYP = 2

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
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: 9,024 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: 3,828 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: 1,412 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>
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: 3,220 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: 1,226 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>
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: 1,044 bytes>
20 Open Access 1 Sweetwater Heights Park http://www.nationalcityca.gov/government/community-services/facilities 31841 1219 National City, City of 49 City 2 City Agency 2 http://www.ci.national-city.ca.us/index.aspx?page=152 City 2 2.268 Sweetwater Heights Park   <Binary: 180 bytes>
21 Restricted Access 2 Abraham Lincoln High School Park   31843 1188 Los Angeles, City of 24 City 2 City Agency 2 http://lacity.org/ City 2 3.473 Abraham Lincoln High School Park   <Binary: 260 bytes>
24 Open Access 1 Antigua Park   15519 1391 Murrieta, City of 326 City 2 City Agency 2 http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA City 2 2.282 Antigua Park   <Binary: 228 bytes>
26 Open Access 1 Wildwood Canyon Park http://www.burbankca.gov/departments/park-recreation-and-community-services/parks-facilities/wildwood-canyon-park 760 1038 Burbank, City of 135 City 2 City Agency 2 http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities City 2 586.796 Wildwood Canyon Park   <Binary: 2,292 bytes>
28 Open Access 1 Egret Park Open Space   18469 1287 Sacramento, City of 534 City 2 City Agency 2 http://portal.cityofsacramento.org/ParksandRec City 2 3.603 Egret Park OS   <Binary: 212 bytes>
29 Open Access 1 El Dorado Open Space Park   18503 1279 Riverside, City of 185 City 2 City Agency 2 http://www.riversideca.gov/park_rec/ City 2 8.445 El Dorado OS Park   <Binary: 810 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]);