units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,190 rows where DES_TP = 14 sorted by PARK_URL
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Mountains Recreation and Conservation Authority 150
- Ventura, City of 104
- Butte, County of 52
- Yuba County Water Agency 48
- Roseville, City of 46
- Santa Barbara, County of 38
- Poway, City of 35
- Lake, County of 34
- Irvine, City of 29
- Los Angeles, City of 26
- California City, City of 25
- Encinitas, City of 21
- Napa, City of 21
- Orange, County of 19
- Monterey, County of 18
- Rocklin, City of 17
- Seaside, City of 16
- San Diego, City of 15
- Lompoc, City of 14
- Santa Cruz, City of 12
- Los Angeles County Flood Control District 12
- Oroville, City of 12
- Santa Barbara Flood Control and Water Conserv. District 11
- Mammoth Lakes, Town of 11
- Auburn, City of 11
- Los Angeles, County of 10
- Santa Barbara, City of 10
- Guadalupe, City of 10
- Santa Maria, City of 9
- San Lorenzo Valley Water District 9
- …
MNG_AG_TYP 15
- City Agency 654
- County Agency 208
- Open Space District 153
- Water District 78
- Flood District 30
- Recreation/Parks District 28
- County Agency - Other 5
- Irrigation District 4
- Sanitation District 3
- Community Services District 2
- County Agency - Parks 1
- Special District - Other 1
- Metropolitan Planning Organization 1
- Conservation District 1
- Transportation Agency 1
ACCESS_TYP 4
- Open Access 848
- Unknown Access 200
- No Public Access 92
- Restricted Access 30
DES_TP 1
- Local Other or Unknown · 1,170 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
1209 | 1209 | 1208 | {"type": "Polygon", "coordinates": [[[-118.61077, 34.34136], [-118.60659, 34.34141], [-118.60658, 34.33946], [-118.61074, 34.33941], [-118.61077, 34.34136]]]} | Open Access 1 | 8436 | Unnamed site - Santa Monica Mountains Conservancy | 29566 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 20.46 | 0 | Local Other or Unknown 14 | 4 | ||
1210 | 1210 | 1209 | {"type": "MultiPolygon", "coordinates": [[[[-118.61079, 34.34292], [-118.6087, 34.34294], [-118.60869, 34.34216], [-118.61078, 34.34214], [-118.61079, 34.34292]]], [[[-118.61929, 34.3608], [-118.6181, 34.36074], [-118.61801, 34.35708], [-118.61919, 34.35713], [-118.61929, 34.3608]]]]} | Open Access 1 | 8447 | Unnamed site - Santa Monica Mountains Conservancy | 29566 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 15.04 | 0 | Local Other or Unknown 14 | 4 | ||
1216 | 1216 | 1215 | {"type": "Polygon", "coordinates": [[[-122.58991, 38.30992], [-122.57891, 38.32201], [-122.57277, 38.31852], [-122.58368, 38.30636], [-122.58991, 38.30992]]]} | No Public Access 3 | 7007 | Lafferty Ranch | 20837 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 272.49 | Lafferty Ranch | 0 | Local Other or Unknown 14 | 4 | |
1339 | 1339 | 1338 | {"type": "Polygon", "coordinates": [[[-116.73714, 32.58342], [-116.74114, 32.58362], [-116.74116, 32.57636], [-116.73709, 32.57624], [-116.73707, 32.57262], [-116.74115, 32.5727], [-116.74116, 32.5691], [-116.73703, 32.56906], [-116.73696, 32.56738], [-116.75384, 32.56596], [-116.75385, 32.56579], [-116.80114, 32.56182], [-116.80119, 32.56352], [-116.79687, 32.56361], [-116.79696, 32.56738], [-116.78817, 32.56748], [-116.78397, 32.56787], [-116.78402, 32.57978], [-116.77099, 32.58015], [-116.76217, 32.58046], [-116.76212, 32.58426], [-116.75374, 32.58427], [-116.75371, 32.58796], [-116.75367, 32.59538], [-116.74509, 32.59534], [-116.74513, 32.59151], [-116.72846, 32.59121], [-116.72857, 32.58727], [-116.73278, 32.58732], [-116.7329, 32.5834], [-116.73714, 32.58342]]]} | No Public Access 3 | 7398 | Marron Valley Mitigation Bank | 21885 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 2644.0 | Marron Valley Mitigation Bank | 0 | Local Other or Unknown 14 | 4 | |
1412 | 1412 | 1411 | {"type": "Polygon", "coordinates": [[[-119.67034, 34.43903], [-119.67034, 34.4395], [-119.66917, 34.4395], [-119.66941, 34.43903], [-119.67034, 34.43903]]]} | Unknown Access 4 | 36486 | Santa Barbara holding 9 | 25051 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | Santa Barbara 7 | 1.234 | Santa Barbara holding 9 | 0 | Local Other or Unknown 14 | 4 | |
1437 | 1437 | 1436 | {"type": "MultiPolygon", "coordinates": [[[[-118.34031, 34.12245], [-118.33893, 34.12345], [-118.33872, 34.12325], [-118.34008, 34.12224], [-118.34031, 34.12245]]], [[[-118.33885, 34.12352], [-118.33618, 34.12548], [-118.33607, 34.12549], [-118.33599, 34.12546], [-118.33595, 34.12544], [-118.3359, 34.12532], [-118.33855, 34.12337], [-118.33863, 34.12331], [-118.33885, 34.12352]]]]} | No Public Access 3 | 12459 | Los Angeles Department of Water and Power | 21482 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 3.847 | Los Angeles Department of Water and Power | 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 | |
1634 | 1634 | 1633 | {"type": "Polygon", "coordinates": [[[-118.33735, 34.1239], [-118.33702, 34.12408], [-118.33683, 34.12383], [-118.33721, 34.12367], [-118.33731, 34.12385], [-118.33735, 34.1239]]]} | No Public Access 3 | 12456 | Los Angeles Department of Water and Power | 21482 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.284 | Los Angeles Department of Water and Power | 0 | Local Other or Unknown 14 | 4 | |
1637 | 1637 | 1636 | {"type": "Polygon", "coordinates": [[[-118.34683, 34.11999], [-118.34463, 34.11999], [-118.34429, 34.11994], [-118.34428, 34.12], [-118.34364, 34.12], [-118.3434, 34.12018], [-118.34321, 34.11995], [-118.34352, 34.11973], [-118.34369, 34.11972], [-118.3438, 34.11978], [-118.34393, 34.11981], [-118.34412, 34.1198], [-118.34424, 34.11974], [-118.34427, 34.11972], [-118.34662, 34.11971], [-118.34683, 34.11999]]]} | No Public Access 3 | 12462 | Los Angeles Department of Water and Power | 21482 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 2.35 | Los Angeles Department of Water and Power | 0 | Local Other or Unknown 14 | 4 | |
2461 | 2461 | 2460 | {"type": "Polygon", "coordinates": [[[-118.34315, 34.12036], [-118.34289, 34.12054], [-118.34274, 34.1204], [-118.34265, 34.12036], [-118.34296, 34.12013], [-118.34315, 34.12036]]]} | No Public Access 3 | 12465 | Los Angeles Department of Water and Power | 21482 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.255 | Los Angeles Department of Water and Power | 0 | Local Other or Unknown 14 | 4 | |
2462 | 2462 | 2461 | {"type": "Polygon", "coordinates": [[[-118.35722, 34.10552], [-118.35702, 34.10564], [-118.35703, 34.10532], [-118.35722, 34.10533], [-118.35722, 34.10552]]]} | No Public Access 3 | 12466 | Los Angeles Department of Water and Power | 21482 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.129 | Los Angeles Department of Water and Power | 0 | Local Other or Unknown 14 | 4 | |
2551 | 2551 | 2550 | {"type": "Polygon", "coordinates": [[[-122.19184, 38.13515], [-122.19158, 38.13526], [-122.19131, 38.13478], [-122.19123, 38.13468], [-122.19099, 38.1342], [-122.19079, 38.13407], [-122.19041, 38.13416], [-122.1903, 38.13436], [-122.18981, 38.13471], [-122.18936, 38.13477], [-122.18846, 38.13375], [-122.18772, 38.13324], [-122.18704, 38.13336], [-122.18679, 38.13315], [-122.18649, 38.13293], [-122.18554, 38.13206], [-122.1861, 38.13174], [-122.18524, 38.13097], [-122.18589, 38.13091], [-122.18631, 38.13097], [-122.18726, 38.13107], [-122.18796, 38.13157], [-122.18847, 38.13188], [-122.18936, 38.13246], [-122.19034, 38.13316], [-122.19067, 38.13331], [-122.1909, 38.13352], [-122.19133, 38.13422], [-122.19156, 38.13457], [-122.19184, 38.13515]]]} | Restricted Access 2 | 17806 | McIntyre Ranch | 22040 | 1365 | Vallejo, City of 531 | City 2 | City Agency 2 | http://www.ci.vallejo.ca.us/attractions___events/sports___recreation/parks___trails | City 2 | 1365 | Vallejo, City of 524 | City 2 | City Agency 2 | Solano 26 | 23.753 | McIntyre Ranch | 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 | |
2882 | 2882 | 2881 | {"type": "Polygon", "coordinates": [[[-121.79106, 37.67722], [-121.79029, 37.67754], [-121.78871, 37.6778], [-121.78807, 37.67784], [-121.78741, 37.67737], [-121.78811, 37.67727], [-121.78838, 37.67755], [-121.78901, 37.67751], [-121.78842, 37.67665], [-121.78831, 37.67628], [-121.78917, 37.67597], [-121.78992, 37.67604], [-121.79005, 37.67635], [-121.79039, 37.67668], [-121.79075, 37.67693], [-121.79106, 37.67722]]]} | Open Access 1 | 22290 | Unknown park - Livermore, City of | 28714 | 1178 | Livermore, City of 256 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | Alameda 17 | 8.284 | 0 | Local Other or Unknown 14 | 4 | ||
2953 | 2953 | 2952 | {"type": "Polygon", "coordinates": [[[-117.88143, 33.70905], [-117.8815, 33.70906], [-117.88153, 33.70911], [-117.88152, 33.70962], [-117.88149, 33.70965], [-117.87994, 33.70965], [-117.88027, 33.70954], [-117.88143, 33.70905]]]} | Open Access 1 | 20418 | Segerstrom Triangle | 25286 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 1.234 | Segerstrom Triangle | 0 | Local Other or Unknown 14 | 4 | |
3050 | 3050 | 3049 | {"type": "MultiPolygon", "coordinates": [[[[-121.24452, 38.72086], [-121.24452, 38.72174], [-121.24392, 38.72198], [-121.24348, 38.72211], [-121.243, 38.72216], [-121.24087, 38.72215], [-121.24088, 38.72187], [-121.24142, 38.72131], [-121.24229, 38.72048], [-121.2424, 38.72035], [-121.24247, 38.72024], [-121.24255, 38.72001], [-121.24256, 38.71981], [-121.24243, 38.71901], [-121.24317, 38.71934], [-121.24452, 38.72086]]], [[[-121.24324, 38.72673], [-121.24287, 38.72694], [-121.24263, 38.72659], [-121.24242, 38.72641], [-121.24196, 38.72561], [-121.24212, 38.7254], [-121.24228, 38.7254], [-121.24235, 38.72544], [-121.24262, 38.72546], [-121.24261, 38.72582], [-121.24268, 38.72605], [-121.24282, 38.72626], [-121.24324, 38.72673]]], [[[-121.24705, 38.72776], [-121.24669, 38.72806], [-121.24614, 38.7276], [-121.24538, 38.7271], [-121.24461, 38.72713], [-121.24464, 38.72905], [-121.24408, 38.72926], [-121.24395, 38.72917], [-121.24386, 38.72913], [-121.24372, 38.7291], [-121.24358, 38.7291], [-121.24358, 38.72874], [-121.24324, 38.72824], [-121.24342, 38.72813], [-121.24353, 38.72797], [-121.24366, 38.72722], [-121.24366, 38.72705], [-121.24361, 38.7269], [-121.24353, 38.7268], [-121.2429, 38.72609], [-121.24281, 38.72588], [-121.2428, 38.7257], [-121.24283, 38.72526], [-121.24329, 38.72527], [-121.24334, 38.72506], [-121.2433, 38.72484], [-121.24337, 38.72448], [-121.24365, 38.72414], [-121.24385, 38.72389], [-121.24388, 38.72355], [-121.24381, 38.72292], [-121.24399, 38.72224], [-121.24462, 38.72224], [-121.24462, 38.72236], [-121.24444, 38.72249], [-121.24437, 38.72277], [-121.24432, 38.72287], [-121.2443, 38.72308], [-121.24453, 38.72352], [-121.24447, 38.72389], [-121.24432, 38.7242], [-121.24392, 38.72447], [-121.2439, 38.72451], [-121.24388, 38.72482], [-121.24387, 38.72589], [-121.24392, 38.72603], [-121.24398, 38.72612], [-121.2441, 38.72622], [-121.24423, 38.72622], [-121.24505, 38.72665], [-121.2456, 38.72668], [-121.2461, 38.72696], [-121.24705, 38.72776]]], [[[-121.24936, 38.72958], [-121.24879, 38.72974], [-121.24869, 38.72944], [-121.2471, 38.72837], [-121.24684, 38.72817], [-121.24721, 38.72788], [-121.24746, 38.72807], [-121.24913, 38.72919], [-121.24936, 38.72958]]]]} | Open Access 1 | 20932 | Flood Control | 18952 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 37.251 | Flood Control | 0 | Local Other or Unknown 14 | 4 | |
3141 | 3141 | 3140 | {"type": "Polygon", "coordinates": [[[-122.22656, 38.37413], [-122.20765, 38.37399], [-122.20771, 38.35953], [-122.21237, 38.35957], [-122.21237, 38.36318], [-122.22173, 38.36325], [-122.22177, 38.36686], [-122.22646, 38.3669], [-122.22656, 38.37413]]]} | No Public Access 3 | 25801 | Milliken Reservoir Property | 22251 | 311 | Napa, County of 498 | County 3 | County Agency 3 | http://www.napaoutdoors.org/ | County 3 | 311 | Napa, County of 489 | County 3 | County Agency 3 | Napa 11 | 489.122 | Milliken Reservoir Property | 2000 | 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 |
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]);