units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
122 rows where MNG_AGENCY = 56 sorted by ACRES
This data as json, copyable, CSV (advanced)
DES_TP 9
- Local Park 79
- Local Recreation Area 16
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AG_TYP 1
- City Agency 102
MNG_AGENCY 1
- Oakland, City of · 102 ✖
ACCESS_TYP 1
- Open Access 102
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8522 | 8522 | 8521 | {"type": "Polygon", "coordinates": [[[-122.25792, 37.84756], [-122.2579, 37.8476], [-122.25786, 37.84762], [-122.25741, 37.84767], [-122.25737, 37.84765], [-122.25735, 37.84762], [-122.25734, 37.84745], [-122.25736, 37.84742], [-122.2574, 37.8474], [-122.25781, 37.84735], [-122.25789, 37.84739], [-122.25792, 37.84756]]]} | Open Access 1 | 13441 | Colby Park | 17479 | 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.357 | Colby Park | 0 | Local Park 2 | 4 | |
9353 | 9353 | 9352 | {"type": "Polygon", "coordinates": [[[-122.27275, 37.81463], [-122.27269, 37.81501], [-122.27229, 37.81496], [-122.27236, 37.81458], [-122.27275, 37.81463]]]} | Open Access 1 | 15617 | 25th St. Mini Park | 15188 | 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.375 | 25th St. MP | 0 | Local Park 2 | 4 | |
7466 | 7466 | 7465 | {"type": "Polygon", "coordinates": [[[-122.17152, 37.75333], [-122.17114, 37.7535], [-122.17092, 37.75318], [-122.1713, 37.75301], [-122.17152, 37.75333]]]} | Open Access 1 | 15669 | 88th Avenue Mini Park | 15218 | 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.384 | 88th Avenue MP | 0 | Local Park 2 | 4 | |
4211 | 4211 | 4210 | {"type": "Polygon", "coordinates": [[[-122.20516, 37.78073], [-122.20486, 37.78088], [-122.20461, 37.78104], [-122.2045, 37.78112], [-122.20436, 37.781], [-122.20469, 37.78076], [-122.20493, 37.78052], [-122.20516, 37.78073]]]} | Open Access 1 | 44961 | Courtland Creek Park | 17721 | 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.386 | Courtland Creek Park | 0 | Local Park 2 | 4 | |
9327 | 9327 | 9326 | {"type": "Polygon", "coordinates": [[[-122.27638, 37.8329], [-122.27622, 37.83345], [-122.2759, 37.83342], [-122.27602, 37.83283], [-122.27638, 37.8329]]]} | Open Access 1 | 15550 | Linden Park | 21291 | 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 | Linden 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 | |
9243 | 9243 | 9242 | {"type": "Polygon", "coordinates": [[[-122.17895, 37.73253], [-122.17879, 37.73285], [-122.17879, 37.73286], [-122.17869, 37.73296], [-122.17862, 37.73298], [-122.17826, 37.73236], [-122.17857, 37.73236], [-122.17895, 37.73253]]]} | Open Access 1 | 15521 | Carney Park | 16886 | 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.559 | Carney Park | 0 | Local Park 2 | 4 | |
8503 | 8503 | 8502 | {"type": "Polygon", "coordinates": [[[-122.23046, 37.79398], [-122.22987, 37.79467], [-122.22967, 37.79455], [-122.23012, 37.79384], [-122.23046, 37.79398]]]} | Open Access 1 | 13320 | Morgan Plaza | 22485 | 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.618 | Morgan Plaza | 0 | Local Park 2 | 4 | |
9323 | 9323 | 9322 | {"type": "Polygon", "coordinates": [[[-122.23661, 37.77791], [-122.23654, 37.778], [-122.23636, 37.77796], [-122.23613, 37.77797], [-122.23591, 37.77781], [-122.23608, 37.77763], [-122.23613, 37.77763], [-122.23621, 37.77755], [-122.23628, 37.77758], [-122.23632, 37.77753], [-122.23641, 37.77755], [-122.23641, 37.77744], [-122.23638, 37.77738], [-122.23634, 37.77717], [-122.23639, 37.7772], [-122.23649, 37.77735], [-122.23657, 37.77754], [-122.23661, 37.77771], [-122.23661, 37.77791]]]} | Open Access 1 | 15543 | Kennedy Tract Park | 20606 | 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.667 | Kennedy Tract Park | 0 | Local Park 2 | 4 | |
9346 | 9346 | 9345 | {"type": "Polygon", "coordinates": [[[-122.24828, 37.81065], [-122.24821, 37.81073], [-122.24813, 37.81081], [-122.24789, 37.81123], [-122.24786, 37.81123], [-122.2478, 37.81119], [-122.2476, 37.81094], [-122.24755, 37.81081], [-122.24751, 37.81058], [-122.24749, 37.81051], [-122.24738, 37.81039], [-122.24747, 37.81042], [-122.24776, 37.81058], [-122.24792, 37.81064], [-122.24804, 37.81067], [-122.24828, 37.81065]]]} | Open Access 1 | 15615 | Splash Pad Park | 25726 | 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.705 | Splash Pad Park | 0 | Local Park 2 | 4 | |
8478 | 8478 | 8477 | {"type": "Polygon", "coordinates": [[[-122.25812, 37.842], [-122.25806, 37.84208], [-122.25715, 37.84239], [-122.25706, 37.84226], [-122.25722, 37.84209], [-122.25728, 37.84206], [-122.25741, 37.8419], [-122.25746, 37.84176], [-122.25754, 37.8418], [-122.2576, 37.84174], [-122.25812, 37.842]]]} | Open Access 1 | 13443 | Hardy Dog Park | 19677 | 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.788 | Hardy Dog Park | 0 | Local Park 2 | 4 | |
3498 | 3498 | 3497 | {"type": "Polygon", "coordinates": [[[-122.24759, 37.80067], [-122.24699, 37.80102], [-122.24645, 37.80127], [-122.24607, 37.80138], [-122.24606, 37.80136], [-122.24737, 37.80046], [-122.24759, 37.80067]]]} | Open Access 1 | 13305 | Park Boulevard Plaza Park | 23426 | 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.789 | Park Boulevard Plaza Park | 0 | Local Park 2 | 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 |
8545 | 8545 | 8544 | {"type": "MultiPolygon", "coordinates": [[[[-122.25241, 37.82454], [-122.25213, 37.82477], [-122.25186, 37.82458], [-122.25215, 37.82436], [-122.25241, 37.82454]]], [[[-122.25329, 37.82402], [-122.25266, 37.82457], [-122.25238, 37.82435], [-122.25268, 37.82406], [-122.25275, 37.82413], [-122.25309, 37.82386], [-122.25329, 37.82402]]]]} | Open Access 1 | 13466 | Glen Echo Park | 19320 | 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.896 | Glen Echo Park | 0 | Local Park 2 | 4 | |
9308 | 9308 | 9307 | {"type": "Polygon", "coordinates": [[[-122.19271, 37.80049], [-122.19222, 37.80069], [-122.19223, 37.80074], [-122.19163, 37.80082], [-122.19163, 37.8007], [-122.19166, 37.80061], [-122.19171, 37.80053], [-122.19181, 37.80044], [-122.19203, 37.80032], [-122.19249, 37.80017], [-122.19271, 37.80049]]]} | Open Access 1 | 15515 | Avenue Terrance Park | 15726 | 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.925 | Avenue Terrance Park | 0 | Local Park 2 | 4 | |
12102 | 12102 | 12101 | {"type": "Polygon", "coordinates": [[[-122.25489, 37.79992], [-122.25459, 37.80007], [-122.25445, 37.80018], [-122.25432, 37.80033], [-122.25428, 37.80035], [-122.25424, 37.80034], [-122.25395, 37.80025], [-122.25392, 37.80021], [-122.25392, 37.80017], [-122.25439, 37.79946], [-122.25489, 37.7999], [-122.25489, 37.79992]]]} | Open Access 1 | 24941 | Athol Plaza Park | 15669 | 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.009 | Athol Plaza Park | 0 | Local Park 2 | 4 | |
8529 | 8529 | 8528 | {"type": "Polygon", "coordinates": [[[-122.19977, 37.82048], [-122.19935, 37.82095], [-122.19938, 37.82098], [-122.19928, 37.82103], [-122.19889, 37.82132], [-122.19882, 37.82144], [-122.19875, 37.82171], [-122.19871, 37.82178], [-122.19864, 37.82183], [-122.19856, 37.82187], [-122.19847, 37.82189], [-122.19843, 37.82188], [-122.19842, 37.82184], [-122.19854, 37.82149], [-122.19859, 37.8214], [-122.19871, 37.82126], [-122.19894, 37.8211], [-122.19907, 37.82097], [-122.19915, 37.82085], [-122.19933, 37.82044], [-122.19942, 37.82031], [-122.19945, 37.82028], [-122.19977, 37.82048]]]} | Open Access 1 | 13395 | Sulfur Springs Park | 25947 | 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.101 | Sulfur Springs Park | 0 | Local Park 2 | 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 |
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 | |
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 |
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]);