units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17 rows where AGNCY_LEV = 2, DES_TP = 2 and MNG_AGENCY = 301
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 17
MNG_AGENCY 1
- La Verne, City of · 17 ✖
DES_TP 1
- Local Park · 17 ✖
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 | |
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 | |
1411 | 1411 | 1410 | {"type": "Polygon", "coordinates": [[[-117.76876, 34.14961], [-117.76819, 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 | 12352 | La Verne City Parkland | 20811 | 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.671 | La Verne City Parkland | 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 | |
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 | |
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 | |
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 | |
12121 | 12121 | 12120 | {"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 | 25067 | Challenger Park | 17117 | 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.596 | Challenger Park | 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]);