units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
122 rows where MNG_AGENCY = 56 sorted by SUID_NMA descending
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
DES_TP 9
- Local Park 99
- Local Recreation Area 16
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AG_TYP 1
- City Agency 122
MNG_AGENCY 1
- Oakland, City of · 122 ✖
ACCESS_TYP 1
- Open Access 122
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12591 | 12591 | 12590 | {"type": "Polygon", "coordinates": [[[-122.19359, 37.76393], [-122.19346, 37.76401], [-122.1932, 37.76376], [-122.19333, 37.76367], [-122.19359, 37.76393]]]} | Open Access 1 | 48775 | Tomas Melero-Smith Park | 33501 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | https://localwiki.org/oakland/Tomas_Melero-Smith_Park | Alameda 17 | 0.138 | Tomas Melero-Smith Park | 0 | Local Park 2 | 4 |
8392 | 8392 | 8391 | {"type": "Polygon", "coordinates": [[[-122.21593, 37.75709], [-122.21587, 37.75719], [-122.21495, 37.7577], [-122.21461, 37.75735], [-122.21469, 37.75729], [-122.21469, 37.75727], [-122.21417, 37.75663], [-122.21362, 37.75602], [-122.21439, 37.75561], [-122.21469, 37.75547], [-122.21492, 37.75552], [-122.21507, 37.75559], [-122.21511, 37.75569], [-122.21512, 37.75585], [-122.2152, 37.756], [-122.21541, 37.7561], [-122.21548, 37.75637], [-122.2157, 37.75655], [-122.21576, 37.75666], [-122.21556, 37.75671], [-122.2156, 37.75689], [-122.21593, 37.75709]]]} | Open Access 1 | 48489 | Soccer Field | 33200 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 6.246 | Soccer Field | 0 | Local Recreation Area 3 | 4 | |
8493 | 8493 | 8492 | {"type": "Polygon", "coordinates": [[[-122.27085, 37.79746], [-122.27066, 37.79776], [-122.27058, 37.79782], [-122.27046, 37.79786], [-122.27036, 37.79786], [-122.2702, 37.79782], [-122.26962, 37.79759], [-122.26993, 37.79709], [-122.27085, 37.79746]]]} | Open Access 1 | 13277 | Chinese Garden Park | 32515 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 1.324 | Chinese Garden Park | 0 | Local Park 2 | 4 | |
8498 | 8498 | 8497 | {"type": "Polygon", "coordinates": [[[-122.25379, 37.79435], [-122.25304, 37.79487], [-122.25235, 37.79427], [-122.2531, 37.79373], [-122.25379, 37.79435]]]} | Open Access 1 | 13293 | Clinton Park | 32504 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 1.998 | Clinton Park | 0 | Local Park 2 | 4 | |
11169 | 11169 | 11168 | {"type": "Polygon", "coordinates": [[[-122.25867, 37.81866], [-122.25819, 37.81906], [-122.25812, 37.81906], [-122.25805, 37.81891], [-122.25791, 37.81879], [-122.25839, 37.81849], [-122.25867, 37.81866]]]} | Open Access 1 | 47999 | Oak Park | 32421 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 0.493 | Oak Park | 0 | Local Park 2 | 4 | |
14804 | 14804 | 14803 | {"type": "Polygon", "coordinates": [[[-122.30253, 37.80789], [-122.30246, 37.8081], [-122.3024, 37.80817], [-122.30212, 37.80803], [-122.30219, 37.80782], [-122.30253, 37.80789]]]} | Open Access 1 | 47998 | Bertha Port Park | 32420 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 0.218 | Bertha Port Park | 0 | Local Park 2 | 4 | |
11168 | 11168 | 11167 | {"type": "Polygon", "coordinates": [[[-122.33381, 37.80525], [-122.33311, 37.80588], [-122.33301, 37.80592], [-122.33295, 37.80585], [-122.3326, 37.80603], [-122.33238, 37.80574], [-122.33272, 37.80548], [-122.33265, 37.80541], [-122.33289, 37.80523], [-122.33297, 37.80522], [-122.33381, 37.80525]]]} | Open Access 1 | 47997 | Port View Park | 32419 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 1.429 | Port View Park | 0 | Local Park 2 | 4 | |
11167 | 11167 | 11166 | {"type": "Polygon", "coordinates": [[[-122.26122, 37.83814], [-122.26105, 37.83823], [-122.26092, 37.83834], [-122.26066, 37.83815], [-122.26104, 37.83796], [-122.26109, 37.83798], [-122.26122, 37.83814]]]} | Open Access 1 | 47996 | Redondo Park | 32418 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 0.25 | Redondo Park | 0 | Local Park 2 | 4 | |
11166 | 11166 | 11165 | {"type": "Polygon", "coordinates": [[[-122.2686, 37.84295], [-122.26834, 37.843], [-122.26827, 37.84298], [-122.26793, 37.84302], [-122.26779, 37.84237], [-122.26814, 37.84232], [-122.2682, 37.84224], [-122.26821, 37.84226], [-122.26845, 37.84222], [-122.2686, 37.84295]]]} | Open Access 1 | 47995 | Dover Street Park | 32417 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | https://www.oaklandca.gov/services/find-a-parks-and-recreation-location | Alameda 17 | 1.139 | Dover Street Park | 0 | Local Park 2 | 4 |
16975 | 16975 | 16974 | {"type": "Polygon", "coordinates": [[[-122.18787, 37.79778], [-122.18784, 37.7984], [-122.18755, 37.79839], [-122.18753, 37.79873], [-122.18703, 37.7987], [-122.18697, 37.79866], [-122.18687, 37.79848], [-122.18679, 37.79843], [-122.18663, 37.79838], [-122.18627, 37.79833], [-122.18608, 37.79825], [-122.18738, 37.79737], [-122.18754, 37.79737], [-122.18752, 37.79777], [-122.18787, 37.79778]]]} | Open Access 1 | 13397 | Redwoods Heights Recreation Center | 30896 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/s/facility/OAK029394 | Alameda 17 | 3.1 | Redwoods Heights Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
15790 | 15790 | 15789 | {"type": "Polygon", "coordinates": [[[-122.2005, 37.76573], [-122.19965, 37.76633], [-122.19929, 37.766], [-122.20001, 37.7655], [-122.2005, 37.76573]]]} | Open Access 1 | 13369 | Rainbow Recreation Center | 30895 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/s/facility/OAK029393 | Alameda 17 | 1.112 | Rainbow Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
3569 | 3569 | 3568 | {"type": "Polygon", "coordinates": [[[-122.22826, 37.7939], [-122.22801, 37.79472], [-122.22759, 37.79463], [-122.22784, 37.79382], [-122.22826, 37.7939]]]} | Open Access 1 | 13339 | Manzanita Recreation Center | 30894 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/s/facility/OAK029390 | Alameda 17 | 0.877 | Manzanita Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
8508 | 8508 | 8507 | {"type": "Polygon", "coordinates": [[[-122.22078, 37.79608], [-122.22051, 37.79683], [-122.22041, 37.79692], [-122.22031, 37.7974], [-122.22024, 37.79743], [-122.22009, 37.79765], [-122.21975, 37.79758], [-122.21968, 37.79721], [-122.21964, 37.79663], [-122.21998, 37.79527], [-122.22062, 37.79541], [-122.2205, 37.79586], [-122.22062, 37.79602], [-122.22078, 37.79608]]]} | Open Access 1 | 13345 | Wood Park | 27677 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 4.197 | Wood Park | 0 | Local Park 2 | 4 | |
8496 | 8496 | 8495 | {"type": "Polygon", "coordinates": [[[-122.29695, 37.81202], [-122.29654, 37.81255], [-122.29589, 37.81221], [-122.29631, 37.8117], [-122.29695, 37.81202]]]} | Open Access 1 | 13268 | Willow Mini Park | 27580 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 1.135 | Willow MP | 0 | Local Park 2 | 4 | |
1780 | 1780 | 1779 | {"type": "Polygon", "coordinates": [[[-122.29076, 37.80888], [-122.29052, 37.80959], [-122.28941, 37.8093], [-122.28911, 37.80883], [-122.28908, 37.8086], [-122.28911, 37.80855], [-122.29076, 37.80888]]]} | Open Access 1 | 13270 | Wade Johnson Park | 27206 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 2.538 | Wade Johnson Park | 0 | Local Park 2 | 4 | |
8519 | 8519 | 8518 | {"type": "Polygon", "coordinates": [[[-122.16384, 37.74928], [-122.16303, 37.74965], [-122.162, 37.74825], [-122.1628, 37.74788], [-122.16384, 37.74928]]]} | Open Access 1 | 13381 | Verdese Carter Park | 26987 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 3.66 | Verdese Carter Park | 0 | Local Park 2 | 4 | |
8501 | 8501 | 8500 | {"type": "Polygon", "coordinates": [[[-122.24847, 37.78886], [-122.24842, 37.78889], [-122.24833, 37.78889], [-122.24828, 37.78891], [-122.24824, 37.78895], [-122.24822, 37.78904], [-122.24818, 37.78906], [-122.24776, 37.78869], [-122.24771, 37.78862], [-122.24765, 37.78857], [-122.24765, 37.78854], [-122.24769, 37.78853], [-122.24778, 37.78857], [-122.24847, 37.78886]]]} | Open Access 1 | 13314 | Vantage Point Park | 26835 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 0.344 | Vantage Point Park | 0 | Local Park 2 | 4 | |
9347 | 9347 | 9346 | {"type": "Polygon", "coordinates": [[[-122.24302, 37.7783], [-122.24243, 37.77844], [-122.24214, 37.77811], [-122.24164, 37.77775], [-122.24135, 37.7775], [-122.24112, 37.77728], [-122.24103, 37.77711], [-122.24097, 37.77684], [-122.24088, 37.77608], [-122.24078, 37.7759], [-122.24068, 37.77574], [-122.24051, 37.77558], [-122.24033, 37.77544], [-122.24011, 37.77533], [-122.24009, 37.7752], [-122.24014, 37.77518], [-122.24056, 37.77518], [-122.24113, 37.77573], [-122.24171, 37.77601], [-122.24177, 37.77608], [-122.24185, 37.77621], [-122.24188, 37.77644], [-122.24189, 37.77673], [-122.24292, 37.77808], [-122.24302, 37.7783]]]} | Open Access 1 | 15616 | Union Point Park | 26659 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 6.705 | Union Point Park | 0 | Local Park 2 | 4 | |
3404 | 3404 | 3403 | {"type": "Polygon", "coordinates": [[[-122.28292, 37.82599], [-122.2825, 37.82589], [-122.28278, 37.82555], [-122.28278, 37.82555], [-122.28292, 37.82599]]]} | Open Access 1 | 13249 | Union Plaza | 26658 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 0.211 | Union Plaza | 0 | Local Park 2 | 4 | |
8518 | 8518 | 8517 | {"type": "Polygon", "coordinates": [[[-122.18525, 37.75116], [-122.18468, 37.75144], [-122.18392, 37.75049], [-122.18413, 37.75039], [-122.1842, 37.75049], [-122.18452, 37.75036], [-122.1848, 37.75073], [-122.1849, 37.75069], [-122.18525, 37.75116]]]} | Open Access 1 | 13379 | Tassafaronga Park | 26193 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 1.613 | Tassafaronga 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]);