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 LABEL_NAME descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, LAYER
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15059 | 15059 | 15058 | {"type": "Polygon", "coordinates": [[[-118.20626, 34.09845], [-118.20591, 34.09868], [-118.20587, 34.09831], [-118.20587, 34.09831], [-118.20626, 34.09845]]]} | Open Access 1 | 45839 | Woodside Triangle | 28859 | 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.175 | Woodside Triangle | 0 | Local Other or Unknown 14 | 4 | |
13965 | 13965 | 13964 | {"type": "Polygon", "coordinates": [[[-121.77936, 38.67377], [-121.77932, 38.67379], [-121.77838, 38.67379], [-121.77836, 38.67377], [-121.77838, 38.67215], [-121.77934, 38.67215], [-121.77937, 38.67216], [-121.77936, 38.67377]]]} | Open Access 1 | 36630 | Woodland holding 1 | 27720 | 1665 | Woodland, City of 547 | City 2 | City Agency 2 | http://www.cityofwoodland.org/gov/depts/communityserv/parks/default.asp | City 2 | 1665 | Woodland, City of 540 | City 2 | City Agency 2 | Yolo 33 | 3.889 | Woodland holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13915 | 13915 | 13914 | {"type": "Polygon", "coordinates": [[[-119.10553, 36.42313], [-119.10507, 36.42313], [-119.10506, 36.42314], [-119.10507, 36.42332], [-119.10552, 36.42334], [-119.10552, 36.42466], [-119.10293, 36.42464], [-119.10293, 36.42289], [-119.10552, 36.42289], [-119.10553, 36.42313]]]} | Open Access 1 | 36520 | Woodlake holding 3 | 27716 | 1383 | Woodlake, City of 175 | City 2 | City Agency 2 | http://www.cityofwoodlake.com/ | City 2 | 1383 | Woodlake, City of 171 | City 2 | City Agency 2 | Tulare 29 | 11.04 | Woodlake holding 3 | 0 | Local Other or Unknown 14 | 4 | |
13363 | 13363 | 13362 | {"type": "Polygon", "coordinates": [[[-119.10553, 36.42313], [-119.10552, 36.42333], [-119.10507, 36.42332], [-119.10506, 36.42313], [-119.10553, 36.42313]]]} | Open Access 1 | 35447 | Woodlake holding 2 | 27715 | 1383 | Woodlake, City of 175 | City 2 | City Agency 2 | http://www.cityofwoodlake.com/ | City 2 | 1383 | Woodlake, City of 171 | City 2 | City Agency 2 | Tulare 29 | 0.23 | Woodlake holding 2 | 0 | Local Other or Unknown 14 | 4 | |
13297 | 13297 | 13296 | {"type": "Polygon", "coordinates": [[[-119.08851, 36.41638], [-119.08851, 36.41666], [-119.08824, 36.41669], [-119.08818, 36.41666], [-119.08817, 36.41638], [-119.08851, 36.41638]]]} | Open Access 1 | 35351 | Woodlake holding 1 | 27714 | 1383 | Woodlake, City of 175 | City 2 | City Agency 2 | http://www.cityofwoodlake.com/ | City 2 | 1383 | Woodlake, City of 171 | City 2 | City Agency 2 | Tulare 29 | 0.244 | Woodlake holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13969 | 13969 | 13968 | {"type": "Polygon", "coordinates": [[[-121.97688, 38.51984], [-121.97524, 38.52043], [-121.97486, 38.51977], [-121.97649, 38.51918], [-121.97669, 38.51951], [-121.97633, 38.51964], [-121.97632, 38.51966], [-121.97635, 38.51968], [-121.97671, 38.51955], [-121.97688, 38.51984]]]} | Open Access 1 | 36635 | Winters holding 1 | 27655 | 1675 | Winters, City of 581 | City 2 | City Agency 2 | http://www.cityofwinters.org/recreation/recreation_gen.htm | City 2 | 1675 | Winters, City of 573 | City 2 | City Agency 2 | Yolo 33 | 3.09 | Winters holding 1 | 0 | Local Other or Unknown 14 | 4 | |
6428 | 6428 | 6427 | {"type": "Polygon", "coordinates": [[[-121.33786, 36.47151], [-121.33187, 36.47323], [-121.3318, 36.46281], [-121.3377, 36.46284], [-121.33786, 36.47151]]]} | No Public Access 3 | 1938 | Windmill Property | 27628 | 1336 | Soledad, City of 485 | City 2 | City Agency 2 | http://www.cityofsoledad.com/ | City 2 | 1336 | Soledad, City of 476 | City 2 | City Agency 2 | Monterey 14 | 139.773 | Windmill Property | 0 | Local Other or Unknown 14 | 4 | |
11092 | 11092 | 11091 | {"type": "MultiPolygon", "coordinates": [[[[-121.16924, 38.65774], [-121.16896, 38.65771], [-121.16855, 38.65678], [-121.16886, 38.65674], [-121.16896, 38.65708], [-121.16924, 38.65774]]], [[[-121.17532, 38.65773], [-121.17433, 38.65815], [-121.17418, 38.65817], [-121.17404, 38.65816], [-121.17391, 38.65812], [-121.1731, 38.65773], [-121.17294, 38.65768], [-121.17275, 38.65767], [-121.17207, 38.65774], [-121.17195, 38.65772], [-121.1719, 38.65768], [-121.17188, 38.65763], [-121.17178, 38.65702], [-121.17332, 38.65696], [-121.1745, 38.65783], [-121.17532, 38.65773]]], [[[-121.17623, 38.66259], [-121.1745, 38.66164], [-121.17445, 38.66148], [-121.17582, 38.6616], [-121.17604, 38.66229], [-121.1762, 38.66248], [-121.17623, 38.66259]]], [[[-121.17588, 38.65765], [-121.17587, 38.65767], [-121.17565, 38.65814], [-121.17558, 38.65769], [-121.17588, 38.65765]]]]} | Open Access 1 | 21311 | Willow Creek | 27575 | 1108 | Folsom, City of 565 | City 2 | City Agency 2 | http://www.folsom.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1108 | Folsom, City of 557 | City 2 | City Agency 2 | Sacramento 41 | 7.281 | Willow Creek | 0 | Local Other or Unknown 14 | 4 | |
13799 | 13799 | 13798 | {"type": "Polygon", "coordinates": [[[-122.15135, 39.15148], [-122.15134, 39.15235], [-122.15081, 39.15256], [-122.15016, 39.15159], [-122.15049, 39.15147], [-122.15135, 39.15148]]]} | Open Access 1 | 36392 | Williams holding 1 | 27564 | 1381 | Williams, City of 752 | City 2 | City Agency 2 | http://www.cityofwilliams.org/parks-rec/index.htm | City 2 | 1381 | Williams, City of 738 | City 2 | City Agency 2 | Colusa 49 | 2.145 | Williams holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13303 | 13303 | 13302 | {"type": "Polygon", "coordinates": [[[-121.75571, 36.90633], [-121.75551, 36.90647], [-121.75541, 36.90638], [-121.75541, 36.90638], [-121.75571, 36.90633]]]} | Open Access 1 | 35365 | Watsonville holding 1 | 27309 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 0.04 | Watsonville holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13516 | 13516 | 13515 | {"type": "Polygon", "coordinates": [[[-117.32213, 34.54004], [-117.3216, 34.54025], [-117.32155, 34.54016], [-117.32099, 34.54035], [-117.32087, 34.54008], [-117.32067, 34.53955], [-117.32071, 34.53951], [-117.32174, 34.53927], [-117.32179, 34.53927], [-117.32182, 34.5393], [-117.32204, 34.53987], [-117.32213, 34.54004]]]} | Open Access 1 | 35809 | Victorville holding 1 | 27087 | 1367 | Victorville, City of 40 | City 2 | City Agency 2 | http://ci.victorville.ca.us/Site/CityDepartments2.aspx?id=522 | City 2 | 1367 | Victorville, City of 39 | City 2 | City Agency 2 | San Bernardino 22 | 2.576 | Victorville holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13251 | 13251 | 13250 | {"type": "Polygon", "coordinates": [[[-119.19394, 34.28125], [-119.19393, 34.28125], [-119.1939, 34.28121], [-119.19385, 34.2812], [-119.19316, 34.28133], [-119.19299, 34.28152], [-119.19315, 34.28186], [-119.19341, 34.28221], [-119.1934, 34.28222], [-119.19324, 34.28201], [-119.19311, 34.28181], [-119.19297, 34.28152], [-119.19293, 34.28142], [-119.19294, 34.28138], [-119.193, 34.28134], [-119.19385, 34.28119], [-119.19391, 34.2812], [-119.19394, 34.28125]]]} | Open Access 1 | 35296 | Ventura holding 99 | 26983 | 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.127 | Ventura holding 99 | 0 | Local Other or Unknown 14 | 4 | |
13253 | 13253 | 13252 | {"type": "Polygon", "coordinates": [[[-119.18424, 34.28252], [-119.18342, 34.28264], [-119.18296, 34.28272], [-119.18242, 34.28286], [-119.18238, 34.2829], [-119.18239, 34.28295], [-119.18238, 34.28296], [-119.18236, 34.28293], [-119.18237, 34.28288], [-119.18241, 34.28285], [-119.18296, 34.28271], [-119.18351, 34.28261], [-119.18423, 34.28251], [-119.18424, 34.28252]]]} | Open Access 1 | 35298 | Ventura holding 98 | 26982 | 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.069 | Ventura holding 98 | 0 | Local Other or Unknown 14 | 4 | |
13254 | 13254 | 13253 | {"type": "Polygon", "coordinates": [[[-119.16704, 34.29601], [-119.16663, 34.29625], [-119.16528, 34.29542], [-119.16408, 34.29455], [-119.1635, 34.29388], [-119.16364, 34.2938], [-119.16372, 34.29381], [-119.16398, 34.29415], [-119.16414, 34.2943], [-119.1646, 34.29464], [-119.16496, 34.2948], [-119.1651, 34.29489], [-119.16566, 34.29542], [-119.16603, 34.29569], [-119.1662, 34.29578], [-119.16643, 34.29587], [-119.16704, 34.29601]]]} | Open Access 1 | 35299 | Ventura holding 97 | 26981 | 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 | 2.39 | Ventura holding 97 | 0 | Local Other or Unknown 14 | 4 | |
13242 | 13242 | 13241 | {"type": "Polygon", "coordinates": [[[-119.16635, 34.26389], [-119.16519, 34.26459], [-119.16502, 34.26471], [-119.16483, 34.26489], [-119.16434, 34.26543], [-119.16427, 34.26549], [-119.16421, 34.26561], [-119.16421, 34.26569], [-119.16426, 34.26578], [-119.16434, 34.26585], [-119.16477, 34.26636], [-119.16504, 34.2666], [-119.16527, 34.26674], [-119.16561, 34.2669], [-119.1657, 34.26691], [-119.16578, 34.2669], [-119.16591, 34.26683], [-119.16615, 34.26702], [-119.16593, 34.26727], [-119.16504, 34.26697], [-119.16402, 34.26581], [-119.16411, 34.2656], [-119.16436, 34.26534], [-119.16444, 34.26513], [-119.16455, 34.26502], [-119.16479, 34.26487], [-119.16484, 34.26469], [-119.16556, 34.26419], [-119.1657, 34.26396], [-119.16584, 34.2639], [-119.16613, 34.26396], [-119.1662, 34.26389], [-119.16635, 34.26389]]]} | Open Access 1 | 35286 | Ventura holding 96 | 26980 | 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 | 2.502 | Ventura holding 96 | 0 | Local Other or Unknown 14 | 4 | |
13246 | 13246 | 13245 | {"type": "Polygon", "coordinates": [[[-119.17722, 34.26059], [-119.17718, 34.26059], [-119.1769, 34.26038], [-119.17675, 34.26011], [-119.17642, 34.26014], [-119.17633, 34.26019], [-119.17607, 34.26025], [-119.17606, 34.26031], [-119.17581, 34.26047], [-119.17576, 34.26057], [-119.17563, 34.26054], [-119.17562, 34.26057], [-119.17457, 34.26054], [-119.17433, 34.26059], [-119.17373, 34.26086], [-119.17364, 34.26092], [-119.17348, 34.26107], [-119.1734, 34.26125], [-119.17333, 34.26123], [-119.1731, 34.26128], [-119.17327, 34.26119], [-119.17314, 34.26103], [-119.1732, 34.26095], [-119.17334, 34.26091], [-119.17346, 34.26078], [-119.17379, 34.26074], [-119.17388, 34.26062], [-119.17398, 34.26054], [-119.17407, 34.26054], [-119.17415, 34.26045], [-119.17425, 34.26039], [-119.17435, 34.26037], [-119.17453, 34.26046], [-119.17481, 34.26044], [-119.17483, 34.26029], [-119.17491, 34.26023], [-119.17511, 34.26028], [-119.17528, 34.26021], [-119.17545, 34.26027], [-119.17545, 34.26046], [-119.17563, 34.26049], [-119.17587, 34.26021], [-119.17616, 34.26002], [-119.17644, 34.25999], [-119.17658, 34.26003], [-119.17678, 34.25991], [-119.17703, 34.26039], [-119.1772, 34.26049], [-119.17722, 34.26059]]]} | Open Access 1 | 35291 | Ventura holding 95 | 26979 | 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 | 2.007 | Ventura holding 95 | 0 | Local Other or Unknown 14 | 4 | |
13247 | 13247 | 13246 | {"type": "Polygon", "coordinates": [[[-119.19609, 34.25545], [-119.19601, 34.2557], [-119.19558, 34.25596], [-119.19573, 34.25634], [-119.19517, 34.25684], [-119.195, 34.25825], [-119.19511, 34.25833], [-119.19501, 34.2584], [-119.19502, 34.25842], [-119.19529, 34.25841], [-119.19556, 34.25848], [-119.19553, 34.25863], [-119.19561, 34.25882], [-119.19558, 34.25897], [-119.19561, 34.25909], [-119.19556, 34.25911], [-119.19527, 34.25939], [-119.19534, 34.25961], [-119.19546, 34.25977], [-119.19544, 34.25994], [-119.19549, 34.26001], [-119.19557, 34.26002], [-119.19566, 34.26014], [-119.19585, 34.26029], [-119.19558, 34.2604], [-119.19544, 34.26052], [-119.19538, 34.26068], [-119.19541, 34.26096], [-119.19572, 34.2614], [-119.19513, 34.26146], [-119.19508, 34.26144], [-119.19506, 34.2614], [-119.19504, 34.2614], [-119.19477, 34.26015], [-119.19476, 34.26005], [-119.19472, 34.25997], [-119.19466, 34.25991], [-119.19483, 34.2597], [-119.19479, 34.25953], [-119.19479, 34.2591], [-119.19482, 34.25885], [-119.19471, 34.25886], [-119.19449, 34.25865], [-119.19439, 34.2585], [-119.19435, 34.25834], [-119.19436, 34.25822], [-119.19472, 34.2571], [-119.19477, 34.25669], [-119.19474, 34.25649], [-119.19497, 34.25635], [-119.19493, 34.25607], [-119.19484, 34.25574], [-119.19535, 34.25561], [-119.19581, 34.25515], [-119.19587, 34.25511], [-119.19609, 34.25545]]]} | Open Access 1 | 35292 | Ventura holding 94 | 26978 | 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 | 10.393 | Ventura holding 94 | 0 | Local Other or Unknown 14 | 4 | |
13249 | 13249 | 13248 | {"type": "Polygon", "coordinates": [[[-119.19871, 34.28098], [-119.19821, 34.2821], [-119.19765, 34.28218], [-119.19803, 34.28189], [-119.19846, 34.28084], [-119.19839, 34.28049], [-119.19865, 34.28045], [-119.19871, 34.28098]]]} | Open Access 1 | 35294 | Ventura holding 93 | 26977 | 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.228 | Ventura holding 93 | 0 | Local Other or Unknown 14 | 4 | |
13250 | 13250 | 13249 | {"type": "Polygon", "coordinates": [[[-119.20753, 34.27207], [-119.20215, 34.27284], [-119.20212, 34.27268], [-119.2061, 34.27211], [-119.20613, 34.272], [-119.20633, 34.27201], [-119.20648, 34.272], [-119.20749, 34.27186], [-119.20753, 34.27207]]]} | Open Access 1 | 35295 | Ventura holding 92 | 26976 | 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 | 2.462 | Ventura holding 92 | 0 | Local Other or Unknown 14 | 4 | |
13243 | 13243 | 13242 | {"type": "Polygon", "coordinates": [[[-119.16877, 34.27064], [-119.16876, 34.27067], [-119.16858, 34.27045], [-119.16824, 34.27065], [-119.16814, 34.27064], [-119.16805, 34.2704], [-119.16835, 34.2703], [-119.16825, 34.27004], [-119.1683, 34.27007], [-119.16877, 34.27064]]]} | Open Access 1 | 35287 | Ventura holding 91 | 26975 | 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.372 | Ventura holding 91 | 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]);