superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
36 rows where MNG_AGENCY = 120 sorted by PARK_URL
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1552 | 1552 | 1551 | {"type": "Polygon", "coordinates": [[[-117.33206, 33.16323], [-117.33174, 33.16369], [-117.33078, 33.16284], [-117.33123, 33.16249], [-117.33206, 33.16323]]]} | Restricted Access 2 | Carlsbad High School Tennis Courts | 32247 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 1.727 | Carlsbad High School Tennis Courts | ||
2302 | 2302 | 2301 | {"type": "Polygon", "coordinates": [[[-117.32697, 33.13106], [-117.32664, 33.13118], [-117.32652, 33.13085], [-117.32636, 33.13054], [-117.32613, 33.13023], [-117.32591, 33.12999], [-117.32628, 33.12989], [-117.32697, 33.13106]]]} | Open Access 1 | City Park | 17341 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 1.04 | City Park | ||
2861 | 2861 | 2860 | {"type": "Polygon", "coordinates": [[[-117.34184, 33.15698], [-117.34182, 33.15701], [-117.34113, 33.15742], [-117.34108, 33.15742], [-117.34104, 33.1574], [-117.34033, 33.15654], [-117.34113, 33.15608], [-117.34183, 33.15694], [-117.34184, 33.15698]]]} | Open Access 1 | Chase Field | 17153 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 2.723 | Chase Field | ||
2871 | 2871 | 2870 | {"type": "Polygon", "coordinates": [[[-117.30179, 33.13802], [-117.30174, 33.13819], [-117.30151, 33.13825], [-117.30101, 33.13828], [-117.30039, 33.13846], [-117.30037, 33.13863], [-117.30055, 33.1388], [-117.29992, 33.13877], [-117.30001, 33.13674], [-117.29812, 33.13667], [-117.29824, 33.13312], [-117.29871, 33.13306], [-117.2992, 33.13303], [-117.2995, 33.13305], [-117.29988, 33.13309], [-117.30021, 33.13316], [-117.30049, 33.13324], [-117.30079, 33.13334], [-117.30047, 33.13362], [-117.30025, 33.13408], [-117.29992, 33.13447], [-117.29989, 33.13469], [-117.29968, 33.13496], [-117.29966, 33.13527], [-117.29974, 33.13534], [-117.29979, 33.13542], [-117.29986, 33.13543], [-117.30003, 33.13541], [-117.30019, 33.13536], [-117.3004, 33.13527], [-117.3005, 33.13529], [-117.30059, 33.13542], [-117.30099, 33.13627], [-117.30068, 33.13678], [-117.3007, 33.13713], [-117.30076, 33.13745], [-117.30079, 33.13778], [-117.30093, 33.13801], [-117.30114, 33.13811], [-117.30148, 33.13803], [-117.30171, 33.13794], [-117.30179, 33.13802]]]} | Open Access 1 | Macario Canyon Preserve | 32975 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 24.859 | Macario Canyon Preserve | ||
9011 | 9011 | 9010 | {"type": "Polygon", "coordinates": [[[-117.35047, 33.16003], [-117.34995, 33.16035], [-117.34918, 33.15942], [-117.34972, 33.15911], [-117.35047, 33.16003]]]} | Open Access 1 | Rotary Park | 24686 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 1.856 | Rotary Park | ||
12792 | 12792 | 12791 | {"type": "Polygon", "coordinates": [[[-117.2429, 33.08001], [-117.24288, 33.08032], [-117.24286, 33.08034], [-117.24286, 33.08075], [-117.24204, 33.08076], [-117.24201, 33.07859], [-117.24207, 33.07859], [-117.24218, 33.07904], [-117.24283, 33.07906], [-117.24279, 33.07988], [-117.2429, 33.08001]]]} | Restricted Access 2 | Levante School Park | 29992 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 3.676 | Levante School Park | ||
12794 | 12794 | 12793 | {"type": "Polygon", "coordinates": [[[-117.34147, 33.16315], [-117.34136, 33.16304], [-117.34116, 33.16316], [-117.34123, 33.16287], [-117.34126, 33.16266], [-117.34126, 33.16249], [-117.34147, 33.16315]]]} | Open Access 1 | Oak Park | 29998 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 0.19 | Oak Park | ||
12799 | 12799 | 12798 | {"type": "Polygon", "coordinates": [[[-117.30624, 33.13868], [-117.30621, 33.13872], [-117.30606, 33.13881], [-117.30581, 33.13889], [-117.30563, 33.1389], [-117.30496, 33.13888], [-117.30479, 33.1389], [-117.30457, 33.13895], [-117.30055, 33.13879], [-117.30037, 33.13863], [-117.30038, 33.13846], [-117.30101, 33.13828], [-117.30151, 33.13825], [-117.30173, 33.13819], [-117.30179, 33.13803], [-117.3017, 33.13794], [-117.30148, 33.13803], [-117.30114, 33.13811], [-117.30093, 33.138], [-117.30079, 33.13778], [-117.30076, 33.13745], [-117.3007, 33.13713], [-117.30068, 33.13677], [-117.30099, 33.13627], [-117.3006, 33.13542], [-117.3005, 33.13529], [-117.30039, 33.13527], [-117.30019, 33.13536], [-117.30003, 33.13541], [-117.29986, 33.13543], [-117.29979, 33.13542], [-117.29974, 33.13534], [-117.29966, 33.13527], [-117.29969, 33.13496], [-117.29989, 33.13469], [-117.29992, 33.13447], [-117.30025, 33.13409], [-117.30048, 33.13361], [-117.30079, 33.13334], [-117.30118, 33.13354], [-117.30147, 33.13376], [-117.30217, 33.13439], [-117.30276, 33.13504], [-117.30306, 33.1353], [-117.30332, 33.13548], [-117.30456, 33.13621], [-117.30481, 33.13638], [-117.30497, 33.13653], [-117.30517, 33.13674], [-117.30533, 33.13698], [-117.30546, 33.13723], [-117.30582, 33.13813], [-117.30596, 33.13834], [-117.30623, 33.13864], [-117.30624, 33.13868]]]} | Open Access 1 | Veterans Memorial Park | 30003 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 49.274 | Veterans Memorial Park | ||
12803 | 12803 | 12802 | {"type": "Polygon", "coordinates": [[[-117.29151, 33.13914], [-117.29094, 33.13994], [-117.29087, 33.14011], [-117.29095, 33.14017], [-117.29055, 33.14137], [-117.28899, 33.14036], [-117.28835, 33.14107], [-117.28758, 33.14058], [-117.28903, 33.13896], [-117.28987, 33.13948], [-117.29102, 33.13866], [-117.2913, 33.13893], [-117.29151, 33.13909], [-117.29151, 33.13914]]]} | Open Access 1 | Business Park Recreation Facility (Zone 5) | 30004 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 13.0 | Business Park Rec. Facility (Zone 5) | ||
13149 | 13149 | 13148 | {"type": "Polygon", "coordinates": [[[-117.27642, 33.10482], [-117.27601, 33.10477], [-117.2759, 33.10472], [-117.27538, 33.10439], [-117.27531, 33.10431], [-117.27516, 33.104], [-117.27491, 33.10395], [-117.27475, 33.10394], [-117.27475, 33.10338], [-117.27481, 33.10333], [-117.27618, 33.1033], [-117.27625, 33.1034], [-117.27624, 33.10399], [-117.27633, 33.10406], [-117.27642, 33.10482]]]} | Restricted Access 2 | Aviara Oaks Middle School Park | 31948 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 4.375 | Aviara Oaks Middle School Park | ||
14152 | 14152 | 14151 | {"type": "Polygon", "coordinates": [[[-117.24324, 33.10452], [-117.24295, 33.10466], [-117.24254, 33.10499], [-117.2424, 33.10498], [-117.24176, 33.10484], [-117.24171, 33.10478], [-117.24165, 33.10475], [-117.24152, 33.10476], [-117.24146, 33.10481], [-117.24127, 33.10477], [-117.24119, 33.10472], [-117.24122, 33.10468], [-117.24122, 33.10466], [-117.24082, 33.10455], [-117.24083, 33.10448], [-117.24077, 33.10443], [-117.2408, 33.10434], [-117.24077, 33.10432], [-117.24092, 33.10403], [-117.24145, 33.10412], [-117.24145, 33.10416], [-117.24172, 33.10428], [-117.24255, 33.10361], [-117.24285, 33.10394], [-117.24324, 33.10452]]]} | Restricted Access 2 | Fuerte Park | 31613 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 4.636 | Fuerte Park | ||
14160 | 14160 | 14159 | {"type": "Polygon", "coordinates": [[[-117.33023, 33.15686], [-117.33021, 33.157], [-117.33015, 33.1571], [-117.33003, 33.1572], [-117.32987, 33.15728], [-117.32972, 33.1573], [-117.3295, 33.15728], [-117.3294, 33.15725], [-117.32929, 33.15717], [-117.32917, 33.15701], [-117.32785, 33.15762], [-117.32731, 33.15675], [-117.32718, 33.15651], [-117.32716, 33.15642], [-117.32727, 33.15627], [-117.3275, 33.15625], [-117.32782, 33.1562], [-117.32795, 33.15615], [-117.32929, 33.15552], [-117.33023, 33.15686]]]} | Restricted Access 2 | Magnolia Athletic Field | 31624 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 9.192 | Magnolia Athletic Field | ||
14599 | 14599 | 14598 | {"type": "MultiPolygon", "coordinates": [[[[-117.30136, 33.12431], [-117.30109, 33.12548], [-117.30099, 33.12581], [-117.30089, 33.12606], [-117.30077, 33.1263], [-117.30063, 33.12653], [-117.30041, 33.12683], [-117.30016, 33.1271], [-117.29988, 33.12736], [-117.29943, 33.12767], [-117.29912, 33.12785], [-117.29879, 33.128], [-117.29844, 33.12813], [-117.29799, 33.12825], [-117.29689, 33.12844], [-117.29653, 33.12854], [-117.29611, 33.12871], [-117.29546, 33.12906], [-117.29516, 33.12919], [-117.29485, 33.1293], [-117.29455, 33.12937], [-117.29393, 33.12948], [-117.29388, 33.12931], [-117.29366, 33.12931], [-117.29348, 33.12914], [-117.2928, 33.12894], [-117.29075, 33.12924], [-117.29021, 33.12955], [-117.29004, 33.12945], [-117.28923, 33.12912], [-117.28822, 33.12843], [-117.2879, 33.12839], [-117.29046, 33.12797], [-117.29037, 33.12753], [-117.29113, 33.12727], [-117.29116, 33.12721], [-117.29105, 33.12678], [-117.29103, 33.12657], [-117.29388, 33.12611], [-117.29434, 33.12505], [-117.29475, 33.12451], [-117.29521, 33.12385], [-117.29436, 33.1232], [-117.29415, 33.12299], [-117.29467, 33.12313], [-117.29552, 33.12331], [-117.29988, 33.12403], [-117.30074, 33.12415], [-117.30086, 33.1242], [-117.30129, 33.12426], [-117.30134, 33.12428], [-117.30136, 33.12431]]], [[[-117.30821, 33.12981], [-117.30818, 33.12985], [-117.30818, 33.12992], [-117.30821, 33.13009], [-117.30827, 33.13574], [-117.30791, 33.13835], [-117.30763, 33.13858], [-117.30741, 33.13879], [-117.30725, 33.13898], [-117.3072, 33.139], [-117.30688, 33.13882], [-117.30658, 33.13862], [-117.30647, 33.13853], [-117.30624, 33.13828], [-117.30605, 33.13801], [-117.30591, 33.13774], [-117.30568, 33.13712], [-117.30553, 33.13682], [-117.30542, 33.13663], [-117.30519, 33.13635], [-117.30492, 33.1361], [-117.30461, 33.13589], [-117.30357, 33.13528], [-117.30323, 33.13506], [-117.30163, 33.13361], [-117.30136, 33.1334], [-117.30105, 33.13321], [-117.30081, 33.13309], [-117.30038, 33.13293], [-117.30012, 33.13286], [-117.29975, 33.13279], [-117.29928, 33.13275], [-117.29891, 33.13276], [-117.29836, 33.13285], [-117.29809, 33.13292], [-117.29774, 33.13304], [-117.29674, 33.13352], [-117.29634, 33.13378], [-117.29605, 33.13401], [-117.29585, 33.1342], [-117.29567, 33.1344], [-117.2954, 33.13476], [-117.29519, 33.13514], [-117.29465, 33.13281], [-117.29201, 33.13101], [-117.29222, 33.13079], [-117.29302, 33.13088], [-117.29334, 33.13079], [-117.29375, 33.13063], [-117.29486, 33.13138], [-117.29564, 33.13095], [-117.29621, 33.13071], [-117.29622, 33.13068], [-117.29569, 33.13037], [-117.29544, 33.13028], [-117.29554, 33.12974], [-117.29521, 33.12948], [-117.29563, 33.1293], [-117.29634, 33.12892], [-117.29665, 33.1288], [-117.29689, 33.12873], [-117.29722, 33.12866], [-117.2982, 33.12849], [-117.29851, 33.12841], [-117.29881, 33.1283], [-117.2992, 33.12813], [-117.29957, 33.12794], [-117.29983, 33.12777], [-117.30012, 33.12755], [-117.30045, 33.12725], [-117.30078, 33.12687], [-117.30079, 33.12685], [-117.30095, 33.12665], [-117.30115, 33.12628], [-117.30133, 33.12584], [-117.30159, 33.1248], [-117.30164, 33.12472], [-117.30169, 33.12449], [-117.30173, 33.12437], [-117.3018, 33.12434], [-117.30193, 33.12432], [-117.30244, 33.12435], [-117.30277, 33.12434], [-117.30376, 33.12426], [-117.30415, 33.12421], [-117.30475, 33.12408], [-117.30523, 33.12395], [-117.30593, 33.12373], [-117.306, 33.12376], [-117.30601, 33.12378], [-117.30643, 33.12504], [-117.30675, 33.12506], [-117.30722, 33.12647], [-117.30727, 33.12686], [-117.30726, 33.12705], [-117.30712, 33.12705], [-117.30698, 33.12724], [-117.30691, 33.12971], [-117.30713, 33.12967], [-117.3082, 33.12935], [-117.30821, 33.12981]]]]} | Restricted Access 2 | The Crossings Golf Course | 30002 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 391.581 | The Crossings GC | ||
14641 | 14641 | 14640 | {"type": "MultiPolygon", "coordinates": [[[[-117.30392, 33.09963], [-117.30353, 33.09976], [-117.30314, 33.09969], [-117.30324, 33.09953], [-117.30324, 33.09935], [-117.30314, 33.09914], [-117.30301, 33.09907], [-117.30276, 33.099], [-117.30287, 33.09898], [-117.30372, 33.09898], [-117.30392, 33.09963]]], [[[-117.30489, 33.1026], [-117.30484, 33.10263], [-117.30464, 33.10265], [-117.30424, 33.1026], [-117.30451, 33.10256], [-117.30459, 33.10252], [-117.30466, 33.10246], [-117.3047, 33.1024], [-117.30471, 33.10229], [-117.30467, 33.10201], [-117.30452, 33.10151], [-117.30442, 33.10129], [-117.30412, 33.10082], [-117.3039, 33.10085], [-117.30378, 33.10059], [-117.30401, 33.10049], [-117.30403, 33.10047], [-117.30422, 33.1004], [-117.30466, 33.10131], [-117.30467, 33.10135], [-117.30481, 33.10171], [-117.30487, 33.10193], [-117.30489, 33.10221], [-117.3049, 33.10257], [-117.30489, 33.1026]]], [[[-117.30647, 33.10234], [-117.30617, 33.10247], [-117.30636, 33.10281], [-117.30617, 33.10282], [-117.30617, 33.10266], [-117.30509, 33.10089], [-117.30508, 33.1009], [-117.30508, 33.10146], [-117.30497, 33.10125], [-117.30494, 33.10114], [-117.30486, 33.10098], [-117.30445, 33.1], [-117.30439, 33.09991], [-117.30399, 33.09898], [-117.30512, 33.09899], [-117.30508, 33.10085], [-117.30526, 33.1008], [-117.30538, 33.10115], [-117.3057, 33.10108], [-117.30543, 33.10119], [-117.30544, 33.10126], [-117.3055, 33.10135], [-117.30587, 33.10197], [-117.30617, 33.10185], [-117.30619, 33.10187], [-117.30589, 33.10201], [-117.30614, 33.10244], [-117.30645, 33.10232], [-117.30647, 33.10234]]], [[[-117.30606, 33.10595], [-117.30582, 33.10598], [-117.30555, 33.10596], [-117.30562, 33.10551], [-117.30556, 33.10548], [-117.30521, 33.10539], [-117.30525, 33.105], [-117.30526, 33.10463], [-117.30605, 33.10448], [-117.30606, 33.10595]]]]} | Open Access 1 | Batiquitos Drive Open Space | 15863 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 9.658 | Batiquitos Drive OS | ||
14738 | 14738 | 14737 | {"type": "Polygon", "coordinates": [[[-117.24719, 33.08498], [-117.24511, 33.08569], [-117.24483, 33.08511], [-117.24479, 33.08506], [-117.24465, 33.08473], [-117.24408, 33.08356], [-117.24396, 33.08316], [-117.24407, 33.08242], [-117.24407, 33.08146], [-117.24415, 33.08123], [-117.24416, 33.08092], [-117.24457, 33.08092], [-117.24442, 33.08126], [-117.24448, 33.08142], [-117.24468, 33.08178], [-117.24468, 33.08182], [-117.24491, 33.08223], [-117.24513, 33.08329], [-117.24532, 33.08363], [-117.24561, 33.08401], [-117.24598, 33.0844], [-117.24602, 33.08441], [-117.24619, 33.08461], [-117.24651, 33.08479], [-117.24719, 33.08498]]]} | Open Access 1 | La Costa Canyon Open Space | 20752 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 12.953 | La Costa Canyon OS | ||
15411 | 15411 | 15410 | {"type": "Polygon", "coordinates": [[[-117.29374, 33.13929], [-117.29267, 33.1393], [-117.29229, 33.13926], [-117.29214, 33.13922], [-117.29185, 33.13912], [-117.29165, 33.139], [-117.29149, 33.13887], [-117.29129, 33.13865], [-117.2935, 33.13738], [-117.29374, 33.13929]]]} | Open Access 1 | Business Park Recreation Facility | 16541 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 7.166 | Business Park Rec. Facility | ||
2882 | 2882 | 2881 | {"type": "Polygon", "coordinates": [[[-117.29824, 33.13313], [-117.29812, 33.13667], [-117.29552, 33.13657], [-117.29529, 33.13554], [-117.29538, 33.1353], [-117.29548, 33.13507], [-117.29561, 33.13484], [-117.29582, 33.13456], [-117.296, 33.13436], [-117.29626, 33.13411], [-117.29655, 33.13389], [-117.29678, 33.13374], [-117.29768, 33.13329], [-117.29796, 33.13319], [-117.29824, 33.13313]]]} | Open Access 1 | Veterans Park Preserve | http://www.carlsbadca.gov/civicax/filebank/blobdload.aspx?BlobID=37992 | 32977 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 19.572 | Veterans Park Preserve | |
6771 | 6771 | 6770 | {"type": "Polygon", "coordinates": [[[-117.35386, 33.16562], [-117.35275, 33.16562], [-117.35275, 33.16525], [-117.35327, 33.16513], [-117.35386, 33.16562]]]} | Open Access 1 | Maxton Brown Park | http://www.carlsbadca.gov/services/depts/parks/facilities/north/brown.asp | 21968 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 0.947 | Maxton Brown Park | |
12787 | 12787 | 12786 | {"type": "Polygon", "coordinates": [[[-117.30042, 33.16416], [-117.30022, 33.16457], [-117.30007, 33.16511], [-117.30001, 33.16558], [-117.30001, 33.16585], [-117.30008, 33.16623], [-117.30014, 33.16643], [-117.30038, 33.16702], [-117.30038, 33.16706], [-117.30035, 33.1671], [-117.29881, 33.16761], [-117.29876, 33.1676], [-117.29872, 33.16755], [-117.29802, 33.16583], [-117.29797, 33.16563], [-117.29795, 33.16543], [-117.298, 33.16505], [-117.29814, 33.16471], [-117.29822, 33.16458], [-117.29833, 33.16445], [-117.29862, 33.16422], [-117.29889, 33.16405], [-117.29965, 33.16377], [-117.29974, 33.16387], [-117.30042, 33.16416]]]} | Open Access 1 | Calavera Park | http://www.carlsbadca.gov/services/depts/parks/facilities/north/calavera.asp | 29986 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 16.79 | Calavera Park | |
2587 | 2587 | 2586 | {"type": "Polygon", "coordinates": [[[-117.33591, 33.13338], [-117.33487, 33.13375], [-117.33448, 33.13298], [-117.33535, 33.13267], [-117.3354, 33.13267], [-117.33591, 33.13338]]]} | Open Access 1 | Cannon Park | http://www.carlsbadca.gov/services/depts/parks/facilities/north/cannon.asp | 16804 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 2.281 | Cannon 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]);