superunits_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)
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2288 | 2288 | 2287 | {"type": "Polygon", "coordinates": [[[-122.21848, 37.77884], [-122.21773, 37.77981], [-122.21745, 37.77956], [-122.21813, 37.77872], [-122.21826, 37.77849], [-122.21752, 37.77811], [-122.2176, 37.778], [-122.21846, 37.77842], [-122.21848, 37.77884]]]} | Open Access 1 | Cesar Chavez Park | 17097 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1.525 | Cesar Chavez Park | ||
2375 | 2375 | 2374 | {"type": "Polygon", "coordinates": [[[-122.26514, 37.84588], [-122.26212, 37.84635], [-122.2619, 37.84545], [-122.26324, 37.84525], [-122.26317, 37.84488], [-122.26367, 37.84481], [-122.26376, 37.84516], [-122.26392, 37.84514], [-122.26385, 37.84478], [-122.26406, 37.84475], [-122.26411, 37.8451], [-122.26423, 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 | Bushrod Recreation Center | 16540 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 7.777 | Bushrod Rec. Ctr. | 1910 | |
2784 | 2784 | 2783 | {"type": "Polygon", "coordinates": [[[-122.2254, 37.79572], [-122.22489, 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.79637], [-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 | Central Reservoir Park | 17073 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 9.134 | Central Reservoir Park | ||
2821 | 2821 | 2820 | {"type": "Polygon", "coordinates": [[[-122.24204, 37.85062], [-122.23985, 37.85093], [-122.23982, 37.85109], [-122.2391, 37.85125], [-122.23883, 37.8512], [-122.23693, 37.85067], [-122.23681, 37.85044], [-122.23681, 37.85023], [-122.23658, 37.84995], [-122.23623, 37.84978], [-122.23624, 37.84932], [-122.23667, 37.84953], [-122.23731, 37.84991], [-122.23785, 37.85015], [-122.23846, 37.85028], [-122.23905, 37.85035], [-122.24001, 37.85032], [-122.2408, 37.85019], [-122.24128, 37.85007], [-122.24168, 37.84993], [-122.24196, 37.84972], [-122.24204, 37.85062]]]} | Open Access 1 | Chabot Park | 17109 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 10.308 | Chabot Park | 1961 | |
2830 | 2830 | 2829 | {"type": "Polygon", "coordinates": [[[-122.26277, 37.79503], [-122.26265, 37.79521], [-122.26225, 37.79505], [-122.26118, 37.79682], [-122.25982, 37.79631], [-122.25937, 37.79601], [-122.25689, 37.79375], [-122.25807, 37.79295], [-122.25956, 37.79322], [-122.26015, 37.79275], [-122.26028, 37.79248], [-122.26063, 37.79208], [-122.2611, 37.792], [-122.26168, 37.79228], [-122.26185, 37.79209], [-122.26272, 37.79287], [-122.26204, 37.79397], [-122.26183, 37.79427], [-122.26277, 37.79503]]]} | Open Access 1 | Channel Park | 17121 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 37.392 | Channel Park | ||
2971 | 2971 | 2970 | {"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 | City Hall Plaza | 17298 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1.331 | City Hall Plaza | ||
3070 | 3070 | 3069 | {"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.25741, 37.8474], [-122.25781, 37.84735], [-122.25789, 37.84739], [-122.25792, 37.84756]]]} | Open Access 1 | Colby Park | 17479 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.357 | Colby Park | ||
3087 | 3087 | 3086 | {"type": "Polygon", "coordinates": [[[-122.19938, 37.75713], [-122.19924, 37.75722], [-122.19918, 37.75734], [-122.19815, 37.75822], [-122.19753, 37.7576], [-122.19759, 37.75714], [-122.19761, 37.75711], [-122.1977, 37.75643], [-122.19856, 37.7565], [-122.19859, 37.75649], [-122.19874, 37.7565], [-122.19938, 37.75713]]]} | Open Access 1 | Coliseum Gardens Park | 17499 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 4.999 | Coliseum Gardens Park | ||
3123 | 3123 | 3122 | {"type": "MultiPolygon", "coordinates": [[[[-122.18916, 37.72907], [-122.18879, 37.72898], [-122.18871, 37.72856], [-122.18907, 37.72866], [-122.18916, 37.72907]]], [[[-122.19138, 37.73026], [-122.1904, 37.73064], [-122.18972, 37.73088], [-122.18947, 37.73095], [-122.18934, 37.73095], [-122.1893, 37.73091], [-122.1888, 37.7291], [-122.1892, 37.7292], [-122.18966, 37.73082], [-122.18972, 37.73082], [-122.19011, 37.73067], [-122.19012, 37.73037], [-122.19019, 37.73034], [-122.1909, 37.73032], [-122.19107, 37.73029], [-122.19126, 37.73022], [-122.19134, 37.73022], [-122.19138, 37.73026]]]]} | Open Access 1 | Columbian Gardens Park | 17550 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 2.656 | Columbian Gardens Park | ||
3140 | 3140 | 3139 | {"type": "Polygon", "coordinates": [[[-122.18437, 37.77273], [-122.18343, 37.77353], [-122.18268, 37.77286], [-122.18334, 37.77241], [-122.18287, 37.77195], [-122.18325, 37.77171], [-122.18437, 37.77273]]]} | Open Access 1 | Concordia Park | 17577 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 3.5 | Concordia Park | ||
3249 | 3249 | 3248 | {"type": "Polygon", "coordinates": [[[-122.2501, 37.80035], [-122.24957, 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.24886, 37.80041], [-122.24923, 37.80031], [-122.25006, 37.80024], [-122.2501, 37.80035]]]} | Open Access 1 | F. M. SMITH PARK | 18780 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1.693 | F. M. SMITH PARK | ||
3252 | 3252 | 3251 | {"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 | Courtland Creek Park | 17721 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.386 | Courtland Creek Park | ||
3315 | 3315 | 3314 | {"type": "Polygon", "coordinates": [[[-122.29722, 37.80377], [-122.29719, 37.80383], [-122.29678, 37.80373], [-122.2968, 37.80366], [-122.29722, 37.80377]]]} | Open Access 1 | Cresent Park | 17799 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.074 | Cresent Park | ||
3380 | 3380 | 3379 | {"type": "Polygon", "coordinates": [[[-122.21426, 37.79561], [-122.21378, 37.79679], [-122.21206, 37.79603], [-122.21209, 37.79594], [-122.21209, 37.79585], [-122.21199, 37.79538], [-122.21201, 37.79535], [-122.21252, 37.79484], [-122.21426, 37.79561]]]} | Open Access 1 | Curt Flood Field | 17862 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 6.218 | Curt Flood Field | ||
3389 | 3389 | 3388 | {"type": "Polygon", "coordinates": [[[-122.29309, 37.81022], [-122.29302, 37.81041], [-122.29246, 37.81029], [-122.29225, 37.81086], [-122.29189, 37.81078], [-122.29186, 37.81081], [-122.29176, 37.81079], [-122.29189, 37.81039], [-122.29198, 37.80998], [-122.29309, 37.81022]]]} | Open Access 1 | Cypress Freeway Memorial Park | 17873 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1.281 | Cypress Freeway Memorial Park | ||
3521 | 3521 | 3520 | {"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 | DeFremery Park | 18017 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 9.427 | DeFremery Park | 1910 | |
3618 | 3618 | 3617 | {"type": "MultiPolygon", "coordinates": [[[[-122.21418, 37.81309], [-122.21399, 37.81324], [-122.21383, 37.81342], [-122.21296, 37.81468], [-122.21287, 37.81488], [-122.21282, 37.81505], [-122.21279, 37.81524], [-122.21276, 37.81568], [-122.21271, 37.81589], [-122.21264, 37.81615], [-122.21255, 37.81635], [-122.21242, 37.8166], [-122.21216, 37.81697], [-122.21188, 37.81727], [-122.21156, 37.81754], [-122.21133, 37.81733], [-122.21022, 37.8181], [-122.21042, 37.81832], [-122.20899, 37.81931], [-122.20864, 37.8196], [-122.20844, 37.8198], [-122.20824, 37.82005], [-122.20783, 37.82076], [-122.20753, 37.82065], [-122.20748, 37.82071], [-122.20708, 37.82061], [-122.2072, 37.82062], [-122.20724, 37.82059], [-122.2066, 37.81988], [-122.20655, 37.81977], [-122.20656, 37.81968], [-122.20664, 37.81949], [-122.20665, 37.81934], [-122.2074, 37.81931], [-122.20747, 37.81913], [-122.20759, 37.81904], [-122.20762, 37.81894], [-122.2074, 37.81888], [-122.20734, 37.81874], [-122.20698, 37.81872], [-122.20695, 37.81862], [-122.20657, 37.81849], [-122.20619, 37.81822], [-122.20582, 37.81817], [-122.20518, 37.81767], [-122.20511, 37.81752], [-122.20472, 37.81736], [-122.20425, 37.81689], [-122.20411, 37.81684], [-122.20401, 37.81675], [-122.20367, 37.8167], [-122.2035, 37.81649], [-122.2037, 37.81627], [-122.20461, 37.81657], [-122.20479, 37.81665], [-122.20494, 37.81677], [-122.20511, 37.81692], [-122.20541, 37.81728], [-122.20586, 37.81761], [-122.20601, 37.81766], [-122.20628, 37.81764], [-122.20626, 37.81779], [-122.20644, 37.8179], [-122.20652, 37.81792], [-122.2067, 37.8179], [-122.20684, 37.81792], [-122.2073, 37.81813], [-122.21117, 37.8155], [-122.21113, 37.8148], [-122.2109, 37.81459], [-122.2105, 37.81486], [-122.21011, 37.81458], [-122.20948, 37.81371], [-122.20937, 37.8135], [-122.20949, 37.81337], [-122.20984, 37.81349], [-122.20991, 37.81338], [-122.21032, 37.81354], [-122.21028, 37.8136], [-122.21029, 37.81362], [-122.21061, 37.81374], [-122.21072, 37.81377], [-122.21091, 37.81376], [-122.21113, 37.81371], [-122.21141, 37.8137], [-122.21165, 37.81365], [-122.21181, 37.81358], [-122.21196, 37.81346], [-122.21202, 37.81339], [-122.21205, 37.81331], [-122.21206, 37.81323], [-122.21203, 37.81315], [-122.2119, 37.81299], [-122.21187, 37.81289], [-122.21226, 37.81285], [-122.21266, 37.8127], [-122.21266, 37.81226], [-122.21289, 37.81238], [-122.2131, 37.81212], [-122.21365, 37.81239], [-122.21398, 37.81251], [-122.2138, 37.81288], [-122.21397, 37.813], [-122.21403, 37.81298], [-122.21418, 37.81309]]], [[[-122.21615, 37.8102], [-122.21597, 37.81029], [-122.21571, 37.81014], [-122.21562, 37.81013], [-122.21555, 37.81019], [-122.21534, 37.81058], [-122.21499, 37.81103], [-122.21478, 37.81126], [-122.21455, 37.81134], [-122.21436, 37.81156], [-122.21424, 37.81174], [-122.2144, 37.81205], [-122.2142, 37.81215], [-122.21411, 37.81217], [-122.21403, 37.81225], [-122.21399, 37.81236], [-122.21373, 37.81227], [-122.21319, 37.812], [-122.21358, 37.81151], [-122.21352, 37.8107], [-122.21438, 37.81005], [-122.21447, 37.81011], [-122.21465, 37.80997], [-122.21458, 37.80989], [-122.21471, 37.8098], [-122.21499, 37.80947], [-122.21512, 37.8092], [-122.21515, 37.80906], [-122.21527, 37.80906], [-122.21528, 37.80896], [-122.21517, 37.80894], [-122.2152, 37.80871], [-122.21533, 37.8087], [-122.21533, 37.80861], [-122.21522, 37.8086], [-122.21532, 37.80794], [-122.21545, 37.80794], [-122.21549, 37.80763], [-122.21546, 37.80761], [-122.21574, 37.80753], [-122.21592, 37.80763], [-122.21611, 37.80767], [-122.21615, 37.80805], [-122.21614, 37.80818], [-122.21605, 37.80838], [-122.21605, 37.80855], [-122.21595, 37.80889], [-122.21601, 37.80917], [-122.216, 37.80924], [-122.2159, 37.80948], [-122.21589, 37.80955], [-122.21593, 37.80968], [-122.21603, 37.80983], [-122.21615, 37.8102]]], [[[-122.21679, 37.804], [-122.21671, 37.80414], [-122.21665, 37.80427], [-122.21669, 37.80442], [-122.21656, 37.80466], [-122.21669, 37.80483], [-122.21644, 37.80488], [-122.21633, 37.80495], [-122.21649, 37.80502], [-122.21634, 37.80543], [-122.21638, 37.80566], [-122.21638, 37.80575], [-122.21591, 37.80606], [-122.21592, 37.80645], [-122.21605, 37.80683], [-122.2162, 37.80705], [-122.21621, 37.8072], [-122.21619, 37.80727], [-122.21605, 37.80744], [-122.21606, 37.80752], [-122.21596, 37.80749], [-122.21584, 37.80742], [-122.21578, 37.80737], [-122.21537, 37.80669], [-122.21432, 37.80652], [-122.21493, 37.80499], [-122.21446, 37.80489], [-122.2151, 37.80326], [-122.21636, 37.80358], [-122.21649, 37.80358], [-122.21672, 37.80373], [-122.2167, 37.80387], [-122.21679, 37.804]]]]} | Open Access 1 | Dimond Canyon Park | 18154 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 78.716 | Dimond Canyon Park | ||
3741 | 3741 | 3740 | {"type": "Polygon", "coordinates": [[[-122.14501, 37.74224], [-122.14462, 37.74247], [-122.14315, 37.74306], [-122.14154, 37.74234], [-122.14023, 37.74083], [-122.14108, 37.73916], [-122.14144, 37.73896], [-122.14157, 37.73902], [-122.14195, 37.7395], [-122.14307, 37.73996], [-122.1434, 37.74026], [-122.1437, 37.74072], [-122.14413, 37.74111], [-122.14501, 37.74224]]]} | Open Access 1 | Dunsmuir Estate Park | 18309 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 25.145 | Dunsmuir Estate Park | ||
3750 | 3750 | 3749 | {"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 | Durant Mini Park | 18311 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.32 | Durant MP | ||
3967 | 3967 | 3966 | {"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 | Elmhurst Plaza | 18598 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 2.01 | Elmhurst Plaza |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);