CPAD_2020a_Units

Table actions

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

1,203 rows where ACCESS_TYP = 2

This data as json, geojson, copyable, CSV (advanced)

Suggested facets: AGNCY_TYP, 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
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: 1,160 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: 420 bytes>
62 Restricted Access 2 21943 San Francisco Watershed Water 24890 321 San Francisco - Public Utilities Commission, City and County of 31 County 3 County Agency - Other 9 http://sfwater.org/ County 3 321 San Francisco - Public Utilities Commission, City and County of 30 County 3 County Agency - Other 8   San Mateo 15 1251.272 San Francisco Watershed Water 1930 None 9   <Binary: 8,855 bytes>
124 Restricted Access 2 315 Russell Research Station (UC) 24744 217 University of California 53 State 5 State Agency 5 http://nrs.ucop.edu/ Other State 5 217 University of California 51 State 5 State Agency 5   Contra Costa 12 247.32 Russell Research Station (UC)   None 17   <Binary: 1,444 bytes>
151 Restricted Access 2 398 Channel Islands National Park 14200 198 United States Department of Defense 61 Federal 1 Federal Agency 1 http://www.defense.gov/ US Military/Defense 11 108 United States National Park Service 59 Federal 1 Federal Agency 1 http://www.nps.gov/chis/index.htm Santa Barbara 7 9515.241 Channel Islands NP 1980 National Park 18 2 <Binary: 24,004 bytes>
170 Restricted Access 2 543 Santa Cruz Island Reserve 25080 3091 The Nature Conservancy 63 Non Profit 6 Non Profit - Land Trust 10 http://www.nature.org/ Non Governmental Organization 10 3091 The Nature Conservancy 61 Non Profit 6 Non Profit - Land Trust 10   Santa Barbara 7 46928.685 Santa Cruz Island Reserve 1978 Private Conservation 16 2 <Binary: 45,668 bytes>
176 Restricted Access 2 492 Santa Barbara Golf Club 32988 1317 Santa Barbara, City of 26 City 2 City Agency 2 http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp City 2 1317 Santa Barbara, City of 26 City 2 City Agency 2   Santa Barbara 7 110.039 Santa Barbara Golf Club 0 Local Recreation Area 3 4 <Binary: 484 bytes>
204 Restricted Access 2 555 Santa Lucia Preserve 25093 3071 Santa Lucia Conservancy 84 Non Profit 6 Non Profit - Land Trust 10 http://www.slconservancy.org/ Non Governmental Organization 10 3071 Santa Lucia Conservancy 82 Non Profit 6 Non Profit - Land Trust 10   Monterey 14 5266.011 Santa Lucia Preserve 0 Private Conservation 16 2 <Binary: 16,996 bytes>
220 Restricted Access 2 604 SCWA 25221 2156 Sonoma County Water Agency 90 Special District 4 Water District 13 http://www.scwa.ca.gov/ Special District 4 2156 Sonoma County Water Agency 88 Special District 4 Water District 13   Sonoma 16 783.197 SCWA 0 None 24   <Binary: 45,088 bytes>
226 Restricted Access 2 616 Hetch Hetchy Water and Power 19888 321 San Francisco - Public Utilities Commission, City and County of 31 County 3 County Agency - Other 9 http://sfwater.org/ County 3 321 San Francisco - Public Utilities Commission, City and County of 30 County 3 County Agency - Other 8   Tuolumne 21 2706.955 Hetch Hetchy Water and Power   None 25   <Binary: 8,815 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: 874 bytes>
266 Restricted Access 2 907 Dry Creek Preserve 18285 3076 Sequoia Riverlands Trust 109 Non Profit 6 Non Profit - Land Trust 10 http://www.sequoiariverlands.org Non Governmental Organization 10 3076 Sequoia Riverlands Trust 106 Non Profit 6 Non Profit - Land Trust 10   Tulare 29 142.711 Dry Creek Preserve 2004 Private Conservation 16 2 <Binary: 212 bytes>
279 Restricted Access 2 956 South Monterey Dunes 25664 1330 Seaside, City of 115 City 2 City Agency 2 http://www.ci.seaside.ca.us/index.aspx?page=313 City 2 1330 Seaside, City of 112 City 2 City Agency 2   Monterey 14 0.07 South Monterey Dunes   None 30   <Binary: 148 bytes>
339 Restricted Access 2 933 Lewis Hill Preserve 21191 3076 Sequoia Riverlands Trust 109 Non Profit 6 Non Profit - Land Trust 10 http://www.sequoiariverlands.org Non Governmental Organization 10 3076 Sequoia Riverlands Trust 106 Non Profit 6 Non Profit - Land Trust 10   Tulare 29 107.649 Lewis Hill Preserve 1994 Private Conservation 16 2 <Binary: 372 bytes>
343 Restricted Access 2 941 Snell Valley Wildflower Preserve 25581 3035 Land Trust of Napa County 140 Non Profit 6 Non Profit - Land Trust 10 http://www.napalandtrust.org/ Non Governmental Organization 10 3035 Land Trust of Napa County 137 Non Profit 6 Non Profit - Land Trust 10   Napa 11 278.025 Snell Valley Wildflower Preserve 0 Private Conservation 16 2 <Binary: 484 bytes>
346 Restricted Access 2 953 George Manooshian Park 29754 2312 Glendora Unified School District 141 Special District 4 School District 14 http://www.glendora.k12.ca.us/ Special District 4 1120 Glendora, City of 74 City 2 City Agency 2   Los Angeles 6 18.865 George Manooshian Park 0 Local Park 2 4 <Binary: 276 bytes>
355 Restricted Access 2 982 Sonoma Baylands 25608 100 United States Army Corps of Engineers 146 Federal 1 Federal Agency 1 http://www.usace.army.mil/ Other Federal 13 100 United States Army Corps of Engineers 142 Federal 1 Federal Agency 1   Sonoma 16 37.517 Sonoma Baylands   None 36   <Binary: 388 bytes>
401 Restricted Access 2 1556 Springville Ecological Reserve 25751 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/ California Department of Fish and Wildlife 6 201 California Department of Fish and Wildlife 25 State 5 State Agency 5   Tulare 29 4.947 Springville ER 0 State Conservation Area 8 2 <Binary: 180 bytes>
441 Restricted Access 2 1381 Tor House 26411 3008 Big Sur Land Trust 173 Non Profit 6 Non Profit - Land Trust 10 http://www.bigsurlandtrust.org Non Governmental Organization 10 3008 Big Sur Land Trust 169 Non Profit 6 Non Profit - Land Trust 10   Monterey 14 0.129 Tor House 0 Private Conservation 16 2 <Binary: 164 bytes>
466 Restricted Access 2 921 Grass Lake Wildlife Area 19448 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/ California Department of Fish and Wildlife 6 201 California Department of Fish and Wildlife 25 State 5 State Agency 5   Siskiyou 28 44.169 Grass Lake Wildlife Area 0 State Conservation Area 8 2 <Binary: 404 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]);