superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
94 rows where MNG_AG_TYP = 9 sorted by AGNCY_WEB descending
This data as json, copyable, CSV (advanced)
Suggested facets: PARK_URL, MNG_AG_ID, AGNCY_WEB
MNG_AGENCY 9
- Fresno Metropolitan Flood Control District 29
- Natomas Basin Conservancy 20
- Santa Barbara Flood Control and Water Conserv. District 16
- Los Angeles County Flood Control District 16
- 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 · 94 ✖
Link | rowid | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB ▲ | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2314 | 2314 | 2313 | {"type": "Polygon", "coordinates": [[[-117.03429, 34.05023], [-117.03428, 34.05205], [-117.02584, 34.05208], [-117.02582, 34.0496], [-117.0264, 34.04972], [-117.02709, 34.04997], [-117.0277, 34.04982], [-117.02836, 34.04976], [-117.02879, 34.04956], [-117.02917, 34.04944], [-117.02963, 34.04933], [-117.03007, 34.04927], [-117.03008, 34.04906], [-117.03226, 34.04903], [-117.03227, 34.05024], [-117.03429, 34.05023]]]} | No Public Access 3 | Bryant St Detention Basin | 16460 | 2131 | San Bernardino County Flood Control District 865 | Special District 4 | Flood District 9 | http://www.sbcounty.gov/dpw/floodcontrol/ | Special District 4 | 51.958 | Bryant St Detention Basin | ||
6477 | 6477 | 6476 | {"type": "Polygon", "coordinates": [[[-117.30654, 34.07949], [-117.3063, 34.07973], [-117.30579, 34.07938], [-117.30538, 34.07893], [-117.30545, 34.07883], [-117.30409, 34.07757], [-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 | Lytle-Cajon Channel | 21615 | 2131 | San Bernardino County Flood Control District 865 | Special District 4 | Flood District 9 | http://www.sbcounty.gov/dpw/floodcontrol/ | Special District 4 | 4.29 | Lytle-Cajon Channel | ||
6479 | 6479 | 6478 | {"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.30491, 34.07456], [-117.30531, 34.07488], [-117.30526, 34.07493], [-117.3048, 34.07525], [-117.30449, 34.07581], [-117.3042, 34.07623], [-117.30421, 34.07678], [-117.3039, 34.07712], [-117.30332, 34.07721], [-117.30307, 34.07734], [-117.30273, 34.07744], [-117.30258, 34.07757], [-117.30151, 34.07756], [-117.30119, 34.07793], [-117.30112, 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.0787], [-117.29748, 34.07809], [-117.29775, 34.07788], [-117.3005, 34.07406], [-117.30051, 34.07392], [-117.30064, 34.07391], [-117.30065, 34.07124], [-117.30052, 34.07122], [-117.30052, 34.0704], [-117.30255, 34.0704], [-117.30257, 34.06864], [-117.30775, 34.06867]]]} | No Public Access 3 | Lytle-Cajon Channel/Warm Creek Confluence | 21616 | 2131 | San Bernardino County Flood Control District 865 | Special District 4 | Flood District 9 | http://www.sbcounty.gov/dpw/floodcontrol/ | Special District 4 | 143.917 | Lytle-Cajon Channel/Warm Creek Confluence | ||
7550 | 7550 | 7549 | {"type": "MultiPolygon", "coordinates": [[[[-117.02567, 34.04661], [-117.02269, 34.04662], [-117.02267, 34.04664], [-117.02245, 34.04664], [-117.02245, 34.0449], [-117.02567, 34.04488], [-117.02567, 34.04661]]], [[[-117.03119, 34.04474], [-117.02356, 34.04478], [-117.02356, 34.04447], [-117.02423, 34.04422], [-117.02454, 34.04413], [-117.02494, 34.04411], [-117.02527, 34.04421], [-117.02606, 34.04436], [-117.0261, 34.04433], [-117.0267, 34.04453], [-117.02707, 34.04453], [-117.0274, 34.04442], [-117.02786, 34.04413], [-117.02832, 34.04395], [-117.02955, 34.04374], [-117.03011, 34.04361], [-117.03012, 34.04364], [-117.03032, 34.04365], [-117.03064, 34.04371], [-117.03065, 34.04368], [-117.03119, 34.04367], [-117.03119, 34.04474]]], [[[-117.03337, 34.04484], [-117.03337, 34.04549], [-117.03215, 34.04542], [-117.03107, 34.04503], [-117.02836, 34.04599], [-117.02836, 34.04623], [-117.02793, 34.04629], [-117.02793, 34.0466], [-117.0258, 34.04661], [-117.0258, 34.04488], [-117.03337, 34.04484]]]]} | No Public Access 3 | Oak Glen Creek Detention Basin | 22966 | 2131 | San Bernardino County Flood Control District 865 | Special District 4 | Flood District 9 | http://www.sbcounty.gov/dpw/floodcontrol/ | Special District 4 | 45.376 | Oak Glen Creek Detention Basin | ||
14856 | 14856 | 14855 | {"type": "MultiPolygon", "coordinates": [[[[-117.18202, 34.09897], [-117.17363, 34.09896], [-117.17367, 34.10604], [-117.15672, 34.10581], [-117.1567, 34.10592], [-117.13909, 34.10642], [-117.13903, 34.10637], [-117.13901, 34.10642], [-117.12997, 34.1063], [-117.12728, 34.10623], [-117.12702, 34.10594], [-117.12678, 34.10571], [-117.12652, 34.1055], [-117.12624, 34.1053], [-117.1259, 34.10509], [-117.12558, 34.10494], [-117.12529, 34.10481], [-117.12496, 34.10469], [-117.12434, 34.10453], [-117.12369, 34.10445], [-117.12125, 34.10438], [-117.12127, 34.09896], [-117.12566, 34.09902], [-117.12566, 34.10075], [-117.13002, 34.10083], [-117.13004, 34.10082], [-117.13006, 34.09902], [-117.12566, 34.09894], [-117.12564, 34.09886], [-117.12127, 34.09879], [-117.12129, 34.09166], [-117.13014, 34.09176], [-117.13015, 34.09213], [-117.13217, 34.09216], [-117.13219, 34.09179], [-117.13252, 34.09179], [-117.13252, 34.0927], [-117.13454, 34.09272], [-117.13457, 34.09181], [-117.13861, 34.09186], [-117.13898, 34.09242], [-117.139, 34.09186], [-117.14332, 34.09182], [-117.14334, 34.09544], [-117.139, 34.09551], [-117.13902, 34.09914], [-117.15649, 34.0988], [-117.1563, 34.09169], [-117.16496, 34.09171], [-117.16503, 34.09528], [-117.16937, 34.09532], [-117.16941, 34.09712], [-117.1737, 34.09715], [-117.17371, 34.09536], [-117.18199, 34.09537], [-117.18202, 34.09897]], [[-117.1296, 34.10468], [-117.12961, 34.10454], [-117.12938, 34.10455], [-117.12938, 34.10467], [-117.1296, 34.10468]], [[-117.13015, 34.0923], [-117.13015, 34.09267], [-117.13218, 34.09268], [-117.13217, 34.09232], [-117.13015, 34.0923]]], [[[-117.15204, 34.09531], [-117.14768, 34.09537], [-117.14765, 34.09178], [-117.15197, 34.09173], [-117.15204, 34.09531]]]]} | Restricted Access 2 | East Highlands Ranch Open Space | 18370 | 2131 | San Bernardino County Flood Control District 865 | Special District 4 | Flood District 9 | http://www.sbcounty.gov/dpw/floodcontrol/ | Special District 4 | 1593.734 | East Highlands Ranch OS | ||
3717 | 3717 | 3716 | {"type": "MultiPolygon", "coordinates": [[[[-121.45548, 38.6727], [-121.45533, 38.67278], [-121.45527, 38.67304], [-121.45223, 38.67303], [-121.45222, 38.6748], [-121.44819, 38.67476], [-121.44761, 38.67528], [-121.44761, 38.67116], [-121.45221, 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.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.67323]]], [[[-121.45675, 38.6734], [-121.45675, 38.67432], [-121.45675, 38.67432], [-121.45607, 38.67324], [-121.45675, 38.6734]]]]} | Open Access 1 | Dry Creek Parkway | 18283 | 2128 | Sacramento Area Flood Control Agency 580 | Special District 4 | Flood District 9 | http://www.safca.org/ | Special District 4 | 79.542 | Dry Creek Parkway | ||
10545 | 10545 | 10544 | {"type": "MultiPolygon", "coordinates": [[[[-121.45314, 38.66939], [-121.44761, 38.66934], [-121.44762, 38.66815], [-121.44965, 38.6681], [-121.45041, 38.66816], [-121.45095, 38.66817], [-121.45137, 38.66808], [-121.4514, 38.66785], [-121.45155, 38.66774], [-121.45156, 38.66771], [-121.45158, 38.6677], [-121.45196, 38.66814], [-121.45206, 38.66811], [-121.4523, 38.6684], [-121.45169, 38.6684], [-121.45204, 38.66885], [-121.4527, 38.66887], [-121.45314, 38.66939]]], [[[-121.45308, 38.6683], [-121.45248, 38.66829], [-121.45208, 38.66783], [-121.45269, 38.66784], [-121.45308, 38.6683]]], [[[-121.4775, 38.67242], [-121.47694, 38.67244], [-121.47663, 38.67085], [-121.47545, 38.67084], [-121.47545, 38.67078], [-121.47624, 38.67078], [-121.47649, 38.67068], [-121.47651, 38.67057], [-121.47605, 38.66817], [-121.47595, 38.668], [-121.47581, 38.66789], [-121.47564, 38.66781], [-121.47542, 38.66777], [-121.47541, 38.66402], [-121.47565, 38.664], [-121.47697, 38.67084], [-121.4772, 38.67085], [-121.4775, 38.67242]]], [[[-121.48409, 38.67807], [-121.47893, 38.67807], [-121.47774, 38.67182], [-121.48407, 38.67458], [-121.48409, 38.67807]]]]} | Open Access 1 | UEDA Parkway | 26645 | 2128 | Sacramento Area Flood Control Agency 580 | Special District 4 | Flood District 9 | http://www.safca.org/ | Special District 4 | 90.589 | UEDA Parkway | ||
113 | 113 | 112 | {"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 | Bianchi West | 16062 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | http://www.natomasbasin.org/ | Special District 4 | 102.176 | Bianchi West | ||
1647 | 1647 | 1646 | {"type": "MultiPolygon", "coordinates": [[[[-121.6007, 38.7384], [-121.59981, 38.74049], [-121.59115, 38.74058], [-121.59023, 38.74346], [-121.58935, 38.74635], [-121.58496, 38.74644], [-121.58503, 38.74523], [-121.58488, 38.74496], [-121.58336, 38.74324], [-121.58352, 38.74306], [-121.58355, 38.74272], [-121.58366, 38.74229], [-121.5843, 38.74056], [-121.58581, 38.73629], [-121.59247, 38.73626], [-121.59185, 38.7384], [-121.59186, 38.73842], [-121.6007, 38.7384]]], [[[-121.58903, 38.7474], [-121.58849, 38.74926], [-121.58654, 38.7493], [-121.5865, 38.74746], [-121.58903, 38.7474]]]]} | No Public Access 3 | Atkinson | 15671 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | http://www.natomasbasin.org/ | Special District 4 | 207.44 | Atkinson | ||
1954 | 1954 | 1953 | {"type": "MultiPolygon", "coordinates": [[[[-121.56754, 38.78412], [-121.56281, 38.78417], [-121.56278, 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.78466], [-121.5756, 38.78501], [-121.57605, 38.78658], [-121.57227, 38.7866], [-121.57224, 38.78407], [-121.56773, 38.78412], [-121.56767, 38.77925], [-121.57688, 38.7791]]]]} | No Public Access 3 | Bennett North | 16014 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | http://www.natomasbasin.org/ | Special District 4 | 220.336 | Bennett North | ||
1955 | 1955 | 1954 | {"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 | Bennett South | 16015 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | http://www.natomasbasin.org/ | Special District 4 | 125.171 | Bennett South | ||
2122 | 2122 | 2121 | {"type": "Polygon", "coordinates": [[[-121.58368, 38.77894], [-121.58367, 38.78624], [-121.57862, 38.78635], [-121.57859, 38.78626], [-121.57859, 38.78505], [-121.57857, 38.78483], [-121.57847, 38.78457], [-121.57822, 38.78433], [-121.57798, 38.78417], [-121.57743, 38.78397], [-121.57704, 38.78389], [-121.57707, 38.7791], [-121.58368, 38.77894]]]} | No Public Access 3 | Bolen North | 16237 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | http://www.natomasbasin.org/ | Special District 4 | 107.053 | Bolen North | ||
2123 | 2123 | 2122 | {"type": "Polygon", "coordinates": [[[-121.5898, 38.77492], [-121.58979, 38.77858], [-121.58084, 38.7788], [-121.58085, 38.77515], [-121.5898, 38.77492]]]} | No Public Access 3 | Bolen South | 16238 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | http://www.natomasbasin.org/ | Special District 4 | 77.853 | Bolen South | ||
2124 | 2124 | 2123 | {"type": "MultiPolygon", "coordinates": [[[[-121.59008, 38.78617], [-121.59003, 38.79179], [-121.58388, 38.78653], [-121.58388, 38.78637], [-121.59008, 38.78617]]], [[[-121.59012, 38.77873], [-121.59011, 38.78228], [-121.59002, 38.78232], [-121.58999, 38.78603], [-121.58388, 38.78623], [-121.58389, 38.77893], [-121.59012, 38.77873]]]]} | No Public Access 3 | Bolen West | 16239 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | http://www.natomasbasin.org/ | Special District 4 | 150.02 | Bolen West | ||
2763 | 2763 | 2762 | {"type": "MultiPolygon", "coordinates": [[[[-121.51211, 38.73594], [-121.5053, 38.73594], [-121.4936, 38.73517], [-121.49357, 38.73262], [-121.492, 38.73261], [-121.492, 38.73089], [-121.49354, 38.73089], [-121.49355, 38.73073], [-121.49199, 38.73072], [-121.49192, 38.73045], [-121.49182, 38.73023], [-121.49167, 38.73], [-121.49147, 38.72979], [-121.49128, 38.72963], [-121.49109, 38.72951], [-121.49064, 38.72931], [-121.49032, 38.72913], [-121.49007, 38.72895], [-121.49007, 38.72887], [-121.49617, 38.72886], [-121.49617, 38.7293], [-121.49615, 38.72941], [-121.49619, 38.72953], [-121.49628, 38.72963], [-121.49641, 38.72969], [-121.49656, 38.72971], [-121.49671, 38.72969], [-121.49683, 38.72962], [-121.49685, 38.72975], [-121.49752, 38.72982], [-121.49755, 38.72954], [-121.49765, 38.72954], [-121.4977, 38.72935], [-121.49817, 38.72938], [-121.49818, 38.72885], [-121.51206, 38.72883], [-121.51211, 38.73594]], [[-121.50409, 38.72946], [-121.50409, 38.72907], [-121.50368, 38.72907], [-121.50368, 38.72947], [-121.50409, 38.72946]], [[-121.50715, 38.72915], [-121.50714, 38.72913], [-121.50677, 38.7291], [-121.50648, 38.72911], [-121.50584, 38.7291], [-121.50595, 38.72985], [-121.5059, 38.72993], [-121.5059, 38.73022], [-121.50588, 38.73035], [-121.50575, 38.73041], [-121.50568, 38.73055], [-121.50563, 38.7312], [-121.50566, 38.73125], [-121.50695, 38.73036], [-121.50694, 38.73024], [-121.50705, 38.72956], [-121.50715, 38.72915]]], [[[-121.56722, 38.72886], [-121.55827, 38.72891], [-121.55829, 38.73595], [-121.54081, 38.73595], [-121.54077, 38.72191], [-121.5486, 38.7219], [-121.54862, 38.72893], [-121.54863, 38.72895], [-121.55825, 38.7289], [-121.55823, 38.72189], [-121.56715, 38.72188], [-121.56722, 38.72886]]]]} | No Public Access 3 | Central Basin | 17046 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | http://www.natomasbasin.org/ | Special District 4 | 883.597 | Central Basin | ||
3122 | 3122 | 3121 | {"type": "Polygon", "coordinates": [[[-121.56715, 38.72188], [-121.55823, 38.72189], [-121.5582, 38.71449], [-121.56014, 38.7145], [-121.56708, 38.71449], [-121.56715, 38.72188]]]} | No Public Access 3 | Elsie | 18605 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | http://www.natomasbasin.org/ | Special District 4 | 156.93 | Elsie | ||
3339 | 3339 | 3338 | {"type": "MultiPolygon", "coordinates": [[[[-121.56274, 38.64215], [-121.55175, 38.64219], [-121.55177, 38.63957], [-121.56212, 38.63953], [-121.56243, 38.64112], [-121.56256, 38.64159], [-121.56274, 38.64215]]], [[[-121.56974, 38.6564], [-121.5697, 38.66347], [-121.5552, 38.66347], [-121.55514, 38.66338], [-121.55569, 38.66199], [-121.55597, 38.6616], [-121.55662, 38.66106], [-121.55701, 38.66063], [-121.55734, 38.66024], [-121.55755, 38.65989], [-121.55802, 38.65871], [-121.55839, 38.65818], [-121.55884, 38.65793], [-121.55992, 38.65762], [-121.56053, 38.65731], [-121.56097, 38.65689], [-121.56108, 38.65639], [-121.56974, 38.6564]]], [[[-121.56061, 38.631], [-121.55811, 38.631], [-121.55878, 38.63463], [-121.55707, 38.63464], [-121.55706, 38.63442], [-121.55574, 38.62732], [-121.55758, 38.62732], [-121.55858, 38.62737], [-121.56002, 38.62737], [-121.56004, 38.62778], [-121.5601, 38.62831], [-121.56061, 38.631]]], [[[-121.56747, 38.64782], [-121.56742, 38.65624], [-121.56279, 38.65624], [-121.56281, 38.65341], [-121.55849, 38.65339], [-121.5583, 38.65285], [-121.55758, 38.65156], [-121.55699, 38.65089], [-121.55642, 38.64912], [-121.56515, 38.6491], [-121.56711, 38.64756], [-121.56747, 38.64782]]]]} | No Public Access 3 | Fisherman's Lake | 18921 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | http://www.natomasbasin.org/ | Special District 4 | 462.047 | Fisherman's Lake | ||
4366 | 4366 | 4365 | {"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.80978], [-121.5595, 38.80998], [-121.55976, 38.81045]]]} | No Public Access 3 | Frazer | 19069 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | http://www.natomasbasin.org/ | Special District 4 | 85.164 | Frazer | ||
5201 | 5201 | 5200 | {"type": "Polygon", "coordinates": [[[-121.58089, 38.76428], [-121.57704, 38.76432], [-121.57698, 38.75393], [-121.57986, 38.75654], [-121.57991, 38.75691], [-121.58081, 38.76113], [-121.58089, 38.76428]]]} | No Public Access 3 | Huffman East | 20138 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | http://www.natomasbasin.org/ | Special District 4 | 74.081 | Huffman East | ||
5289 | 5289 | 5288 | {"type": "Polygon", "coordinates": [[[-121.59372, 38.74945], [-121.59374, 38.74956], [-121.5937, 38.74972], [-121.59337, 38.75048], [-121.59196, 38.75395], [-121.59179, 38.7545], [-121.59167, 38.75505], [-121.59145, 38.75654], [-121.57989, 38.75672], [-121.57985, 38.75653], [-121.57698, 38.75393], [-121.57695, 38.74977], [-121.58419, 38.7496], [-121.58418, 38.75113], [-121.58333, 38.75115], [-121.58332, 38.75312], [-121.58573, 38.75314], [-121.58577, 38.74956], [-121.59366, 38.74939], [-121.59372, 38.74945]]]} | No Public Access 3 | Huffman West | 20139 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | http://www.natomasbasin.org/ | Special District 4 | 232.744 | Huffman West |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);