units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
40 rows where ACCESS_TYP = 1 and MNG_AG_TYP = 9 sorted by MNG_AG_ID
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 1
- Open Access · 40 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 |
6347 | 6347 | 6346 | {"type": "Polygon", "coordinates": [[[-119.72501, 36.73865], [-119.725, 36.73946], [-119.72284, 36.73945], [-119.72277, 36.73948], [-119.72274, 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.72319, 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 | 1762 | Trolley Creek Park | 26550 | 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 | 8.104 | Trolley Creek Park | 0 | Local Park 2 | 4 | |
6389 | 6389 | 6388 | {"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 | 1815 | Oso De Oro Lake Park | 23234 | 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.316 | Oso De Oro Lake Park | 0 | Local Park 2 | 4 | |
14752 | 14752 | 14751 | {"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 | 47260 | Basin C Park | 30970 | 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 | 10.001 | Basin C Park | 0 | Local Park 2 | 4 |
14815 | 14815 | 14814 | {"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 | 47257 | Basin AC Park | 30968 | 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 | 7.509 | Basin AC Park | 0 | Local Park 2 | 4 |
14829 | 14829 | 14828 | {"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 | 47264 | Basin DD1 Park | 30973 | 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 | 4.322 | Basin DD1 Park | 0 | Local Park 2 | 4 |
14831 | 14831 | 14830 | {"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 | 47266 | Basin EG Park | 30974 | 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 | 1.297 | Basin EG Park | 0 | Local Park 2 | 4 |
14834 | 14834 | 14833 | {"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 | 47267 | Basin F Park | 30976 | 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 | 1.692 | Basin F Park | 0 | Local Park 2 | 4 |
14839 | 14839 | 14838 | {"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 | 47269 | Basin FF Park | 30978 | 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 | 1.472 | Basin FF Park | 0 | Local Park 2 | 4 |
14849 | 14849 | 14848 | {"type": "Polygon", "coordinates": [[[-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], [-119.79667, 36.82651]]]} | Open Access 1 | 47273 | Basin H Park | 30981 | 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 | 7.305 | Basin H Park | 0 | Local Park 2 | 4 |
14878 | 14878 | 14877 | {"type": "Polygon", "coordinates": [[[-119.81224, 36.70994], [-119.81179, 36.70994], [-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 | 47281 | Basin TT2 Park | 30990 | 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 | 4.062 | Basin TT2 Park | 0 | Local Park 2 | 4 |
14881 | 14881 | 14880 | {"type": "Polygon", "coordinates": [[[-119.77005, 36.81043], [-119.77004, 36.8121], [-119.76831, 36.81211], [-119.7683, 36.81219], [-119.76777, 36.81219], [-119.76777, 36.81043], [-119.77005, 36.81043]]]} | Open Access 1 | 47278 | Basin M Park | 30986 | 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 | 9.444 | Basin M Park | 0 | Local Park 2 | 4 |
15033 | 15033 | 15032 | {"type": "Polygon", "coordinates": [[[-119.83778, 36.76281], [-119.83769, 36.76281], [-119.83768, 36.76288], [-119.83567, 36.76288], [-119.83567, 36.76165], [-119.83777, 36.76164], [-119.83778, 36.76281]]]} | Open Access 1 | 47287 | Basin XX Park | 30993 | 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.359 | Basin XX Park | 0 | Local Park 2 | 4 |
10118 | 10118 | 10117 | {"type": "MultiPolygon", "coordinates": [[[[-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.52596, 38.07439], [-122.52574, 38.07374], [-122.5243, 38.07215], [-122.52311, 38.07182], [-122.52237, 38.07141], [-122.5218, 38.07101], [-122.52315, 38.06994], [-122.52495, 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.53148, 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.53462, 38.08549], [-122.53457, 38.08664], [-122.51994, 38.09789], [-122.51972, 38.09772], [-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.50189, 38.08967], [-122.50306, 38.08829], [-122.50434, 38.08636], [-122.50476, 38.08672], [-122.50462, 38.0869], [-122.50547, 38.08821], [-122.5071, 38.09337], [-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.55951, 38.09996], [-122.55862, 38.10039], [-122.55845, 38.10046], [-122.55726, 38.0999], [-122.5569, 38.09995], [-122.55686, 38.09998], [-122.5528, 38.09898], [-122.55176, 38.09958], [-122.5507, 38.09887], [-122.54961, 38.10549], [-122.54399, 38.10359], [-122.54188, 38.10374], [-122.53904, 38.10259], [-122.53854, 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.5423, 38.10081], [-122.54299, 38.10036], [-122.54308, 38.10049], [-122.54317, 38.10043], [-122.54344, 38.09978], [-122.54308, 38.09854], [-122.54219, 38.09765], [-122.54108, 38.09662], [-122.54019, 38.09627], [-122.53982, 38.09454], [-122.53834, 38.09349], [-122.53683, 38.09307], [-122.53388, 38.0938], [-122.53231, 38.09484], [-122.53214, 38.09646], [-122.53264, 38.0976], [-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.09282], [-122.5426, 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.09619], [-122.55088, 38.09626], [-122.55104, 38.09631], [-122.55121, 38.09633], [-122.55146, 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.54938, 38.09799], [-122.54938, 38.09798], [-122.54655, 38.09688], [-122.54664, 38.09628], [-122.54662, 38.09627], [-122.54651, 38.09694], [-122.54938, 38.09799]]]]} | Open Access 1 | 17572 | Marin County Flood Control | 6348 | 2072 | Marin Public Works Dept/Flood Control 945 | Special District 4 | Flood District 8 | http://www.marincounty.org/depts/pw/divisions/flood-control | Special District 4 | 2072 | Marin Public Works Dept/Flood Control 917 | Special District 4 | Flood District 9 | Marin 23 | 1294.68 | Marin County Flood Control | 0 | Local Other or Unknown 14 | 4 | |
10348 | 10348 | 10347 | {"type": "Polygon", "coordinates": [[[-121.05008, 37.47695], [-121.04981, 37.47744], [-121.04901, 37.47822], [-121.04893, 37.48562], [-121.04748, 37.48584], [-121.04661, 37.48352], [-121.04645, 37.48354], [-121.04625, 37.48355], [-121.04608, 37.48354], [-121.04588, 37.48349], [-121.04563, 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.48094], [-121.04465, 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.48149], [-121.04888, 37.48106], [-121.04885, 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.48098], [-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.04383, 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 | 18274 | Gomes Lake | 19387 | 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 | Stanislaus 2 | 42.26 | Gomes Lake | 0 | None 906 | |||
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 | |
11269 | 11269 | 11268 | {"type": "MultiPolygon", "coordinates": [[[[-121.45314, 38.66939], [-121.44761, 38.66934], [-121.44762, 38.66815], [-121.44965, 38.6681], [-121.45041, 38.66816], [-121.45094, 38.66817], [-121.45137, 38.66808], [-121.4514, 38.66785], [-121.45155, 38.66774], [-121.45156, 38.66771], [-121.45158, 38.6677], [-121.45197, 38.66815], [-121.45206, 38.66811], [-121.4523, 38.6684], [-121.45168, 38.66839], [-121.45205, 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.47664, 38.67085], [-121.47545, 38.67084], [-121.47545, 38.67078], [-121.47624, 38.67078], [-121.4765, 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 | 21782 | UEDA Parkway | 26645 | 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 | 90.571 | UEDA Parkway | 0 | Local Recreation Area 3 | 4 | |
172 | 172 | 171 | {"type": "Polygon", "coordinates": [[[-119.7122, 34.45864], [-119.71219, 34.45865], [-119.71206, 34.45871], [-119.71176, 34.45871], [-119.71175, 34.45848], [-119.71185, 34.45854], [-119.7122, 34.45864]]]} | Open Access 1 | 462 | Santa Barbara Botanic Gardens | 25037 | 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.145 | Santa Barbara Botanic Gardens | 0 | Local Park 2 | 4 | |
241 | 241 | 240 | {"type": "Polygon", "coordinates": [[[-120.19548, 34.61923], [-120.19532, 34.62017], [-120.19414, 34.61966], [-120.19453, 34.61897], [-120.19477, 34.61907], [-120.19504, 34.61915], [-120.19548, 34.61923]]]} | Open Access 1 | 785 | Buellton Park | 16483 | 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.399 | Buellton Park | 0 | Local Park 2 | 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]);