superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9,670 rows where ACCESS_TYP = 1 and MNG_AG_TYP = 2 sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP
ACCESS_TYP 1
- Open Access · 9,670 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10280 | 10280 | 10279 | {"type": "Polygon", "coordinates": [[[-117.28319, 33.04494], [-117.28317, 33.045], [-117.28306, 33.045], [-117.28307, 33.04496], [-117.28303, 33.04494], [-117.28299, 33.04494], [-117.28295, 33.04496], [-117.28294, 33.045], [-117.2829, 33.04497], [-117.28291, 33.04454], [-117.28293, 33.04452], [-117.28296, 33.04453], [-117.28319, 33.04492], [-117.28319, 33.04494]]]} | Open Access 1 | Unknown park - Encinitas, City of | 28635 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 0.21 | |||
10305 | 10305 | 10304 | {"type": "Polygon", "coordinates": [[[-122.29703, 38.32248], [-122.29673, 38.32253], [-122.29668, 38.3225], [-122.29665, 38.32238], [-122.29698, 38.32231], [-122.29703, 38.32248]]]} | Open Access 1 | Unknown park - Napa, City of | 28648 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 0.139 | |||
11699 | 11699 | 11698 | {"type": "Polygon", "coordinates": [[[-121.94894, 37.95659], [-121.94812, 37.95676], [-121.94769, 37.95718], [-121.94595, 37.95732], [-121.94556, 37.95747], [-121.94522, 37.95733], [-121.94478, 37.95735], [-121.94426, 37.95733], [-121.94353, 37.95711], [-121.94302, 37.957], [-121.94253, 37.95683], [-121.94236, 37.95692], [-121.94229, 37.95689], [-121.94223, 37.9569], [-121.94208, 37.95672], [-121.94172, 37.95664], [-121.94141, 37.95649], [-121.94116, 37.95642], [-121.94053, 37.95602], [-121.9399, 37.9559], [-121.94005, 37.95573], [-121.94022, 37.9556], [-121.94045, 37.95581], [-121.94064, 37.95573], [-121.9428, 37.95516], [-121.94301, 37.95513], [-121.94349, 37.95516], [-121.94377, 37.95516], [-121.94406, 37.95513], [-121.94503, 37.95483], [-121.94529, 37.95473], [-121.94551, 37.95461], [-121.94551, 37.95459], [-121.9453, 37.95439], [-121.94545, 37.95428], [-121.94565, 37.95443], [-121.94581, 37.95462], [-121.94617, 37.9549], [-121.94641, 37.95496], [-121.94663, 37.95505], [-121.94703, 37.95524], [-121.94707, 37.9552], [-121.94792, 37.95578], [-121.9482, 37.95594], [-121.94845, 37.95617], [-121.9486, 37.95614], [-121.94868, 37.95609], [-121.9488, 37.9563], [-121.94894, 37.95659]]]} | Open Access 1 | Unnamed site - Concord, City of | 30380 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 35.165 | |||
12088 | 12088 | 12087 | {"type": "MultiPolygon", "coordinates": [[[[-124.10601, 40.49914], [-124.10572, 40.49916], [-124.10573, 40.49867], [-124.10555, 40.49848], [-124.10587, 40.49829], [-124.10601, 40.49914]]], [[[-124.10652, 40.49814], [-124.10615, 40.49811], [-124.10585, 40.49742], [-124.10585, 40.49742], [-124.10652, 40.49814]]]]} | Open Access 1 | Unknown park - Rio Dell, City of | http://www.riodellcity.com/planning-pdf/Rio%20Dell%20Zoning%20Map.pdf | 30546 | 1435 | Rio Dell, City of 632 | City 2 | City Agency 2 | http://www.riodellcity.com/ | City 2 | 0.75 | ||
12107 | 12107 | 12106 | {"type": "Polygon", "coordinates": [[[-124.10655, 40.50715], [-124.10654, 40.50718], [-124.10649, 40.5072], [-124.10591, 40.5071], [-124.10587, 40.50708], [-124.10587, 40.50705], [-124.10588, 40.50702], [-124.10605, 40.50694], [-124.10617, 40.50686], [-124.1063, 40.50671], [-124.10635, 40.50669], [-124.1064, 40.50673], [-124.10649, 40.50701], [-124.10655, 40.50715]]]} | Open Access 1 | Unnamed site - Rio Dell, City of | 30560 | 1435 | Rio Dell, City of 632 | City 2 | City Agency 2 | http://www.riodellcity.com/ | City 2 | 0.418 | |||
13517 | 13517 | 13516 | {"type": "Polygon", "coordinates": [[[-122.49889, 37.96947], [-122.49879, 37.96966], [-122.49802, 37.97002], [-122.49766, 37.97016], [-122.49731, 37.97028], [-122.49713, 37.97033], [-122.49695, 37.97036], [-122.49659, 37.97038], [-122.49622, 37.97037], [-122.49578, 37.9703], [-122.49568, 37.97019], [-122.49615, 37.96878], [-122.4984, 37.96946], [-122.49886, 37.96944], [-122.49889, 37.96947]]]} | Open Access 1 | Unnamed site - San Rafael, City of | 32671 | 1312 | San Rafael, City of 349 | City 2 | City Agency 2 | http://www.cityofsanrafael.org/comsvcs-home/ | City 2 | 7.23 | |||
14037 | 14037 | 14036 | {"type": "Polygon", "coordinates": [[[-118.86173, 34.28582], [-118.86002, 34.28619], [-118.85448, 34.28618], [-118.85629, 34.28478], [-118.85712, 34.28437], [-118.85736, 34.28427], [-118.85765, 34.28419], [-118.85807, 34.28414], [-118.85838, 34.28414], [-118.85869, 34.28418], [-118.85895, 34.28424], [-118.85927, 34.28436], [-118.85956, 34.28452], [-118.85984, 34.28474], [-118.85998, 34.28489], [-118.86011, 34.28504], [-118.86013, 34.28504], [-118.86021, 34.28521], [-118.86035, 34.28538], [-118.86048, 34.2855], [-118.86063, 34.28561], [-118.86086, 34.28572], [-118.86114, 34.2858], [-118.86143, 34.28584], [-118.86173, 34.28582]]]} | Open Access 1 | Unnamed site - Moorpark, City of | 33324 | 1214 | Moorpark, City of 168 | City 2 | City Agency 2 | http://www.moorparkca.gov/199/Recreation | City 2 | 21.957 | |||
14114 | 14114 | 14113 | {"type": "Polygon", "coordinates": [[[-120.63297, 36.97684], [-120.63292, 36.97688], [-120.63232, 36.97688], [-120.63228, 36.97685], [-120.63228, 36.97652], [-120.63297, 36.97652], [-120.63297, 36.97684]]]} | Open Access 1 | Unknown park - Dos Palos, City of | 33657 | 1460 | Dos Palos, City of 190 | City 2 | City Agency 2 | City 2 | 0.607 | ||||
14272 | 14272 | 14271 | {"type": "MultiPolygon", "coordinates": [[[[-122.57219, 38.57658], [-122.57184, 38.57719], [-122.57089, 38.57682], [-122.57116, 38.57631], [-122.57219, 38.57658]]], [[[-122.59131, 38.58052], [-122.59118, 38.58071], [-122.59058, 38.58066], [-122.59033, 38.5805], [-122.59051, 38.58045], [-122.59131, 38.58052]]], [[[-122.59352, 38.58594], [-122.59328, 38.58619], [-122.59306, 38.58597], [-122.59325, 38.58577], [-122.59352, 38.58594]]]]} | Open Access 1 | Unnamed site - Calistoga, City of | 28631 | 1042 | Calistoga, City of 755 | City 2 | City Agency 2 | http://www.ci.calistoga.ca.us/ | City 2 | 2.194 | |||
14274 | 14274 | 14273 | {"type": "Polygon", "coordinates": [[[-120.18846, 36.61384], [-120.18812, 36.61416], [-120.18658, 36.61417], [-120.18447, 36.61277], [-120.18626, 36.61114], [-120.18632, 36.61119], [-120.18564, 36.61182], [-120.18563, 36.61183], [-120.18846, 36.61384]]]} | Open Access 1 | Unknown park - San Joaquin, City of | 28660 | 1302 | San Joaquin, City of 225 | City 2 | City Agency 2 | http://www.cityofsanjoaquin.org/ | City 2 | 11.13 | |||
14275 | 14275 | 14274 | {"type": "MultiPolygon", "coordinates": [[[[-120.65368, 35.25981], [-120.65355, 35.25973], [-120.65336, 35.25938], [-120.65327, 35.25852], [-120.65304, 35.25837], [-120.65297, 35.25826], [-120.65294, 35.25809], [-120.653, 35.2577], [-120.65339, 35.25769], [-120.65368, 35.25981]]], [[[-120.65374, 35.27663], [-120.65364, 35.27676], [-120.65352, 35.27662], [-120.65365, 35.27654], [-120.65374, 35.27663]]], [[[-120.68305, 35.25007], [-120.68298, 35.25011], [-120.68277, 35.25009], [-120.68274, 35.25012], [-120.68269, 35.25007], [-120.68285, 35.24982], [-120.68305, 35.25007]]]]} | Open Access 1 | Unnamed site - San Luis Obispo, City of | 28661 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1.835 | |||
14280 | 14280 | 14279 | {"type": "MultiPolygon", "coordinates": [[[[-122.27703, 38.31682], [-122.27674, 38.3171], [-122.27646, 38.31702], [-122.27594, 38.31695], [-122.27565, 38.31688], [-122.27558, 38.31653], [-122.27581, 38.31638], [-122.27597, 38.3162], [-122.27656, 38.31622], [-122.27679, 38.31615], [-122.27678, 38.31633], [-122.27683, 38.31652], [-122.27691, 38.31667], [-122.27703, 38.31682]]], [[[-122.27749, 38.30276], [-122.27737, 38.30283], [-122.27718, 38.30304], [-122.27707, 38.30306], [-122.27701, 38.30305], [-122.27692, 38.30298], [-122.27666, 38.3027], [-122.27686, 38.3028], [-122.27707, 38.30284], [-122.27729, 38.30283], [-122.27735, 38.30281], [-122.27736, 38.30279], [-122.27749, 38.30276]]], [[[-122.28082, 38.28098], [-122.27751, 38.28071], [-122.27753, 38.28051], [-122.28081, 38.28064], [-122.28082, 38.28098]]], [[[-122.28563, 38.32175], [-122.28561, 38.32179], [-122.28539, 38.32195], [-122.28528, 38.32197], [-122.28528, 38.32154], [-122.28548, 38.3215], [-122.28563, 38.3217], [-122.28563, 38.32175]]], [[[-122.28633, 38.32236], [-122.2863, 38.32236], [-122.28528, 38.32252], [-122.28528, 38.3224], [-122.28534, 38.32223], [-122.28539, 38.32215], [-122.28547, 38.32206], [-122.28558, 38.32197], [-122.28568, 38.32191], [-122.28575, 38.3219], [-122.2858, 38.3219], [-122.28614, 38.32221], [-122.28633, 38.32236]]], [[[-122.28707, 38.32222], [-122.28659, 38.32231], [-122.28628, 38.32208], [-122.2861, 38.32192], [-122.28591, 38.32174], [-122.2857, 38.32146], [-122.28679, 38.32126], [-122.28707, 38.32222]]], [[[-122.28917, 38.3009], [-122.28907, 38.30095], [-122.28902, 38.30095], [-122.28885, 38.30075], [-122.28901, 38.30069], [-122.28917, 38.3009]]], [[[-122.28966, 38.30079], [-122.28933, 38.30084], [-122.28919, 38.30061], [-122.28952, 38.30046], [-122.28962, 38.30044], [-122.28966, 38.30079]]], [[[-122.2977, 38.32825], [-122.2972, 38.3285], [-122.29663, 38.32864], [-122.29655, 38.32859], [-122.29758, 38.3281], [-122.2977, 38.32825]]], [[[-122.31677, 38.29327], [-122.31482, 38.29396], [-122.31422, 38.29403], [-122.31412, 38.29363], [-122.31425, 38.29329], [-122.31436, 38.29316], [-122.31439, 38.29308], [-122.3144, 38.29298], [-122.31651, 38.29297], [-122.31651, 38.29326], [-122.31677, 38.29327]]], [[[-122.31969, 38.31537], [-122.31968, 38.3154], [-122.31965, 38.31542], [-122.31947, 38.31545], [-122.31931, 38.31498], [-122.31956, 38.3152], [-122.31969, 38.31537]]], [[[-122.34106, 38.30681], [-122.341, 38.30679], [-122.34093, 38.30667], [-122.34086, 38.30658], [-122.34045, 38.3062], [-122.34007, 38.30593], [-122.33968, 38.30568], [-122.33914, 38.3054], [-122.3391, 38.30534], [-122.33912, 38.30527], [-122.33923, 38.30535], [-122.33938, 38.3054], [-122.33952, 38.30542], [-122.33961, 38.30547], [-122.33966, 38.30552], [-122.3398, 38.30569], [-122.33993, 38.3058], [-122.34011, 38.30586], [-122.34049, 38.30593], [-122.34063, 38.30599], [-122.34068, 38.30605], [-122.34073, 38.30625], [-122.3408, 38.30635], [-122.34083, 38.30638], [-122.34091, 38.30639], [-122.34105, 38.30635], [-122.34106, 38.30681]]], [[[-122.34618, 38.30909], [-122.34597, 38.30934], [-122.34614, 38.30944], [-122.34597, 38.30955], [-122.34589, 38.30957], [-122.34581, 38.30954], [-122.34512, 38.30898], [-122.34519, 38.30876], [-122.34544, 38.30879], [-122.34534, 38.30903], [-122.34535, 38.30905], [-122.34568, 38.30906], [-122.34612, 38.30899], [-122.34618, 38.30909]]], [[[-122.3487, 38.31069], [-122.34864, 38.31088], [-122.34806, 38.31077], [-122.34714, 38.31048], [-122.34688, 38.31036], [-122.34665, 38.31022], [-122.34613, 38.30976], [-122.3461, 38.30972], [-122.34611, 38.30968], [-122.34617, 38.30961], [-122.34625, 38.30956], [-122.34634, 38.30965], [-122.34665, 38.30968], [-122.34674, 38.30993], [-122.34686, 38.31013], [-122.34725, 38.31024], [-122.3475, 38.31039], [-122.34763, 38.31031], [-122.34789, 38.31052], [-122.34805, 38.31036], [-122.34821, 38.31049], [-122.34838, 38.31044], [-122.34859, 38.31072], [-122.3487, 38.31069]]]]} | Open Access 1 | Unnamed site - Napa, City of | 28646 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 16.577 | |||
14282 | 14282 | 14281 | {"type": "MultiPolygon", "coordinates": [[[[-121.77531, 36.91167], [-121.77503, 36.91227], [-121.77428, 36.91196], [-121.77397, 36.91189], [-121.77363, 36.91186], [-121.77326, 36.91191], [-121.77314, 36.91171], [-121.77244, 36.91195], [-121.77201, 36.91199], [-121.77149, 36.91185], [-121.77153, 36.91119], [-121.77249, 36.91129], [-121.77282, 36.9112], [-121.77299, 36.91105], [-121.77342, 36.91099], [-121.77355, 36.91109], [-121.77531, 36.91167]]], [[[-121.78001, 36.90996], [-121.7796, 36.90977], [-121.77934, 36.90977], [-121.77882, 36.90995], [-121.77805, 36.91048], [-121.77599, 36.91021], [-121.77576, 36.91069], [-121.7756, 36.91016], [-121.77561, 36.91007], [-121.77568, 36.90995], [-121.77575, 36.90988], [-121.7759, 36.90981], [-121.7764, 36.90969], [-121.77693, 36.90981], [-121.77743, 36.90968], [-121.77756, 36.90959], [-121.77779, 36.90933], [-121.77802, 36.90919], [-121.77858, 36.90875], [-121.77882, 36.90864], [-121.77931, 36.90851], [-121.77936, 36.90846], [-121.77938, 36.90841], [-121.77938, 36.90832], [-121.78001, 36.90996]]], [[[-121.79104, 37.01528], [-121.79097, 37.01543], [-121.791, 37.01553], [-121.7909, 37.01571], [-121.79074, 37.01585], [-121.79048, 37.01595], [-121.78976, 37.01601], [-121.78875, 37.01642], [-121.78822, 37.01683], [-121.78806, 37.01702], [-121.78779, 37.01739], [-121.78779, 37.01786], [-121.78794, 37.01826], [-121.78733, 37.0187], [-121.78722, 37.01887], [-121.78726, 37.019], [-121.78736, 37.01911], [-121.78433, 37.01909], [-121.78606, 37.01588], [-121.78619, 37.01552], [-121.7865, 37.01535], [-121.78714, 37.01517], [-121.78795, 37.01487], [-121.78952, 37.01435], [-121.79104, 37.01528]], [[-121.79089, 37.01556], [-121.79088, 37.01554], [-121.7903, 37.01553], [-121.79029, 37.01554], [-121.79045, 37.01588], [-121.79068, 37.01579], [-121.79083, 37.01566], [-121.79089, 37.01556]]], [[[-121.80347, 37.04255], [-121.80296, 37.04373], [-121.80276, 37.04499], [-121.80264, 37.04534], [-121.80233, 37.04573], [-121.80235, 37.04659], [-121.80223, 37.04686], [-121.80224, 37.047], [-121.80228, 37.04703], [-121.80228, 37.04715], [-121.80279, 37.04754], [-121.80017, 37.04746], [-121.79151, 37.04743], [-121.79167, 37.0407], [-121.797, 37.04075], [-121.80045, 37.04074], [-121.80194, 37.04076], [-121.80282, 37.04139], [-121.80342, 37.04205], [-121.80347, 37.04255]]]]} | Open Access 1 | Unnamed site - Watsonville, City of | 28675 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 233.758 | |||
14295 | 14295 | 14294 | {"type": "Polygon", "coordinates": [[[-120.14075, 34.59592], [-120.13946, 34.5959], [-120.13946, 34.5959], [-120.13963, 34.59555], [-120.14075, 34.59592]]]} | Open Access 1 | Unknown park - Solvang, City of | 28669 | 1337 | Solvang, City of 79 | City 2 | City Agency 2 | http://www.cityofsolvang.com/index.php/departments/parks-a-recreation | City 2 | 0.581 | |||
14296 | 14296 | 14295 | {"type": "Polygon", "coordinates": [[[-120.14651, 34.6035], [-120.14643, 34.60387], [-120.14512, 34.60449], [-120.14492, 34.60438], [-120.14466, 34.6043], [-120.14438, 34.6043], [-120.14381, 34.60437], [-120.14377, 34.60436], [-120.14373, 34.60432], [-120.14374, 34.6041], [-120.14379, 34.60395], [-120.14434, 34.60404], [-120.14512, 34.60379], [-120.14578, 34.60373], [-120.14651, 34.6035]]]} | Open Access 1 | Unnamed site - Solvang, City of | 28670 | 1337 | Solvang, City of 79 | City 2 | City Agency 2 | http://www.cityofsolvang.com/index.php/departments/parks-a-recreation | City 2 | 3.005 | |||
14303 | 14303 | 14302 | {"type": "MultiPolygon", "coordinates": [[[[-117.14137, 33.15374], [-117.14114, 33.15399], [-117.1411, 33.154], [-117.14106, 33.154], [-117.14103, 33.15398], [-117.14101, 33.15395], [-117.14087, 33.15347], [-117.14094, 33.15346], [-117.14137, 33.15374]]], [[[-117.18544, 33.1626], [-117.18544, 33.16267], [-117.18537, 33.16299], [-117.18467, 33.1629], [-117.18466, 33.16288], [-117.18471, 33.16253], [-117.18544, 33.1626]]]]} | Open Access 1 | Unknown park - San Marcos, City of | 28686 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1.074 | |||
14305 | 14305 | 14304 | {"type": "Polygon", "coordinates": [[[-122.58206, 38.57942], [-122.58194, 38.57963], [-122.58178, 38.57951], [-122.58195, 38.57934], [-122.58206, 38.57942]]]} | Open Access 1 | Unknown park - Calistoga, City of | 28689 | 1042 | Calistoga, City of 755 | City 2 | City Agency 2 | http://www.ci.calistoga.ca.us/ | City 2 | 0.098 | |||
14309 | 14309 | 14308 | {"type": "Polygon", "coordinates": [[[-122.38148, 37.73182], [-122.38123, 37.73211], [-122.38122, 37.73223], [-122.38105, 37.73214], [-122.38098, 37.73216], [-122.38071, 37.73205], [-122.38067, 37.73203], [-122.38065, 37.73199], [-122.38066, 37.73194], [-122.38081, 37.73176], [-122.38103, 37.73152], [-122.38108, 37.7315], [-122.38114, 37.7315], [-122.38118, 37.73152], [-122.38134, 37.73167], [-122.38138, 37.73177], [-122.38148, 37.73182]]]} | Open Access 1 | Unnamed site - San Francisco, City of | 28697 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.817 | |||
14312 | 14312 | 14311 | {"type": "MultiPolygon", "coordinates": [[[[-117.05883, 32.72129], [-117.05851, 32.72137], [-117.05826, 32.72054], [-117.05856, 32.72042], [-117.05883, 32.72129]]], [[[-117.06249, 32.75242], [-117.06211, 32.75251], [-117.06106, 32.75279], [-117.06087, 32.75234], [-117.0624, 32.75219], [-117.06249, 32.75242]]], [[[-117.06411, 32.71928], [-117.06404, 32.71934], [-117.06249, 32.71803], [-117.0625, 32.71793], [-117.06411, 32.71928]]], [[[-117.20364, 32.79871], [-117.20168, 32.7987], [-117.2017, 32.79679], [-117.2017, 32.79679], [-117.20364, 32.79871]]]]} | Open Access 1 | Unnamed site - San Diego, City of | 28704 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 7.375 | |||
14313 | 14313 | 14312 | {"type": "Polygon", "coordinates": [[[-121.79106, 37.67722], [-121.79029, 37.67754], [-121.78871, 37.6778], [-121.78807, 37.67784], [-121.78741, 37.67737], [-121.78811, 37.67727], [-121.78838, 37.67755], [-121.789, 37.67751], [-121.78842, 37.67665], [-121.78831, 37.67628], [-121.78917, 37.67597], [-121.78992, 37.67604], [-121.79005, 37.67635], [-121.79039, 37.67668], [-121.79075, 37.67693], [-121.79106, 37.67722]]]} | Open Access 1 | Unknown park - Livermore, City of | 28714 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 8.298 |
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]);