superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
37 rows where MNG_AGENCY = 15
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8014 | 8014 | 8013 | {"type": "Polygon", "coordinates": [[[-117.22611, 33.89861], [-117.22604, 33.89868], [-117.22536, 33.89868], [-117.22533, 33.89865], [-117.22533, 33.8984], [-117.22611, 33.8984], [-117.22611, 33.89861]]]} | Open Access 1 | Patriot Park | 23514 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 0.54 | Patriot Park | ||
8063 | 8063 | 8062 | {"type": "Polygon", "coordinates": [[[-117.21495, 33.88814], [-117.21413, 33.88823], [-117.21329, 33.88838], [-117.21316, 33.88835], [-117.21311, 33.88815], [-117.21312, 33.88796], [-117.21315, 33.88781], [-117.21327, 33.88749], [-117.21336, 33.88692], [-117.21401, 33.887], [-117.21464, 33.88693], [-117.21489, 33.88692], [-117.21495, 33.88814]]]} | Open Access 1 | Pedrorena Park | 23563 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 5.601 | Pedrorena Park | ||
8630 | 8630 | 8629 | {"type": "Polygon", "coordinates": [[[-117.36351, 34.00678], [-117.36336, 34.00838], [-117.362, 34.01018], [-117.35971, 34.01331], [-117.35887, 34.0143], [-117.35658, 34.01406], [-117.35175, 34.01332], [-117.35243, 34.01217], [-117.35253, 34.01193], [-117.35277, 34.01117], [-117.35321, 34.01016], [-117.35385, 34.00916], [-117.35449, 34.00853], [-117.35588, 34.0073], [-117.35792, 34.00425], [-117.35802, 34.00423], [-117.36351, 34.00678]]]} | Open Access 1 | Reid Park | 24279 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 172.702 | Reid Park | ||
8688 | 8688 | 8687 | {"type": "Polygon", "coordinates": [[[-117.16526, 33.9064], [-117.16413, 33.90667], [-117.16329, 33.90674], [-117.1629, 33.90592], [-117.16314, 33.90583], [-117.16455, 33.90547], [-117.16488, 33.90537], [-117.16526, 33.9064]]]} | Open Access 1 | Ridge Crest Park | 24347 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 5.281 | Ridge Crest Park | ||
8844 | 8844 | 8843 | {"type": "Polygon", "coordinates": [[[-117.18933, 33.93181], [-117.18902, 33.93204], [-117.18795, 33.93145], [-117.18795, 33.93102], [-117.18841, 33.93099], [-117.18842, 33.93067], [-117.18859, 33.93067], [-117.1886, 33.9313], [-117.18912, 33.93158], [-117.18933, 33.93181]]]} | Open Access 1 | Rock Ridge Park | 24512 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 1.934 | Rock Ridge Park | ||
9543 | 9543 | 9542 | {"type": "Polygon", "coordinates": [[[-117.25852, 33.97926], [-117.25646, 33.9793], [-117.25643, 33.97744], [-117.25746, 33.97774], [-117.25769, 33.9778], [-117.2581, 33.97782], [-117.25828, 33.97782], [-117.2585, 33.9778], [-117.25852, 33.97926]]]} | Open Access 1 | Shadow Mountain Park | 25338 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 8.256 | Shadow Mtn. Park | ||
10094 | 10094 | 10093 | {"type": "MultiPolygon", "coordinates": [[[[-117.23056, 33.93552], [-117.22939, 33.93726], [-117.22655, 33.93726], [-117.22655, 33.93592], [-117.22664, 33.93591], [-117.22665, 33.93583], [-117.22646, 33.93581], [-117.22646, 33.93552], [-117.23056, 33.93552]]], [[[-117.23072, 33.93726], [-117.22962, 33.93726], [-117.2307, 33.93561], [-117.2307, 33.93655], [-117.23072, 33.93726]]]]} | Open Access 1 | Sunnymead Park | 26007 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 17.424 | Sunnymead Park | ||
10095 | 10095 | 10094 | {"type": "MultiPolygon", "coordinates": [[[[-117.25065, 33.96318], [-117.25048, 33.96323], [-117.24879, 33.96134], [-117.24853, 33.96172], [-117.24839, 33.96167], [-117.24851, 33.9613], [-117.24634, 33.96131], [-117.24633, 33.96104], [-117.24874, 33.96103], [-117.25065, 33.96318]]], [[[-117.25129, 33.96387], [-117.25109, 33.96388], [-117.25065, 33.9634], [-117.25082, 33.96336], [-117.25129, 33.96387]]], [[[-117.25281, 33.9656], [-117.25279, 33.96568], [-117.25275, 33.96576], [-117.25123, 33.96404], [-117.25144, 33.96406], [-117.25281, 33.9656]]], [[[-117.25338, 33.96623], [-117.25333, 33.96631], [-117.25328, 33.96635], [-117.25288, 33.9659], [-117.25296, 33.96576], [-117.25338, 33.96623]]], [[[-117.25523, 33.96837], [-117.25508, 33.96843], [-117.25439, 33.96765], [-117.25341, 33.96652], [-117.25351, 33.96641], [-117.25523, 33.96837]]]]} | Open Access 1 | Sunnymead Ranch Linear Park Site | 26008 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 5.356 | Sunnymead Ranch Linear Park Site | ||
10428 | 10428 | 10427 | {"type": "Polygon", "coordinates": [[[-117.27414, 33.9303], [-117.27373, 33.93047], [-117.27341, 33.93062], [-117.27307, 33.93022], [-117.27271, 33.9302], [-117.27233, 33.9304], [-117.27226, 33.93049], [-117.27226, 33.93059], [-117.27252, 33.93064], [-117.2726, 33.93064], [-117.27261, 33.93067], [-117.27257, 33.93068], [-117.27232, 33.93086], [-117.27232, 33.93088], [-117.2741, 33.93202], [-117.27379, 33.93222], [-117.27206, 33.93113], [-117.27105, 33.93222], [-117.27066, 33.93199], [-117.27036, 33.93185], [-117.27008, 33.93174], [-117.26982, 33.93166], [-117.26976, 33.93157], [-117.27001, 33.93095], [-117.2701, 33.93078], [-117.27017, 33.93054], [-117.2702, 33.93038], [-117.27022, 33.93016], [-117.27021, 33.92961], [-117.27035, 33.92969], [-117.27063, 33.92969], [-117.27071, 33.92965], [-117.27074, 33.92961], [-117.27379, 33.92959], [-117.27387, 33.92956], [-117.27394, 33.92954], [-117.27405, 33.92948], [-117.27406, 33.92991], [-117.27414, 33.9303]]]} | Open Access 1 | Towngate Memorial Park | 26496 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 17.355 | Towngate Memorial Park | ||
10632 | 10632 | 10631 | {"type": "Polygon", "coordinates": [[[-117.24827, 33.89692], [-117.24824, 33.89779], [-117.24691, 33.89782], [-117.24689, 33.89688], [-117.24827, 33.89692]]]} | Open Access 1 | Valley Skate Park | 26801 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 3.114 | Valley Skate Park | ||
10634 | 10634 | 10633 | {"type": "Polygon", "coordinates": [[[-117.24827, 33.89565], [-117.24827, 33.89692], [-117.24689, 33.89688], [-117.24688, 33.89562], [-117.24827, 33.89565]]]} | Open Access 1 | Valley Skate Park (Hockey Rink) | 26802 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 4.437 | Valley Skate Park (Hockey Rink) | ||
10871 | 10871 | 10870 | {"type": "Polygon", "coordinates": [[[-117.21378, 33.89051], [-117.21312, 33.89162], [-117.21163, 33.89101], [-117.21232, 33.88986], [-117.21261, 33.89002], [-117.21378, 33.89051]]]} | Open Access 1 | Victoriano Park | 27086 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 5.25 | Victoriano Park | ||
10929 | 10929 | 10928 | {"type": "Polygon", "coordinates": [[[-117.1989, 33.89558], [-117.19852, 33.89557], [-117.19848, 33.89555], [-117.19837, 33.89556], [-117.19832, 33.8956], [-117.19829, 33.89566], [-117.19832, 33.89575], [-117.19792, 33.89604], [-117.19709, 33.89601], [-117.19671, 33.89594], [-117.19595, 33.89591], [-117.19595, 33.89558], [-117.19655, 33.89555], [-117.19736, 33.89543], [-117.19793, 33.89529], [-117.19827, 33.89519], [-117.19884, 33.89498], [-117.19892, 33.8951], [-117.19894, 33.89523], [-117.1989, 33.89558]]]} | Open Access 1 | Vista Lomas Park | 27177 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 3.935 | Vista Lomas Park | ||
11145 | 11145 | 11144 | {"type": "Polygon", "coordinates": [[[-117.20878, 33.92995], [-117.20869, 33.93002], [-117.20851, 33.93004], [-117.20839, 33.93007], [-117.20832, 33.93003], [-117.20827, 33.92988], [-117.20813, 33.92963], [-117.20797, 33.92942], [-117.20768, 33.92911], [-117.2076, 33.92895], [-117.20755, 33.9288], [-117.20755, 33.92834], [-117.20759, 33.9283], [-117.20869, 33.92829], [-117.20877, 33.92837], [-117.20878, 33.92995]]]} | Open Access 1 | Weston Park | 27415 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 4.151 | Weston Park | ||
11392 | 11392 | 11391 | {"type": "Polygon", "coordinates": [[[-117.21472, 33.90996], [-117.21294, 33.90995], [-117.21286, 33.90989], [-117.21286, 33.90933], [-117.21282, 33.90908], [-117.21269, 33.9088], [-117.21259, 33.90866], [-117.21246, 33.90852], [-117.21246, 33.90847], [-117.21264, 33.90828], [-117.21277, 33.90806], [-117.21323, 33.90814], [-117.21324, 33.90816], [-117.21472, 33.90815], [-117.21472, 33.90996]]]} | Open Access 1 | Woodland Park | 27723 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 9.085 | Woodland Park | ||
11708 | 11708 | 11707 | {"type": "Polygon", "coordinates": [[[-117.26135, 33.96557], [-117.2581, 33.96558], [-117.2581, 33.96493], [-117.25814, 33.96497], [-117.26135, 33.96496], [-117.26135, 33.96557]]]} | Open Access 1 | Westbluff Park | http://www.moreno-valley.ca.us/resident_services/park_rec/index_park-rec.shtml?tab=3#Tab-mv | 28291 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 5.009 | Westbluff Park | |
14506 | 14506 | 14505 | {"type": "Polygon", "coordinates": [[[-117.26651, 33.92036], [-117.26651, 33.92039], [-117.26641, 33.9206], [-117.26637, 33.92081], [-117.26592, 33.92102], [-117.26594, 33.92111], [-117.26612, 33.9214], [-117.26618, 33.92154], [-117.2662, 33.92162], [-117.26626, 33.92176], [-117.26626, 33.92189], [-117.26624, 33.92201], [-117.26621, 33.92211], [-117.26615, 33.92219], [-117.26575, 33.92202], [-117.26564, 33.92182], [-117.26545, 33.92155], [-117.2653, 33.92118], [-117.26518, 33.92108], [-117.26501, 33.92104], [-117.26362, 33.92104], [-117.26352, 33.92105], [-117.26337, 33.92112], [-117.2631, 33.92132], [-117.263, 33.92143], [-117.26292, 33.92157], [-117.26285, 33.92175], [-117.26283, 33.92219], [-117.26281, 33.92236], [-117.26276, 33.92252], [-117.26265, 33.92268], [-117.26225, 33.92314], [-117.26215, 33.92331], [-117.26214, 33.92341], [-117.26144, 33.92341], [-117.26142, 33.92104], [-117.26149, 33.92097], [-117.26168, 33.92097], [-117.26185, 33.92093], [-117.26201, 33.92087], [-117.26215, 33.92077], [-117.26249, 33.92108], [-117.26261, 33.92098], [-117.26299, 33.92069], [-117.26322, 33.92059], [-117.26351, 33.92053], [-117.26578, 33.92053], [-117.26589, 33.92012], [-117.26604, 33.92016], [-117.26651, 33.92036]]]} | Restricted Access 2 | Park El Moreno Golf Course | 33026 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 14.926 | Park El Moreno GC |
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]);