superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
253 rows where MNG_AGENCY = 32
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
- Open Access 207
- Restricted Access 6
MNG_AG_TYP 1
- City Agency 213
MNG_AGENCY 1
- San Jose, City of · 213 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2390 | 2390 | 2389 | {"type": "Polygon", "coordinates": [[[-121.9176, 37.25993], [-121.91518, 37.26101], [-121.91514, 37.26101], [-121.91508, 37.26099], [-121.91444, 37.26006], [-121.91444, 37.26002], [-121.91445, 37.25999], [-121.91687, 37.25892], [-121.91694, 37.25895], [-121.9176, 37.25989], [-121.9176, 37.25993]]]} | Open Access 1 | Butcher | 16545 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 8.116 | Butcher | 1981 | |
2451 | 2451 | 2450 | {"type": "Polygon", "coordinates": [[[-122.02681, 37.30115], [-122.02645, 37.30261], [-122.02649, 37.30263], [-122.02622, 37.30302], [-122.02611, 37.30314], [-122.02528, 37.30385], [-122.02406, 37.30433], [-122.02399, 37.30413], [-122.02384, 37.30385], [-122.0238, 37.30366], [-122.02376, 37.30168], [-122.0238, 37.30147], [-122.02381, 37.30133], [-122.02383, 37.30129], [-122.02389, 37.30126], [-122.02608, 37.30126], [-122.02635, 37.30123], [-122.02668, 37.30115], [-122.02681, 37.30115]]]} | Open Access 1 | Calabazas | 16668 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 16.77 | Calabazas | 1978 | |
2474 | 2474 | 2473 | {"type": "Polygon", "coordinates": [[[-121.85208, 37.24596], [-121.85169, 37.24702], [-121.85135, 37.24693], [-121.85055, 37.24676], [-121.8482, 37.24621], [-121.84858, 37.24515], [-121.85208, 37.24596]]]} | Open Access 1 | Cahalan | 16655 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 9.756 | Cahalan | 1978 | |
2475 | 2475 | 2474 | {"type": "Polygon", "coordinates": [[[-121.90575, 37.3289], [-121.90546, 37.32891], [-121.9054, 37.32894], [-121.90536, 37.32899], [-121.90535, 37.32904], [-121.90539, 37.32905], [-121.90543, 37.32964], [-121.90462, 37.32968], [-121.90458, 37.32909], [-121.9046, 37.32908], [-121.9046, 37.32905], [-121.90456, 37.32899], [-121.90449, 37.32896], [-121.90424, 37.32896], [-121.90419, 37.32828], [-121.90509, 37.32824], [-121.90511, 37.32842], [-121.90563, 37.3284], [-121.90573, 37.32842], [-121.90575, 37.3289]]]} | Open Access 1 | Cahill Park | 16656 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 3.712 | Cahill Park | 2004 | |
2494 | 2494 | 2493 | {"type": "Polygon", "coordinates": [[[-121.81872, 37.23996], [-121.81869, 37.24127], [-121.8181, 37.24107], [-121.81777, 37.241], [-121.81742, 37.24099], [-121.81736, 37.24095], [-121.81724, 37.24045], [-121.81706, 37.23993], [-121.81872, 37.23996]]]} | Open Access 1 | Calero Park | 16680 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 4.064 | Calero Park | 1980 | |
2589 | 2589 | 2588 | {"type": "Polygon", "coordinates": [[[-121.87874, 37.2851], [-121.87862, 37.28552], [-121.8768, 37.28518], [-121.87693, 37.28476], [-121.87874, 37.2851]]]} | Open Access 1 | Canoas Park | 16806 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1.986 | Canoas Park | 1989 | |
2592 | 2592 | 2591 | {"type": "Polygon", "coordinates": [[[-121.8348, 37.35189], [-121.83476, 37.35193], [-121.83441, 37.35211], [-121.83384, 37.35234], [-121.83324, 37.3525], [-121.83257, 37.35262], [-121.83141, 37.35137], [-121.83268, 37.35051], [-121.83287, 37.35071], [-121.83341, 37.35039], [-121.83478, 37.35184], [-121.8348, 37.35189]]]} | Open Access 1 | Capitol | 16836 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 10.602 | Capitol | 1967 | |
2593 | 2593 | 2592 | {"type": "Polygon", "coordinates": [[[-121.76924, 37.29043], [-121.76917, 37.29049], [-121.7689, 37.29058], [-121.76865, 37.29073], [-121.76858, 37.29075], [-121.76849, 37.29075], [-121.76842, 37.29071], [-121.76826, 37.29055], [-121.76792, 37.29031], [-121.76785, 37.29021], [-121.76784, 37.29013], [-121.76786, 37.29009], [-121.76798, 37.2901], [-121.76798, 37.29014], [-121.76802, 37.29016], [-121.76855, 37.29025], [-121.76872, 37.29026], [-121.76892, 37.29023], [-121.76906, 37.29024], [-121.76914, 37.29027], [-121.76919, 37.29032], [-121.76923, 37.29038], [-121.76924, 37.29043]]]} | Open Access 1 | Canyon Creek Park | 16813 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1.151 | Canyon Creek Park | 2005 | |
2643 | 2643 | 2642 | {"type": "Polygon", "coordinates": [[[-121.9386, 37.25096], [-121.93856, 37.25097], [-121.93856, 37.25136], [-121.93859, 37.25139], [-121.93853, 37.2516], [-121.93847, 37.25158], [-121.93834, 37.25157], [-121.93822, 37.25152], [-121.93802, 37.25154], [-121.93796, 37.25148], [-121.93794, 37.25145], [-121.93794, 37.25078], [-121.93797, 37.25073], [-121.93804, 37.2507], [-121.9386, 37.2507], [-121.9386, 37.25096]]]} | Open Access 1 | Carolyn Norris Park | 16888 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1.303 | Carolyn Norris Park | ||
2659 | 2659 | 2658 | {"type": "Polygon", "coordinates": [[[-121.83615, 37.21266], [-121.836, 37.21253], [-121.83574, 37.21238], [-121.83546, 37.21225], [-121.83482, 37.21202], [-121.83481, 37.21199], [-121.83493, 37.21118], [-121.83495, 37.21093], [-121.83549, 37.21093], [-121.83549, 37.21084], [-121.83582, 37.21077], [-121.83615, 37.21266]]]} | Open Access 1 | Carrabelle Park | 16907 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 3.684 | Carrabelle Park | 1991 | |
2701 | 2701 | 2700 | {"type": "Polygon", "coordinates": [[[-121.87631, 37.40276], [-121.87599, 37.40296], [-121.87594, 37.40287], [-121.87584, 37.40275], [-121.87572, 37.40268], [-121.87554, 37.4026], [-121.87545, 37.40254], [-121.87456, 37.40155], [-121.87443, 37.40145], [-121.87422, 37.40134], [-121.87408, 37.40129], [-121.87384, 37.40126], [-121.87369, 37.40126], [-121.87353, 37.40129], [-121.87331, 37.40137], [-121.87154, 37.40238], [-121.87135, 37.40245], [-121.87107, 37.40248], [-121.87083, 37.40256], [-121.87028, 37.40286], [-121.87021, 37.40285], [-121.86956, 37.40213], [-121.86942, 37.40207], [-121.86929, 37.40208], [-121.86659, 37.40363], [-121.86648, 37.40364], [-121.86643, 37.40363], [-121.86638, 37.40358], [-121.86565, 37.4026], [-121.86496, 37.4016], [-121.86511, 37.40159], [-121.86517, 37.40165], [-121.86521, 37.40166], [-121.86527, 37.40166], [-121.86534, 37.40161], [-121.86534, 37.40154], [-121.86538, 37.4015], [-121.86584, 37.40127], [-121.8659, 37.40127], [-121.86596, 37.40131], [-121.86627, 37.40174], [-121.86641, 37.40187], [-121.86649, 37.40191], [-121.86664, 37.40199], [-121.8668, 37.40203], [-121.86696, 37.40206], [-121.8672, 37.40205], [-121.86743, 37.402], [-121.86766, 37.40189], [-121.86873, 37.40129], [-121.86887, 37.40123], [-121.86914, 37.40118], [-121.86929, 37.40114], [-121.8699, 37.4008], [-121.86996, 37.40082], [-121.87035, 37.40125], [-121.87054, 37.40138], [-121.87068, 37.40144], [-121.87091, 37.4015], [-121.87108, 37.40151], [-121.87124, 37.4015], [-121.8714, 37.40146], [-121.87162, 37.40137], [-121.87371, 37.40016], [-121.87375, 37.40013], [-121.87377, 37.40008], [-121.87387, 37.40009], [-121.87423, 37.39987], [-121.87494, 37.40039], [-121.87514, 37.40056], [-121.87531, 37.40075], [-121.87546, 37.40095], [-121.8757, 37.40137], [-121.87631, 37.40276]]]} | Open Access 1 | Cataldi | 16968 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 32.699 | Cataldi | 1980 | |
2707 | 2707 | 2706 | {"type": "Polygon", "coordinates": [[[-121.84745, 37.20134], [-121.84565, 37.20254], [-121.84563, 37.20249], [-121.84558, 37.20246], [-121.84551, 37.20245], [-121.84545, 37.20247], [-121.84542, 37.20251], [-121.84542, 37.20256], [-121.84544, 37.2026], [-121.84551, 37.20264], [-121.8452, 37.20285], [-121.84461, 37.20322], [-121.8433, 37.20177], [-121.84341, 37.20185], [-121.84347, 37.20186], [-121.84352, 37.20184], [-121.84355, 37.2018], [-121.84354, 37.20175], [-121.84342, 37.20169], [-121.84517, 37.20043], [-121.84539, 37.20021], [-121.84556, 37.19995], [-121.84566, 37.20001], [-121.84567, 37.20007], [-121.84573, 37.20011], [-121.84578, 37.20011], [-121.84589, 37.20008], [-121.84634, 37.20012], [-121.8466, 37.20018], [-121.84684, 37.20031], [-121.8472, 37.20066], [-121.84718, 37.20071], [-121.8472, 37.20078], [-121.84745, 37.20134]]]} | Open Access 1 | Cathedral Oaks Park | 16975 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 16.969 | Cathedral Oaks Park | ||
2709 | 2709 | 2708 | {"type": "Polygon", "coordinates": [[[-121.82582, 37.2727], [-121.82555, 37.27295], [-121.82555, 37.27309], [-121.82505, 37.2734], [-121.82524, 37.2741], [-121.82307, 37.27331], [-121.82274, 37.2722], [-121.82283, 37.27213], [-121.82287, 37.27198], [-121.82297, 37.27176], [-121.823, 37.27172], [-121.82304, 37.27172], [-121.82351, 37.27185], [-121.82582, 37.2727]]]} | Open Access 1 | Danna Rock Park | 17921 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 9.563 | Danna Rock Park | 1985 | |
2795 | 2795 | 2794 | {"type": "Polygon", "coordinates": [[[-121.82621, 37.22902], [-121.82609, 37.22903], [-121.82597, 37.22907], [-121.82581, 37.22918], [-121.82515, 37.22872], [-121.82423, 37.22874], [-121.824, 37.22889], [-121.82393, 37.22912], [-121.82384, 37.22914], [-121.82378, 37.22909], [-121.82302, 37.22908], [-121.82296, 37.22912], [-121.82289, 37.2291], [-121.82283, 37.22911], [-121.82278, 37.22913], [-121.82275, 37.22918], [-121.82205, 37.22899], [-121.82192, 37.22928], [-121.82184, 37.2293], [-121.8218, 37.22936], [-121.82181, 37.22943], [-121.8219, 37.22951], [-121.8219, 37.22962], [-121.82152, 37.22964], [-121.82153, 37.23028], [-121.82141, 37.23029], [-121.82132, 37.23032], [-121.82132, 37.23054], [-121.82111, 37.23048], [-121.82083, 37.23034], [-121.82063, 37.23027], [-121.82065, 37.23], [-121.82039, 37.22994], [-121.82019, 37.22983], [-121.82009, 37.22971], [-121.81999, 37.22949], [-121.81985, 37.22937], [-121.81966, 37.2293], [-121.81919, 37.22926], [-121.81908, 37.22923], [-121.81898, 37.22918], [-121.8184, 37.22859], [-121.81824, 37.22848], [-121.81803, 37.22841], [-121.81799, 37.22825], [-121.81792, 37.22813], [-121.81781, 37.22804], [-121.81768, 37.22798], [-121.81765, 37.22798], [-121.81748, 37.22821], [-121.81742, 37.22823], [-121.81738, 37.22828], [-121.81738, 37.22878], [-121.81735, 37.22895], [-121.8173, 37.22906], [-121.81721, 37.22921], [-121.81703, 37.22939], [-121.81698, 37.22942], [-121.81627, 37.22915], [-121.81639, 37.22894], [-121.81612, 37.2287], [-121.81599, 37.22855], [-121.81608, 37.22841], [-121.81614, 37.22821], [-121.81616, 37.22805], [-121.81614, 37.22792], [-121.81608, 37.22777], [-121.816, 37.22766], [-121.81586, 37.22754], [-121.81576, 37.22748], [-121.81562, 37.22744], [-121.81549, 37.22744], [-121.81535, 37.22747], [-121.81523, 37.22753], [-121.81489, 37.22788], [-121.81461, 37.22822], [-121.81432, 37.22822], [-121.81409, 37.22815], [-121.81424, 37.22795], [-121.81408, 37.22783], [-121.81395, 37.2277], [-121.8139, 37.22761], [-121.81379, 37.22735], [-121.81364, 37.22711], [-121.81345, 37.22694], [-121.81327, 37.22687], [-121.81305, 37.22685], [-121.81294, 37.22688], [-121.81282, 37.22694], [-121.81269, 37.22707], [-121.81254, 37.22738], [-121.81249, 37.22743], [-121.81241, 37.22747], [-121.81229, 37.22749], [-121.81185, 37.22747], [-121.81159, 37.22753], [-121.81159, 37.22777], [-121.81095, 37.22777], [-121.81094, 37.22749], [-121.81111, 37.22727], [-121.81114, 37.22712], [-121.81111, 37.22701], [-121.81105, 37.22692], [-121.811, 37.22688], [-121.8109, 37.22684], [-121.81079, 37.22684], [-121.8104, 37.22691], [-121.80977, 37.22689], [-121.80969, 37.22692], [-121.80965, 37.22696], [-121.80956, 37.22715], [-121.80951, 37.22719], [-121.80916, 37.2272], [-121.8089, 37.22718], [-121.80882, 37.22725], [-121.80876, 37.22723], [-121.80882, 37.22714], [-121.80863, 37.22699], [-121.80856, 37.22698], [-121.80789, 37.22745], [-121.8078, 37.22744], [-121.80772, 37.22747], [-121.80771, 37.2274], [-121.80756, 37.22737], [-121.80742, 37.22737], [-121.80691, 37.22759], [-121.8069, 37.22782], [-121.80642, 37.22782], [-121.80642, 37.22759], [-121.80635, 37.22752], [-121.80634, 37.22703], [-121.80667, 37.22672], [-121.80696, 37.22647], [-121.80765, 37.22592], [-121.80832, 37.22661], [-121.80871, 37.22656], [-121.80883, 37.2269], [-121.80912, 37.22698], [-121.80945, 37.22694], [-121.80984, 37.2267], [-121.81032, 37.22681], [-121.81081, 37.22668], [-121.81142, 37.22669], [-121.81153, 37.22701], [-121.81164, 37.22719], [-121.81182, 37.22724], [-121.81199, 37.22723], [-121.81212, 37.22723], [-121.81245, 37.22711], [-121.81289, 37.22685], [-121.81337, 37.22683], [-121.8136, 37.22697], [-121.81423, 37.22782], [-121.81459, 37.22793], [-121.81528, 37.22743], [-121.81539, 37.22738], [-121.81554, 37.22736], [-121.81569, 37.22737], [-121.81582, 37.22741], [-121.81609, 37.22759], [-121.8163, 37.22808], [-121.81639, 37.2282], [-121.81648, 37.2283], [-121.81654, 37.22834], [-121.81678, 37.22838], [-121.81682, 37.22841], [-121.81732, 37.22816], [-121.81744, 37.22785], [-121.81783, 37.22786], [-121.81806, 37.2281], [-121.81851, 37.22843], [-121.81904, 37.22851], [-121.81926, 37.22902], [-121.81954, 37.22905], [-121.82014, 37.22903], [-121.82035, 37.22959], [-121.82053, 37.22974], [-121.82099, 37.2299], [-121.82124, 37.2298], [-121.82147, 37.22942], [-121.82159, 37.22835], [-121.82162, 37.22823], [-121.82184, 37.22817], [-121.82211, 37.22826], [-121.8223, 37.22837], [-121.82261, 37.22857], [-121.82297, 37.22873], [-121.82325, 37.2288], [-121.82358, 37.22879], [-121.82377, 37.22872], [-121.82412, 37.22849], [-121.82455, 37.22833], [-121.8247, 37.22818], [-121.82496, 37.22811], [-121.82507, 37.22813], [-121.82515, 37.22844], [-121.82529, 37.22858], [-121.8255, 37.22867], [-121.82587, 37.22874], [-121.82604, 37.22875], [-121.82615, 37.22867], [-121.82621, 37.22902]]]} | Open Access 1 | Century Oaks | 17076 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 23.11 | Century Oaks | 1976 | |
2857 | 2857 | 2856 | {"type": "Polygon", "coordinates": [[[-121.80092, 37.24396], [-121.80092, 37.24396], [-121.7994, 37.24355], [-121.7995, 37.24329], [-121.80074, 37.24363], [-121.80084, 37.24368], [-121.8009, 37.24376], [-121.80092, 37.24396]]]} | Open Access 1 | Charlotte Commons | 17148 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1.001 | Charlotte Commons | ||
2902 | 2902 | 2901 | {"type": "Polygon", "coordinates": [[[-121.84341, 37.36447], [-121.84319, 37.36462], [-121.84225, 37.36365], [-121.84266, 37.36339], [-121.84316, 37.36422], [-121.84341, 37.36447]]]} | Open Access 1 | Children of the Rainbow Park | 17197 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1.1 | Children of the Rainbow Park | 1989 | |
2939 | 2939 | 2938 | {"type": "Polygon", "coordinates": [[[-121.81932, 37.25991], [-121.81815, 37.25992], [-121.81815, 37.25986], [-121.81821, 37.25982], [-121.81824, 37.25976], [-121.81822, 37.25971], [-121.81813, 37.25964], [-121.81812, 37.2596], [-121.81812, 37.25948], [-121.81819, 37.25924], [-121.81822, 37.25905], [-121.81826, 37.25902], [-121.81831, 37.25901], [-121.81906, 37.25906], [-121.8192, 37.25906], [-121.81928, 37.25909], [-121.81932, 37.25913], [-121.81933, 37.25918], [-121.81932, 37.25991]]]} | Open Access 1 | Chynoweth Park | 17252 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 2.449 | Chynoweth Park | 2001 | |
2941 | 2941 | 2940 | {"type": "Polygon", "coordinates": [[[-121.84023, 37.38539], [-121.84022, 37.38543], [-121.84008, 37.38557], [-121.84, 37.3856], [-121.83996, 37.38565], [-121.83994, 37.3857], [-121.83996, 37.38576], [-121.83942, 37.38602], [-121.83933, 37.38599], [-121.83924, 37.386], [-121.83918, 37.38607], [-121.83918, 37.38613], [-121.83862, 37.38641], [-121.83773, 37.38527], [-121.83772, 37.38523], [-121.83774, 37.38519], [-121.83777, 37.38517], [-121.83922, 37.38454], [-121.83928, 37.38456], [-121.8394, 37.38472], [-121.83956, 37.38486], [-121.84022, 37.38534], [-121.84023, 37.38539]]]} | Open Access 1 | Cimarron Park | 17256 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 6.24 | Cimarron Park | 1981 | |
3014 | 3014 | 3013 | {"type": "Polygon", "coordinates": [[[-121.77619, 37.31251], [-121.77616, 37.31256], [-121.77565, 37.31284], [-121.77558, 37.31283], [-121.77541, 37.31269], [-121.77596, 37.3123], [-121.77617, 37.31248], [-121.77619, 37.31251]]]} | Open Access 1 | Classico Park | 17392 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.476 | Classico Park | 2004 | |
3124 | 3124 | 3123 | {"type": "MultiPolygon", "coordinates": [[[[-121.9093, 37.34496], [-121.9093, 37.34499], [-121.90788, 37.34598], [-121.9071, 37.34525], [-121.90708, 37.3452], [-121.90843, 37.34425], [-121.90847, 37.34424], [-121.90854, 37.34426], [-121.90928, 37.34492], [-121.9093, 37.34496]]], [[[-121.91054, 37.34412], [-121.90959, 37.34479], [-121.90952, 37.34481], [-121.90945, 37.34479], [-121.90871, 37.34414], [-121.90869, 37.34409], [-121.90872, 37.34405], [-121.90972, 37.34339], [-121.90975, 37.34339], [-121.91054, 37.34412]]]]} | Open Access 1 | Columbus Park | 17551 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 8.016 | Columbus 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]);