units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
99 rows where DES_TP = 2 and MNG_AGENCY = 56 sorted by map
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
MNG_AG_TYP 1
- City Agency 99
MNG_AGENCY 1
- Oakland, City of · 99 ✖
DES_TP 1
- Local Park · 99 ✖
ACCESS_TYP 1
- Open Access 99
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9315 | 9315 | 9314 | {"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.73083], [-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 | 15530 | Columbian Gardens Park | 17550 | 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.649 | Columbian Gardens Park | 0 | Local Park 2 | 4 | |
6047 | 6047 | 6046 | {"type": "MultiPolygon", "coordinates": [[[[-122.19936, 37.82584], [-122.19917, 37.82609], [-122.199, 37.82594], [-122.19853, 37.82587], [-122.19831, 37.82559], [-122.198, 37.82546], [-122.19786, 37.82564], [-122.19758, 37.8256], [-122.19729, 37.82563], [-122.19726, 37.82559], [-122.19736, 37.82553], [-122.19793, 37.82537], [-122.19818, 37.82532], [-122.19836, 37.82531], [-122.19845, 37.82534], [-122.19855, 37.82546], [-122.19866, 37.82552], [-122.19875, 37.82553], [-122.19886, 37.82551], [-122.19906, 37.82551], [-122.19916, 37.82554], [-122.19922, 37.8256], [-122.19936, 37.82584]]], [[[-122.20188, 37.82431], [-122.20184, 37.82443], [-122.20182, 37.82454], [-122.20184, 37.82475], [-122.20191, 37.82496], [-122.20204, 37.82517], [-122.20209, 37.82529], [-122.20224, 37.82591], [-122.20224, 37.82612], [-122.20218, 37.82644], [-122.20218, 37.82661], [-122.20221, 37.82683], [-122.2022, 37.82698], [-122.20216, 37.82714], [-122.20194, 37.82763], [-122.2016, 37.82826], [-122.2014, 37.82856], [-122.20118, 37.82881], [-122.20087, 37.82862], [-122.20092, 37.82854], [-122.201, 37.82834], [-122.20117, 37.82809], [-122.20118, 37.82798], [-122.20112, 37.82785], [-122.20111, 37.8278], [-122.20113, 37.82775], [-122.20123, 37.82764], [-122.20124, 37.82754], [-122.20122, 37.82749], [-122.20109, 37.82732], [-122.20102, 37.82728], [-122.20086, 37.82722], [-122.20083, 37.82719], [-122.20101, 37.827], [-122.20117, 37.82694], [-122.2013, 37.82688], [-122.2014, 37.82679], [-122.20144, 37.82672], [-122.20144, 37.82663], [-122.20137, 37.82653], [-122.20127, 37.82645], [-122.20111, 37.82636], [-122.20105, 37.82629], [-122.20107, 37.82619], [-122.2012, 37.82608], [-122.20125, 37.82599], [-122.20126, 37.8259], [-122.2012, 37.82579], [-122.20076, 37.82541], [-122.20059, 37.82534], [-122.20039, 37.82531], [-122.20022, 37.82534], [-122.20003, 37.82542], [-122.19993, 37.8255], [-122.19978, 37.82569], [-122.19966, 37.82581], [-122.19962, 37.82583], [-122.19958, 37.82583], [-122.19952, 37.8258], [-122.19935, 37.8255], [-122.19921, 37.82541], [-122.19909, 37.82538], [-122.19879, 37.82537], [-122.19875, 37.82535], [-122.19871, 37.82527], [-122.19866, 37.82522], [-122.19857, 37.82517], [-122.19848, 37.82516], [-122.19805, 37.8252], [-122.19764, 37.8253], [-122.19752, 37.82502], [-122.19773, 37.82486], [-122.19786, 37.82479], [-122.198, 37.82476], [-122.19824, 37.82474], [-122.19842, 37.82468], [-122.19854, 37.82461], [-122.19868, 37.82446], [-122.19884, 37.8244], [-122.19916, 37.82418], [-122.19923, 37.82415], [-122.19942, 37.82411], [-122.19956, 37.82447], [-122.19972, 37.82444], [-122.19965, 37.8241], [-122.19972, 37.82415], [-122.19979, 37.82417], [-122.19987, 37.82418], [-122.19994, 37.82416], [-122.20003, 37.82439], [-122.20034, 37.82433], [-122.20024, 37.82401], [-122.20029, 37.82399], [-122.20055, 37.82399], [-122.20064, 37.82396], [-122.20091, 37.82424], [-122.20142, 37.82393], [-122.20188, 37.82431]]], [[[-122.20072, 37.82856], [-122.20067, 37.82861], [-122.20051, 37.82868], [-122.2004, 37.82877], [-122.20034, 37.82886], [-122.20028, 37.82899], [-122.20023, 37.82905], [-122.19996, 37.82919], [-122.19964, 37.82941], [-122.19958, 37.82946], [-122.19949, 37.8296], [-122.19934, 37.82967], [-122.19892, 37.82998], [-122.19885, 37.83005], [-122.19878, 37.8302], [-122.19868, 37.83029], [-122.19848, 37.83037], [-122.1982, 37.82998], [-122.19835, 37.82991], [-122.19871, 37.82954], [-122.19961, 37.82885], [-122.20019, 37.82851], [-122.2003, 37.8284], [-122.20072, 37.82856]]], [[[-122.20115, 37.82883], [-122.20091, 37.82905], [-122.20057, 37.82929], [-122.19975, 37.8297], [-122.19971, 37.8297], [-122.19968, 37.82968], [-122.19968, 37.8296], [-122.19974, 37.82952], [-122.20006, 37.82931], [-122.20035, 37.82915], [-122.20043, 37.82907], [-122.20049, 37.82892], [-122.20055, 37.82884], [-122.20061, 37.8288], [-122.20077, 37.82872], [-122.20086, 37.82865], [-122.20115, 37.82883]]], [[[-122.20127, 37.82668], [-122.20126, 37.82671], [-122.20114, 37.82679], [-122.20094, 37.82687], [-122.20088, 37.8269], [-122.2007, 37.82709], [-122.20066, 37.82717], [-122.20067, 37.82723], [-122.20071, 37.8273], [-122.20078, 37.82735], [-122.20095, 37.82741], [-122.20107, 37.82756], [-122.20107, 37.8276], [-122.20097, 37.8277], [-122.20094, 37.82778], [-122.20095, 37.82787], [-122.20101, 37.828], [-122.201, 37.82807], [-122.20084, 37.82828], [-122.20073, 37.82853], [-122.20032, 37.82838], [-122.20044, 37.82825], [-122.20054, 37.82788], [-122.20049, 37.82771], [-122.20019, 37.8274], [-122.20006, 37.82742], [-122.20025, 37.82706], [-122.20065, 37.82658], [-122.20121, 37.82659], [-122.20127, 37.82668]]], [[[-122.20352, 37.82221], [-122.20326, 37.82242], [-122.20333, 37.82334], [-122.20314, 37.8234], [-122.20292, 37.82386], [-122.20261, 37.82412], [-122.20219, 37.82473], [-122.20243, 37.82513], [-122.20245, 37.8253], [-122.20259, 37.82586], [-122.20246, 37.82625], [-122.20244, 37.82626], [-122.20243, 37.82624], [-122.20246, 37.82599], [-122.20243, 37.82579], [-122.20229, 37.82524], [-122.20224, 37.82511], [-122.20211, 37.8249], [-122.20205, 37.82475], [-122.20203, 37.82462], [-122.20204, 37.8245], [-122.20208, 37.82435], [-122.20217, 37.82422], [-122.20285, 37.82358], [-122.20291, 37.82347], [-122.20299, 37.82318], [-122.20288, 37.82322], [-122.20279, 37.82316], [-122.20271, 37.82343], [-122.20266, 37.82351], [-122.20204, 37.82408], [-122.20196, 37.82417], [-122.20189, 37.82428], [-122.20145, 37.82392], [-122.2019, 37.82367], [-122.20251, 37.8229], [-122.20225, 37.82267], [-122.20201, 37.82238], [-122.20194, 37.82221], [-122.20221, 37.82167], [-122.20267, 37.8217], [-122.20276, 37.82172], [-122.20329, 37.82203], [-122.20352, 37.82221]]]]} | Open Access 1 | 746 | Shepherd Canyon Park | 25390 | 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 | 33.053 | Shepherd Canyon Park | 0 | Local Park 2 | 4 | |
9394 | 9394 | 9393 | {"type": "MultiPolygon", "coordinates": [[[[-122.21418, 37.81309], [-122.21399, 37.81324], [-122.21383, 37.81341], [-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.21134, 37.81732], [-122.21021, 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.20752, 37.82065], [-122.20748, 37.82071], [-122.20708, 37.82061], [-122.20721, 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.20763, 37.81894], [-122.2074, 37.81888], [-122.20735, 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.20512, 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.20729, 37.81814], [-122.21117, 37.8155], [-122.21113, 37.8148], [-122.2109, 37.81458], [-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.81361], [-122.21029, 37.81362], [-122.21061, 37.81374], [-122.21072, 37.81377], [-122.21091, 37.81377], [-122.21113, 37.81371], [-122.2114, 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.21379, 37.81288], [-122.21397, 37.81301], [-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.21374, 37.81227], [-122.21319, 37.812], [-122.21359, 37.81151], [-122.21352, 37.8107], [-122.21438, 37.81005], [-122.21447, 37.81011], [-122.21466, 37.80997], [-122.21458, 37.80989], [-122.21471, 37.8098], [-122.21499, 37.80946], [-122.21512, 37.8092], [-122.21515, 37.80906], [-122.21527, 37.80907], [-122.21528, 37.80895], [-122.21517, 37.80894], [-122.2152, 37.80871], [-122.21533, 37.80871], [-122.21534, 37.80861], [-122.21522, 37.8086], [-122.21532, 37.80794], [-122.21544, 37.80794], [-122.21549, 37.80762], [-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.2167, 37.80414], [-122.21665, 37.80427], [-122.21669, 37.80442], [-122.21656, 37.80466], [-122.21669, 37.80483], [-122.21644, 37.80488], [-122.21632, 37.80495], [-122.21649, 37.80502], [-122.21633, 37.80543], [-122.21638, 37.80566], [-122.21638, 37.80575], [-122.21591, 37.80605], [-122.21592, 37.80644], [-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.80736], [-122.21537, 37.80669], [-122.21432, 37.80652], [-122.21493, 37.80498], [-122.21446, 37.80489], [-122.2151, 37.80326], [-122.21637, 37.80358], [-122.21649, 37.80358], [-122.21672, 37.80373], [-122.2167, 37.80387], [-122.21679, 37.804]]]]} | Open Access 1 | 15702 | Dimond Canyon Park | 18154 | 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 | 78.65 | Dimond Canyon Park | 0 | Local Park 2 | 4 | |
8527 | 8527 | 8526 | {"type": "MultiPolygon", "coordinates": [[[[-122.22488, 37.85002], [-122.22487, 37.85037], [-122.22479, 37.85056], [-122.22471, 37.85063], [-122.22423, 37.8507], [-122.22404, 37.851], [-122.22409, 37.85133], [-122.22453, 37.85173], [-122.22447, 37.8518], [-122.22419, 37.85183], [-122.22365, 37.85195], [-122.22346, 37.85216], [-122.22344, 37.85262], [-122.22355, 37.85292], [-122.224, 37.85341], [-122.22399, 37.85345], [-122.22339, 37.85357], [-122.22299, 37.85382], [-122.223, 37.85416], [-122.2232, 37.8546], [-122.2233, 37.85488], [-122.22344, 37.85497], [-122.22335, 37.85498], [-122.2232, 37.85495], [-122.22293, 37.85478], [-122.22262, 37.85474], [-122.22227, 37.85488], [-122.22199, 37.85486], [-122.22162, 37.85509], [-122.22121, 37.85495], [-122.22117, 37.85484], [-122.22153, 37.85474], [-122.22182, 37.85462], [-122.22214, 37.85445], [-122.22243, 37.85426], [-122.22262, 37.8541], [-122.22282, 37.8539], [-122.22309, 37.85354], [-122.22332, 37.8536], [-122.22356, 37.85314], [-122.22331, 37.85305], [-122.22337, 37.85278], [-122.22339, 37.85252], [-122.22337, 37.85213], [-122.22332, 37.85192], [-122.22326, 37.85173], [-122.22331, 37.85158], [-122.22339, 37.85144], [-122.22418, 37.8504], [-122.22433, 37.85027], [-122.22447, 37.85018], [-122.2247, 37.85008], [-122.22488, 37.85002]]], [[[-122.22657, 37.85004], [-122.22654, 37.85009], [-122.22647, 37.85014], [-122.22631, 37.85019], [-122.22568, 37.85012], [-122.22565, 37.84991], [-122.22584, 37.8499], [-122.22606, 37.84992], [-122.22653, 37.85], [-122.22657, 37.85004]]]]} | Open Access 1 | 13392 | Gateway Gardens | 19235 | 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.645 | Gateway Gardens | 0 | Local Park 2 | 4 | |
8545 | 8545 | 8544 | {"type": "MultiPolygon", "coordinates": [[[[-122.25241, 37.82454], [-122.25213, 37.82477], [-122.25186, 37.82458], [-122.25215, 37.82436], [-122.25241, 37.82454]]], [[[-122.25329, 37.82402], [-122.25266, 37.82457], [-122.25238, 37.82435], [-122.25268, 37.82406], [-122.25275, 37.82413], [-122.25309, 37.82386], [-122.25329, 37.82402]]]]} | Open Access 1 | 13466 | Glen Echo Park | 19320 | 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.896 | Glen Echo 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 | |
8532 | 8532 | 8531 | {"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 | 13404 | Dunsmuir Estate Park | 18309 | 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 | 25.146 | Dunsmuir Estate Park | 0 | Local Park 2 | 4 | |
8519 | 8519 | 8518 | {"type": "Polygon", "coordinates": [[[-122.16384, 37.74928], [-122.16303, 37.74965], [-122.162, 37.74825], [-122.1628, 37.74788], [-122.16384, 37.74928]]]} | Open Access 1 | 13381 | Verdese Carter Park | 26987 | 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.66 | Verdese Carter Park | 0 | Local Park 2 | 4 | |
8524 | 8524 | 8523 | {"type": "Polygon", "coordinates": [[[-122.16902, 37.74457], [-122.16857, 37.74478], [-122.1684, 37.74454], [-122.16885, 37.74434], [-122.16902, 37.74457]]]} | Open Access 1 | 13383 | Hooly Mini Park | 20077 | 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 | Hooly 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 | |
8534 | 8534 | 8533 | {"type": "Polygon", "coordinates": [[[-122.17361, 37.75533], [-122.17331, 37.75544], [-122.17312, 37.7551], [-122.1734, 37.755], [-122.17361, 37.75533]]]} | Open Access 1 | 13413 | 85th Avenue Mini Park | 15217 | 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.291 | 85th Avenue MP | 0 | Local Park 2 | 4 | |
8530 | 8530 | 8529 | {"type": "Polygon", "coordinates": [[[-122.17517, 37.79591], [-122.17479, 37.79667], [-122.17464, 37.79685], [-122.17459, 37.79689], [-122.17386, 37.79706], [-122.1738, 37.79704], [-122.1739, 37.7965], [-122.17369, 37.796], [-122.17347, 37.79585], [-122.17326, 37.79579], [-122.17315, 37.79564], [-122.1737, 37.79569], [-122.17396, 37.79587], [-122.17462, 37.79574], [-122.17488, 37.79576], [-122.17517, 37.79591]]]} | Open Access 1 | 13399 | Pinto Park | 23708 | 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.42 | Pinto Park | 1961 | 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 | |
13080 | 13080 | 13079 | {"type": "Polygon", "coordinates": [[[-122.17595, 37.73669], [-122.1741, 37.73813], [-122.17386, 37.73782], [-122.17511, 37.73686], [-122.17502, 37.73674], [-122.17482, 37.73661], [-122.17463, 37.73664], [-122.17449, 37.73644], [-122.17449, 37.73639], [-122.1747, 37.73626], [-122.1752, 37.73597], [-122.17568, 37.73635], [-122.17561, 37.73641], [-122.17595, 37.73669]]]} | Open Access 1 | 45011 | Stonehurst Park | 25890 | 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.471 | Stonehurst 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 | |
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 | |
9243 | 9243 | 9242 | {"type": "Polygon", "coordinates": [[[-122.17895, 37.73253], [-122.17879, 37.73285], [-122.17879, 37.73286], [-122.17869, 37.73296], [-122.17862, 37.73298], [-122.17826, 37.73236], [-122.17857, 37.73236], [-122.17895, 37.73253]]]} | Open Access 1 | 15521 | Carney Park | 16886 | 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.559 | Carney Park | 0 | Local Park 2 | 4 | |
9328 | 9328 | 9327 | {"type": "Polygon", "coordinates": [[[-122.18259, 37.79131], [-122.18261, 37.79144], [-122.18259, 37.79225], [-122.18252, 37.79255], [-122.18163, 37.79162], [-122.1816, 37.79123], [-122.18178, 37.79125], [-122.18199, 37.79117], [-122.18227, 37.79112], [-122.18259, 37.79131]]]} | Open Access 1 | 15552 | Mc Crea Park | 21986 | 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.147 | Mc Crea Park | 0 | Local Park 2 | 4 | |
8516 | 8516 | 8515 | {"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 | 13374 | Concordia Park | 17577 | 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.494 | Concordia 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 |
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]);