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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5244 | 5244 | 5243 | {"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 | Hooly Mini Park | 20077 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.344 | Hooly MP | ||
5479 | 5479 | 5478 | {"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 | Madison Square | 21660 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1.377 | Madison Square | ||
5509 | 5509 | 5508 | {"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 | Jefferson Square | 20383 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1.376 | Jefferson Square | ||
5707 | 5707 | 5706 | {"type": "Polygon", "coordinates": [[[-122.23661, 37.77791], [-122.23654, 37.778], [-122.23636, 37.77796], [-122.23613, 37.77797], [-122.23591, 37.77781], [-122.23608, 37.77763], [-122.23613, 37.77763], [-122.23621, 37.77755], [-122.23627, 37.77758], [-122.23632, 37.77753], [-122.23641, 37.77755], [-122.23641, 37.77744], [-122.23638, 37.77738], [-122.23634, 37.77717], [-122.23639, 37.7772], [-122.23649, 37.77735], [-122.23657, 37.77754], [-122.23661, 37.77771], [-122.23661, 37.77791]]]} | Open Access 1 | Kennedy Tract Park | 20606 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.669 | Kennedy Tract Park | ||
5743 | 5743 | 5742 | {"type": "MultiPolygon", "coordinates": [[[[-122.15632, 37.76164], [-122.15604, 37.76171], [-122.15583, 37.76174], [-122.15555, 37.76175], [-122.1553, 37.76172], [-122.15499, 37.76163], [-122.15312, 37.7609], [-122.15291, 37.76085], [-122.15267, 37.76083], [-122.15245, 37.76083], [-122.15219, 37.76087], [-122.15215, 37.76087], [-122.15201, 37.76071], [-122.15191, 37.76063], [-122.151, 37.76013], [-122.15123, 37.75994], [-122.15083, 37.75943], [-122.15125, 37.75924], [-122.15165, 37.7589], [-122.15154, 37.75872], [-122.15187, 37.75857], [-122.15263, 37.75841], [-122.15291, 37.75828], [-122.15302, 37.7582], [-122.15309, 37.7581], [-122.15312, 37.75799], [-122.1531, 37.75788], [-122.15303, 37.75777], [-122.1529, 37.75765], [-122.15276, 37.75758], [-122.15258, 37.75753], [-122.15245, 37.75751], [-122.15295, 37.75729], [-122.15632, 37.76164]]], [[[-122.15929, 37.76543], [-122.15602, 37.767], [-122.15434, 37.76458], [-122.15292, 37.76529], [-122.15179, 37.76304], [-122.15352, 37.76241], [-122.15335, 37.76208], [-122.15317, 37.7617], [-122.15312, 37.76151], [-122.15308, 37.76124], [-122.15304, 37.76118], [-122.15298, 37.76115], [-122.15308, 37.76118], [-122.15481, 37.76187], [-122.15516, 37.76198], [-122.15549, 37.76202], [-122.15586, 37.76202], [-122.15619, 37.76197], [-122.1565, 37.76187], [-122.15922, 37.76537], [-122.15924, 37.76537], [-122.15929, 37.76543]]]]} | Open Access 1 | Kings Estate | 20660 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 77.497 | Kings Estate | ||
5869 | 5869 | 5868 | {"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 | Lafayette Square | 20833 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1.388 | Lafayette Square | ||
5943 | 5943 | 5942 | {"type": "Polygon", "coordinates": [[[-122.26211, 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.2605, 37.80382], [-122.26049, 37.8045], [-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.26211, 37.81037]]]} | Open Access 1 | Lake Merritt | 20953 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 141.453 | Lake Merritt | 1957 | |
5962 | 5962 | 5961 | {"type": "Polygon", "coordinates": [[[-122.26242, 37.8014], [-122.26237, 37.80162], [-122.26208, 37.80217], [-122.26155, 37.80288], [-122.26109, 37.80373], [-122.26084, 37.80396], [-122.26089, 37.8044], [-122.26189, 37.80504], [-122.26215, 37.80532], [-122.26263, 37.80595], [-122.26307, 37.80667], [-122.26317, 37.80719], [-122.26324, 37.80769], [-122.26311, 37.80829], [-122.26227, 37.81082], [-122.26051, 37.81049], [-122.26017, 37.81039], [-122.25939, 37.80971], [-122.2588, 37.80938], [-122.25734, 37.80894], [-122.25617, 37.80888], [-122.25636, 37.80844], [-122.25619, 37.8078], [-122.25601, 37.80743], [-122.25554, 37.80755], [-122.25504, 37.80764], [-122.2537, 37.80773], [-122.25297, 37.80784], [-122.25262, 37.80813], [-122.25253, 37.80863], [-122.25103, 37.8085], [-122.25052, 37.80855], [-122.25007, 37.80874], [-122.24979, 37.80872], [-122.24946, 37.80849], [-122.24937, 37.80821], [-122.24938, 37.80814], [-122.24951, 37.80799], [-122.24951, 37.80786], [-122.24948, 37.80768], [-122.24986, 37.80679], [-122.25044, 37.80568], [-122.25084, 37.80475], [-122.25116, 37.80442], [-122.25141, 37.80432], [-122.25202, 37.80423], [-122.2524, 37.80414], [-122.25305, 37.804], [-122.25335, 37.8038], [-122.25347, 37.80355], [-122.25355, 37.80325], [-122.25378, 37.80283], [-122.25414, 37.80248], [-122.25431, 37.80217], [-122.25447, 37.80169], [-122.25438, 37.80077], [-122.25461, 37.80048], [-122.25462, 37.80041], [-122.25474, 37.80032], [-122.25512, 37.80013], [-122.25557, 37.80006], [-122.25664, 37.79994], [-122.25722, 37.79985], [-122.25777, 37.79968], [-122.25819, 37.79935], [-122.25824, 37.7993], [-122.25824, 37.79923], [-122.25858, 37.79896], [-122.25888, 37.79866], [-122.25918, 37.79855], [-122.26011, 37.79887], [-122.26116, 37.79921], [-122.26165, 37.79967], [-122.26184, 37.79996], [-122.26198, 37.80044], [-122.26215, 37.80084], [-122.26242, 37.8014]], [[-122.26145, 37.80722], [-122.26139, 37.80882], [-122.26124, 37.80951], [-122.26121, 37.81003], [-122.26141, 37.8104], [-122.26188, 37.81046], [-122.26211, 37.81037], [-122.26228, 37.81014], [-122.2626, 37.8087], [-122.2628, 37.80815], [-122.2628, 37.80726], [-122.26245, 37.80641], [-122.26148, 37.80527], [-122.26049, 37.80451], [-122.26049, 37.80382], [-122.26104, 37.80261], [-122.2613, 37.80222], [-122.26151, 37.80087], [-122.26139, 37.80021], [-122.26124, 37.79995], [-122.25917, 37.79895], [-122.25882, 37.7992], [-122.25836, 37.79968], [-122.25712, 37.80039], [-122.25654, 37.80053], [-122.25551, 37.80043], [-122.25507, 37.80057], [-122.25473, 37.80084], [-122.25473, 37.80158], [-122.25484, 37.8019], [-122.25473, 37.80206], [-122.25472, 37.8021], [-122.2539, 37.8032], [-122.25372, 37.80369], [-122.2534, 37.80419], [-122.25118, 37.80494], [-122.2511, 37.80499], [-122.25074, 37.80566], [-122.2503, 37.80668], [-122.24999, 37.80721], [-122.24972, 37.80785], [-122.24972, 37.80836], [-122.24995, 37.80847], [-122.25109, 37.80815], [-122.25146, 37.8081], [-122.25224, 37.80751], [-122.25305, 37.80712], [-122.254, 37.80703], [-122.25475, 37.80716], [-122.25542, 37.80718], [-122.25573, 37.80702], [-122.25625, 37.80655], [-122.25631, 37.8057], [-122.2566, 37.80538], [-122.25787, 37.80485], [-122.25862, 37.80467], [-122.25897, 37.80479], [-122.25945, 37.80556], [-122.26, 37.80604], [-122.26019, 37.80656], [-122.26059, 37.80677], [-122.26115, 37.80678], [-122.26125, 37.80701], [-122.26145, 37.80722]]]} | Open Access 1 | Lakeside Park | 20979 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 89.393 | Lakeside Park | 1957 | |
6108 | 6108 | 6107 | {"type": "MultiPolygon", "coordinates": [[[[-122.18013, 37.79253], [-122.17981, 37.79282], [-122.17941, 37.79279], [-122.17596, 37.79357], [-122.17505, 37.79408], [-122.17472, 37.7943], [-122.17463, 37.79429], [-122.17444, 37.79448], [-122.17406, 37.79414], [-122.17365, 37.79442], [-122.17228, 37.79476], [-122.17135, 37.79479], [-122.17133, 37.79481], [-122.17097, 37.79478], [-122.1707, 37.79471], [-122.17047, 37.79458], [-122.16974, 37.79398], [-122.16928, 37.79357], [-122.16892, 37.79327], [-122.16822, 37.79263], [-122.16806, 37.79245], [-122.16796, 37.79227], [-122.16789, 37.79209], [-122.16785, 37.79193], [-122.16784, 37.79176], [-122.16788, 37.7915], [-122.1681, 37.79098], [-122.17057, 37.79323], [-122.17175, 37.79353], [-122.17287, 37.79283], [-122.17292, 37.79166], [-122.17197, 37.79052], [-122.16881, 37.789], [-122.16813, 37.78913], [-122.16792, 37.78846], [-122.1679, 37.7883], [-122.16789, 37.78772], [-122.16786, 37.78757], [-122.16779, 37.78745], [-122.16763, 37.78728], [-122.16745, 37.78717], [-122.16661, 37.78691], [-122.16664, 37.78689], [-122.16745, 37.78714], [-122.16765, 37.78725], [-122.16781, 37.78742], [-122.16789, 37.78757], [-122.16793, 37.7877], [-122.16793, 37.78828], [-122.16795, 37.78845], [-122.16815, 37.78906], [-122.16956, 37.78877], [-122.17252, 37.7902], [-122.17358, 37.7915], [-122.17355, 37.79269], [-122.17582, 37.79224], [-122.17829, 37.79228], [-122.17945, 37.7917], [-122.17983, 37.79067], [-122.17986, 37.79081], [-122.17985, 37.79099], [-122.1798, 37.79112], [-122.17961, 37.79149], [-122.17959, 37.79159], [-122.17959, 37.79173], [-122.17963, 37.79187], [-122.17977, 37.7921], [-122.17989, 37.79227], [-122.18013, 37.79253]]], [[[-122.18087, 37.79024], [-122.18056, 37.79112], [-122.18056, 37.79116], [-122.18038, 37.79125], [-122.18018, 37.79137], [-122.18001, 37.79153], [-122.17988, 37.79169], [-122.17983, 37.7917], [-122.17981, 37.79169], [-122.17979, 37.79165], [-122.17981, 37.79154], [-122.18001, 37.79114], [-122.18007, 37.79091], [-122.18007, 37.79081], [-122.18005, 37.79069], [-122.18, 37.79058], [-122.17993, 37.79047], [-122.18087, 37.79024]]], [[[-122.18103, 37.79328], [-122.181, 37.79329], [-122.18025, 37.79236], [-122.18009, 37.79219], [-122.17992, 37.79194], [-122.17993, 37.79188], [-122.18013, 37.79163], [-122.18023, 37.79153], [-122.18043, 37.79138], [-122.18065, 37.79128], [-122.18067, 37.79142], [-122.18056, 37.79157], [-122.18058, 37.79199], [-122.18072, 37.79227], [-122.18082, 37.79274], [-122.18103, 37.79328]]], [[[-122.18276, 37.79282], [-122.18229, 37.79322], [-122.182, 37.79305], [-122.18164, 37.79262], [-122.18123, 37.79228], [-122.18113, 37.79187], [-122.18118, 37.79149], [-122.18115, 37.79094], [-122.18123, 37.79041], [-122.18155, 37.79042], [-122.18156, 37.791], [-122.18163, 37.79162], [-122.18276, 37.79282]]]]} | Open Access 1 | Leona Heights | 21171 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 56.779 | Leona Heights | ||
6204 | 6204 | 6203 | {"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 | Lincoln Square | 21275 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1.384 | Lincoln Square | ||
6218 | 6218 | 6217 | {"type": "Polygon", "coordinates": [[[-122.27638, 37.8329], [-122.27622, 37.83345], [-122.2759, 37.83342], [-122.27602, 37.83283], [-122.27638, 37.8329]]]} | Open Access 1 | Linden Park | 21291 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.493 | Linden Park | ||
6291 | 6291 | 6290 | {"type": "Polygon", "coordinates": [[[-122.23738, 37.80443], [-122.23717, 37.80502], [-122.23656, 37.80494], [-122.23636, 37.80518], [-122.23581, 37.80496], [-122.23493, 37.80445], [-122.23412, 37.80402], [-122.23408, 37.80398], [-122.23407, 37.80393], [-122.23411, 37.80388], [-122.23466, 37.80346], [-122.2367, 37.80324], [-122.23676, 37.80353], [-122.23703, 37.80351], [-122.23711, 37.80391], [-122.23696, 37.80399], [-122.23691, 37.8041], [-122.23738, 37.80443]]]} | Open Access 1 | Live Oak Memorial Pool | 21365 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 9.469 | Live Oak Memorial Pool | ||
6437 | 6437 | 6436 | {"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 | Lowell Park | 21557 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 8.709 | Lowell Park | ||
6476 | 6476 | 6475 | {"type": "MultiPolygon", "coordinates": [[[[-122.16513, 37.74516], [-122.16423, 37.74558], [-122.16392, 37.74518], [-122.16494, 37.74491], [-122.16513, 37.74516]]], [[[-122.16709, 37.74587], [-122.1662, 37.74629], [-122.16514, 37.74486], [-122.16614, 37.74459], [-122.16709, 37.74587]]]]} | Open Access 1 | Lyons Field Park | 21613 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 4.901 | Lyons Field Park | ||
6567 | 6567 | 6566 | {"type": "Polygon", "coordinates": [[[-122.24239, 37.81173], [-122.24125, 37.81277], [-122.24123, 37.81275], [-122.24228, 37.81165], [-122.24239, 37.81173]]]} | Open Access 1 | Mandana Plaza Park | 21736 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.29 | Mandana Plaza Park | ||
6569 | 6569 | 6568 | {"type": "MultiPolygon", "coordinates": [[[[-122.28913, 37.82196], [-122.28906, 37.82294], [-122.28882, 37.82299], [-122.2889, 37.82189], [-122.28913, 37.82196]]], [[[-122.28921, 37.82079], [-122.28915, 37.82174], [-122.28915, 37.82174], [-122.28891, 37.82168], [-122.28898, 37.82067], [-122.28921, 37.82079]]], [[[-122.28951, 37.81702], [-122.28944, 37.81762], [-122.28935, 37.81811], [-122.28937, 37.8183], [-122.28931, 37.81936], [-122.28923, 37.82062], [-122.28899, 37.82052], [-122.28913, 37.81859], [-122.28913, 37.81829], [-122.2891, 37.81778], [-122.28911, 37.81751], [-122.28914, 37.81724], [-122.28921, 37.81692], [-122.28951, 37.81702]]], [[[-122.29162, 37.81096], [-122.29125, 37.81197], [-122.29074, 37.81317], [-122.29043, 37.814], [-122.28959, 37.81672], [-122.28929, 37.81662], [-122.28942, 37.8162], [-122.29032, 37.81368], [-122.29051, 37.81305], [-122.29074, 37.81178], [-122.29084, 37.81149], [-122.29106, 37.81095], [-122.29126, 37.81089], [-122.29162, 37.81096]]], [[[-122.293, 37.80588], [-122.29304, 37.80616], [-122.29304, 37.80645], [-122.29302, 37.80674], [-122.29298, 37.80697], [-122.29247, 37.80844], [-122.29191, 37.80994], [-122.29198, 37.80998], [-122.29189, 37.81039], [-122.29176, 37.81079], [-122.29141, 37.8107], [-122.29191, 37.80929], [-122.29243, 37.80791], [-122.29257, 37.80746], [-122.29263, 37.80713], [-122.29264, 37.80701], [-122.29257, 37.80698], [-122.29257, 37.80687], [-122.29262, 37.80674], [-122.29261, 37.80671], [-122.29256, 37.8067], [-122.29257, 37.80624], [-122.2925, 37.8061], [-122.29242, 37.80605], [-122.2922, 37.80594], [-122.29197, 37.80587], [-122.29204, 37.80566], [-122.293, 37.80588]]]]} | Open Access 1 | Mandela Parkway | 21738 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 12.47 | Mandela Parkway | ||
6716 | 6716 | 6715 | {"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 | Marston Campbell Park | 21899 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 2.771 | Marston Campbell Park | ||
6773 | 6773 | 6772 | {"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 | Maxwell Park | 21971 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1.249 | Maxwell Park | 2000 | |
6789 | 6789 | 6788 | {"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 | Mc Crea Park | 21986 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 2.147 | Mc Crea Park | ||
6810 | 6810 | 6809 | {"type": "Polygon", "coordinates": [[[-122.28067, 37.81793], [-122.28059, 37.81813], [-122.28026, 37.81805], [-122.28033, 37.81785], [-122.28067, 37.81793]]]} | Open Access 1 | McClymonds Mini Park | 22003 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.175 | McClymonds MP |
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]);