units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
108 rows where MNG_AG_TYP = 9
This data as json, copyable, CSV (advanced)
DES_TP >30
MNG_AGENCY 8
- Fresno Metropolitan Flood Control District 25
- Natomas Basin Conservancy 18
- Los Angeles County Flood Control District 16
- Santa Barbara Flood Control and Water Conserv. District 6
- San Bernardino County Flood Control District 5
- Sacramento Area Flood Control Agency 1
- Sacramento and San Joaquin Drainage District 1
- Marin Public Works Dept/Flood Control 1
ACCESS_TYP 4
MNG_AG_TYP 1
- Flood District · 73 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
7382 | 7382 | 7381 | {"type": "Polygon", "coordinates": [[[-117.78983, 34.12756], [-117.78982, 34.12783], [-117.78752, 34.13014], [-117.78637, 34.13038], [-117.78555, 34.13045], [-117.78534, 34.13051], [-117.78522, 34.13055], [-117.78495, 34.13071], [-117.78485, 34.13079], [-117.78469, 34.13097], [-117.78457, 34.13119], [-117.78445, 34.1317], [-117.78419, 34.13188], [-117.78382, 34.1317], [-117.78399, 34.1297], [-117.7855, 34.12892], [-117.78769, 34.12891], [-117.7877, 34.12836], [-117.78983, 34.12756]]]} | Open Access 1 | 6806 | San Dimas Wash | 24876 | 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 | 20.063 | San Dimas Wash | None 614 | |||
7508 | 7508 | 7507 | {"type": "MultiPolygon", "coordinates": [[[[-118.02016, 34.0969], [-118.0198, 34.09688], [-118.01959, 34.0969], [-118.01911, 34.09701], [-118.0189, 34.09694], [-118.01761, 34.0972], [-118.01658, 34.09718], [-118.0164, 34.09722], [-118.01612, 34.09729], [-118.01466, 34.09789], [-118.01431, 34.09815], [-118.01381, 34.09841], [-118.01362, 34.0986], [-118.01357, 34.09879], [-118.0136, 34.09887], [-118.01377, 34.09908], [-118.01382, 34.09936], [-118.01376, 34.09954], [-118.01378, 34.09965], [-118.01385, 34.0997], [-118.01389, 34.09971], [-118.01387, 34.09979], [-118.01404, 34.09992], [-118.01418, 34.10009], [-118.0142, 34.10023], [-118.01441, 34.1004], [-118.01459, 34.10065], [-118.01469, 34.10074], [-118.0146, 34.10103], [-118.01451, 34.10145], [-118.01426, 34.10188], [-118.01405, 34.10192], [-118.01382, 34.10181], [-118.01359, 34.10176], [-118.01335, 34.10167], [-118.01317, 34.10165], [-118.01293, 34.10166], [-118.01281, 34.10171], [-118.01263, 34.10171], [-118.01249, 34.1015], [-118.01245, 34.1014], [-118.01232, 34.10131], [-118.01216, 34.10128], [-118.01201, 34.1012], [-118.01193, 34.10108], [-118.01189, 34.10083], [-118.01186, 34.10077], [-118.01175, 34.10074], [-118.01157, 34.10064], [-118.01107, 34.10048], [-118.01123, 34.10014], [-118.01033, 34.09983], [-118.01043, 34.09961], [-118.01123, 34.09967], [-118.01206, 34.09925], [-118.01293, 34.0984], [-118.01387, 34.098], [-118.01443, 34.09761], [-118.01638, 34.09673], [-118.01739, 34.09682], [-118.02013, 34.09652], [-118.02016, 34.0969]]], [[[-118.02033, 34.09914], [-118.02027, 34.09935], [-118.01857, 34.10015], [-118.01711, 34.10129], [-118.01597, 34.10246], [-118.0159, 34.10259], [-118.01579, 34.10286], [-118.01576, 34.10299], [-118.01574, 34.10324], [-118.01575, 34.10339], [-118.01577, 34.10348], [-118.01575, 34.10348], [-118.01572, 34.10338], [-118.01572, 34.10318], [-118.01575, 34.10295], [-118.01581, 34.10274], [-118.01593, 34.1025], [-118.01609, 34.10228], [-118.01709, 34.10125], [-118.01848, 34.10009], [-118.02033, 34.09914]]]]} | Open Access 1 | 7037 | Peck Road Water Conservation Park | 23558 | 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 | 27.496 | Peck Road Water Conservation Park | None 624 | |||
8226 | 8226 | 8225 | {"type": "MultiPolygon", "coordinates": [[[[-118.39803, 34.33154], [-118.3977, 34.33187], [-118.39753, 34.33221], [-118.39757, 34.33239], [-118.39737, 34.33259], [-118.39713, 34.33296], [-118.39723, 34.33309], [-118.39705, 34.33349], [-118.39717, 34.33365], [-118.39712, 34.3337], [-118.39693, 34.33361], [-118.39669, 34.32974], [-118.39678, 34.32974], [-118.39673, 34.32982], [-118.39691, 34.33018], [-118.39675, 34.33035], [-118.39698, 34.33065], [-118.39722, 34.33079], [-118.39714, 34.33099], [-118.39747, 34.3312], [-118.39755, 34.3313], [-118.39803, 34.33154]]], [[[-118.40538, 34.33402], [-118.40103, 34.33386], [-118.40101, 34.33713], [-118.39708, 34.33708], [-118.39693, 34.33374], [-118.39715, 34.33384], [-118.39734, 34.33366], [-118.3972, 34.33348], [-118.39737, 34.33307], [-118.39728, 34.33295], [-118.39748, 34.33265], [-118.39771, 34.33242], [-118.39766, 34.33222], [-118.39781, 34.33192], [-118.39822, 34.33152], [-118.39805, 34.33141], [-118.39764, 34.33122], [-118.39757, 34.33112], [-118.39729, 34.33095], [-118.39738, 34.33074], [-118.39707, 34.33057], [-118.39691, 34.33035], [-118.39707, 34.3302], [-118.39687, 34.32982], [-118.39693, 34.32974], [-118.39846, 34.32976], [-118.39852, 34.32957], [-118.39898, 34.32907], [-118.39906, 34.32891], [-118.40003, 34.32864], [-118.40055, 34.32838], [-118.40086, 34.32802], [-118.40088, 34.32853], [-118.4008, 34.32863], [-118.40014, 34.32961], [-118.40005, 34.32969], [-118.39991, 34.32975], [-118.39991, 34.32977], [-118.40014, 34.32977], [-118.40022, 34.3297], [-118.40089, 34.32872], [-118.40095, 34.32978], [-118.40521, 34.32981], [-118.40538, 34.33402]]]]} | No Public Access 3 | 12544 | Pacoima Wash | 23311 | 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 | 125.037 | Pacoima Wash | None 686 | |||
8295 | 8295 | 8294 | {"type": "Polygon", "coordinates": [[[-118.44066, 34.32991], [-118.44064, 34.33152], [-118.43961, 34.33184], [-118.43917, 34.33239], [-118.43727, 34.33306], [-118.43591, 34.33306], [-118.43464, 34.33355], [-118.4344, 34.33311], [-118.43366, 34.33287], [-118.43328, 34.33317], [-118.43276, 34.33272], [-118.43306, 34.33152], [-118.43441, 34.33071], [-118.43503, 34.33053], [-118.43502, 34.3299], [-118.43183, 34.32988], [-118.43185, 34.3275], [-118.43215, 34.32748], [-118.43219, 34.32749], [-118.43222, 34.32753], [-118.43237, 34.32753], [-118.43239, 34.32749], [-118.43242, 34.32747], [-118.43272, 34.32745], [-118.43274, 34.32766], [-118.43307, 34.32764], [-118.43308, 34.32772], [-118.43659, 34.32755], [-118.43659, 34.32747], [-118.43694, 34.32744], [-118.43744, 34.32745], [-118.43745, 34.32741], [-118.43782, 34.32741], [-118.43782, 34.3299], [-118.44066, 34.32991]]]} | No Public Access 3 | 12714 | 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 | 85.213 | Flood Control | 0 | Local Other or Unknown 14 | 4 | |
8296 | 8296 | 8295 | {"type": "Polygon", "coordinates": [[[-118.46627, 34.32993], [-118.46601, 34.32993], [-118.466, 34.32966], [-118.46531, 34.32965], [-118.46531, 34.32993], [-118.46492, 34.32992], [-118.4651, 34.32938], [-118.46586, 34.32944], [-118.46627, 34.32993]]]} | No Public Access 3 | 12715 | 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 | 0.889 | Flood Control | 0 | Local Other or Unknown 14 | 4 | |
8298 | 8298 | 8297 | {"type": "Polygon", "coordinates": [[[-118.42996, 34.33076], [-118.42998, 34.3313], [-118.42978, 34.33175], [-118.42986, 34.33266], [-118.42959, 34.33271], [-118.42929, 34.33205], [-118.42879, 34.33196], [-118.4284, 34.33155], [-118.42781, 34.33143], [-118.42735, 34.33145], [-118.42681, 34.33168], [-118.42663, 34.3315], [-118.42709, 34.33123], [-118.42776, 34.33103], [-118.42849, 34.33092], [-118.42842, 34.33034], [-118.42684, 34.33026], [-118.42679, 34.33], [-118.42852, 34.32962], [-118.42869, 34.32985], [-118.42874, 34.32985], [-118.42897, 34.32974], [-118.42912, 34.3296], [-118.42922, 34.32943], [-118.42925, 34.32922], [-118.4294, 34.32923], [-118.4294, 34.32942], [-118.42954, 34.33013], [-118.42957, 34.33017], [-118.42962, 34.3302], [-118.42968, 34.3302], [-118.42974, 34.33019], [-118.4298, 34.33026], [-118.42957, 34.33035], [-118.42956, 34.33037], [-118.42969, 34.33054], [-118.42996, 34.33076]]]} | No Public Access 3 | 12716 | 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 | 12.167 | Flood Control | 0 | Local Other or Unknown 14 | 4 | |
8300 | 8300 | 8299 | {"type": "Polygon", "coordinates": [[[-118.46565, 34.33048], [-118.46562, 34.33062], [-118.46563, 34.33073], [-118.46517, 34.33077], [-118.46516, 34.33138], [-118.46458, 34.332], [-118.46458, 34.33243], [-118.46432, 34.33311], [-118.4639, 34.3328], [-118.46417, 34.33245], [-118.46393, 34.33219], [-118.46382, 34.33173], [-118.46412, 34.33168], [-118.46385, 34.33059], [-118.46422, 34.33041], [-118.46428, 34.3302], [-118.4648, 34.33011], [-118.46482, 34.33008], [-118.46531, 34.33009], [-118.46526, 34.33043], [-118.46565, 34.33048]]]} | No Public Access 3 | 12719 | 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 | 6.732 | Flood Control | 0 | Local Other or Unknown 14 | 4 | |
8301 | 8301 | 8300 | {"type": "Polygon", "coordinates": [[[-118.45954, 34.32608], [-118.45903, 34.32693], [-118.45897, 34.32748], [-118.45866, 34.32801], [-118.45855, 34.32801], [-118.45828, 34.32695], [-118.45824, 34.32695], [-118.45826, 34.32561], [-118.45823, 34.3255], [-118.458, 34.32543], [-118.4579, 34.32485], [-118.45808, 34.32479], [-118.45807, 34.32476], [-118.45823, 34.32469], [-118.45797, 34.32414], [-118.45813, 34.32418], [-118.45857, 34.32507], [-118.45921, 34.32507], [-118.45954, 34.32608]]]} | No Public Access 3 | 12720 | 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 | 7.386 | Flood Control | 0 | Local Other or Unknown 14 | 4 | |
8302 | 8302 | 8301 | {"type": "MultiPolygon", "coordinates": [[[[-118.47595, 34.32868], [-118.47522, 34.32881], [-118.47516, 34.32877], [-118.475, 34.3286], [-118.47468, 34.32886], [-118.47418, 34.32872], [-118.47382, 34.32824], [-118.47375, 34.32796], [-118.47388, 34.32773], [-118.47425, 34.32782], [-118.47464, 34.3274], [-118.47489, 34.32723], [-118.475, 34.32723], [-118.47498, 34.32741], [-118.47504, 34.32747], [-118.47515, 34.32748], [-118.47595, 34.32868]]], [[[-118.47687, 34.33028], [-118.47677, 34.33041], [-118.47584, 34.32924], [-118.4757, 34.32915], [-118.4762, 34.32905], [-118.47683, 34.33027], [-118.47687, 34.33028]]]]} | No Public Access 3 | 12721 | 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 | 6.178 | Flood Control | 0 | Local Other or Unknown 14 | 4 | |
8303 | 8303 | 8302 | {"type": "Polygon", "coordinates": [[[-118.47061, 34.3327], [-118.47016, 34.33284], [-118.46964, 34.33229], [-118.46861, 34.33235], [-118.46846, 34.33475], [-118.46779, 34.33473], [-118.46763, 34.33148], [-118.46832, 34.33146], [-118.46882, 34.3306], [-118.46881, 34.33058], [-118.46838, 34.33055], [-118.46839, 34.33011], [-118.46915, 34.33012], [-118.46944, 34.33023], [-118.46958, 34.33035], [-118.47003, 34.33102], [-118.47061, 34.3327]]]} | No Public Access 3 | 12722 | 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 | 15.975 | Flood Control | 0 | Local Other or Unknown 14 | 4 | |
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 | |
8352 | 8352 | 8351 | {"type": "Polygon", "coordinates": [[[-117.30654, 34.07949], [-117.3063, 34.07973], [-117.30578, 34.07938], [-117.30538, 34.07893], [-117.30545, 34.07884], [-117.30409, 34.07756], [-117.30366, 34.07727], [-117.30308, 34.07734], [-117.30332, 34.07721], [-117.3039, 34.07712], [-117.30416, 34.07684], [-117.30422, 34.07705], [-117.30575, 34.07856], [-117.30654, 34.07949]]]} | No Public Access 3 | 12937 | Lytle-Cajon Channel | 21615 | 2131 | San Bernardino County Flood Control District 891 | Special District 4 | Flood District 8 | http://www.sbcounty.gov/dpw/floodcontrol/ | Special District 4 | 2131 | San Bernardino County Flood Control District 865 | Special District 4 | Flood District 9 | San Bernardino 22 | 4.286 | Lytle-Cajon Channel | None 696 | |||
8353 | 8353 | 8352 | {"type": "Polygon", "coordinates": [[[-117.30775, 34.06867], [-117.30766, 34.06901], [-117.30769, 34.06982], [-117.30768, 34.07016], [-117.30758, 34.07063], [-117.30747, 34.07094], [-117.3073, 34.07133], [-117.30711, 34.07166], [-117.30698, 34.07184], [-117.30659, 34.07226], [-117.30613, 34.07269], [-117.30491, 34.07389], [-117.3049, 34.07457], [-117.30531, 34.07488], [-117.30526, 34.07493], [-117.3048, 34.07525], [-117.30449, 34.07581], [-117.3042, 34.07624], [-117.30421, 34.07678], [-117.3039, 34.07712], [-117.30332, 34.07721], [-117.30308, 34.07734], [-117.30273, 34.07744], [-117.30258, 34.07757], [-117.30151, 34.07756], [-117.30119, 34.07793], [-117.30111, 34.07804], [-117.30081, 34.07893], [-117.30044, 34.07934], [-117.30036, 34.07934], [-117.2989, 34.0811], [-117.29768, 34.07934], [-117.29728, 34.07871], [-117.29742, 34.07871], [-117.29748, 34.07809], [-117.29775, 34.07788], [-117.3005, 34.07406], [-117.30051, 34.07392], [-117.30064, 34.07392], [-117.30065, 34.07123], [-117.30052, 34.07122], [-117.30052, 34.0704], [-117.30255, 34.0704], [-117.30257, 34.06864], [-117.30775, 34.06867]]]} | No Public Access 3 | 12938 | Lytle-Cajon Channel/Warm Creek Confluence | 21616 | 2131 | San Bernardino County Flood Control District 891 | Special District 4 | Flood District 8 | http://www.sbcounty.gov/dpw/floodcontrol/ | Special District 4 | 2131 | San Bernardino County Flood Control District 865 | Special District 4 | Flood District 9 | San Bernardino 22 | 143.889 | Lytle-Cajon Channel/Warm Creek Confluence | 0 | None 697 | ||
8562 | 8562 | 8561 | {"type": "Polygon", "coordinates": [[[-120.44506, 34.91474], [-120.44502, 34.91664], [-120.44479, 34.91663], [-120.44483, 34.91473], [-120.44506, 34.91474]]]} | Open Access 1 | 13574 | Santa Maria Valley Muli-Purpose Trail | 28709 | 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.107 | Santa Maria Valley Muli-Purpose Trail | 0 | Local Recreation Area 3 | 4 | |
8831 | 8831 | 8830 | {"type": "Polygon", "coordinates": [[[-119.51853, 34.40523], [-119.51825, 34.40559], [-119.51773, 34.40641], [-119.51755, 34.40688], [-119.51721, 34.40679], [-119.51826, 34.40517], [-119.51853, 34.40523]]]} | Open Access 1 | 16039 | Franklin Park | 19067 | 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.208 | Franklin Park | 0 | Local Park 2 | 4 | |
10118 | 10118 | 10117 | {"type": "MultiPolygon", "coordinates": [[[[-122.53534, 38.07672], [-122.53156, 38.07807], [-122.53133, 38.07813], [-122.53036, 38.0783], [-122.52863, 38.07883], [-122.52842, 38.07833], [-122.52729, 38.07791], [-122.52563, 38.07464], [-122.52596, 38.07439], [-122.52574, 38.07374], [-122.5243, 38.07215], [-122.52311, 38.07182], [-122.52237, 38.07141], [-122.5218, 38.07101], [-122.52315, 38.06994], [-122.52495, 38.06973], [-122.52495, 38.06971], [-122.52738, 38.06943], [-122.52761, 38.07048], [-122.52826, 38.07145], [-122.52875, 38.07227], [-122.52886, 38.07233], [-122.52895, 38.07248], [-122.52897, 38.07274], [-122.52924, 38.0732], [-122.52982, 38.07335], [-122.53044, 38.07297], [-122.53091, 38.07302], [-122.53132, 38.07324], [-122.53149, 38.07354], [-122.53148, 38.07382], [-122.53175, 38.0742], [-122.53227, 38.07428], [-122.53262, 38.07445], [-122.53285, 38.07487], [-122.53314, 38.07482], [-122.53391, 38.07456], [-122.53469, 38.07593], [-122.53489, 38.07618], [-122.53514, 38.07644], [-122.53534, 38.07672]]], [[[-122.53462, 38.08549], [-122.53457, 38.08664], [-122.51994, 38.09789], [-122.51972, 38.09772], [-122.51576, 38.10081], [-122.51169, 38.09693], [-122.51111, 38.09776], [-122.50743, 38.09739], [-122.50179, 38.09877], [-122.5016, 38.09898], [-122.50144, 38.09994], [-122.49266, 38.09971], [-122.49517, 38.09326], [-122.49571, 38.09316], [-122.49813, 38.09207], [-122.50068, 38.09055], [-122.50189, 38.08967], [-122.50306, 38.08829], [-122.50434, 38.08636], [-122.50476, 38.08672], [-122.50462, 38.0869], [-122.50547, 38.08821], [-122.5071, 38.09337], [-122.50961, 38.09217], [-122.51401, 38.08952], [-122.51417, 38.09043], [-122.51543, 38.09181], [-122.51569, 38.09196], [-122.5162, 38.09211], [-122.51883, 38.09149], [-122.51989, 38.09089], [-122.5217, 38.08911], [-122.52284, 38.08835], [-122.52335, 38.08812], [-122.52446, 38.08801], [-122.52504, 38.08804], [-122.5258, 38.08817], [-122.52699, 38.08823], [-122.52785, 38.08799], [-122.52841, 38.08753], [-122.52891, 38.08677], [-122.52898, 38.08609], [-122.52863, 38.08491], [-122.52814, 38.08411], [-122.52711, 38.08293], [-122.52684, 38.08204], [-122.5271, 38.08141], [-122.52804, 38.08099], [-122.52999, 38.0817], [-122.53168, 38.08273], [-122.53318, 38.08368], [-122.53412, 38.08444], [-122.53462, 38.08549]]], [[[-122.55951, 38.09996], [-122.55862, 38.10039], [-122.55845, 38.10046], [-122.55726, 38.0999], [-122.5569, 38.09995], [-122.55686, 38.09998], [-122.5528, 38.09898], [-122.55176, 38.09958], [-122.5507, 38.09887], [-122.54961, 38.10549], [-122.54399, 38.10359], [-122.54188, 38.10374], [-122.53904, 38.10259], [-122.53854, 38.10213], [-122.5352, 38.10117], [-122.5351, 38.10123], [-122.53421, 38.10043], [-122.53427, 38.10035], [-122.53466, 38.10075], [-122.53542, 38.10118], [-122.53848, 38.10186], [-122.5397, 38.10179], [-122.54035, 38.10017], [-122.5423, 38.10081], [-122.54299, 38.10036], [-122.54308, 38.10049], [-122.54317, 38.10043], [-122.54344, 38.09978], [-122.54308, 38.09854], [-122.54219, 38.09765], [-122.54108, 38.09662], [-122.54019, 38.09627], [-122.53982, 38.09454], [-122.53834, 38.09349], [-122.53683, 38.09307], [-122.53388, 38.0938], [-122.53231, 38.09484], [-122.53214, 38.09646], [-122.53264, 38.0976], [-122.53368, 38.09778], [-122.53315, 38.09841], [-122.52794, 38.09337], [-122.52831, 38.09329], [-122.52831, 38.09327], [-122.5281, 38.09305], [-122.52858, 38.09268], [-122.5286, 38.09268], [-122.53, 38.09158], [-122.53, 38.09157], [-122.53247, 38.08961], [-122.53254, 38.08966], [-122.53422, 38.08837], [-122.53534, 38.08745], [-122.53546, 38.08781], [-122.53566, 38.08815], [-122.53593, 38.08846], [-122.5361, 38.08859], [-122.53646, 38.08883], [-122.53667, 38.08893], [-122.53722, 38.08914], [-122.53754, 38.0893], [-122.53784, 38.08947], [-122.53812, 38.08967], [-122.54201, 38.09264], [-122.54214, 38.09272], [-122.54228, 38.09278], [-122.54243, 38.09282], [-122.5426, 38.09285], [-122.54276, 38.09285], [-122.54292, 38.09282], [-122.54308, 38.09278], [-122.54365, 38.09254], [-122.54418, 38.09237], [-122.54472, 38.09223], [-122.54588, 38.09203], [-122.54644, 38.09197], [-122.54672, 38.09198], [-122.547, 38.092], [-122.54728, 38.09205], [-122.54755, 38.09212], [-122.5479, 38.09223], [-122.54757, 38.09267], [-122.54778, 38.09278], [-122.54813, 38.09233], [-122.54838, 38.09246], [-122.54862, 38.09261], [-122.54883, 38.09277], [-122.54903, 38.09295], [-122.5492, 38.09314], [-122.54935, 38.09335], [-122.54948, 38.09356], [-122.55018, 38.09494], [-122.55026, 38.09517], [-122.55031, 38.09539], [-122.55036, 38.09576], [-122.55042, 38.09588], [-122.5505, 38.096], [-122.55061, 38.09611], [-122.55074, 38.09619], [-122.55088, 38.09626], [-122.55104, 38.09631], [-122.55121, 38.09633], [-122.55146, 38.09632], [-122.55563, 38.09543], [-122.55597, 38.09584], [-122.55612, 38.09581], [-122.55679, 38.09661], [-122.55677, 38.09667], [-122.55898, 38.09929], [-122.55951, 38.09996]], [[-122.54938, 38.09799], [-122.54938, 38.09798], [-122.54655, 38.09688], [-122.54664, 38.09628], [-122.54662, 38.09627], [-122.54651, 38.09694], [-122.54938, 38.09799]]]]} | Open Access 1 | 17572 | Marin County Flood Control | 6348 | 2072 | Marin Public Works Dept/Flood Control 945 | Special District 4 | Flood District 8 | http://www.marincounty.org/depts/pw/divisions/flood-control | Special District 4 | 2072 | Marin Public Works Dept/Flood Control 917 | Special District 4 | Flood District 9 | Marin 23 | 1294.68 | Marin County Flood Control | 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]);