units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
122 rows where MNG_AGENCY = 56
This data as json, copyable, CSV (advanced)
DES_TP 8
- Local Park 65
- Local Recreation Area 11
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AG_TYP 1
- City Agency 82
MNG_AGENCY 1
- Oakland, City of · 82 ✖
ACCESS_TYP 1
- Open Access 82
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6708 | 6708 | 6707 | {"type": "Polygon", "coordinates": [[[-122.26514, 37.84588], [-122.26212, 37.84635], [-122.2619, 37.84545], [-122.26325, 37.84525], [-122.26317, 37.84488], [-122.26367, 37.84481], [-122.26377, 37.84516], [-122.26393, 37.84514], [-122.26385, 37.84478], [-122.26406, 37.84475], [-122.26411, 37.84511], [-122.26424, 37.8451], [-122.2642, 37.84473], [-122.26447, 37.84468], [-122.26453, 37.84505], [-122.26502, 37.84498], [-122.26514, 37.84588]]]} | Open Access 1 | 5003 | Bushrod Recreation Center | 16540 | 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 | 7.761 | Bushrod Rec. Ctr. | 1910 | Local Recreation Area 3 | 4 | |
7449 | 7449 | 7448 | {"type": "Polygon", "coordinates": [[[-122.27229, 37.81853], [-122.27223, 37.81886], [-122.27181, 37.81879], [-122.2719, 37.81848], [-122.27229, 37.81853]]]} | Open Access 1 | 13447 | Durant Mini Park | 18311 | 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.32 | Durant 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 | |
8131 | 8131 | 8130 | {"type": "Polygon", "coordinates": [[[-122.30053, 37.80331], [-122.30039, 37.80354], [-122.29548, 37.80242], [-122.29654, 37.80233], [-122.29877, 37.80267], [-122.30053, 37.80331]]]} | Open Access 1 | 13451 | South Prescott Park | 25676 | 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.269 | South Prescott 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 | |
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 | |
8489 | 8489 | 8488 | {"type": "Polygon", "coordinates": [[[-122.2501, 37.80035], [-122.24956, 37.80053], [-122.24965, 37.8007], [-122.24926, 37.80087], [-122.24894, 37.80105], [-122.24884, 37.80108], [-122.24865, 37.80111], [-122.2485, 37.80048], [-122.24885, 37.80041], [-122.24923, 37.80031], [-122.25006, 37.80024], [-122.2501, 37.80035]]]} | Open Access 1 | 13299 | F. M. SMITH PARK | 18780 | 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.691 | F. M. SMITH PARK | None 710 | |||
8492 | 8492 | 8491 | {"type": "Polygon", "coordinates": [[[-122.26763, 37.79791], [-122.26733, 37.7984], [-122.26639, 37.79803], [-122.2667, 37.79755], [-122.26763, 37.79791]]]} | Open Access 1 | 13274 | Madison Square | 21660 | 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.377 | Madison Square | 0 | Local Park 2 | 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 | |
8494 | 8494 | 8493 | {"type": "Polygon", "coordinates": [[[-122.26277, 37.79503], [-122.26265, 37.79521], [-122.26225, 37.79504], [-122.26118, 37.79682], [-122.25982, 37.79631], [-122.25937, 37.79601], [-122.25689, 37.79375], [-122.25807, 37.79295], [-122.25956, 37.79323], [-122.26015, 37.79275], [-122.26028, 37.79248], [-122.26063, 37.79208], [-122.2611, 37.792], [-122.26168, 37.79229], [-122.26185, 37.79209], [-122.26272, 37.79287], [-122.26204, 37.79397], [-122.26183, 37.79427], [-122.26277, 37.79503]]]} | Open Access 1 | 13280 | Channel Park | 17121 | 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 | 37.379 | Channel Park | 0 | Local Park 2 | 4 | |
8495 | 8495 | 8494 | {"type": "Polygon", "coordinates": [[[-122.26083, 37.79699], [-122.26049, 37.79764], [-122.26059, 37.79773], [-122.26034, 37.79816], [-122.25893, 37.7976], [-122.25923, 37.79743], [-122.25918, 37.79672], [-122.25933, 37.79648], [-122.25931, 37.79641], [-122.25951, 37.7963], [-122.25963, 37.79638], [-122.25965, 37.7965], [-122.26083, 37.79699]]]} | Open Access 1 | 13283 | Peralta Park | 23606 | 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.691 | Peralta 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 | |
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 | |
8499 | 8499 | 8498 | {"type": "Polygon", "coordinates": [[[-122.24868, 37.79278], [-122.24791, 37.79333], [-122.24715, 37.79266], [-122.24792, 37.79211], [-122.24868, 37.79278]]]} | Open Access 1 | 13296 | Franklin Park | 19063 | 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.248 | Franklin Park | 0 | Local Park 2 | 4 | |
8500 | 8500 | 8499 | {"type": "MultiPolygon", "coordinates": [[[[-122.26828, 37.82304], [-122.26803, 37.82378], [-122.2678, 37.82373], [-122.26765, 37.82361], [-122.26722, 37.82337], [-122.26718, 37.82326], [-122.26743, 37.82313], [-122.26754, 37.82287], [-122.26828, 37.82304]]], [[[-122.26978, 37.82379], [-122.26952, 37.8249], [-122.26929, 37.82574], [-122.26889, 37.82573], [-122.26877, 37.82583], [-122.26874, 37.82598], [-122.26863, 37.82624], [-122.26834, 37.82621], [-122.26843, 37.82585], [-122.26847, 37.82562], [-122.26845, 37.82533], [-122.26847, 37.8252], [-122.26902, 37.82323], [-122.2697, 37.82339], [-122.26961, 37.82374], [-122.26978, 37.82379]]]]} | Open Access 1 | 13311 | Grove Shafter | 19535 | 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 | 7.028 | Grove Shafter | None 711 | |||
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 | |
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 | |
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 | |
8509 | 8509 | 8508 | {"type": "Polygon", "coordinates": [[[-122.13519, 37.73486], [-122.13502, 37.73508], [-122.13467, 37.73497], [-122.13464, 37.73502], [-122.1337, 37.73467], [-122.13363, 37.73477], [-122.13324, 37.73463], [-122.13349, 37.73412], [-122.13443, 37.73429], [-122.13485, 37.73432], [-122.13486, 37.7344], [-122.135, 37.73447], [-122.13483, 37.7347], [-122.13519, 37.73486]]]} | Open Access 1 | 13406 | Sheffield Village Park | 25383 | 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.443 | Sheffield Village Park | 0 | Local Park 2 | 4 | |
8510 | 8510 | 8509 | {"type": "Polygon", "coordinates": [[[-122.21827, 37.78703], [-122.21759, 37.78792], [-122.21721, 37.78773], [-122.21707, 37.78791], [-122.21677, 37.78776], [-122.21692, 37.78758], [-122.21691, 37.78755], [-122.21686, 37.78754], [-122.21679, 37.78753], [-122.21672, 37.78756], [-122.21668, 37.78759], [-122.21633, 37.78742], [-122.21601, 37.78783], [-122.21591, 37.78778], [-122.21611, 37.78751], [-122.21583, 37.78727], [-122.2161, 37.78707], [-122.21607, 37.78703], [-122.21647, 37.78673], [-122.21639, 37.78664], [-122.21667, 37.78643], [-122.21682, 37.78655], [-122.21684, 37.78653], [-122.21697, 37.78659], [-122.21684, 37.78678], [-122.21734, 37.78702], [-122.2176, 37.7867], [-122.21827, 37.78703]]]} | Open Access 1 | 13348 | Peralta Hacienda Park | 23605 | 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.497 | Peralta Hacienda 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]);