units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
22 rows where ACCESS_TYP = 1, LAYER = 2 and MNG_AGENCY = 301
This data as json, copyable, CSV (advanced)
DES_TP 4
MNG_AG_TYP 1
- City Agency 22
MNG_AGENCY 1
- La Verne, City of · 22 ✖
ACCESS_TYP 1
- Open Access · 22 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1010 | 1010 | 1009 | {"type": "Polygon", "coordinates": [[[-117.78545, 34.12475], [-117.78473, 34.12579], [-117.78446, 34.12623], [-117.78414, 34.12696], [-117.78402, 34.1271], [-117.78352, 34.1271], [-117.78322, 34.12645], [-117.78334, 34.12642], [-117.7834, 34.12638], [-117.78368, 34.1266], [-117.78372, 34.12659], [-117.78375, 34.12441], [-117.78446, 34.12442], [-117.78446, 34.12472], [-117.78483, 34.12473], [-117.78484, 34.12475], [-117.78545, 34.12475]]]} | Open Access 1 | 6789 | Los Encinos Park | 21514 | 1162 | La Verne, City of 305 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | Los Angeles 6 | 6.9 | Los Encinos Park | 0 | Local Park 2 | 4 | |
1011 | 1011 | 1010 | {"type": "Polygon", "coordinates": [[[-117.76393, 34.14161], [-117.76342, 34.1421], [-117.76331, 34.14232], [-117.76331, 34.14243], [-117.76337, 34.14267], [-117.76337, 34.14304], [-117.76345, 34.1432], [-117.76345, 34.14348], [-117.76025, 34.14346], [-117.75906, 34.14347], [-117.75905, 34.14352], [-117.75879, 34.14355], [-117.75874, 34.14353], [-117.75869, 34.14324], [-117.75976, 34.14314], [-117.76228, 34.14231], [-117.76283, 34.14222], [-117.76319, 34.14186], [-117.76344, 34.14188], [-117.7638, 34.14152], [-117.76393, 34.14161]]]} | Open Access 1 | 6791 | Golden Hills Wilderness Park | 19365 | 1162 | La Verne, City of 305 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | Los Angeles 6 | 9.525 | Golden Hills Wilderness Park | 0 | Local Conservation Area 4 | 2 | |
1012 | 1012 | 1011 | {"type": "Polygon", "coordinates": [[[-117.76319, 34.14696], [-117.76318, 34.14723], [-117.76299, 34.14736], [-117.76281, 34.14753], [-117.76245, 34.14732], [-117.76267, 34.14708], [-117.76274, 34.14696], [-117.76278, 34.14687], [-117.76319, 34.14696]]]} | Open Access 1 | 6793 | Rustic Canyon Park | 24749 | 1162 | La Verne, City of 305 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | Los Angeles 6 | 0.708 | Rustic Canyon Park | 0 | Local Park 2 | 4 | |
1013 | 1013 | 1012 | {"type": "Polygon", "coordinates": [[[-117.77666, 34.12771], [-117.77648, 34.12776], [-117.77611, 34.1278], [-117.7758, 34.12781], [-117.77566, 34.12789], [-117.77553, 34.128], [-117.77517, 34.12848], [-117.77516, 34.12873], [-117.77513, 34.12876], [-117.77504, 34.12875], [-117.77491, 34.12831], [-117.77483, 34.12796], [-117.77483, 34.12784], [-117.77492, 34.12751], [-117.77553, 34.12759], [-117.77594, 34.12763], [-117.77604, 34.12765], [-117.77661, 34.12766], [-117.77665, 34.12768], [-117.77666, 34.12771]]]} | Open Access 1 | 6795 | Heritage Park | 19851 | 1162 | La Verne, City of 305 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | Los Angeles 6 | 1.913 | Heritage Park | 0 | Local Park 2 | 4 | |
1163 | 1163 | 1162 | {"type": "Polygon", "coordinates": [[[-117.75741, 34.14445], [-117.7574, 34.14464], [-117.75731, 34.14506], [-117.75717, 34.14548], [-117.757, 34.14585], [-117.75591, 34.14577], [-117.75601, 34.14505], [-117.75606, 34.14491], [-117.75609, 34.14486], [-117.75624, 34.1447], [-117.75669, 34.1444], [-117.75681, 34.14431], [-117.75691, 34.14417], [-117.75698, 34.14402], [-117.75701, 34.144], [-117.75718, 34.14399], [-117.75726, 34.14399], [-117.7573, 34.14401], [-117.75733, 34.14434], [-117.75741, 34.14445]]]} | Open Access 1 | 6790 | Lowell Brandt Park | 21555 | 1162 | La Verne, City of 305 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | Los Angeles 6 | 4.621 | Lowell Brandt Park | 0 | Local Park 2 | 4 | |
1368 | 1368 | 1367 | {"type": "Polygon", "coordinates": [[[-117.77758, 34.10939], [-117.77694, 34.11107], [-117.77576, 34.11076], [-117.7759, 34.11069], [-117.77608, 34.11008], [-117.77617, 34.11004], [-117.77641, 34.11007], [-117.77674, 34.10918], [-117.77758, 34.10939]]]} | Open Access 1 | 8240 | Pelota Park | 23573 | 1162 | La Verne, City of 305 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | Los Angeles 6 | 4.47 | Pelota Park | 0 | Local Park 2 | 4 | |
5205 | 5205 | 5204 | {"type": "Polygon", "coordinates": [[[-117.77667, 34.12738], [-117.77663, 34.12742], [-117.77636, 34.12743], [-117.77637, 34.12718], [-117.77666, 34.12718], [-117.77667, 34.12738]]]} | Open Access 1 | 12355 | La Verne City Parkland | 20812 | 1162 | La Verne, City of 305 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | Los Angeles 6 | 0.181 | La Verne City Parkland | 0 | Local Park 2 | 4 | |
5752 | 5752 | 5751 | {"type": "Polygon", "coordinates": [[[-117.76564, 34.10458], [-117.76537, 34.10527], [-117.76555, 34.10565], [-117.76522, 34.10581], [-117.76485, 34.10603], [-117.76445, 34.10633], [-117.7641, 34.10667], [-117.76389, 34.10693], [-117.76366, 34.10726], [-117.76353, 34.10749], [-117.76332, 34.10797], [-117.76322, 34.10815], [-117.76166, 34.10774], [-117.76181, 34.10737], [-117.7619, 34.10733], [-117.76196, 34.10725], [-117.76197, 34.10718], [-117.76194, 34.10703], [-117.76206, 34.10673], [-117.76239, 34.1068], [-117.76268, 34.10691], [-117.76282, 34.10689], [-117.76287, 34.10685], [-117.76291, 34.1068], [-117.76297, 34.10659], [-117.76339, 34.10549], [-117.76353, 34.10473], [-117.76376, 34.10414], [-117.76366, 34.10407], [-117.76376, 34.10413], [-117.76382, 34.10411], [-117.76482, 34.10439], [-117.76484, 34.10437], [-117.76564, 34.10458]]]} | Open Access 1 | 3679 | Las Flores Park | 21051 | 1162 | La Verne, City of 305 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | Los Angeles 6 | 16.361 | Las Flores Park | 0 | Local Park 2 | 4 | |
5873 | 5873 | 5872 | {"type": "Polygon", "coordinates": [[[-117.77097, 34.11987], [-117.77097, 34.1207], [-117.77094, 34.12073], [-117.76945, 34.12073], [-117.76944, 34.12045], [-117.76875, 34.12045], [-117.76875, 34.12026], [-117.7683, 34.12026], [-117.7683, 34.12021], [-117.76875, 34.12007], [-117.77033, 34.11997], [-117.77034, 34.11987], [-117.77097, 34.11987]]]} | Open Access 1 | 257 | Emerald Park | 18617 | 1162 | La Verne, City of 305 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | Los Angeles 6 | 3.885 | Emerald Park | 0 | Local Park 2 | 4 | |
6541 | 6541 | 6540 | {"type": "Polygon", "coordinates": [[[-117.77874, 34.10395], [-117.77844, 34.10473], [-117.77735, 34.10445], [-117.77765, 34.10367], [-117.77874, 34.10395]]]} | Open Access 1 | 2996 | Kuns Park | 20732 | 1162 | La Verne, City of 305 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | Los Angeles 6 | 2.356 | Kuns Park | 0 | Local Park 2 | 4 | |
6693 | 6693 | 6692 | {"type": "Polygon", "coordinates": [[[-117.77556, 34.09736], [-117.77541, 34.09778], [-117.7746, 34.09757], [-117.77484, 34.09718], [-117.77556, 34.09736]]]} | Open Access 1 | 24524 | Lordsburg Park | 21467 | 1162 | La Verne, City of 305 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | Los Angeles 6 | 0.878 | Lordsburg Park | 0 | Local Park 2 | 4 | |
7159 | 7159 | 7158 | {"type": "MultiPolygon", "coordinates": [[[[-117.77221, 34.13306], [-117.77221, 34.13324], [-117.77211, 34.13356], [-117.77199, 34.13387], [-117.77147, 34.13453], [-117.77144, 34.13453], [-117.77106, 34.13558], [-117.77083, 34.13559], [-117.77075, 34.13557], [-117.77064, 34.13557], [-117.7707, 34.13539], [-117.77056, 34.13527], [-117.77048, 34.13527], [-117.77044, 34.13515], [-117.77044, 34.13508], [-117.77048, 34.13506], [-117.77053, 34.13491], [-117.77062, 34.13487], [-117.77066, 34.13483], [-117.77072, 34.13462], [-117.77075, 34.13458], [-117.77078, 34.13457], [-117.77081, 34.13449], [-117.77074, 34.1344], [-117.77074, 34.13433], [-117.77078, 34.13433], [-117.77081, 34.13424], [-117.77087, 34.13416], [-117.77087, 34.13376], [-117.77093, 34.13359], [-117.77095, 34.13359], [-117.771, 34.13348], [-117.77105, 34.13345], [-117.77107, 34.13328], [-117.77104, 34.13309], [-117.7711, 34.13311], [-117.77112, 34.13322], [-117.77112, 34.13338], [-117.7711, 34.13349], [-117.77104, 34.13363], [-117.77104, 34.13371], [-117.77099, 34.13373], [-117.771, 34.13414], [-117.77115, 34.13422], [-117.77152, 34.13381], [-117.77164, 34.13364], [-117.77173, 34.13324], [-117.77173, 34.13311], [-117.7713, 34.13309], [-117.77134, 34.13306], [-117.77221, 34.13306]]], [[[-117.77094, 34.13575], [-117.77088, 34.13603], [-117.77047, 34.13603], [-117.77055, 34.13594], [-117.77059, 34.13583], [-117.7706, 34.13579], [-117.77055, 34.13577], [-117.77057, 34.13573], [-117.77094, 34.13575]]], [[[-117.77532, 34.12952], [-117.7753, 34.12981], [-117.77523, 34.13014], [-117.7752, 34.13035], [-117.77512, 34.1306], [-117.77506, 34.13074], [-117.77496, 34.13091], [-117.77482, 34.1311], [-117.77468, 34.13124], [-117.7744, 34.13145], [-117.77412, 34.1316], [-117.77371, 34.13174], [-117.77341, 34.1318], [-117.77291, 34.13194], [-117.77277, 34.13205], [-117.77272, 34.13214], [-117.77258, 34.13247], [-117.77255, 34.13267], [-117.77249, 34.1329], [-117.77194, 34.13289], [-117.77195, 34.13261], [-117.77202, 34.1325], [-117.77206, 34.13233], [-117.77223, 34.13201], [-117.77235, 34.13184], [-117.7725, 34.13168], [-117.77294, 34.13157], [-117.77298, 34.13159], [-117.77317, 34.13155], [-117.77318, 34.13157], [-117.77341, 34.13152], [-117.77359, 34.13141], [-117.77381, 34.13135], [-117.77401, 34.13126], [-117.77404, 34.13127], [-117.77423, 34.13116], [-117.7744, 34.13103], [-117.77454, 34.13088], [-117.77466, 34.13073], [-117.77482, 34.1304], [-117.77487, 34.13007], [-117.77495, 34.12977], [-117.77497, 34.12944], [-117.77516, 34.12946], [-117.77532, 34.12952]]]]} | Open Access 1 | 6800 | Marshall Creek Open Space | 21896 | 1162 | La Verne, City of 305 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | Los Angeles 6 | 9.299 | Marshall Creek OS | 0 | Local Recreation Area 3 | 4 | |
7388 | 7388 | 7387 | {"type": "Polygon", "coordinates": [[[-117.75909, 34.1581], [-117.75908, 34.16531], [-117.75748, 34.16533], [-117.75596, 34.16545], [-117.75594, 34.16535], [-117.75473, 34.16537], [-117.75472, 34.15966], [-117.75471, 34.15814], [-117.75037, 34.15817], [-117.75035, 34.15442], [-117.75571, 34.15438], [-117.75572, 34.15436], [-117.75561, 34.15427], [-117.75564, 34.15412], [-117.75647, 34.15315], [-117.75679, 34.15328], [-117.75681, 34.15356], [-117.75691, 34.1536], [-117.75676, 34.1538], [-117.75638, 34.15414], [-117.75579, 34.15436], [-117.75579, 34.15437], [-117.75666, 34.15437], [-117.75655, 34.15453], [-117.75656, 34.15454], [-117.75764, 34.15453], [-117.75765, 34.15424], [-117.75834, 34.15382], [-117.75839, 34.15359], [-117.75843, 34.15356], [-117.75842, 34.15808], [-117.75909, 34.1581]]]} | Open Access 1 | 6794 | West Marshall Canyon Wilderness Area | 27368 | 1162 | La Verne, City of 305 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | Los Angeles 6 | 158.532 | West Marshall Canyon Wilderness Area | 0 | Local Conservation Area 4 | 2 | |
7389 | 7389 | 7388 | {"type": "Polygon", "coordinates": [[[-117.77663, 34.12982], [-117.77661, 34.13156], [-117.77577, 34.13149], [-117.77575, 34.13155], [-117.77514, 34.13155], [-117.77513, 34.13183], [-117.77507, 34.13184], [-117.77506, 34.13155], [-117.77469, 34.13155], [-117.77463, 34.13149], [-117.77468, 34.13124], [-117.77482, 34.1311], [-117.77496, 34.13091], [-117.77506, 34.13074], [-117.77512, 34.1306], [-117.7752, 34.13035], [-117.77523, 34.13014], [-117.7753, 34.12981], [-117.77531, 34.12968], [-117.77561, 34.12968], [-117.77569, 34.12972], [-117.77577, 34.12968], [-117.77609, 34.12968], [-117.77609, 34.12973], [-117.77612, 34.12977], [-117.77622, 34.12983], [-117.77663, 34.12982]]]} | Open Access 1 | 6796 | Oak Mesa Park | 22990 | 1162 | La Verne, City of 305 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | Los Angeles 6 | 7.303 | Oak Mesa Park | 0 | Local Park 2 | 4 | |
7390 | 7390 | 7389 | {"type": "MultiPolygon", "coordinates": [[[[-117.77664, 34.13318], [-117.77664, 34.13397], [-117.7766, 34.13415], [-117.77645, 34.13435], [-117.77616, 34.1346], [-117.77608, 34.13462], [-117.7746, 34.13464], [-117.77456, 34.13464], [-117.77452, 34.13462], [-117.77451, 34.13455], [-117.77453, 34.13453], [-117.77554, 34.13383], [-117.7758, 34.13363], [-117.77612, 34.13331], [-117.7764, 34.13294], [-117.77646, 34.13293], [-117.77651, 34.13296], [-117.77658, 34.13303], [-117.77664, 34.13318]]], [[[-117.77667, 34.13286], [-117.77653, 34.13275], [-117.77653, 34.13273], [-117.77653, 34.1327], [-117.77665, 34.13247], [-117.77667, 34.13246], [-117.77667, 34.13286]]]]} | Open Access 1 | 6797 | Mills Park | 22255 | 1162 | La Verne, City of 305 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | Los Angeles 6 | 4.5 | Mills Park | 0 | Local Park 2 | 4 | |
7810 | 7810 | 7809 | {"type": "MultiPolygon", "coordinates": [[[[-117.77369, 34.12726], [-117.77367, 34.12728], [-117.77347, 34.12734], [-117.77322, 34.12745], [-117.773, 34.1272], [-117.77251, 34.1272], [-117.77248, 34.12707], [-117.77305, 34.12703], [-117.7732, 34.12723], [-117.77361, 34.12702], [-117.77363, 34.12665], [-117.77367, 34.12665], [-117.77369, 34.12667], [-117.77368, 34.12713], [-117.77369, 34.12726]]], [[[-117.77428, 34.12546], [-117.77397, 34.12581], [-117.77386, 34.12598], [-117.77375, 34.12621], [-117.7737, 34.12646], [-117.77367, 34.12648], [-117.77359, 34.12648], [-117.7737, 34.12599], [-117.77425, 34.12543], [-117.77428, 34.12546]]], [[[-117.77484, 34.12724], [-117.77482, 34.12733], [-117.7743, 34.12725], [-117.77391, 34.12723], [-117.77389, 34.12722], [-117.77388, 34.12711], [-117.77388, 34.12654], [-117.7739, 34.12639], [-117.77398, 34.12616], [-117.77406, 34.12601], [-117.77412, 34.12594], [-117.77417, 34.12595], [-117.77403, 34.12618], [-117.77399, 34.1263], [-117.77395, 34.12649], [-117.77394, 34.12712], [-117.7743, 34.12716], [-117.77435, 34.12711], [-117.77443, 34.12713], [-117.77448, 34.12712], [-117.77451, 34.12719], [-117.77484, 34.12724]]], [[[-117.77449, 34.12559], [-117.77428, 34.12582], [-117.77426, 34.1258], [-117.77426, 34.12577], [-117.77444, 34.12555], [-117.77449, 34.12559]]], [[[-117.7754, 34.12406], [-117.77538, 34.12419], [-117.77534, 34.12431], [-117.77524, 34.12448], [-117.77437, 34.12536], [-117.77434, 34.12534], [-117.77516, 34.12448], [-117.77527, 34.12429], [-117.77528, 34.12389], [-117.77516, 34.12352], [-117.77493, 34.12321], [-117.77498, 34.12321], [-117.775, 34.12322], [-117.77529, 34.1236], [-117.77537, 34.12381], [-117.7754, 34.12393], [-117.7754, 34.12406]]], [[[-117.77478, 34.12529], [-117.77458, 34.12551], [-117.77452, 34.12547], [-117.77471, 34.12528], [-117.77476, 34.12527], [-117.77478, 34.12529]]], [[[-117.77532, 34.12473], [-117.77491, 34.12516], [-117.77489, 34.12515], [-117.77488, 34.12514], [-117.77489, 34.1251], [-117.77525, 34.12473], [-117.77532, 34.12473]]], [[[-117.77526, 34.12327], [-117.77505, 34.12299], [-117.77499, 34.12287], [-117.77495, 34.12275], [-117.77495, 34.12262], [-117.77496, 34.12261], [-117.77521, 34.1226], [-117.77522, 34.12288], [-117.77526, 34.12327]]]]} | Open Access 1 | 12351 | La Verne City Parkland | 20812 | 1162 | La Verne, City of 305 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | Los Angeles 6 | 2.29 | La Verne City Parkland | 0 | Local Park 2 | 4 | |
8173 | 8173 | 8172 | {"type": "MultiPolygon", "coordinates": [[[[-117.76903, 34.12806], [-117.76903, 34.12806], [-117.76892, 34.12799], [-117.769, 34.128], [-117.76903, 34.12802], [-117.76903, 34.12806]]], [[[-117.76151, 34.12897], [-117.76099, 34.12943], [-117.75945, 34.13104], [-117.75932, 34.13121], [-117.75922, 34.13139], [-117.75928, 34.12899], [-117.76151, 34.12897]]], [[[-117.75921, 34.13235], [-117.75921, 34.13246], [-117.7592, 34.13261], [-117.75911, 34.13257], [-117.75911, 34.13253], [-117.75921, 34.13235]]], [[[-117.77084, 34.13055], [-117.77078, 34.13063], [-117.77021, 34.1311], [-117.77015, 34.13125], [-117.7704, 34.13154], [-117.77036, 34.13184], [-117.77015, 34.13206], [-117.76997, 34.13209], [-117.76986, 34.13221], [-117.76983, 34.13237], [-117.76987, 34.1324], [-117.76995, 34.13231], [-117.76994, 34.13224], [-117.77028, 34.13207], [-117.77064, 34.13182], [-117.77057, 34.13202], [-117.77044, 34.1325], [-117.77053, 34.13263], [-117.77031, 34.13279], [-117.77064, 34.1331], [-117.77059, 34.13314], [-117.77019, 34.13286], [-117.77002, 34.13303], [-117.7698, 34.13347], [-117.76973, 34.13393], [-117.76969, 34.134], [-117.76946, 34.13414], [-117.76928, 34.13413], [-117.76903, 34.13403], [-117.76861, 34.13402], [-117.76848, 34.13429], [-117.7684, 34.13423], [-117.76841, 34.1342], [-117.76827, 34.13411], [-117.76812, 34.13412], [-117.768, 34.1342], [-117.76796, 34.13427], [-117.76794, 34.13433], [-117.76815, 34.13445], [-117.76798, 34.13449], [-117.76811, 34.13513], [-117.76808, 34.13515], [-117.76794, 34.13527], [-117.76825, 34.13554], [-117.76831, 34.1355], [-117.76842, 34.13563], [-117.76842, 34.13566], [-117.76822, 34.13582], [-117.76805, 34.13604], [-117.76804, 34.13604], [-117.76827, 34.13565], [-117.76819, 34.13559], [-117.76799, 34.13551], [-117.76783, 34.13542], [-117.76776, 34.13533], [-117.76769, 34.13519], [-117.7673, 34.13541], [-117.76732, 34.13561], [-117.76656, 34.13604], [-117.76229, 34.13605], [-117.7625, 34.13589], [-117.76276, 34.13564], [-117.76285, 34.13553], [-117.76301, 34.13526], [-117.76313, 34.1349], [-117.76319, 34.13457], [-117.76326, 34.1344], [-117.76326, 34.13434], [-117.76322, 34.13427], [-117.76378, 34.13363], [-117.76368, 34.13318], [-117.76313, 34.13321], [-117.76289, 34.13326], [-117.76265, 34.13336], [-117.76248, 34.13349], [-117.76244, 34.13355], [-117.76204, 34.13339], [-117.76192, 34.13361], [-117.76161, 34.13363], [-117.76159, 34.13401], [-117.76141, 34.13393], [-117.76118, 34.13379], [-117.76112, 34.13373], [-117.76116, 34.13368], [-117.76107, 34.13359], [-117.76101, 34.13364], [-117.76083, 34.1335], [-117.76062, 34.13339], [-117.76082, 34.13308], [-117.7606, 34.13296], [-117.76047, 34.13282], [-117.76038, 34.13266], [-117.76067, 34.13222], [-117.7608, 34.13215], [-117.76137, 34.13222], [-117.76152, 34.13233], [-117.76165, 34.13255], [-117.76199, 34.13245], [-117.7621, 34.1325], [-117.76221, 34.1325], [-117.76243, 34.13244], [-117.76256, 34.13243], [-117.76267, 34.1324], [-117.76284, 34.13233], [-117.76297, 34.13223], [-117.76415, 34.13109], [-117.76424, 34.13099], [-117.7643, 34.13087], [-117.76433, 34.13075], [-117.76433, 34.13064], [-117.76422, 34.13005], [-117.76423, 34.12986], [-117.76419, 34.1298], [-117.76414, 34.12976], [-117.76411, 34.12964], [-117.76396, 34.12966], [-117.76397, 34.12973], [-117.76396, 34.12974], [-117.7638, 34.12979], [-117.76356, 34.12983], [-117.76339, 34.12989], [-117.7632, 34.12998], [-117.76302, 34.13011], [-117.76287, 34.13023], [-117.76275, 34.13036], [-117.7624, 34.13084], [-117.76227, 34.131], [-117.76209, 34.13115], [-117.76183, 34.13131], [-117.76171, 34.13141], [-117.76151, 34.13168], [-117.76145, 34.13169], [-117.76091, 34.13158], [-117.76071, 34.13158], [-117.76056, 34.13161], [-117.76041, 34.13166], [-117.76029, 34.13172], [-117.76005, 34.13189], [-117.75989, 34.13209], [-117.75981, 34.13225], [-117.75979, 34.13225], [-117.75978, 34.13228], [-117.75974, 34.1323], [-117.75951, 34.13229], [-117.75925, 34.13222], [-117.75931, 34.13194], [-117.75931, 34.13168], [-117.75933, 34.13157], [-117.75941, 34.13138], [-117.75957, 34.13114], [-117.76101, 34.12964], [-117.76173, 34.12897], [-117.76378, 34.12896], [-117.764, 34.12882], [-117.7643, 34.12873], [-117.76446, 34.1287], [-117.76446, 34.12877], [-117.76506, 34.12878], [-117.76584, 34.1284], [-117.7659, 34.12862], [-117.76584, 34.12868], [-117.76589, 34.12875], [-117.76589, 34.12895], [-117.76813, 34.12895], [-117.76814, 34.12839], [-117.76839, 34.12859], [-117.76839, 34.12891], [-117.76865, 34.12901], [-117.76892, 34.12848], [-117.76896, 34.12821], [-117.76903, 34.12814], [-117.76902, 34.12825], [-117.76912, 34.12865], [-117.76912, 34.12881], [-117.76908, 34.12899], [-117.76904, 34.12909], [-117.76888, 34.12934], [-117.76881, 34.12957], [-117.76882, 34.12981], [-117.76887, 34.13021], [-117.76887, 34.13031], [-117.76887, 34.13073], [-117.76882, 34.13088], [-117.76875, 34.13101], [-117.76861, 34.13114], [-117.76845, 34.13122], [-117.76805, 34.13137], [-117.76791, 34.13146], [-117.76778, 34.13157], [-117.76769, 34.13167], [-117.76729, 34.13234], [-117.76718, 34.13244], [-117.76718, 34.13247], [-117.7673, 34.13257], [-117.76741, 34.13248], [-117.76742, 34.13246], [-117.76746, 34.13243], [-117.76787, 34.13175], [-117.76802, 34.13159], [-117.76822, 34.13147], [-117.76853, 34.13137], [-117.76874, 34.13126], [-117.7689, 34.13112], [-117.76901, 34.13094], [-117.76906, 34.13076], [-117.76907, 34.13029], [-117.76907, 34.13017], [-117.76901, 34.12978], [-117.76901, 34.12961], [-117.76906, 34.1294], [-117.76925, 34.12908], [-117.76932, 34.12884], [-117.7693, 34.12855], [-117.76922, 34.1283], [-117.76922, 34.12802], [-117.76924, 34.128], [-117.7697, 34.12801], [-117.76961, 34.12819], [-117.76962, 34.1285], [-117.76951, 34.12887], [-117.77007, 34.12907], [-117.77021, 34.12953], [-117.77004, 34.12983], [-117.7706, 34.1299], [-117.77036, 34.13026], [-117.77084, 34.13055]]], [[[-117.76187, 34.13627], [-117.76161, 34.13663], [-117.75762, 34.13664], [-117.75763, 34.1363], [-117.76187, 34.13627]]], [[[-117.7565, 34.14037], [-117.75643, 34.14041], [-117.75622, 34.14045], [-117.75596, 34.1409], [-117.75563, 34.14097], [-117.75586, 34.14085], [-117.75608, 34.14045], [-117.75626, 34.14035], [-117.75646, 34.14037], [-117.7565, 34.14037]]], [[[-117.76507, 34.13626], [-117.76482, 34.13647], [-117.76479, 34.13686], [-117.76469, 34.13702], [-117.76401, 34.13709], [-117.7642, 34.13739], [-117.76402, 34.13778], [-117.76405, 34.13787], [-117.76391, 34.13794], [-117.76361, 34.138], [-117.76357, 34.13805], [-117.76357, 34.13809], [-117.76355, 34.13814], [-117.7633, 34.13815], [-117.7632, 34.13818], [-117.76267, 34.1382], [-117.76248, 34.13812], [-117.76229, 34.1381], [-117.76212, 34.13815], [-117.76195, 34.13836], [-117.76162, 34.13839], [-117.76124, 34.13851], [-117.76113, 34.13864], [-117.76076, 34.1388], [-117.76061, 34.13891], [-117.76051, 34.13886], [-117.76022, 34.13894], [-117.76011, 34.13898], [-117.75993, 34.13919], [-117.75972, 34.13928], [-117.75931, 34.13943], [-117.75926, 34.13942], [-117.75911, 34.13921], [-117.75905, 34.1392], [-117.75879, 34.13923], [-117.75861, 34.13923], [-117.75846, 34.13942], [-117.75822, 34.1395], [-117.75792, 34.13962], [-117.7578, 34.13983], [-117.75761, 34.13993], [-117.75746, 34.13988], [-117.75722, 34.13995], [-117.75697, 34.14015], [-117.75693, 34.14021], [-117.75667, 34.14026], [-117.75657, 34.14032], [-117.75646, 34.14034], [-117.75625, 34.14031], [-117.75605, 34.14042], [-117.75582, 34.14082], [-117.75557, 34.14097], [-117.75533, 34.141], [-117.75519, 34.14108], [-117.7552, 34.14145], [-117.75482, 34.14172], [-117.75455, 34.14169], [-117.75414, 34.14145], [-117.75399, 34.14149], [-117.75374, 34.1417], [-117.75364, 34.14167], [-117.7534, 34.14153], [-117.75312, 34.14169], [-117.75306, 34.14186], [-117.75298, 34.14197], [-117.7528, 34.14212], [-117.7528, 34.14243], [-117.75203, 34.14274], [-117.75194, 34.14258], [-117.75174, 34.14257], [-117.75168, 34.14241], [-117.75166, 34.14227], [-117.75167, 34.14196], [-117.75172, 34.14176], [-117.75183, 34.14155], [-117.75194, 34.14139], [-117.752, 34.14133], [-117.75207, 34.14133], [-117.75216, 34.14156], [-117.75263, 34.14152], [-117.75356, 34.14117], [-117.75404, 34.14108], [-117.75425, 34.14108], [-117.75421, 34.14094], [-117.7543, 34.1407], [-117.75468, 34.14058], [-117.75457, 34.14025], [-117.75443, 34.14011], [-117.75473, 34.13991], [-117.75495, 34.14012], [-117.75539, 34.14016], [-117.75556, 34.13994], [-117.75598, 34.13973], [-117.7561, 34.13962], [-117.75616, 34.13952], [-117.75616, 34.13944], [-117.75613, 34.13937], [-117.75612, 34.13929], [-117.75615, 34.13924], [-117.7562, 34.13919], [-117.75623, 34.13911], [-117.75665, 34.13923], [-117.75756, 34.13846], [-117.75755, 34.13859], [-117.75775, 34.13883], [-117.75781, 34.13886], [-117.75788, 34.13886], [-117.75818, 34.13876], [-117.75871, 34.13873], [-117.75887, 34.13866], [-117.75899, 34.13857], [-117.75903, 34.1385], [-117.75907, 34.13843], [-117.75908, 34.13835], [-117.7591, 34.13833], [-117.7594, 34.13831], [-117.75963, 34.13826], [-117.76049, 34.13794], [-117.76064, 34.13787], [-117.76097, 34.13766], [-117.76115, 34.13749], [-117.76207, 34.13627], [-117.76507, 34.13626]]], [[[-117.75158, 34.14145], [-117.75158, 34.14149], [-117.7515, 34.14161], [-117.75144, 34.14178], [-117.7514, 34.14199], [-117.75139, 34.1422], [-117.7514, 34.14233], [-117.75146, 34.14253], [-117.75097, 34.14262], [-117.7508, 34.14274], [-117.75064, 34.14274], [-117.75042, 34.14294], [-117.75037, 34.14309], [-117.75014, 34.14318], [-117.75017, 34.14241], [-117.75053, 34.14226], [-117.75097, 34.14203], [-117.75119, 34.14182], [-117.75127, 34.14161], [-117.75103, 34.14132], [-117.7511, 34.14134], [-117.75133, 34.14133], [-117.75158, 34.14145]]]]} | Open Access 1 | 12353 | Marshall Canyon Conservation Corridor | 21893 | 1162 | La Verne, City of 305 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | Los Angeles 6 | 184.336 | Marshall Canyon Conservation Corridor | 0 | Local Conservation Area 4 | 2 | |
9209 | 9209 | 9208 | {"type": "Polygon", "coordinates": [[[-117.78269, 34.10193], [-117.78236, 34.10283], [-117.78061, 34.10237], [-117.78085, 34.10175], [-117.78093, 34.10177], [-117.78103, 34.10161], [-117.78117, 34.10144], [-117.78132, 34.1013], [-117.78146, 34.1012], [-117.78172, 34.10106], [-117.78201, 34.10096], [-117.78223, 34.10094], [-117.78249, 34.10096], [-117.78218, 34.1018], [-117.78269, 34.10193]]]} | Open Access 1 | 15327 | Wheeler Avenue Park | 27452 | 1162 | La Verne, City of 305 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | Los Angeles 6 | 6.013 | Wheeler Avenue Park | 0 | Local Park 2 | 4 | |
9646 | 9646 | 9645 | {"type": "Polygon", "coordinates": [[[-117.77975, 34.10358], [-117.77961, 34.10395], [-117.77908, 34.1038], [-117.77922, 34.10344], [-117.77975, 34.10358]]]} | Open Access 1 | 47853 | Veterans Hall | 31799 | 1162 | La Verne, City of 305 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | Los Angeles 6 | 0.538 | Veterans Hall | None 822 | |||
11887 | 11887 | 11886 | {"type": "Polygon", "coordinates": [[[-117.76279, 34.10082], [-117.76263, 34.10122], [-117.76269, 34.10125], [-117.76255, 34.10162], [-117.76192, 34.10145], [-117.76222, 34.10067], [-117.76279, 34.10082]]]} | Open Access 1 | 24488 | Lincoln Mini Park | 21258 | 1162 | La Verne, City of 305 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | Los Angeles 6 | 1.305 | Lincoln MP | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);