superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
59 rows where MNG_AGENCY = 185 sorted by PARK_URL
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5130 | 5130 | 5129 | {"type": "Polygon", "coordinates": [[[-117.33014, 33.98755], [-117.32986, 33.98789], [-117.32965, 33.98784], [-117.32856, 33.98784], [-117.32834, 33.98781], [-117.32807, 33.9877], [-117.32771, 33.98746], [-117.32742, 33.98734], [-117.32717, 33.98729], [-117.32643, 33.98724], [-117.32641, 33.98721], [-117.32641, 33.9867], [-117.32646, 33.98666], [-117.32677, 33.98666], [-117.32679, 33.98701], [-117.3289, 33.98699], [-117.32899, 33.98724], [-117.32964, 33.98699], [-117.33014, 33.98755]]]} | Open Access 1 | Highland Park | 19934 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 5.565 | Highland Park | ||
5146 | 5146 | 5145 | {"type": "Polygon", "coordinates": [[[-117.36909, 33.97328], [-117.36859, 33.97404], [-117.36855, 33.97406], [-117.36852, 33.97405], [-117.36731, 33.97349], [-117.36786, 33.9727], [-117.36909, 33.97328]]]} | Open Access 1 | Lincoln Park | 21269 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 3.27 | Lincoln Park | ||
5301 | 5301 | 5300 | {"type": "Polygon", "coordinates": [[[-117.44281, 33.92927], [-117.44007, 33.93082], [-117.44, 33.9307], [-117.4399, 33.93042], [-117.43981, 33.93026], [-117.43907, 33.92934], [-117.4391, 33.9293], [-117.44164, 33.92787], [-117.4417, 33.9279], [-117.44281, 33.92927]]]} | Open Access 1 | Hunt Park | 20152 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 13.778 | Hunt Park | ||
5302 | 5302 | 5301 | {"type": "Polygon", "coordinates": [[[-117.34381, 34.00102], [-117.34008, 34.00101], [-117.34004, 34.00099], [-117.34002, 34.00096], [-117.34002, 33.9977], [-117.34004, 33.99767], [-117.34008, 33.99765], [-117.34377, 33.99765], [-117.34381, 34.00102]]]} | Open Access 1 | Hunter Park | 20153 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 32.153 | Hunter Park | ||
5420 | 5420 | 5419 | {"type": "Polygon", "coordinates": [[[-117.31356, 33.97583], [-117.31348, 33.97661], [-117.31272, 33.97644], [-117.3127, 33.97634], [-117.31246, 33.97633], [-117.31216, 33.97636], [-117.31184, 33.97644], [-117.31152, 33.97658], [-117.31126, 33.97676], [-117.31103, 33.977], [-117.31091, 33.97717], [-117.31082, 33.97736], [-117.31077, 33.97756], [-117.31074, 33.97776], [-117.31077, 33.97802], [-117.31097, 33.97915], [-117.30941, 33.97913], [-117.30939, 33.9792], [-117.3091, 33.9792], [-117.30899, 33.97901], [-117.30891, 33.97877], [-117.30888, 33.9786], [-117.30888, 33.97827], [-117.30939, 33.97827], [-117.30941, 33.97575], [-117.31351, 33.97578], [-117.31355, 33.9758], [-117.31356, 33.97583]]]} | Open Access 1 | Islander Park | 20282 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 18.789 | Islander Park | ||
5837 | 5837 | 5836 | {"type": "Polygon", "coordinates": [[[-117.49315, 33.92732], [-117.49312, 33.92736], [-117.49233, 33.92766], [-117.49234, 33.92772], [-117.49048, 33.92843], [-117.49032, 33.92843], [-117.49019, 33.92838], [-117.48966, 33.92668], [-117.48843, 33.92474], [-117.48846, 33.92466], [-117.48897, 33.92435], [-117.48929, 33.92422], [-117.49078, 33.92578], [-117.49082, 33.9258], [-117.49095, 33.92584], [-117.49108, 33.92584], [-117.49186, 33.92554], [-117.49203, 33.92586], [-117.49239, 33.92573], [-117.49293, 33.92679], [-117.49289, 33.92682], [-117.49315, 33.92732]]]} | Open Access 1 | La Sierra Park | 20808 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 23.049 | La Sierra Park | ||
6377 | 6377 | 6376 | {"type": "Polygon", "coordinates": [[[-117.38677, 33.98911], [-117.3867, 33.98967], [-117.38581, 33.9893], [-117.38579, 33.98931], [-117.38569, 33.98922], [-117.38557, 33.98916], [-117.38573, 33.98909], [-117.38574, 33.98907], [-117.38557, 33.98899], [-117.3852, 33.98842], [-117.38543, 33.98852], [-117.38548, 33.98853], [-117.38555, 33.98849], [-117.3856, 33.9885], [-117.38566, 33.98844], [-117.38571, 33.98842], [-117.3858, 33.98849], [-117.38614, 33.9886], [-117.38634, 33.98871], [-117.38649, 33.98882], [-117.38677, 33.98911]]]} | Open Access 1 | Loring Park | 21469 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 2.465 | Loring Park | ||
6434 | 6434 | 6433 | {"type": "MultiPolygon", "coordinates": [[[[-117.40095, 33.94772], [-117.40095, 33.94777], [-117.40025, 33.94777], [-117.40041, 33.94751], [-117.40046, 33.94749], [-117.40093, 33.94769], [-117.40095, 33.94772]]], [[[-117.40082, 33.94629], [-117.40073, 33.94643], [-117.40029, 33.94713], [-117.40029, 33.94672], [-117.40046, 33.9467], [-117.40046, 33.9463], [-117.40082, 33.94629]]], [[[-117.40096, 33.94666], [-117.40096, 33.94755], [-117.40095, 33.94758], [-117.40091, 33.9476], [-117.40053, 33.94743], [-117.4005, 33.94737], [-117.40096, 33.94666]]]]} | Open Access 1 | Low Park | 21552 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1.259 | Low Park | ||
7241 | 7241 | 7240 | {"type": "Polygon", "coordinates": [[[-117.39744, 33.98247], [-117.39709, 33.98354], [-117.39609, 33.98502], [-117.3952, 33.98599], [-117.39408, 33.98696], [-117.3933, 33.98826], [-117.39245, 33.98893], [-117.39223, 33.9892], [-117.39218, 33.98924], [-117.39205, 33.98929], [-117.39182, 33.98929], [-117.39155, 33.98933], [-117.39091, 33.98952], [-117.38988, 33.98974], [-117.38962, 33.98976], [-117.3893, 33.98973], [-117.38766, 33.98919], [-117.38735, 33.989], [-117.38667, 33.98836], [-117.38626, 33.98815], [-117.38659, 33.98816], [-117.38668, 33.98819], [-117.38677, 33.98826], [-117.38713, 33.98798], [-117.38713, 33.98797], [-117.38673, 33.98764], [-117.38677, 33.98762], [-117.38669, 33.98696], [-117.38721, 33.98694], [-117.3872, 33.98667], [-117.38756, 33.98665], [-117.38782, 33.98635], [-117.38834, 33.98591], [-117.38873, 33.98478], [-117.38871, 33.98462], [-117.38943, 33.98417], [-117.39008, 33.98389], [-117.39036, 33.98386], [-117.39043, 33.98362], [-117.39076, 33.98331], [-117.39088, 33.98317], [-117.39101, 33.98296], [-117.3911, 33.9828], [-117.39116, 33.98262], [-117.39123, 33.98228], [-117.39142, 33.98213], [-117.3917, 33.9818], [-117.39214, 33.98142], [-117.39223, 33.98129], [-117.39221, 33.98118], [-117.39211, 33.98102], [-117.39204, 33.98074], [-117.39178, 33.9806], [-117.39172, 33.98048], [-117.39173, 33.98035], [-117.39164, 33.9803], [-117.39178, 33.98], [-117.39202, 33.97965], [-117.39226, 33.97939], [-117.39259, 33.97912], [-117.39309, 33.97935], [-117.39343, 33.97913], [-117.39343, 33.97912], [-117.39297, 33.97889], [-117.39302, 33.97885], [-117.39293, 33.97872], [-117.3952, 33.97823], [-117.39515, 33.97836], [-117.39551, 33.97836], [-117.39563, 33.97842], [-117.39601, 33.97902], [-117.39609, 33.98016], [-117.39688, 33.98022], [-117.39735, 33.98022], [-117.39737, 33.97982], [-117.39734, 33.97973], [-117.39726, 33.97967], [-117.39734, 33.97958], [-117.39739, 33.97962], [-117.39747, 33.97971], [-117.39751, 33.97987], [-117.39737, 33.98224], [-117.39744, 33.98247]]]} | Open Access 1 | Mount Rubidoux Park | 22530 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 166.452 | Mount Rubidoux Park | ||
7244 | 7244 | 7243 | {"type": "Polygon", "coordinates": [[[-117.31797, 33.98415], [-117.31795, 33.98417], [-117.31792, 33.98419], [-117.31714, 33.98418], [-117.31701, 33.98413], [-117.31694, 33.98412], [-117.31683, 33.98416], [-117.3168, 33.9842], [-117.31679, 33.98425], [-117.31672, 33.98425], [-117.31672, 33.98509], [-117.31652, 33.98524], [-117.31637, 33.98543], [-117.3148, 33.98544], [-117.31479, 33.9857], [-117.31407, 33.9857], [-117.31407, 33.98558], [-117.314, 33.98553], [-117.31371, 33.98548], [-117.31371, 33.98543], [-117.31377, 33.98523], [-117.31378, 33.98484], [-117.31433, 33.98483], [-117.31434, 33.98456], [-117.31551, 33.98457], [-117.31557, 33.98408], [-117.3166, 33.98349], [-117.31665, 33.98307], [-117.31671, 33.98307], [-117.31673, 33.98312], [-117.31796, 33.98312], [-117.31797, 33.98415]]]} | Open Access 1 | Mount Vernon Park | 22535 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 12.334 | Mount Vernon Park | ||
7293 | 7293 | 7292 | {"type": "Polygon", "coordinates": [[[-117.47581, 33.92126], [-117.47472, 33.92215], [-117.47442, 33.92184], [-117.47425, 33.92197], [-117.47407, 33.92174], [-117.47366, 33.9219], [-117.47363, 33.92189], [-117.47326, 33.92208], [-117.47304, 33.92173], [-117.47259, 33.92118], [-117.4737, 33.9206], [-117.47389, 33.92082], [-117.4746, 33.92045], [-117.47477, 33.92071], [-117.47462, 33.92081], [-117.47474, 33.92101], [-117.47538, 33.92068], [-117.47579, 33.92118], [-117.47581, 33.92126]]]} | Open Access 1 | Myra Linn Park | 22619 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 7.881 | Myra Linn Park | ||
7362 | 7362 | 7361 | {"type": "MultiPolygon", "coordinates": [[[[-117.37978, 33.97615], [-117.37952, 33.97656], [-117.37949, 33.97657], [-117.37945, 33.97657], [-117.37897, 33.97634], [-117.37903, 33.97625], [-117.3794, 33.97624], [-117.37964, 33.9762], [-117.37978, 33.97615]]], [[[-117.3806, 33.97735], [-117.38008, 33.97814], [-117.37913, 33.97771], [-117.37967, 33.97692], [-117.3806, 33.97735]]]]} | Open Access 1 | Newman Park | 22730 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 2.886 | Newman Park | ||
7376 | 7376 | 7375 | {"type": "Polygon", "coordinates": [[[-117.42612, 33.96], [-117.42413, 33.95836], [-117.42387, 33.95817], [-117.42353, 33.95796], [-117.42304, 33.95772], [-117.42224, 33.9574], [-117.42156, 33.95721], [-117.42116, 33.95713], [-117.4208, 33.95708], [-117.42081, 33.95701], [-117.42103, 33.95701], [-117.42134, 33.95707], [-117.42168, 33.9571], [-117.42609, 33.95706], [-117.42612, 33.96]]]} | Open Access 1 | Nichols Park | 22749 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 14.585 | Nichols Park | ||
7449 | 7449 | 7448 | {"type": "Polygon", "coordinates": [[[-117.36851, 33.97944], [-117.36827, 33.9797], [-117.36799, 33.98012], [-117.36746, 33.97987], [-117.36785, 33.97925], [-117.36794, 33.97919], [-117.36851, 33.97944]]]} | Open Access 1 | North Park | 22841 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1.274 | North Park | ||
7649 | 7649 | 7648 | {"type": "Polygon", "coordinates": [[[-117.46881, 33.95793], [-117.46871, 33.958], [-117.4678, 33.95806], [-117.46654, 33.95818], [-117.46577, 33.95822], [-117.46696, 33.95722], [-117.46655, 33.95686], [-117.46679, 33.95666], [-117.46684, 33.95669], [-117.46692, 33.9567], [-117.46698, 33.95669], [-117.46703, 33.95665], [-117.46707, 33.9566], [-117.46707, 33.95655], [-117.46706, 33.9565], [-117.46702, 33.95646], [-117.4674, 33.95614], [-117.46833, 33.95678], [-117.46856, 33.95701], [-117.4687, 33.95723], [-117.46879, 33.95745], [-117.46882, 33.95768], [-117.46881, 33.95793]]]} | Open Access 1 | Rutland Park | 24755 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 8.567 | Rutland Park | ||
7730 | 7730 | 7729 | {"type": "Polygon", "coordinates": [[[-117.31539, 33.89509], [-117.31542, 33.89745], [-117.31538, 33.89765], [-117.31531, 33.89784], [-117.3152, 33.89802], [-117.31503, 33.89823], [-117.31326, 33.89717], [-117.31293, 33.897], [-117.31258, 33.89686], [-117.31221, 33.89675], [-117.31182, 33.89668], [-117.31156, 33.89666], [-117.31167, 33.89567], [-117.31189, 33.89491], [-117.3126, 33.89505], [-117.3131, 33.8951], [-117.31539, 33.89509]]]} | Open Access 1 | Orange Terrace Community Park | 23178 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 21.8 | Orange Terrace Community Park | ||
8020 | 8020 | 8019 | {"type": "Polygon", "coordinates": [[[-117.35274, 33.97925], [-117.35065, 33.97926], [-117.35064, 33.97845], [-117.35274, 33.97843], [-117.35274, 33.97925]]]} | Open Access 1 | Patterson Park | 23521 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 4.35 | Patterson Park | ||
8525 | 8525 | 8524 | {"type": "Polygon", "coordinates": [[[-117.48705, 33.90341], [-117.48654, 33.90444], [-117.48509, 33.90395], [-117.4845, 33.90321], [-117.48512, 33.90285], [-117.48535, 33.90279], [-117.48561, 33.90279], [-117.48585, 33.90284], [-117.48646, 33.90305], [-117.48659, 33.90312], [-117.4867, 33.90314], [-117.48678, 33.90312], [-117.48685, 33.90335], [-117.48705, 33.90341]]]} | Open Access 1 | Rancho Loma Park | 24151 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 6.497 | Rancho Loma Park | ||
8803 | 8803 | 8802 | {"type": "Polygon", "coordinates": [[[-117.33536, 33.9812], [-117.33535, 33.98219], [-117.33523, 33.98258], [-117.33522, 33.98284], [-117.33513, 33.9829], [-117.33282, 33.98289], [-117.33281, 33.98294], [-117.33261, 33.98294], [-117.3326, 33.98289], [-117.33248, 33.98289], [-117.33246, 33.98294], [-117.33221, 33.98294], [-117.33219, 33.98289], [-117.33128, 33.98289], [-117.33124, 33.98286], [-117.33125, 33.98119], [-117.33284, 33.9812], [-117.33536, 33.9812]]]} | Open Access 1 | Riverside Sports Center | 24460 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 17.5 | Riverside Sports Ctr. | ||
8808 | 8808 | 8807 | {"type": "MultiPolygon", "coordinates": [[[[-117.49463, 33.90092], [-117.49453, 33.901], [-117.49383, 33.90091], [-117.49395, 33.90071], [-117.49401, 33.90052], [-117.49414, 33.90042], [-117.4942, 33.90034], [-117.49423, 33.90023], [-117.49421, 33.90011], [-117.49405, 33.89988], [-117.49393, 33.89967], [-117.49386, 33.89952], [-117.49387, 33.89939], [-117.49385, 33.89936], [-117.49373, 33.89929], [-117.49363, 33.89919], [-117.49355, 33.89914], [-117.49328, 33.89906], [-117.49316, 33.89906], [-117.49304, 33.89901], [-117.49297, 33.89895], [-117.49283, 33.89878], [-117.49358, 33.89836], [-117.49418, 33.89909], [-117.49433, 33.89935], [-117.49447, 33.89966], [-117.49456, 33.89993], [-117.49462, 33.90026], [-117.49465, 33.90054], [-117.49463, 33.90092]]], [[[-117.49574, 33.90107], [-117.49564, 33.90112], [-117.49505, 33.90105], [-117.49499, 33.90098], [-117.49501, 33.90053], [-117.49494, 33.89995], [-117.49488, 33.89974], [-117.49474, 33.89939], [-117.49484, 33.89936], [-117.49538, 33.90002], [-117.49532, 33.90011], [-117.49532, 33.90021], [-117.49567, 33.90064], [-117.49573, 33.90074], [-117.49576, 33.90088], [-117.49574, 33.90107]]]]} | Open Access 1 | Riverwalk Dog Park | 24468 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 6.013 | Riverwalk Dog 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]);