superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
35 rows where ACCESS_TYP = 1 and YR_EST = 2004
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AGENCY, MNG_AG_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
512 | 512 | 511 | {"type": "Polygon", "coordinates": [[[-120.45049, 34.69233], [-120.44937, 34.69163], [-120.44841, 34.69136], [-120.44665, 34.69339], [-120.44259, 34.70021], [-120.44243, 34.70013], [-120.44787, 34.69066], [-120.44845, 34.69086], [-120.44961, 34.69143], [-120.45049, 34.69233]]]} | Open Access 1 | Burton Mesa Ecological Reserve | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Burton-Mesa-ER | 32070 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 10.754 | Burton Mesa ER | 2004 |
743 | 743 | 742 | {"type": "Polygon", "coordinates": [[[-121.76995, 37.32073], [-121.76992, 37.32078], [-121.76987, 37.3208], [-121.76953, 37.32076], [-121.76868, 37.31766], [-121.76873, 37.31765], [-121.76879, 37.31791], [-121.76891, 37.31796], [-121.76892, 37.31801], [-121.76897, 37.31805], [-121.76902, 37.31823], [-121.76906, 37.31824], [-121.76911, 37.31845], [-121.76908, 37.31848], [-121.76906, 37.31852], [-121.76908, 37.31857], [-121.76911, 37.31861], [-121.76909, 37.31888], [-121.7692, 37.31889], [-121.76921, 37.31913], [-121.76928, 37.31919], [-121.76927, 37.31925], [-121.7693, 37.3193], [-121.76921, 37.31936], [-121.76936, 37.3199], [-121.76944, 37.31997], [-121.76944, 37.32001], [-121.76947, 37.32005], [-121.76953, 37.32009], [-121.7695, 37.32033], [-121.76958, 37.32035], [-121.76957, 37.32067], [-121.76995, 37.32073]]]} | Open Access 1 | Pocket Park No. 10 | 23821 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1.014 | PP No. 10 | 2004 | |
744 | 744 | 743 | {"type": "Polygon", "coordinates": [[[-121.76494, 37.31564], [-121.7648, 37.3157], [-121.76466, 37.31572], [-121.7645, 37.3157], [-121.76436, 37.31564], [-121.76425, 37.31555], [-121.76419, 37.31544], [-121.76418, 37.31531], [-121.76422, 37.31518], [-121.76429, 37.3151], [-121.76435, 37.31505], [-121.76445, 37.315], [-121.76457, 37.31497], [-121.76477, 37.31498], [-121.76496, 37.31506], [-121.76504, 37.31513], [-121.76508, 37.31519], [-121.76511, 37.31526], [-121.76512, 37.31535], [-121.76511, 37.31543], [-121.76506, 37.31552], [-121.76494, 37.31564]]]} | Open Access 1 | Pocket Park No. 11 | 23822 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1.328 | PP No. 11 | 2004 | |
745 | 745 | 744 | {"type": "MultiPolygon", "coordinates": [[[[-121.77933, 37.31566], [-121.7791, 37.31572], [-121.77901, 37.31526], [-121.77923, 37.31547], [-121.77933, 37.31563], [-121.77933, 37.31566]]], [[[-121.77976, 37.31553], [-121.77956, 37.31557], [-121.77951, 37.31556], [-121.77939, 37.31537], [-121.77917, 37.31515], [-121.77914, 37.3151], [-121.77915, 37.31507], [-121.77918, 37.31505], [-121.77928, 37.31503], [-121.77938, 37.31536], [-121.77966, 37.31535], [-121.77962, 37.31542], [-121.77963, 37.31547], [-121.77968, 37.31551], [-121.77976, 37.31553]]]]} | Open Access 1 | Pocket Park No. 14 | 23823 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.348 | PP No. 14 | 2004 | |
1194 | 1194 | 1193 | {"type": "MultiPolygon", "coordinates": [[[[-119.30699, 34.38027], [-119.30462, 34.38044], [-119.30512, 34.37949], [-119.30634, 34.37676], [-119.30649, 34.37654], [-119.30663, 34.37735], [-119.30655, 34.37738], [-119.30655, 34.37744], [-119.30657, 34.37745], [-119.30665, 34.37743], [-119.30658, 34.37809], [-119.3066, 34.37844], [-119.30664, 34.37866], [-119.30674, 34.37904], [-119.30691, 34.37902], [-119.30699, 34.38027]]], [[[-119.30727, 34.37477], [-119.30685, 34.37623], [-119.30682, 34.37632], [-119.30652, 34.37483], [-119.30727, 34.37477]]]]} | Open Access 1 | Ventura River Confluence Preserve | https://ovlc.org/preserves/ventura-river-confluence/ | 32882 | 3296 | Ojai Valley Land Conservancy 1066 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.ovlc.org/ | Non Governmental Organization 10 | 12.458 | Ventura River Confluence Preserve | 2004 |
1612 | 1612 | 1611 | {"type": "MultiPolygon", "coordinates": [[[[-121.76711, 37.31382], [-121.76553, 37.31405], [-121.7655, 37.31394], [-121.76629, 37.31381], [-121.76631, 37.31384], [-121.76709, 37.31372], [-121.76708, 37.31377], [-121.76711, 37.31382]]], [[[-121.76796, 37.3137], [-121.76734, 37.31379], [-121.76734, 37.31373], [-121.76731, 37.31368], [-121.76793, 37.31359], [-121.76793, 37.31365], [-121.76796, 37.3137]]], [[[-121.7688, 37.31357], [-121.76819, 37.31366], [-121.76819, 37.31361], [-121.76816, 37.31355], [-121.76879, 37.31346], [-121.76878, 37.31352], [-121.7688, 37.31357]]], [[[-121.76968, 37.31344], [-121.76903, 37.31354], [-121.76903, 37.31348], [-121.76901, 37.31343], [-121.76966, 37.31333], [-121.76968, 37.31344]]]]} | Open Access 1 | Pocket Park No. 15 | 23824 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.923 | PP No. 15 | 2004 | |
1614 | 1614 | 1613 | {"type": "MultiPolygon", "coordinates": [[[[-121.75909, 37.31125], [-121.75908, 37.31129], [-121.75903, 37.31135], [-121.75894, 37.31143], [-121.75879, 37.3115], [-121.75881, 37.31139], [-121.7588, 37.31118], [-121.7587, 37.3111], [-121.75843, 37.31101], [-121.758, 37.31101], [-121.75767, 37.31106], [-121.75771, 37.31101], [-121.75779, 37.31097], [-121.75801, 37.31095], [-121.75802, 37.31091], [-121.75822, 37.3109], [-121.75847, 37.31091], [-121.75859, 37.31093], [-121.75879, 37.31101], [-121.75901, 37.31116], [-121.75909, 37.31125]]], [[[-121.75906, 37.31205], [-121.75896, 37.31207], [-121.75881, 37.3116], [-121.75887, 37.31158], [-121.75906, 37.31205]]], [[[-121.75984, 37.31269], [-121.75981, 37.31281], [-121.75957, 37.31279], [-121.75949, 37.31283], [-121.75915, 37.31287], [-121.75902, 37.31229], [-121.75903, 37.31224], [-121.75907, 37.31221], [-121.75914, 37.31219], [-121.75928, 37.31242], [-121.75946, 37.31246], [-121.75954, 37.31264], [-121.75984, 37.31269]]]]} | Open Access 1 | Pocket Park No. 17 | 23826 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1.194 | PP No. 17 | 2004 | |
1615 | 1615 | 1614 | {"type": "Polygon", "coordinates": [[[-121.75911, 37.31065], [-121.75911, 37.31077], [-121.75894, 37.31093], [-121.75867, 37.31081], [-121.75863, 37.31078], [-121.7587, 37.31058], [-121.75902, 37.3106], [-121.75911, 37.31065]]]} | Open Access 1 | Pocket Park No. 18 | 23827 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.285 | PP No. 18 | 2004 | |
1624 | 1624 | 1623 | {"type": "Polygon", "coordinates": [[[-121.92157, 37.31987], [-121.92107, 37.31987], [-121.92107, 37.31975], [-121.92153, 37.31975], [-121.92157, 37.31977], [-121.92157, 37.31987]]]} | Open Access 1 | Buena Vista Park | 16493 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.147 | Buena Vista Park | 2004 | |
1705 | 1705 | 1704 | {"type": "Polygon", "coordinates": [[[-121.75759, 37.30772], [-121.75723, 37.3079], [-121.7574, 37.30815], [-121.75736, 37.30818], [-121.7573, 37.30817], [-121.75713, 37.30796], [-121.75708, 37.30783], [-121.75703, 37.30764], [-121.75707, 37.30757], [-121.75706, 37.3075], [-121.75701, 37.30746], [-121.75694, 37.30744], [-121.75688, 37.30733], [-121.75718, 37.30743], [-121.7573, 37.30749], [-121.75744, 37.30758], [-121.75759, 37.30772]]]} | Open Access 1 | Pocket Park No. 19 | 23828 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.523 | PP No. 19 | 2004 | |
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 | |
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 | |
3204 | 3204 | 3203 | {"type": "MultiPolygon", "coordinates": [[[[-121.76776, 37.31275], [-121.76743, 37.31279], [-121.76713, 37.31286], [-121.76708, 37.31283], [-121.767, 37.31282], [-121.76693, 37.31285], [-121.7669, 37.31289], [-121.76658, 37.31288], [-121.76656, 37.31284], [-121.76616, 37.31274], [-121.76601, 37.31272], [-121.76564, 37.31277], [-121.76555, 37.31276], [-121.76549, 37.3128], [-121.76473, 37.31291], [-121.76467, 37.31266], [-121.76469, 37.31264], [-121.76589, 37.31246], [-121.76603, 37.31245], [-121.76628, 37.31247], [-121.76657, 37.31256], [-121.76671, 37.31258], [-121.76687, 37.31258], [-121.76765, 37.31251], [-121.76772, 37.31256], [-121.76776, 37.31275]]], [[[-121.7705, 37.31315], [-121.77014, 37.31317], [-121.7698, 37.31322], [-121.76982, 37.31314], [-121.76981, 37.31309], [-121.76976, 37.31305], [-121.76967, 37.31304], [-121.76963, 37.31294], [-121.76915, 37.31273], [-121.76885, 37.31278], [-121.76885, 37.31271], [-121.7688, 37.31267], [-121.76871, 37.31265], [-121.76864, 37.31269], [-121.76856, 37.31265], [-121.76795, 37.31274], [-121.76789, 37.31251], [-121.76794, 37.31247], [-121.76849, 37.31239], [-121.76881, 37.31239], [-121.76901, 37.31242], [-121.77002, 37.31283], [-121.77043, 37.31294], [-121.77046, 37.31297], [-121.7705, 37.31315]]], [[[-121.77291, 37.31277], [-121.77226, 37.31303], [-121.772, 37.3131], [-121.77172, 37.31314], [-121.77141, 37.31318], [-121.77116, 37.31317], [-121.77068, 37.31313], [-121.77067, 37.31308], [-121.77069, 37.31303], [-121.77075, 37.31301], [-121.77124, 37.31305], [-121.77155, 37.31304], [-121.77186, 37.31299], [-121.77225, 37.31288], [-121.7728, 37.31265], [-121.77284, 37.31266], [-121.77291, 37.31277]]], [[[-121.77541, 37.31297], [-121.77534, 37.31303], [-121.77514, 37.31287], [-121.77488, 37.31272], [-121.77459, 37.3126], [-121.77444, 37.31256], [-121.77413, 37.31252], [-121.77381, 37.31251], [-121.7735, 37.31255], [-121.7732, 37.31263], [-121.77317, 37.31255], [-121.77319, 37.31252], [-121.77324, 37.31249], [-121.7736, 37.31241], [-121.77378, 37.3124], [-121.77414, 37.3124], [-121.77449, 37.31245], [-121.77474, 37.31252], [-121.7749, 37.31259], [-121.7752, 37.31276], [-121.7754, 37.31291], [-121.77541, 37.31297]]]]} | Open Access 1 | Cortona Park | 17666 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 5.316 | Cortona Park | 2004 | |
3756 | 3756 | 3755 | {"type": "Polygon", "coordinates": [[[-122.16655, 37.98899], [-122.16265, 37.98898], [-122.15791, 37.98903], [-122.15779, 37.98345], [-122.15833, 37.98316], [-122.1587, 37.98292], [-122.16049, 37.98141], [-122.16149, 37.98051], [-122.16254, 37.9801], [-122.16255, 37.98177], [-122.1665, 37.98176], [-122.16655, 37.98899]]]} | Open Access 1 | Dutra Ranch | 18325 | 3045 | John Muir Land Trust 105 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.jmlt.org/ | Non Governmental Organization 10 | 152.178 | Dutra Ranch | 2004 | |
4107 | 4107 | 4106 | {"type": "Polygon", "coordinates": [[[-121.77436, 37.31377], [-121.77415, 37.31422], [-121.77351, 37.31402], [-121.77373, 37.31357], [-121.77436, 37.31377]]]} | Open Access 1 | Evergreen Village Park | 18768 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.805 | Evergreen Village Park | 2004 | |
4172 | 4172 | 4171 | {"type": "MultiPolygon", "coordinates": [[[[-121.76247, 37.30719], [-121.76236, 37.30725], [-121.76225, 37.30735], [-121.76221, 37.30737], [-121.76214, 37.30736], [-121.76213, 37.30711], [-121.76208, 37.30692], [-121.76216, 37.30688], [-121.76213, 37.30675], [-121.76204, 37.30675], [-121.76196, 37.30638], [-121.76204, 37.30635], [-121.762, 37.30621], [-121.76192, 37.30621], [-121.76183, 37.30585], [-121.76192, 37.30581], [-121.76188, 37.30567], [-121.76179, 37.30568], [-121.76168, 37.30523], [-121.76197, 37.3051], [-121.76208, 37.30559], [-121.76204, 37.30563], [-121.76203, 37.30569], [-121.76206, 37.30574], [-121.76214, 37.30577], [-121.76228, 37.30637], [-121.76224, 37.30642], [-121.76223, 37.30647], [-121.76227, 37.30652], [-121.76231, 37.30655], [-121.76247, 37.30719]]], [[[-121.76236, 37.30865], [-121.76236, 37.30869], [-121.76232, 37.30871], [-121.76223, 37.30854], [-121.76217, 37.30835], [-121.76199, 37.30829], [-121.76201, 37.30822], [-121.76201, 37.30816], [-121.76198, 37.30809], [-121.76194, 37.30803], [-121.76208, 37.30792], [-121.76204, 37.30773], [-121.76208, 37.3075], [-121.76212, 37.30756], [-121.76209, 37.30773], [-121.76209, 37.30788], [-121.76222, 37.30838], [-121.76227, 37.30851], [-121.76236, 37.30865]]], [[[-121.76263, 37.3073], [-121.76256, 37.30759], [-121.76243, 37.30763], [-121.7625, 37.30796], [-121.76237, 37.30797], [-121.76232, 37.30794], [-121.76229, 37.30783], [-121.76229, 37.30773], [-121.76232, 37.30763], [-121.76236, 37.30753], [-121.76243, 37.30744], [-121.76252, 37.30736], [-121.76263, 37.3073]]], [[[-121.76283, 37.30873], [-121.76266, 37.30866], [-121.7625, 37.3085], [-121.76244, 37.30841], [-121.76241, 37.30832], [-121.76241, 37.30828], [-121.76243, 37.30824], [-121.76246, 37.30822], [-121.76255, 37.3082], [-121.76263, 37.30853], [-121.76278, 37.30852], [-121.76283, 37.30873]]], [[[-121.76371, 37.31256], [-121.76359, 37.31258], [-121.76361, 37.3127], [-121.76353, 37.31271], [-121.76263, 37.30883], [-121.76275, 37.30888], [-121.76289, 37.30892], [-121.76314, 37.30895], [-121.76314, 37.30904], [-121.76312, 37.30915], [-121.76296, 37.30933], [-121.76302, 37.30961], [-121.76299, 37.30965], [-121.76298, 37.3097], [-121.76301, 37.30974], [-121.76306, 37.30977], [-121.76319, 37.31034], [-121.76316, 37.31038], [-121.76316, 37.31043], [-121.76319, 37.31047], [-121.76323, 37.3105], [-121.76336, 37.31106], [-121.76333, 37.3111], [-121.76333, 37.31116], [-121.76336, 37.3112], [-121.7634, 37.31123], [-121.76353, 37.3118], [-121.7635, 37.31184], [-121.76349, 37.31188], [-121.76352, 37.31193], [-121.76357, 37.31196], [-121.76371, 37.31256]]]]} | Open Access 1 | Falls Creek Linear Park | 18837 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 4.277 | Falls Creek Linear Park | 2004 | |
4350 | 4350 | 4349 | {"type": "Polygon", "coordinates": [[[-121.76559, 37.31506], [-121.76531, 37.31511], [-121.76518, 37.31495], [-121.76504, 37.31485], [-121.76486, 37.31479], [-121.76467, 37.31476], [-121.76447, 37.31478], [-121.76431, 37.31483], [-121.76414, 37.31492], [-121.76403, 37.31502], [-121.76217, 37.31363], [-121.76214, 37.31352], [-121.76158, 37.31311], [-121.7645, 37.31267], [-121.76473, 37.31364], [-121.76477, 37.31367], [-121.76483, 37.31368], [-121.76526, 37.31361], [-121.76559, 37.31506]]]} | Open Access 1 | Fowler Creek Community Park | 19029 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 12.45 | Fowler Creek Community Park | 2004 | |
4461 | 4461 | 4460 | {"type": "Polygon", "coordinates": [[[-122.26963, 38.18034], [-122.26953, 38.18042], [-122.26821, 38.18041], [-122.26821, 38.18035], [-122.26832, 38.18031], [-122.26835, 38.18027], [-122.26837, 38.18022], [-122.26833, 38.18013], [-122.26822, 38.18005], [-122.26869, 38.18], [-122.26866, 38.17971], [-122.26953, 38.17962], [-122.26963, 38.18022], [-122.26963, 38.18034]]]} | Open Access 1 | Gadwell Park | 19168 | 1005 | American Canyon, City of 428 | City 2 | City Agency 2 | http://cityofamericancanyon.org/city-departments/parks-recreation | City 2 | 2.015 | Gadwell Park | 2004 | |
4827 | 4827 | 4826 | {"type": "Polygon", "coordinates": [[[-121.87021, 37.35546], [-121.86975, 37.35577], [-121.86972, 37.35574], [-121.8697, 37.35568], [-121.86965, 37.35565], [-121.86965, 37.35564], [-121.86975, 37.35561], [-121.86978, 37.35557], [-121.86979, 37.35553], [-121.87014, 37.3553], [-121.87021, 37.35546]]]} | Open Access 1 | Hacienda Park | 19589 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.229 | Hacienda Park | 2004 | |
5437 | 5437 | 5436 | {"type": "Polygon", "coordinates": [[[-118.12099, 33.76215], [-118.12095, 33.76218], [-118.12089, 33.76215], [-118.12066, 33.76192], [-118.12054, 33.76183], [-118.11973, 33.76245], [-118.11976, 33.76251], [-118.11952, 33.76268], [-118.11946, 33.76265], [-118.119, 33.76301], [-118.11851, 33.76256], [-118.11853, 33.76255], [-118.11855, 33.76248], [-118.11858, 33.76245], [-118.11855, 33.7624], [-118.11988, 33.76164], [-118.1201, 33.76161], [-118.12043, 33.76165], [-118.12047, 33.76164], [-118.12057, 33.76171], [-118.12056, 33.76177], [-118.12099, 33.76215]]]} | Open Access 1 | Jack Dunster Marine Biological Reserve | 20302 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 3.223 | Jack Dunster Marine Biological Reserve | 2004 |
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]);