superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
37 rows where ACCESS_TYP = 1 and MNG_AG_TYP = 9 sorted by ACRES
This data as json, copyable, CSV (advanced)
MNG_AGENCY 7
- Fresno Metropolitan Flood Control District 10
- Los Angeles County Flood Control District 5
- Santa Barbara Flood Control and Water Conserv. District 4
- Sacramento Area Flood Control Agency 2
- Sacramento and San Joaquin Drainage District 1
- Alameda County Flood Control and Water Conservation District 1
- Marin Public Works Dept/Flood Control 1
MNG_AG_TYP 1
- Flood District · 24 ✖
ACCESS_TYP 1
- Open Access · 24 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13558 | 13558 | 13557 | {"type": "Polygon", "coordinates": [[[-119.81224, 36.70994], [-119.8118, 36.70995], [-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 | Basin TT2 Park | http://www.fresnofloodcontrol.org/ | 30990 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Special District 4 | 4.064 | Basin TT2 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 | |
14304 | 14304 | 14303 | {"type": "MultiPolygon", "coordinates": [[[[-120.45512, 34.65536], [-120.45512, 34.65556], [-120.45477, 34.65559], [-120.45508, 34.65538], [-120.45512, 34.65536]]], [[[-120.47548, 34.63445], [-120.47542, 34.63898], [-120.47512, 34.63897], [-120.47516, 34.63502], [-120.47511, 34.63485], [-120.47501, 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]]], [[[-120.47539, 34.64089], [-120.47535, 34.64386], [-120.47512, 34.64386], [-120.47516, 34.64089], [-120.47539, 34.64089]]], [[[-120.4754, 34.63998], [-120.47539, 34.64067], [-120.47516, 34.64066], [-120.47517, 34.63998], [-120.4754, 34.63998]]]]} | Open Access 1 | Unnamed site - Santa Barbara Flood Control and Water Conserv. District | 28688 | 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 | 6.015 | |||
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 | ||
13561 | 13561 | 13560 | {"type": "Polygon", "coordinates": [[[-119.83778, 36.76281], [-119.83769, 36.76282], [-119.83768, 36.76288], [-119.83567, 36.76288], [-119.83567, 36.76165], [-119.83777, 36.76164], [-119.83778, 36.76281]]]} | Open Access 1 | Basin XX Park | http://www.fresnofloodcontrol.org/ | 30993 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Special District 4 | 6.358 | Basin XX Park | |
13552 | 13552 | 13551 | {"type": "Polygon", "coordinates": [[[-119.82186, 36.82104], [-119.82186, 36.82267], [-119.82071, 36.82268], [-119.82071, 36.82239], [-119.81998, 36.82168], [-119.81992, 36.8217], [-119.81966, 36.8217], [-119.81966, 36.82097], [-119.82, 36.82096], [-119.82002, 36.82105], [-119.82186, 36.82104]]]} | Open Access 1 | Basin I Park | http://www.fresnofloodcontrol.org/ | 30984 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Special District 4 | 6.945 | Basin I Park | |
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 | |
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 | |
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 | ||
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 | ||
13554 | 13554 | 13553 | {"type": "Polygon", "coordinates": [[[-119.77005, 36.81043], [-119.77004, 36.8121], [-119.76832, 36.81211], [-119.7683, 36.81219], [-119.76777, 36.81219], [-119.76777, 36.81043], [-119.77005, 36.81043]]]} | Open Access 1 | Basin M Park | http://www.fresnofloodcontrol.org/ | 30986 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Special District 4 | 9.444 | Basin M Park | |
13550 | 13550 | 13549 | {"type": "Polygon", "coordinates": [[[-119.74966, 36.79444], [-119.74965, 36.79625], [-119.74636, 36.79624], [-119.74689, 36.79573], [-119.74739, 36.79533], [-119.74753, 36.7952], [-119.74772, 36.79496], [-119.74789, 36.79465], [-119.74842, 36.79461], [-119.74966, 36.79444]]]} | Open Access 1 | Basin C Park | http://www.fresnofloodcontrol.org/ | 30970 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Special District 4 | 10.001 | Basin C Park | |
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 | |||
39 | 39 | 38 | {"type": "Polygon", "coordinates": [[[-119.80757, 34.42522], [-119.80482, 34.42554], [-119.80482, 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 | More Mesa Open Space | 22474 | 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 | 13.534 | More Mesa OS | ||
9181 | 9181 | 9180 | {"type": "Polygon", "coordinates": [[[-117.78983, 34.12756], [-117.78982, 34.12783], [-117.78752, 34.13014], [-117.78637, 34.13038], [-117.78555, 34.13045], [-117.78534, 34.13051], [-117.78523, 34.13055], [-117.78495, 34.13071], [-117.78485, 34.13079], [-117.78469, 34.13097], [-117.78457, 34.13119], [-117.78445, 34.1317], [-117.78419, 34.13188], [-117.78382, 34.1317], [-117.78399, 34.1297], [-117.7855, 34.12892], [-117.78769, 34.12891], [-117.7877, 34.12836], [-117.78983, 34.12756]]]} | Open Access 1 | San Dimas Wash | 24876 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 20.069 | San Dimas Wash | ||
8052 | 8052 | 8051 | {"type": "MultiPolygon", "coordinates": [[[[-118.02016, 34.09689], [-118.0198, 34.09688], [-118.01959, 34.0969], [-118.01911, 34.09701], [-118.0189, 34.09694], [-118.01761, 34.0972], [-118.01658, 34.09718], [-118.01639, 34.09722], [-118.01612, 34.09729], [-118.01466, 34.09789], [-118.01431, 34.09815], [-118.01381, 34.09841], [-118.01362, 34.0986], [-118.01357, 34.09878], [-118.0136, 34.09887], [-118.01377, 34.09908], [-118.01382, 34.09936], [-118.01376, 34.09953], [-118.01378, 34.09964], [-118.01385, 34.0997], [-118.01389, 34.09971], [-118.01388, 34.09979], [-118.01404, 34.09992], [-118.01418, 34.10009], [-118.01421, 34.10024], [-118.01441, 34.1004], [-118.01459, 34.10065], [-118.01469, 34.10074], [-118.0146, 34.10103], [-118.01451, 34.10145], [-118.01426, 34.10188], [-118.01405, 34.10192], [-118.01382, 34.10181], [-118.01359, 34.10176], [-118.01335, 34.10167], [-118.01317, 34.10165], [-118.01293, 34.10166], [-118.01281, 34.10171], [-118.01263, 34.10171], [-118.01249, 34.1015], [-118.01245, 34.1014], [-118.01232, 34.10131], [-118.01216, 34.10128], [-118.01201, 34.1012], [-118.01193, 34.10108], [-118.01189, 34.10083], [-118.01186, 34.10077], [-118.01175, 34.10074], [-118.01157, 34.10064], [-118.01107, 34.10048], [-118.01123, 34.10014], [-118.01033, 34.09983], [-118.01043, 34.09961], [-118.01123, 34.09967], [-118.01206, 34.09925], [-118.01293, 34.0984], [-118.01387, 34.098], [-118.01443, 34.09761], [-118.01638, 34.09673], [-118.01739, 34.09682], [-118.02013, 34.09652], [-118.02016, 34.09689]]], [[[-118.02033, 34.09914], [-118.02027, 34.09935], [-118.01857, 34.10015], [-118.01711, 34.10129], [-118.01597, 34.10247], [-118.0159, 34.10259], [-118.01579, 34.10286], [-118.01576, 34.10299], [-118.01574, 34.10324], [-118.01575, 34.10338], [-118.01577, 34.10348], [-118.01575, 34.10348], [-118.01572, 34.10338], [-118.01572, 34.10318], [-118.01575, 34.10295], [-118.01581, 34.10274], [-118.01593, 34.1025], [-118.01609, 34.10228], [-118.01709, 34.10125], [-118.01848, 34.10009], [-118.02033, 34.09914]]]]} | Open Access 1 | Peck Road Water Conservation Park | 23558 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 27.505 | Peck Road Water Conservation Park | ||
9336 | 9336 | 9335 | {"type": "MultiPolygon", "coordinates": [[[[-119.52796, 34.42581], [-119.52763, 34.42608], [-119.52787, 34.42631], [-119.52779, 34.42645], [-119.52752, 34.42646], [-119.52751, 34.42634], [-119.52731, 34.4262], [-119.52769, 34.42541], [-119.52761, 34.42489], [-119.52731, 34.42485], [-119.52677, 34.42469], [-119.52676, 34.4245], [-119.52655, 34.42434], [-119.52618, 34.42437], [-119.52603, 34.42421], [-119.52557, 34.42425], [-119.52537, 34.42402], [-119.52509, 34.42402], [-119.52507, 34.42393], [-119.52538, 34.42386], [-119.52549, 34.42355], [-119.52539, 34.42323], [-119.52547, 34.4227], [-119.52599, 34.42124], [-119.52575, 34.42096], [-119.52564, 34.42069], [-119.52583, 34.42065], [-119.52588, 34.42077], [-119.526, 34.42077], [-119.52629, 34.42028], [-119.52629, 34.41998], [-119.52657, 34.41997], [-119.52684, 34.41942], [-119.52669, 34.4191], [-119.52673, 34.41863], [-119.52703, 34.41834], [-119.52701, 34.41806], [-119.5268, 34.41746], [-119.52644, 34.4166], [-119.52632, 34.4164], [-119.52628, 34.41577], [-119.52661, 34.41577], [-119.52674, 34.41652], [-119.52705, 34.41732], [-119.52731, 34.41768], [-119.52766, 34.41829], [-119.52759, 34.41936], [-119.52738, 34.41936], [-119.52687, 34.42026], [-119.52696, 34.42048], [-119.5268, 34.42071], [-119.52685, 34.42102], [-119.5272, 34.42146], [-119.52749, 34.42167], [-119.52745, 34.42187], [-119.52772, 34.42235], [-119.52772, 34.42348], [-119.52738, 34.42419], [-119.52727, 34.42434], [-119.52743, 34.42449], [-119.52781, 34.42464], [-119.52803, 34.42496], [-119.5281, 34.42531], [-119.52796, 34.42581]], [[-119.52669, 34.42194], [-119.52704, 34.42197], [-119.52707, 34.42164], [-119.52672, 34.42112], [-119.52662, 34.42057], [-119.52656, 34.42055], [-119.52637, 34.42076], [-119.52639, 34.42127], [-119.52666, 34.42157], [-119.52669, 34.42194]]], [[[-119.52876, 34.40482], [-119.52868, 34.40513], [-119.52842, 34.40587], [-119.52806, 34.4067], [-119.52792, 34.40706], [-119.52795, 34.40708], [-119.5279, 34.40723], [-119.52782, 34.40744], [-119.5274, 34.40831], [-119.52726, 34.40872], [-119.52711, 34.40929], [-119.5266, 34.41374], [-119.5263, 34.41385], [-119.52635, 34.41365], [-119.52678, 34.40968], [-119.52686, 34.40923], [-119.52698, 34.40879], [-119.52713, 34.40837], [-119.52808, 34.40625], [-119.52833, 34.40556], [-119.52858, 34.4048], [-119.52876, 34.40482]]], [[[-119.5289, 34.40218], [-119.52879, 34.40304], [-119.52879, 34.40348], [-119.52865, 34.40345], [-119.52865, 34.40307], [-119.52876, 34.40214], [-119.5289, 34.40218]]], [[[-119.52886, 34.40434], [-119.52884, 34.40463], [-119.52873, 34.40461], [-119.52875, 34.40449], [-119.52868, 34.40447], [-119.52866, 34.404], [-119.52868, 34.404], [-119.52886, 34.40434]]], [[[-119.5293, 34.4012], [-119.5292, 34.40139], [-119.52908, 34.40167], [-119.52915, 34.4018], [-119.52905, 34.40199], [-119.52881, 34.40192], [-119.52912, 34.40112], [-119.5293, 34.4012]]]]} | Open Access 1 | Santa Monica Creek | 25118 | 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 | 31.882 | Santa Monica Creek | ||
4652 | 4652 | 4651 | {"type": "Polygon", "coordinates": [[[-121.05008, 37.47695], [-121.04981, 37.47744], [-121.04901, 37.47823], [-121.04893, 37.48562], [-121.04748, 37.48584], [-121.04661, 37.48352], [-121.04625, 37.48355], [-121.04608, 37.48354], [-121.04588, 37.48349], [-121.04562, 37.48339], [-121.04538, 37.48317], [-121.0453, 37.48304], [-121.04517, 37.48265], [-121.04504, 37.48171], [-121.04405, 37.48162], [-121.04261, 37.48197], [-121.04182, 37.4817], [-121.04167, 37.48135], [-121.0417, 37.48091], [-121.04211, 37.4806], [-121.04288, 37.48066], [-121.04371, 37.48094], [-121.04433, 37.48093], [-121.04464, 37.48038], [-121.04424, 37.4798], [-121.04404, 37.47886], [-121.0446, 37.47887], [-121.0447, 37.47961], [-121.04544, 37.48016], [-121.04697, 37.48112], [-121.04678, 37.48136], [-121.04678, 37.48138], [-121.04738, 37.4816], [-121.04842, 37.48148], [-121.04888, 37.48106], [-121.04884, 37.48074], [-121.04816, 37.4803], [-121.04815, 37.47982], [-121.04869, 37.47938], [-121.04871, 37.47807], [-121.04954, 37.47726], [-121.0498, 37.47675], [-121.04997, 37.47686], [-121.05008, 37.47695]], [[-121.04619, 37.48132], [-121.04606, 37.48124], [-121.04563, 37.48131], [-121.04513, 37.481], [-121.04492, 37.48099], [-121.04425, 37.48114], [-121.04401, 37.48116], [-121.04369, 37.4811], [-121.04297, 37.4808], [-121.04251, 37.48072], [-121.04228, 37.48073], [-121.04216, 37.48077], [-121.04206, 37.48082], [-121.04184, 37.48099], [-121.04186, 37.48134], [-121.04193, 37.48152], [-121.04206, 37.4816], [-121.04247, 37.48166], [-121.0427, 37.48174], [-121.0429, 37.48173], [-121.04382, 37.48147], [-121.0441, 37.48146], [-121.04487, 37.48158], [-121.04516, 37.48153], [-121.04569, 37.48173], [-121.0459, 37.48179], [-121.04622, 37.48158], [-121.04625, 37.48144], [-121.04619, 37.48132]]]} | Open Access 1 | Gomes Lake | 19387 | 2127 | Sacramento and San Joaquin Drainage District 671 | Special District 4 | Flood District 9 | Special District 4 | 42.286 | Gomes Lake | |||
3271 | 3271 | 3270 | {"type": "MultiPolygon", "coordinates": [[[[-118.05583, 33.85032], [-118.0555, 33.85058], [-118.05501, 33.85093], [-118.05491, 33.85112], [-118.05476, 33.85123], [-118.05468, 33.85127], [-118.05459, 33.8512], [-118.04664, 33.85659], [-118.04643, 33.85693], [-118.04634, 33.85714], [-118.04633, 33.85671], [-118.04639, 33.85671], [-118.04639, 33.85665], [-118.04633, 33.85663], [-118.04632, 33.85595], [-118.04638, 33.85594], [-118.04638, 33.85587], [-118.04631, 33.85585], [-118.0463, 33.8556], [-118.04654, 33.85566], [-118.04783, 33.85479], [-118.04783, 33.85477], [-118.04764, 33.85477], [-118.04801, 33.85452], [-118.04824, 33.85453], [-118.04963, 33.85362], [-118.0504, 33.85362], [-118.0504, 33.85303], [-118.05091, 33.8527], [-118.05367, 33.85081], [-118.05441, 33.85033], [-118.05583, 33.85032]]], [[[-118.05906, 33.84647], [-118.05887, 33.84646], [-118.05885, 33.84651], [-118.05848, 33.84671], [-118.05662, 33.84943], [-118.05631, 33.84983], [-118.05507, 33.84984], [-118.05525, 33.84969], [-118.05551, 33.84942], [-118.05575, 33.84913], [-118.05748, 33.84657], [-118.0575, 33.84635], [-118.05754, 33.84628], [-118.05892, 33.84628], [-118.05906, 33.84636], [-118.05906, 33.84647]]], [[[-118.06126, 33.83895], [-118.06125, 33.83898], [-118.06107, 33.83907], [-118.06104, 33.83915], [-118.06065, 33.84192], [-118.06053, 33.8425], [-118.06071, 33.84255], [-118.06063, 33.84287], [-118.06045, 33.84285], [-118.06031, 33.84332], [-118.06015, 33.84376], [-118.06033, 33.84383], [-118.06029, 33.84391], [-118.06012, 33.84387], [-118.0601, 33.84388], [-118.06006, 33.84403], [-118.06022, 33.84408], [-118.06016, 33.84424], [-118.05997, 33.8442], [-118.05961, 33.84495], [-118.05926, 33.84555], [-118.05916, 33.84569], [-118.05931, 33.84579], [-118.05914, 33.84603], [-118.05915, 33.84608], [-118.05904, 33.84601], [-118.05903, 33.84404], [-118.05933, 33.84332], [-118.05956, 33.84256], [-118.05972, 33.84173], [-118.05975, 33.84146], [-118.05936, 33.84143], [-118.05939, 33.84138], [-118.05938, 33.84131], [-118.05978, 33.84132], [-118.06007, 33.8393], [-118.0601, 33.83928], [-118.06013, 33.83912], [-118.05992, 33.83901], [-118.05993, 33.83898], [-118.06126, 33.83895]]], [[[-118.0628, 33.83198], [-118.0623, 33.83332], [-118.0618, 33.83474], [-118.0617, 33.83513], [-118.06187, 33.83514], [-118.06185, 33.83522], [-118.06169, 33.83519], [-118.06164, 33.83536], [-118.0615, 33.83603], [-118.06132, 33.83726], [-118.0613, 33.83755], [-118.06124, 33.83796], [-118.06119, 33.8381], [-118.06114, 33.83842], [-118.06119, 33.83852], [-118.06131, 33.83859], [-118.06131, 33.83862], [-118.05997, 33.83865], [-118.05998, 33.83862], [-118.06021, 33.8385], [-118.06055, 33.8359], [-118.06077, 33.83495], [-118.06068, 33.83492], [-118.06058, 33.83495], [-118.0607, 33.83451], [-118.06094, 33.83379], [-118.06107, 33.83344], [-118.0628, 33.83198]]]]} | Open Access 1 | Coyote Creek & Bike Trail | 17737 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 63.574 | Coyote Creek & Bike Trail | ||
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 |
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]);