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 61
- Local Recreation Area 14
- None 1
- 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
3585 | 3585 | 3584 | {"type": "Polygon", "coordinates": [[[-122.29309, 37.81022], [-122.29302, 37.81041], [-122.29246, 37.81028], [-122.29225, 37.81086], [-122.29188, 37.81077], [-122.29186, 37.81081], [-122.29176, 37.81079], [-122.29189, 37.81038], [-122.29198, 37.80998], [-122.29309, 37.81022]]]} | Open Access 1 | 29165 | Cypress Freeway Memorial Park | 17873 | 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.278 | Cypress Freeway Memorial Park | 0 | Local Park 2 | 4 | |
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 | |
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 | |
1779 | 1779 | 1778 | {"type": "Polygon", "coordinates": [[[-122.27241, 37.80487], [-122.27205, 37.80548], [-122.27156, 37.80529], [-122.27141, 37.80474], [-122.27152, 37.80454], [-122.27241, 37.80487]]]} | Open Access 1 | 13266 | City Hall Plaza | 17298 | 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.331 | City Hall Plaza | 0 | Local Park 2 | 4 | |
1778 | 1778 | 1777 | {"type": "Polygon", "coordinates": [[[-122.27921, 37.80074], [-122.2789, 37.80123], [-122.27797, 37.80087], [-122.27828, 37.80037], [-122.27921, 37.80074]]]} | Open Access 1 | 13264 | Jefferson Square | 20383 | 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.376 | Jefferson Square | 0 | Local Park 2 | 4 | |
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 | |
1781 | 1781 | 1780 | {"type": "Polygon", "coordinates": [[[-122.26913, 37.80021], [-122.26883, 37.8007], [-122.26789, 37.80033], [-122.2682, 37.79984], [-122.26913, 37.80021]]]} | Open Access 1 | 13272 | Lincoln Square | 21275 | 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.384 | Lincoln Square | 0 | Local Park 2 | 4 | |
3415 | 3415 | 3414 | {"type": "Polygon", "coordinates": [[[-122.27749, 37.80349], [-122.27719, 37.80399], [-122.27626, 37.80362], [-122.27656, 37.80312], [-122.27749, 37.80349]]]} | Open Access 1 | 13257 | Lafayette Square | 20833 | 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.388 | Lafayette Square | 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 | |
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 | |
14644 | 14644 | 14643 | {"type": "Polygon", "coordinates": [[[-122.25431, 37.80143], [-122.25437, 37.80161], [-122.25436, 37.80178], [-122.25413, 37.80225], [-122.25409, 37.80231], [-122.254, 37.80238], [-122.25392, 37.80242], [-122.2538, 37.80244], [-122.2537, 37.80244], [-122.2536, 37.80242], [-122.25338, 37.8023], [-122.25319, 37.80214], [-122.25379, 37.80196], [-122.25365, 37.80159], [-122.25431, 37.80143]]]} | Open Access 1 | 44892 | Pine Knoll Park | 23681 | 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.509 | Pine Knoll Park | 0 | 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 | |
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 | |
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 | |||
9188 | 9188 | 9187 | {"type": "Polygon", "coordinates": [[[-122.26214, 37.81105], [-122.26189, 37.81169], [-122.26104, 37.81169], [-122.2609, 37.81082], [-122.26151, 37.81091], [-122.26214, 37.81105]]]} | Open Access 1 | 15254 | Adams Park | 15262 | 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.952 | Adams 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 | |
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 | |
8526 | 8526 | 8525 | {"type": "Polygon", "coordinates": [[[-122.17538, 37.74328], [-122.17464, 37.74363], [-122.17402, 37.74281], [-122.17476, 37.74246], [-122.17538, 37.74328]]]} | Open Access 1 | 13385 | Elmhurst Plaza | 18598 | 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.01 | Elmhurst Plaza | 0 | Local Park 2 | 4 | |
3413 | 3413 | 3412 | {"type": "Polygon", "coordinates": [[[-122.28464, 37.82278], [-122.28462, 37.82284], [-122.2835, 37.82424], [-122.2833, 37.82419], [-122.28387, 37.82261], [-122.28464, 37.82278]]]} | Open Access 1 | 13252 | Poplar Park | 23893 | 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.036 | Poplar 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]);