CPAD_2020a_Units

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

1,263 rows where AGNCY_TYP = 3

View and edit SQL

Suggested facets: ACCESS_TYP, MNG_AG_LEV, MNG_AG_TYP, YR_EST, 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
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>
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>
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>
23 Open Access 1 62 Atlantic Avenue Park 15674 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 305 Los Angeles, County of 16 County 3 County Agency 3   Los Angeles 6 1.951 Atlantic Avenue Park 0 Local Park 2 4 <Binary data: 260 bytes>
30 Open Access 1 80 River Park 24416 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 123.418 River Park 0 Local Park 2 4 <Binary data: 516 bytes>
41 Open Access 1 97 Roach Canyon Park 24474 310 Monterey, County of 23 County 3 County Agency 3 http://www.co.monterey.ca.us/parks/ County 3 310 Monterey, County of 23 County 3 County Agency 3   Monterey 14 15.0 Roach Canyon Park 0 Local Park 2 4 <Binary data: 244 bytes>
127 Open Access 1 394 San Miguel Community Park 24955 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.196 San Miguel Community Park 0 Local Park 2 4 <Binary data: 196 bytes>
132 Unknown Access 4 414 San Roque Creek 24990 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 0.477 San Roque Creek 0 Local Other or Unknown 14 4 <Binary data: 260 bytes>
141 Open Access 1 446 Sand and Surf County Park 25009 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 13.006 Sand and Surf County Park 0 Local Park 2 4 <Binary data: 330 bytes>
143 Open Access 1 363 Brommer Park 16416 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 7.663 Brommer Park 0 Local Park 2 4 <Binary data: 228 bytes>
159 Open Access 1 409 San Miguel Staging Area Park 24961 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 1.605 San Miguel Staging Area Park 0 Local Park 2 4 <Binary data: 132 bytes>
200 Open Access 1 539 Santa Cruz Gardens Park 25063 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 1.786 Santa Cruz Gardens Park 0 Local Park 2 4 <Binary data: 244 bytes>
215 Open Access 1 691 Scott Park 25203 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 4.268 Scott Park 0 Local Park 2 4 <Binary data: 212 bytes>
222 Open Access 1 610 Santa Rosa Park 25134 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 24.322 Santa Rosa Park 0 Local Park 2 4 <Binary data: 596 bytes>
233 Open Access 1 752 Pixley Park 23756 330 Tulare, County of 96 County 3 County Agency 3 http://www.tularecounty.ca.gov/cao/index.cfm/general-services/parks-and-recreation/county-parks/ County 3 330 Tulare, County of 94 County 3 County Agency 3   Tulare 29 19.73 Pixley Park 0 Local Park 2 4 <Binary data: 180 bytes>
251 Open Access 1 702 Alpaugh Park 15404 330 Tulare, County of 96 County 3 County Agency 3 http://www.tularecounty.ca.gov/cao/index.cfm/general-services/parks-and-recreation/county-parks/ County 3 330 Tulare, County of 94 County 3 County Agency 3   Tulare 29 3.313 Alpaugh Park 0 Local Park 2 4 <Binary data: 132 bytes>
253 Open Access 1 704 Seaside Gardens County Park 25250 319 San Diego, County of 104 County 3 County Agency 3 http://www.sandiegocounty.gov/parks/ County 3 319 San Diego, County of 101 County 3 County Agency 3   San Diego 4 0.15 Seaside Gardens County Park 0 Local Park 2 4 <Binary data: 148 bytes>
255 No Public Access 3 845 Mason Wildlife Refuge 21944 319 San Diego, County of 104 County 3 County Agency 3 http://www.sandiegocounty.gov/parks/ County 3 319 San Diego, County of 101 County 3 County Agency 3   San Diego 4 353.869 Mason Wildlife Refuge 0 Local Conservation Area 4 2 <Binary data: 276 bytes>
256 Open Access 1 715 Bartlett Park 15842 330 Tulare, County of 96 County 3 County Agency 3 http://www.tularecounty.ca.gov/cao/index.cfm/general-services/parks-and-recreation/county-parks/ County 3 330 Tulare, County of 94 County 3 County Agency 3   Tulare 29 141.958 Bartlett Park 0 Local Park 2 4 <Binary data: 596 bytes>
261 Restricted Access 2 733 Kings River Nature Preserve 20663 330 Tulare, County of 96 County 3 County Agency 3 http://www.tularecounty.ca.gov/cao/index.cfm/general-services/parks-and-recreation/county-parks/ County 3 330 Tulare, County of 94 County 3 County Agency 3   Tulare 29 86.678 Kings River Nature Preserve 0 Local Conservation Area 4 2 <Binary data: 874 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 475.105ms · Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette