units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
61 rows where MNG_AGENCY = 185 sorted by map descending
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, LABEL_NAME, YR_EST, GAP_STS
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
2925 | 2925 | 2924 | {"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.90336], [-117.48705, 33.90341]]]} | Open Access 1 | 19856 | Rancho Loma Park | 24151 | 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.497 | Rancho Loma Park | 0 | Local Park 2 | 4 | |
2924 | 2924 | 2923 | {"type": "Polygon", "coordinates": [[[-117.48066, 33.91287], [-117.48064, 33.91295], [-117.47958, 33.9135], [-117.47841, 33.91207], [-117.47877, 33.91192], [-117.47881, 33.91196], [-117.47887, 33.91198], [-117.47899, 33.91197], [-117.47904, 33.91192], [-117.47912, 33.9118], [-117.4792, 33.91173], [-117.47953, 33.91154], [-117.47959, 33.91155], [-117.48066, 33.91287]]]} | Open Access 1 | 19855 | Collett Park | 17517 | 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.616 | Collett Park | 0 | Local Park 2 | 4 | |
865 | 865 | 864 | {"type": "Polygon", "coordinates": [[[-117.47581, 33.92126], [-117.47472, 33.92215], [-117.47441, 33.92183], [-117.47425, 33.92197], [-117.47407, 33.92174], [-117.47366, 33.9219], [-117.47364, 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.47461, 33.9208], [-117.47474, 33.92101], [-117.47538, 33.92068], [-117.47579, 33.92118], [-117.47581, 33.92126]]]} | Open Access 1 | 5587 | Myra Linn Park | 22619 | 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.868 | Myra Linn Park | 0 | Local Park 2 | 4 | |
2927 | 2927 | 2926 | {"type": "Polygon", "coordinates": [[[-117.46881, 33.95793], [-117.46871, 33.958], [-117.4678, 33.95805], [-117.46654, 33.95818], [-117.46577, 33.95822], [-117.46697, 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 | 19865 | Rutland Park | 24755 | 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 | 8.56 | Rutland Park | 0 | Local Park 2 | 4 | |
13161 | 13161 | 13160 | {"type": "Polygon", "coordinates": [[[-117.46674, 33.9428], [-117.46599, 33.9428], [-117.46595, 33.94279], [-117.46591, 33.94273], [-117.46591, 33.94235], [-117.46674, 33.94235], [-117.46674, 33.9428]]]} | Open Access 1 | 48820 | Arlanza Community Garden | 33539 | 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 | https://www.riversideca.gov/mayor/fitfreshfunriverside/community.asp | Riverside 10 | 0.937 | Arlanza Community Garden | 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 | |
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 | |
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 | |
2667 | 2667 | 2666 | {"type": "Polygon", "coordinates": [[[-117.44922, 33.92097], [-117.44787, 33.92173], [-117.4472, 33.9209], [-117.44883, 33.91998], [-117.44921, 33.92046], [-117.44896, 33.92062], [-117.44922, 33.92097]]]} | Open Access 1 | 18187 | Arlington Park | 15590 | 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.645 | Arlington Park | 0 | Local Park 2 | 4 | |
2926 | 2926 | 2925 | {"type": "Polygon", "coordinates": [[[-117.44729, 33.93129], [-117.44564, 33.93223], [-117.44557, 33.93222], [-117.44446, 33.93087], [-117.44445, 33.93083], [-117.44448, 33.9308], [-117.44622, 33.92979], [-117.44646, 33.93007], [-117.44651, 33.93028], [-117.44658, 33.93041], [-117.44729, 33.93129]]]} | Open Access 1 | 19857 | Don Lorenzi Sports Park | 18207 | 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 | 9.204 | Don Lorenzi Sports Park | 0 | Local Recreation Area 3 | 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 | |
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 | |
499 | 499 | 498 | {"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 | 2014 | Hunt Park | 20152 | 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 | 13.779 | Hunt Park | 0 | Local Park 2 | 4 | |
14846 | 14846 | 14845 | {"type": "Polygon", "coordinates": [[[-117.4311, 33.90173], [-117.43346, 33.90466], [-117.43347, 33.90469], [-117.43345, 33.90471], [-117.43013, 33.90662], [-117.43009, 33.90663], [-117.43006, 33.90661], [-117.42888, 33.90516], [-117.42945, 33.90482], [-117.42825, 33.90334], [-117.4311, 33.90173]]]} | Open Access 1 | 45361 | Arlington Heights Sports Park Picnic Area | 15588 | 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 | 34.333 | Arlington Heights Sports Park Picnic Area | 0 | Local Recreation Area 3 | 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 | |
1295 | 1295 | 1294 | {"type": "Polygon", "coordinates": [[[-117.42388, 33.91938], [-117.41909, 33.92211], [-117.41862, 33.92237], [-117.41949, 33.92047], [-117.41964, 33.92019], [-117.41975, 33.92002], [-117.42093, 33.91887], [-117.42114, 33.91856], [-117.42201, 33.91709], [-117.42388, 33.91938]]]} | Open Access 1 | 5722 | Don Derr Park | 18202 | 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.992 | Don Derr 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 | |
16913 | 16913 | 16912 | {"type": "Polygon", "coordinates": [[[-117.40859, 33.95923], [-117.40748, 33.95924], [-117.40747, 33.95732], [-117.40856, 33.95731], [-117.40858, 33.95876], [-117.4085, 33.95874], [-117.40842, 33.95875], [-117.40835, 33.9588], [-117.40833, 33.95886], [-117.40836, 33.95893], [-117.40842, 33.95898], [-117.4085, 33.95898], [-117.40858, 33.95896], [-117.40859, 33.95923]]]} | Open Access 1 | 19866 | Mountain View Park | 22558 | 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.233 | Mtn. View 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]);