units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
61 rows where MNG_AGENCY = 185 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_WEB, LAYER, LABEL_NAME, YR_EST, GAP_STS
DES_TP 4
AGNCY_TYP 2 ✖
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 61
MNG_AGENCY 1
- Riverside, City of · 61 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12122 | 12122 | 12121 | {"type": "Polygon", "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]]]} | Open Access 1 | 25073 | Newman Park | 22730 | 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 | 0.423 | Newman Park | 0 | Local Park 2 | 4 | |
3799 | 3799 | 3798 | {"type": "Polygon", "coordinates": [[[-117.33029, 33.96071], [-117.33022, 33.96079], [-117.32984, 33.96073], [-117.32966, 33.96063], [-117.32972, 33.96057], [-117.32972, 33.96049], [-117.33009, 33.96027], [-117.33022, 33.96031], [-117.33029, 33.96071]]]} | Open Access 1 | 48819 | Kensington Pocket Park | 33538 | 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/park_rec/sites/riversideca.gov.park_rec/files/pdf/Riverside%20Parks_0.pdf | Riverside 10 | 0.541 | Kensington PP | 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 |
11998 | 11998 | 11997 | {"type": "Polygon", "coordinates": [[[-117.35595, 33.94831], [-117.35569, 33.94856], [-117.35559, 33.94867], [-117.35535, 33.9482], [-117.35525, 33.94793], [-117.3552, 33.94765], [-117.35516, 33.94725], [-117.35516, 33.94704], [-117.3554, 33.94761], [-117.35551, 33.94783], [-117.35569, 33.94807], [-117.35595, 33.94831]]]} | Open Access 1 | 24656 | Swanson Park | 26096 | 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.029 | Swanson 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 | |
746 | 746 | 745 | {"type": "MultiPolygon", "coordinates": [[[[-117.40095, 33.94777], [-117.40071, 33.94777], [-117.40025, 33.94777], [-117.40041, 33.94751], [-117.40046, 33.94749], [-117.40093, 33.94769], [-117.40095, 33.94772], [-117.40095, 33.94777]]], [[[-117.40082, 33.94629], [-117.40073, 33.94643], [-117.40029, 33.94713], [-117.40029, 33.94672], [-117.40046, 33.94671], [-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 | 4842 | Low Park | 21552 | 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.258 | Low 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 | |
4068 | 4068 | 4067 | {"type": "Polygon", "coordinates": [[[-117.39209, 33.98971], [-117.39155, 33.99036], [-117.39049, 33.99022], [-117.3899, 33.99009], [-117.39089, 33.98988], [-117.39165, 33.98966], [-117.39171, 33.98965], [-117.39171, 33.98967], [-117.39188, 33.98967], [-117.39209, 33.98971]]]} | Open Access 1 | 44442 | Carlson Park | 16863 | 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.898 | Carlson Park | 0 | Local Park 2 | 4 | |
776 | 776 | 775 | {"type": "Polygon", "coordinates": [[[-117.3806, 33.97735], [-117.38008, 33.97814], [-117.37913, 33.97771], [-117.37967, 33.97692], [-117.3806, 33.97735]]]} | Open Access 1 | 5730 | Newman Park | 22730 | 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 | 2.463 | Newman Park | 0 | Local Park 2 | 4 | |
11339 | 11339 | 11338 | {"type": "Polygon", "coordinates": [[[-117.38677, 33.98911], [-117.3867, 33.98967], [-117.38581, 33.98929], [-117.38579, 33.98931], [-117.38569, 33.98922], [-117.38557, 33.98916], [-117.38574, 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.98851], [-117.38566, 33.98844], [-117.38571, 33.98842], [-117.3858, 33.98848], [-117.38614, 33.9886], [-117.38634, 33.98871], [-117.38649, 33.98882], [-117.38677, 33.98911]]]} | Open Access 1 | 22122 | Loring Park | 21469 | 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 | 2.464 | Loring Park | 0 | Local Park 2 | 4 | |
875 | 875 | 874 | {"type": "Polygon", "coordinates": [[[-117.36909, 33.97328], [-117.36858, 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 | 5696 | Lincoln Park | 21269 | 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 | 3.27 | Lincoln 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 | |
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 | |
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 | |
11996 | 11996 | 11995 | {"type": "Polygon", "coordinates": [[[-117.3249, 33.88653], [-117.32405, 33.88669], [-117.32397, 33.8864], [-117.32373, 33.88644], [-117.3233, 33.88487], [-117.32336, 33.88494], [-117.32345, 33.88497], [-117.32371, 33.88491], [-117.32477, 33.8849], [-117.3248, 33.88491], [-117.32467, 33.88518], [-117.32464, 33.88533], [-117.32463, 33.88553], [-117.32465, 33.88565], [-117.3249, 33.88653]]]} | Open Access 1 | 24654 | Bergmont Park | 16021 | 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.031 | Bergmont 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 | |
14471 | 14471 | 14470 | {"type": "Polygon", "coordinates": [[[-117.32246, 33.95383], [-117.32245, 33.95457], [-117.32188, 33.95454], [-117.32112, 33.95458], [-117.32047, 33.95466], [-117.31985, 33.95479], [-117.31984, 33.95381], [-117.32246, 33.95383]]]} | Open Access 1 | 47101 | Ameal Moore Nature Center | 30760 | 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.254 | Ameal Moore Nature Ctr. | 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 | |
11343 | 11343 | 11342 | {"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.3277, 33.98746], [-117.32743, 33.98734], [-117.32717, 33.98729], [-117.32643, 33.98724], [-117.3264, 33.98721], [-117.32641, 33.9867], [-117.32646, 33.98666], [-117.32677, 33.98666], [-117.32678, 33.98701], [-117.3289, 33.98699], [-117.32899, 33.98724], [-117.32964, 33.98699], [-117.33014, 33.98755]]]} | Open Access 1 | 22123 | Highland Park | 19934 | 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.558 | Highland 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 |
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]);