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)
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
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]);