units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
386 rows where ACCESS_TYP = 4 sorted by UNIT_NAME descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, LAYER, MNG_AG_LEV, PARK_URL, YR_EST, GAP_STS
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 13
- Santa Barbara, City of 12
- Save the Redwoods League 10
- San Joaquin River Parkway and Conservation Trust 8
- California State Lands Commission 7
- Sacramento, County of 7
- Riverside, County of 6
- Santa Barbara Flood Control and Water Conserv. District 4
- 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
- Sierra Foothill Conservancy 3
- Sacramento and San Joaquin Drainage District 3
- Wildlands Inc 3
- Northcoast Regional Land Trust 3
- Carpinteria, City of 2
- 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
- …
DES_TP >30
- Local Other or Unknown 204
- Private Conservation 52
- State Other or Unknown 18
- Local Recreation Area 16
- Local Conservation Area 11
- Private Other or Unknown 10
- State Resource Management Area 7
- Local Park 5
- National Monument or Landmark 3
- Recreation Management Area 1
- 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
- …
MNG_AG_TYP 15
- Open Space District 151
- Water District 55
- Non Profit - Land Trust 40
- County Agency 36
- City Agency 29
- State Agency 28
- Non Profit - Conservation 23
- Flood District 7
- Federal Agency 6
- 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 · 386 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3742 | 3742 | 3741 | {"type": "Polygon", "coordinates": [[[-117.25665, 33.25608], [-117.25376, 33.25609], [-117.24955, 33.25549], [-117.24981, 33.25449], [-117.25017, 33.25456], [-117.25354, 33.25499], [-117.25356, 33.25494], [-117.25383, 33.25496], [-117.25409, 33.25496], [-117.25448, 33.25494], [-117.25623, 33.25464], [-117.25665, 33.25608]]]} | Unknown Access 4 | 44862 | Zwierstra Mitigation Site | 27873 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | San Diego 4 | 19.59 | Zwierstra Mitigation Site | 0 | State Other or Unknown 104 | 4 | |
4260 | 4260 | 4259 | {"type": "Polygon", "coordinates": [[[-117.16445, 32.95224], [-117.16113, 32.95233], [-117.16099, 32.94848], [-117.16432, 32.94852], [-117.16445, 32.95224]]]} | Unknown Access 4 | 45284 | Zamudio TransNet Environmental Mitigation | 27854 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | San Diego 4 | 32.329 | Zamudio TransNet Environmental Mitigation | 0 | State Other or Unknown 104 | 4 | |
13391 | 13391 | 13390 | {"type": "Polygon", "coordinates": [[[-121.2718, 39.47467], [-121.27178, 39.47519], [-121.27125, 39.47519], [-121.27123, 39.47535], [-121.27078, 39.47536], [-121.27081, 39.47451], [-121.27119, 39.47444], [-121.27138, 39.47444], [-121.27154, 39.47449], [-121.2717, 39.47457], [-121.2718, 39.47467]]]} | Unknown Access 4 | 35494 | Yuba County Water Agency 9 | 27844 | 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.824 | Yuba County Water Agency 9 | 0 | Local Other or Unknown 14 | 4 | |
13462 | 13462 | 13461 | {"type": "Polygon", "coordinates": [[[-121.28629, 39.49959], [-121.28524, 39.49961], [-121.28526, 39.50057], [-121.28357, 39.49813], [-121.28627, 39.49819], [-121.28629, 39.49959]]]} | Unknown Access 4 | 35682 | Yuba County Water Agency 8 | 27843 | 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 | 8.198 | Yuba County Water Agency 8 | 0 | Local Other or Unknown 14 | 4 | |
3876 | 3876 | 3875 | {"type": "Polygon", "coordinates": [[[-121.28161, 39.49241], [-121.28087, 39.49553], [-121.27866, 39.49811], [-121.27864, 39.49743], [-121.27853, 39.49685], [-121.27851, 39.49655], [-121.27854, 39.4958], [-121.27841, 39.49547], [-121.27838, 39.4953], [-121.27916, 39.49462], [-121.27937, 39.49367], [-121.27955, 39.49218], [-121.27846, 39.49076], [-121.27957, 39.49017], [-121.28161, 39.49241]]]} | Unknown Access 4 | 35684 | Yuba County Water Agency 7 | 27842 | 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 | 30.672 | Yuba County Water Agency 7 | 0 | Local Other or Unknown 14 | 4 | |
13463 | 13463 | 13462 | {"type": "Polygon", "coordinates": [[[-121.27797, 39.49638], [-121.27764, 39.49672], [-121.27672, 39.49629], [-121.27702, 39.49592], [-121.27797, 39.49638]]]} | Unknown Access 4 | 35683 | Yuba County Water Agency 6 | 27841 | 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.137 | Yuba County Water Agency 6 | 0 | Local Other or Unknown 14 | 4 | |
13453 | 13453 | 13452 | {"type": "Polygon", "coordinates": [[[-121.27315, 39.48037], [-121.27315, 39.48143], [-121.2637, 39.48142], [-121.26368, 39.48036], [-121.27315, 39.48037]]]} | Unknown Access 4 | 35664 | Yuba County Water Agency 5 | 27840 | 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 | 23.618 | Yuba County Water Agency 5 | 0 | Local Other or Unknown 14 | 4 | |
3854 | 3854 | 3853 | {"type": "Polygon", "coordinates": [[[-121.27711, 39.49874], [-121.27703, 39.49881], [-121.27655, 39.499], [-121.27626, 39.49896], [-121.27605, 39.49886], [-121.27594, 39.49879], [-121.27626, 39.49835], [-121.27711, 39.49874]]]} | Unknown Access 4 | 35578 | Yuba County Water Agency 49 | 27839 | 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.0 | Yuba County Water Agency 49 | 0 | Local Other or Unknown 14 | 4 | |
3857 | 3857 | 3856 | {"type": "Polygon", "coordinates": [[[-121.27671, 39.49771], [-121.2765, 39.49801], [-121.27567, 39.49769], [-121.27565, 39.49761], [-121.27587, 39.49734], [-121.27671, 39.49771]]]} | Unknown Access 4 | 35587 | Yuba County Water Agency 48 | 27838 | 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.844 | Yuba County Water Agency 48 | 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 | |
14123 | 14123 | 14122 | {"type": "Polygon", "coordinates": [[[-121.05725, 39.43932], [-121.05664, 39.43942], [-121.05651, 39.44297], [-121.05471, 39.44295], [-121.05477, 39.43885], [-121.05507, 39.43835], [-121.05725, 39.43932]]]} | Unknown Access 4 | 43015 | Yuba County Water Agency 46 | 27836 | 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 | 18.833 | Yuba County Water Agency 46 | 0 | Local Other or Unknown 14 | 4 | |
14117 | 14117 | 14116 | {"type": "Polygon", "coordinates": [[[-121.16577, 39.37457], [-121.16513, 39.37558], [-121.16452, 39.37641], [-121.1639, 39.37703], [-121.16383, 39.37729], [-121.16389, 39.37774], [-121.16402, 39.37827], [-121.16399, 39.37875], [-121.16381, 39.3791], [-121.16377, 39.37947], [-121.1638, 39.37989], [-121.16386, 39.38032], [-121.16399, 39.38073], [-121.16413, 39.38139], [-121.1639, 39.3814], [-121.16378, 39.3809], [-121.16374, 39.38069], [-121.16358, 39.38027], [-121.16352, 39.37968], [-121.1635, 39.3792], [-121.16377, 39.37856], [-121.16377, 39.37819], [-121.16372, 39.37781], [-121.16355, 39.37726], [-121.1633, 39.37739], [-121.16275, 39.37757], [-121.16217, 39.37764], [-121.16158, 39.37759], [-121.16101, 39.37742], [-121.15901, 39.37666], [-121.15836, 39.37655], [-121.15853, 39.37624], [-121.15933, 39.37632], [-121.1612, 39.37703], [-121.16132, 39.37685], [-121.16196, 39.37706], [-121.16234, 39.37717], [-121.16282, 39.3772], [-121.16334, 39.37688], [-121.16362, 39.37662], [-121.16375, 39.37674], [-121.16393, 39.37657], [-121.16438, 39.376], [-121.16486, 39.37545], [-121.16529, 39.37484], [-121.16574, 39.37404], [-121.16577, 39.37457]]]} | Unknown Access 4 | 43014 | Yuba County Water Agency 45 | 27835 | 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 | 10.802 | Yuba County Water Agency 45 | 0 | Local Other or Unknown 14 | 4 | |
13739 | 13739 | 13738 | {"type": "Polygon", "coordinates": [[[-121.19544, 39.32953], [-121.19529, 39.3307], [-121.19482, 39.33058], [-121.19431, 39.33048], [-121.1939, 39.33048], [-121.1934, 39.3305], [-121.19293, 39.33057], [-121.19258, 39.33071], [-121.19237, 39.33083], [-121.19196, 39.33088], [-121.19188, 39.33092], [-121.19197, 39.3303], [-121.19287, 39.3302], [-121.19318, 39.33019], [-121.19385, 39.33006], [-121.19449, 39.32991], [-121.19501, 39.32976], [-121.19525, 39.32965], [-121.19544, 39.32953]]]} | Unknown Access 4 | 36233 | Yuba County Water Agency 44 | 27834 | 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 | 4.515 | Yuba County Water Agency 44 | 0 | Local Other or Unknown 14 | 4 | |
13979 | 13979 | 13978 | {"type": "Polygon", "coordinates": [[[-121.28906, 39.50662], [-121.28848, 39.50646], [-121.28784, 39.50624], [-121.2872, 39.50636], [-121.28646, 39.50697], [-121.28622, 39.50753], [-121.28542, 39.50752], [-121.28578, 39.50712], [-121.28621, 39.50655], [-121.28666, 39.50577], [-121.28667, 39.50497], [-121.28663, 39.5039], [-121.28656, 39.50322], [-121.28624, 39.50282], [-121.28582, 39.50266], [-121.28531, 39.50266], [-121.28525, 39.50023], [-121.28866, 39.50015], [-121.2887, 39.50107], [-121.28777, 39.50109], [-121.28785, 39.50189], [-121.28782, 39.50258], [-121.28772, 39.5031], [-121.28775, 39.50357], [-121.28759, 39.50433], [-121.28746, 39.50478], [-121.28755, 39.50521], [-121.28791, 39.50559], [-121.28843, 39.50576], [-121.28904, 39.50584], [-121.28906, 39.50662]]]} | Unknown Access 4 | 36648 | Yuba County Water Agency 43 | 27833 | 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 | 30.302 | Yuba County Water Agency 43 | 0 | Local Other or Unknown 14 | 4 | |
13379 | 13379 | 13378 | {"type": "Polygon", "coordinates": [[[-121.27563, 39.49942], [-121.27246, 39.50161], [-121.27156, 39.50224], [-121.27495, 39.498], [-121.27524, 39.498], [-121.27482, 39.49898], [-121.27563, 39.49942]]]} | Unknown Access 4 | 35468 | Yuba County Water Agency 42 | 27832 | 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 | 8.399 | Yuba County Water Agency 42 | 0 | Local Other or Unknown 14 | 4 | |
13446 | 13446 | 13445 | {"type": "Polygon", "coordinates": [[[-121.28866, 39.50015], [-121.28525, 39.50023], [-121.28524, 39.49961], [-121.28629, 39.49959], [-121.28863, 39.49951], [-121.28866, 39.50015]]]} | Unknown Access 4 | 35640 | Yuba County Water Agency 41 | 27831 | 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 | 5.006 | Yuba County Water Agency 41 | 0 | Local Other or Unknown 14 | 4 | |
3869 | 3869 | 3868 | {"type": "Polygon", "coordinates": [[[-121.28986, 39.50148], [-121.28872, 39.50152], [-121.28863, 39.49951], [-121.28976, 39.49949], [-121.28986, 39.50148]]]} | Unknown Access 4 | 35639 | Yuba County Water Agency 40 | 27830 | 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 | 5.364 | Yuba County Water Agency 40 | 0 | Local Other or Unknown 14 | 4 | |
13451 | 13451 | 13450 | {"type": "Polygon", "coordinates": [[[-121.28536, 39.46045], [-121.28531, 39.46143], [-121.28411, 39.46143], [-121.28411, 39.46113], [-121.28423, 39.46099], [-121.28459, 39.46073], [-121.28498, 39.46026], [-121.28536, 39.46045]]]} | Unknown Access 4 | 35663 | Yuba County Water Agency 4 | 27829 | 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 | 2.361 | Yuba County Water Agency 4 | 0 | Local Other or Unknown 14 | 4 | |
3583 | 3583 | 3582 | {"type": "Polygon", "coordinates": [[[-121.28103, 39.50008], [-121.27996, 39.49892], [-121.27995, 39.49806], [-121.28102, 39.49808], [-121.28103, 39.50008]]]} | Unknown Access 4 | 36690 | Yuba County Water Agency 39 | 27828 | 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 | 3.618 | Yuba County Water Agency 39 | 0 | Local Other or Unknown 14 | 4 | |
3868 | 3868 | 3867 | {"type": "Polygon", "coordinates": [[[-121.2878, 39.49075], [-121.28749, 39.49816], [-121.28627, 39.49819], [-121.27875, 39.49803], [-121.27866, 39.49811], [-121.2808, 39.49561], [-121.28207, 39.49531], [-121.28583, 39.49307], [-121.27774, 39.4835], [-121.28324, 39.48882], [-121.28684, 39.4861], [-121.28687, 39.49074], [-121.2878, 39.49075]]]} | Unknown Access 4 | 35638 | Yuba County Water Agency 38 | 27827 | 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 | 121.398 | Yuba County Water Agency 38 | 0 | Local Other or Unknown 14 | 4 |
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]);