units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
663 rows where DES_TP = 14 and MNG_AG_TYP = 2 sorted by PARK_URL
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Ventura, City of 106
- Roseville, City of 46
- Poway, City of 35
- Irvine, City of 29
- Los Angeles, City of 26
- California City, City of 25
- Encinitas, City of 21
- Napa, City of 21
- Rocklin, City of 17
- Seaside, City of 16
- San Diego, City of 15
- Lompoc, City of 14
- Santa Cruz, City of 12
- Oroville, City of 12
- Santa Barbara, City of 11
- Mammoth Lakes, Town of 11
- Auburn, City of 11
- Guadalupe, City of 10
- Santa Maria, City of 9
- Escondido, City of 9
- Watsonville, City of 7
- Scotts Valley, City of 7
- Torrance, City of 7
- San Luis Obispo, City of 6
- Los Angeles - Department of Water and Power, City of 6
- Salinas, City of 5
- Anaheim, City of 5
- Stockton, City of 5
- San Marcos, City of 4
- Marina, City of 4
- …
ACCESS_TYP 4
- Open Access 581
- No Public Access 60
- Unknown Access 16
- Restricted Access 6
MNG_AG_TYP 1
- City Agency · 663 ✖
DES_TP 1
- Local Other or Unknown · 663 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
185 | 185 | 184 | {"type": "Polygon", "coordinates": [[[-119.52773, 34.40703], [-119.52713, 34.40837], [-119.52698, 34.40879], [-119.52686, 34.40923], [-119.52678, 34.40968], [-119.52672, 34.40966], [-119.52675, 34.4094], [-119.52682, 34.40907], [-119.52689, 34.40883], [-119.52701, 34.40848], [-119.52766, 34.40701], [-119.52773, 34.40703]]]} | Unknown Access 4 | 592 | Santa Monica Creek | 25117 | 1047 | Carpinteria, City of 72 | City 2 | City Agency 2 | http://www.carpinteria.ca.us/parks_rec/index.shtml | City 2 | 1047 | Carpinteria, City of 70 | City 2 | City Agency 2 | Santa Barbara 7 | 0.489 | Santa Monica Creek | 0 | Local Other or Unknown 14 | 4 | |
208 | 208 | 207 | {"type": "Polygon", "coordinates": [[[-117.09538, 33.13695], [-117.09362, 33.13752], [-117.09362, 33.1357], [-117.09365, 33.13567], [-117.09379, 33.1356], [-117.0939, 33.13563], [-117.09401, 33.1356], [-117.09406, 33.13557], [-117.09407, 33.13551], [-117.09406, 33.1355], [-117.09382, 33.13558], [-117.09362, 33.13548], [-117.09357, 33.13283], [-117.09348, 33.13177], [-117.09397, 33.13182], [-117.09425, 33.13159], [-117.09432, 33.13154], [-117.09436, 33.13154], [-117.09442, 33.13154], [-117.09451, 33.13179], [-117.09458, 33.13207], [-117.09474, 33.13462], [-117.09453, 33.13534], [-117.09455, 33.13535], [-117.0948, 33.13527], [-117.09484, 33.13577], [-117.09489, 33.13594], [-117.09494, 33.13615], [-117.09502, 33.13635], [-117.09522, 33.13672], [-117.0953, 33.13686], [-117.09538, 33.13695]]]} | No Public Access 3 | 654 | Reidy Canyon Creek | 24281 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 16.798 | Reidy Canyon Creek | 0 | Local Other or Unknown 14 | 4 | |
235 | 235 | 234 | {"type": "MultiPolygon", "coordinates": [[[[-117.09432, 33.11987], [-117.09377, 33.1199], [-117.09333, 33.11988], [-117.09298, 33.11971], [-117.09292, 33.11957], [-117.0934, 33.11955], [-117.09432, 33.11987]]], [[[-117.09563, 33.1199], [-117.09552, 33.12002], [-117.09533, 33.1203], [-117.09524, 33.12049], [-117.09521, 33.1206], [-117.09497, 33.12181], [-117.09491, 33.12286], [-117.09486, 33.12319], [-117.09477, 33.12344], [-117.0946, 33.1235], [-117.09447, 33.1232], [-117.09458, 33.12282], [-117.0946, 33.12228], [-117.09473, 33.12119], [-117.09482, 33.12061], [-117.09498, 33.12015], [-117.09521, 33.11975], [-117.09563, 33.1199]]]]} | No Public Access 3 | 684 | Reidy Canyon Creek | 24281 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 4.055 | Reidy Canyon Creek | 0 | Local Other or Unknown 14 | 4 | |
236 | 236 | 235 | {"type": "Polygon", "coordinates": [[[-117.09461, 33.12373], [-117.09348, 33.12592], [-117.09308, 33.12668], [-117.09291, 33.12629], [-117.09353, 33.12505], [-117.09345, 33.12492], [-117.09371, 33.12472], [-117.09415, 33.12388], [-117.09461, 33.12373]]]} | No Public Access 3 | 687 | Reidy Canyon Creek | 24281 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 2.732 | Reidy Canyon Creek | 0 | Local Other or Unknown 14 | 4 | |
251 | 251 | 250 | {"type": "Polygon", "coordinates": [[[-117.0929, 33.12785], [-117.09258, 33.12797], [-117.09245, 33.12767], [-117.09253, 33.12696], [-117.09276, 33.12662], [-117.09289, 33.12693], [-117.09286, 33.12698], [-117.09278, 33.12727], [-117.09278, 33.12756], [-117.0929, 33.12785]]]} | No Public Access 3 | 683 | Reidy Canyon Creek | 24281 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 0.966 | Reidy Canyon Creek | 0 | Local Other or Unknown 14 | 4 | |
275 | 275 | 274 | {"type": "Polygon", "coordinates": [[[-119.19704, 34.28676], [-119.1969, 34.28706], [-119.19612, 34.28715], [-119.19612, 34.28713], [-119.19635, 34.28707], [-119.19658, 34.28696], [-119.19673, 34.28683], [-119.19685, 34.28668], [-119.19704, 34.28676]]]} | Open Access 1 | 35439 | Ventura holding 73 | 26955 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.367 | Ventura holding 73 | 0 | Local Other or Unknown 14 | 4 | |
276 | 276 | 275 | {"type": "Polygon", "coordinates": [[[-119.17054, 34.28047], [-119.17066, 34.2806], [-119.17066, 34.28063], [-119.17064, 34.28066], [-119.16734, 34.28261], [-119.16727, 34.2826], [-119.16717, 34.28249], [-119.16745, 34.28232], [-119.16748, 34.28234], [-119.16892, 34.28149], [-119.16889, 34.28144], [-119.17054, 34.28047]]]} | Open Access 1 | 35440 | Ventura holding 72 | 26954 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 1.844 | Ventura holding 72 | 0 | Local Other or Unknown 14 | 4 | |
364 | 364 | 363 | {"type": "Polygon", "coordinates": [[[-119.67342, 34.42333], [-119.67318, 34.42356], [-119.67274, 34.42324], [-119.67299, 34.42301], [-119.67342, 34.42333]]]} | Unknown Access 4 | 1276 | Sycamore Creek | 26121 | 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 | 0.446 | Sycamore Creek | 0 | Local Other or Unknown 14 | 4 | |
740 | 740 | 739 | {"type": "MultiPolygon", "coordinates": [[[[-122.43261, 37.73842], [-122.43248, 37.73852], [-122.4324, 37.73848], [-122.43211, 37.73825], [-122.432, 37.7382], [-122.43185, 37.73817], [-122.43168, 37.73818], [-122.43124, 37.7383], [-122.43104, 37.73798], [-122.43159, 37.73777], [-122.43195, 37.73779], [-122.43261, 37.73842]]], [[[-122.43549, 37.74395], [-122.43519, 37.74397], [-122.43518, 37.7439], [-122.435, 37.74391], [-122.43495, 37.74329], [-122.43544, 37.74326], [-122.43547, 37.74327], [-122.43549, 37.74395]]]]} | Open Access 1 | 5519 | Diamond Hights Lot3 | 18142 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 2.023 | Diamond Hights Lot3 | 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 | |
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 | |
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 |
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]);