superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
36 rows where ACCESS_TYP = 1 and YR_EST = 1984
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
83 | 83 | 82 | {"type": "MultiPolygon", "coordinates": [[[[-117.41584, 33.89039], [-117.41541, 33.89094], [-117.41511, 33.89107], [-117.41508, 33.89095], [-117.41517, 33.89085], [-117.41511, 33.8908], [-117.4151, 33.89069], [-117.41508, 33.89069], [-117.415, 33.89084], [-117.41492, 33.89086], [-117.41483, 33.89098], [-117.41473, 33.89083], [-117.41472, 33.89067], [-117.41463, 33.89057], [-117.41449, 33.89053], [-117.41432, 33.8902], [-117.41431, 33.8902], [-117.41437, 33.89054], [-117.41453, 33.89069], [-117.41447, 33.89082], [-117.41431, 33.89084], [-117.41431, 33.89089], [-117.41443, 33.89103], [-117.41441, 33.89119], [-117.41446, 33.89129], [-117.41441, 33.89148], [-117.41442, 33.89158], [-117.41433, 33.89161], [-117.41451, 33.89196], [-117.4144, 33.89203], [-117.41404, 33.89198], [-117.41377, 33.89199], [-117.4135, 33.89186], [-117.41353, 33.89164], [-117.4134, 33.89163], [-117.4133, 33.89157], [-117.41336, 33.89147], [-117.41333, 33.89099], [-117.41341, 33.89088], [-117.4133, 33.8907], [-117.41332, 33.89056], [-117.41309, 33.89036], [-117.413, 33.89022], [-117.41287, 33.89013], [-117.41285, 33.88996], [-117.41272, 33.89], [-117.41254, 33.89021], [-117.41235, 33.89029], [-117.41194, 33.89031], [-117.41195, 33.88994], [-117.41184, 33.88988], [-117.41186, 33.88968], [-117.41174, 33.88961], [-117.41173, 33.88953], [-117.41159, 33.88956], [-117.41158, 33.88938], [-117.41133, 33.88943], [-117.41143, 33.88926], [-117.4112, 33.88913], [-117.41127, 33.88888], [-117.41085, 33.88867], [-117.41085, 33.88846], [-117.4106, 33.88852], [-117.41048, 33.88846], [-117.41044, 33.88823], [-117.41021, 33.88855], [-117.40998, 33.88863], [-117.40985, 33.88821], [-117.40949, 33.88808], [-117.40925, 33.88786], [-117.4093, 33.88773], [-117.40977, 33.88755], [-117.40989, 33.88734], [-117.4097, 33.88701], [-117.40964, 33.88694], [-117.41085, 33.88738], [-117.41231, 33.88798], [-117.41291, 33.88834], [-117.41352, 33.88872], [-117.41408, 33.88914], [-117.41462, 33.88949], [-117.41584, 33.89039]]], [[[-117.42825, 33.89828], [-117.42551, 33.89984], [-117.42507, 33.89982], [-117.42447, 33.89968], [-117.42413, 33.89972], [-117.42387, 33.89991], [-117.42313, 33.90089], [-117.42295, 33.9013], [-117.42102, 33.9024], [-117.41746, 33.90445], [-117.41221, 33.89813], [-117.41103, 33.89667], [-117.41409, 33.89496], [-117.41445, 33.89493], [-117.41478, 33.89496], [-117.41517, 33.89543], [-117.41526, 33.89538], [-117.41851, 33.89932], [-117.42035, 33.89826], [-117.41811, 33.89551], [-117.41837, 33.89535], [-117.4186, 33.89529], [-117.419, 33.89581], [-117.42006, 33.89559], [-117.42029, 33.89534], [-117.42021, 33.89448], [-117.42012, 33.89439], [-117.41995, 33.89439], [-117.42013, 33.89428], [-117.42019, 33.89428], [-117.42026, 33.89429], [-117.4205, 33.8944], [-117.42072, 33.89443], [-117.42092, 33.89442], [-117.42108, 33.89436], [-117.42117, 33.8943], [-117.42124, 33.89421], [-117.42129, 33.89411], [-117.42141, 33.89401], [-117.42153, 33.89405], [-117.42195, 33.89414], [-117.42262, 33.89437], [-117.42282, 33.89462], [-117.42312, 33.89445], [-117.42341, 33.8946], [-117.42362, 33.89468], [-117.42386, 33.89474], [-117.4243, 33.89469], [-117.42455, 33.89476], [-117.42507, 33.89494], [-117.42563, 33.89526], [-117.426, 33.89556], [-117.4265, 33.89614], [-117.42825, 33.89828]]], [[[-117.4211, 33.89413], [-117.42104, 33.89421], [-117.42094, 33.89427], [-117.42079, 33.8943], [-117.42061, 33.89428], [-117.4203, 33.89417], [-117.42015, 33.89415], [-117.42013, 33.8941], [-117.41976, 33.89373], [-117.4193, 33.89373], [-117.41907, 33.89345], [-117.41869, 33.89345], [-117.41845, 33.89311], [-117.41809, 33.8932], [-117.41755, 33.89264], [-117.41759, 33.89239], [-117.418, 33.89201], [-117.41868, 33.89265], [-117.41886, 33.89297], [-117.4192, 33.8931], [-117.41938, 33.89329], [-117.41972, 33.89351], [-117.41991, 33.89358], [-117.42044, 33.89369], [-117.42069, 33.89379], [-117.42107, 33.89392], [-117.4211, 33.89413]]]]} | Open Access 1 | California Citrus State Historic Park | http://www.parks.ca.gov/?page_id=649 | 1455 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 252.448 | California Citrus SHP | 1984 |
371 | 371 | 370 | {"type": "MultiPolygon", "coordinates": [[[[-118.27708, 34.23336], [-118.2746, 34.23281], [-118.27449, 34.23274], [-118.27367, 34.23255], [-118.26859, 34.23141], [-118.268, 34.23107], [-118.26755, 34.23097], [-118.26718, 34.23078], [-118.26693, 34.23072], [-118.2668, 34.23061], [-118.26717, 34.2304], [-118.26682, 34.22994], [-118.26683, 34.22784], [-118.26966, 34.22964], [-118.27167, 34.23046], [-118.27708, 34.23336]]], [[[-118.27981, 34.23393], [-118.27925, 34.23386], [-118.27867, 34.23373], [-118.27191, 34.2301], [-118.26993, 34.22928], [-118.26683, 34.22733], [-118.26687, 34.22185], [-118.27531, 34.22179], [-118.27539, 34.2291], [-118.27975, 34.22907], [-118.27981, 34.23393]]]]} | Open Access 1 | Verdugo Mountains Park Property | http://www.parks.ca.gov/?page_id=635 | 1781 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 252.512 | Verdugo Mtns. Park Property | 1984 |
2246 | 2246 | 2245 | {"type": "Polygon", "coordinates": [[[-122.05539, 37.53459], [-122.05494, 37.53486], [-122.05338, 37.53409], [-122.05373, 37.53374], [-122.05382, 37.53347], [-122.05426, 37.53356], [-122.05443, 37.53361], [-122.05462, 37.53369], [-122.05477, 37.53378], [-122.05494, 37.53391], [-122.05514, 37.53414], [-122.05539, 37.53459]]]} | Open Access 1 | Bridgepointe Park | 16377 | 1221 | Newark, City of 372 | City 2 | City Agency 2 | http://www.ci.newark.ca.us/departments/recreation-and-community-services/parks/ | City 2 | 3.527 | Bridgepointe Park | 1984 | |
2342 | 2342 | 2341 | {"type": "Polygon", "coordinates": [[[-121.94629, 37.55413], [-121.94554, 37.5548], [-121.94613, 37.55522], [-121.94594, 37.55538], [-121.94582, 37.55544], [-121.94487, 37.55626], [-121.9447, 37.55637], [-121.94463, 37.55636], [-121.94461, 37.55634], [-121.94456, 37.55617], [-121.94449, 37.55605], [-121.94437, 37.55591], [-121.94414, 37.55573], [-121.94412, 37.55571], [-121.94413, 37.55567], [-121.94596, 37.55405], [-121.94603, 37.55402], [-121.9461, 37.55402], [-121.94629, 37.55413]]]} | Open Access 1 | Buena Vista Park | 16491 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 4.547 | Buena Vista Park | 1984 | |
2442 | 2442 | 2441 | {"type": "Polygon", "coordinates": [[[-122.02239, 37.53645], [-122.02193, 37.53702], [-122.0216, 37.53688], [-122.0216, 37.53681], [-122.02155, 37.53674], [-122.02091, 37.5364], [-122.02082, 37.5363], [-122.02073, 37.53612], [-122.02064, 37.536], [-122.0205, 37.53588], [-122.0203, 37.53577], [-122.02028, 37.53573], [-122.02049, 37.53547], [-122.02239, 37.53645]]]} | Open Access 1 | Byington Park | 16617 | 1221 | Newark, City of 372 | City 2 | City Agency 2 | http://www.ci.newark.ca.us/departments/recreation-and-community-services/parks/ | City 2 | 2.956 | Byington Park | 1984 | |
3371 | 3371 | 3370 | {"type": "Polygon", "coordinates": [[[-122.08326, 37.37172], [-122.08272, 37.37173], [-122.0827, 37.37347], [-122.07912, 37.3734], [-122.07913, 37.37216], [-122.07878, 37.37215], [-122.07877, 37.37167], [-122.07799, 37.37167], [-122.07799, 37.37091], [-122.08326, 37.37097], [-122.08326, 37.37172]]]} | Open Access 1 | Cuesta Park | 17850 | 1218 | Mountain View, City of 453 | City 2 | City Agency 2 | http://www.ci.mtnview.ca.us/services/parks/default.asp | City 2 | 25.205 | Cuesta Park | 1984 | |
4080 | 4080 | 4079 | {"type": "Polygon", "coordinates": [[[-122.00438, 37.52428], [-122.0038, 37.52499], [-122.00248, 37.52434], [-122.00276, 37.52398], [-122.00264, 37.5239], [-122.00292, 37.52355], [-122.00438, 37.52428]]]} | Open Access 1 | Eucalyptus Grove Park (South) | 18737 | 1221 | Newark, City of 372 | City 2 | City Agency 2 | http://www.ci.newark.ca.us/departments/recreation-and-community-services/parks/ | City 2 | 3.374 | Eucalyptus Grove Park (South) | 1984 | |
4160 | 4160 | 4159 | {"type": "Polygon", "coordinates": [[[-121.96284, 37.40502], [-121.9613, 37.40567], [-121.96112, 37.40543], [-121.96115, 37.40536], [-121.96112, 37.40529], [-121.96107, 37.40526], [-121.96094, 37.40524], [-121.96086, 37.40521], [-121.96077, 37.40514], [-121.9607, 37.40506], [-121.96066, 37.40497], [-121.96065, 37.40481], [-121.96058, 37.40461], [-121.96062, 37.40457], [-121.96163, 37.40414], [-121.96206, 37.40477], [-121.96284, 37.40502]]]} | Open Access 1 | Fairway Glen Park | 18822 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 4.071 | Fairway Glen Park | 1984 | |
4209 | 4209 | 4208 | {"type": "Polygon", "coordinates": [[[-121.79758, 37.34781], [-121.79725, 37.34797], [-121.79713, 37.34796], [-121.79703, 37.34799], [-121.7965, 37.34825], [-121.79535, 37.34749], [-121.79509, 37.34736], [-121.79483, 37.34728], [-121.7948, 37.34725], [-121.79479, 37.34721], [-121.79492, 37.34706], [-121.79539, 37.34659], [-121.79553, 37.34638], [-121.79758, 37.34781]]]} | Open Access 1 | Fernish Park | 18881 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 5.483 | Fernish Park | 1984 | |
4447 | 4447 | 4446 | {"type": "Polygon", "coordinates": [[[-121.96563, 37.39796], [-121.96499, 37.39824], [-121.96491, 37.39816], [-121.96458, 37.39769], [-121.96438, 37.39777], [-121.96431, 37.39773], [-121.96432, 37.39768], [-121.96448, 37.39759], [-121.9642, 37.39717], [-121.96427, 37.39718], [-121.96433, 37.39715], [-121.9644, 37.39704], [-121.96447, 37.39699], [-121.9648, 37.39685], [-121.96488, 37.39686], [-121.96563, 37.39796]]]} | Open Access 1 | Fuller Street Park | 19142 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 2.434 | Fuller Street Park | 1984 | |
4546 | 4546 | 4545 | {"type": "Polygon", "coordinates": [[[-121.79518, 37.23742], [-121.79515, 37.23746], [-121.79513, 37.23751], [-121.79514, 37.2387], [-121.79513, 37.23879], [-121.7951, 37.23884], [-121.79504, 37.23888], [-121.79496, 37.23889], [-121.79468, 37.23884], [-121.79447, 37.23881], [-121.79399, 37.2388], [-121.79393, 37.23878], [-121.79391, 37.23873], [-121.79387, 37.23693], [-121.79388, 37.2369], [-121.79394, 37.23688], [-121.79461, 37.23701], [-121.79518, 37.23708], [-121.79518, 37.23742]]]} | Open Access 1 | George Page Park | 19272 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 5.627 | George Page Park | 1984 | |
4793 | 4793 | 4792 | {"type": "Polygon", "coordinates": [[[-121.88306, 37.23598], [-121.88282, 37.23622], [-121.88261, 37.23649], [-121.88268, 37.23668], [-121.88284, 37.23692], [-121.88238, 37.23705], [-121.88186, 37.23728], [-121.88159, 37.23744], [-121.88065, 37.23811], [-121.88052, 37.23825], [-121.88041, 37.23841], [-121.88029, 37.23876], [-121.88017, 37.23895], [-121.87981, 37.23938], [-121.8797, 37.23947], [-121.87956, 37.23956], [-121.87916, 37.23973], [-121.8789, 37.23954], [-121.8787, 37.23941], [-121.87844, 37.23928], [-121.8782, 37.23919], [-121.87803, 37.23948], [-121.87701, 37.23919], [-121.87697, 37.23916], [-121.87698, 37.23895], [-121.87695, 37.23881], [-121.87697, 37.23875], [-121.87716, 37.2386], [-121.87729, 37.23847], [-121.87755, 37.23816], [-121.87764, 37.23799], [-121.87767, 37.23781], [-121.87767, 37.23731], [-121.87801, 37.23725], [-121.87825, 37.23724], [-121.87836, 37.23668], [-121.87836, 37.23665], [-121.87764, 37.2361], [-121.87779, 37.23596], [-121.87789, 37.23578], [-121.87792, 37.23569], [-121.87794, 37.2355], [-121.87785, 37.23515], [-121.87784, 37.23498], [-121.87781, 37.23481], [-121.87774, 37.23464], [-121.87758, 37.23438], [-121.87755, 37.23428], [-121.87754, 37.23412], [-121.87765, 37.23381], [-121.87775, 37.23361], [-121.87786, 37.2335], [-121.87805, 37.23337], [-121.87812, 37.23327], [-121.87816, 37.23317], [-121.87816, 37.23309], [-121.87814, 37.23294], [-121.87815, 37.23285], [-121.87814, 37.2328], [-121.88021, 37.23293], [-121.88006, 37.23334], [-121.88034, 37.23378], [-121.88057, 37.23417], [-121.88125, 37.23452], [-121.88183, 37.23457], [-121.882, 37.23454], [-121.88218, 37.23447], [-121.88226, 37.23446], [-121.88239, 37.23454], [-121.88269, 37.23456], [-121.88271, 37.23468], [-121.88251, 37.23471], [-121.88232, 37.23482], [-121.8822, 37.235], [-121.88204, 37.23511], [-121.88195, 37.23533], [-121.882, 37.2354], [-121.88232, 37.23541], [-121.88233, 37.2355], [-121.88228, 37.23562], [-121.88237, 37.23576], [-121.88253, 37.23578], [-121.88281, 37.23578], [-121.883, 37.2359], [-121.88306, 37.23598]]]} | Open Access 1 | Guadalupe Oak Grove | 19555 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 57.836 | Guadalupe Oak Grove | 1984 | |
5248 | 5248 | 5247 | {"type": "Polygon", "coordinates": [[[-122.21778, 37.48305], [-122.21644, 37.48394], [-122.21344, 37.48339], [-122.21436, 37.48199], [-122.21537, 37.48239], [-122.21599, 37.4823], [-122.21778, 37.48305]]]} | Open Access 1 | Hoover Park | 20081 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 11.512 | Hoover Park | 1984 | |
5712 | 5712 | 5711 | {"type": "Polygon", "coordinates": [[[-118.38057, 34.01511], [-118.3805, 34.0151], [-118.38043, 34.01512], [-118.38035, 34.01526], [-118.37778, 34.0153], [-118.37775, 34.01366], [-118.37761, 34.01347], [-118.37663, 34.01349], [-118.37647, 34.01384], [-118.37619, 34.01404], [-118.37593, 34.01451], [-118.37583, 34.01452], [-118.37551, 34.01452], [-118.37458, 34.01458], [-118.37457, 34.01464], [-118.37434, 34.01465], [-118.37432, 34.01431], [-118.37424, 34.01381], [-118.37498, 34.01377], [-118.37494, 34.01346], [-118.37489, 34.01333], [-118.37488, 34.01324], [-118.37489, 34.01317], [-118.37961, 34.01301], [-118.38057, 34.01511]]]} | Open Access 1 | Kenneth Hahn State Recreation Area | http://www.parks.ca.gov/?page_id=612 | 20609 | 2125 | Rose Hills Memorial Park Association 406 | Special District 4 | Cemetery District 11 | http://www.rosehills.com/ | Special District 4 | 20.84 | Kenneth Hahn SRA | 1984 |
6314 | 6314 | 6313 | {"type": "Polygon", "coordinates": [[[-121.83923, 37.359], [-121.83914, 37.35909], [-121.83875, 37.35927], [-121.83871, 37.35928], [-121.83867, 37.35926], [-121.83633, 37.35687], [-121.83565, 37.35587], [-121.83599, 37.35588], [-121.83665, 37.3566], [-121.83681, 37.35652], [-121.83923, 37.359]]]} | Open Access 1 | Lo Bue Park | 21390 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 5.834 | Lo Bue Park | 1984 | |
6354 | 6354 | 6353 | {"type": "Polygon", "coordinates": [[[-121.91257, 37.24638], [-121.91193, 37.24639], [-121.91168, 37.24645], [-121.91158, 37.24641], [-121.91143, 37.24648], [-121.91143, 37.24653], [-121.9114, 37.24657], [-121.91116, 37.24668], [-121.91031, 37.24549], [-121.91017, 37.24517], [-121.90953, 37.24426], [-121.91011, 37.244], [-121.91017, 37.24399], [-121.91021, 37.24401], [-121.91111, 37.24526], [-121.91129, 37.24543], [-121.91151, 37.24556], [-121.91177, 37.24564], [-121.91196, 37.24566], [-121.91256, 37.24566], [-121.91257, 37.24638]]]} | Open Access 1 | Lone Hill Park | 21438 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 7.081 | Lone Hill Park | 1984 | |
6714 | 6714 | 6713 | {"type": "Polygon", "coordinates": [[[-122.0192, 37.34862], [-122.01805, 37.34863], [-122.01804, 37.34683], [-122.01919, 37.34683], [-122.0192, 37.34862]]]} | Open Access 1 | Panama Park | 23385 | 1345 | Sunnyvale, City of 413 | City 2 | City Agency 2 | http://sunnyvale.ca.gov/Departments/CommunityServices/Parks.aspx | City 2 | 5.018 | Panama Park | 1984 | |
6717 | 6717 | 6716 | {"type": "Polygon", "coordinates": [[[-121.86456, 37.33387], [-121.86435, 37.33498], [-121.86409, 37.33516], [-121.86367, 37.3373], [-121.86253, 37.3362], [-121.86309, 37.3358], [-121.86285, 37.33557], [-121.86285, 37.3355], [-121.86282, 37.33545], [-121.86253, 37.33517], [-121.8625, 37.33512], [-121.86251, 37.33507], [-121.86254, 37.335], [-121.86412, 37.33396], [-121.86417, 37.3339], [-121.8642, 37.33383], [-121.86456, 37.33387]]]} | Open Access 1 | Martin | 21901 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 8.34 | Martin | 1984 | |
6735 | 6735 | 6734 | {"type": "Polygon", "coordinates": [[[-121.77261, 37.22524], [-121.77226, 37.22632], [-121.77218, 37.22638], [-121.77202, 37.22639], [-121.77177, 37.22636], [-121.7713, 37.22671], [-121.77114, 37.22687], [-121.76979, 37.22607], [-121.77015, 37.22477], [-121.77007, 37.22474], [-121.77007, 37.22473], [-121.77243, 37.22517], [-121.77261, 37.22524]]]} | Open Access 1 | Martin Murphy Playfield | 21923 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 9.39 | Martin Murphy Playfield | 1984 | |
7059 | 7059 | 7058 | {"type": "Polygon", "coordinates": [[[-121.93952, 37.54652], [-121.93642, 37.54749], [-121.93634, 37.54757], [-121.93601, 37.54739], [-121.93593, 37.54741], [-121.93544, 37.54713], [-121.93594, 37.54656], [-121.93702, 37.54622], [-121.93777, 37.5454], [-121.93841, 37.54539], [-121.93841, 37.54585], [-121.93928, 37.54636], [-121.93952, 37.54652]]]} | Open Access 1 | Mission San Jose Community Park | 22310 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 9.581 | Mission San Jose Community Park | 1984 |
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]);