units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
122 rows where MNG_AGENCY = 56 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
DES_TP 8
- Local Park 83
- Local Recreation Area 13
- 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |||
5425 | 5425 | 5424 | {"type": "Polygon", "coordinates": [[[-122.23869, 37.79974], [-122.23813, 37.80013], [-122.23755, 37.79959], [-122.23809, 37.79919], [-122.23869, 37.79974]]]} | Open Access 1 | 13302 | Bella Vista Park | 15981 | 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.284 | Bella Vista 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 | |
3499 | 3499 | 3498 | {"type": "Polygon", "coordinates": [[[-122.26527, 37.8064], [-122.26438, 37.80782], [-122.26436, 37.80783], [-122.26403, 37.80765], [-122.2639, 37.80756], [-122.26381, 37.80745], [-122.26359, 37.8071], [-122.26427, 37.806], [-122.26527, 37.8064]]]} | Open Access 1 | 13308 | Snow Park | 25584 | 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.988 | Snow 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 | |
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 |
1782 | 1782 | 1781 | {"type": "Polygon", "coordinates": [[[-122.2254, 37.79572], [-122.22488, 37.79726], [-122.2254, 37.79739], [-122.22534, 37.79752], [-122.22512, 37.79788], [-122.22476, 37.79824], [-122.22455, 37.79614], [-122.22445, 37.7959], [-122.22414, 37.79575], [-122.22369, 37.79573], [-122.22272, 37.79592], [-122.22233, 37.79614], [-122.22223, 37.79636], [-122.22215, 37.79767], [-122.2213, 37.79752], [-122.22212, 37.79528], [-122.22285, 37.79546], [-122.22296, 37.79513], [-122.2254, 37.79572]]]} | Open Access 1 | 13342 | Central Reservoir Park | 17073 | 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 | 9.124 | Central Reservoir Park | 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 | |
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 | |
5041 | 5041 | 5040 | {"type": "Polygon", "coordinates": [[[-122.23485, 37.78563], [-122.23432, 37.7862], [-122.23352, 37.78576], [-122.23411, 37.78532], [-122.23485, 37.78563]]]} | Open Access 1 | 13351 | Garfield Park | 19213 | 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.445 | Garfield Park | 0 | Local Park 2 | 4 | |
5048 | 5048 | 5047 | {"type": "Polygon", "coordinates": [[[-122.22637, 37.78087], [-122.226, 37.78126], [-122.22441, 37.78073], [-122.22462, 37.78033], [-122.22637, 37.78087]]]} | Open Access 1 | 13353 | Sanborn Park | 25005 | 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.969 | Sanborn Park | 2000 | Local Park 2 | 4 | |
3517 | 3517 | 3516 | {"type": "Polygon", "coordinates": [[[-122.21848, 37.77884], [-122.21773, 37.77981], [-122.21745, 37.77956], [-122.21813, 37.77872], [-122.21827, 37.77848], [-122.21752, 37.77811], [-122.2176, 37.778], [-122.21846, 37.77842], [-122.21848, 37.77884]]]} | Open Access 1 | 13356 | Cesar Chavez Park | 17097 | 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.518 | Cesar Chavez Park | 0 | Local Park 2 | 4 | |
8513 | 8513 | 8512 | {"type": "Polygon", "coordinates": [[[-122.2066, 37.78294], [-122.20591, 37.78344], [-122.20537, 37.78298], [-122.20506, 37.78319], [-122.20435, 37.78257], [-122.20519, 37.78169], [-122.2066, 37.78294]]]} | Open Access 1 | 13363 | BROOKDALE PARK | 16420 | 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.55 | BROOKDALE PARK | None 713 | |||
8514 | 8514 | 8513 | {"type": "Polygon", "coordinates": [[[-122.20043, 37.78154], [-122.19989, 37.78191], [-122.19929, 37.78137], [-122.19982, 37.781], [-122.20043, 37.78154]]]} | Open Access 1 | 13366 | Maxwell Park | 21971 | 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.249 | Maxwell Park | 2000 | 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]);