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 9
- Fresno Metropolitan Flood Control District 29
- Natomas Basin Conservancy 22
- Santa Barbara Flood Control and Water Conserv. District 18
- Los Angeles County Flood Control District 17
- San Bernardino County Flood Control District 5
- Sacramento and San Joaquin Drainage District 4
- Sacramento Area Flood Control Agency 2
- Alameda County Flood Control and Water Conservation District 1
- Marin Public Works Dept/Flood Control 1
ACCESS_TYP 4
MNG_AG_TYP 1
- Flood District · 99 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
3152 | 3152 | 3151 | {"type": "MultiPolygon", "coordinates": [[[[-121.45548, 38.6727], [-121.45533, 38.67278], [-121.45527, 38.67304], [-121.45223, 38.67302], [-121.45222, 38.6748], [-121.44819, 38.67476], [-121.44761, 38.67528], [-121.44761, 38.67116], [-121.45222, 38.6712], [-121.45224, 38.67009], [-121.45374, 38.6701], [-121.45404, 38.67046], [-121.45426, 38.67077], [-121.45548, 38.6727]]], [[[-121.4527, 38.66887], [-121.45205, 38.66885], [-121.45167, 38.66839], [-121.4523, 38.6684], [-121.4527, 38.66887]]], [[[-121.45421, 38.68026], [-121.45328, 38.68025], [-121.45232, 38.68024], [-121.45258, 38.67949], [-121.4542, 38.6795], [-121.45421, 38.68026]]], [[[-121.45675, 38.66942], [-121.45676, 38.67323], [-121.45675, 38.67323], [-121.45617, 38.67309], [-121.45582, 38.67284], [-121.4544, 38.67061], [-121.45416, 38.6703], [-121.45341, 38.6694], [-121.45675, 38.66942]]], [[[-121.45675, 38.6734], [-121.45675, 38.6734], [-121.45675, 38.67432], [-121.45607, 38.67324], [-121.45675, 38.6734]]]]} | Open Access 1 | 21711 | Dry Creek Parkway | 18283 | 2128 | Sacramento Area Flood Control Agency 590 | Special District 4 | Flood District 8 | http://www.safca.org/ | Special District 4 | 2128 | Sacramento Area Flood Control Agency 580 | Special District 4 | Flood District 9 | Sacramento 41 | 79.517 | Dry Creek Parkway | 0 | Local Recreation Area 3 | 4 | |
3385 | 3385 | 3384 | {"type": "Polygon", "coordinates": [[[-121.55826, 38.7289], [-121.54862, 38.72895], [-121.5486, 38.7219], [-121.55823, 38.72189], [-121.55826, 38.7289]]]} | No Public Access 3 | 35038 | Natomas Basin Conservancy | 22668 | 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 | Sacramento 41 | 161.591 | Natomas Basin Conservancy | None 279 | |||
3477 | 3477 | 3476 | {"type": "Polygon", "coordinates": [[[-121.48575, 38.69996], [-121.48446, 38.69997], [-121.48434, 38.68531], [-121.48562, 38.68532], [-121.48575, 38.69996]]]} | No Public Access 3 | 25814 | UEDA Parkway | 26644 | 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 | Sacramento 41 | 45.052 | UEDA Parkway | 0 | Local Recreation Area 3 | 4 | |
3642 | 3642 | 3641 | {"type": "Polygon", "coordinates": [[[-121.55976, 38.81045], [-121.55308, 38.81447], [-121.5516, 38.81536], [-121.55163, 38.80843], [-121.55929, 38.80831], [-121.5588, 38.8086], [-121.55869, 38.80876], [-121.55872, 38.80892], [-121.55888, 38.80918], [-121.55948, 38.80966], [-121.55948, 38.80977], [-121.5595, 38.80998], [-121.55976, 38.81045]]]} | No Public Access 3 | 29722 | Frazer | 19069 | 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 | 85.165 | Frazer | None 303 | |||
3674 | 3674 | 3673 | {"type": "Polygon", "coordinates": [[[-121.5396, 38.7289], [-121.53955, 38.73052], [-121.53953, 38.73375], [-121.53067, 38.73375], [-121.53068, 38.72896], [-121.5396, 38.7289]]]} | No Public Access 3 | 29739 | Bianchi West | 16062 | 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 | Sacramento 41 | 102.179 | Bianchi West | 0 | None 307 | ||
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 | ||
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 | |
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 |
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 | ||
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 | ||
4692 | 4692 | 4691 | {"type": "Polygon", "coordinates": [[[-118.35865, 34.26614], [-118.35827, 34.26807], [-118.35695, 34.26791], [-118.35657, 34.2683], [-118.35593, 34.26829], [-118.35637, 34.26785], [-118.35636, 34.26783], [-118.35538, 34.26771], [-118.35584, 34.26829], [-118.35539, 34.26829], [-118.35538, 34.2683], [-118.3577, 34.27107], [-118.35758, 34.2717], [-118.35674, 34.27179], [-118.3562, 34.272], [-118.35591, 34.27203], [-118.35491, 34.27184], [-118.35328, 34.27158], [-118.35331, 34.27145], [-118.35321, 34.27142], [-118.35327, 34.27106], [-118.35311, 34.27121], [-118.35307, 34.27142], [-118.35297, 34.27141], [-118.35294, 34.27154], [-118.35225, 34.27148], [-118.3521, 34.27136], [-118.35132, 34.27105], [-118.35025, 34.27136], [-118.35001, 34.27136], [-118.34913, 34.27125], [-118.34883, 34.27106], [-118.34638, 34.27079], [-118.3461, 34.27079], [-118.34579, 34.27083], [-118.34487, 34.27088], [-118.34383, 34.27067], [-118.34275, 34.27038], [-118.34297, 34.2702], [-118.34461, 34.26985], [-118.34448, 34.26941], [-118.34405, 34.26957], [-118.34268, 34.26987], [-118.34194, 34.26956], [-118.34228, 34.26782], [-118.33932, 34.26743], [-118.33933, 34.26732], [-118.33824, 34.26717], [-118.33809, 34.26706], [-118.33774, 34.26708], [-118.33774, 34.2671], [-118.33771, 34.26708], [-118.33752, 34.26709], [-118.33678, 34.26627], [-118.33684, 34.26622], [-118.33636, 34.26564], [-118.33801, 34.26554], [-118.33802, 34.26556], [-118.33921, 34.26572], [-118.3404, 34.26577], [-118.34054, 34.26507], [-118.34096, 34.26513], [-118.34096, 34.26515], [-118.34167, 34.26525], [-118.34171, 34.26509], [-118.34256, 34.26511], [-118.34257, 34.26507], [-118.34282, 34.26507], [-118.34299, 34.26424], [-118.34363, 34.26427], [-118.34414, 34.26432], [-118.34481, 34.26442], [-118.34531, 34.26452], [-118.34609, 34.26472], [-118.3483, 34.26542], [-118.34897, 34.26558], [-118.34944, 34.26565], [-118.35413, 34.26605], [-118.35603, 34.26619], [-118.35857, 34.26622], [-118.35865, 34.26614]]]} | Restricted Access 2 | 45521 | Unnamed - Los Angeles County Flood Control District | 30959 | 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 | http://dpw.lacounty.gov/wrd/Projects/BTWMA/index.cfm | Los Angeles 6 | 242.496 | 0 | Local Other or Unknown 14 | 4 | |
4779 | 4779 | 4778 | {"type": "Polygon", "coordinates": [[[-119.7721, 36.81927], [-119.7721, 36.82034], [-119.77065, 36.82074], [-119.76932, 36.82178], [-119.76873, 36.82129], [-119.76874, 36.82111], [-119.76941, 36.82058], [-119.76952, 36.82039], [-119.76935, 36.82023], [-119.76862, 36.8208], [-119.76973, 36.81993], [-119.7721, 36.81927]]]} | No Public Access 3 | 47094 | Unnamed site - Fresno Metropolitan Flood Control District | 30753 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | Fresno 9 | 9.081 | 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 |
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]);