CPAD_2020a_Units

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

17,068 rows

View and edit SQL

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 data: 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 data: 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 data: 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 data: 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 data: 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 data: 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 data: 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 data: 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 data: 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 data: 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 data: 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 data: 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 data: 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 data: 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 data: 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 data: 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 data: 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 data: 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 data: 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 data: 132 bytes>

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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]);
Powered by Datasette · Query took 2555.794ms · Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette