units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
286 rows where DES_TP = 14 and LAYER = 4
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP, COUNTY, YR_EST
MNG_AGENCY >30
- Mountains Recreation and Conservation Authority 131
- Yuba County Water Agency 48
- Los Angeles County Flood Control District 13
- Santa Barbara Flood Control and Water Conserv. District 12
- San Lorenzo Valley Water District 9
- La Selva Beach Recreation District 8
- Marin County Open Space District 3
- Scotts Valley Water District 3
- Natomas Basin Conservancy 3
- Santa Clara Valley Water District 3
- Hayward Area Recreation and Park District 2
- Riverside County Regional Park and Open Space District 2
- Imperial Irrigation District 2
- Sonoma County Agricultural Preservation and Open Space District 2
- Truckee Tahoe Airport District 2
- North County Recreation and Park District 2
- Orange County Water District 2
- Westfield Recreation and Park District 2
- Ramona Municipal Water District 2
- Western Riverside County Regional Conservation Authority 2
- Conejo Recreation and Park District 1
- Monterey Peninsula Regional Park District 1
- Napa County Regional Park and Open Space District 1
- San Marcos, City of 1
- Marin Municipal Water District 1
- North of the River Recreation and Park District 1
- Metropolitan Water District of Southern California 1
- Santa Clara Valley Open Space Authority 1
- Olivehurst Public Utility District 1
- Riverside County Habitat Conservation Agency 1
- …
MNG_AG_TYP 12
ACCESS_TYP 4
- Unknown Access 167
- Open Access 74
- No Public Access 29
- Restricted Access 16
DES_TP 1
- Local Other or Unknown · 286 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 108 | 108 | 107 | {"type": "Polygon", "coordinates": [[[-119.80165, 34.44381], [-119.80106, 34.44387], [-119.79957, 34.44402], [-119.79959, 34.44377], [-119.80161, 34.44357], [-119.80165, 34.44381]]]} | Unknown Access 4 | 295 | San Antonio Creek | 24829 | 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 | 1.291 | San Antonio Creek | 0 | Local Other or Unknown 14 | 4 | |
| 928 | 928 | 927 | {"type": "MultiPolygon", "coordinates": [[[[-118.59921, 34.0992], [-118.59903, 34.09939], [-118.59861, 34.09959], [-118.59848, 34.0997], [-118.59839, 34.10003], [-118.59832, 34.10038], [-118.59776, 34.10077], [-118.59771, 34.10077], [-118.5977, 34.10064], [-118.59805, 34.10038], [-118.59816, 34.10024], [-118.59822, 34.10008], [-118.59827, 34.09982], [-118.59832, 34.09971], [-118.59838, 34.09965], [-118.59873, 34.09941], [-118.59894, 34.09917], [-118.59904, 34.09909], [-118.59921, 34.0992]]], [[[-118.60098, 34.097], [-118.60043, 34.09746], [-118.60002, 34.09794], [-118.59991, 34.09786], [-118.60007, 34.09761], [-118.60025, 34.09742], [-118.60077, 34.0971], [-118.60089, 34.09699], [-118.60096, 34.09691], [-118.60098, 34.097]]], [[[-118.60123, 34.09661], [-118.60104, 34.09701], [-118.60099, 34.09686], [-118.60102, 34.09679], [-118.60106, 34.0966], [-118.60103, 34.09619], [-118.60109, 34.09619], [-118.6011, 34.09645], [-118.60123, 34.09661]]]]} | Open Access 1 | 6426 | Topanga Creek | 26407 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | Los Angeles 6 | 1.477 | Topanga Creek | 0 | Local Other or Unknown 14 | 4 | |
| 1046 | 1046 | 1045 | {"type": "Polygon", "coordinates": [[[-118.34139, 34.12342], [-118.34119, 34.12342], [-118.34101, 34.12338], [-118.34082, 34.12338], [-118.34041, 34.12313], [-118.34051, 34.12301], [-118.34068, 34.12311], [-118.34077, 34.12313], [-118.34087, 34.12313], [-118.341, 34.12307], [-118.34139, 34.12342]]]} | Open Access 1 | 6900 | Unnamed site - Mountains Recreation and Conservation Authority | 29458 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.464 | 0 | Local Other or Unknown 14 | 4 | ||
| 1066 | 1066 | 1065 | {"type": "Polygon", "coordinates": [[[-118.16257, 34.20755], [-118.16261, 34.2077], [-118.16261, 34.20779], [-118.16252, 34.20798], [-118.16232, 34.20798], [-118.16232, 34.20756], [-118.16257, 34.20755]]]} | Open Access 1 | 6963 | Unnamed site - Mountains Recreation and Conservation Authority | 29458 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.283 | 0 | Local Other or Unknown 14 | 4 | ||
| 1192 | 1192 | 1191 | {"type": "MultiPolygon", "coordinates": [[[[-122.48372, 37.92711], [-122.47966, 37.92717], [-122.4794, 37.92537], [-122.48367, 37.9253], [-122.48372, 37.92711]]], [[[-122.49518, 37.92873], [-122.48832, 37.92884], [-122.48822, 37.92522], [-122.49509, 37.9251], [-122.49518, 37.92873]]], [[[-122.49976, 37.92865], [-122.49747, 37.92869], [-122.49739, 37.92507], [-122.49764, 37.92506], [-122.49818, 37.92572], [-122.49942, 37.92654], [-122.49972, 37.92677], [-122.49976, 37.92865]]]]} | Open Access 1 | 6910 | Water Lots | 27294 | 2070 | Marin County Open Space District 44 | Special District 4 | Recreation/Parks District 4 | http://www.marincountyparks.org/Depts/PK.aspx | Special District 4 | 2070 | Marin County Open Space District 43 | Special District 4 | Recreation/Parks District 4 | Marin 23 | 93.387 | Water Lots | 0 | Local Other or Unknown 14 | 4 | |
| 1208 | 1208 | 1207 | {"type": "Polygon", "coordinates": [[[-118.6372, 34.36427], [-118.62414, 34.36475], [-118.62394, 34.35736], [-118.63275, 34.35717], [-118.63292, 34.36076], [-118.63708, 34.36067], [-118.6372, 34.36427]]]} | Unknown Access 4 | 8425 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 201.929 | 0 | Local Other or Unknown 14 | 4 | ||
| 1532 | 1532 | 1531 | {"type": "MultiPolygon", "coordinates": [[[[-115.83381, 33.16563], [-115.83378, 33.16928], [-115.82198, 33.16929], [-115.82198, 33.16199], [-115.80482, 33.16192], [-115.80482, 33.15463], [-115.82199, 33.15469], [-115.82199, 33.16199], [-115.82687, 33.16198], [-115.82686, 33.16563], [-115.83381, 33.16563]]], [[[-115.90534, 33.29488], [-115.89218, 33.29486], [-115.89209, 33.28754], [-115.90085, 33.28756], [-115.90091, 33.29121], [-115.90529, 33.29122], [-115.90534, 33.29488]]], [[[-115.94493, 33.33904], [-115.94492, 33.32776], [-115.94935, 33.32775], [-115.94935, 33.3315], [-115.95377, 33.33149], [-115.95378, 33.33524], [-115.95819, 33.33522], [-115.95819, 33.33896], [-115.94493, 33.33904]]], [[[-115.87442, 33.40541], [-115.87441, 33.41234], [-115.85704, 33.41234], [-115.85647, 33.39822], [-115.86469, 33.39821], [-115.86509, 33.40498], [-115.8656, 33.40501], [-115.86561, 33.40527], [-115.87142, 33.40527], [-115.87442, 33.40541]]], [[[-116.01564, 33.39721], [-116.01562, 33.40443], [-116.01558, 33.40444], [-116.01555, 33.41176], [-115.99783, 33.4119], [-115.99791, 33.4265], [-115.98011, 33.42661], [-115.98006, 33.41198], [-115.96255, 33.41242], [-115.96254, 33.39762], [-115.9451, 33.39771], [-115.94509, 33.38299], [-115.92747, 33.38307], [-115.92745, 33.3906], [-115.90998, 33.39065], [-115.90996, 33.38314], [-115.89259, 33.38356], [-115.89256, 33.37504], [-115.89246, 33.36837], [-115.87583, 33.3684], [-115.87452, 33.36836], [-115.87415, 33.35374], [-115.89244, 33.35368], [-115.89245, 33.36836], [-115.90998, 33.36836], [-115.90999, 33.36835], [-115.90998, 33.35365], [-115.89247, 33.35368], [-115.89243, 33.3391], [-115.87371, 33.33912], [-115.87393, 33.32377], [-115.85611, 33.3237], [-115.85604, 33.33922], [-115.83881, 33.3393], [-115.83896, 33.32365], [-115.82156, 33.32357], [-115.82146, 33.33939], [-115.8041, 33.33951], [-115.80422, 33.3235], [-115.78723, 33.32344], [-115.7871, 33.33961], [-115.79552, 33.33958], [-115.80408, 33.33952], [-115.80398, 33.35407], [-115.8213, 33.35429], [-115.82123, 33.36847], [-115.83855, 33.36875], [-115.83851, 33.37503], [-115.83857, 33.38347], [-115.85586, 33.38345], [-115.85645, 33.39789], [-115.83907, 33.39793], [-115.82237, 33.398], [-115.82236, 33.39779], [-115.82164, 33.39779], [-115.82144, 33.39075], [-115.83012, 33.39073], [-115.83013, 33.39071], [-115.83007, 33.38892], [-115.82139, 33.38894], [-115.82123, 33.3835], [-115.82121, 33.37503], [-115.82124, 33.36848], [-115.80396, 33.36857], [-115.80399, 33.35408], [-115.76974, 33.35424], [-115.76973, 33.35342], [-115.76994, 33.32338], [-115.75247, 33.32209], [-115.75236, 33.33955], [-115.73458, 33.33953], [-115.73457, 33.33983], [-115.73443, 33.33983], [-115.73573, 33.32261], [-115.73574, 33.32203], [-115.71843, 33.322], [-115.71842, 33.32266], [-115.71712, 33.33982], [-115.71685, 33.33982], [-115.71684, 33.33967], [-115.69966, 33.33961], [-115.70108, 33.32203], [-115.68392, 33.32199], [-115.68235, 33.33986], [-115.68215, 33.3543], [-115.66495, 33.35426], [-115.66497, 33.34343], [-115.66037, 33.34342], [-115.66037, 33.33982], [-115.66676, 33.33981], [-115.66667, 33.32201], [-115.64872, 33.32197], [-115.6487, 33.33981], [-115.64435, 33.33978], [-115.64436, 33.33711], [-115.64004, 33.33708], [-115.64005, 33.33441], [-115.63573, 33.33438], [-115.63575, 33.32904], [-115.63144, 33.32902], [-115.63146, 33.32188], [-115.62293, 33.32185], [-115.62293, 33.31461], [-115.61865, 33.31458], [-115.61864, 33.31096], [-115.61436, 33.31094], [-115.61435, 33.30369], [-115.61001, 33.30367], [-115.61001, 33.29277], [-115.60566, 33.29275], [-115.60569, 33.28912], [-115.60134, 33.2891], [-115.60138, 33.28547], [-115.59704, 33.28544], [-115.59711, 33.27818], [-115.59708, 33.26367], [-115.58839, 33.26367], [-115.58835, 33.24925], [-115.59428, 33.24956], [-115.59436, 33.24923], [-115.59703, 33.24923], [-115.59706, 33.23474], [-115.57973, 33.23473], [-115.57976, 33.22813], [-115.57982, 33.22021], [-115.57981, 33.20924], [-115.58413, 33.20924], [-115.58414, 33.20559], [-115.58846, 33.2056], [-115.58851, 33.1984], [-115.59716, 33.19835], [-115.59713, 33.20562], [-115.61442, 33.2056], [-115.6144, 33.19099], [-115.63163, 33.19095], [-115.63147, 33.17661], [-115.63153, 33.16575], [-115.63581, 33.16574], [-115.63582, 33.16212], [-115.6401, 33.16211], [-115.64012, 33.15845], [-115.6444, 33.15843], [-115.64443, 33.15477], [-115.64871, 33.15475], [-115.64877, 33.14741], [-115.66632, 33.14745], [-115.68348, 33.1474], [-115.68339, 33.13303], [-115.68339, 33.11864], [-115.66637, 33.11857], [-115.66641, 33.104], [-115.68355, 33.10408], [-115.68339, 33.11863], [-115.69211, 33.11862], [-115.69211, 33.12582], [-115.70082, 33.12581], [-115.70084, 33.10413], [-115.73531, 33.10411], [-115.73536, 33.09685], [-115.75264, 33.09672], [-115.75266, 33.10034], [-115.75708, 33.10035], [-115.75709, 33.10398], [-115.76152, 33.104], [-115.76147, 33.10763], [-115.77031, 33.10767], [-115.77015, 33.11857], [-115.77015, 33.12725], [-115.78773, 33.12721], [-115.78776, 33.13303], [-115.77015, 33.13305], [-115.77014, 33.14745], [-115.78758, 33.14741], [-115.7875, 33.16199], [-115.77011, 33.162], [-115.77014, 33.14745], [-115.75242, 33.14742], [-115.75245, 33.13311], [-115.75081, 33.13309], [-115.73529, 33.13305], [-115.73529, 33.14742], [-115.71803, 33.14745], [-115.71802, 33.14023], [-115.70081, 33.14022], [-115.70077, 33.14743], [-115.68349, 33.1474], [-115.68349, 33.16204], [-115.6665, 33.16203], [-115.66649, 33.17657], [-115.6665, 33.17658], [-115.68352, 33.17655], [-115.68358, 33.191], [-115.68043, 33.19101], [-115.66655, 33.19099], [-115.66654, 33.19104], [-115.66647, 33.19104], [-115.64877, 33.19098], [-115.64885, 33.20569], [-115.6317, 33.20562], [-115.63178, 33.22012], [-115.62588, 33.2201], [-115.61438, 33.22014], [-115.61435, 33.22742], [-115.61003, 33.22743], [-115.61002, 33.23107], [-115.61434, 33.23107], [-115.6143, 33.24921], [-115.62582, 33.2492], [-115.63172, 33.24923], [-115.63163, 33.26368], [-115.63164, 33.26369], [-115.64884, 33.26369], [-115.64892, 33.25003], [-115.64886, 33.24918], [-115.66651, 33.24915], [-115.66655, 33.25004], [-115.66654, 33.26368], [-115.66655, 33.26369], [-115.68372, 33.26364], [-115.68375, 33.25004], [-115.68367, 33.24913], [-115.70102, 33.24913], [-115.70108, 33.25005], [-115.70101, 33.26369], [-115.70102, 33.2637], [-115.71822, 33.26373], [-115.71823, 33.25005], [-115.71817, 33.24918], [-115.73556, 33.24917], [-115.73558, 33.25003], [-115.73559, 33.26381], [-115.75082, 33.26381], [-115.75251, 33.26379], [-115.75256, 33.25004], [-115.75249, 33.24929], [-115.7622, 33.25009], [-115.76328, 33.25008], [-115.77001, 33.25062], [-115.76993, 33.26535], [-115.76994, 33.26536], [-115.78725, 33.26543], [-115.78727, 33.25067], [-115.80456, 33.25072], [-115.80455, 33.26546], [-115.82178, 33.26548], [-115.8218, 33.25074], [-115.83917, 33.25072], [-115.8392, 33.25007], [-115.83922, 33.23474], [-115.8564, 33.23466], [-115.85638, 33.25005], [-115.85637, 33.25077], [-115.83918, 33.25073], [-115.83917, 33.25074], [-115.8392, 33.2655], [-115.85634, 33.26547], [-115.85631, 33.28015], [-115.83925, 33.28014], [-115.83908, 33.29477], [-115.85622, 33.29485], [-115.85614, 33.30925], [-115.87405, 33.30937], [-115.87395, 33.32376], [-115.89239, 33.32388], [-115.89232, 33.30942], [-115.90986, 33.30952], [-115.9098, 33.3022], [-115.91856, 33.30222], [-115.91861, 33.30589], [-115.92737, 33.30591], [-115.92741, 33.30958], [-115.93179, 33.30959], [-115.9318, 33.31318], [-115.93617, 33.31319], [-115.93618, 33.32398], [-115.92745, 33.32396], [-115.92745, 33.33906], [-115.94492, 33.33905], [-115.94492, 33.3536], [-115.94493, 33.35361], [-115.96261, 33.35359], [-115.96261, 33.34259], [-115.96693, 33.34257], [-115.96693, 33.34624], [-115.97125, 33.34623], [-115.97125, 33.3499], [-115.97556, 33.3499], [-115.97556, 33.35358], [-115.96262, 33.35359], [-115.96263, 33.36831], [-115.97989, 33.36828], [-115.97987, 33.35358], [-115.9887, 33.35341], [-115.98869, 33.36084], [-115.9975, 33.36075], [-115.99747, 33.36826], [-115.9799, 33.36828], [-115.97989, 33.37505], [-115.97993, 33.38277], [-115.99761, 33.38274], [-115.99778, 33.3974], [-116.00082, 33.39739], [-116.01564, 33.39721]], [[-115.99777, 33.39742], [-115.99776, 33.39741], [-115.98, 33.39751], [-115.98007, 33.41197], [-115.99782, 33.4119], [-115.99777, 33.39742]], [[-115.97998, 33.39751], [-115.97992, 33.38278], [-115.96255, 33.38288], [-115.96255, 33.39761], [-115.97998, 33.39751]], [[-115.92746, 33.36835], [-115.92745, 33.36834], [-115.90999, 33.36836], [-115.90995, 33.38314], [-115.92747, 33.38307], [-115.9275, 33.37505], [-115.92746, 33.36835]], [[-115.94493, 33.36833], [-115.94495, 33.36832], [-115.94493, 33.35361], [-115.92746, 33.35361], [-115.92746, 33.36835], [-115.94493, 33.36833]], [[-115.96254, 33.38288], [-115.9626, 33.36832], [-115.94495, 33.36833], [-115.94496, 33.37506], [-115.9451, 33.38298], [-115.96254, 33.38288]], [[-115.92745, 33.35361], [-115.92745, 33.33907], [-115.90997, 33.33911], [-115.90998, 33.35364], [-115.92745, 33.35361]], [[-115.90996, 33.32392], [-115.89239, 33.32388], [-115.89244, 33.3391], [-115.90996, 33.33911], [-115.90996, 33.32392]], [[-115.85614, 33.30926], [-115.839, 33.30916], [-115.83897, 33.32365], [-115.8561, 33.32369], [-115.85614, 33.30926]], [[-115.82162, 33.30908], [-115.82161, 33.30907], [-115.80431, 33.309], [-115.80422, 33.3235], [-115.82155, 33.32357], [-115.82162, 33.30908]], [[-115.78726, 33.30888], [-115.76998, 33.30876], [-115.76995, 33.32338], [-115.78723, 33.32343], [-115.78726, 33.30888]], [[-115.75246, 33.32209], [-115.75247, 33.32208], [-115.7525, 33.30766], [-115.75083, 33.30763], [-115.73572, 33.30753], [-115.73574, 33.32203], [-115.75082, 33.32207], [-115.75246, 33.32209]], [[-115.71841, 33.322], [-115.71845, 33.30744], [-115.70116, 33.30733], [-115.70109, 33.32203], [-115.71841, 33.322]], [[-115.68391, 33.32199], [-115.68392, 33.32198], [-115.68388, 33.30725], [-115.66672, 33.30727], [-115.66668, 33.322], [-115.68391, 33.32199]], [[-115.6487, 33.32197], [-115.64871, 33.32196], [-115.64878, 33.30731], [-115.63154, 33.30739], [-115.63147, 33.32188], [-115.6487, 33.32197]], [[-115.66664, 33.29272], [-115.64876, 33.29274], [-115.64878, 33.3073], [-115.66671, 33.30727], [-115.66664, 33.29272]], [[-115.64874, 33.29274], [-115.64884, 33.27825], [-115.63158, 33.27828], [-115.63159, 33.29283], [-115.64874, 33.29274]], [[-115.63157, 33.27828], [-115.63158, 33.27827], [-115.63157, 33.27104], [-115.63163, 33.26369], [-115.61442, 33.26362], [-115.61444, 33.27094], [-115.62302, 33.27096], [-115.62303, 33.27827], [-115.63157, 33.27828]], [[-115.61441, 33.26362], [-115.61442, 33.26361], [-115.6143, 33.24922], [-115.60567, 33.24923], [-115.60575, 33.26363], [-115.61441, 33.26362]], [[-115.66662, 33.27821], [-115.66661, 33.27098], [-115.66653, 33.26369], [-115.64884, 33.2637], [-115.64884, 33.27824], [-115.66662, 33.27821]], [[-115.70101, 33.26371], [-115.68373, 33.26365], [-115.68377, 33.27819], [-115.70107, 33.27823], [-115.70101, 33.26371]], [[-115.73562, 33.27832], [-115.73563, 33.27831], [-115.73557, 33.26381], [-115.71823, 33.26374], [-115.71833, 33.27827], [-115.73562, 33.27832]], [[-115.76996, 33.27997], [-115.76997, 33.27997], [-115.76993, 33.26536], [-115.75251, 33.2638], [-115.75249, 33.27837], [-115.76996, 33.27997]], [[-115.80451, 33.2801], [-115.80452, 33.28009], [-115.80455, 33.26547], [-115.78726, 33.26544], [-115.78724, 33.28006], [-115.80451, 33.2801]], [[-115.83923, 33.28014], [-115.83924, 33.28013], [-115.83919, 33.2655], [-115.82179, 33.26548], [-115.82176, 33.28012], [-115.83923, 33.28014]], [[-115.82176, 33.28014], [-115.80452, 33.2801], [-115.8044, 33.29454], [-115.82174, 33.29467], [-115.82176, 33.28014]], [[-115.83899, 33.30915], [-115.83907, 33.29477], [-115.82175, 33.29468], [-115.82163, 33.30907], [-115.83899, 33.30915]], [[-115.8043, 33.30899], [-115.80431, 33.30898], [-115.8044, 33.29454], [-115.78725, 33.29442], [-115.78726, 33.30887], [-115.8043, 33.30899]], [[-115.76999, 33.29429], [-115.75252, 33.29292], [-115.75251, 33.30765], [-115.76997, 33.30875], [-115.76999, 33.29429]], [[-115.70106, 33.29275], [-115.68378, 33.29269], [-115.68388, 33.30725], [-115.70116, 33.30733], [-115.70106, 33.29275]], [[-115.68377, 33.29268], [-115.68377, 33.2782], [-115.66663, 33.27821], [-115.66664, 33.29271], [-115.68377, 33.29268]], [[-115.71832, 33.27828], [-115.70108, 33.27824], [-115.70106, 33.29273], [-115.71836, 33.29279], [-115.71832, 33.27828]], [[-115.75249, 33.27838], [-115.73564, 33.27832], [-115.73565, 33.29284], [-115.75082, 33.29293], [-115.75252, 33.29292], [-115.75249, 33.27838]], [[-115.78724, 33.28007], [-115.76997, 33.27998], [-115.76999, 33.29428], [-115.78725, 33.29442], [-115.78724, 33.28007]], [[-115.92741, 33.30975], [-115.9274, 33.30958], [-115.90987, 33.30952], [-115.90996, 33.3239], [-115.92744, 33.32395], [-115.92741, 33.30975]], [[-115.72667, 33.11861], [-115.72666, 33.1186], [-115.71806, 33.11861], [-115.71804, 33.12581], [-115.72666, 33.12581], [-115.72667, 33.11861]], [[-115.71811, 33.11137], [-115.7181, 33.11136], [-115.70947, 33.11137], [-115.70945, 33.1186], [-115.71806, 33.11861], [-115.71811, 33.11137]], [[-115.74387, 33.11853], [-115.74399, 33.10404], [-115.73532, 33.10411], [-115.73528, 33.11858], [-115.74387, 33.11853]]]]} | Open Access 1 | 12944 | Salton Sea - Irrigation District | 4595 | 2048 | Imperial Irrigation District 379 | Special District 4 | Irrigation District 17 | http://www.iid.com/ | Special District 4 | 2048 | Imperial Irrigation District 374 | Special District 4 | Irrigation District 16 | Imperial 20 | 69004.419 | Salton Sea - Irrigation District | 0 | Local Other or Unknown 14 | 4 | |
| 2719 | 2719 | 2718 | {"type": "Polygon", "coordinates": [[[-122.15145, 37.62482], [-122.1508, 37.62499], [-122.14973, 37.62515], [-122.14837, 37.62508], [-122.14707, 37.62481], [-122.14004, 37.62225], [-122.13959, 37.62203], [-122.13915, 37.62174], [-122.14433, 37.62003], [-122.14478, 37.62002], [-122.14935, 37.61837], [-122.15103, 37.61782], [-122.15106, 37.61893], [-122.15087, 37.61931], [-122.15075, 37.62021], [-122.15092, 37.62129], [-122.15132, 37.6246], [-122.15145, 37.62482]]]} | Restricted Access 2 | 18348 | Oliver Property | 23136 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 118.291 | Oliver Property | 1977 | Local Other or Unknown 14 | 4 | |
| 3178 | 3178 | 3177 | {"type": "Polygon", "coordinates": [[[-121.93307, 36.98817], [-121.93305, 36.9883], [-121.93244, 36.98822], [-121.93247, 36.98809], [-121.93307, 36.98817]]]} | Open Access 1 | 1913 | Willowbrook Park - Soquel Creek Water District | 27591 | 2157 | Soquel Creek Water District 592 | Special District 4 | Water District 13 | http://www.soquelcreekwater.org/ | Special District 4 | 2157 | Soquel Creek Water District 582 | Special District 4 | Water District 13 | Santa Cruz 5 | 0.197 | Willowbrook Park - Soquel Creek Water District | 0 | Local Other or Unknown 14 | 4 | |
| 3220 | 3220 | 3219 | {"type": "MultiPolygon", "coordinates": [[[[-122.09018, 37.13776], [-122.09013, 37.13822], [-122.0897, 37.13823], [-122.08931, 37.13812], [-122.08919, 37.1378], [-122.08975, 37.13776], [-122.09018, 37.13776]]], [[[-122.09064, 37.14203], [-122.09063, 37.14221], [-122.09047, 37.14215], [-122.09043, 37.1422], [-122.09035, 37.14208], [-122.09022, 37.14195], [-122.09006, 37.14184], [-122.08989, 37.14175], [-122.08984, 37.14171], [-122.08991, 37.14163], [-122.08994, 37.14164], [-122.09008, 37.14142], [-122.09036, 37.14158], [-122.09032, 37.14163], [-122.09055, 37.14187], [-122.09064, 37.14203]]]]} | Open Access 1 | 28259 | San Lorenzo Valley Water District | 11349 | 2277 | San Lorenzo Valley Water District 598 | Special District 4 | Water District 13 | http://www.slvwd.com/ | Special District 4 | 2277 | San Lorenzo Valley Water District 588 | Special District 4 | Water District 13 | Santa Cruz 5 | 1.606 | San Lorenzo Valley Water District | 0 | Local Other or Unknown 14 | 4 | |
| 3222 | 3222 | 3221 | {"type": "Polygon", "coordinates": [[[-121.96535, 37.09424], [-121.96324, 37.09425], [-121.96291, 37.09238], [-121.96505, 37.09238], [-121.96535, 37.09424]]]} | Open Access 1 | 28269 | Scotts Valley Water District | 25214 | 2274 | Scotts Valley Water District 599 | Special District 4 | Water District 13 | http://www.svwd.org/ | Special District 4 | 2274 | Scotts Valley Water District 589 | Special District 4 | Water District 13 | Santa Cruz 5 | 9.695 | Scotts Valley Water District | 0 | Local Other or Unknown 14 | 4 | |
| 3438 | 3438 | 3437 | {"type": "Polygon", "coordinates": [[[-121.27738, 39.49699], [-121.277, 39.49737], [-121.27617, 39.49697], [-121.2765, 39.49657], [-121.27738, 39.49699]]]} | Unknown Access 4 | 35476 | Yuba County Water Agency 3 | 27818 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 1.144 | Yuba County Water Agency 3 | 0 | Local Other or Unknown 14 | 4 | |
| 3457 | 3457 | 3456 | {"type": "Polygon", "coordinates": [[[-121.27854, 39.49693], [-121.27778, 39.49658], [-121.27854, 39.4958], [-121.27851, 39.49654], [-121.27854, 39.49693]]]} | Unknown Access 4 | 35580 | Yuba County Water Agency 47 | 27837 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 0.973 | Yuba County Water Agency 47 | 0 | Local Other or Unknown 14 | 4 | |
| 3465 | 3465 | 3464 | {"type": "Polygon", "coordinates": [[[-121.27748, 39.49831], [-121.27736, 39.49848], [-121.27711, 39.49873], [-121.27626, 39.49834], [-121.27659, 39.49789], [-121.27748, 39.49831]]]} | Unknown Access 4 | 35637 | Yuba County Water Agency 14 | 27802 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 1.259 | Yuba County Water Agency 14 | 0 | Local Other or Unknown 14 | 4 | |
| 3548 | 3548 | 3547 | {"type": "Polygon", "coordinates": [[[-121.95786, 37.09826], [-121.95785, 37.09831], [-121.95772, 37.09853], [-121.95771, 37.09862], [-121.95776, 37.0987], [-121.95792, 37.09886], [-121.95799, 37.09899], [-121.95798, 37.09918], [-121.95799, 37.09931], [-121.9581, 37.09962], [-121.95813, 37.09973], [-121.95812, 37.10001], [-121.95813, 37.10012], [-121.95819, 37.10025], [-121.95843, 37.10056], [-121.95847, 37.10076], [-121.95845, 37.10085], [-121.95837, 37.10096], [-121.958, 37.10123], [-121.95783, 37.10138], [-121.95773, 37.10155], [-121.95769, 37.10172], [-121.95629, 37.10164], [-121.95655, 37.10147], [-121.95691, 37.10155], [-121.95723, 37.10095], [-121.95744, 37.10068], [-121.95767, 37.10059], [-121.95757, 37.10014], [-121.95779, 37.09972], [-121.95773, 37.0996], [-121.9574, 37.09934], [-121.95733, 37.09916], [-121.95733, 37.09893], [-121.95737, 37.09881], [-121.95667, 37.09858], [-121.95655, 37.09837], [-121.95617, 37.09827], [-121.95643, 37.09799], [-121.95564, 37.09731], [-121.95743, 37.09748], [-121.95708, 37.09765], [-121.95701, 37.09775], [-121.95701, 37.09786], [-121.95747, 37.09804], [-121.95786, 37.09826]]]} | Open Access 1 | 28270 | Scotts Valley Water District | 25214 | 2274 | Scotts Valley Water District 599 | Special District 4 | Water District 13 | http://www.svwd.org/ | Special District 4 | 2274 | Scotts Valley Water District 589 | Special District 4 | Water District 13 | Santa Cruz 5 | 9.048 | Scotts Valley Water District | 0 | Local Other or Unknown 14 | 4 | |
| 3549 | 3549 | 3548 | {"type": "MultiPolygon", "coordinates": [[[[-122.0948, 37.05167], [-122.09523, 37.0518], [-122.09531, 37.05186], [-122.09535, 37.05191], [-122.09535, 37.05198], [-122.09527, 37.05217], [-122.09521, 37.05222], [-122.09513, 37.05225], [-122.09477, 37.05223], [-122.09445, 37.05228], [-122.0948, 37.05167]]], [[[-122.10538, 37.05336], [-122.09591, 37.05335], [-122.09591, 37.05309], [-122.09516, 37.05242], [-122.09526, 37.0524], [-122.09535, 37.05235], [-122.09542, 37.0523], [-122.09546, 37.05223], [-122.09555, 37.05206], [-122.09556, 37.05192], [-122.0955, 37.05179], [-122.09541, 37.0517], [-122.09555, 37.05169], [-122.09556, 37.05168], [-122.09536, 37.05163], [-122.09486, 37.05141], [-122.09483, 37.05116], [-122.09522, 37.0506], [-122.0954, 37.05042], [-122.09543, 37.05025], [-122.09453, 37.04961], [-122.09315, 37.05085], [-122.0934, 37.05104], [-122.09379, 37.05115], [-122.09377, 37.0512], [-122.09291, 37.05096], [-122.09282, 37.05091], [-122.09277, 37.05084], [-122.09232, 37.04997], [-122.09226, 37.0499], [-122.09218, 37.04985], [-122.09099, 37.04935], [-122.0907, 37.04918], [-122.09043, 37.04908], [-122.08996, 37.049], [-122.08972, 37.04899], [-122.08938, 37.049], [-122.08921, 37.04897], [-122.08894, 37.04882], [-122.08869, 37.04874], [-122.08869, 37.04856], [-122.08848, 37.04857], [-122.0881, 37.04862], [-122.0879, 37.0486], [-122.08772, 37.04862], [-122.08744, 37.04871], [-122.08727, 37.04878], [-122.08678, 37.04907], [-122.08627, 37.04922], [-122.08606, 37.04933], [-122.08594, 37.04943], [-122.08584, 37.04943], [-122.08595, 37.04937], [-122.08613, 37.04923], [-122.08644, 37.04908], [-122.08657, 37.04903], [-122.08668, 37.04902], [-122.08679, 37.04897], [-122.08687, 37.0489], [-122.0872, 37.04868], [-122.08738, 37.04861], [-122.08768, 37.04852], [-122.0879, 37.04849], [-122.0881, 37.0485], [-122.08846, 37.04846], [-122.08862, 37.04851], [-122.0887, 37.04848], [-122.08869, 37.04837], [-122.08745, 37.04797], [-122.08684, 37.04745], [-122.08624, 37.04744], [-122.08628, 37.0455], [-122.0912, 37.04553], [-122.09117, 37.04663], [-122.09118, 37.04664], [-122.09293, 37.04667], [-122.1006, 37.04584], [-122.10523, 37.04586], [-122.10538, 37.05336]]]]} | Open Access 1 | 28274 | San Lorenzo Valley Water District | 11349 | 2277 | San Lorenzo Valley Water District 598 | Special District 4 | Water District 13 | http://www.slvwd.com/ | Special District 4 | 2277 | San Lorenzo Valley Water District 588 | Special District 4 | Water District 13 | Santa Cruz 5 | 251.674 | San Lorenzo Valley Water District | 0 | Local Other or Unknown 14 | 4 | |
| 3583 | 3583 | 3582 | {"type": "Polygon", "coordinates": [[[-121.28103, 39.50008], [-121.27996, 39.49892], [-121.27995, 39.49806], [-121.28102, 39.49808], [-121.28103, 39.50008]]]} | Unknown Access 4 | 36690 | Yuba County Water Agency 39 | 27828 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 3.618 | Yuba County Water Agency 39 | 0 | Local Other or Unknown 14 | 4 | |
| 3586 | 3586 | 3585 | {"type": "Polygon", "coordinates": [[[-120.11203, 39.33019], [-120.08116, 39.33018], [-120.08102, 39.32357], [-120.08615, 39.32375], [-120.08611, 39.31645], [-120.10961, 39.31639], [-120.10962, 39.32423], [-120.10845, 39.3243], [-120.10845, 39.32716], [-120.11194, 39.32719], [-120.11203, 39.33019]]]} | Restricted Access 2 | 37007 | Waddle Ranch | 27205 | 2329 | Truckee Tahoe Airport District 663 | Special District 4 | Community Services District 19 | http://www.truckeetahoeairport.com/ | Special District 4 | 2329 | Truckee Tahoe Airport District 651 | Special District 4 | Community Services District 17 | Nevada 30 | 851.88 | Waddle Ranch | 0 | Local Other or Unknown 14 | 4 | |
| 3741 | 3741 | 3740 | {"type": "Polygon", "coordinates": [[[-121.909, 36.51865], [-121.90875, 36.51885], [-121.90885, 36.51911], [-121.90865, 36.51936], [-121.90826, 36.5196], [-121.90811, 36.51967], [-121.90807, 36.51973], [-121.90716, 36.52011], [-121.90656, 36.52042], [-121.90615, 36.52045], [-121.90555, 36.52056], [-121.90501, 36.52079], [-121.9046, 36.52107], [-121.90365, 36.52139], [-121.9025, 36.52232], [-121.90225, 36.5224], [-121.90144, 36.52252], [-121.90107, 36.52238], [-121.90084, 36.52241], [-121.90066, 36.52256], [-121.90048, 36.52259], [-121.89827, 36.52246], [-121.89696, 36.52232], [-121.89571, 36.51565], [-121.8964, 36.51259], [-121.89768, 36.51305], [-121.89768, 36.5118], [-121.90218, 36.51185], [-121.90218, 36.50821], [-121.90668, 36.50827], [-121.90669, 36.51191], [-121.90662, 36.51654], [-121.909, 36.51865]]]} | Restricted Access 2 | 44849 | Whisler-Wilson Ranch | 28252 | 2085 | Monterey Peninsula Regional Park District 47 | Special District 4 | Recreation/Parks District 4 | http://www.mprpd.org/ | Special District 4 | 2085 | Monterey Peninsula Regional Park District 46 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 306.464 | Whisler-Wilson Ranch | 0 | Local Other or Unknown 14 | 4 | |
| 3770 | 3770 | 3769 | {"type": "Polygon", "coordinates": [[[-121.40978, 39.0321], [-121.40886, 39.03318], [-121.40825, 39.0338], [-121.40801, 39.03396], [-121.40738, 39.03562], [-121.40691, 39.03607], [-121.40665, 39.03623], [-121.40644, 39.03625], [-121.40543, 39.03614], [-121.40505, 39.03582], [-121.40453, 39.0351], [-121.40393, 39.0349], [-121.40344, 39.03488], [-121.40287, 39.03514], [-121.4026, 39.03562], [-121.40242, 39.03625], [-121.40184, 39.0353], [-121.40342, 39.03459], [-121.40368, 39.03458], [-121.40502, 39.03496], [-121.40768, 39.03386], [-121.40806, 39.03357], [-121.40923, 39.03229], [-121.40961, 39.0318], [-121.40978, 39.0321]]]} | Unknown Access 4 | 472 | Dry Creek | 18279 | 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 | Yuba 25 | 15.587 | Dry Creek | 0 | Local Other or Unknown 14 | 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]);