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 LABEL_NAME
This data as json, copyable, CSV (advanced)
DES_TP >30
MNG_AGENCY 8
- Los Angeles County Flood Control District 22
- Natomas Basin Conservancy 21
- Fresno Metropolitan Flood Control District 19
- Santa Barbara Flood Control and Water Conserv. District 14
- San Bernardino County Flood Control District 5
- Sacramento and San Joaquin Drainage District 4
- Sacramento Area Flood Control Agency 2
- Marin Public Works Dept/Flood Control 1
ACCESS_TYP 4
AGNCY_LEV 2 ✖
- Special District 87
- County 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14834 | 14834 | 14833 | {"type": "Polygon", "coordinates": [[[-119.79715, 36.81648], [-119.79715, 36.81665], [-119.79656, 36.81674], [-119.79642, 36.81675], [-119.79629, 36.81674], [-119.79602, 36.81668], [-119.7959, 36.81662], [-119.79577, 36.81654], [-119.79559, 36.81636], [-119.79551, 36.81624], [-119.79546, 36.81614], [-119.79543, 36.81597], [-119.79715, 36.81648]]]} | Open Access 1 | 47267 | Basin F Park | 30976 | 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 | http://www.fresnofloodcontrol.org/ | Fresno 9 | 1.692 | Basin F Park | 0 | Local Park 2 | 4 |
14847 | 14847 | 14846 | {"type": "Polygon", "coordinates": [[[-119.82653, 36.72499], [-119.8265, 36.72733], [-119.82652, 36.72779], [-119.82393, 36.72781], [-119.82393, 36.72836], [-119.82325, 36.72836], [-119.8233, 36.72501], [-119.82653, 36.72499]]]} | No Public Access 3 | 47270 | Basin FF | 30979 | 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 | http://www.fresnofloodcontrol.org/ | Fresno 9 | 23.139 | Basin FF | None 1276 | ||
14839 | 14839 | 14838 | {"type": "Polygon", "coordinates": [[[-119.8233, 36.72501], [-119.82328, 36.72602], [-119.82268, 36.72602], [-119.8227, 36.72501], [-119.8233, 36.72501]]]} | Open Access 1 | 47269 | Basin FF Park | 30978 | 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 | http://www.fresnofloodcontrol.org/ | Fresno 9 | 1.472 | Basin FF Park | 0 | Local Park 2 | 4 |
14848 | 14848 | 14847 | {"type": "Polygon", "coordinates": [[[-119.73175, 36.7576], [-119.73175, 36.7591], [-119.73157, 36.75909], [-119.73139, 36.75904], [-119.73131, 36.75898], [-119.73118, 36.75885], [-119.73101, 36.75863], [-119.73094, 36.75851], [-119.73087, 36.75827], [-119.73086, 36.75791], [-119.73095, 36.75784], [-119.73104, 36.75782], [-119.73145, 36.7576], [-119.73175, 36.7576]]]} | No Public Access 3 | 47271 | Basin G | 30980 | 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 | http://www.fresnofloodcontrol.org/ | Fresno 9 | 2.587 | Basin G | None 1277 | ||
14849 | 14849 | 14848 | {"type": "Polygon", "coordinates": [[[-119.79667, 36.82651], [-119.79493, 36.82652], [-119.79495, 36.82485], [-119.79576, 36.82483], [-119.79586, 36.8248], [-119.79593, 36.82475], [-119.79668, 36.82475], [-119.79667, 36.82651]]]} | Open Access 1 | 47273 | Basin H Park | 30981 | 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 | http://www.fresnofloodcontrol.org/ | Fresno 9 | 7.305 | Basin H Park | 0 | Local Park 2 | 4 |
14850 | 14850 | 14849 | {"type": "Polygon", "coordinates": [[[-119.82072, 36.82239], [-119.82071, 36.82268], [-119.81965, 36.82268], [-119.81966, 36.8217], [-119.81991, 36.8217], [-119.81997, 36.82167], [-119.82072, 36.82239]]]} | No Public Access 3 | 47275 | Basin I | 30983 | 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 | http://www.fresnofloodcontrol.org/ | Fresno 9 | 1.938 | Basin I | None 1278 | ||
4312 | 4312 | 4311 | {"type": "Polygon", "coordinates": [[[-119.82186, 36.82104], [-119.82186, 36.82267], [-119.82071, 36.82268], [-119.82071, 36.82239], [-119.81997, 36.82167], [-119.81992, 36.8217], [-119.81966, 36.8217], [-119.81966, 36.82097], [-119.82, 36.82096], [-119.82001, 36.82105], [-119.82186, 36.82104]]]} | Open Access 1 | 47276 | Basin I Park | 30984 | 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 | http://www.fresnofloodcontrol.org/ | Fresno 9 | 6.944 | Basin I Park | 0 | Local Park 2 | 4 |
14546 | 14546 | 14545 | {"type": "Polygon", "coordinates": [[[-119.68934, 36.79579], [-119.68898, 36.7962], [-119.68816, 36.7969], [-119.68789, 36.79661], [-119.68767, 36.79635], [-119.68747, 36.79603], [-119.68723, 36.79556], [-119.68708, 36.79508], [-119.68701, 36.79458], [-119.68699, 36.79421], [-119.6883, 36.79422], [-119.68907, 36.79478], [-119.68923, 36.79555], [-119.68934, 36.79579]]]} | No Public Access 3 | 47277 | Basin IE | 30985 | 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 | http://www.fresnofloodcontrol.org/ | Fresno 9 | 10.257 | Basin IE | None 1240 | ||
14882 | 14882 | 14881 | {"type": "Polygon", "coordinates": [[[-119.77005, 36.80943], [-119.77005, 36.81043], [-119.7689, 36.81042], [-119.76891, 36.80944], [-119.77005, 36.80943]]]} | No Public Access 3 | 47279 | Basin M | 30987 | 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 | http://www.fresnofloodcontrol.org/ | Fresno 9 | 2.777 | Basin M | None 1283 | ||
14881 | 14881 | 14880 | {"type": "Polygon", "coordinates": [[[-119.77005, 36.81043], [-119.77004, 36.8121], [-119.76831, 36.81211], [-119.7683, 36.81219], [-119.76777, 36.81219], [-119.76777, 36.81043], [-119.77005, 36.81043]]]} | Open Access 1 | 47278 | Basin M Park | 30986 | 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 | http://www.fresnofloodcontrol.org/ | Fresno 9 | 9.444 | Basin M Park | 0 | Local Park 2 | 4 |
14883 | 14883 | 14882 | {"type": "Polygon", "coordinates": [[[-119.71801, 36.79454], [-119.71712, 36.79489], [-119.71655, 36.79496], [-119.71417, 36.79586], [-119.71379, 36.79605], [-119.71346, 36.79608], [-119.71303, 36.7959], [-119.71246, 36.79556], [-119.71181, 36.79498], [-119.71149, 36.79491], [-119.7115, 36.79474], [-119.71144, 36.79469], [-119.71143, 36.79428], [-119.71146, 36.79424], [-119.71146, 36.79416], [-119.71194, 36.79411], [-119.71678, 36.7941], [-119.71759, 36.79416], [-119.71801, 36.79416], [-119.71801, 36.79454]]]} | No Public Access 3 | 47280 | Basin S | 30989 | 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 | http://www.fresnofloodcontrol.org/ | Fresno 9 | 20.076 | Basin S | None 1284 | ||
15014 | 15014 | 15013 | {"type": "Polygon", "coordinates": [[[-119.81224, 36.70995], [-119.81224, 36.71035], [-119.81186, 36.71035], [-119.81187, 36.71015], [-119.81185, 36.71008], [-119.81178, 36.70994], [-119.81224, 36.70995]]]} | No Public Access 3 | 47284 | Basin TT2 | 30991 | 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 | http://www.fresnofloodcontrol.org/ | Fresno 9 | 0.396 | Basin TT2 | None 1294 | ||
14878 | 14878 | 14877 | {"type": "Polygon", "coordinates": [[[-119.81224, 36.70994], [-119.81179, 36.70994], [-119.81185, 36.71007], [-119.81187, 36.71015], [-119.81186, 36.71035], [-119.81112, 36.71036], [-119.81112, 36.70874], [-119.81224, 36.70873], [-119.81224, 36.70994]]]} | Open Access 1 | 47281 | Basin TT2 Park | 30990 | 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 | http://www.fresnofloodcontrol.org/ | Fresno 9 | 4.062 | Basin TT2 Park | 0 | Local Park 2 | 4 |
15019 | 15019 | 15018 | {"type": "Polygon", "coordinates": [[[-119.74079, 36.7657], [-119.74078, 36.76666], [-119.7402, 36.76665], [-119.74007, 36.76659], [-119.73981, 36.76632], [-119.73979, 36.76623], [-119.73982, 36.76611], [-119.73984, 36.7657], [-119.74079, 36.7657]]]} | No Public Access 3 | 47285 | Basin V | 30992 | 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 | http://www.fresnofloodcontrol.org/ | Fresno 9 | 2.119 | Basin V | None 1297 | ||
15015 | 15015 | 15014 | {"type": "Polygon", "coordinates": [[[-119.83993, 36.76288], [-119.83956, 36.76288], [-119.83955, 36.76281], [-119.83778, 36.76281], [-119.83777, 36.76164], [-119.83992, 36.76164], [-119.83993, 36.76288]]]} | No Public Access 3 | 47288 | Basin XX | 30994 | 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 | http://www.fresnofloodcontrol.org/ | Fresno 9 | 6.232 | Basin XX | None 1295 | ||
15033 | 15033 | 15032 | {"type": "Polygon", "coordinates": [[[-119.83778, 36.76281], [-119.83769, 36.76281], [-119.83768, 36.76288], [-119.83567, 36.76288], [-119.83567, 36.76165], [-119.83777, 36.76164], [-119.83778, 36.76281]]]} | Open Access 1 | 47287 | Basin XX Park | 30993 | 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 | http://www.fresnofloodcontrol.org/ | Fresno 9 | 6.359 | Basin XX Park | 0 | Local Park 2 | 4 |
15158 | 15158 | 15157 | {"type": "Polygon", "coordinates": [[[-119.72501, 36.73776], [-119.72501, 36.73865], [-119.72424, 36.73868], [-119.72396, 36.73853], [-119.72369, 36.73841], [-119.72327, 36.73837], [-119.72318, 36.73827], [-119.72285, 36.73828], [-119.72286, 36.73784], [-119.72306, 36.73768], [-119.72476, 36.73768], [-119.72487, 36.73776], [-119.72501, 36.73776]]]} | No Public Access 3 | 47289 | Basin Y | 30995 | 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 | http://www.fresnofloodcontrol.org/ | Fresno 9 | 4.281 | Basin Y | None 1320 | ||
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 | ||||
13174 | 13174 | 13173 | {"type": "MultiPolygon", "coordinates": [[[[-121.56754, 38.78412], [-121.56281, 38.78417], [-121.56279, 38.78305], [-121.559, 38.78306], [-121.55896, 38.78247], [-121.55883, 38.78192], [-121.55796, 38.77936], [-121.56749, 38.77925], [-121.56754, 38.78412]]], [[[-121.57688, 38.7791], [-121.57685, 38.78379], [-121.57658, 38.7838], [-121.57635, 38.78385], [-121.57612, 38.78398], [-121.57591, 38.78415], [-121.57575, 38.78438], [-121.57562, 38.78465], [-121.5756, 38.78501], [-121.57605, 38.78658], [-121.57227, 38.7866], [-121.57225, 38.78407], [-121.56773, 38.78412], [-121.56767, 38.77925], [-121.57688, 38.7791]]]]} | No Public Access 3 | 35158 | Bennett North | 16014 | 2092 | Natomas Basin Conservancy 634 | Special District 4 | Flood District 8 | http://www.natomasbasin.org/ | Special District 4 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | Sutter 47 | 220.308 | Bennett North | None 1145 | |||
12715 | 12715 | 12714 | {"type": "Polygon", "coordinates": [[[-121.58089, 38.76428], [-121.58083, 38.77153], [-121.58085, 38.77515], [-121.58084, 38.7788], [-121.57707, 38.77889], [-121.57707, 38.77795], [-121.57912, 38.77792], [-121.57912, 38.77662], [-121.57911, 38.77661], [-121.57706, 38.77662], [-121.57704, 38.76432], [-121.58089, 38.76428]]]} | No Public Access 3 | 29729 | Bennett South | 16015 | 2092 | Natomas Basin Conservancy 634 | Special District 4 | Flood District 8 | http://www.natomasbasin.org/ | Special District 4 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | Sutter 47 | 125.162 | Bennett South | None 1111 |
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]);