units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
39 rows where MNG_AGENCY = 15 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, LABEL_NAME
DES_TP 4
- Local Park 31
- Local Recreation Area 6
- None 1
- None 1
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 39
MNG_AGENCY 1
- Moreno Valley, City of · 39 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14112 | 14112 | 14111 | {"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 | 39195 | 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 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 0.54 | Patriot Park | 0 | Local Park 2 | 4 | |
539 | 539 | 538 | {"type": "Polygon", "coordinates": [[[-117.26884, 33.97884], [-117.26877, 33.97891], [-117.26867, 33.97912], [-117.26867, 33.97921], [-117.26869, 33.97926], [-117.26861, 33.97934], [-117.26856, 33.97944], [-117.26852, 33.97949], [-117.26829, 33.97943], [-117.26791, 33.97943], [-117.26785, 33.9794], [-117.26774, 33.97913], [-117.26764, 33.97897], [-117.26754, 33.97876], [-117.26772, 33.97863], [-117.26778, 33.97864], [-117.26798, 33.97861], [-117.26804, 33.97883], [-117.26852, 33.9788], [-117.26884, 33.97884]]]} | Open Access 1 | 1795 | Hidden Springs Park | 19913 | 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 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 1.73 | Hidden Springs Park | 0 | Local Park 2 | 4 | |
14111 | 14111 | 14110 | {"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 | 39194 | 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 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 1.93 | Rock Ridge Park | 0 | Local Park 2 | 4 | |
6860 | 6860 | 6859 | {"type": "Polygon", "coordinates": [[[-117.2372, 33.92043], [-117.23719, 33.92081], [-117.23527, 33.92082], [-117.23514, 33.92072], [-117.23514, 33.92045], [-117.2372, 33.92043]]]} | Open Access 1 | 5494 | Bayside Park | 15896 | 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 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 1.935 | Bayside Park | 0 | Local Park 2 | 4 | |
10120 | 10120 | 10119 | {"type": "Polygon", "coordinates": [[[-117.24196, 33.9082], [-117.24193, 33.90836], [-117.24184, 33.90826], [-117.24182, 33.90826], [-117.24187, 33.90844], [-117.24187, 33.90876], [-117.24154, 33.90837], [-117.24154, 33.90821], [-117.24138, 33.90821], [-117.23994, 33.90653], [-117.23999, 33.9065], [-117.24031, 33.9065], [-117.24179, 33.9082], [-117.24196, 33.9082]]]} | Open Access 1 | 17589 | CA Aqueduct Linear Park Site | 16631 | 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 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 2.084 | CA Aqueduct Linear Park Site | 0 | Local Park 2 | 4 | |
9032 | 9032 | 9031 | {"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 | 14949 | 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 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 3.114 | Valley Skate Park | 0 | Local Recreation Area 3 | 4 | |
9118 | 9118 | 9117 | {"type": "Polygon", "coordinates": [[[-117.19889, 33.89558], [-117.19852, 33.89557], [-117.19849, 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.19889, 33.89558]]]} | Open Access 1 | 15118 | 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 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 3.935 | Vista Lomas Park | 0 | Local Park 2 | 4 | |
7725 | 7725 | 7724 | {"type": "Polygon", "coordinates": [[[-117.20566, 33.89551], [-117.2056, 33.89569], [-117.2056, 33.89687], [-117.20554, 33.8969], [-117.20441, 33.89691], [-117.20436, 33.89688], [-117.20428, 33.89669], [-117.20416, 33.89652], [-117.20411, 33.89646], [-117.20412, 33.8964], [-117.20443, 33.89619], [-117.20474, 33.89591], [-117.20501, 33.89561], [-117.2052, 33.89534], [-117.20527, 33.89532], [-117.20562, 33.89546], [-117.20566, 33.89551]]]} | Open Access 1 | 7981 | Parque Amistad | 23472 | 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 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 4.028 | Parque Amistad | None 639 | |||
6932 | 6932 | 6931 | {"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.20798, 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 | 5828 | 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 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 4.152 | Weston Park | 0 | Local Park 2 | 4 | |
1220 | 1220 | 1219 | {"type": "Polygon", "coordinates": [[[-117.26783, 33.92058], [-117.26764, 33.92058], [-117.26747, 33.92053], [-117.26684, 33.92026], [-117.26704, 33.91989], [-117.26709, 33.91976], [-117.26711, 33.91964], [-117.26711, 33.91952], [-117.26708, 33.9194], [-117.26683, 33.91877], [-117.26682, 33.91847], [-117.26684, 33.91845], [-117.26782, 33.91847], [-117.26783, 33.92058]]]} | Open Access 1 | 8693 | Adrienne Mitchell Memorial Park | 15276 | 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 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 4.412 | Adrienne Mitchell Memorial Park | 0 | Local Park 2 | 4 | |
9033 | 9033 | 9032 | {"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 | 14952 | 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 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 4.438 | Valley Skate Park (Hockey Rink) | None 752 | |||
6618 | 6618 | 6617 | {"type": "MultiPolygon", "coordinates": [[[[-117.25331, 33.91882], [-117.25309, 33.91903], [-117.25258, 33.9187], [-117.25256, 33.91835], [-117.25331, 33.91882]]], [[[-117.25764, 33.92158], [-117.25733, 33.92173], [-117.25325, 33.91913], [-117.25334, 33.91902], [-117.25347, 33.91893], [-117.25764, 33.92158]]], [[[-117.25922, 33.92258], [-117.25917, 33.92262], [-117.25839, 33.92212], [-117.25822, 33.9223], [-117.25752, 33.92185], [-117.25782, 33.9217], [-117.25882, 33.92232], [-117.25907, 33.92254], [-117.25916, 33.92258], [-117.25922, 33.92258]]]]} | Open Access 1 | 4234 | CA Aqueduct Linear Park Site | 16631 | 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 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 4.849 | CA Aqueduct Linear Park Site | 0 | Local Park 2 | 4 | |
96 | 96 | 95 | {"type": "Polygon", "coordinates": [[[-117.17871, 33.90266], [-117.17628, 33.90268], [-117.17627, 33.90187], [-117.17869, 33.90186], [-117.17871, 33.90266]]]} | Open Access 1 | 458 | Fairway Park | 18825 | 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 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 4.956 | Fairway Park | 0 | Local Park 2 | 4 | |
9175 | 9175 | 9174 | {"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 | 15233 | Westbluff Park | 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 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/resident_services/park_rec/index_park-rec.shtml?tab=3#Tab-mv | Riverside 10 | 5.011 | Westbluff Park | 0 | Local Park 2 | 4 |
9084 | 9084 | 9083 | {"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 | 15043 | 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 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 5.25 | Victoriano Park | 0 | Local Park 2 | 4 | |
7849 | 7849 | 7848 | {"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 | 9934 | 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 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 5.282 | Ridge Crest Park | 0 | Local Park 2 | 4 | |
8911 | 8911 | 8910 | {"type": "MultiPolygon", "coordinates": [[[[-117.25065, 33.96318], [-117.25048, 33.96323], [-117.24879, 33.96134], [-117.24853, 33.96172], [-117.24839, 33.96167], [-117.24852, 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.96569], [-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 | 14579 | 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 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 5.344 | Sunnymead Ranch Linear Park Site | 0 | Local Park 2 | 4 | |
992 | 992 | 991 | {"type": "Polygon", "coordinates": [[[-117.21966, 33.87834], [-117.21749, 33.87836], [-117.21748, 33.87735], [-117.21965, 33.87736], [-117.21966, 33.87834]]]} | Open Access 1 | 5497 | Bethune Park | 16048 | 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 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 5.479 | Bethune Park | 0 | Local Park 2 | 4 | |
3184 | 3184 | 3183 | {"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 | 22125 | 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 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 5.601 | Pedrorena Park | 0 | Local Park 2 | 4 | |
11991 | 11991 | 11990 | {"type": "Polygon", "coordinates": [[[-117.18266, 33.90361], [-117.1824, 33.90362], [-117.1824, 33.90407], [-117.1809, 33.90438], [-117.18064, 33.90402], [-117.1806, 33.9038], [-117.18052, 33.9038], [-117.18053, 33.90297], [-117.18062, 33.90291], [-117.18258, 33.90291], [-117.18266, 33.90297], [-117.18266, 33.90361]]]} | Open Access 1 | 24645 | Celebration Park | 17004 | 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 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 6.573 | Celebration 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]);