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 MNG_AGENCY 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
682 | 682 | 681 | {"type": "MultiPolygon", "coordinates": [[[[-122.53462, 38.08549], [-122.53457, 38.08664], [-122.51994, 38.09789], [-122.51972, 38.09773], [-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.50188, 38.08967], [-122.50306, 38.08829], [-122.50434, 38.08636], [-122.50476, 38.08672], [-122.50463, 38.0869], [-122.50547, 38.08821], [-122.50711, 38.09336], [-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.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.52595, 38.07438], [-122.52574, 38.07374], [-122.5243, 38.07215], [-122.5231, 38.07182], [-122.52237, 38.07141], [-122.5218, 38.07101], [-122.52315, 38.06994], [-122.52494, 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.53149, 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.55951, 38.09996], [-122.55862, 38.10039], [-122.55845, 38.10046], [-122.55726, 38.0999], [-122.55691, 38.09995], [-122.55686, 38.09998], [-122.55281, 38.09899], [-122.55176, 38.09958], [-122.5507, 38.09888], [-122.54961, 38.10549], [-122.54399, 38.10359], [-122.54187, 38.10374], [-122.53904, 38.10259], [-122.53853, 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.54229, 38.1008], [-122.54299, 38.10036], [-122.54308, 38.10049], [-122.54317, 38.10043], [-122.54343, 38.09978], [-122.54308, 38.09854], [-122.54219, 38.09765], [-122.54108, 38.09663], [-122.54019, 38.09627], [-122.53982, 38.09454], [-122.53834, 38.09349], [-122.53683, 38.09308], [-122.53388, 38.0938], [-122.53232, 38.09484], [-122.53214, 38.09646], [-122.53264, 38.09759], [-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.09283], [-122.54259, 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.0962], [-122.55088, 38.09626], [-122.55104, 38.09631], [-122.55121, 38.09633], [-122.55147, 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.54937, 38.09799], [-122.54937, 38.09797], [-122.54655, 38.09688], [-122.54664, 38.09631], [-122.54662, 38.0963], [-122.54651, 38.09694], [-122.54937, 38.09799]]]]} | Open Access 1 | Marin County Flood Control | 6348 | 2072 | Marin Public Works Dept/Flood Control 917 | Special District 4 | Flood District 9 | http://www.marincounty.org/depts/pw/divisions/flood-control | Special District 4 | 1294.866 | Marin County Flood Control | ||
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 | ||
14315 | 14315 | 14314 | {"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 | Unnamed site - Alameda County Flood Control and Water Conservation District | 28716 | 2000 | Alameda County Flood Control and Water Conservation District 752 | Special District 4 | Flood District 9 | http://acfloodcontrol.org/ | Special District 4 | 13.151 | |||
7778 | 7778 | 7777 | {"type": "Polygon", "coordinates": [[[-119.83073, 36.81646], [-119.83073, 36.81823], [-119.82858, 36.81824], [-119.82858, 36.81647], [-119.83073, 36.81646]]]} | Open Access 1 | Oso De Oro Lake Park | 23234 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Special District 4 | 9.315 | Oso De Oro Lake Park | ||
10466 | 10466 | 10465 | {"type": "Polygon", "coordinates": [[[-119.72501, 36.73865], [-119.725, 36.73946], [-119.72284, 36.73945], [-119.72277, 36.73948], [-119.72273, 36.73954], [-119.7218, 36.73953], [-119.72181, 36.73948], [-119.72187, 36.7394], [-119.72187, 36.73933], [-119.72181, 36.73926], [-119.7217, 36.73923], [-119.7216, 36.73926], [-119.72154, 36.73933], [-119.72154, 36.7394], [-119.7216, 36.73948], [-119.72161, 36.73953], [-119.72058, 36.73953], [-119.72058, 36.73894], [-119.72284, 36.73894], [-119.72285, 36.73828], [-119.72318, 36.73827], [-119.7232, 36.7383], [-119.72327, 36.73837], [-119.72369, 36.73841], [-119.72396, 36.73853], [-119.72424, 36.73868], [-119.72501, 36.73865]]]} | Open Access 1 | Trolley Creek Park | 26550 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Special District 4 | 8.113 | Trolley Creek Park | ||
13176 | 13176 | 13175 | {"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 | Basin FF Park | http://www.fresnofloodcontrol.org/ | 30978 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Special District 4 | 1.472 | Basin FF Park | |
13180 | 13180 | 13179 | {"type": "Polygon", "coordinates": [[[-119.82653, 36.72499], [-119.8265, 36.72733], [-119.82652, 36.72779], [-119.82394, 36.72781], [-119.82393, 36.72836], [-119.82325, 36.72836], [-119.8233, 36.72501], [-119.82653, 36.72499]]]} | No Public Access 3 | Basin FF | http://www.fresnofloodcontrol.org/ | 30979 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Special District 4 | 23.144 | Basin FF | |
13496 | 13496 | 13495 | {"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 | Basin G | http://www.fresnofloodcontrol.org/ | 30980 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Special District 4 | 2.587 | Basin G | |
13503 | 13503 | 13502 | {"type": "Polygon", "coordinates": [[[-119.79668, 36.82475], [-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]]]} | Open Access 1 | Basin H Park | http://www.fresnofloodcontrol.org/ | 30981 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Special District 4 | 7.304 | Basin H Park | |
13504 | 13504 | 13503 | {"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 | Basin I | http://www.fresnofloodcontrol.org/ | 30983 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Special District 4 | 1.938 | Basin I | |
13511 | 13511 | 13510 | {"type": "Polygon", "coordinates": [[[-119.8129, 36.79759], [-119.8129, 36.79813], [-119.80966, 36.79816], [-119.80965, 36.79807], [-119.80975, 36.79761], [-119.8129, 36.79759]]]} | Open Access 1 | Basin DD1 Park | http://www.fresnofloodcontrol.org/ | 30973 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Special District 4 | 4.319 | Basin DD1 Park | |
13519 | 13519 | 13518 | {"type": "Polygon", "coordinates": [[[-119.90629, 36.8413], [-119.90545, 36.84133], [-119.90541, 36.84069], [-119.90626, 36.8407], [-119.90629, 36.8413]]]} | Open Access 1 | Basin EG Park | http://www.fresnofloodcontrol.org/ | 30974 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Special District 4 | 1.296 | Basin EG Park | |
13535 | 13535 | 13534 | {"type": "Polygon", "coordinates": [[[-119.90644, 36.84421], [-119.90559, 36.8442], [-119.90545, 36.84133], [-119.90629, 36.8413], [-119.90644, 36.84421]]]} | No Public Access 3 | Basin EG | http://www.fresnofloodcontrol.org/ | 30975 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Special District 4 | 5.958 | Basin EG | |
13536 | 13536 | 13535 | {"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 | Basin F Park | http://www.fresnofloodcontrol.org/ | 30976 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Special District 4 | 1.691 | Basin F Park | |
13542 | 13542 | 13541 | {"type": "Polygon", "coordinates": [[[-119.79715, 36.81665], [-119.79715, 36.81715], [-119.79707, 36.81714], [-119.79699, 36.81716], [-119.79694, 36.8172], [-119.79691, 36.81726], [-119.79692, 36.81734], [-119.79702, 36.81743], [-119.79704, 36.8175], [-119.79612, 36.8175], [-119.79612, 36.81744], [-119.79608, 36.81739], [-119.79603, 36.81735], [-119.79596, 36.81733], [-119.795, 36.81734], [-119.79501, 36.81601], [-119.79543, 36.81601], [-119.7955, 36.81624], [-119.79565, 36.81643], [-119.79577, 36.81654], [-119.7959, 36.81662], [-119.79603, 36.81668], [-119.79629, 36.81674], [-119.79642, 36.81675], [-119.79656, 36.81674], [-119.79715, 36.81665]]]} | No Public Access 3 | Basin F | http://www.fresnofloodcontrol.org/ | 30977 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Special District 4 | 4.639 | Basin F | |
13546 | 13546 | 13545 | {"type": "Polygon", "coordinates": [[[-119.86682, 36.82496], [-119.86666, 36.82512], [-119.86489, 36.82512], [-119.86489, 36.82462], [-119.86486, 36.82455], [-119.86479, 36.8245], [-119.8648, 36.82365], [-119.86682, 36.82496]]]} | No Public Access 3 | Basin AC | http://www.fresnofloodcontrol.org/ | 30967 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Special District 4 | 3.873 | Basin AC |
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]);