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 rowid descending
This data as json, copyable, CSV (advanced)
MNG_AGENCY 8
- Natomas Basin Conservancy 20
- Los Angeles County Flood Control District 15
- Santa Barbara Flood Control and Water Conserv. District 14
- Fresno Metropolitan Flood Control District 14
- Sacramento and San Joaquin Drainage District 4
- San Bernardino County Flood Control District 4
- Sacramento Area Flood Control Agency 2
- Marin Public Works Dept/Flood Control 1
ACCESS_TYP 4
MNG_AG_TYP 1
- Flood District · 74 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13547 | 13547 | 13546 | {"type": "Polygon", "coordinates": [[[-119.86782, 36.82561], [-119.86717, 36.82627], [-119.86482, 36.82629], [-119.86482, 36.82551], [-119.86487, 36.82546], [-119.86489, 36.82541], [-119.86489, 36.82512], [-119.86665, 36.82512], [-119.86682, 36.82496], [-119.86782, 36.82561]]]} | Open Access 1 | Basin AC Park | http://www.fresnofloodcontrol.org/ | 30968 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Special District 4 | 7.509 | Basin AC Park | |
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 | |
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 | |
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 | |
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 | |
13531 | 13531 | 13530 | {"type": "Polygon", "coordinates": [[[-118.02569, 34.09575], [-118.02561, 34.09631], [-118.0254, 34.0964], [-118.02208, 34.09808], [-118.0218, 34.09822], [-118.0218, 34.09825], [-118.02158, 34.09831], [-118.02096, 34.09882], [-118.02033, 34.0991], [-118.01846, 34.10006], [-118.01705, 34.10123], [-118.01607, 34.10226], [-118.01593, 34.10244], [-118.01581, 34.10266], [-118.01572, 34.10293], [-118.01569, 34.1031], [-118.01568, 34.1033], [-118.01569, 34.10344], [-118.01573, 34.10351], [-118.01587, 34.10418], [-118.01498, 34.10449], [-118.01309, 34.10512], [-118.01166, 34.10633], [-118.00712, 34.10626], [-118.00748, 34.10553], [-118.00755, 34.10551], [-118.00771, 34.10517], [-118.009, 34.10473], [-118.01107, 34.10048], [-118.01157, 34.10064], [-118.01175, 34.10074], [-118.01186, 34.10077], [-118.01189, 34.10083], [-118.01193, 34.10108], [-118.012, 34.1012], [-118.01216, 34.10128], [-118.01232, 34.10131], [-118.01245, 34.1014], [-118.01249, 34.1015], [-118.01264, 34.10171], [-118.01281, 34.10171], [-118.01293, 34.10166], [-118.01317, 34.10165], [-118.01335, 34.10167], [-118.01359, 34.10176], [-118.01382, 34.10181], [-118.01404, 34.10192], [-118.01426, 34.10188], [-118.01451, 34.10145], [-118.0146, 34.10103], [-118.01469, 34.10074], [-118.01459, 34.10065], [-118.01441, 34.1004], [-118.0142, 34.10023], [-118.01418, 34.10009], [-118.01404, 34.09992], [-118.01387, 34.09979], [-118.01388, 34.09971], [-118.01378, 34.09965], [-118.01376, 34.09954], [-118.01382, 34.09936], [-118.01377, 34.09909], [-118.0136, 34.09887], [-118.01357, 34.09879], [-118.01362, 34.0986], [-118.01381, 34.09841], [-118.01431, 34.09815], [-118.01466, 34.09789], [-118.01612, 34.09729], [-118.01658, 34.09718], [-118.01761, 34.0972], [-118.01891, 34.09694], [-118.01911, 34.09701], [-118.01959, 34.0969], [-118.0198, 34.09688], [-118.02014, 34.09689], [-118.02013, 34.09658], [-118.02022, 34.09675], [-118.02082, 34.09668], [-118.02533, 34.09589], [-118.02569, 34.09575]]]} | No Public Access 3 | Los Angeles County Flood Control District Open Space | 32704 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 143.445 | Los Angeles County Flood Control District OS | ||
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
11922 | 11922 | 11921 | {"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 | Santa Maria Valley Muli-Purpose Trail | 28709 | 2141 | Santa Barbara Flood Control and Water Conserv. District 45 | Special District 4 | Flood District 9 | http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 | Special District 4 | 1.107 | Santa Maria Valley Muli-Purpose Trail | ||
11898 | 11898 | 11897 | {"type": "Polygon", "coordinates": [[[-118.28909, 33.79761], [-118.28846, 33.79761], [-118.28848, 33.79601], [-118.28845, 33.79583], [-118.28838, 33.79573], [-118.28713, 33.79362], [-118.28712, 33.79355], [-118.28758, 33.79355], [-118.28786, 33.79404], [-118.28788, 33.79404], [-118.28789, 33.79287], [-118.28758, 33.79285], [-118.28758, 33.79272], [-118.28789, 33.79271], [-118.2879, 33.79285], [-118.28821, 33.79285], [-118.28806, 33.79287], [-118.28805, 33.79318], [-118.28805, 33.79435], [-118.2882, 33.7946], [-118.28884, 33.79461], [-118.28884, 33.79478], [-118.28832, 33.79478], [-118.28831, 33.7948], [-118.28881, 33.79566], [-118.28883, 33.79566], [-118.28884, 33.79547], [-118.289, 33.79552], [-118.28899, 33.79759], [-118.28909, 33.79761]]]} | Open Access 1 | Canada de Palos Verdes Creek | 28604 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 6.228 | Canada de Palos Verdes Creek | ||
10796 | 10796 | 10795 | {"type": "Polygon", "coordinates": [[[-121.58503, 38.74523], [-121.58494, 38.74668], [-121.58484, 38.74681], [-121.58168, 38.74774], [-121.58154, 38.74784], [-121.58087, 38.74943], [-121.57695, 38.74952], [-121.57692, 38.74306], [-121.57717, 38.7431], [-121.57789, 38.74347], [-121.57807, 38.7435], [-121.5827, 38.74346], [-121.5831, 38.74338], [-121.5833, 38.74329], [-121.58335, 38.74324], [-121.58488, 38.74496], [-121.58503, 38.74523]]]} | No Public Access 3 | Vestal | 27009 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | http://www.natomasbasin.org/ | Special District 4 | 93.79 | Vestal | ||
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 | ||
10543 | 10543 | 10542 | {"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 | UEDA Parkway | 26644 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | http://www.natomasbasin.org/ | Special District 4 | 45.049 | UEDA Parkway | ||
10475 | 10475 | 10474 | {"type": "Polygon", "coordinates": [[[-119.77525, 34.46378], [-119.77515, 34.46411], [-119.77508, 34.46423], [-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 | Tuckers Grove Park | 26559 | 2141 | Santa Barbara Flood Control and Water Conserv. District 45 | Special District 4 | Flood District 9 | http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 | Special District 4 | 2.064 | Tuckers Grove 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 |
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]);