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 146
- Yuba County Water Agency 45
- National Audubon Society 22
- California Department of Transportation 15
- Santa Barbara, County of 12
- Save the Redwoods League 9
- Santa Barbara, City of 8
- California State Lands Commission 7
- San Joaquin River Parkway and Conservation Trust 6
- Riverside, County of 5
- Sacramento, County of 5
- 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
- Wilderness Land Trust 2
- Ramona Municipal Water District 2
- San Diego, City of 1
- United States Forest Service 1
- Monterey Peninsula Regional Park District 1
- Carpinteria, City of 1
- …
DES_TP >30
- Local Other or Unknown 195
- Private Conservation 47
- State Other or Unknown 18
- Local Recreation Area 13
- 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 148
- Water District 50
- Non Profit - Land Trust 35
- County Agency 32
- State Agency 28
- City Agency 22
- Non Profit - Conservation 22
- 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 · 359 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
3723 | 3723 | 3722 | {"type": "Polygon", "coordinates": [[[-124.21314, 41.8682], [-124.213, 41.86893], [-124.21297, 41.86902], [-124.21287, 41.86916], [-124.21219, 41.86918], [-124.21116, 41.86925], [-124.21155, 41.8682], [-124.21314, 41.86807], [-124.21314, 41.8682]]]} | Unknown Access 4 | 44703 | Kellogg Beach | 20579 | 347 | Del Norte County Parks, County of 672 | County 3 | County Agency - Parks 7 | http://www.dnco.org/ | County 3 | 347 | Del Norte County Parks, County of 661 | County 3 | County Agency - Parks 7 | Del Norte 50 | 4.007 | Kellogg Beach | 0 | Local Park 2 | 4 | |
3735 | 3735 | 3734 | {"type": "MultiPolygon", "coordinates": [[[[-115.10406, 34.54508], [-115.08803, 34.54518], [-115.08805, 34.53083], [-115.08787, 34.53082], [-115.08786, 34.53069], [-115.08667, 34.53068], [-115.08667, 34.53042], [-115.10406, 34.53045], [-115.10406, 34.54508]]], [[[-115.12163, 34.51577], [-115.12163, 34.52303], [-115.12161, 34.53026], [-115.11284, 34.5303], [-115.10424, 34.53032], [-115.10424, 34.51581], [-115.12163, 34.51577]]], [[[-115.12164, 34.48689], [-115.12161, 34.50126], [-115.10425, 34.5013], [-115.10427, 34.48694], [-115.12164, 34.48689]]], [[[-115.12292, 34.54519], [-115.12277, 34.55666], [-115.10969, 34.55712], [-115.10968, 34.55726], [-115.10553, 34.55726], [-115.10557, 34.5452], [-115.12292, 34.54519]]]]} | Unknown Access 4 | 31017 | Native American Land Conservancy | 22662 | 3125 | Native American Land Conservancy 674 | Non Profit 6 | Non Profit - Land Trust 10 | http://nalc4all.org/ | Non Governmental Organization 10 | 3125 | Native American Land Conservancy 664 | Non Profit 6 | Non Profit - Land Trust 10 | San Bernardino 22 | 2369.21 | Native American Land Conservancy | 0 | Private Conservation 16 | 2 | |
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 | |
3753 | 3753 | 3752 | {"type": "Polygon", "coordinates": [[[-119.69543, 34.43397], [-119.69509, 34.43541], [-119.69424, 34.43536], [-119.69419, 34.43629], [-119.69257, 34.4363], [-119.69256, 34.43377], [-119.69278, 34.4335], [-119.6928, 34.43343], [-119.69302, 34.43324], [-119.69368, 34.43246], [-119.69391, 34.43263], [-119.69364, 34.43294], [-119.69351, 34.43319], [-119.69331, 34.43328], [-119.69335, 34.43335], [-119.69344, 34.43332], [-119.69346, 34.43333], [-119.69364, 34.43368], [-119.69373, 34.43372], [-119.69382, 34.43371], [-119.69382, 34.43374], [-119.69527, 34.43376], [-119.69515, 34.43396], [-119.69543, 34.43397]]]} | Unknown Access 4 | 467 | Santa Barbara Bowl | 25038 | 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 | 16.55 | Santa Barbara Bowl | None 315 | |||
3770 | 3770 | 3769 | {"type": "Polygon", "coordinates": [[[-121.40978, 39.0321], [-121.40886, 39.03318], [-121.40825, 39.0338], [-121.40801, 39.03396], [-121.40738, 39.03562], [-121.40691, 39.03607], [-121.40665, 39.03623], [-121.40644, 39.03625], [-121.40543, 39.03614], [-121.40505, 39.03582], [-121.40453, 39.0351], [-121.40393, 39.0349], [-121.40344, 39.03488], [-121.40287, 39.03514], [-121.4026, 39.03562], [-121.40242, 39.03625], [-121.40184, 39.0353], [-121.40342, 39.03459], [-121.40368, 39.03458], [-121.40502, 39.03496], [-121.40768, 39.03386], [-121.40806, 39.03357], [-121.40923, 39.03229], [-121.40961, 39.0318], [-121.40978, 39.0321]]]} | Unknown Access 4 | 472 | Dry Creek | 18279 | 2127 | Sacramento and San Joaquin Drainage District 681 | Special District 4 | Flood District 8 | Special District 4 | 2127 | Sacramento and San Joaquin Drainage District 671 | Special District 4 | Flood District 9 | Yuba 25 | 15.587 | Dry Creek | 0 | Local Other or Unknown 14 | 4 | ||
3783 | 3783 | 3782 | {"type": "Polygon", "coordinates": [[[-121.75364, 36.487], [-121.75279, 36.48783], [-121.7518, 36.48836], [-121.75076, 36.4881], [-121.75052, 36.48825], [-121.75067, 36.48844], [-121.7499, 36.48882], [-121.74643, 36.48407], [-121.74641, 36.484], [-121.74643, 36.48389], [-121.74641, 36.48383], [-121.74632, 36.48377], [-121.74621, 36.48377], [-121.74493, 36.48202], [-121.74586, 36.48073], [-121.75297, 36.48553], [-121.75243, 36.48657], [-121.75263, 36.48678], [-121.75293, 36.48659], [-121.75364, 36.487]]]} | Unknown Access 4 | 8686 | Condon | 17579 | 2085 | Monterey Peninsula Regional Park District 47 | Special District 4 | Recreation/Parks District 4 | http://www.mprpd.org/ | Special District 4 | 2085 | Monterey Peninsula Regional Park District 46 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 70.591 | Condon | None 317 | |||
3853 | 3853 | 3852 | {"type": "Polygon", "coordinates": [[[-121.27315, 39.48143], [-121.27314, 39.48349], [-121.26373, 39.48345], [-121.2637, 39.48142], [-121.27315, 39.48143]]]} | Unknown Access 4 | 35576 | Yuba County Water Agency 13 | 27801 | 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 | 45.633 | Yuba County Water Agency 13 | 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 | |
3866 | 3866 | 3865 | {"type": "Polygon", "coordinates": [[[-121.28772, 39.49953], [-121.28629, 39.49959], [-121.28627, 39.49819], [-121.28769, 39.49815], [-121.28772, 39.49953]]]} | Unknown Access 4 | 35635 | Yuba County Water Agency 18 | 27806 | 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.676 | Yuba County Water Agency 18 | 0 | Local Other or Unknown 14 | 4 | |
3867 | 3867 | 3866 | {"type": "Polygon", "coordinates": [[[-121.27862, 39.49732], [-121.27862, 39.49732], [-121.27803, 39.49771], [-121.27838, 39.49725], [-121.27858, 39.49713], [-121.27862, 39.49732]]]} | Unknown Access 4 | 35636 | Yuba County Water Agency 15 | 27803 | 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.215 | Yuba County Water Agency 15 | 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 | |
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 | |
3870 | 3870 | 3869 | {"type": "Polygon", "coordinates": [[[-121.27768, 39.49802], [-121.27748, 39.49831], [-121.27659, 39.49789], [-121.27678, 39.49762], [-121.27768, 39.49802]]]} | Unknown Access 4 | 35641 | Yuba County Water Agency 37 | 27826 | 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.772 | Yuba County Water Agency 37 | 0 | Local Other or Unknown 14 | 4 | |
3871 | 3871 | 3870 | {"type": "Polygon", "coordinates": [[[-121.2765, 39.49801], [-121.27626, 39.49834], [-121.27594, 39.49879], [-121.27582, 39.49848], [-121.27576, 39.49805], [-121.27567, 39.49769], [-121.2765, 39.49801]]]} | Unknown Access 4 | 35642 | Yuba County Water Agency 36 | 27825 | 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.008 | Yuba County Water Agency 36 | 0 | Local Other or Unknown 14 | 4 | |
3872 | 3872 | 3871 | {"type": "Polygon", "coordinates": [[[-121.27589, 39.49889], [-121.27563, 39.49942], [-121.27481, 39.49898], [-121.27531, 39.49782], [-121.27554, 39.49761], [-121.27564, 39.49806], [-121.27575, 39.49869], [-121.27589, 39.49889]]]} | Unknown Access 4 | 35643 | Yuba County Water Agency 35 | 27824 | 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.388 | Yuba County Water Agency 35 | 0 | Local Other or Unknown 14 | 4 | |
3873 | 3873 | 3872 | {"type": "Polygon", "coordinates": [[[-121.27655, 39.4991], [-121.2759, 39.49956], [-121.27563, 39.49942], [-121.27589, 39.49889], [-121.27615, 39.49905], [-121.27655, 39.4991]]]} | Unknown Access 4 | 35644 | Yuba County Water Agency 34 | 27823 | 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.673 | Yuba County Water Agency 34 | 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 | |
3879 | 3879 | 3878 | {"type": "Polygon", "coordinates": [[[-121.19451, 39.33672], [-121.19414, 39.33949], [-121.18597, 39.3391], [-121.18689, 39.33154], [-121.18707, 39.33029], [-121.18718, 39.3303], [-121.18742, 39.3303], [-121.18842, 39.3304], [-121.18881, 39.3304], [-121.18925, 39.33042], [-121.18963, 39.33042], [-121.19002, 39.33044], [-121.19016, 39.33043], [-121.18978, 39.3321], [-121.19067, 39.33218], [-121.19105, 39.33663], [-121.1914, 39.33671], [-121.19169, 39.33661], [-121.19204, 39.33663], [-121.19255, 39.33679], [-121.19303, 39.33702], [-121.19349, 39.33708], [-121.19377, 39.33714], [-121.19405, 39.33696], [-121.19418, 39.33677], [-121.19451, 39.33672]]]} | Unknown Access 4 | 35703 | Yuba County Water Agency 25 | 27814 | 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 | 108.796 | Yuba County Water Agency 25 | 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]);