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 9
- Local Park 99
- Local Recreation Area 16
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AG_TYP 1
- City Agency 122
MNG_AGENCY 1
- Oakland, City of · 122 ✖
ACCESS_TYP 1
- Open Access 122
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
146 | 146 | 145 | {"type": "Polygon", "coordinates": [[[-122.24241, 37.79003], [-122.24099, 37.79152], [-122.23911, 37.7904], [-122.24053, 37.78891], [-122.24241, 37.79003]]]} | Open Access 1 | 366 | San Antonio Park | 24832 | 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.619 | San Antonio 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 | |
681 | 681 | 680 | {"type": "Polygon", "coordinates": [[[-122.19178, 37.73593], [-122.19137, 37.73616], [-122.19116, 37.73688], [-122.19077, 37.73841], [-122.18827, 37.73776], [-122.18881, 37.73569], [-122.19025, 37.736], [-122.19031, 37.73606], [-122.19074, 37.7357], [-122.19104, 37.73566], [-122.19126, 37.73533], [-122.19178, 37.73593]]]} | Open Access 1 | 3504 | Ira Jenkins Park | 20226 | 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 | 15.161 | Ira Jenkins Park | 0 | Local Park 2 | 4 | |
6708 | 6708 | 6707 | {"type": "Polygon", "coordinates": [[[-122.26514, 37.84588], [-122.26212, 37.84635], [-122.2619, 37.84545], [-122.26325, 37.84525], [-122.26317, 37.84488], [-122.26367, 37.84481], [-122.26377, 37.84516], [-122.26393, 37.84514], [-122.26385, 37.84478], [-122.26406, 37.84475], [-122.26411, 37.84511], [-122.26424, 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 | 5003 | Bushrod Recreation Center | 16540 | 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.761 | Bushrod Rec. Ctr. | 1910 | Local Recreation Area 3 | 4 | |
1226 | 1226 | 1225 | {"type": "Polygon", "coordinates": [[[-122.2621, 37.81037], [-122.26187, 37.81046], [-122.26141, 37.8104], [-122.26121, 37.81003], [-122.26124, 37.80951], [-122.26139, 37.80882], [-122.26145, 37.80722], [-122.26125, 37.80701], [-122.26115, 37.80678], [-122.26059, 37.80677], [-122.26018, 37.80656], [-122.26, 37.80604], [-122.25945, 37.80556], [-122.25897, 37.80479], [-122.25862, 37.80467], [-122.25787, 37.80485], [-122.2566, 37.80538], [-122.25631, 37.8057], [-122.25625, 37.80655], [-122.25573, 37.80703], [-122.25541, 37.80719], [-122.25475, 37.80716], [-122.254, 37.80703], [-122.25305, 37.80712], [-122.25224, 37.80751], [-122.25146, 37.8081], [-122.25109, 37.80815], [-122.24995, 37.80847], [-122.24972, 37.80838], [-122.24972, 37.80785], [-122.24999, 37.80721], [-122.2503, 37.80668], [-122.25074, 37.80566], [-122.2511, 37.80499], [-122.25117, 37.80494], [-122.2534, 37.80418], [-122.25372, 37.80369], [-122.2539, 37.80321], [-122.25472, 37.80211], [-122.25473, 37.80206], [-122.25483, 37.80191], [-122.25473, 37.80158], [-122.25473, 37.80085], [-122.25507, 37.80057], [-122.25551, 37.80043], [-122.25654, 37.80053], [-122.25712, 37.80039], [-122.25836, 37.79968], [-122.25882, 37.7992], [-122.25917, 37.79895], [-122.26125, 37.79996], [-122.26139, 37.80021], [-122.26151, 37.80087], [-122.2613, 37.80222], [-122.26104, 37.80261], [-122.26049, 37.80382], [-122.26049, 37.80451], [-122.26147, 37.80527], [-122.26245, 37.80641], [-122.2628, 37.80726], [-122.2628, 37.80815], [-122.2626, 37.8087], [-122.26228, 37.81014], [-122.2621, 37.81037]]]} | Open Access 1 | 8847 | Lake Merritt | 20953 | 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 | 141.432 | Lake Merritt | 1957 | None 107 | ||
1556 | 1556 | 1555 | {"type": "Polygon", "coordinates": [[[-122.28429, 37.8453], [-122.28401, 37.84534], [-122.28346, 37.84522], [-122.28281, 37.8452], [-122.28279, 37.84516], [-122.28227, 37.84523], [-122.28208, 37.84463], [-122.284, 37.8444], [-122.28429, 37.8453]]]} | Open Access 1 | 13055 | Golden Gate Recreation Center | 19360 | 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.496 | Golden Gate Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
17010 | 17010 | 17009 | {"type": "Polygon", "coordinates": [[[-122.22695, 37.84735], [-122.22693, 37.8474], [-122.2263, 37.84745], [-122.22594, 37.8475], [-122.22559, 37.84757], [-122.22508, 37.84772], [-122.22455, 37.84792], [-122.22289, 37.84789], [-122.22304, 37.84852], [-122.22278, 37.84872], [-122.22254, 37.84894], [-122.22236, 37.84914], [-122.22218, 37.8494], [-122.22203, 37.84966], [-122.22192, 37.84994], [-122.22185, 37.85023], [-122.22181, 37.85052], [-122.22181, 37.85076], [-122.22184, 37.851], [-122.22189, 37.85124], [-122.22195, 37.85143], [-122.22203, 37.8516], [-122.22225, 37.85154], [-122.22247, 37.85196], [-122.22251, 37.85207], [-122.22256, 37.85232], [-122.22256, 37.85257], [-122.2213, 37.85272], [-122.22104, 37.85291], [-122.21964, 37.85377], [-122.21947, 37.85385], [-122.21927, 37.85392], [-122.21896, 37.85398], [-122.21832, 37.85401], [-122.2182, 37.85398], [-122.21813, 37.85399], [-122.21807, 37.85401], [-122.21802, 37.85406], [-122.21801, 37.85412], [-122.21803, 37.85417], [-122.21736, 37.85418], [-122.21723, 37.85416], [-122.21682, 37.85452], [-122.2165, 37.85462], [-122.21619, 37.85474], [-122.2159, 37.85488], [-122.21563, 37.85504], [-122.21537, 37.85522], [-122.21472, 37.85574], [-122.21456, 37.85527], [-122.21446, 37.85531], [-122.21412, 37.85495], [-122.21413, 37.85407], [-122.2154, 37.85398], [-122.2153, 37.85297], [-122.21486, 37.85316], [-122.21472, 37.85311], [-122.21478, 37.85298], [-122.21527, 37.85273], [-122.21523, 37.85235], [-122.21392, 37.85227], [-122.21355, 37.8522], [-122.21365, 37.85158], [-122.21364, 37.85135], [-122.21335, 37.85137], [-122.2137, 37.84989], [-122.21409, 37.84967], [-122.21409, 37.84965], [-122.21408, 37.84965], [-122.2126, 37.85015], [-122.21271, 37.85002], [-122.21287, 37.84975], [-122.21318, 37.84947], [-122.21941, 37.84738], [-122.22456, 37.84748], [-122.22457, 37.84736], [-122.22594, 37.84738], [-122.22695, 37.84735]]]} | Open Access 1 | 13243 | North Oakland Sports Center | 22835 | 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 | 124.166 | North Oakland Sports Ctr. | 1949 | Local Recreation Area 3 | 4 | |
1771 | 1771 | 1770 | {"type": "Polygon", "coordinates": [[[-122.24362, 37.84525], [-122.24333, 37.84541], [-122.2431, 37.84557], [-122.24304, 37.84555], [-122.24291, 37.84531], [-122.24294, 37.84529], [-122.24336, 37.84527], [-122.24362, 37.84525]]]} | Open Access 1 | 13245 | Rockridge Park | 24533 | 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.248 | Rockridge Park | 0 | Local Park 2 | 4 | |
1772 | 1772 | 1771 | {"type": "Polygon", "coordinates": [[[-122.23771, 37.84106], [-122.23757, 37.84115], [-122.23742, 37.84121], [-122.2367, 37.84127], [-122.23653, 37.84132], [-122.2364, 37.84138], [-122.2364, 37.84135], [-122.23642, 37.84134], [-122.23663, 37.84122], [-122.23693, 37.84111], [-122.23724, 37.84105], [-122.23771, 37.84106]]]} | Open Access 1 | 13247 | Ostrander Park | 23239 | 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.351 | Ostrander Park | 0 | Local Park 2 | 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 | |
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 | |
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 | |
8496 | 8496 | 8495 | {"type": "Polygon", "coordinates": [[[-122.29695, 37.81202], [-122.29654, 37.81255], [-122.29589, 37.81221], [-122.29631, 37.8117], [-122.29695, 37.81202]]]} | Open Access 1 | 13268 | Willow Mini Park | 27580 | 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.135 | Willow MP | 0 | Local Park 2 | 4 | |
1780 | 1780 | 1779 | {"type": "Polygon", "coordinates": [[[-122.29076, 37.80888], [-122.29052, 37.80959], [-122.28941, 37.8093], [-122.28911, 37.80883], [-122.28908, 37.8086], [-122.28911, 37.80855], [-122.29076, 37.80888]]]} | Open Access 1 | 13270 | Wade Johnson Park | 27206 | 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.538 | Wade Johnson Park | 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 | |
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 | |
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 |
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]);