units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
386 rows where ACCESS_TYP = 4
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Mountains Recreation and Conservation Authority 149
- Yuba County Water Agency 48
- National Audubon Society 23
- California Department of Transportation 15
- Santa Barbara, County of 12
- Santa Barbara, City of 10
- Save the Redwoods League 9
- San Joaquin River Parkway and Conservation Trust 8
- California State Lands Commission 7
- Sacramento, County of 7
- Riverside, County of 6
- Wilderness Land Trust 4
- California Wildlife Conservation Board 4
- North County Transit District 4
- Los Angeles, County of 3
- Monterey, County of 3
- Los Angeles, City of 3
- United States Fish and Wildlife Service 3
- Santa Barbara Flood Control and Water Conserv. District 3
- Sierra Foothill Conservancy 3
- Sacramento and San Joaquin Drainage District 3
- Wildlands Inc 3
- Northcoast Regional Land Trust 3
- Orange, County of 2
- Back Country Land Trust 2
- Ramona Municipal Water District 2
- San Diego, City of 1
- Fresno, City of 1
- United States Forest Service 1
- Monterey Peninsula Regional Park District 1
- …
DES_TP >30
- Local Other or Unknown 200
- Private Conservation 51
- State Other or Unknown 18
- Local Recreation Area 15
- Local Conservation Area 11
- Private Other or Unknown 10
- State Resource Management Area 7
- Local Park 5
- National Monument or Landmark 3
- Private Recreation or Education 1
- Local Resource Management Area 1
- Federal Other or Unknown 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 15
- Open Space District 151
- Water District 55
- Non Profit - Land Trust 39
- County Agency 35
- State Agency 28
- City Agency 26
- Non Profit - Conservation 23
- Flood District 6
- Federal Agency 5
- Transportation Agency 4
- Mitigation Bank 3
- Recreation/Parks District 1
- County Agency - Parks 1
- Irrigation District 1
- Non Profit - Other 1
ACCESS_TYP 1
- Unknown Access · 379 ✖
Link | rowid ▼ | id | map | 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1208 | 1208 | 1207 | {"type": "Polygon", "coordinates": [[[-118.6372, 34.36427], [-118.62414, 34.36475], [-118.62394, 34.35736], [-118.63275, 34.35717], [-118.63292, 34.36076], [-118.63708, 34.36067], [-118.6372, 34.36427]]]} | Unknown Access 4 | 8425 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 201.929 | 0 | Local Other or Unknown 14 | 4 | ||
1273 | 1273 | 1272 | {"type": "Polygon", "coordinates": [[[-118.21161, 34.50894], [-118.21051, 34.50893], [-118.21051, 34.50802], [-118.2116, 34.50803], [-118.21161, 34.50894]]]} | Unknown Access 4 | 9563 | Red Rover Mine TaxDef | 24228 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 2.509 | Red Rover Mine TaxDef | None 110 | |||
1412 | 1412 | 1411 | {"type": "Polygon", "coordinates": [[[-119.67034, 34.43903], [-119.67034, 34.4395], [-119.66917, 34.4395], [-119.66941, 34.43903], [-119.67034, 34.43903]]]} | Unknown Access 4 | 36486 | Santa Barbara holding 9 | 25051 | 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 | 1.234 | Santa Barbara holding 9 | 0 | Local Other or Unknown 14 | 4 | |
1584 | 1584 | 1583 | {"type": "Polygon", "coordinates": [[[-117.09349, 33.56898], [-117.0926, 33.57066], [-117.08388, 33.57076], [-117.08394, 33.56909], [-117.09349, 33.56898]]]} | Unknown Access 4 | 12140 | French Valley Conservation Area, Expansion 1 | 19108 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 38.849 | French Valley Conservation Area, Expansion 1 | None 128 | |||
1681 | 1681 | 1680 | {"type": "Polygon", "coordinates": [[[-117.56495, 33.66821], [-117.5606, 33.66822], [-117.56061, 33.67181], [-117.55625, 33.67183], [-117.55624, 33.66465], [-117.56493, 33.66461], [-117.56495, 33.66821]]]} | Unknown Access 4 | 12688 | Trabuco Canyon Water District lands | 26502 | 2166 | Trabuco Canyon Water District 406 | Special District 4 | Water District 13 | http://www.tcwd.ca.gov/ | Special District 4 | 2166 | Trabuco Canyon Water District 400 | Special District 4 | Water District 13 | Orange 3 | 119.276 | Trabuco Canyon Water District lands | None 135 | |||
1986 | 1986 | 1985 | {"type": "Polygon", "coordinates": [[[-119.79036, 36.76947], [-119.78888, 36.76947], [-119.78887, 36.7687], [-119.78891, 36.76869], [-119.78909, 36.7686], [-119.79, 36.76854], [-119.79001, 36.76798], [-119.79035, 36.76797], [-119.79036, 36.76947]]]} | Unknown Access 4 | 15187 | Ratcliffe Stadium | 24192 | 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.753 | Ratcliffe Stadium | None 158 | |||
2134 | 2134 | 2133 | {"type": "Polygon", "coordinates": [[[-121.32208, 36.402], [-121.32178, 36.40221], [-121.32097, 36.40256], [-121.31938, 36.40316], [-121.31871, 36.40382], [-121.31838, 36.40545], [-121.318, 36.40469], [-121.31752, 36.40383], [-121.31755, 36.40364], [-121.31762, 36.40347], [-121.31775, 36.40326], [-121.31788, 36.40313], [-121.3181, 36.40297], [-121.31862, 36.40285], [-121.31927, 36.40262], [-121.31975, 36.40242], [-121.32168, 36.40147], [-121.32188, 36.40139], [-121.32208, 36.402]]]} | Unknown Access 4 | 17419 | Los Coches Adobe | 21512 | 1336 | Soledad, City of 485 | City 2 | City Agency 2 | http://www.cityofsoledad.com/ | City 2 | 1336 | Soledad, City of 476 | City 2 | City Agency 2 | Monterey 14 | 10.355 | Los Coches Adobe | None 173 | |||
2239 | 2239 | 2238 | {"type": "Polygon", "coordinates": [[[-119.81102, 36.87326], [-119.80959, 36.87329], [-119.8096, 36.87351], [-119.81007, 36.87379], [-119.81022, 36.87384], [-119.81101, 36.87381], [-119.81092, 36.88017], [-119.80915, 36.88029], [-119.80178, 36.8809], [-119.79911, 36.88089], [-119.80337, 36.87899], [-119.80477, 36.87934], [-119.80542, 36.8792], [-119.8063, 36.87931], [-119.8063, 36.8783], [-119.80622, 36.87802], [-119.80565, 36.87825], [-119.80549, 36.8785], [-119.80516, 36.87785], [-119.79392, 36.8778], [-119.79337, 36.87782], [-119.79334, 36.87681], [-119.79332, 36.8768], [-119.7933, 36.87682], [-119.79325, 36.87549], [-119.79577, 36.8744], [-119.80082, 36.87025], [-119.80215, 36.86845], [-119.80261, 36.86797], [-119.80445, 36.86616], [-119.80599, 36.86497], [-119.80929, 36.86355], [-119.80935, 36.86353], [-119.81041, 36.86422], [-119.81111, 36.86607], [-119.81102, 36.87326]]]} | Unknown Access 4 | 16693 | Van Buren Unit | 26820 | 2345 | Tehachapi-Cummings County Water District 499 | Special District 4 | Water District 13 | http://tccwd.com/ | Special District 4 | 3069 | San Joaquin River Parkway and Conservation Trust 491 | Non Profit 6 | Non Profit - Land Trust 10 | Madera 48 | 433.198 | Van Buren Unit | None 186 | |||
2390 | 2390 | 2389 | {"type": "Polygon", "coordinates": [[[-118.71787, 34.45684], [-118.71569, 34.45684], [-118.71568, 34.46041], [-118.71122, 34.4604], [-118.70698, 34.46033], [-118.70695, 34.45676], [-118.70268, 34.45668], [-118.70267, 34.45669], [-118.70272, 34.46026], [-118.69843, 34.46019], [-118.6982, 34.45301], [-118.70692, 34.45318], [-118.70696, 34.44953], [-118.71123, 34.44959], [-118.71339, 34.44958], [-118.71341, 34.45326], [-118.71611, 34.45327], [-118.71787, 34.45684]]]} | Unknown Access 4 | 11474 | Holser Canyon Open Space | 29737 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 345.8 | Holser Canyon OS | 0 | Local Recreation Area 3 | 4 | |
2581 | 2581 | 2580 | {"type": "Polygon", "coordinates": [[[-119.66557, 34.42181], [-119.6652, 34.42296], [-119.66446, 34.42284], [-119.66145, 34.42302], [-119.66143, 34.42284], [-119.66412, 34.42212], [-119.66557, 34.42181]]]} | Unknown Access 4 | 17913 | Montecity Country Club | 22411 | 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 | 6.027 | Montecity Country Club | 0 | Local Recreation Area 3 | 4 | |
2752 | 2752 | 2751 | {"type": "Polygon", "coordinates": [[[-121.26584, 38.41176], [-121.26406, 38.41179], [-121.26392, 38.41155], [-121.26373, 38.41107], [-121.26365, 38.41082], [-121.2645, 38.41003], [-121.26465, 38.41], [-121.26491, 38.41005], [-121.26516, 38.4102], [-121.26531, 38.41033], [-121.2654, 38.41046], [-121.26549, 38.41072], [-121.26554, 38.41094], [-121.26582, 38.41152], [-121.26584, 38.41165], [-121.26584, 38.41176]]]} | Unknown Access 4 | 21481 | Green Rd Subdivision Map | 19466 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 6.621 | Green Rd Subdivision Map | None 230 | |||
2876 | 2876 | 2875 | {"type": "Polygon", "coordinates": [[[-121.25202, 38.40904], [-121.25157, 38.40901], [-121.25157, 38.40891], [-121.25154, 38.40884], [-121.25164, 38.40866], [-121.25175, 38.40863], [-121.25192, 38.40869], [-121.25202, 38.40883], [-121.25202, 38.40904]]]} | Unknown Access 4 | 22243 | Schnabel Tentative Parcel Map | 25185 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 0.366 | Schnabel Tentative Parcel Map | None 240 | |||
3158 | 3158 | 3157 | {"type": "Polygon", "coordinates": [[[-121.08887, 38.32906], [-121.08872, 38.32997], [-121.0886, 38.33024], [-121.08831, 38.33059], [-121.08712, 38.33171], [-121.0868, 38.33162], [-121.08621, 38.33112], [-121.08608, 38.33088], [-121.08604, 38.33063], [-121.08614, 38.33054], [-121.08636, 38.33047], [-121.08658, 38.3303], [-121.08671, 38.33014], [-121.08694, 38.32905], [-121.08887, 38.32906]]]} | Unknown Access 4 | 21825 | Smud | 25577 | 2129 | Sacramento Municipal Utility District 591 | Special District 4 | Water District 13 | http://www.smud.org/ | Special District 4 | 2129 | Sacramento Municipal Utility District 581 | Special District 4 | Water District 13 | Sacramento 41 | 10.95 | Smud | None 258 | |||
3438 | 3438 | 3437 | {"type": "Polygon", "coordinates": [[[-121.27738, 39.49699], [-121.277, 39.49737], [-121.27617, 39.49697], [-121.2765, 39.49657], [-121.27738, 39.49699]]]} | Unknown Access 4 | 35476 | Yuba County Water Agency 3 | 27818 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 1.144 | Yuba County Water Agency 3 | 0 | Local Other or Unknown 14 | 4 | |
3457 | 3457 | 3456 | {"type": "Polygon", "coordinates": [[[-121.27854, 39.49693], [-121.27778, 39.49658], [-121.27854, 39.4958], [-121.27851, 39.49654], [-121.27854, 39.49693]]]} | Unknown Access 4 | 35580 | Yuba County Water Agency 47 | 27837 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 0.973 | Yuba County Water Agency 47 | 0 | Local Other or Unknown 14 | 4 | |
3465 | 3465 | 3464 | {"type": "Polygon", "coordinates": [[[-121.27748, 39.49831], [-121.27736, 39.49848], [-121.27711, 39.49873], [-121.27626, 39.49834], [-121.27659, 39.49789], [-121.27748, 39.49831]]]} | Unknown Access 4 | 35637 | Yuba County Water Agency 14 | 27802 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 1.259 | Yuba County Water Agency 14 | 0 | Local Other or Unknown 14 | 4 | |
3478 | 3478 | 3477 | {"type": "Polygon", "coordinates": [[[-116.10126, 34.74073], [-116.10125, 34.74791], [-116.09285, 34.74777], [-116.09283, 34.74063], [-116.10126, 34.74073]]]} | Unknown Access 4 | 25830 | Wilderness Land Trust | 27510 | 3097 | Wilderness Land Trust 603 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.wildernesslandtrust.org/ | Non Governmental Organization 10 | 3097 | Wilderness Land Trust 592 | Non Profit 6 | Non Profit - Land Trust 10 | San Bernardino 22 | 151.196 | Wilderness Land Trust | 0 | Private Conservation 16 | 2 | |
3480 | 3480 | 3479 | {"type": "Polygon", "coordinates": [[[-118.84904, 38.00675], [-118.84899, 38.01037], [-118.8444, 38.01038], [-118.84445, 38.00676], [-118.84904, 38.00675]]]} | Unknown Access 4 | 25838 | Wilderness Land Trust | 27510 | 3097 | Wilderness Land Trust 603 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.wildernesslandtrust.org/ | Non Governmental Organization 10 | 3097 | Wilderness Land Trust 592 | Non Profit 6 | Non Profit - Land Trust 10 | Mono 32 | 40.043 | Wilderness Land Trust | 0 | Private Conservation 16 | 2 | |
3494 | 3494 | 3493 | {"type": "Polygon", "coordinates": [[[-119.92013, 36.84814], [-119.9201, 36.84889], [-119.91933, 36.84892], [-119.91621, 36.84954], [-119.91557, 36.84957], [-119.91467, 36.84879], [-119.91115, 36.8488], [-119.91115, 36.85122], [-119.91068, 36.85129], [-119.91054, 36.85133], [-119.90847, 36.8513], [-119.90649, 36.85002], [-119.90733, 36.84921], [-119.90775, 36.84888], [-119.90795, 36.84855], [-119.90816, 36.84837], [-119.90879, 36.848], [-119.90911, 36.84784], [-119.90954, 36.8475], [-119.90997, 36.84724], [-119.91042, 36.84702], [-119.91072, 36.84679], [-119.91172, 36.8464], [-119.91209, 36.84619], [-119.91244, 36.84606], [-119.91285, 36.84585], [-119.91314, 36.84576], [-119.91372, 36.84572], [-119.91435, 36.84574], [-119.91473, 36.84573], [-119.91559, 36.84561], [-119.91563, 36.84814], [-119.92013, 36.84814]]]} | Unknown Access 4 | 25925 | Schneider Property | 25187 | 3069 | San Joaquin River Parkway and Conservation Trust 649 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.riverparkway.org | Non Governmental Organization 10 | 3069 | San Joaquin River Parkway and Conservation Trust 491 | Non Profit 6 | Non Profit - Land Trust 10 | Madera 48 | 77.528 | Schneider Property | 0 | Private Conservation 16 | 2 | |
3511 | 3511 | 3510 | {"type": "Polygon", "coordinates": [[[-118.29463, 35.66527], [-118.29017, 35.6658], [-118.29016, 35.66338], [-118.29462, 35.66337], [-118.29463, 35.66527]]]} | Unknown Access 4 | 36102 | National Audubon Society 4 | 22654 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Kern 36 | 23.993 | Nat. Audubon Society 4 | 0 | Private Conservation 16 | 2 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, 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_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);