units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
122 rows where MNG_AGENCY = 56 sorted by GAP_STS
This data as json, copyable, CSV (advanced)
DES_TP 2
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1788 | 1788 | 1787 | {"type": "Polygon", "coordinates": [[[-122.24809, 37.82008], [-122.24766, 37.82045], [-122.2476, 37.82052], [-122.24759, 37.82057], [-122.24759, 37.82064], [-122.24762, 37.82071], [-122.24789, 37.8209], [-122.24764, 37.82114], [-122.24789, 37.82131], [-122.24701, 37.82157], [-122.24627, 37.82034], [-122.24623, 37.82029], [-122.2456, 37.81975], [-122.24606, 37.81933], [-122.24615, 37.81937], [-122.24623, 37.81953], [-122.24624, 37.81963], [-122.24631, 37.81966], [-122.24639, 37.81965], [-122.24642, 37.81961], [-122.24642, 37.81958], [-122.24638, 37.81953], [-122.24632, 37.81946], [-122.24627, 37.8194], [-122.24628, 37.81931], [-122.2466, 37.81952], [-122.24727, 37.81894], [-122.24761, 37.81918], [-122.24682, 37.81986], [-122.24699, 37.81996], [-122.2475, 37.81952], [-122.24784, 37.81976], [-122.24775, 37.81985], [-122.24809, 37.82008]]]} | Open Access 1 | 13453 | Morcom Rose Garden | 22472 | 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.464 | Morcom Rose Garden | 0 | Local Park 2 | 4 | |
2039 | 2039 | 2038 | {"type": "Polygon", "coordinates": [[[-122.28859, 37.81185], [-122.28813, 37.81311], [-122.28611, 37.81266], [-122.28528, 37.8123], [-122.28569, 37.81119], [-122.28859, 37.81185]]]} | Open Access 1 | 15570 | DeFremery Park | 18017 | 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.428 | DeFremery Park | 1910 | Local Park 2 | 4 | |
2050 | 2050 | 2049 | {"type": "Polygon", "coordinates": [[[-122.17764, 37.72612], [-122.17735, 37.72742], [-122.17733, 37.72744], [-122.17726, 37.72744], [-122.17601, 37.72728], [-122.17597, 37.72726], [-122.17595, 37.72723], [-122.1762, 37.72594], [-122.17764, 37.72612]]]} | Open Access 1 | 15614 | Sobrante Park | 25587 | 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.682 | Sobrante Park | 0 | Local Park 2 | 4 | |
2458 | 2458 | 2457 | {"type": "Polygon", "coordinates": [[[-122.17762, 37.76178], [-122.17531, 37.76327], [-122.17401, 37.76158], [-122.17408, 37.76156], [-122.17414, 37.76151], [-122.17415, 37.76144], [-122.17413, 37.76138], [-122.17405, 37.76132], [-122.17392, 37.76131], [-122.17367, 37.76098], [-122.17577, 37.75997], [-122.17762, 37.76178]]]} | Open Access 1 | 17382 | Arroyo Viejo Park | 15635 | 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 | 16.302 | Arroyo Viejo Park | 0 | Local Park 2 | 4 | |
2479 | 2479 | 2478 | {"type": "Polygon", "coordinates": [[[-122.28586, 37.80805], [-122.28546, 37.8093], [-122.28276, 37.80878], [-122.28328, 37.80749], [-122.28586, 37.80805]]]} | Open Access 1 | 17473 | Lowell Park | 21557 | 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 | 8.71 | Lowell Park | 0 | Local Park 2 | 4 | |
2633 | 2633 | 2632 | {"type": "Polygon", "coordinates": [[[-122.26189, 37.82383], [-122.26156, 37.82507], [-122.26052, 37.82483], [-122.25985, 37.82466], [-122.25897, 37.82438], [-122.25893, 37.82436], [-122.25891, 37.82431], [-122.25892, 37.82427], [-122.25984, 37.82279], [-122.26038, 37.82299], [-122.2614, 37.82321], [-122.2614, 37.8233], [-122.26143, 37.82338], [-122.26189, 37.82383]]]} | Open Access 1 | 18052 | Mosswood Park | 22516 | 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 | 10.31 | Mosswood Park | 1912 | Local Park 2 | 4 | |
3074 | 3074 | 3073 | {"type": "Polygon", "coordinates": [[[-122.21426, 37.79561], [-122.21378, 37.79679], [-122.21206, 37.79603], [-122.21209, 37.79595], [-122.21209, 37.79585], [-122.21199, 37.79538], [-122.21201, 37.79535], [-122.21252, 37.79484], [-122.21426, 37.79561]]]} | Open Access 1 | 24940 | Curt Flood Field | 17862 | 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.219 | Curt Flood Field | 0 | Local Recreation Area 3 | 4 | |
3293 | 3293 | 3292 | {"type": "MultiPolygon", "coordinates": [[[[-122.20851, 37.74554], [-122.20724, 37.74625], [-122.2072, 37.7462], [-122.20847, 37.7455], [-122.20851, 37.74554]]], [[[-122.21207, 37.75744], [-122.21203, 37.75781], [-122.20778, 37.75305], [-122.2081, 37.75293], [-122.20955, 37.75294], [-122.2107, 37.75286], [-122.21104, 37.75277], [-122.21142, 37.75331], [-122.2107, 37.75372], [-122.2105, 37.75392], [-122.21047, 37.75401], [-122.21048, 37.7541], [-122.21149, 37.75663], [-122.2116, 37.75682], [-122.21193, 37.75727], [-122.21207, 37.75744]]], [[[-122.20975, 37.74657], [-122.2097, 37.74657], [-122.20952, 37.74636], [-122.20955, 37.74634], [-122.20975, 37.74657]]], [[[-122.21108, 37.75075], [-122.21078, 37.75094], [-122.21058, 37.75037], [-122.21072, 37.75029], [-122.21108, 37.75075]]]]} | Open Access 1 | 29553 | Oakport Field | 23034 | 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 | 16.514 | Oakport Field | 0 | Local Recreation Area 3 | 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 | |
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 | |
3414 | 3414 | 3413 | {"type": "Polygon", "coordinates": [[[-122.28016, 37.80965], [-122.2799, 37.81031], [-122.27832, 37.80965], [-122.2787, 37.80906], [-122.28016, 37.80965]]]} | Open Access 1 | 13255 | Marston Campbell Park | 21899 | 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.772 | Marston Campbell Park | 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 | |
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 | |
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 | |
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 |
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 | |
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 | |
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 |
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]);