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 COUNTY
This data as json, copyable, CSV (advanced)
DES_TP >30
MNG_AGENCY 9
- Fresno Metropolitan Flood Control District 29
- Natomas Basin Conservancy 22
- Santa Barbara Flood Control and Water Conserv. District 21
- San Bernardino County Flood Control District 5
- Los Angeles County Flood Control District 4
- Sacramento and San Joaquin Drainage District 3
- 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 · 88 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8304 | 8304 | 8303 | {"type": "Polygon", "coordinates": [[[-118.44775, 34.33271], [-118.44653, 34.33307], [-118.44644, 34.33288], [-118.44629, 34.33208], [-118.44632, 34.3321], [-118.44633, 34.33209], [-118.44593, 34.33133], [-118.4458, 34.33101], [-118.44556, 34.33066], [-118.44548, 34.3306], [-118.44537, 34.33055], [-118.44527, 34.33054], [-118.44516, 34.33055], [-118.44502, 34.3306], [-118.44486, 34.33072], [-118.44462, 34.33082], [-118.44455, 34.33083], [-118.44446, 34.3308], [-118.4444, 34.33074], [-118.44438, 34.33068], [-118.4444, 34.33061], [-118.44498, 34.32992], [-118.44717, 34.32993], [-118.44716, 34.33007], [-118.44756, 34.33103], [-118.44775, 34.33271]]]} | No Public Access 3 | 12723 | Flood Control | 18953 | 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 | 13.401 | Flood Control | 0 | Local Other or Unknown 14 | 4 | |
15043 | 15043 | 15042 | {"type": "Polygon", "coordinates": [[[-118.28909, 33.79761], [-118.28846, 33.79761], [-118.28848, 33.79601], [-118.28845, 33.79583], [-118.28838, 33.79573], [-118.28714, 33.79362], [-118.28712, 33.79355], [-118.28758, 33.79355], [-118.28786, 33.79404], [-118.28788, 33.79404], [-118.28789, 33.79286], [-118.28758, 33.79285], [-118.28758, 33.79272], [-118.28789, 33.79271], [-118.28789, 33.79285], [-118.28821, 33.79285], [-118.28806, 33.79286], [-118.28805, 33.79318], [-118.28805, 33.79435], [-118.2882, 33.79461], [-118.28884, 33.79461], [-118.28884, 33.79478], [-118.28832, 33.79478], [-118.28831, 33.79479], [-118.28882, 33.79567], [-118.28883, 33.79566], [-118.28884, 33.79547], [-118.289, 33.79552], [-118.28899, 33.7976], [-118.28909, 33.79761]]]} | Open Access 1 | 45707 | Canada de Palos Verdes Creek | 28604 | 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 | 6.214 | Canada de Palos Verdes Creek | 0 | Local Other or Unknown 14 | 4 | |
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 | |
16176 | 16176 | 16175 | {"type": "Polygon", "coordinates": [[[-118.02569, 34.09575], [-118.02561, 34.09631], [-118.0254, 34.0964], [-118.02208, 34.09808], [-118.02179, 34.09823], [-118.0218, 34.09825], [-118.02158, 34.09831], [-118.02096, 34.09882], [-118.02033, 34.0991], [-118.01846, 34.10006], [-118.01705, 34.10123], [-118.01607, 34.10226], [-118.01593, 34.10244], [-118.01581, 34.10265], [-118.01572, 34.10293], [-118.01569, 34.1031], [-118.01568, 34.1033], [-118.01569, 34.10344], [-118.01573, 34.10351], [-118.01587, 34.10418], [-118.01498, 34.10449], [-118.01309, 34.10512], [-118.01166, 34.10633], [-118.00712, 34.10626], [-118.00748, 34.10553], [-118.00754, 34.10551], [-118.00771, 34.10517], [-118.009, 34.10473], [-118.01107, 34.10048], [-118.01157, 34.10064], [-118.01175, 34.10074], [-118.01186, 34.10077], [-118.01189, 34.10083], [-118.01193, 34.10108], [-118.01201, 34.1012], [-118.01216, 34.10128], [-118.01232, 34.10131], [-118.01245, 34.1014], [-118.01249, 34.1015], [-118.01263, 34.10171], [-118.01281, 34.10171], [-118.01293, 34.10166], [-118.01317, 34.10165], [-118.01335, 34.10167], [-118.01359, 34.10176], [-118.01382, 34.10181], [-118.01404, 34.10192], [-118.01426, 34.10188], [-118.01451, 34.10145], [-118.0146, 34.10103], [-118.01469, 34.10074], [-118.01459, 34.10065], [-118.01441, 34.1004], [-118.0142, 34.10023], [-118.01418, 34.10009], [-118.01404, 34.09992], [-118.01387, 34.09979], [-118.01388, 34.09971], [-118.01385, 34.0997], [-118.01378, 34.09965], [-118.01376, 34.09954], [-118.01382, 34.09936], [-118.01377, 34.09909], [-118.0136, 34.09887], [-118.01357, 34.09879], [-118.01362, 34.0986], [-118.01381, 34.09841], [-118.01431, 34.09815], [-118.01466, 34.09789], [-118.01612, 34.09729], [-118.01658, 34.09718], [-118.01761, 34.0972], [-118.01891, 34.09694], [-118.01911, 34.09701], [-118.01959, 34.0969], [-118.0198, 34.09688], [-118.02015, 34.09689], [-118.02013, 34.09658], [-118.02021, 34.09675], [-118.02082, 34.09668], [-118.02534, 34.09589], [-118.02569, 34.09575]]]} | No Public Access 3 | 48171 | Los Angeles County Flood Control District Open Space | 32704 | 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 | 143.431 | Los Angeles County Flood Control District OS | 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 | |
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 |
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]);