units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
61 rows where MNG_AGENCY = 185 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4866 | 4866 | 4865 | {"type": "Polygon", "coordinates": [[[-117.39881, 33.97562], [-117.3967, 33.97612], [-117.39677, 33.976], [-117.39676, 33.97599], [-117.39632, 33.97609], [-117.39633, 33.97611], [-117.39646, 33.97618], [-117.39507, 33.9765], [-117.39506, 33.97649], [-117.39344, 33.97687], [-117.3909, 33.97747], [-117.39089, 33.9775], [-117.39057, 33.97757], [-117.3904, 33.9775], [-117.39115, 33.97631], [-117.39145, 33.97595], [-117.39173, 33.97568], [-117.39207, 33.97541], [-117.39381, 33.97423], [-117.39453, 33.9738], [-117.39476, 33.97361], [-117.39493, 33.9734], [-117.39587, 33.97382], [-117.39642, 33.97382], [-117.39704, 33.97375], [-117.39773, 33.97419], [-117.39809, 33.97398], [-117.39792, 33.97424], [-117.39811, 33.97432], [-117.39829, 33.97438], [-117.39865, 33.97443], [-117.39881, 33.97562]]]} | Open Access 1 | 14708 | Tequesquito Arroyo Park | 26248 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 42.809 | Tequesquito Arroyo Park | 0 | Local Park 2 | 4 | |
5119 | 5119 | 5118 | {"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 | 8097 | Patterson Park | 23521 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 4.352 | Patterson Park | 0 | Local Park 2 | 4 | |
5463 | 5463 | 5462 | {"type": "Polygon", "coordinates": [[[-117.35709, 33.97285], [-117.35709, 33.97395], [-117.356, 33.97398], [-117.35595, 33.97467], [-117.35505, 33.97466], [-117.35504, 33.97285], [-117.35709, 33.97285]]]} | Open Access 1 | 6271 | Bobby Bonds Park and Sports Complex | 16213 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 7.442 | Bobby Bonds Park and Sports Complex | 0 | Local Recreation Area 3 | 4 | |
5531 | 5531 | 5530 | {"type": "Polygon", "coordinates": [[[-117.38523, 33.97454], [-117.38443, 33.97573], [-117.38338, 33.97525], [-117.38268, 33.97514], [-117.38229, 33.97515], [-117.38184, 33.97479], [-117.38356, 33.97319], [-117.38429, 33.97345], [-117.38463, 33.97353], [-117.38449, 33.97375], [-117.38478, 33.9739], [-117.38488, 33.97413], [-117.38505, 33.97434], [-117.38519, 33.97442], [-117.38523, 33.97454]]]} | Open Access 1 | 400 | Evans Park | 18753 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 12.086 | Evans Park | 0 | Local Park 2 | 4 | |
5750 | 5750 | 5749 | {"type": "Polygon", "coordinates": [[[-117.49315, 33.92732], [-117.49312, 33.92736], [-117.49232, 33.92767], [-117.49234, 33.92772], [-117.49048, 33.92843], [-117.49032, 33.92843], [-117.49019, 33.92838], [-117.48967, 33.92668], [-117.48843, 33.92474], [-117.48846, 33.92466], [-117.48897, 33.92435], [-117.48929, 33.92422], [-117.49079, 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.92681], [-117.49315, 33.92732]]]} | Open Access 1 | 3215 | La Sierra Park | 20808 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 23.045 | La Sierra Park | 0 | Local Park 2 | 4 | |
6488 | 6488 | 6487 | {"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.31076, 33.97802], [-117.31097, 33.97915], [-117.3094, 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 | 2341 | Islander Park | 20282 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 18.783 | Islander Park | 0 | Local Park 2 | 4 | |
6873 | 6873 | 6872 | {"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.39244, 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.98763], [-117.38669, 33.98696], [-117.38722, 33.98694], [-117.3872, 33.98667], [-117.38756, 33.98666], [-117.38782, 33.98635], [-117.38835, 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.39224, 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.39344, 33.97913], [-117.39343, 33.97912], [-117.39297, 33.97889], [-117.39302, 33.97886], [-117.39293, 33.97872], [-117.3952, 33.97823], [-117.39514, 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 | 5527 | Mount Rubidoux Park | 22530 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 166.427 | Mount Rubidoux Park | 0 | Local Park 2 | 4 | |
6875 | 6875 | 6874 | {"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.31684, 33.98416], [-117.3168, 33.9842], [-117.31679, 33.98425], [-117.31671, 33.98425], [-117.31672, 33.98509], [-117.31652, 33.98524], [-117.31637, 33.98543], [-117.31479, 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.31378, 33.98523], [-117.31378, 33.98484], [-117.31434, 33.98483], [-117.31434, 33.98456], [-117.31552, 33.98458], [-117.31557, 33.98408], [-117.31661, 33.98349], [-117.31665, 33.98307], [-117.31671, 33.98307], [-117.31672, 33.98312], [-117.31796, 33.98312], [-117.31797, 33.98415]]]} | Open Access 1 | 5533 | Mount Vernon Park | 22535 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 12.317 | Mount Vernon Park | 0 | Local Park 2 | 4 | |
6893 | 6893 | 6892 | {"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 | 5734 | North Park | 22841 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 1.274 | North Park | 0 | Local Park 2 | 4 | |
6897 | 6897 | 6896 | {"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 | 5744 | Nichols Park | 22749 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 14.586 | Nichols Park | 0 | Local Park 2 | 4 | |
7637 | 7637 | 7636 | {"type": "Polygon", "coordinates": [[[-117.46151, 33.93868], [-117.46151, 33.93891], [-117.46149, 33.93896], [-117.46143, 33.93898], [-117.45898, 33.93897], [-117.45902, 33.937], [-117.45903, 33.93485], [-117.45964, 33.93506], [-117.46119, 33.93554], [-117.46115, 33.93867], [-117.46151, 33.93868]]]} | Open Access 1 | 11597 | Bryant Park | 16458 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 20.908 | Bryant Park | 0 | Local Park 2 | 4 | |
8188 | 8188 | 8187 | {"type": "Polygon", "coordinates": [[[-117.39493, 33.94612], [-117.39314, 33.94614], [-117.39311, 33.94353], [-117.39324, 33.9435], [-117.39336, 33.94351], [-117.39402, 33.94372], [-117.39491, 33.9439], [-117.39493, 33.94612]]]} | Open Access 1 | 12431 | Shamel Park | 25355 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 11.051 | Shamel Park | 0 | Local Park 2 | 4 | |
9119 | 9119 | 9118 | {"type": "Polygon", "coordinates": [[[-117.41925, 33.9404], [-117.41735, 33.94148], [-117.41678, 33.94078], [-117.41675, 33.94072], [-117.41676, 33.94066], [-117.41681, 33.9406], [-117.41858, 33.93959], [-117.41925, 33.9404]]]} | Open Access 1 | 18705 | Don Jones Park | 18205 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 5.714 | Don Jones Park | 0 | Local Park 2 | 4 | |
9177 | 9177 | 9176 | {"type": "Polygon", "coordinates": [[[-117.37885, 33.9822], [-117.37866, 33.98249], [-117.3787, 33.98252], [-117.3787, 33.98262], [-117.37876, 33.9827], [-117.37854, 33.98304], [-117.37756, 33.98259], [-117.37757, 33.98255], [-117.37628, 33.98195], [-117.37676, 33.98123], [-117.37885, 33.9822]]]} | Open Access 1 | 15332 | White Park | 27461 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 5.332 | White Park | 0 | Local Park 2 | 4 | |
9396 | 9396 | 9395 | {"type": "Polygon", "coordinates": [[[-117.44487, 33.92816], [-117.44309, 33.92917], [-117.44256, 33.92851], [-117.44257, 33.92847], [-117.44432, 33.92748], [-117.44487, 33.92816]]]} | Open Access 1 | 18711 | Don Lorenzi Sports Center | 18206 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 4.492 | Don Lorenzi Sports Ctr. | 0 | Local Recreation Area 3 | 4 | |
10696 | 10696 | 10695 | {"type": "Polygon", "coordinates": [[[-117.50348, 33.92772], [-117.50251, 33.92989], [-117.50242, 33.92988], [-117.50156, 33.93086], [-117.50142, 33.93067], [-117.50125, 33.93054], [-117.50115, 33.93049], [-117.50104, 33.93046], [-117.50092, 33.93045], [-117.50058, 33.93051], [-117.50057, 33.93047], [-117.50053, 33.93047], [-117.49988, 33.92856], [-117.50072, 33.92825], [-117.50109, 33.92828], [-117.50152, 33.92826], [-117.50215, 33.92813], [-117.50294, 33.9279], [-117.50347, 33.92771], [-117.50348, 33.92772]]]} | Open Access 1 | 19854 | Golden Park | 19369 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 15.176 | Golden Park | 0 | Local Park 2 | 4 | |
10698 | 10698 | 10697 | {"type": "Polygon", "coordinates": [[[-117.45939, 33.92471], [-117.45996, 33.92582], [-117.46002, 33.92601], [-117.46004, 33.92623], [-117.46002, 33.92641], [-117.45998, 33.92658], [-117.45933, 33.92831], [-117.45763, 33.92787], [-117.45744, 33.92783], [-117.45553, 33.92783], [-117.45536, 33.92785], [-117.45518, 33.92791], [-117.45519, 33.92631], [-117.45527, 33.92629], [-117.45526, 33.92568], [-117.45773, 33.92493], [-117.45804, 33.92488], [-117.45891, 33.92481], [-117.45916, 33.92477], [-117.45939, 33.92471]]]} | Open Access 1 | 19858 | Challen Hill Park | 17115 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 33.132 | Challen Hill Park | 0 | Local Park 2 | 4 | |
10699 | 10699 | 10698 | {"type": "Polygon", "coordinates": [[[-117.44341, 33.90341], [-117.44327, 33.90362], [-117.44303, 33.90377], [-117.44231, 33.90407], [-117.44202, 33.9043], [-117.4418, 33.9046], [-117.44161, 33.90455], [-117.44127, 33.90455], [-117.44128, 33.90379], [-117.44133, 33.90359], [-117.44144, 33.9034], [-117.44156, 33.90326], [-117.44168, 33.90316], [-117.44266, 33.90261], [-117.44271, 33.9026], [-117.44277, 33.90262], [-117.44341, 33.90341]]]} | Open Access 1 | 19860 | Harrison Park | 19702 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 6.028 | Harrison Park | 0 | Local Park 2 | 4 | |
10700 | 10700 | 10699 | {"type": "Polygon", "coordinates": [[[-117.46036, 33.8924], [-117.45897, 33.89319], [-117.45756, 33.89148], [-117.4579, 33.89149], [-117.45792, 33.89136], [-117.45928, 33.89142], [-117.45965, 33.89158], [-117.46036, 33.8924]]]} | Open Access 1 | 19861 | Victoria Cross Park | 27074 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 7.06 | Victoria Cross Park | 0 | Local Park 2 | 4 | |
10701 | 10701 | 10700 | {"type": "Polygon", "coordinates": [[[-117.36263, 33.97145], [-117.36167, 33.97146], [-117.36167, 33.97143], [-117.36207, 33.97142], [-117.36206, 33.97072], [-117.36167, 33.97071], [-117.36167, 33.97062], [-117.36175, 33.97047], [-117.36181, 33.97046], [-117.36219, 33.97059], [-117.36224, 33.97066], [-117.36251, 33.97097], [-117.36262, 33.97106], [-117.36263, 33.97145]]]} | Open Access 1 | 19862 | Dario Vasquez Park | 17926 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 1.193 | Dario Vasquez 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]);