superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
26 rows where MNG_AGENCY = 143 sorted by map descending
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12399 | 12399 | 12398 | {"type": "Polygon", "coordinates": [[[-117.92597, 34.147], [-117.92573, 34.14717], [-117.9255, 34.14736], [-117.92514, 34.14777], [-117.92517, 34.14784], [-117.92511, 34.14789], [-117.92501, 34.14781], [-117.92472, 34.14769], [-117.92525, 34.1473], [-117.92536, 34.1472], [-117.92551, 34.14714], [-117.92559, 34.14714], [-117.9257, 34.14709], [-117.92597, 34.147]]]} | Open Access 1 | Azusa Rockery | http://www.ci.azusa.ca.us/documentcenter/view/30083 | 29396 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 0.671 | Azusa Rockery | |
11497 | 11497 | 11496 | {"type": "Polygon", "coordinates": [[[-117.92179, 34.11982], [-117.92177, 34.12163], [-117.92068, 34.12164], [-117.92067, 34.12153], [-117.91871, 34.12153], [-117.91861, 34.12146], [-117.91861, 34.1209], [-117.91868, 34.12085], [-117.91899, 34.12085], [-117.91927, 34.1209], [-117.91984, 34.1209], [-117.92004, 34.12087], [-117.92028, 34.12079], [-117.92041, 34.12076], [-117.92109, 34.12076], [-117.92125, 34.12079], [-117.92137, 34.12077], [-117.92143, 34.12071], [-117.92146, 34.12063], [-117.92143, 34.12048], [-117.92143, 34.1201], [-117.92146, 34.11993], [-117.92145, 34.11987], [-117.92141, 34.11982], [-117.92179, 34.11982]]]} | Open Access 1 | Zacatecas Park | 27850 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 6.773 | Zacatecas Park | ||
7487 | 7487 | 7486 | {"type": "Polygon", "coordinates": [[[-117.91444, 34.14248], [-117.91441, 34.14341], [-117.90975, 34.14339], [-117.90975, 34.14274], [-117.91258, 34.14276], [-117.91259, 34.14206], [-117.91267, 34.14189], [-117.91298, 34.14199], [-117.91318, 34.14198], [-117.91319, 34.14095], [-117.91444, 34.14096], [-117.91442, 34.14188], [-117.91443, 34.14246], [-117.91444, 34.14248]]]} | Open Access 1 | Northside Park | 22891 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 14.475 | Northside Park | ||
6938 | 6938 | 6937 | {"type": "Polygon", "coordinates": [[[-117.91348, 34.12635], [-117.91348, 34.12749], [-117.91227, 34.12749], [-117.91226, 34.12798], [-117.91029, 34.12797], [-117.91029, 34.12633], [-117.91348, 34.12635]]]} | Open Access 1 | Memorial Park Recreation Center | 22145 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 11.719 | Memorial Park Rec. Ctr. | ||
12391 | 12391 | 12390 | {"type": "Polygon", "coordinates": [[[-117.91348, 34.12749], [-117.91348, 34.12799], [-117.91226, 34.12798], [-117.91226, 34.12749], [-117.91348, 34.12749]]]} | Open Access 1 | Memorial Park North Recreation Center (NRC) | http://www.ci.azusa.ca.us/index.aspx?NID=988 | 29353 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 1.529 | Memorial Park North Rec. Ctr. (NRC) | |
12385 | 12385 | 12384 | {"type": "Polygon", "coordinates": [[[-117.90951, 34.14686], [-117.9095, 34.1481], [-117.90942, 34.14811], [-117.90929, 34.14758], [-117.90916, 34.14691], [-117.9092, 34.14685], [-117.90928, 34.14683], [-117.90951, 34.14683], [-117.90951, 34.14686]]]} | Open Access 1 | Canyon Park | 29355 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 0.735 | Canyon Park | ||
12386 | 12386 | 12385 | {"type": "Polygon", "coordinates": [[[-117.9074, 34.13175], [-117.9074, 34.13191], [-117.90694, 34.13191], [-117.90694, 34.13175], [-117.9074, 34.13175]]]} | Open Access 1 | Edwards Park | http://www.ci.azusa.ca.us/index.aspx?nid=1230 | 29357 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 0.189 | Edwards Park | |
8179 | 8179 | 8178 | {"type": "Polygon", "coordinates": [[[-117.90512, 34.14554], [-117.9051, 34.14659], [-117.90507, 34.14664], [-117.90497, 34.14665], [-117.90332, 34.14665], [-117.90332, 34.1466], [-117.90342, 34.14629], [-117.90377, 34.14598], [-117.90382, 34.14597], [-117.90387, 34.14587], [-117.904, 34.14576], [-117.90401, 34.14566], [-117.90398, 34.14557], [-117.904, 34.14553], [-117.90512, 34.14554]]]} | Open Access 1 | Pioneer Park | 23718 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 4.093 | Pioneer Park | ||
249 | 249 | 248 | {"type": "Polygon", "coordinates": [[[-117.90331, 34.11113], [-117.90329, 34.11315], [-117.90111, 34.11315], [-117.90112, 34.11113], [-117.90331, 34.11113]]]} | Restricted Access 2 | Murray Elementary School Park | http://www.ci.azusa.ca.us/index.aspx?nid=1240 | 31893 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 11.167 | Murray Elementary School Park | |
897 | 897 | 896 | {"type": "Polygon", "coordinates": [[[-117.90259, 34.14702], [-117.90257, 34.14752], [-117.9016, 34.14798], [-117.9016, 34.14772], [-117.90149, 34.14756], [-117.90205, 34.14721], [-117.90234, 34.14708], [-117.90234, 34.14681], [-117.9024, 34.14683], [-117.90249, 34.14689], [-117.90253, 34.14694], [-117.90254, 34.14701], [-117.90259, 34.14702]]]} | Open Access 1 | Craftsman Park | 32769 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 1.454 | Craftsman Park | ||
4574 | 4574 | 4573 | {"type": "Polygon", "coordinates": [[[-117.90242, 34.11526], [-117.90241, 34.11696], [-117.90124, 34.11696], [-117.90125, 34.11535], [-117.90159, 34.11535], [-117.90207, 34.11526], [-117.90242, 34.11526]]]} | Open Access 1 | Gladstone Park | 19305 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 4.9 | Gladstone Park | ||
9732 | 9732 | 9731 | {"type": "Polygon", "coordinates": [[[-117.90234, 34.13097], [-117.90097, 34.13097], [-117.90096, 34.13044], [-117.90019, 34.13043], [-117.9002, 34.13022], [-117.90096, 34.13023], [-117.90097, 34.12991], [-117.90234, 34.12992], [-117.90234, 34.13097]]]} | Open Access 1 | Slauson Park | 25553 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 4.082 | Slauson Park | ||
12413 | 12413 | 12412 | {"type": "Polygon", "coordinates": [[[-117.90199, 34.14495], [-117.9019, 34.14501], [-117.90172, 34.14521], [-117.90151, 34.14503], [-117.90138, 34.14481], [-117.90099, 34.14377], [-117.90127, 34.14368], [-117.90127, 34.14369], [-117.90118, 34.14374], [-117.90114, 34.14383], [-117.90122, 34.14412], [-117.9012, 34.14415], [-117.9012, 34.14423], [-117.90126, 34.14431], [-117.90125, 34.14437], [-117.90127, 34.14446], [-117.90133, 34.14451], [-117.90144, 34.14454], [-117.90179, 34.14443], [-117.90182, 34.14443], [-117.90185, 34.14447], [-117.90183, 34.14453], [-117.90167, 34.14466], [-117.90154, 34.14484], [-117.90155, 34.14492], [-117.90159, 34.145], [-117.90164, 34.14503], [-117.90168, 34.14503], [-117.9019, 34.14489], [-117.90195, 34.14489], [-117.90199, 34.14495]]]} | Open Access 1 | Ridgeview Park | http://www.ci.azusa.ca.us/index.aspx?nid=1232 | 29404 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 0.678 | Ridgeview Park | |
12400 | 12400 | 12399 | {"type": "Polygon", "coordinates": [[[-117.90027, 34.14511], [-117.90027, 34.14515], [-117.90025, 34.14517], [-117.89993, 34.14529], [-117.89972, 34.14534], [-117.89967, 34.14532], [-117.89968, 34.14523], [-117.89983, 34.14464], [-117.89986, 34.14463], [-117.89993, 34.14464], [-117.90004, 34.1447], [-117.90027, 34.14511]]]} | Open Access 1 | Citrus Grove Park | http://www.ci.azusa.ca.us/index.aspx?nid=1229 | 29397 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 0.656 | Citrus Grove Park | |
10875 | 10875 | 10874 | {"type": "Polygon", "coordinates": [[[-117.90005, 34.14647], [-117.90002, 34.14658], [-117.89993, 34.14659], [-117.89981, 34.14669], [-117.89972, 34.14671], [-117.89885, 34.14671], [-117.89865, 34.14666], [-117.89864, 34.14658], [-117.89879, 34.14643], [-117.89904, 34.14612], [-117.89908, 34.1461], [-117.89968, 34.14636], [-117.90005, 34.14647]]]} | Open Access 1 | Sierra Madre Park | 29400 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 1.326 | Sierra Madre Park | ||
12414 | 12414 | 12413 | {"type": "Polygon", "coordinates": [[[-117.89744, 34.14257], [-117.89752, 34.14257], [-117.89773, 34.14263], [-117.89788, 34.14272], [-117.89798, 34.14281], [-117.89807, 34.14294], [-117.8981, 34.14303], [-117.89809, 34.14314], [-117.89806, 34.14319], [-117.89802, 34.14324], [-117.89793, 34.14329], [-117.89785, 34.14331], [-117.89767, 34.14329], [-117.89747, 34.14323], [-117.89735, 34.14315], [-117.89726, 34.14307], [-117.89716, 34.14289], [-117.89714, 34.14283], [-117.89715, 34.14275], [-117.89719, 34.14267], [-117.89726, 34.14261], [-117.89735, 34.14258], [-117.89744, 34.14257]]]} | Open Access 1 | Alisal Park | http://www.ci.azusa.ca.us/index.aspx?nid=1228 | 29407 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 1.292 | Alisal Park | |
899 | 899 | 898 | {"type": "Polygon", "coordinates": [[[-117.89715, 34.13822], [-117.89714, 34.13906], [-117.89448, 34.13905], [-117.89448, 34.13822], [-117.89453, 34.13818], [-117.89709, 34.13818], [-117.89715, 34.13822]]]} | Open Access 1 | Promenade Park | 32780 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 5.891 | Promenade Park | ||
12411 | 12411 | 12410 | {"type": "Polygon", "coordinates": [[[-117.89704, 34.14639], [-117.89704, 34.14643], [-117.89699, 34.14652], [-117.89686, 34.14663], [-117.89668, 34.1467], [-117.8965, 34.1467], [-117.89637, 34.14666], [-117.89625, 34.14659], [-117.89621, 34.14655], [-117.89618, 34.1465], [-117.89619, 34.14646], [-117.89622, 34.14644], [-117.89643, 34.14637], [-117.89669, 34.14633], [-117.89697, 34.14633], [-117.89703, 34.14636], [-117.89704, 34.14639]]]} | Open Access 1 | Oak Hill Park | 29402 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 0.593 | Oak Hill Park | ||
895 | 895 | 894 | {"type": "Polygon", "coordinates": [[[-117.89601, 34.14862], [-117.89599, 34.14889], [-117.89594, 34.14889], [-117.8959, 34.14896], [-117.89536, 34.14884], [-117.89531, 34.1488], [-117.89525, 34.14888], [-117.8951, 34.14884], [-117.89497, 34.14883], [-117.89441, 34.14862], [-117.89423, 34.14849], [-117.89399, 34.14824], [-117.89408, 34.14822], [-117.89417, 34.14823], [-117.89529, 34.14852], [-117.89578, 34.1486], [-117.89601, 34.14862]]]} | Open Access 1 | Summit Park | 32768 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 1.6 | Summit Park | ||
12389 | 12389 | 12388 | {"type": "Polygon", "coordinates": [[[-117.89454, 34.14527], [-117.89455, 34.1453], [-117.89457, 34.14571], [-117.89457, 34.14599], [-117.89449, 34.1464], [-117.89436, 34.14675], [-117.89414, 34.14703], [-117.89391, 34.14752], [-117.89374, 34.14795], [-117.8938, 34.14803], [-117.89374, 34.1481], [-117.89374, 34.14816], [-117.89378, 34.14824], [-117.89386, 34.14827], [-117.894, 34.14825], [-117.89402, 34.14828], [-117.89388, 34.14833], [-117.89384, 34.14833], [-117.89363, 34.14823], [-117.89343, 34.14859], [-117.89311, 34.14888], [-117.89263, 34.14853], [-117.89228, 34.14794], [-117.89256, 34.14761], [-117.89329, 34.14778], [-117.89341, 34.14767], [-117.8934, 34.14703], [-117.89348, 34.14695], [-117.89388, 34.14664], [-117.89395, 34.14635], [-117.89382, 34.14608], [-117.89394, 34.14582], [-117.89374, 34.14528], [-117.89418, 34.14524], [-117.89449, 34.14524], [-117.89454, 34.14527]]]} | Open Access 1 | Arroyo Park North | 29368 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 7.038 | Arroyo Park North |
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]);