superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
48 rows where ACCESS_TYP = 1 and MNG_AG_TYP = 12
This data as json, copyable, CSV (advanced)
MNG_AGENCY 25
- Del Monte Forest Foundation 6
- Mountains Restoration Trust 3
- Trust for Public Land 3
- Irvine Ranch Conservancy 3
- Marin Audubon Society 2
- Community Environmental Council 2
- Friends of the Enchanted Meadow 2
- Morro Coast Audubon Society 1
- National Audubon Society 1
- Serra Cross Conservancy 1
- Westport Village Society 1
- Friends of Palm Springs Mountains 1
- San Diego River Park Foundation 1
- Audubon Canyon Ranch 1
- The Old Mill Foundation 1
- Moat Creek Managing Agency 1
- Redwood Coast Land Conservancy 1
- Palo Cerdo Community Park Association 1
- Placer Legacy 1
- Watsonville Wetlands Watch 1
- Marin Conservation League 1
- Los Angeles Conservation Corps 1
- Batiquitos Lagoon Foundation 1
- Stewards of the Coast and Redwoods 1
- Redwood Coast Recreation Center 1
MNG_AG_TYP 1
- Non Profit - Conservation · 39 ✖
ACCESS_TYP 1
- Open Access · 39 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3968 | 3968 | 3967 | {"type": "Polygon", "coordinates": [[[-121.20019, 38.71522], [-121.20005, 38.71565], [-121.19981, 38.71561], [-121.19954, 38.7156], [-121.19959, 38.71518], [-121.20019, 38.71522]]]} | Open Access 1 | Elsami | 18603 | 3056 | Placer Legacy 935 | Non Profit 6 | Non Profit - Conservation 12 | http://www.placer.ca.gov/departments/communitydevelopment/planning/placerlegacy | Non Governmental Organization 10 | 0.573 | Elsami | ||
5236 | 5236 | 5235 | {"type": "Polygon", "coordinates": [[[-119.71423, 34.41147], [-119.71286, 34.41261], [-119.71211, 34.41205], [-119.71251, 34.41167], [-119.71232, 34.41149], [-119.71267, 34.41116], [-119.7132, 34.41071], [-119.71401, 34.41104], [-119.71423, 34.41147]]]} | Open Access 1 | Honda Valley Park - Community Environmental Council | 20066 | 3015 | Community Environmental Council 500 | Non Profit 6 | Non Profit - Conservation 12 | http://www.communityenvironmentalcouncil.org/ | Non Governmental Organization 10 | 5.433 | Honda Valley Park - Community Environmental Council | ||
6720 | 6720 | 6719 | {"type": "Polygon", "coordinates": [[[-122.69118, 37.9329], [-122.68888, 37.93441], [-122.67482, 37.94751], [-122.66036, 37.93681], [-122.66163, 37.93601], [-122.66163, 37.93599], [-122.65724, 37.93353], [-122.65725, 37.9335], [-122.6572, 37.93347], [-122.65775, 37.93261], [-122.65787, 37.93201], [-122.66228, 37.92912], [-122.66557, 37.92719], [-122.66568, 37.92715], [-122.66657, 37.92673], [-122.66708, 37.92652], [-122.66955, 37.92521], [-122.67289, 37.92396], [-122.67443, 37.92344], [-122.67464, 37.92388], [-122.67503, 37.92435], [-122.67516, 37.9246], [-122.67551, 37.92494], [-122.67583, 37.92515], [-122.67596, 37.92522], [-122.67608, 37.92525], [-122.67657, 37.92529], [-122.677, 37.92529], [-122.67779, 37.9252], [-122.67879, 37.92521], [-122.67907, 37.92527], [-122.67913, 37.92531], [-122.67927, 37.92537], [-122.67976, 37.9257], [-122.6799, 37.92577], [-122.68007, 37.92582], [-122.68031, 37.92595], [-122.68036, 37.92601], [-122.6804, 37.92609], [-122.68043, 37.92618], [-122.68043, 37.92635], [-122.68049, 37.92644], [-122.68101, 37.927], [-122.68148, 37.92737], [-122.68185, 37.92762], [-122.68199, 37.92778], [-122.68205, 37.92791], [-122.68208, 37.92809], [-122.68207, 37.92836], [-122.68203, 37.92864], [-122.682, 37.92902], [-122.68201, 37.92914], [-122.68206, 37.92934], [-122.68211, 37.92948], [-122.68223, 37.92966], [-122.68246, 37.92987], [-122.68273, 37.93004], [-122.68314, 37.93023], [-122.68387, 37.93053], [-122.68406, 37.93058], [-122.68427, 37.9306], [-122.68457, 37.93059], [-122.68522, 37.93045], [-122.68529, 37.93085], [-122.68565, 37.93107], [-122.68593, 37.93102], [-122.68642, 37.93039], [-122.68675, 37.93041], [-122.68792, 37.93056], [-122.68821, 37.93071], [-122.68836, 37.93086], [-122.68845, 37.931], [-122.68849, 37.93113], [-122.68851, 37.93133], [-122.68849, 37.93148], [-122.68841, 37.93167], [-122.68843, 37.93199], [-122.68856, 37.93222], [-122.68876, 37.93235], [-122.68919, 37.93253], [-122.68963, 37.93266], [-122.68999, 37.9327], [-122.69036, 37.93269], [-122.69081, 37.93262], [-122.69093, 37.93264], [-122.69104, 37.93271], [-122.69118, 37.9329]]]} | Open Access 1 | Martin Griffin Preserve | 21904 | 3005 | Audubon Canyon Ranch 814 | Non Profit 6 | Non Profit - Conservation 12 | http://www.egret.org | Non Governmental Organization 10 | 1010.787 | Martin Griffin Preserve | ||
8583 | 8583 | 8582 | {"type": "Polygon", "coordinates": [[[-118.6346, 34.10682], [-118.63459, 34.10718], [-118.6335, 34.10718], [-118.63333, 34.10682], [-118.63356, 34.10682], [-118.63372, 34.1069], [-118.63389, 34.10682], [-118.6346, 34.10682]]]} | Open Access 1 | Red Rock Canyon Park | 24227 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 1.049 | Red Rock Canyon Park | ||
8738 | 8738 | 8737 | {"type": "Polygon", "coordinates": [[[-121.93421, 36.60999], [-121.93184, 36.60975], [-121.932, 36.60951], [-121.93212, 36.60925], [-121.93222, 36.60897], [-121.93226, 36.6088], [-121.93229, 36.60854], [-121.93229, 36.60833], [-121.93227, 36.60812], [-121.93222, 36.60787], [-121.93214, 36.60765], [-121.93203, 36.60742], [-121.9319, 36.60721], [-121.93327, 36.60681], [-121.93327, 36.60718], [-121.9333, 36.60759], [-121.9334, 36.60812], [-121.9335, 36.60851], [-121.93372, 36.60916], [-121.93395, 36.60966], [-121.93405, 36.60983], [-121.93421, 36.60999]]]} | Open Access 1 | Rip Van Winkle Open Space | 24395 | 3016 | Del Monte Forest Foundation 552 | Non Profit 6 | Non Profit - Conservation 12 | http://www.delmonteforestfoundation.org/ | Non Governmental Organization 10 | 9.948 | Rip Van Winkle OS | ||
9167 | 9167 | 9166 | {"type": "Polygon", "coordinates": [[[-123.67793, 38.88158], [-123.67779, 38.88178], [-123.67736, 38.88184], [-123.67704, 38.88184], [-123.67605, 38.88163], [-123.67615, 38.88209], [-123.67607, 38.88208], [-123.67596, 38.88214], [-123.67593, 38.88221], [-123.67594, 38.88229], [-123.67596, 38.88232], [-123.67584, 38.88241], [-123.6752, 38.88218], [-123.67489, 38.88312], [-123.67478, 38.88317], [-123.67461, 38.88321], [-123.6744, 38.8832], [-123.67327, 38.8825], [-123.6732, 38.88249], [-123.67262, 38.88206], [-123.67226, 38.88183], [-123.67086, 38.88065], [-123.67085, 38.88052], [-123.6709, 38.88046], [-123.67115, 38.88027], [-123.67134, 38.88016], [-123.67138, 38.88014], [-123.67143, 38.88015], [-123.67147, 38.88017], [-123.67166, 38.88041], [-123.67226, 38.88107], [-123.67263, 38.88129], [-123.67283, 38.88138], [-123.67289, 38.88139], [-123.67295, 38.88137], [-123.67302, 38.8813], [-123.67303, 38.88121], [-123.67301, 38.88117], [-123.67296, 38.88113], [-123.67285, 38.8811], [-123.67278, 38.88112], [-123.67261, 38.88111], [-123.6725, 38.88106], [-123.67233, 38.88093], [-123.6706, 38.87897], [-123.67133, 38.87866], [-123.67118, 38.87854], [-123.67097, 38.87846], [-123.67085, 38.87838], [-123.67078, 38.87826], [-123.67076, 38.87818], [-123.67066, 38.87809], [-123.67056, 38.87788], [-123.6704, 38.8778], [-123.67032, 38.87786], [-123.67031, 38.87769], [-123.67045, 38.87772], [-123.67068, 38.87788], [-123.67088, 38.87807], [-123.67097, 38.87827], [-123.67122, 38.87844], [-123.67138, 38.87857], [-123.67158, 38.87864], [-123.67166, 38.87883], [-123.67181, 38.87895], [-123.67196, 38.87903], [-123.67202, 38.87914], [-123.67253, 38.87988], [-123.67272, 38.88007], [-123.67286, 38.88031], [-123.67307, 38.88042], [-123.67389, 38.8807], [-123.67458, 38.88089], [-123.67499, 38.88116], [-123.67527, 38.88127], [-123.67704, 38.88176], [-123.67736, 38.88174], [-123.67793, 38.88158]]]} | Open Access 1 | Moat Creek Coastal Access | http://visitredwoodcoast.com/content/moat-creek-coastal-access-and-trail/nco9B9343306A4C803A6 | 33692 | 3398 | Moat Creek Managing Agency 878 | Non Profit 6 | Non Profit - Conservation 12 | Non Governmental Organization 10 | 23.565 | Moat Creek Coastal Access | ||
9213 | 9213 | 9212 | {"type": "Polygon", "coordinates": [[[-123.64935, 38.84992], [-123.64931, 38.84997], [-123.64905, 38.85012], [-123.6491, 38.8502], [-123.64922, 38.8503], [-123.64935, 38.85043], [-123.64926, 38.85052], [-123.64925, 38.85081], [-123.64913, 38.85087], [-123.64879, 38.85091], [-123.6488, 38.85097], [-123.64889, 38.851], [-123.64926, 38.851], [-123.64932, 38.85103], [-123.64924, 38.85123], [-123.64905, 38.85129], [-123.64886, 38.85128], [-123.64865, 38.85135], [-123.64865, 38.8514], [-123.64859, 38.85151], [-123.64858, 38.8516], [-123.64874, 38.85164], [-123.64862, 38.8517], [-123.64861, 38.85178], [-123.6485, 38.85183], [-123.64834, 38.85186], [-123.64822, 38.85194], [-123.64778, 38.85177], [-123.6477, 38.85162], [-123.64757, 38.85111], [-123.64735, 38.85059], [-123.64703, 38.8501], [-123.64817, 38.84956], [-123.6482, 38.84968], [-123.64816, 38.84975], [-123.64816, 38.84981], [-123.64797, 38.84979], [-123.64779, 38.84979], [-123.64762, 38.85], [-123.64765, 38.85012], [-123.64778, 38.85034], [-123.64793, 38.85047], [-123.64806, 38.85051], [-123.64829, 38.85043], [-123.64844, 38.85027], [-123.64843, 38.85018], [-123.64865, 38.85004], [-123.64885, 38.84997], [-123.64907, 38.84994], [-123.64935, 38.84992]]]} | Open Access 1 | Hearn Gulch | https://www.rclc.org/hearn-gulch/ | 33693 | 3303 | Redwood Coast Land Conservancy 879 | Non Profit 6 | Non Profit - Conservation 12 | http://www.rc-lc.org/ | Non Governmental Organization 10 | 6.419 | Hearn Gulch | 2008 |
9465 | 9465 | 9464 | {"type": "Polygon", "coordinates": [[[-122.47026, 38.03457], [-122.47026, 38.03457], [-122.46444, 38.03432], [-122.46746, 38.02948], [-122.47021, 38.02945], [-122.47026, 38.03457]]]} | Open Access 1 | Water Lots | 27295 | 3130 | Marin Conservation League 997 | Non Profit 6 | Non Profit - Conservation 12 | http://www.marinconservationleague.org/ | Non Governmental Organization 10 | 51.859 | Water Lots | ||
9925 | 9925 | 9924 | {"type": "Polygon", "coordinates": [[[-118.24324, 33.90596], [-118.243, 33.90596], [-118.24296, 33.90579], [-118.2428, 33.90555], [-118.24267, 33.90547], [-118.24228, 33.90547], [-118.24206, 33.90556], [-118.24174, 33.90563], [-118.24154, 33.90508], [-118.24172, 33.90504], [-118.24174, 33.90502], [-118.24165, 33.90479], [-118.24133, 33.90457], [-118.24197, 33.90439], [-118.24199, 33.9044], [-118.24323, 33.90582], [-118.24324, 33.90596]]]} | Open Access 1 | Compton Creek-Washington Elementary | https://mrca.ca.gov/parks/park-listing/compton-creek-natural-park-at-george-washington-elementary/ | 27986 | 3384 | Los Angeles Conservation Corps 1004 | Non Profit 6 | Non Profit - Conservation 12 | https://www.lacorps.org/ | Non Governmental Organization 10 | 2.731 | Compton Creek-Washington Elementary | |
10166 | 10166 | 10165 | {"type": "Polygon", "coordinates": [[[-120.84817, 35.32126], [-120.84815, 35.32137], [-120.84803, 35.32132], [-120.84642, 35.32149], [-120.84526, 35.32195], [-120.84319, 35.32215], [-120.84305, 35.32222], [-120.84157, 35.32248], [-120.84135, 35.3228], [-120.84054, 35.32138], [-120.84055, 35.3212], [-120.84053, 35.32104], [-120.84047, 35.32086], [-120.84038, 35.3207], [-120.8417, 35.32045], [-120.84307, 35.32045], [-120.84306, 35.32132], [-120.84357, 35.32133], [-120.8449, 35.32046], [-120.84491, 35.32041], [-120.84605, 35.32043], [-120.84615, 35.32032], [-120.84817, 35.32126]], [[-120.84302, 35.32151], [-120.84303, 35.3209], [-120.8427, 35.32089], [-120.84258, 35.32095], [-120.84254, 35.32092], [-120.84208, 35.32117], [-120.84257, 35.32151], [-120.84302, 35.32151]]]} | Open Access 1 | Sweet Springs Nature Preserve | 26104 | 3043 | Morro Coast Audubon Society 461 | Non Profit 6 | Non Profit - Conservation 12 | http://www.morrocoastaudubon.org/ | Non Governmental Organization 10 | 22.673 | Sweet Springs Nature Preserve | ||
10232 | 10232 | 10231 | {"type": "Polygon", "coordinates": [[[-121.77745, 36.91053], [-121.77722, 36.91156], [-121.77673, 36.91208], [-121.77635, 36.91196], [-121.77603, 36.91181], [-121.77584, 36.91168], [-121.7757, 36.91157], [-121.77547, 36.91132], [-121.77591, 36.91037], [-121.77745, 36.91053]]]} | Open Access 1 | Tarplant Hill | 26191 | 3118 | Watsonville Wetlands Watch 989 | Non Profit 6 | Non Profit - Conservation 12 | http://www.watsonvillewetlandswatch.org/ | Non Governmental Organization 10 | 5.694 | Tarplant Hill | ||
11563 | 11563 | 11562 | {"type": "Polygon", "coordinates": [[[-118.2902, 34.09309], [-118.2894, 34.0931], [-118.2894, 34.09282], [-118.2902, 34.09282], [-118.2902, 34.09309]]]} | Open Access 1 | Madison Avenue Park | http://www.tpl.org/our-work/parks-for-people/madison-ave-park | 28044 | 3094 | Trust for Public Land 718 | Non Profit 6 | Non Profit - Conservation 12 | http://www.tpl.org/ | Non Governmental Organization 10 | 0.559 | Madison Avenue Park | |
11573 | 11573 | 11572 | {"type": "Polygon", "coordinates": [[[-118.25946, 34.06588], [-118.25927, 34.06617], [-118.25885, 34.06598], [-118.25904, 34.06569], [-118.25946, 34.06588]]]} | Open Access 1 | Patton Street Park | https://www.tpl.org/our-work/parks-for-people/patton-street-park | 28079 | 3094 | Trust for Public Land 718 | Non Profit 6 | Non Profit - Conservation 12 | http://www.tpl.org/ | Non Governmental Organization 10 | 0.4 | Patton Street Park | |
11576 | 11576 | 11575 | {"type": "Polygon", "coordinates": [[[-123.53176, 38.79603], [-123.52979, 38.79762], [-123.52905, 38.79636], [-123.52785, 38.79494], [-123.52811, 38.79484], [-123.52838, 38.79482], [-123.5285, 38.79482], [-123.52897, 38.79489], [-123.52942, 38.79536], [-123.53153, 38.79567], [-123.53176, 38.79603]]]} | Open Access 1 | Redwood Coast Recreation Center | http://rcrcpool.org/ | 33212 | 3389 | Redwood Coast Recreation Center 1116 | Non Profit 6 | Non Profit - Conservation 12 | http://rcrcpool.org/#about | Non Governmental Organization 10 | 11.149 | Redwood Coast Rec. Ctr. | 1999 |
11588 | 11588 | 11587 | {"type": "Polygon", "coordinates": [[[-118.33306, 33.97936], [-118.33306, 33.97952], [-118.33244, 33.97953], [-118.33244, 33.97936], [-118.33306, 33.97936]]]} | Open Access 1 | South Victoria Avenue Park | http://www.tpl.org/our-work/parks-for-people/fitness-zones/south-victoria-avenue-park | 28103 | 3094 | Trust for Public Land 718 | Non Profit 6 | Non Profit - Conservation 12 | http://www.tpl.org/ | Non Governmental Organization 10 | 0.26 | South Victoria Avenue Park | 2019 |
11640 | 11640 | 11639 | {"type": "Polygon", "coordinates": [[[-122.23717, 40.56026], [-122.2369, 40.56056], [-122.23549, 40.56201], [-122.23102, 40.56204], [-122.2313, 40.56082], [-122.23338, 40.56082], [-122.23339, 40.56028], [-122.23717, 40.56026]]]} | Open Access 1 | Palo Cedro Community Park | 33316 | 3394 | Palo Cerdo Community Park Association 922 | Non Profit 6 | Non Profit - Conservation 12 | https://pcpark.org/ | Non Governmental Organization 10 | 18.26 | Palo Cedro Community Park | 2006 | |
11645 | 11645 | 11644 | {"type": "Polygon", "coordinates": [[[-123.7274, 39.24845], [-123.72682, 39.2487], [-123.72662, 39.2486], [-123.72645, 39.24844], [-123.72609, 39.24815], [-123.72594, 39.24806], [-123.72562, 39.24794], [-123.72529, 39.24766], [-123.72488, 39.24741], [-123.72471, 39.24728], [-123.72437, 39.24658], [-123.72419, 39.2464], [-123.72412, 39.2462], [-123.72418, 39.24532], [-123.72483, 39.24527], [-123.72523, 39.24513], [-123.7251, 39.24577], [-123.72525, 39.24628], [-123.72568, 39.24692], [-123.72603, 39.24724], [-123.72638, 39.24732], [-123.72713, 39.24796], [-123.72724, 39.24812], [-123.72735, 39.24824], [-123.7274, 39.24845]]]} | Open Access 1 | Albert Cattalini Conservancy | http://www.friendsofenchantedmeadow.org/acc.html | 28204 | 3353 | Friends of the Enchanted Meadow 730 | Non Profit 6 | Non Profit - Conservation 12 | http://www.friendsofenchantedmeadow.org/ | Non Governmental Organization 10 | 9.327 | Albert Cattalini Conservancy | |
11646 | 11646 | 11645 | {"type": "Polygon", "coordinates": [[[-122.49894, 38.01446], [-122.49539, 38.01456], [-122.48924, 38.01369], [-122.48627, 38.01271], [-122.48622, 38.01267], [-122.48309, 38.01166], [-122.47894, 38.01029], [-122.47893, 38.00548], [-122.47958, 38.00571], [-122.48005, 38.00605], [-122.48038, 38.00636], [-122.48081, 38.00667], [-122.48135, 38.00724], [-122.4815, 38.00754], [-122.48158, 38.00762], [-122.48167, 38.00768], [-122.48183, 38.00773], [-122.48192, 38.00774], [-122.48203, 38.00772], [-122.48215, 38.00768], [-122.48231, 38.00767], [-122.48259, 38.00772], [-122.48287, 38.00766], [-122.48416, 38.00777], [-122.4859, 38.00918], [-122.48688, 38.0108], [-122.48795, 38.01262], [-122.48831, 38.01285], [-122.48847, 38.01316], [-122.48922, 38.01367], [-122.4895, 38.0131], [-122.48932, 38.01235], [-122.49261, 38.01094], [-122.49894, 38.01446]]]} | Open Access 1 | Unnamed site - National Audubon Society | 30327 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 123.63 | |||
11647 | 11647 | 11646 | {"type": "Polygon", "coordinates": [[[-123.72841, 39.25459], [-123.72836, 39.25477], [-123.72774, 39.25477], [-123.72734, 39.25423], [-123.72695, 39.2538], [-123.72614, 39.25278], [-123.72607, 39.25268], [-123.72573, 39.25242], [-123.7255, 39.25223], [-123.7254, 39.25204], [-123.72532, 39.25184], [-123.72532, 39.25161], [-123.72538, 39.25135], [-123.72509, 39.25077], [-123.72528, 39.25029], [-123.72534, 39.24985], [-123.72518, 39.24934], [-123.72499, 39.24893], [-123.72531, 39.24875], [-123.72585, 39.24829], [-123.72603, 39.24822], [-123.72628, 39.24841], [-123.72658, 39.24867], [-123.72676, 39.24878], [-123.72664, 39.24928], [-123.72705, 39.24987], [-123.7272, 39.25039], [-123.72728, 39.25059], [-123.72746, 39.25075], [-123.72761, 39.25109], [-123.7274, 39.25158], [-123.72737, 39.25191], [-123.7272, 39.2526], [-123.72734, 39.25285], [-123.72759, 39.25311], [-123.72813, 39.25374], [-123.72841, 39.25459]]]} | Open Access 1 | Raven's Call | http://www.friendsofenchantedmeadow.org/raven.html | 28205 | 3353 | Friends of the Enchanted Meadow 730 | Non Profit 6 | Non Profit - Conservation 12 | http://www.friendsofenchantedmeadow.org/ | Non Governmental Organization 10 | 23.568 | Raven's Call | |
11676 | 11676 | 11675 | {"type": "Polygon", "coordinates": [[[-118.12811, 34.11951], [-118.12805, 34.11968], [-118.1278, 34.11974], [-118.12742, 34.11973], [-118.1274, 34.11975], [-118.12724, 34.11968], [-118.12728, 34.11907], [-118.1277, 34.11898], [-118.1279, 34.1189], [-118.12811, 34.11951]]]} | Open Access 1 | The Old Mill | http://www.old-mill.org/ | 28251 | 3354 | The Old Mill Foundation 845 | Non Profit 6 | Non Profit - Conservation 12 | http://www.old-mill.org/ | Non Governmental Organization 10 | 1.424 | The Old Mill |
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]);