superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
24 rows where MNG_AGENCY = 301 sorted by map descending
This data as json, copyable, CSV (advanced)
Suggested facets: PARK_NAME, LABEL_NAME
Link | rowid | id | map ▲ | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5359 | 5359 | 5358 | {"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 | Los Encinos Park | 21514 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 6.904 | Los Encinos Park | ||
11175 | 11175 | 11174 | {"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.78219, 34.10179], [-117.78269, 34.10193]]]} | Open Access 1 | Wheeler Avenue Park | 27452 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 6.018 | Wheeler Avenue Park | ||
14362 | 14362 | 14361 | {"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 | Veterans Hall | 31799 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 0.538 | Veterans Hall | ||
5789 | 5789 | 5788 | {"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 | Kuns Park | 20732 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 2.356 | Kuns Park | ||
8074 | 8074 | 8073 | {"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 | Pelota Park | 23573 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 4.472 | Pelota Park | ||
5062 | 5062 | 5061 | {"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.77518, 34.12847], [-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 | Heritage Park | 19851 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 1.914 | Heritage Park | ||
7572 | 7572 | 7571 | {"type": "Polygon", "coordinates": [[[-117.77663, 34.12982], [-117.77661, 34.13156], [-117.77578, 34.13149], [-117.77575, 34.13155], [-117.77515, 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.77483, 34.1311], [-117.77496, 34.13091], [-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 | Oak Mesa Park | 22990 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 7.313 | Oak Mesa Park | ||
2299 | 2299 | 2298 | {"type": "Polygon", "coordinates": [[[-117.7766, 34.09621], [-117.77634, 34.09639], [-117.77597, 34.09584], [-117.77594, 34.09567], [-117.77616, 34.09564], [-117.77623, 34.09566], [-117.7766, 34.09621]]]} | Open Access 1 | Challenger Park | 17117 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 0.595 | Challenger Park | ||
6375 | 6375 | 6374 | {"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 | Lordsburg Park | 21467 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 0.877 | Lordsburg Park | ||
3982 | 3982 | 3981 | {"type": "Polygon", "coordinates": [[[-117.77097, 34.11987], [-117.77097, 34.1207], [-117.77094, 34.12073], [-117.76945, 34.12073], [-117.76943, 34.12045], [-117.76875, 34.12045], [-117.76874, 34.12026], [-117.7683, 34.12026], [-117.7683, 34.12021], [-117.76875, 34.12006], [-117.77032, 34.11997], [-117.77034, 34.11987], [-117.77097, 34.11987]]]} | Open Access 1 | Emerald Park | 18617 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 3.89 | Emerald Park | ||
5846 | 5846 | 5845 | {"type": "Polygon", "coordinates": [[[-117.76876, 34.14961], [-117.7682, 34.14963], [-117.76817, 34.14987], [-117.76775, 34.14988], [-117.76775, 34.1492], [-117.76818, 34.14946], [-117.76819, 34.14957], [-117.76875, 34.14956], [-117.76876, 34.14961]]]} | No Public Access 3 | La Verne City Parkland | 20811 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 0.674 | La Verne City Parkland | ||
14156 | 14156 | 14155 | {"type": "Polygon", "coordinates": [[[-117.76612, 34.10899], [-117.7652, 34.11126], [-117.76228, 34.1103], [-117.76223, 34.11016], [-117.76212, 34.10995], [-117.76202, 34.1098], [-117.7623, 34.10965], [-117.76255, 34.10947], [-117.76279, 34.10925], [-117.76296, 34.10904], [-117.76318, 34.10868], [-117.7637, 34.10752], [-117.76409, 34.10765], [-117.76407, 34.10773], [-117.76441, 34.10784], [-117.7646, 34.10793], [-117.76462, 34.10793], [-117.76466, 34.10782], [-117.76493, 34.10789], [-117.76612, 34.10899]]]} | Restricted Access 2 | La Verne Sports Park | 31619 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 22.089 | La Verne Sports Park | ||
6018 | 6018 | 6017 | {"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.76375, 34.10414], [-117.76366, 34.10407], [-117.76376, 34.10412], [-117.76382, 34.10411], [-117.76481, 34.10439], [-117.76484, 34.10437], [-117.76564, 34.10458]]]} | Open Access 1 | Las Flores Park | 21051 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 16.364 | Las Flores Park | ||
4635 | 4635 | 4634 | {"type": "Polygon", "coordinates": [[[-117.76393, 34.14161], [-117.76342, 34.1421], [-117.76331, 34.14232], [-117.76331, 34.14244], [-117.76337, 34.14267], [-117.76337, 34.14304], [-117.76345, 34.1432], [-117.76345, 34.14348], [-117.76025, 34.14346], [-117.75907, 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 | Golden Hills Wilderness Park | 19365 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 9.527 | Golden Hills Wilderness Park | ||
9079 | 9079 | 9078 | {"type": "Polygon", "coordinates": [[[-117.76319, 34.14696], [-117.76318, 34.14723], [-117.76298, 34.14736], [-117.76281, 34.14753], [-117.76245, 34.14732], [-117.76267, 34.14708], [-117.76274, 34.14697], [-117.76278, 34.14687], [-117.76319, 34.14696]]]} | Open Access 1 | Rustic Canyon Park | 24749 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 0.708 | Rustic Canyon Park | ||
6190 | 6190 | 6189 | {"type": "Polygon", "coordinates": [[[-117.76279, 34.10082], [-117.76264, 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 | Lincoln Mini Park | 21258 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 1.305 | Lincoln MP | ||
11100 | 11100 | 11099 | {"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.15815], [-117.75037, 34.15817], [-117.75035, 34.15442], [-117.75571, 34.15438], [-117.75571, 34.15436], [-117.75561, 34.15427], [-117.75564, 34.15412], [-117.75647, 34.15315], [-117.75679, 34.15328], [-117.75682, 34.15356], [-117.75691, 34.1536], [-117.75676, 34.1538], [-117.75638, 34.15414], [-117.7558, 34.15435], [-117.7558, 34.15437], [-117.75666, 34.15437], [-117.75656, 34.15452], [-117.75657, 34.15454], [-117.75763, 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 | West Marshall Canyon Wilderness Area | 27368 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 158.583 | West Marshall Canyon Wilderness Area | ||
5400 | 5400 | 5399 | {"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.75605, 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 | Lowell Brandt Park | 21555 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 4.621 | Lowell Brandt Park | ||
6301 | 6301 | 6300 | {"type": "Polygon", "coordinates": [[[-117.75671, 34.13628], [-117.75559, 34.13883], [-117.75547, 34.13901], [-117.75533, 34.13918], [-117.75515, 34.13932], [-117.75367, 34.14035], [-117.75356, 34.14041], [-117.75326, 34.14053], [-117.75216, 34.14084], [-117.75214, 34.14092], [-117.75193, 34.14107], [-117.75169, 34.1413], [-117.75165, 34.14129], [-117.75133, 34.14113], [-117.75127, 34.14107], [-117.75121, 34.14102], [-117.7511, 34.141], [-117.7511, 34.14067], [-117.75024, 34.14008], [-117.75023, 34.13986], [-117.74992, 34.13986], [-117.74843, 34.13883], [-117.74818, 34.13785], [-117.7485, 34.13662], [-117.75064, 34.13454], [-117.75064, 34.13451], [-117.75208, 34.13314], [-117.75433, 34.13264], [-117.75616, 34.13503], [-117.75671, 34.13628]]]} | No Public Access 3 | Live Oak Reservoir | 21375 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 117.758 | Live Oak Reservoir | ||
14888 | 14888 | 14887 | {"type": "Polygon", "coordinates": [[[-117.75625, 34.14581], [-117.75608, 34.14612], [-117.75606, 34.1465], [-117.7559, 34.14671], [-117.75581, 34.14696], [-117.75576, 34.14718], [-117.75548, 34.14746], [-117.75534, 34.14782], [-117.75531, 34.14803], [-117.75533, 34.14808], [-117.7552, 34.1482], [-117.75524, 34.1484], [-117.75505, 34.14856], [-117.75487, 34.14858], [-117.75472, 34.14875], [-117.75482, 34.14892], [-117.75469, 34.1491], [-117.75476, 34.1493], [-117.75475, 34.14939], [-117.75466, 34.1496], [-117.75471, 34.14968], [-117.75464, 34.14969], [-117.75458, 34.14974], [-117.75457, 34.14982], [-117.75459, 34.14985], [-117.75438, 34.14997], [-117.75442, 34.15017], [-117.75466, 34.1503], [-117.75451, 34.15059], [-117.75447, 34.15064], [-117.75451, 34.15091], [-117.75458, 34.15112], [-117.75445, 34.15137], [-117.75433, 34.15133], [-117.75407, 34.15118], [-117.75396, 34.1511], [-117.75385, 34.15099], [-117.75392, 34.15094], [-117.75395, 34.15081], [-117.75387, 34.15066], [-117.75382, 34.1506], [-117.75382, 34.15048], [-117.75377, 34.15044], [-117.75373, 34.15045], [-117.75362, 34.15056], [-117.7536, 34.15065], [-117.75346, 34.1507], [-117.75345, 34.15073], [-117.75327, 34.1507], [-117.75307, 34.15074], [-117.75289, 34.15083], [-117.75266, 34.15101], [-117.7525, 34.15106], [-117.75235, 34.15105], [-117.75196, 34.15096], [-117.75076, 34.15095], [-117.75079, 34.15093], [-117.75273, 34.15092], [-117.75483, 34.1482], [-117.75553, 34.14714], [-117.75565, 34.14638], [-117.75574, 34.14624], [-117.75582, 34.14609], [-117.75587, 34.14597], [-117.75591, 34.14577], [-117.75625, 34.14581]]]} | Open Access 1 | Lowell Brandt Open Space | 21554 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 8.287 | Lowell Brandt OS |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);