units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
38 rows where ACCESS_TYP = 1 and MNG_AGENCY = 15
This data as json, copyable, CSV (advanced)
DES_TP 3
- Local Park 15
- Local Recreation Area 2
- None 1
MNG_AG_TYP 1
- City Agency 18
MNG_AGENCY 1
- Moreno Valley, City of · 18 ✖
ACCESS_TYP 1
- Open Access · 18 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7845 | 7845 | 7844 | {"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 | 9734 | 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 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 172.703 | Reid 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 | |
8162 | 8162 | 8161 | {"type": "Polygon", "coordinates": [[[-117.25852, 33.97926], [-117.25646, 33.9793], [-117.25643, 33.97744], [-117.25746, 33.97774], [-117.2577, 33.9778], [-117.2581, 33.97782], [-117.25828, 33.97782], [-117.2585, 33.9778], [-117.25852, 33.97926]]]} | Open Access 1 | 12358 | 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 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 8.258 | Shadow Mtn. Park | 0 | Local Park 2 | 4 | |
8438 | 8438 | 8437 | {"type": "MultiPolygon", "coordinates": [[[[-117.21676, 33.87927], [-117.21586, 33.87795], [-117.21494, 33.87663], [-117.21514, 33.87659], [-117.21528, 33.87655], [-117.2164, 33.87818], [-117.21673, 33.87813], [-117.21674, 33.87813], [-117.21676, 33.87826], [-117.21676, 33.87927]]], [[[-117.21737, 33.88013], [-117.21706, 33.8797], [-117.21698, 33.87969], [-117.217, 33.87965], [-117.217, 33.87958], [-117.21697, 33.87946], [-117.21696, 33.87901], [-117.21701, 33.87907], [-117.21737, 33.87907], [-117.21737, 33.88013]]], [[[-117.22183, 33.88557], [-117.22158, 33.88526], [-117.2185, 33.88162], [-117.2189, 33.88163], [-117.21965, 33.88249], [-117.22153, 33.88472], [-117.22183, 33.88474], [-117.22183, 33.88557]]], [[[-117.22605, 33.89039], [-117.22544, 33.88968], [-117.22443, 33.88853], [-117.22531, 33.88855], [-117.22531, 33.88869], [-117.22584, 33.88911], [-117.22605, 33.88911], [-117.22605, 33.89039]]], [[[-117.26297, 33.925], [-117.26293, 33.92504], [-117.26285, 33.92519], [-117.26276, 33.9252], [-117.26189, 33.92465], [-117.26244, 33.92465], [-117.26297, 33.925]]], [[[-117.2647, 33.92609], [-117.26457, 33.92628], [-117.26448, 33.92628], [-117.263, 33.92535], [-117.263, 33.92528], [-117.26311, 33.92516], [-117.2632, 33.92513], [-117.2647, 33.92609]]], [[[-117.26729, 33.92786], [-117.26683, 33.92784], [-117.26572, 33.9271], [-117.26572, 33.92708], [-117.26475, 33.92646], [-117.26476, 33.92638], [-117.26487, 33.92626], [-117.26489, 33.9262], [-117.26721, 33.92771], [-117.26729, 33.92786]]], [[[-117.26937, 33.92941], [-117.26755, 33.92824], [-117.26714, 33.92799], [-117.2677, 33.928], [-117.26936, 33.92906], [-117.26937, 33.92941]]], [[[-117.26993, 33.92942], [-117.26985, 33.9295], [-117.26962, 33.92949], [-117.26957, 33.92946], [-117.26957, 33.9292], [-117.26993, 33.92942]]]]} | Open Access 1 | 13105 | 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 | 16.212 | CA Aqueduct Linear Park Site | 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 | |
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 | |
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 | |||
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 | |
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 | |
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 |
9291 | 9291 | 9290 | {"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.21263, 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 | 15477 | 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 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 9.086 | Woodland 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 | |
10709 | 10709 | 10708 | {"type": "Polygon", "coordinates": [[[-117.27147, 33.98103], [-117.27074, 33.98105], [-117.27077, 33.98227], [-117.27102, 33.98307], [-117.26991, 33.98309], [-117.26957, 33.98198], [-117.26922, 33.98177], [-117.2686, 33.98153], [-117.26838, 33.98123], [-117.2681, 33.98108], [-117.26807, 33.98093], [-117.26797, 33.9808], [-117.26785, 33.98078], [-117.26794, 33.98044], [-117.26796, 33.98026], [-117.26797, 33.98009], [-117.26794, 33.97977], [-117.26792, 33.97965], [-117.26796, 33.9796], [-117.26815, 33.97959], [-117.26828, 33.9796], [-117.2685, 33.97966], [-117.26861, 33.97971], [-117.26894, 33.97996], [-117.26907, 33.98004], [-117.26923, 33.98011], [-117.26939, 33.98015], [-117.26956, 33.98017], [-117.26973, 33.98017], [-117.2699, 33.98015], [-117.27025, 33.98005], [-117.27046, 33.98003], [-117.27066, 33.98004], [-117.27084, 33.98009], [-117.27102, 33.98017], [-117.27117, 33.98028], [-117.2713, 33.98041], [-117.27139, 33.98058], [-117.27147, 33.98103]]]} | Open Access 1 | 19867 | Hidden Springs Community Park | 19912 | 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 | 16.933 | Hidden Springs Community Park | 0 | Local Park 2 | 4 | |
10710 | 10710 | 10709 | {"type": "Polygon", "coordinates": [[[-117.36135, 34.01479], [-117.35954, 34.01846], [-117.35914, 34.01925], [-117.35661, 34.01788], [-117.35432, 34.01711], [-117.35485, 34.01485], [-117.35635, 34.01522], [-117.35656, 34.0142], [-117.35864, 34.01442], [-117.35857, 34.01448], [-117.35858, 34.01449], [-117.36135, 34.01479]]]} | Open Access 1 | 19868 | Ab Brown Sports Complex | 15231 | 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 | 53.482 | Ab Brown Sports Complex | 0 | Local Recreation Area 3 | 4 | |
11344 | 11344 | 11343 | {"type": "Polygon", "coordinates": [[[-117.20012, 33.92813], [-117.19583, 33.92815], [-117.19583, 33.92645], [-117.20007, 33.92645], [-117.20008, 33.92693], [-117.20006, 33.92694], [-117.20006, 33.92702], [-117.20008, 33.92703], [-117.20008, 33.9274], [-117.20012, 33.92741], [-117.20012, 33.92813]]]} | Open Access 1 | 22124 | Morrison Park | 22499 | 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 | 18.257 | Morrison 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 | |
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 | |
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 |
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]);