units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
108 rows where MNG_AG_TYP = 9 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_WEB, LAYER, MNG_AG_ID, PARK_URL, GAP_STS
DES_TP >30
COUNTY 10 ✖
- Fresno 29
- Los Angeles 23
- Santa Barbara 21
- Sutter 15
- Sacramento 9
- San Bernardino 5
- Yuba 3
- Stanislaus 1
- Alameda 1
- Marin 1
MNG_AGENCY 9
- Fresno Metropolitan Flood Control District 29
- Los Angeles County Flood Control District 23
- Natomas Basin Conservancy 22
- Santa Barbara Flood Control and Water Conserv. District 21
- San Bernardino County Flood Control District 5
- Sacramento and San Joaquin Drainage District 4
- Sacramento Area Flood Control Agency 2
- Alameda County Flood Control and Water Conservation District 1
- Marin Public Works Dept/Flood Control 1
ACCESS_TYP 4
AGNCY_TYP 2 ✖
- Flood District 107
- County Agency 1
MNG_AG_TYP 1
- Flood District · 108 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |
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 | ||||
172 | 172 | 171 | {"type": "Polygon", "coordinates": [[[-119.7122, 34.45864], [-119.71219, 34.45865], [-119.71206, 34.45871], [-119.71176, 34.45871], [-119.71175, 34.45848], [-119.71185, 34.45854], [-119.7122, 34.45864]]]} | Open Access 1 | 462 | Santa Barbara Botanic Gardens | 25037 | 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 | 0.145 | Santa Barbara Botanic Gardens | 0 | Local Park 2 | 4 | |
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 | ||
5979 | 5979 | 5978 | {"type": "MultiPolygon", "coordinates": [[[[-120.48345, 34.98584], [-120.48337, 34.99218], [-120.48142, 34.99198], [-120.47965, 34.99181], [-120.47966, 34.98664], [-120.47789, 34.98695], [-120.47784, 34.99165], [-120.47579, 34.99142], [-120.47587, 34.98734], [-120.47788, 34.98694], [-120.47789, 34.98663], [-120.47968, 34.98631], [-120.47968, 34.98652], [-120.47969, 34.98653], [-120.48345, 34.98584]]], [[[-120.51263, 34.98085], [-120.50518, 34.98229], [-120.50506, 34.98221], [-120.50461, 34.98232], [-120.48777, 34.98558], [-120.48775, 34.98517], [-120.4854, 34.98558], [-120.4854, 34.98549], [-120.48776, 34.98508], [-120.50194, 34.98231], [-120.5049, 34.98171], [-120.51221, 34.98035], [-120.51238, 34.98023], [-120.51229, 34.97976], [-120.51243, 34.97975], [-120.51263, 34.98085]]]]} | Open Access 1 | 578 | Santa Maria River | 25115 | 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 | 112.788 | Santa Maria River | None 479 | |||
5990 | 5990 | 5989 | {"type": "MultiPolygon", "coordinates": [[[[-119.5293, 34.4012], [-119.5292, 34.40139], [-119.52908, 34.40167], [-119.52915, 34.4018], [-119.52905, 34.40199], [-119.52881, 34.40192], [-119.52912, 34.40112], [-119.5293, 34.4012]]], [[[-119.5289, 34.40218], [-119.52879, 34.40304], [-119.52879, 34.40348], [-119.52865, 34.40345], [-119.52865, 34.40307], [-119.52876, 34.40214], [-119.5289, 34.40218]]], [[[-119.52886, 34.40434], [-119.52884, 34.40463], [-119.52873, 34.40461], [-119.52875, 34.40449], [-119.52868, 34.40447], [-119.52866, 34.404], [-119.52868, 34.404], [-119.52886, 34.40434]]], [[[-119.52876, 34.40482], [-119.52868, 34.40513], [-119.52842, 34.40587], [-119.52806, 34.4067], [-119.52792, 34.40707], [-119.52795, 34.40708], [-119.5279, 34.40723], [-119.52782, 34.40744], [-119.5274, 34.40831], [-119.52726, 34.40872], [-119.52711, 34.40929], [-119.5266, 34.41374], [-119.5263, 34.41385], [-119.52635, 34.41365], [-119.52678, 34.40968], [-119.52686, 34.40923], [-119.52698, 34.40879], [-119.52713, 34.40837], [-119.52808, 34.40625], [-119.52833, 34.40556], [-119.52858, 34.4048], [-119.52876, 34.40482]]], [[[-119.52796, 34.42581], [-119.52762, 34.42608], [-119.52787, 34.42631], [-119.52779, 34.42645], [-119.52752, 34.42646], [-119.52752, 34.42634], [-119.52731, 34.4262], [-119.52769, 34.42541], [-119.52761, 34.42489], [-119.52731, 34.42485], [-119.52677, 34.42469], [-119.52676, 34.4245], [-119.52655, 34.42433], [-119.52618, 34.42437], [-119.52604, 34.42421], [-119.52557, 34.42425], [-119.52537, 34.42401], [-119.52509, 34.42402], [-119.52507, 34.42393], [-119.52538, 34.42387], [-119.52549, 34.42355], [-119.52539, 34.42323], [-119.52547, 34.4227], [-119.52599, 34.42123], [-119.52575, 34.42096], [-119.52564, 34.42069], [-119.52583, 34.42065], [-119.52588, 34.42077], [-119.526, 34.42077], [-119.52629, 34.42028], [-119.52629, 34.41998], [-119.52656, 34.41997], [-119.52684, 34.41942], [-119.52669, 34.4191], [-119.52673, 34.41863], [-119.52703, 34.41834], [-119.52701, 34.41806], [-119.5268, 34.41746], [-119.52644, 34.4166], [-119.52632, 34.4164], [-119.52628, 34.41577], [-119.52661, 34.41577], [-119.52674, 34.41652], [-119.52705, 34.41732], [-119.52731, 34.41768], [-119.52766, 34.41829], [-119.52759, 34.41936], [-119.52738, 34.41936], [-119.52686, 34.42026], [-119.52696, 34.42048], [-119.5268, 34.42071], [-119.52685, 34.42101], [-119.5272, 34.42146], [-119.52749, 34.42167], [-119.52745, 34.42187], [-119.52772, 34.42235], [-119.52772, 34.42348], [-119.52738, 34.42419], [-119.52727, 34.42434], [-119.52743, 34.42449], [-119.52781, 34.42464], [-119.52803, 34.42496], [-119.5281, 34.42531], [-119.52796, 34.42581]], [[-119.52669, 34.42195], [-119.52704, 34.42197], [-119.52707, 34.42164], [-119.52672, 34.42112], [-119.52662, 34.42057], [-119.52656, 34.42055], [-119.52637, 34.42076], [-119.52639, 34.42128], [-119.52666, 34.42157], [-119.52669, 34.42195]]]]} | Open Access 1 | 599 | Santa Monica Creek | 25118 | 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 | 31.846 | Santa Monica Creek | 0 | Local Other or Unknown 14 | 4 | |
241 | 241 | 240 | {"type": "Polygon", "coordinates": [[[-120.19548, 34.61923], [-120.19532, 34.62017], [-120.19414, 34.61966], [-120.19453, 34.61897], [-120.19477, 34.61907], [-120.19504, 34.61915], [-120.19548, 34.61923]]]} | Open Access 1 | 785 | Buellton Park | 16483 | 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 | 2.399 | Buellton Park | 0 | Local Park 2 | 4 | |
4015 | 4015 | 4014 | {"type": "Polygon", "coordinates": [[[-119.77525, 34.46378], [-119.77515, 34.46411], [-119.77508, 34.46424], [-119.77513, 34.46436], [-119.77498, 34.46477], [-119.77422, 34.46477], [-119.77427, 34.4643], [-119.77438, 34.46379], [-119.77525, 34.46378]]]} | Open Access 1 | 1439 | Tuckers Grove Park | 26559 | 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 | 2.064 | Tuckers Grove Park | 0 | Local Park 2 | 4 | |
6347 | 6347 | 6346 | {"type": "Polygon", "coordinates": [[[-119.72501, 36.73865], [-119.725, 36.73946], [-119.72284, 36.73945], [-119.72277, 36.73948], [-119.72274, 36.73954], [-119.7218, 36.73953], [-119.72181, 36.73948], [-119.72187, 36.7394], [-119.72187, 36.73933], [-119.72181, 36.73926], [-119.7217, 36.73923], [-119.7216, 36.73926], [-119.72154, 36.73933], [-119.72154, 36.7394], [-119.7216, 36.73948], [-119.72161, 36.73953], [-119.72058, 36.73953], [-119.72058, 36.73894], [-119.72284, 36.73894], [-119.72285, 36.73828], [-119.72318, 36.73827], [-119.72319, 36.7383], [-119.72327, 36.73837], [-119.72369, 36.73841], [-119.72396, 36.73853], [-119.72424, 36.73868], [-119.72501, 36.73865]]]} | Open Access 1 | 1762 | Trolley Creek Park | 26550 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | Fresno 9 | 8.104 | Trolley Creek Park | 0 | Local Park 2 | 4 | |
6389 | 6389 | 6388 | {"type": "Polygon", "coordinates": [[[-119.83073, 36.81646], [-119.83073, 36.81823], [-119.82858, 36.81824], [-119.82858, 36.81647], [-119.83073, 36.81646]]]} | Open Access 1 | 1815 | Oso De Oro Lake Park | 23234 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | Fresno 9 | 9.316 | Oso De Oro Lake Park | 0 | Local Park 2 | 4 | |
6625 | 6625 | 6624 | {"type": "Polygon", "coordinates": [[[-119.50841, 34.395], [-119.5075, 34.3955], [-119.50689, 34.39577], [-119.50682, 34.39566], [-119.50722, 34.39559], [-119.50754, 34.39538], [-119.50776, 34.39528], [-119.50804, 34.39502], [-119.50825, 34.39477], [-119.50841, 34.395]]]} | Unknown Access 4 | 4393 | Carpinteria Creek | 16898 | 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 | 0.458 | Carpinteria Creek | 0 | Local Other or Unknown 14 | 4 | |
6661 | 6661 | 6660 | {"type": "MultiPolygon", "coordinates": [[[[-119.52905, 34.3961], [-119.52846, 34.39735], [-119.52762, 34.39923], [-119.52766, 34.39927], [-119.52741, 34.39995], [-119.5269, 34.39971], [-119.52637, 34.39941], [-119.52672, 34.39929], [-119.52671, 34.39926], [-119.52674, 34.39925], [-119.52683, 34.39932], [-119.52708, 34.39925], [-119.52717, 34.39921], [-119.52737, 34.39902], [-119.52739, 34.39902], [-119.5288, 34.39601], [-119.52905, 34.3961]]], [[[-119.53027, 34.40061], [-119.5299, 34.40115], [-119.52919, 34.40081], [-119.52943, 34.40021], [-119.53027, 34.40061]]]]} | Restricted Access 2 | 4718 | Carpinteria Salt Marsh Reserve | 16900 | 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 | 5.152 | Carpinteria Salt Marsh Reserve | 0 | Local Conservation Area 4 | 2 | |
15861 | 15861 | 15860 | {"type": "MultiPolygon", "coordinates": [[[[-118.38822, 33.8722], [-118.38765, 33.87247], [-118.38748, 33.87223], [-118.38807, 33.87196], [-118.38822, 33.8722]]], [[[-118.38856, 33.87271], [-118.38781, 33.87273], [-118.3877, 33.87257], [-118.38829, 33.8723], [-118.38856, 33.87271]]], [[[-118.38891, 33.87189], [-118.38834, 33.87214], [-118.38818, 33.87191], [-118.38876, 33.87164], [-118.38891, 33.87189]]]]} | Open Access 1 | 6066 | Redondo Beach Open Space | 24240 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | Los Angeles 6 | 1.473 | Redondo Beach OS | 0 | Local Recreation Area 3 | 4 | |
7111 | 7111 | 7110 | {"type": "MultiPolygon", "coordinates": [[[[-118.28809, 33.79111], [-118.28789, 33.79151], [-118.28789, 33.79271], [-118.28758, 33.79273], [-118.28759, 33.79285], [-118.28789, 33.79286], [-118.28788, 33.79407], [-118.28758, 33.79355], [-118.28712, 33.79355], [-118.28703, 33.79257], [-118.28728, 33.79176], [-118.2873, 33.79163], [-118.2873, 33.79112], [-118.28809, 33.79111]]], [[[-118.28884, 33.79414], [-118.28884, 33.79461], [-118.2882, 33.79461], [-118.28805, 33.79435], [-118.28806, 33.79285], [-118.28837, 33.79285], [-118.28836, 33.79318], [-118.28845, 33.79318], [-118.28844, 33.794], [-118.28884, 33.79401], [-118.28884, 33.79414]]], [[[-118.28884, 33.79478], [-118.28884, 33.79511], [-118.28883, 33.7957], [-118.2883, 33.79478], [-118.28884, 33.79478]]], [[[-118.28979, 33.79607], [-118.28978, 33.79731], [-118.28946, 33.79732], [-118.28947, 33.79761], [-118.28899, 33.79761], [-118.289, 33.79539], [-118.28939, 33.79538], [-118.2894, 33.79552], [-118.28978, 33.79552], [-118.28979, 33.79607]]], [[[-118.28994, 33.79789], [-118.28993, 33.79899], [-118.28916, 33.80024], [-118.28897, 33.80024], [-118.28891, 33.80001], [-118.28877, 33.79965], [-118.28852, 33.79913], [-118.28826, 33.79876], [-118.28819, 33.79867], [-118.28837, 33.79789], [-118.28994, 33.79789]]]]} | No Public Access 3 | 6187 | Canada de Palos Verdes Creek | 16791 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | Los Angeles 6 | 18.831 | Canada de Palos Verdes Creek | 0 | Local Other or Unknown 14 | 4 | |
1033 | 1033 | 1032 | {"type": "Polygon", "coordinates": [[[-118.51157, 34.07731], [-118.51143, 34.07746], [-118.5104, 34.07684], [-118.5101, 34.07613], [-118.50988, 34.07539], [-118.50872, 34.07481], [-118.50845, 34.0745], [-118.50826, 34.07401], [-118.50761, 34.07364], [-118.50763, 34.07328], [-118.50737, 34.07296], [-118.50731, 34.07284], [-118.50737, 34.07275], [-118.50746, 34.07269], [-118.50778, 34.07276], [-118.50866, 34.0734], [-118.50892, 34.0734], [-118.50898, 34.07385], [-118.50974, 34.07406], [-118.50989, 34.07443], [-118.50989, 34.07475], [-118.51067, 34.07526], [-118.51068, 34.07637], [-118.51099, 34.07669], [-118.51107, 34.07682], [-118.5113, 34.07702], [-118.51157, 34.07731]]]} | No Public Access 3 | 6378 | Sullivan Canyon Creek & Dam | 25948 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | Los Angeles 6 | 10.67 | Sullivan Canyon Creek & Dam | None 93 | |||
928 | 928 | 927 | {"type": "MultiPolygon", "coordinates": [[[[-118.59921, 34.0992], [-118.59903, 34.09939], [-118.59861, 34.09959], [-118.59848, 34.0997], [-118.59839, 34.10003], [-118.59832, 34.10038], [-118.59776, 34.10077], [-118.59771, 34.10077], [-118.5977, 34.10064], [-118.59805, 34.10038], [-118.59816, 34.10024], [-118.59822, 34.10008], [-118.59827, 34.09982], [-118.59832, 34.09971], [-118.59838, 34.09965], [-118.59873, 34.09941], [-118.59894, 34.09917], [-118.59904, 34.09909], [-118.59921, 34.0992]]], [[[-118.60098, 34.097], [-118.60043, 34.09746], [-118.60002, 34.09794], [-118.59991, 34.09786], [-118.60007, 34.09761], [-118.60025, 34.09742], [-118.60077, 34.0971], [-118.60089, 34.09699], [-118.60096, 34.09691], [-118.60098, 34.097]]], [[[-118.60123, 34.09661], [-118.60104, 34.09701], [-118.60099, 34.09686], [-118.60102, 34.09679], [-118.60106, 34.0966], [-118.60103, 34.09619], [-118.60109, 34.09619], [-118.6011, 34.09645], [-118.60123, 34.09661]]]]} | Open Access 1 | 6426 | Topanga Creek | 26407 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | Los Angeles 6 | 1.477 | Topanga Creek | 0 | Local Other or Unknown 14 | 4 | |
1702 | 1702 | 1701 | {"type": "MultiPolygon", "coordinates": [[[[-118.10957, 33.99118], [-118.10841, 33.99393], [-118.10812, 33.99414], [-118.10776, 33.99428], [-118.10723, 33.99468], [-118.1056, 33.99616], [-118.1049, 33.99713], [-118.10463, 33.99726], [-118.10446, 33.99744], [-118.10439, 33.99781], [-118.104, 33.99834], [-118.10373, 33.99899], [-118.1034, 33.99955], [-118.09727, 34.00134], [-118.09715, 34.00171], [-118.09154, 33.99932], [-118.09273, 33.99735], [-118.09448, 33.99594], [-118.09703, 33.99726], [-118.09734, 33.99688], [-118.09773, 33.99673], [-118.09793, 33.99653], [-118.10047, 33.99561], [-118.10232, 33.9928], [-118.10204, 33.99241], [-118.10691, 33.99146], [-118.10957, 33.99118]]], [[[-118.10991, 33.9911], [-118.1069, 33.99141], [-118.102, 33.99238], [-118.10139, 33.99156], [-118.10665, 33.98858], [-118.10706, 33.9888], [-118.10745, 33.98908], [-118.10935, 33.99074], [-118.10962, 33.99093], [-118.10991, 33.9911]]]]} | No Public Access 3 | 6693 | Rio Hondo & Bike Trail | 24380 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | Los Angeles 6 | 234.812 | Rio Hondo & Bike Trail | 0 | Local Recreation Area 3 | 4 | |
986 | 986 | 985 | {"type": "MultiPolygon", "coordinates": [[[[-118.07211, 33.98316], [-118.0721, 33.98317], [-118.07151, 33.98276], [-118.07152, 33.98275], [-118.07211, 33.98316]]], [[[-118.07278, 33.98341], [-118.07277, 33.98343], [-118.07221, 33.98304], [-118.07222, 33.98303], [-118.07278, 33.98341]]], [[[-118.07399, 33.98445], [-118.07398, 33.98447], [-118.07355, 33.98418], [-118.07356, 33.98416], [-118.07399, 33.98445]]]]} | Open Access 1 | 6696 | San Gabriel River & Bike Trail | 24897 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | Los Angeles 6 | 0.082 | San Gabriel River & Bike Trail | 0 | Local Recreation Area 3 | 4 | |
7356 | 7356 | 7355 | {"type": "MultiPolygon", "coordinates": [[[[-118.0628, 33.83198], [-118.0623, 33.83332], [-118.0618, 33.83474], [-118.06169, 33.83513], [-118.06187, 33.83514], [-118.06185, 33.83522], [-118.06169, 33.83519], [-118.06164, 33.83536], [-118.0615, 33.83603], [-118.06132, 33.83727], [-118.0613, 33.83754], [-118.06124, 33.83796], [-118.06119, 33.8381], [-118.06114, 33.83843], [-118.06119, 33.83852], [-118.06131, 33.83859], [-118.06131, 33.83862], [-118.05997, 33.83865], [-118.05998, 33.83862], [-118.06021, 33.8385], [-118.06055, 33.8359], [-118.06077, 33.83494], [-118.06068, 33.83492], [-118.06058, 33.83495], [-118.0607, 33.83451], [-118.06094, 33.83379], [-118.06107, 33.83344], [-118.0628, 33.83198]]], [[[-118.06126, 33.83895], [-118.06125, 33.83898], [-118.06107, 33.83906], [-118.06104, 33.83915], [-118.06065, 33.84192], [-118.06053, 33.84251], [-118.06071, 33.84255], [-118.06063, 33.84287], [-118.06045, 33.84285], [-118.06031, 33.84332], [-118.06015, 33.84377], [-118.06033, 33.84383], [-118.06029, 33.84391], [-118.06012, 33.84387], [-118.0601, 33.84388], [-118.06005, 33.84403], [-118.06022, 33.84408], [-118.06016, 33.84424], [-118.05998, 33.84419], [-118.05961, 33.84495], [-118.05926, 33.84555], [-118.05916, 33.8457], [-118.05931, 33.84579], [-118.05914, 33.84603], [-118.05915, 33.84608], [-118.05904, 33.84601], [-118.05903, 33.84404], [-118.05933, 33.84332], [-118.05956, 33.84256], [-118.05972, 33.84173], [-118.05976, 33.84146], [-118.05936, 33.84143], [-118.05939, 33.84138], [-118.05938, 33.84131], [-118.05978, 33.84133], [-118.06007, 33.8393], [-118.0601, 33.83929], [-118.06013, 33.83911], [-118.05992, 33.83901], [-118.05993, 33.83898], [-118.06126, 33.83895]]], [[[-118.05906, 33.84647], [-118.05887, 33.84646], [-118.05885, 33.84651], [-118.05848, 33.84671], [-118.05662, 33.84944], [-118.05631, 33.84983], [-118.05507, 33.84984], [-118.05525, 33.84969], [-118.05551, 33.84942], [-118.05575, 33.84913], [-118.05749, 33.84657], [-118.0575, 33.84635], [-118.05754, 33.84628], [-118.05892, 33.84628], [-118.05906, 33.84636], [-118.05906, 33.84647]]], [[[-118.05583, 33.85032], [-118.0555, 33.85058], [-118.05501, 33.85093], [-118.05491, 33.85112], [-118.05476, 33.85123], [-118.05468, 33.85127], [-118.0546, 33.8512], [-118.04664, 33.85659], [-118.04643, 33.85693], [-118.04634, 33.85714], [-118.04633, 33.85671], [-118.04639, 33.85671], [-118.04639, 33.85664], [-118.04633, 33.85663], [-118.04632, 33.85595], [-118.04638, 33.85594], [-118.04638, 33.85586], [-118.04631, 33.85585], [-118.0463, 33.8556], [-118.04653, 33.85566], [-118.04784, 33.85479], [-118.04784, 33.85477], [-118.04764, 33.85477], [-118.04801, 33.85452], [-118.04824, 33.85453], [-118.04963, 33.85362], [-118.0504, 33.85363], [-118.0504, 33.85303], [-118.05091, 33.8527], [-118.05367, 33.85081], [-118.05441, 33.85033], [-118.05583, 33.85032]]]]} | Open Access 1 | 6698 | Coyote Creek & Bike Trail | 17737 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | Los Angeles 6 | 63.536 | Coyote Creek & Bike Trail | 0 | Local Recreation Area 3 | 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]);