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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4742 | 4742 | 4741 | {"type": "Polygon", "coordinates": [[[-122.19545, 37.76061], [-122.19446, 37.76127], [-122.19282, 37.75967], [-122.1938, 37.759], [-122.19545, 37.76061]]]} | Open Access 1 | Greenman Field | 19482 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 6.433 | Greenman Field | ||
4779 | 4779 | 4778 | {"type": "MultiPolygon", "coordinates": [[[[-122.26828, 37.82304], [-122.26803, 37.82378], [-122.2678, 37.82373], [-122.26765, 37.82361], [-122.26722, 37.82337], [-122.26718, 37.82326], [-122.26743, 37.82313], [-122.26754, 37.82287], [-122.26828, 37.82304]]], [[[-122.26978, 37.82379], [-122.26952, 37.8249], [-122.26929, 37.82574], [-122.26889, 37.82573], [-122.26877, 37.82584], [-122.26874, 37.82598], [-122.26863, 37.82624], [-122.26834, 37.82621], [-122.26843, 37.82585], [-122.26847, 37.82562], [-122.26845, 37.82533], [-122.26847, 37.8252], [-122.26902, 37.82323], [-122.2697, 37.82339], [-122.26961, 37.82373], [-122.26978, 37.82379]]]]} | Open Access 1 | Grove Shafter | 19535 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 7.03 | Grove Shafter | ||
4884 | 4884 | 4883 | {"type": "Polygon", "coordinates": [[[-122.24942, 37.80932], [-122.24938, 37.80939], [-122.24931, 37.80946], [-122.24928, 37.80945], [-122.2488, 37.80985], [-122.2487, 37.8099], [-122.24861, 37.80991], [-122.24845, 37.8099], [-122.24794, 37.80972], [-122.24743, 37.80959], [-122.24735, 37.80954], [-122.24733, 37.80948], [-122.24734, 37.80941], [-122.2474, 37.80935], [-122.24844, 37.80887], [-122.24857, 37.80883], [-122.24867, 37.80882], [-122.24882, 37.80883], [-122.24898, 37.80888], [-122.24937, 37.80917], [-122.24941, 37.80923], [-122.24942, 37.80932]]]} | Open Access 1 | Lakeshore Park | 20973 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 3.388 | Lakeshore Park | ||
4908 | 4908 | 4907 | {"type": "Polygon", "coordinates": [[[-122.25812, 37.842], [-122.25806, 37.84208], [-122.25715, 37.84239], [-122.25706, 37.84226], [-122.25722, 37.84209], [-122.25728, 37.84206], [-122.2574, 37.84191], [-122.25746, 37.84176], [-122.25754, 37.8418], [-122.2576, 37.84174], [-122.25812, 37.842]]]} | Open Access 1 | Hardy Dog Park | 19677 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.788 | Hardy Dog Park | ||
5006 | 5006 | 5005 | {"type": "Polygon", "coordinates": [[[-122.23329, 37.77571], [-122.23316, 37.77586], [-122.233, 37.77562], [-122.23306, 37.77558], [-122.23329, 37.77571]]]} | Open Access 1 | Lasear Park | 21074 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.085 | Lasear Park | ||
5015 | 5015 | 5014 | {"type": "Polygon", "coordinates": [[[-122.26926, 37.83718], [-122.26919, 37.8378], [-122.26919, 37.8378], [-122.26883, 37.83723], [-122.26926, 37.83718]]]} | Open Access 1 | Helen McGregor Plaza Park | 19798 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.317 | Helen McGregor Plaza Park | ||
5034 | 5034 | 5033 | {"type": "Polygon", "coordinates": [[[-122.14328, 37.74591], [-122.14195, 37.74665], [-122.14191, 37.74665], [-122.14189, 37.74663], [-122.14177, 37.74666], [-122.14117, 37.74669], [-122.14076, 37.74681], [-122.14056, 37.74658], [-122.1402, 37.74669], [-122.13981, 37.7464], [-122.13983, 37.74622], [-122.13976, 37.74603], [-122.1392, 37.7457], [-122.13899, 37.7455], [-122.13879, 37.74543], [-122.13889, 37.74485], [-122.13872, 37.74464], [-122.14026, 37.7439], [-122.14035, 37.74468], [-122.14109, 37.74459], [-122.14156, 37.74496], [-122.14192, 37.74504], [-122.14328, 37.74591]]]} | Open Access 1 | Hellman Recreation Area | 19807 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 16.584 | Hellman Rec. Area | ||
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 |
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]);