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_ID
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, 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
LAYER 10 ✖
MNG_AG_LEV 7 ✖
- Special District 219
- Non Profit 64
- County 37
- City 29
- State 28
- Federal 6
- Private 3
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5162 | 5162 | 5161 | {"type": "Polygon", "coordinates": [[[-120.28838, 34.6322], [-120.28819, 34.63214], [-120.28749, 34.63204], [-120.28601, 34.6281], [-120.2848, 34.626], [-120.2853, 34.62489], [-120.28414, 34.61969], [-120.28535, 34.61953], [-120.28645, 34.62558], [-120.28607, 34.62652], [-120.28748, 34.62894], [-120.28838, 34.6322]]]} | Unknown Access 4 | 17 | RHR, Santa Rosa Creek | 24314 | 212 | California Wildlife Conservation Board 766 | State 5 | State Agency 5 | http://www.wcb.ca.gov/ | Other State 5 | 212 | California Wildlife Conservation Board 747 | State 5 | State Agency 5 | Santa Barbara 7 | 34.432 | RHR, Santa Rosa Creek | None 418 | |||
5799 | 5799 | 5798 | {"type": "MultiPolygon", "coordinates": [[[[-121.59691, 39.01108], [-121.59311, 39.01118], [-121.59358, 39.01301], [-121.59391, 39.01464], [-121.59433, 39.01645], [-121.59443, 39.01699], [-121.59445, 39.01733], [-121.59441, 39.01791], [-121.59437, 39.01814], [-121.59416, 39.01868], [-121.59396, 39.01902], [-121.59373, 39.01946], [-121.59354, 39.01995], [-121.5933, 39.02107], [-121.59319, 39.02146], [-121.59293, 39.02225], [-121.59287, 39.02225], [-121.59264, 39.02153], [-121.59211, 39.02089], [-121.59185, 39.0203], [-121.59032, 39.01854], [-121.58931, 39.01705], [-121.58836, 39.01612], [-121.58836, 39.01457], [-121.5864, 39.01457], [-121.58379, 39.01281], [-121.5838, 39.01078], [-121.58378, 39.00959], [-121.58501, 39.00963], [-121.58568, 39.00955], [-121.588, 39.00982], [-121.58942, 39.00995], [-121.59046, 39.00999], [-121.59107, 39.01008], [-121.59337, 39.01028], [-121.59439, 39.01045], [-121.59592, 39.01079], [-121.59691, 39.01108]]], [[[-121.60816, 39.04031], [-121.60835, 39.04131], [-121.60845, 39.04199], [-121.60859, 39.04275], [-121.60865, 39.04316], [-121.60866, 39.04405], [-121.60885, 39.04578], [-121.60901, 39.04677], [-121.60914, 39.04751], [-121.60925, 39.04829], [-121.60933, 39.04946], [-121.60963, 39.05223], [-121.60988, 39.05361], [-121.60993, 39.05437], [-121.60992, 39.05487], [-121.60995, 39.05554], [-121.61003, 39.05589], [-121.61012, 39.05638], [-121.61012, 39.05727], [-121.60998, 39.058], [-121.60972, 39.05842], [-121.60917, 39.05918], [-121.60876, 39.05993], [-121.60817, 39.06083], [-121.60767, 39.06145], [-121.60749, 39.0617], [-121.60473, 39.06131], [-121.60098, 39.05938], [-121.60167, 39.05491], [-121.60202, 39.0549], [-121.60225, 39.0404], [-121.60632, 39.04039], [-121.60751, 39.04033], [-121.60211, 39.04034], [-121.6018, 39.03873], [-121.60148, 39.03634], [-121.60101, 39.03366], [-121.6005, 39.03365], [-121.60049, 39.03311], [-121.60558, 39.03309], [-121.6062, 39.03424], [-121.60636, 39.03477], [-121.60696, 39.03595], [-121.6072, 39.03667], [-121.60733, 39.03687], [-121.60758, 39.03761], [-121.60774, 39.03819], [-121.60802, 39.03954], [-121.60805, 39.03986], [-121.60816, 39.04031]]], [[[-121.59954, 39.07212], [-121.59934, 39.07246], [-121.59882, 39.07361], [-121.59842, 39.07428], [-121.59809, 39.07473], [-121.59786, 39.07522], [-121.59766, 39.0756], [-121.59715, 39.07635], [-121.59689, 39.07662], [-121.5966, 39.07703], [-121.59637, 39.0774], [-121.59611, 39.07778], [-121.59552, 39.07846], [-121.59529, 39.07891], [-121.59495, 39.07928], [-121.59444, 39.07975], [-121.59428, 39.07997], [-121.59408, 39.08016], [-121.59349, 39.08092], [-121.5933, 39.08112], [-121.59314, 39.08132], [-121.59269, 39.08175], [-121.59219, 39.08216], [-121.59203, 39.08233], [-121.5916, 39.08271], [-121.59139, 39.08287], [-121.59116, 39.08301], [-121.59097, 39.08317], [-121.59055, 39.08341], [-121.59036, 39.08357], [-121.59016, 39.08371], [-121.58968, 39.08415], [-121.58929, 39.08466], [-121.58875, 39.08539], [-121.58839, 39.08605], [-121.58785, 39.08691], [-121.58771, 39.08707], [-121.58689, 39.08791], [-121.5864, 39.08858], [-121.58609, 39.08908], [-121.58595, 39.08926], [-121.58573, 39.08967], [-121.58569, 39.08985], [-121.58569, 39.09004], [-121.58575, 39.09061], [-121.58587, 39.09133], [-121.58594, 39.09157], [-121.58604, 39.0926], [-121.58601, 39.09322], [-121.58606, 39.09392], [-121.58606, 39.0943], [-121.58614, 39.0955], [-121.5863, 39.09631], [-121.58639, 39.09685], [-121.58643, 39.09723], [-121.58662, 39.09793], [-121.58678, 39.09846], [-121.58682, 39.09854], [-121.58597, 39.09854], [-121.58567, 39.09764], [-121.58468, 39.09428], [-121.58458, 39.09132], [-121.58467, 39.0909], [-121.58475, 39.09036], [-121.58497, 39.08994], [-121.58534, 39.08915], [-121.58577, 39.08839], [-121.58625, 39.08782], [-121.58672, 39.08714], [-121.58714, 39.08666], [-121.58848, 39.0847], [-121.5891, 39.08373], [-121.58956, 39.08287], [-121.5898, 39.08238], [-121.59006, 39.08189], [-121.5908, 39.08095], [-121.59121, 39.08047], [-121.59226, 39.07935], [-121.59277, 39.07875], [-121.59278, 39.07648], [-121.59362, 39.07648], [-121.59384, 39.07609], [-121.59416, 39.0758], [-121.59497, 39.07528], [-121.59533, 39.07501], [-121.59632, 39.07414], [-121.59669, 39.07384], [-121.59697, 39.07345], [-121.59736, 39.07281], [-121.59786, 39.07182], [-121.59954, 39.07212]]]]} | Unknown Access 4 | 59 | Feather River | 18860 | 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 | 733.868 | Feather River | 0 | None 465 | |||
5832 | 5832 | 5831 | {"type": "MultiPolygon", "coordinates": [[[[-120.50973, 34.63798], [-120.51286, 34.63889], [-120.51323, 34.63901], [-120.51359, 34.63917], [-120.51515, 34.64001], [-120.51622, 34.64005], [-120.51655, 34.6402], [-120.51656, 34.64047], [-120.51688, 34.64047], [-120.51753, 34.64052], [-120.51833, 34.64072], [-120.52173, 34.64176], [-120.52245, 34.64197], [-120.52267, 34.64203], [-120.52322, 34.64208], [-120.52367, 34.64208], [-120.52411, 34.642], [-120.52453, 34.64184], [-120.52473, 34.64174], [-120.52491, 34.64162], [-120.52509, 34.64148], [-120.52526, 34.64133], [-120.5254, 34.64117], [-120.52499, 34.64091], [-120.52532, 34.64066], [-120.52591, 34.641], [-120.52569, 34.64131], [-120.52561, 34.64127], [-120.52529, 34.64159], [-120.5251, 34.64174], [-120.5249, 34.64187], [-120.52468, 34.64198], [-120.52446, 34.64208], [-120.52423, 34.64216], [-120.524, 34.64221], [-120.52376, 34.64225], [-120.52326, 34.64226], [-120.52306, 34.64225], [-120.52266, 34.64219], [-120.52244, 34.64213], [-120.5177, 34.64076], [-120.51683, 34.64065], [-120.51662, 34.64071], [-120.51561, 34.64118], [-120.51546, 34.64157], [-120.51524, 34.64229], [-120.51503, 34.64383], [-120.51517, 34.64385], [-120.51518, 34.64407], [-120.51465, 34.64397], [-120.51466, 34.64381], [-120.51481, 34.64378], [-120.515, 34.64223], [-120.5152, 34.64136], [-120.5152, 34.64105], [-120.51524, 34.64024], [-120.51359, 34.63934], [-120.5132, 34.63917], [-120.51278, 34.63903], [-120.50968, 34.63817], [-120.50816, 34.6378], [-120.50809, 34.63772], [-120.50496, 34.63692], [-120.50458, 34.63679], [-120.5044, 34.63671], [-120.50407, 34.63649], [-120.50378, 34.63623], [-120.50366, 34.63607], [-120.50355, 34.63591], [-120.50337, 34.63556], [-120.50306, 34.63472], [-120.50291, 34.63448], [-120.50259, 34.63415], [-120.50216, 34.63439], [-120.50154, 34.63387], [-120.50279, 34.63315], [-120.50329, 34.63373], [-120.50277, 34.63406], [-120.50309, 34.63452], [-120.50321, 34.63473], [-120.50355, 34.63565], [-120.50374, 34.63597], [-120.50398, 34.63625], [-120.50427, 34.63649], [-120.50459, 34.63667], [-120.50494, 34.6368], [-120.50702, 34.63734], [-120.5071, 34.63728], [-120.50758, 34.63739], [-120.50763, 34.63748], [-120.50973, 34.63798]]], [[[-120.51511, 34.64666], [-120.51511, 34.6469], [-120.51439, 34.64689], [-120.51439, 34.64665], [-120.51459, 34.64664], [-120.51462, 34.64418], [-120.51492, 34.64425], [-120.51488, 34.64664], [-120.51511, 34.64666]]], [[[-120.5152, 34.64717], [-120.51519, 34.64736], [-120.51495, 34.64736], [-120.5148, 34.66139], [-120.51441, 34.66139], [-120.51444, 34.65983], [-120.5145, 34.65944], [-120.51456, 34.65417], [-120.51455, 34.64736], [-120.51434, 34.64735], [-120.51434, 34.64716], [-120.5152, 34.64717]]], [[[-120.51427, 34.66507], [-120.5144, 34.66155], [-120.5148, 34.66156], [-120.51468, 34.66508], [-120.51458, 34.66933], [-120.51472, 34.66934], [-120.51467, 34.67235], [-120.5146, 34.67337], [-120.51462, 34.67357], [-120.51469, 34.67382], [-120.51479, 34.67405], [-120.51525, 34.67468], [-120.51541, 34.67475], [-120.51554, 34.67482], [-120.51677, 34.67601], [-120.5155, 34.67603], [-120.51524, 34.67584], [-120.51453, 34.67574], [-120.51455, 34.67434], [-120.51437, 34.67417], [-120.51427, 34.67403], [-120.5142, 34.67387], [-120.51415, 34.6737], [-120.51414, 34.67333], [-120.51419, 34.6687], [-120.51427, 34.66507]]]]} | Unknown Access 4 | 159 | Rodeo-San Pascual Flood Control Channel | 24548 | 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 | 53.121 | Rodeo-San Pascual Flood Control Channel | 0 | Local Other or Unknown 14 | 4 | |
5884 | 5884 | 5883 | {"type": "MultiPolygon", "coordinates": [[[[-119.79426, 34.4463], [-119.79411, 34.44637], [-119.79361, 34.44738], [-119.79382, 34.4476], [-119.7938, 34.44786], [-119.79343, 34.44803], [-119.79298, 34.44802], [-119.79241, 34.44812], [-119.79224, 34.44837], [-119.79212, 34.44829], [-119.79226, 34.44801], [-119.7925, 34.44786], [-119.79254, 34.44769], [-119.79277, 34.44765], [-119.79284, 34.44779], [-119.79309, 34.44778], [-119.79324, 34.44775], [-119.79335, 34.44763], [-119.79341, 34.44749], [-119.79326, 34.44738], [-119.79339, 34.44722], [-119.79373, 34.44669], [-119.79374, 34.44663], [-119.79372, 34.44657], [-119.79404, 34.44609], [-119.79426, 34.4463]]], [[[-119.79691, 34.446], [-119.79567, 34.446], [-119.79525, 34.44612], [-119.79527, 34.44646], [-119.79515, 34.44653], [-119.79497, 34.44665], [-119.79437, 34.44639], [-119.79559, 34.44572], [-119.79691, 34.44574], [-119.79691, 34.446]]], [[[-119.80544, 34.44219], [-119.80546, 34.44288], [-119.80541, 34.44301], [-119.8053, 34.44297], [-119.80522, 34.44319], [-119.805, 34.44321], [-119.80514, 34.44286], [-119.80505, 34.44237], [-119.80464, 34.44245], [-119.80463, 34.44244], [-119.80339, 34.4427], [-119.80252, 34.44299], [-119.80242, 34.443], [-119.80218, 34.44295], [-119.80205, 34.44296], [-119.80193, 34.44301], [-119.80184, 34.4431], [-119.80166, 34.44341], [-119.80163, 34.44356], [-119.79959, 34.44377], [-119.79958, 34.44402], [-119.80165, 34.44381], [-119.80166, 34.44387], [-119.80164, 34.4439], [-119.80152, 34.444], [-119.80123, 34.44433], [-119.79955, 34.44431], [-119.79955, 34.44426], [-119.79932, 34.44426], [-119.79926, 34.44428], [-119.79891, 34.44452], [-119.79893, 34.44461], [-119.79879, 34.44464], [-119.79864, 34.44471], [-119.79829, 34.44493], [-119.79811, 34.44503], [-119.79791, 34.4451], [-119.7977, 34.44513], [-119.79719, 34.4451], [-119.79715, 34.44507], [-119.79716, 34.44489], [-119.79744, 34.44489], [-119.79768, 34.44487], [-119.79791, 34.44481], [-119.79813, 34.44471], [-119.79833, 34.44457], [-119.79906, 34.44389], [-119.79918, 34.44383], [-119.79934, 34.44379], [-119.79935, 34.44374], [-119.80041, 34.44361], [-119.8009, 34.44357], [-119.80091, 34.44337], [-119.80083, 34.44331], [-119.80078, 34.44324], [-119.80077, 34.44317], [-119.80078, 34.44304], [-119.80079, 34.44298], [-119.80084, 34.44291], [-119.80095, 34.44281], [-119.80101, 34.44277], [-119.8013, 34.44273], [-119.80157, 34.44261], [-119.80241, 34.44243], [-119.8022, 34.44256], [-119.80194, 34.44281], [-119.80286, 34.44279], [-119.80297, 34.44269], [-119.80544, 34.44219]]]]} | Unknown Access 4 | 290 | San Antonio Creek | 24828 | 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 | 12.836 | San Antonio Creek | 0 | Local Other or Unknown 14 | 4 | |
108 | 108 | 107 | {"type": "Polygon", "coordinates": [[[-119.80165, 34.44381], [-119.80106, 34.44387], [-119.79957, 34.44402], [-119.79959, 34.44377], [-119.80161, 34.44357], [-119.80165, 34.44381]]]} | Unknown Access 4 | 295 | San Antonio Creek | 24829 | 2141 | Santa Barbara Flood Control and Water Conserv. District 46 | Special District 4 | Flood District 8 | http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 | Special District 4 | 2141 | Santa Barbara Flood Control and Water Conserv. District 45 | Special District 4 | Flood District 9 | Santa Barbara 7 | 1.291 | San Antonio Creek | 0 | Local Other or Unknown 14 | 4 | |
15974 | 15974 | 15973 | {"type": "MultiPolygon", "coordinates": [[[[-119.81332, 34.45598], [-119.81288, 34.45617], [-119.81225, 34.45579], [-119.81214, 34.45568], [-119.81209, 34.45571], [-119.81199, 34.45548], [-119.81194, 34.45517], [-119.81158, 34.45496], [-119.81142, 34.45533], [-119.81138, 34.45536], [-119.81135, 34.45542], [-119.81137, 34.4555], [-119.81145, 34.45559], [-119.8115, 34.45578], [-119.81148, 34.45592], [-119.8114, 34.45609], [-119.81136, 34.45621], [-119.81136, 34.45643], [-119.81134, 34.45646], [-119.81119, 34.45654], [-119.81111, 34.45662], [-119.81093, 34.45692], [-119.81062, 34.45753], [-119.8103, 34.45739], [-119.81042, 34.4569], [-119.80997, 34.45714], [-119.80956, 34.45682], [-119.80933, 34.45651], [-119.80908, 34.4565], [-119.80894, 34.45612], [-119.80929, 34.45603], [-119.80957, 34.45575], [-119.80968, 34.4558], [-119.80969, 34.4561], [-119.81035, 34.4561], [-119.81047, 34.45579], [-119.81042, 34.45575], [-119.81048, 34.45568], [-119.8105, 34.45559], [-119.8105, 34.45431], [-119.81053, 34.45429], [-119.81115, 34.45429], [-119.81129, 34.45426], [-119.81139, 34.45421], [-119.81146, 34.45416], [-119.81153, 34.45407], [-119.81158, 34.45396], [-119.81159, 34.45408], [-119.81196, 34.45403], [-119.81204, 34.45397], [-119.81207, 34.45383], [-119.81229, 34.45385], [-119.81229, 34.45306], [-119.81384, 34.45306], [-119.81408, 34.45307], [-119.81411, 34.4531], [-119.81412, 34.45313], [-119.81401, 34.45326], [-119.81387, 34.45335], [-119.81367, 34.45343], [-119.81356, 34.45348], [-119.81346, 34.45357], [-119.81339, 34.45366], [-119.81331, 34.45385], [-119.81322, 34.45435], [-119.81289, 34.45432], [-119.81286, 34.45461], [-119.81251, 34.45474], [-119.81236, 34.45497], [-119.81251, 34.45525], [-119.81269, 34.45538], [-119.81294, 34.45543], [-119.81309, 34.45578], [-119.81332, 34.45598]]], [[[-119.81048, 34.45784], [-119.81042, 34.45797], [-119.81006, 34.45793], [-119.80996, 34.45812], [-119.80972, 34.45833], [-119.80961, 34.45878], [-119.80941, 34.45916], [-119.80963, 34.45934], [-119.80984, 34.45945], [-119.81, 34.4595], [-119.80999, 34.45955], [-119.80985, 34.45956], [-119.8098, 34.4595], [-119.80931, 34.45923], [-119.80912, 34.45888], [-119.80925, 34.4583], [-119.80955, 34.45781], [-119.81004, 34.45766], [-119.81042, 34.45785], [-119.81048, 34.45784]]], [[[-119.81501, 34.458], [-119.815, 34.45855], [-119.81493, 34.45851], [-119.81494, 34.45848], [-119.81485, 34.45842], [-119.81481, 34.45845], [-119.81458, 34.45833], [-119.81417, 34.45818], [-119.81412, 34.45791], [-119.81387, 34.45777], [-119.81367, 34.45716], [-119.81363, 34.45682], [-119.81339, 34.45641], [-119.8131, 34.45626], [-119.81363, 34.45603], [-119.81367, 34.45604], [-119.81376, 34.4562], [-119.81383, 34.45639], [-119.81407, 34.45734], [-119.81419, 34.45756], [-119.81434, 34.45772], [-119.81452, 34.45785], [-119.81478, 34.45796], [-119.81501, 34.458]]], [[[-119.8154, 34.45898], [-119.81531, 34.45912], [-119.81528, 34.45914], [-119.81495, 34.45882], [-119.81494, 34.45878], [-119.81462, 34.45852], [-119.8154, 34.45898]]]]} | Unknown Access 4 | 339 | San Jose Creek Open Space | 24915 | 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 | 23.422 | San Jose Creek OS | 0 | Local Recreation Area 3 | 4 | |
133 | 133 | 132 | {"type": "Polygon", "coordinates": [[[-119.74246, 34.44054], [-119.74244, 34.44072], [-119.74241, 34.44073], [-119.74215, 34.44091], [-119.74194, 34.44113], [-119.74168, 34.44129], [-119.74157, 34.44128], [-119.7414, 34.44128], [-119.74181, 34.44101], [-119.74204, 34.44079], [-119.74227, 34.44062], [-119.74234, 34.44054], [-119.74246, 34.44054]]]} | 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 | |
5920 | 5920 | 5919 | {"type": "MultiPolygon", "coordinates": [[[[-121.53785, 38.99012], [-121.53571, 38.99016], [-121.53505, 38.98682], [-121.53318, 38.97686], [-121.53261, 38.97452], [-121.53228, 38.97439], [-121.52906, 38.974], [-121.52845, 38.97401], [-121.52772, 38.97407], [-121.52694, 38.97429], [-121.52603, 38.97461], [-121.52466, 38.97549], [-121.52472, 38.97146], [-121.53415, 38.97196], [-121.53419, 38.9722], [-121.53437, 38.97219], [-121.53521, 38.97686], [-121.53623, 38.98263], [-121.53785, 38.99012]]], [[[-121.54307, 38.97419], [-121.53827, 38.97526], [-121.53632, 38.97537], [-121.5361, 38.97451], [-121.53695, 38.97474], [-121.53768, 38.97467], [-121.53863, 38.97446], [-121.5393, 38.97412], [-121.54233, 38.97348], [-121.54302, 38.97266], [-121.54307, 38.97419]]], [[[-121.5693, 38.94626], [-121.56559, 38.95156], [-121.56466, 38.95274], [-121.56398, 38.95341], [-121.5629, 38.95417], [-121.56164, 38.95474], [-121.56038, 38.95508], [-121.55862, 38.95546], [-121.55738, 38.95588], [-121.55666, 38.95633], [-121.55608, 38.95694], [-121.55575, 38.95752], [-121.55566, 38.95751], [-121.55566, 38.95777], [-121.55556, 38.95767], [-121.55525, 38.9583], [-121.55289, 38.96098], [-121.55118, 38.96232], [-121.55065, 38.96278], [-121.55031, 38.96313], [-121.54971, 38.96387], [-121.54949, 38.9638], [-121.54995, 38.96284], [-121.55104, 38.96187], [-121.55287, 38.96042], [-121.55366, 38.95939], [-121.555, 38.95758], [-121.55531, 38.95677], [-121.55611, 38.95602], [-121.5573, 38.95535], [-121.55905, 38.95497], [-121.56076, 38.95466], [-121.5618, 38.95423], [-121.56279, 38.95374], [-121.56346, 38.95316], [-121.56433, 38.95229], [-121.56908, 38.94541], [-121.5693, 38.94626]]]]} | Unknown Access 4 | 418 | Bear River | 15929 | 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 | 185.752 | Bear River | None 473 | ||||
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 | ||
185 | 185 | 184 | {"type": "Polygon", "coordinates": [[[-119.52773, 34.40703], [-119.52713, 34.40837], [-119.52698, 34.40879], [-119.52686, 34.40923], [-119.52678, 34.40968], [-119.52672, 34.40966], [-119.52675, 34.4094], [-119.52682, 34.40907], [-119.52689, 34.40883], [-119.52701, 34.40848], [-119.52766, 34.40701], [-119.52773, 34.40703]]]} | Unknown Access 4 | 592 | Santa Monica Creek | 25117 | 1047 | Carpinteria, City of 72 | City 2 | City Agency 2 | http://www.carpinteria.ca.us/parks_rec/index.shtml | City 2 | 1047 | Carpinteria, City of 70 | City 2 | City Agency 2 | Santa Barbara 7 | 0.489 | Santa Monica Creek | 0 | Local Other or Unknown 14 | 4 | |
5597 | 5597 | 5596 | {"type": "Polygon", "coordinates": [[[-120.49458, 34.67098], [-120.49431, 34.67124], [-120.49306, 34.67174], [-120.493, 34.6711], [-120.49457, 34.67081], [-120.49458, 34.67098]]]} | Unknown Access 4 | 631 | Santa Ynez River | 25145 | 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 | 1.884 | Santa Ynez River | None 451 | |||
285 | 285 | 284 | {"type": "MultiPolygon", "coordinates": [[[[-119.69069, 34.44329], [-119.69064, 34.4434], [-119.69065, 34.44355], [-119.69068, 34.44362], [-119.69097, 34.44402], [-119.69099, 34.44413], [-119.69098, 34.44422], [-119.69094, 34.4443], [-119.69087, 34.44436], [-119.69029, 34.44464], [-119.69015, 34.44481], [-119.69015, 34.44384], [-119.68972, 34.44402], [-119.68956, 34.44406], [-119.68939, 34.44408], [-119.68783, 34.44396], [-119.68772, 34.44393], [-119.6876, 34.44389], [-119.68726, 34.44363], [-119.68703, 34.44354], [-119.68683, 34.4435], [-119.68629, 34.44347], [-119.68596, 34.4434], [-119.68596, 34.44324], [-119.68632, 34.44331], [-119.6869, 34.44334], [-119.6871, 34.44338], [-119.6873, 34.44346], [-119.68745, 34.44355], [-119.68767, 34.44372], [-119.68782, 34.44378], [-119.68937, 34.44392], [-119.68964, 34.44387], [-119.69015, 34.44364], [-119.69013, 34.44286], [-119.69069, 34.44329]]], [[[-119.69482, 34.44571], [-119.69452, 34.44628], [-119.69438, 34.44643], [-119.69253, 34.44663], [-119.69154, 34.4466], [-119.69056, 34.44614], [-119.69014, 34.44596], [-119.69015, 34.44498], [-119.69037, 34.44471], [-119.69094, 34.44446], [-119.69102, 34.4444], [-119.69109, 34.44429], [-119.69113, 34.44416], [-119.6911, 34.444], [-119.6908, 34.44353], [-119.69078, 34.44345], [-119.6908, 34.44337], [-119.69144, 34.44386], [-119.69193, 34.44417], [-119.69239, 34.44438], [-119.6932, 34.44461], [-119.69391, 34.4449], [-119.69482, 34.44571]]]]} | Unknown Access 4 | 777 | Sheffield Reservoir | 25382 | 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 | 26.245 | Sheffield Reservoir | 0 | Local Recreation Area 3 | 4 | |
364 | 364 | 363 | {"type": "Polygon", "coordinates": [[[-119.67342, 34.42333], [-119.67318, 34.42356], [-119.67274, 34.42324], [-119.67299, 34.42301], [-119.67342, 34.42333]]]} | Unknown Access 4 | 1276 | Sycamore Creek | 26121 | 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 | 0.446 | Sycamore Creek | 0 | Local Other or Unknown 14 | 4 | |
4475 | 4475 | 4474 | {"type": "Polygon", "coordinates": [[[-117.51483, 34.17196], [-117.51477, 34.17839], [-117.51026, 34.17888], [-117.51022, 34.17196], [-117.51483, 34.17196]]]} | Unknown Access 4 | 3291 | Unnamed site - The Habitat Trust | 28671 | 3089 | The Habitat Trust 340 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3089 | The Habitat Trust 337 | Non Profit 6 | Non Profit - Land Trust 10 | San Bernardino 22 | 76.971 | 0 | Private Other or Unknown 399 | 4 | |||
4961 | 4961 | 4960 | {"type": "Polygon", "coordinates": [[[-118.54326, 34.04416], [-118.54305, 34.04417], [-118.54302, 34.0442], [-118.54286, 34.04405], [-118.54306, 34.04392], [-118.54313, 34.04389], [-118.54316, 34.04389], [-118.54323, 34.04403], [-118.54326, 34.04416]]]} | Unknown Access 4 | 3659 | Las Casas - Grenola | 21045 | 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 | 0.186 | Las Casas - Grenola | None 411 | |||
4478 | 4478 | 4477 | {"type": "Polygon", "coordinates": [[[-116.49292, 33.88852], [-116.49291, 33.8894], [-116.48878, 33.88856], [-116.49198, 33.88852], [-116.49292, 33.88852]]]} | Unknown Access 4 | 3751 | Unnamed site - California Wildlife Conservation Board | 28678 | 212 | California Wildlife Conservation Board 766 | State 5 | State Agency 5 | http://www.wcb.ca.gov/ | Other State 5 | 212 | California Wildlife Conservation Board 747 | State 5 | State Agency 5 | Riverside 10 | 4.66 | 0 | State Other or Unknown 104 | 4 | ||
4479 | 4479 | 4478 | {"type": "Polygon", "coordinates": [[[-116.49291, 33.88957], [-116.4929, 33.89588], [-116.48423, 33.89587], [-116.48427, 33.8886], [-116.48805, 33.88856], [-116.49291, 33.88957]]]} | Unknown Access 4 | 3752 | Unnamed site - California Wildlife Conservation Board | 28678 | 212 | California Wildlife Conservation Board 766 | State 5 | State Agency 5 | http://www.wcb.ca.gov/ | Other State 5 | 212 | California Wildlife Conservation Board 747 | State 5 | State Agency 5 | Riverside 10 | 154.196 | 0 | State Other or Unknown 104 | 4 | ||
15454 | 15454 | 15453 | {"type": "Polygon", "coordinates": [[[-116.36903, 33.83109], [-116.36896, 33.83837], [-116.36677, 33.83836], [-116.36686, 33.83109], [-116.36903, 33.83109]]]} | Unknown Access 4 | 3769 | Unnamed site - Center for Natural Lands Management | 28629 | 3014 | Center for Natural Lands Management 91 | Non Profit 6 | Non Profit - Land Trust 10 | http://cnlm.org/ | Non Governmental Organization 10 | 3014 | Center for Natural Lands Management 89 | Non Profit 6 | Non Profit - Land Trust 10 | Riverside 10 | 40.197 | 0 | Private Other or Unknown 399 | 4 | ||
6601 | 6601 | 6600 | {"type": "MultiPolygon", "coordinates": [[[[-119.50722, 34.39559], [-119.50661, 34.3957], [-119.50574, 34.39635], [-119.5055, 34.39636], [-119.50526, 34.39632], [-119.50526, 34.39623], [-119.50539, 34.39622], [-119.50563, 34.39619], [-119.50586, 34.39611], [-119.50597, 34.39606], [-119.50676, 34.39552], [-119.50722, 34.39559]]], [[[-119.51198, 34.39382], [-119.51152, 34.39386], [-119.51141, 34.39389], [-119.51064, 34.3943], [-119.51039, 34.39448], [-119.51014, 34.39416], [-119.51121, 34.39348], [-119.51144, 34.3934], [-119.51198, 34.39382]]]]} | Unknown Access 4 | 4238 | Carpinteria Creek | 16897 | 1047 | Carpinteria, City of 72 | City 2 | City Agency 2 | http://www.carpinteria.ca.us/parks_rec/index.shtml | City 2 | 1047 | Carpinteria, City of 70 | City 2 | City Agency 2 | Santa Barbara 7 | 2.293 | Carpinteria Creek | 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]);