Data license:
Creative Commons Attribution
·
Data source:
GreenInfo Network
·
About:
simonw/calands-datasette
17,068 rows
✎ View and edit SQL
This data as json, copyable, CSV (advanced)
Suggested facets: LAYER
GAP_STS
✖
- 4 13,582
- 2 1,612
- 3 473
- 1 7
id ▼
|
ACCESS_TYP
|
UNIT_ID
|
UNIT_NAME
|
SUID_NMA
|
AGNCY_ID
|
AGNCY_NAME
|
AGNCY_LEV
|
AGNCY_TYP
|
AGNCY_WEB
|
LAYER
|
MNG_AG_ID
|
MNG_AGENCY
|
MNG_AG_LEV
|
MNG_AG_TYP
|
PARK_URL
|
COUNTY
|
ACRES
|
LABEL_NAME
|
YR_EST
|
DES_TP
|
GAP_STS
|
geometry
|
0 |
Open Access 1 |
21483 |
BLM |
16162 |
102 |
United States Bureau of Land Management 1 |
Federal 1 |
Federal Agency 1 |
http://www.blm.gov/wo/st/en.html |
US Bureau of Land Management 1 |
102 |
United States Bureau of Land Management 1 |
Federal 1 |
Federal Agency 1 |
|
San Luis Obispo 1 |
29770.057 |
BLM |
1899 |
National Public Lands 1 |
3 |
<Binary: 16589 bytes> |
1 |
Open Access 1 |
14 |
Oaklawn Memorial Park |
23029 |
1227 |
Oakdale, City of 2 |
City 2 |
City Agency 2 |
http://www.oakdalegov.com/#!recreation/c222d |
City 2 |
1227 |
Oakdale, City of 2 |
City 2 |
City Agency 2 |
|
Stanislaus 2 |
3.595 |
Oaklawn Memorial Park |
0 |
Local Park 2 |
4 |
<Binary: 132 bytes> |
2 |
Restricted Access 2 |
9 |
Oakdale Golf & Country Club |
32983 |
1227 |
Oakdale, City of 2 |
City 2 |
City Agency 2 |
http://www.oakdalegov.com/#!recreation/c222d |
City 2 |
1227 |
Oakdale, City of 2 |
City 2 |
City Agency 2 |
|
Stanislaus 2 |
137.317 |
Oakdale Golf & Country Club |
0 |
Local Recreation Area 3 |
4 |
<Binary: 1160 bytes> |
3 |
Restricted Access 2 |
24 |
Stanley Wakefield Wilderness Area |
25790 |
1227 |
Oakdale, City of 2 |
City 2 |
City Agency 2 |
http://www.oakdalegov.com/#!recreation/c222d |
City 2 |
1227 |
Oakdale, City of 2 |
City 2 |
City Agency 2 |
|
Stanislaus 2 |
57.379 |
Stanley Wakefield Wilderness Area |
0 |
Local Conservation Area 4 |
2 |
<Binary: 420 bytes> |
4 |
Open Access 1 |
25 |
Eisenhower Park |
18475 |
1329 |
Seal Beach, City of 3 |
City 2 |
City Agency 2 |
http://www.sealbeachca.gov/living/community/facilities/ |
City 2 |
1329 |
Seal Beach, City of 3 |
City 2 |
City Agency 2 |
|
Orange 3 |
1.46 |
Eisenhower Park |
0 |
Local Park 2 |
4 |
<Binary: 327 bytes> |
5 |
Open Access 1 |
26 |
Azalea Neighborhood Park |
30115 |
1297 |
San Diego, City of 4 |
City 2 |
City Agency 2 |
http://www.sandiego.gov/park-and-recreation/ |
City 2 |
1297 |
San Diego, City of 4 |
City 2 |
City Agency 2 |
|
San Diego 4 |
9.138 |
Azalea Neighborhood Park |
0 |
Local Park 2 |
4 |
<Binary: 938 bytes> |
6 |
Open Access 1 |
28 |
Richard Vessey Park |
24328 |
327 |
Santa Cruz, County of 5 |
County 3 |
County Agency 3 |
http://www.scparks.com/ |
County 3 |
327 |
Santa Cruz, County of 5 |
County 3 |
County Agency 3 |
|
Santa Cruz 5 |
0.46 |
Richard Vessey Park |
0 |
Local Park 2 |
4 |
<Binary: 180 bytes> |
7 |
Open Access 1 |
30 |
El Barrio Park |
18477 |
1057 |
Claremont, City of 6 |
City 2 |
City Agency 2 |
http://www.ci.claremont.ca.us/ps.leisurerecreation.cfm?ID=1709 |
City 2 |
1057 |
Claremont, City of 6 |
City 2 |
City Agency 2 |
|
Los Angeles 6 |
2.099 |
El Barrio Park |
0 |
Local Park 2 |
4 |
<Binary: 228 bytes> |
8 |
Open Access 1 |
36 |
Rincon Beach Park |
24367 |
325 |
Santa Barbara, County of 7 |
County 3 |
County Agency 3 |
http://cosb.countyofsb.org/parks/ |
County 3 |
325 |
Santa Barbara, County of 7 |
County 3 |
County Agency 3 |
|
Santa Barbara 7 |
11.623 |
Rincon Beach Park |
0 |
Local Park 2 |
4 |
<Binary: 340 bytes> |
9 |
Open Access 1 |
31 |
47th Street Canyon |
15202 |
1297 |
San Diego, City of 4 |
City 2 |
City Agency 2 |
http://www.sandiego.gov/park-and-recreation/ |
City 2 |
1297 |
San Diego, City of 4 |
City 2 |
City Agency 2 |
|
San Diego 4 |
9.994 |
47th Street Canyon |
0 |
Local Recreation Area 3 |
4 |
<Binary: 756 bytes> |
10 |
Open Access 1 |
46738 |
Butterfly Mini-Park |
30187 |
1297 |
San Diego, City of 4 |
City 2 |
City Agency 2 |
http://www.sandiego.gov/park-and-recreation/ |
City 2 |
1297 |
San Diego, City of 4 |
City 2 |
City Agency 2 |
|
San Diego 4 |
3.079 |
Butterfly Mini-Park |
0 |
Local Park 2 |
4 |
<Binary: 340 bytes> |
11 |
Open Access 1 |
48 |
Rios Caledonia Adobe |
24392 |
323 |
San Luis Obispo, County of 8 |
County 3 |
County Agency 3 |
http://www.slocountyparks.com/ |
County 3 |
323 |
San Luis Obispo, County of 8 |
County 3 |
County Agency 3 |
|
San Luis Obispo 1 |
3.26 |
Rios Caledonia Adobe |
|
None 5 |
|
<Binary: 180 bytes> |
12 |
Open Access 1 |
49 |
William Meyer Park |
27553 |
1227 |
Oakdale, City of 2 |
City 2 |
City Agency 2 |
http://www.oakdalegov.com/#!recreation/c222d |
City 2 |
1227 |
Oakdale, City of 2 |
City 2 |
City Agency 2 |
|
Stanislaus 2 |
0.233 |
William Meyer Park |
0 |
Local Park 2 |
4 |
<Binary: 132 bytes> |
13 |
Open Access 1 |
42 |
Rincon Park |
24369 |
1320 |
Santa Cruz, City of 9 |
City 2 |
City Agency 2 |
http://www.cityofsantacruz.com/departments/parks-recreation |
City 2 |
1320 |
Santa Cruz, City of 9 |
City 2 |
City Agency 2 |
|
Santa Cruz 5 |
0.055 |
Rincon Park |
0 |
Local Park 2 |
4 |
<Binary: 132 bytes> |
14 |
Open Access 1 |
43 |
William A. Fish Veterans Memorial Park |
27537 |
1227 |
Oakdale, City of 2 |
City 2 |
City Agency 2 |
http://www.oakdalegov.com/#!recreation/c222d |
City 2 |
1227 |
Oakdale, City of 2 |
City 2 |
City Agency 2 |
|
Stanislaus 2 |
3.803 |
William A. Fish Veterans Memorial Park |
0 |
Local Park 2 |
4 |
<Binary: 196 bytes> |
15 |
Open Access 1 |
66 |
Ambercot Park |
15443 |
1248 |
Patterson, City of 10 |
City 2 |
City Agency 2 |
http://www.ci.patterson.ca.us/ |
City 2 |
1248 |
Patterson, City of 10 |
City 2 |
City Agency 2 |
|
Stanislaus 2 |
4.088 |
Ambercot Park |
0 |
Local Park 2 |
4 |
<Binary: 180 bytes> |
16 |
Open Access 1 |
56 |
El Dorado Park |
18505 |
1169 |
Lancaster, City of 11 |
City 2 |
City Agency 2 |
http://www.cityoflancasterca.org/index.aspx?page=23 |
City 2 |
1169 |
Lancaster, City of 11 |
City 2 |
City Agency 2 |
|
Los Angeles 6 |
5.137 |
El Dorado Park |
0 |
Local Park 2 |
4 |
<Binary: 196 bytes> |
17 |
Open Access 1 |
58 |
Borchard Park |
16277 |
2025 |
Conejo Recreation and Park District 12 |
Special District 4 |
Recreation/Parks District 4 |
http://www.crpd.org/ |
Special District 4 |
2025 |
Conejo Recreation and Park District 12 |
Special District 4 |
Recreation/Parks District 4 |
|
Ventura 8 |
27.263 |
Borchard Park |
0 |
Local Park 2 |
4 |
<Binary: 212 bytes> |
18 |
Open Access 1 |
46740 |
Dry Creek Mini-Park |
30190 |
1297 |
San Diego, City of 4 |
City 2 |
City Agency 2 |
http://www.sandiego.gov/park-and-recreation/ |
City 2 |
1297 |
San Diego, City of 4 |
City 2 |
City Agency 2 |
|
San Diego 4 |
1.479 |
Dry Creek Mini-Park |
0 |
Local Park 2 |
4 |
<Binary: 244 bytes> |
19 |
Open Access 1 |
76 |
River Park |
24419 |
1373 |
Watsonville, City of 13 |
City 2 |
City Agency 2 |
http://cityofwatsonville.org/parks-community-services |
City 2 |
1373 |
Watsonville, City of 13 |
City 2 |
City Agency 2 |
|
Santa Cruz 5 |
1.349 |
River Park |
0 |
Local Park 2 |
4 |
<Binary: 132 bytes> |
Next page
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]);