CPAD_2020a_Units

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

10,394 rows where AGNCY_LEV = 2

View and edit SQL

Suggested facets: ACCESS_TYP, MNG_AG_LEV, MNG_AG_TYP, GAP_STS

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
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>
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>
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>
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>
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>
20 Open Access 1 77 Aurora Park 15710 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 0.447 Aurora Park 0 Local Park 2 4 <Binary data: 148 bytes>
21 Open Access 1 60 Bigby VIlla Park 16097 1114 Fresno, City of 14 City 2 City Agency 2 http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm City 2 1114 Fresno, City of 14 City 2 City Agency 2   Fresno 9 3.426 Bigby VIlla Park 0 Local Park 2 4 <Binary data: 212 bytes>
22 Open Access 1 17469 City of Moreno Valley Open Space 6975 1216 Moreno Valley, City of 15 City 2 City Agency 2 http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml City 2 1216 Moreno Valley, City of 15 City 2 City Agency 2   Riverside 10 471.264 City of Moreno Valley OS 0 Local Recreation Area 3 4 <Binary data: 10415 bytes>
25 Open Access 1 89 Colina Del Sol Community Park 17497 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 29.899 Colina Del Sol Community Park 0 Local Park 2 4 <Binary data: 452 bytes>
26 Open Access 1 78 El Marino Park 18512 1075 Culver City, City of 18 City 2 City Agency 2 http://www.culvercity.org/Home/Government/PRCS City 2 1075 Culver City, City of 18 City 2 City Agency 2   Los Angeles 6 1.645 El Marino Park 0 Local Park 2 4 <Binary data: 164 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 1465.772ms · Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette