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)

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

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