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
|
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> |
22 |
Restricted Access 2 |
HOA Community Park |
|
31746 |
6064 |
Johnson Ranch Community Association 930 |
Private 7 |
Home Owners Association 15 |
|
Private 14 |
8.408 |
HOA Community Park |
|
<Binary: 1076 bytes> |
23 |
Restricted Access 2 |
HOA Open Space |
|
31747 |
6065 |
Winchester Owners Association 1107 |
Private 7 |
Home Owners Association 15 |
|
Private 14 |
3.838 |
HOA OS |
|
<Binary: 426 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> |
25 |
Open Access 1 |
Carpinteria State Beach |
http://www.parks.ca.gov/?page_id=599 |
1466 |
204 |
California Department of Parks and Recreation 47 |
State 5 |
State Agency 5 |
http://www.parks.ca.gov/ |
California Department of Parks and Recreation 9 |
58.152 |
Carpinteria SB |
1932 |
<Binary: 951 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: 2292 bytes> |
27 |
Open Access 1 |
Jackson Demonstration State Forest |
http://www.fire.ca.gov/resource_mgt/resource_mgt_stateforests_jackson.php |
1366 |
202 |
California Department of Forestry and Fire Protection 343 |
State 5 |
State Agency 5 |
http://www.fire.ca.gov/ |
Other State 5 |
48726.392 |
Jackson DSF |
|
<Binary: 14992 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> |
30 |
Open Access 1 |
Encanto Expressway Open Space |
|
18635 |
1297 |
San Diego, City of 4 |
City 2 |
City Agency 2 |
http://www.sandiego.gov/park-and-recreation/ |
City 2 |
14.138 |
Encanto Expressway OS |
|
<Binary: 1935 bytes> |
31 |
Open Access 1 |
Islay Creek Open Space |
|
20283 |
1307 |
San Luis Obispo, City of 22 |
City 2 |
City Agency 2 |
http://www.slocity.org/parksandrecreation/index.asp |
City 2 |
3.151 |
Islay Creek OS |
|
<Binary: 612 bytes> |
32 |
Restricted Access 2 |
HOA Park |
|
31749 |
6074 |
Home Owners Association - Unknown Name 629 |
Private 7 |
Home Owners Association 15 |
|
Private 14 |
4.231 |
HOA Park |
|
<Binary: 714 bytes> |
33 |
Restricted Access 2 |
Oak Grove Park |
|
31754 |
6106 |
Lakeshore Homes Association 870 |
Private 7 |
Home Owners Association 15 |
http://lakeshorehomes.net/administration/parks-committee |
Private 14 |
4.178 |
Oak Grove Park |
|
<Binary: 692 bytes> |
34 |
Open Access 1 |
Bryce Edward Hanes Park |
|
31758 |
1293 |
San Bernardino, City of 163 |
City 2 |
City Agency 2 |
http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp |
City 2 |
2.453 |
Bryce Edward Hanes Park |
2017 |
<Binary: 228 bytes> |
35 |
Restricted Access 2 |
Comstock South LLC HOA |
|
31763 |
6120 |
Comstock South LLC 883 |
Private 7 |
Home Owners Association 15 |
|
Private 14 |
5.798 |
Comstock South LLC HOA |
|
<Binary: 612 bytes> |
36 |
Open Access 1 |
Frascati Trail |
|
31776 |
2080 |
Miraleste Recreation and Park District 885 |
Special District 4 |
Recreation/Parks District 4 |
https://www.rpvca.gov/ |
Special District 4 |
5.929 |
Frascati Trail |
|
<Binary: 794 bytes> |
37 |
Open Access 1 |
Sallee Park |
|
32819 |
1416 |
San Jacinto, City of 218 |
City 2 |
City Agency 2 |
http://www.ci.san-jacinto.ca.us/residents/parks.html |
City 2 |
5.326 |
Sallee Park |
|
<Binary: 132 bytes> |
38 |
Open Access 1 |
More Mesa Open Space |
|
22474 |
2141 |
Santa Barbara Flood Control and Water Conserv. District 45 |
Special District 4 |
Flood District 9 |
http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 |
Special District 4 |
13.534 |
More Mesa OS |
|
<Binary: 260 bytes> |
39 |
Open Access 1 |
Mount Clef Ridge Open Space - COSCA |
http://www.conejo-openspace.org/mt.-clef.html |
22524 |
2024 |
Conejo Open Space Conservation Agency 496 |
Special District 4 |
Open Space District 6 |
http://www.conejo-openspace.org/ |
Special District 4 |
181.73 |
Mount Clef Ridge OS - COSCA |
|
<Binary: 1499 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]);