superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
32 rows where MNG_AGENCY = 192 sorted by map descending
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 32
MNG_AGENCY 1
- Rancho Cucamonga, City of · 32 ✖
ACCESS_TYP 1
- Open Access 32
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14 | 14 | 13 | {"type": "Polygon", "coordinates": [[[-117.63013, 34.13844], [-117.62976, 34.1385], [-117.62975, 34.13806], [-117.62988, 34.138], [-117.63013, 34.13844]]]} | Open Access 1 | Cucamonga/Demens Creek Trail Rest | https://www.cityofrc.us/cityhall/cs/parks/trails/cucamonga.asp | 31742 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 0.299 | Cucamonga/Demens Creek Trail Rest | |
13981 | 13981 | 13980 | {"type": "Polygon", "coordinates": [[[-117.61755, 34.09674], [-117.61753, 34.09759], [-117.61599, 34.09759], [-117.61599, 34.09673], [-117.61755, 34.09674]]]} | Open Access 1 | Los Amigos Park | http://www.cityofrc.us/cityhall/cs/parkdev/whatsnew/southwest_cucamonga_pk.asp | 32565 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 3.358 | Los Amigos Park | 2017 |
11097 | 11097 | 11096 | {"type": "Polygon", "coordinates": [[[-117.61614, 34.13634], [-117.61177, 34.13636], [-117.61176, 34.13545], [-117.61313, 34.13546], [-117.6138, 34.1355], [-117.61442, 34.13556], [-117.61596, 34.13576], [-117.61607, 34.13582], [-117.61609, 34.13584], [-117.61609, 34.13605], [-117.61614, 34.13606], [-117.61614, 34.13634]]]} | Open Access 1 | West Beryl Park | 27351 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 8.74 | West Beryl Park | ||
8577 | 8577 | 8576 | {"type": "Polygon", "coordinates": [[[-117.61546, 34.11422], [-117.61514, 34.11441], [-117.61437, 34.11467], [-117.61381, 34.11603], [-117.61346, 34.11604], [-117.6135, 34.11963], [-117.6138, 34.11965], [-117.61379, 34.12045], [-117.61297, 34.12045], [-117.61295, 34.12138], [-117.61114, 34.12138], [-117.6111, 34.12137], [-117.61107, 34.12133], [-117.61109, 34.11967], [-117.61104, 34.11965], [-117.61108, 34.11449], [-117.61392, 34.11449], [-117.61484, 34.11422], [-117.61546, 34.11422]]]} | Open Access 1 | Red Hill Community Park | 24223 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 44.782 | Red Hill Community Park | ||
2569 | 2569 | 2568 | {"type": "Polygon", "coordinates": [[[-117.61177, 34.13636], [-117.60738, 34.13639], [-117.60737, 34.13547], [-117.61176, 34.13545], [-117.61177, 34.13636]]]} | Open Access 1 | East Beryl Park | 18363 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 10.11 | East Beryl Park | ||
1866 | 1866 | 1865 | {"type": "Polygon", "coordinates": [[[-117.60777, 34.09942], [-117.60777, 34.10111], [-117.60747, 34.10107], [-117.60668, 34.10107], [-117.60668, 34.09941], [-117.60777, 34.09942]]]} | Open Access 1 | Bear Gulch Park | 15926 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 4.563 | Bear Gulch Park | ||
6256 | 6256 | 6255 | {"type": "Polygon", "coordinates": [[[-117.60541, 34.12], [-117.6054, 34.12133], [-117.60539, 34.12135], [-117.60535, 34.12137], [-117.60497, 34.12137], [-117.60497, 34.12049], [-117.60414, 34.12048], [-117.60415, 34.11982], [-117.6046, 34.11982], [-117.60461, 34.12], [-117.60541, 34.12]]]} | Open Access 1 | Lions Park | 21322 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 2.733 | Lions Park | ||
4636 | 4636 | 4635 | {"type": "Polygon", "coordinates": [[[-117.59971, 34.08465], [-117.59967, 34.08468], [-117.59783, 34.08467], [-117.59783, 34.08363], [-117.59971, 34.08363], [-117.59971, 34.08465]]]} | Open Access 1 | Golden Oak Park | 19366 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 4.998 | Golden Oak Park | ||
7663 | 7663 | 7662 | {"type": "Polygon", "coordinates": [[[-117.58661, 34.0937], [-117.58559, 34.0937], [-117.58559, 34.09324], [-117.58528, 34.09323], [-117.58526, 34.0921], [-117.58661, 34.09211], [-117.58661, 34.0937]]]} | Open Access 1 | Old Town Park | 23107 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 5.029 | Old Town Park | ||
5076 | 5076 | 5075 | {"type": "Polygon", "coordinates": [[[-117.5846, 34.13116], [-117.58458, 34.13119], [-117.58453, 34.13122], [-117.58266, 34.13123], [-117.58263, 34.12928], [-117.58458, 34.12927], [-117.5846, 34.13116]]]} | Open Access 1 | Hermosa Park | 19870 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 9.576 | Hermosa Park | ||
2172 | 2172 | 2171 | {"type": "Polygon", "coordinates": [[[-117.58363, 34.1155], [-117.58255, 34.1155], [-117.58254, 34.11586], [-117.58169, 34.11586], [-117.58168, 34.11413], [-117.58362, 34.11413], [-117.58363, 34.1155]]]} | Open Access 1 | Church Street Park | 17249 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 7.512 | Church Street Park | ||
9878 | 9878 | 9877 | {"type": "Polygon", "coordinates": [[[-117.56879, 34.11417], [-117.56761, 34.11418], [-117.56759, 34.11388], [-117.56754, 34.11363], [-117.56745, 34.11334], [-117.5673, 34.11301], [-117.56731, 34.11295], [-117.56735, 34.11292], [-117.56837, 34.11268], [-117.56879, 34.11417]]]} | Open Access 1 | Spruce Avenue Park | 25753 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 3.899 | Spruce Avenue Park | ||
2585 | 2585 | 2584 | {"type": "Polygon", "coordinates": [[[-117.56593, 34.11792], [-117.5644, 34.1182], [-117.56421, 34.11666], [-117.56449, 34.11689], [-117.56565, 34.11689], [-117.56593, 34.11792]]]} | Open Access 1 | Coyote Canyon Park | 17734 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 4.517 | Coyote Canyon Park | ||
8485 | 8485 | 8484 | {"type": "Polygon", "coordinates": [[[-117.56449, 34.10877], [-117.56445, 34.10893], [-117.56447, 34.10923], [-117.56442, 34.10942], [-117.56436, 34.10944], [-117.56436, 34.10957], [-117.56384, 34.10954], [-117.56375, 34.10981], [-117.56294, 34.10965], [-117.56266, 34.10962], [-117.56257, 34.10986], [-117.56219, 34.11032], [-117.56197, 34.11016], [-117.5618, 34.10996], [-117.56169, 34.10978], [-117.56161, 34.10957], [-117.56157, 34.10937], [-117.56157, 34.10877], [-117.56158, 34.10874], [-117.56162, 34.10872], [-117.56233, 34.10868], [-117.56235, 34.10866], [-117.56326, 34.10866], [-117.56395, 34.1087], [-117.56449, 34.10877]]]} | Open Access 1 | Ralph M. Lewis Park | 24102 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 8.011 | Ralph M. Lewis Park | ||
10859 | 10859 | 10858 | {"type": "Polygon", "coordinates": [[[-117.56414, 34.12925], [-117.56402, 34.12933], [-117.56396, 34.12944], [-117.56397, 34.12957], [-117.56407, 34.12973], [-117.56409, 34.12981], [-117.56406, 34.12991], [-117.56395, 34.13006], [-117.56393, 34.13018], [-117.56339, 34.13017], [-117.56292, 34.13034], [-117.56267, 34.13048], [-117.56224, 34.13067], [-117.56193, 34.13074], [-117.56162, 34.13072], [-117.56158, 34.13021], [-117.56161, 34.13001], [-117.56166, 34.12987], [-117.56173, 34.12976], [-117.56185, 34.12965], [-117.56197, 34.12956], [-117.56215, 34.12948], [-117.56234, 34.12943], [-117.56384, 34.12931], [-117.56414, 34.12925]]]} | Open Access 1 | Victoria Groves Park | 27076 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 6.032 | Victoria Groves Park | ||
11105 | 11105 | 11104 | {"type": "Polygon", "coordinates": [[[-117.56307, 34.11333], [-117.56137, 34.11355], [-117.55999, 34.11337], [-117.5587, 34.11341], [-117.5587, 34.11307], [-117.55975, 34.11303], [-117.56041, 34.11281], [-117.56074, 34.11249], [-117.56208, 34.11289], [-117.56255, 34.11292], [-117.56305, 34.11322], [-117.56307, 34.11333]]]} | Open Access 1 | West Greenway Park | 27358 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 6.092 | West Greenway Park | ||
5904 | 5904 | 5903 | {"type": "Polygon", "coordinates": [[[-117.55831, 34.11338], [-117.55804, 34.11336], [-117.5567, 34.11336], [-117.55579, 34.11364], [-117.55575, 34.11354], [-117.55628, 34.11231], [-117.55626, 34.11218], [-117.5564, 34.11216], [-117.55647, 34.11219], [-117.55654, 34.11215], [-117.55662, 34.11215], [-117.5567, 34.11212], [-117.55675, 34.11215], [-117.5568, 34.11221], [-117.55686, 34.11222], [-117.557, 34.1121], [-117.55724, 34.11206], [-117.55741, 34.11192], [-117.55742, 34.11185], [-117.5575, 34.11184], [-117.55753, 34.11199], [-117.55756, 34.11207], [-117.55764, 34.11217], [-117.55774, 34.11224], [-117.55788, 34.11228], [-117.55801, 34.11228], [-117.55803, 34.11227], [-117.55802, 34.11219], [-117.55821, 34.11217], [-117.55823, 34.11231], [-117.55825, 34.11232], [-117.55829, 34.11266], [-117.55831, 34.11338]]]} | Open Access 1 | Milliken Park | 22250 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 7.131 | Milliken Park | ||
5719 | 5719 | 5718 | {"type": "Polygon", "coordinates": [[[-117.55624, 34.13237], [-117.55629, 34.13266], [-117.5562, 34.13345], [-117.55598, 34.13391], [-117.55527, 34.13366], [-117.55459, 34.13349], [-117.5539, 34.13338], [-117.55319, 34.13332], [-117.55324, 34.13329], [-117.55328, 34.13323], [-117.55333, 34.1332], [-117.55361, 34.13321], [-117.55381, 34.13316], [-117.55396, 34.13307], [-117.55405, 34.13298], [-117.55413, 34.13281], [-117.55415, 34.13248], [-117.55422, 34.13222], [-117.55419, 34.13214], [-117.55402, 34.1321], [-117.55624, 34.13237]]]} | Open Access 1 | Kenyon Park | 20625 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 7.861 | Kenyon Park | ||
6120 | 6120 | 6119 | {"type": "Polygon", "coordinates": [[[-117.5509, 34.11579], [-117.54936, 34.11708], [-117.54931, 34.11704], [-117.54933, 34.11526], [-117.55007, 34.11483], [-117.5509, 34.11579]]]} | Open Access 1 | Mountain View Park | 22557 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 5.02 | Mtn. View Park | ||
3952 | 3952 | 3951 | {"type": "Polygon", "coordinates": [[[-117.55071, 34.12322], [-117.55053, 34.12423], [-117.55049, 34.12459], [-117.55047, 34.12499], [-117.54919, 34.12497], [-117.54931, 34.12466], [-117.54928, 34.12463], [-117.54911, 34.12461], [-117.54911, 34.12455], [-117.54927, 34.12454], [-117.5493, 34.12451], [-117.54929, 34.12439], [-117.54925, 34.12423], [-117.54922, 34.12396], [-117.54929, 34.12368], [-117.54927, 34.12356], [-117.54924, 34.12354], [-117.54908, 34.12355], [-117.54906, 34.1235], [-117.54921, 34.12343], [-117.54925, 34.12337], [-117.5492, 34.12327], [-117.54946, 34.12326], [-117.54991, 34.12315], [-117.5502, 34.12313], [-117.55037, 34.12313], [-117.5506, 34.12316], [-117.55068, 34.12318], [-117.55071, 34.12322]]]} | Open Access 1 | Ellena Park | 18584 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 6.059 | Ellena Park |
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]);