units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
107 rows where AGNCY_TYP = 8 and MNG_AG_TYP = 9 sorted by AGNCY_WEB
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_WEB, MNG_AG_ID, PARK_URL, COUNTY, GAP_STS
DES_TP >30
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
- Sacramento and San Joaquin Drainage District 4
- San Bernardino County Flood Control 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
MNG_AG_TYP 1
- Flood District · 107 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | |||
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 | ||||
10348 | 10348 | 10347 | {"type": "Polygon", "coordinates": [[[-121.05008, 37.47695], [-121.04981, 37.47744], [-121.04901, 37.47822], [-121.04893, 37.48562], [-121.04748, 37.48584], [-121.04661, 37.48352], [-121.04645, 37.48354], [-121.04625, 37.48355], [-121.04608, 37.48354], [-121.04588, 37.48349], [-121.04563, 37.48339], [-121.04538, 37.48317], [-121.0453, 37.48304], [-121.04517, 37.48265], [-121.04504, 37.48171], [-121.04405, 37.48162], [-121.04261, 37.48197], [-121.04182, 37.4817], [-121.04167, 37.48135], [-121.0417, 37.48091], [-121.04211, 37.4806], [-121.04288, 37.48066], [-121.04371, 37.48094], [-121.04433, 37.48094], [-121.04465, 37.48038], [-121.04424, 37.4798], [-121.04404, 37.47886], [-121.0446, 37.47887], [-121.0447, 37.47961], [-121.04544, 37.48016], [-121.04697, 37.48112], [-121.04678, 37.48136], [-121.04678, 37.48138], [-121.04738, 37.4816], [-121.04842, 37.48149], [-121.04888, 37.48106], [-121.04885, 37.48074], [-121.04816, 37.4803], [-121.04815, 37.47982], [-121.04869, 37.47938], [-121.04871, 37.47807], [-121.04954, 37.47726], [-121.0498, 37.47675], [-121.04997, 37.47686], [-121.05008, 37.47695]], [[-121.04619, 37.48132], [-121.04606, 37.48124], [-121.04563, 37.48131], [-121.04513, 37.481], [-121.04492, 37.48099], [-121.04425, 37.48114], [-121.04401, 37.48116], [-121.04369, 37.4811], [-121.04297, 37.4808], [-121.04251, 37.48072], [-121.04228, 37.48073], [-121.04216, 37.48077], [-121.04206, 37.48082], [-121.04184, 37.48098], [-121.04186, 37.48134], [-121.04193, 37.48152], [-121.04206, 37.4816], [-121.04247, 37.48166], [-121.0427, 37.48174], [-121.0429, 37.48173], [-121.04383, 37.48147], [-121.0441, 37.48146], [-121.04487, 37.48158], [-121.04516, 37.48153], [-121.04569, 37.48173], [-121.0459, 37.48179], [-121.04622, 37.48158], [-121.04625, 37.48144], [-121.04619, 37.48132]]]} | Open Access 1 | 18274 | Gomes Lake | 19387 | 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 | Stanislaus 2 | 42.26 | Gomes Lake | 0 | None 906 | |||
4548 | 4548 | 4547 | {"type": "Polygon", "coordinates": [[[-121.79158, 37.67939], [-121.79158, 37.67946], [-121.79149, 37.67979], [-121.79049, 37.6798], [-121.78952, 37.6799], [-121.78852, 37.67912], [-121.78813, 37.67868], [-121.78776, 37.6781], [-121.78856, 37.67806], [-121.78921, 37.67793], [-121.78982, 37.67789], [-121.79032, 37.67778], [-121.79055, 37.67842], [-121.79149, 37.67827], [-121.79153, 37.67865], [-121.79159, 37.67899], [-121.79158, 37.67939]]]} | Open Access 1 | 22291 | Unnamed site - Alameda County Flood Control and Water Conservation District | 28716 | 2000 | Alameda County Flood Control and Water Conservation District 771 | Special District 4 | Flood District 8 | http://acfloodcontrol.org/ | Special District 4 | 2000 | Alameda County Flood Control and Water Conservation District 752 | Special District 4 | Flood District 9 | Alameda 17 | 13.147 | 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 | |
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 | |
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 | |
2616 | 2616 | 2615 | {"type": "Polygon", "coordinates": [[[-119.80757, 34.42522], [-119.80482, 34.42554], [-119.80483, 34.42523], [-119.80248, 34.4255], [-119.80248, 34.42446], [-119.8037, 34.42461], [-119.80398, 34.42462], [-119.80426, 34.4246], [-119.80465, 34.42455], [-119.80523, 34.4244], [-119.80659, 34.42394], [-119.80746, 34.4237], [-119.80757, 34.42522]]]} | Open Access 1 | 17994 | More Mesa Open Space | 22474 | 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 | 13.532 | More Mesa OS | 0 | Local Recreation Area 3 | 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 | |
4557 | 4557 | 4556 | {"type": "Polygon", "coordinates": [[[-120.47548, 34.63445], [-120.47542, 34.63898], [-120.47512, 34.63897], [-120.47516, 34.63502], [-120.47511, 34.63485], [-120.475, 34.63471], [-120.47493, 34.63465], [-120.47476, 34.63455], [-120.47466, 34.63452], [-120.4744, 34.6345], [-120.4744, 34.63445], [-120.47548, 34.63445]]]} | Open Access 1 | 35173 | Unnamed site - Santa Barbara Flood Control and Water Conserv. District | 28688 | 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 | 3.795 | 0 | Local Other or Unknown 14 | 4 | ||
4558 | 4558 | 4557 | {"type": "Polygon", "coordinates": [[[-120.4754, 34.63998], [-120.47539, 34.64067], [-120.47516, 34.64066], [-120.47517, 34.63998], [-120.4754, 34.63998]]]} | Open Access 1 | 35175 | Unnamed site - Santa Barbara Flood Control and Water Conserv. District | 28688 | 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.401 | 0 | Local Other or Unknown 14 | 4 | ||
4563 | 4563 | 4562 | {"type": "Polygon", "coordinates": [[[-120.41098, 34.87234], [-120.41098, 34.87337], [-120.41065, 34.87339], [-120.4103, 34.87346], [-120.41027, 34.87345], [-120.41017, 34.87328], [-120.41001, 34.87306], [-120.40976, 34.87284], [-120.40967, 34.87273], [-120.40957, 34.87255], [-120.40952, 34.87236], [-120.41098, 34.87234]]]} | No Public Access 3 | 35192 | Unnamed site - Santa Barbara Flood Control and Water Conserv. District | 28664 | 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 | 3.02 | 0 | Local Other or Unknown 14 | 4 | ||
4686 | 4686 | 4685 | {"type": "Polygon", "coordinates": [[[-120.45512, 34.65536], [-120.45512, 34.65556], [-120.45477, 34.65559], [-120.45508, 34.65538], [-120.45512, 34.65536]]]} | Open Access 1 | 43090 | Unnamed site - Santa Barbara Flood Control and Water Conserv. District | 28688 | 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.091 | 0 | Local Other or Unknown 14 | 4 | ||
4872 | 4872 | 4871 | {"type": "Polygon", "coordinates": [[[-119.72189, 34.42619], [-119.72175, 34.42632], [-119.72033, 34.42628], [-119.72017, 34.42625], [-119.72001, 34.4262], [-119.71978, 34.42606], [-119.71997, 34.42593], [-119.72024, 34.42605], [-119.72189, 34.42619]]]} | Unknown Access 4 | 14721 | El Mission Creek | 18515 | 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.939 | El Mission Creek | 0 | Local Other or Unknown 14 | 4 | |
5089 | 5089 | 5088 | {"type": "Polygon", "coordinates": [[[-119.73541, 34.4041], [-119.73541, 34.40426], [-119.73437, 34.40428], [-119.73407, 34.4042], [-119.73417, 34.40413], [-119.73405, 34.40365], [-119.73466, 34.40398], [-119.73541, 34.4041]]]} | Open Access 1 | 13858 | Douglas Family Reserve | 18244 | 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.023 | Douglas Family Reserve | 0 | Local Conservation Area 4 | 2 | |
5583 | 5583 | 5582 | {"type": "Polygon", "coordinates": [[[-120.47539, 34.64089], [-120.47535, 34.64386], [-120.47512, 34.64386], [-120.47516, 34.64089], [-120.47539, 34.64089]]]} | Open Access 1 | 43085 | Unnamed site - Santa Barbara Flood Control and Water Conserv. District | 28688 | 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.733 | 0 | Local Other or Unknown 14 | 4 | ||
5654 | 5654 | 5653 | {"type": "Polygon", "coordinates": [[[-120.41368, 34.87359], [-120.41207, 34.8736], [-120.41207, 34.87233], [-120.4133, 34.87231], [-120.41331, 34.87227], [-120.41366, 34.87227], [-120.41368, 34.87359]]]} | No Public Access 3 | 35181 | Unnamed site - Santa Barbara Flood Control and Water Conserv. District | 28664 | 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.145 | 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 |
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]);