superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
82 rows where MNG_AGENCY = 138
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7719 | 7719 | 7718 | {"type": "Polygon", "coordinates": [[[-117.62881, 33.68711], [-117.62823, 33.68765], [-117.62818, 33.6877], [-117.62837, 33.68738], [-117.62838, 33.68717], [-117.62881, 33.68711]]]} | Open Access 1 | Orange holding 2 | 23167 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 0.227 | Orange holding 2 | ||
7720 | 7720 | 7719 | {"type": "Polygon", "coordinates": [[[-117.63374, 33.56465], [-117.63372, 33.56475], [-117.63293, 33.56513], [-117.63284, 33.56515], [-117.63278, 33.5651], [-117.63282, 33.56505], [-117.63252, 33.5646], [-117.63244, 33.56458], [-117.63241, 33.56453], [-117.63243, 33.56448], [-117.6333, 33.56407], [-117.63336, 33.56409], [-117.63374, 33.56465]]]} | Open Access 1 | Orange holding 20 | 23168 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 2.059 | Orange holding 20 | ||
7721 | 7721 | 7720 | {"type": "Polygon", "coordinates": [[[-117.63393, 33.55687], [-117.63377, 33.55721], [-117.63341, 33.55741], [-117.63334, 33.55739], [-117.63329, 33.55683], [-117.63343, 33.55627], [-117.6335, 33.55627], [-117.63383, 33.55651], [-117.63393, 33.55687]]]} | Open Access 1 | Orange holding 21 | 23169 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 1.278 | Orange holding 21 | ||
7722 | 7722 | 7721 | {"type": "Polygon", "coordinates": [[[-117.62942, 33.68702], [-117.62839, 33.68717], [-117.62837, 33.68738], [-117.62818, 33.6877], [-117.62813, 33.68775], [-117.62743, 33.68762], [-117.62754, 33.6872], [-117.6276, 33.68684], [-117.62873, 33.68685], [-117.62887, 33.68684], [-117.62926, 33.68677], [-117.6293, 33.6868], [-117.62942, 33.68702]]]} | Open Access 1 | Orange holding 3 | 23170 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 2.453 | Orange holding 3 | ||
7723 | 7723 | 7722 | {"type": "Polygon", "coordinates": [[[-117.63087, 33.67292], [-117.63058, 33.67337], [-117.6304, 33.67329], [-117.63037, 33.67331], [-117.63009, 33.67319], [-117.62988, 33.67335], [-117.62977, 33.6733], [-117.62957, 33.67326], [-117.62939, 33.67329], [-117.62916, 33.6734], [-117.62909, 33.67337], [-117.62914, 33.67323], [-117.62913, 33.67308], [-117.62914, 33.67295], [-117.62924, 33.67274], [-117.62944, 33.67259], [-117.62946, 33.67244], [-117.62955, 33.67229], [-117.63087, 33.67292]]]} | Open Access 1 | Orange holding 4 | 23171 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 2.905 | Orange holding 4 | ||
7724 | 7724 | 7723 | {"type": "Polygon", "coordinates": [[[-117.63857, 33.57457], [-117.63787, 33.57431], [-117.63727, 33.57449], [-117.63726, 33.57438], [-117.63751, 33.574], [-117.63751, 33.57405], [-117.63754, 33.57408], [-117.63777, 33.57416], [-117.63788, 33.57415], [-117.63799, 33.57409], [-117.63806, 33.57413], [-117.63814, 33.57414], [-117.63825, 33.57418], [-117.63855, 33.57422], [-117.63857, 33.57457]]]} | Open Access 1 | Orange holding 5 | 23172 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 0.87 | Orange holding 5 | ||
7725 | 7725 | 7724 | {"type": "Polygon", "coordinates": [[[-117.63726, 33.57438], [-117.63727, 33.57449], [-117.63717, 33.57496], [-117.63702, 33.57514], [-117.63615, 33.57531], [-117.63567, 33.5756], [-117.63515, 33.57558], [-117.63505, 33.57538], [-117.63485, 33.57548], [-117.63422, 33.57516], [-117.63384, 33.57494], [-117.63357, 33.57506], [-117.63345, 33.57529], [-117.63341, 33.57524], [-117.63358, 33.57484], [-117.63367, 33.57479], [-117.63511, 33.57517], [-117.63594, 33.57518], [-117.63671, 33.5749], [-117.63726, 33.57438]]]} | Open Access 1 | Orange holding 6 | 23173 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 2.929 | Orange holding 6 | ||
7726 | 7726 | 7725 | {"type": "Polygon", "coordinates": [[[-117.63554, 33.54852], [-117.63528, 33.54875], [-117.63505, 33.549], [-117.63502, 33.54901], [-117.63462, 33.54878], [-117.6346, 33.54874], [-117.63495, 33.54837], [-117.63516, 33.54819], [-117.63522, 33.5482], [-117.63553, 33.5485], [-117.63554, 33.54852]]]} | Open Access 1 | Orange holding 7 | 23174 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 1.005 | Orange holding 7 | ||
7727 | 7727 | 7726 | {"type": "Polygon", "coordinates": [[[-117.62419, 33.69092], [-117.62398, 33.69096], [-117.62396, 33.69093], [-117.62377, 33.69096], [-117.62351, 33.69104], [-117.62298, 33.69101], [-117.62301, 33.69097], [-117.62305, 33.69074], [-117.6231, 33.69026], [-117.62314, 33.69005], [-117.62321, 33.6899], [-117.62345, 33.6895], [-117.62353, 33.68947], [-117.62395, 33.68963], [-117.62408, 33.69006], [-117.62399, 33.69007], [-117.62398, 33.69008], [-117.62419, 33.69092]]]} | Open Access 1 | Orange holding 8 | 23175 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 3.388 | Orange holding 8 | ||
7728 | 7728 | 7727 | {"type": "Polygon", "coordinates": [[[-117.63605, 33.54568], [-117.63574, 33.54607], [-117.6355, 33.54619], [-117.63546, 33.54618], [-117.63543, 33.54597], [-117.63539, 33.54497], [-117.63543, 33.54495], [-117.6355, 33.54496], [-117.63596, 33.54523], [-117.63605, 33.54568]]]} | Open Access 1 | Orange holding 9 | 23176 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 1.436 | Orange holding 9 | ||
8264 | 8264 | 8263 | {"type": "Polygon", "coordinates": [[[-117.64544, 33.44089], [-117.64521, 33.44122], [-117.64472, 33.44093], [-117.64482, 33.44062], [-117.64519, 33.44075], [-117.64544, 33.44089]]]} | Open Access 1 | Poche Beach Park | 23820 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 0.599 | Poche Beach Park | ||
8580 | 8580 | 8579 | {"type": "Polygon", "coordinates": [[[-118.08938, 33.73032], [-118.08887, 33.73109], [-118.08653, 33.72956], [-118.08211, 33.72662], [-118.07756, 33.72272], [-118.07496, 33.72052], [-118.07152, 33.71736], [-118.06492, 33.71162], [-118.06543, 33.71158], [-118.0694, 33.71455], [-118.07064, 33.71524], [-118.07147, 33.71563], [-118.07167, 33.71594], [-118.07357, 33.71743], [-118.07588, 33.71905], [-118.07662, 33.71984], [-118.07762, 33.7205], [-118.07884, 33.72184], [-118.07967, 33.72233], [-118.08137, 33.72397], [-118.08275, 33.72511], [-118.08441, 33.72673], [-118.08676, 33.72852], [-118.08938, 33.73032]]]} | Open Access 1 | Sunset County Beach | 26043 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 94.025 | Sunset County Beach | ||
8695 | 8695 | 8694 | {"type": "Polygon", "coordinates": [[[-117.95287, 33.64312], [-117.95276, 33.64333], [-117.95271, 33.64349], [-117.95258, 33.64351], [-117.95264, 33.64375], [-117.95069, 33.65025], [-117.95032, 33.65064], [-117.95044, 33.65129], [-117.95, 33.65229], [-117.9495, 33.65229], [-117.94895, 33.65432], [-117.94797, 33.65773], [-117.94799, 33.65774], [-117.94829, 33.65774], [-117.94686, 33.66245], [-117.94601, 33.66564], [-117.94331, 33.66505], [-117.94417, 33.65804], [-117.94509, 33.65805], [-117.94565, 33.65663], [-117.9479, 33.65483], [-117.949, 33.6525], [-117.94937, 33.65235], [-117.94941, 33.65231], [-117.94949, 33.65231], [-117.94959, 33.65208], [-117.94976, 33.65186], [-117.94989, 33.65093], [-117.94928, 33.65063], [-117.94926, 33.64958], [-117.94856, 33.64958], [-117.94555, 33.64794], [-117.94592, 33.64317], [-117.95287, 33.64312]]]} | Open Access 1 | Talbert Nature Preserve | 26171 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 185.744 | Talbert Nature Preserve | ||
9134 | 9134 | 9133 | {"type": "MultiPolygon", "coordinates": [[[[-117.72548, 33.48131], [-117.72452, 33.48145], [-117.72446, 33.48119], [-117.72395, 33.48016], [-117.72398, 33.48011], [-117.72336, 33.47949], [-117.72333, 33.4794], [-117.72336, 33.47869], [-117.72328, 33.47868], [-117.72309, 33.47813], [-117.72161, 33.47762], [-117.72145, 33.47746], [-117.72125, 33.47718], [-117.72108, 33.47707], [-117.72086, 33.47699], [-117.72064, 33.477], [-117.72041, 33.47707], [-117.72027, 33.47717], [-117.72021, 33.47724], [-117.72008, 33.47735], [-117.71991, 33.47743], [-117.71975, 33.47747], [-117.71969, 33.47754], [-117.71966, 33.47731], [-117.71958, 33.47706], [-117.71949, 33.47687], [-117.71933, 33.47657], [-117.71958, 33.4764], [-117.71972, 33.47633], [-117.72017, 33.47617], [-117.72059, 33.47608], [-117.7207, 33.47603], [-117.72075, 33.47598], [-117.72103, 33.47613], [-117.7211, 33.47614], [-117.72116, 33.47611], [-117.72125, 33.47604], [-117.72131, 33.47596], [-117.72133, 33.47589], [-117.72132, 33.4755], [-117.72116, 33.47511], [-117.72109, 33.47457], [-117.72114, 33.47428], [-117.72126, 33.47406], [-117.72131, 33.47375], [-117.72119, 33.47355], [-117.72083, 33.47339], [-117.72013, 33.47303], [-117.72003, 33.47295], [-117.71994, 33.47282], [-117.71983, 33.4727], [-117.71982, 33.47267], [-117.71986, 33.47266], [-117.71988, 33.47252], [-117.71864, 33.47072], [-117.7178, 33.46933], [-117.71763, 33.46924], [-117.71756, 33.46924], [-117.71755, 33.46918], [-117.71684, 33.46918], [-117.7166, 33.46927], [-117.71639, 33.4692], [-117.71607, 33.46922], [-117.71542, 33.46922], [-117.71549, 33.46914], [-117.71813, 33.46914], [-117.71825, 33.46933], [-117.71846, 33.46972], [-117.71862, 33.46995], [-117.71874, 33.47021], [-117.71884, 33.47034], [-117.71889, 33.4705], [-117.71908, 33.47069], [-117.71912, 33.47079], [-117.71927, 33.47101], [-117.71934, 33.47104], [-117.71953, 33.47137], [-117.71964, 33.47151], [-117.71968, 33.4716], [-117.71982, 33.47167], [-117.71991, 33.47185], [-117.72032, 33.47209], [-117.72052, 33.47231], [-117.72061, 33.47247], [-117.72071, 33.4728], [-117.72084, 33.47289], [-117.72098, 33.47317], [-117.72118, 33.47329], [-117.72146, 33.47342], [-117.72154, 33.47348], [-117.72165, 33.47365], [-117.7219, 33.47424], [-117.7219, 33.47429], [-117.72206, 33.47454], [-117.72209, 33.47468], [-117.72216, 33.47477], [-117.72219, 33.47493], [-117.72228, 33.47503], [-117.72242, 33.4754], [-117.72265, 33.47591], [-117.72271, 33.47605], [-117.72272, 33.47626], [-117.72279, 33.47633], [-117.72303, 33.47688], [-117.72319, 33.47707], [-117.72322, 33.47719], [-117.72335, 33.47734], [-117.72352, 33.47769], [-117.7238, 33.47848], [-117.72397, 33.47877], [-117.72404, 33.47905], [-117.72416, 33.47929], [-117.72436, 33.47984], [-117.72446, 33.48001], [-117.72456, 33.48027], [-117.72466, 33.48044], [-117.72479, 33.48074], [-117.72483, 33.48079], [-117.72493, 33.48082], [-117.72513, 33.48102], [-117.72535, 33.48114], [-117.72548, 33.48131]]], [[[-117.71875, 33.47865], [-117.71714, 33.47625], [-117.71803, 33.47583], [-117.7184, 33.47602], [-117.71861, 33.47614], [-117.71883, 33.47632], [-117.719, 33.47648], [-117.71911, 33.47661], [-117.71928, 33.47687], [-117.71941, 33.47716], [-117.71945, 33.47732], [-117.71951, 33.47762], [-117.71951, 33.47784], [-117.71949, 33.47813], [-117.71943, 33.4783], [-117.71937, 33.47839], [-117.71919, 33.47853], [-117.7189, 33.47866], [-117.71875, 33.47865]]], [[[-117.72425, 33.4818], [-117.72336, 33.48334], [-117.7219, 33.48208], [-117.72357, 33.48188], [-117.72425, 33.4818]]]]} | Open Access 1 | Salt Creek Beach County Park | 24808 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 44.897 | Salt Creek Beach County Park | ||
9203 | 9203 | 9202 | {"type": "MultiPolygon", "coordinates": [[[[-117.85104, 33.66409], [-117.85056, 33.66457], [-117.85039, 33.66479], [-117.84631, 33.66889], [-117.84585, 33.66943], [-117.84565, 33.66972], [-117.84503, 33.67081], [-117.84484, 33.67084], [-117.84412, 33.67061], [-117.84355, 33.67048], [-117.84327, 33.67042], [-117.84269, 33.67034], [-117.84197, 33.67028], [-117.84123, 33.67027], [-117.83645, 33.6705], [-117.83635, 33.66901], [-117.83652, 33.66898], [-117.83642, 33.66747], [-117.8364, 33.66689], [-117.83644, 33.66642], [-117.83657, 33.66573], [-117.83714, 33.666], [-117.83906, 33.66736], [-117.8446, 33.66183], [-117.8446, 33.66181], [-117.84162, 33.65973], [-117.84575, 33.65589], [-117.8462, 33.65622], [-117.84645, 33.65643], [-117.84675, 33.65673], [-117.84713, 33.65719], [-117.8473, 33.65742], [-117.84745, 33.65769], [-117.84757, 33.65796], [-117.84767, 33.65824], [-117.84851, 33.66087], [-117.84871, 33.66139], [-117.84903, 33.662], [-117.84935, 33.66247], [-117.84958, 33.66275], [-117.85011, 33.66327], [-117.85059, 33.66366], [-117.85104, 33.66398], [-117.85104, 33.66409]]], [[[-117.86095, 33.65401], [-117.86078, 33.6542], [-117.86051, 33.65429], [-117.86026, 33.6544], [-117.8598, 33.65467], [-117.85946, 33.65494], [-117.85934, 33.65506], [-117.85902, 33.65504], [-117.8585, 33.65477], [-117.85822, 33.65469], [-117.85779, 33.65464], [-117.85729, 33.65455], [-117.85688, 33.65444], [-117.85636, 33.65413], [-117.85617, 33.65399], [-117.8559, 33.65387], [-117.85583, 33.65381], [-117.85571, 33.6536], [-117.85295, 33.65099], [-117.85325, 33.65094], [-117.85983, 33.6509], [-117.85988, 33.65115], [-117.85998, 33.65155], [-117.86004, 33.6518], [-117.86013, 33.65205], [-117.86013, 33.6521], [-117.8601, 33.65216], [-117.86012, 33.65246], [-117.86022, 33.65247], [-117.86042, 33.6532], [-117.86058, 33.65354], [-117.86075, 33.65379], [-117.86095, 33.65401]]]]} | Restricted Access 2 | San Joaquin Freshwater Marsh Reserve | 24910 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 309.283 | San Joaquin Freshwater Marsh Reserve | ||
9279 | 9279 | 9278 | {"type": "Polygon", "coordinates": [[[-117.95741, 33.62872], [-117.95706, 33.62962], [-117.9526, 33.62718], [-117.94262, 33.62183], [-117.94138, 33.62113], [-117.94019, 33.62061], [-117.93653, 33.61699], [-117.93151, 33.61156], [-117.93212, 33.61121], [-117.93227, 33.61144], [-117.93392, 33.61329], [-117.93419, 33.61384], [-117.93741, 33.61721], [-117.93957, 33.61938], [-117.94029, 33.61993], [-117.94128, 33.62059], [-117.94314, 33.62168], [-117.94645, 33.62335], [-117.9474, 33.62381], [-117.94967, 33.625], [-117.95099, 33.62563], [-117.9543, 33.62728], [-117.95557, 33.62815], [-117.95676, 33.62864], [-117.95741, 33.62872]]]} | Open Access 1 | Santa Ana River County Beach | 25032 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 42.56 | Santa Ana River County Beach | ||
9684 | 9684 | 9683 | {"type": "Polygon", "coordinates": [[[-117.71813, 33.46914], [-117.71782, 33.46914], [-117.71759, 33.46875], [-117.71627, 33.4669], [-117.71623, 33.46688], [-117.71581, 33.46699], [-117.71576, 33.46684], [-117.71616, 33.46674], [-117.71618, 33.46673], [-117.71618, 33.46669], [-117.71605, 33.46642], [-117.71602, 33.4663], [-117.71589, 33.46599], [-117.71512, 33.46478], [-117.71464, 33.46368], [-117.71535, 33.46391], [-117.71545, 33.46419], [-117.71551, 33.4647], [-117.71576, 33.46532], [-117.71605, 33.46569], [-117.71634, 33.46625], [-117.71644, 33.46654], [-117.71691, 33.46711], [-117.71701, 33.46745], [-117.71715, 33.46761], [-117.71731, 33.46791], [-117.71741, 33.46805], [-117.71749, 33.46833], [-117.71763, 33.46861], [-117.71779, 33.4688], [-117.71797, 33.46895], [-117.71813, 33.46914]]]} | Open Access 1 | Silver Strand Beach County Park | 25495 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 5.164 | Silver Strand Beach County Park | ||
9872 | 9872 | 9871 | {"type": "Polygon", "coordinates": [[[-117.71884, 33.57576], [-117.71881, 33.57578], [-117.71873, 33.57603], [-117.71834, 33.57736], [-117.71799, 33.57769], [-117.7177, 33.57776], [-117.71697, 33.5773], [-117.71696, 33.57726], [-117.7171, 33.57705], [-117.71724, 33.57692], [-117.71744, 33.5768], [-117.71759, 33.57667], [-117.71771, 33.57652], [-117.71775, 33.5765], [-117.71782, 33.57635], [-117.71788, 33.57615], [-117.71789, 33.57604], [-117.71787, 33.57583], [-117.71784, 33.57569], [-117.71784, 33.57561], [-117.71795, 33.57538], [-117.71804, 33.57492], [-117.71858, 33.57549], [-117.71849, 33.57547], [-117.71836, 33.5755], [-117.71832, 33.57555], [-117.7183, 33.57559], [-117.71834, 33.57569], [-117.71842, 33.57574], [-117.71849, 33.57574], [-117.71873, 33.57565], [-117.71884, 33.57576]]]} | Open Access 1 | Springdale Park | 25746 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 5.783 | Springdale Park | ||
10120 | 10120 | 10119 | {"type": "MultiPolygon", "coordinates": [[[[-118.07693, 33.72934], [-118.0768, 33.72967], [-118.07605, 33.7304], [-118.06997, 33.73039], [-118.071, 33.72955], [-118.07185, 33.72959], [-118.07242, 33.72965], [-118.07248, 33.72963], [-118.07272, 33.72967], [-118.07273, 33.72957], [-118.07283, 33.72939], [-118.07291, 33.7293], [-118.07302, 33.72921], [-118.07321, 33.72907], [-118.07344, 33.72896], [-118.07363, 33.72888], [-118.07386, 33.72881], [-118.0741, 33.72877], [-118.07429, 33.729], [-118.07423, 33.72927], [-118.07389, 33.72947], [-118.0738, 33.7298], [-118.07483, 33.72994], [-118.07602, 33.72987], [-118.07624, 33.72969], [-118.07617, 33.7294], [-118.07616, 33.72921], [-118.0763, 33.72904], [-118.07693, 33.72934]]], [[[-118.08125, 33.72954], [-118.08108, 33.72965], [-118.08084, 33.72973], [-118.08083, 33.72994], [-118.08091, 33.73], [-118.08074, 33.73008], [-118.08067, 33.7302], [-118.08049, 33.73035], [-118.08026, 33.73039], [-118.07999, 33.73038], [-118.07968, 33.7304], [-118.07691, 33.7304], [-118.07732, 33.73003], [-118.07773, 33.72887], [-118.0786, 33.72857], [-118.07912, 33.72844], [-118.08014, 33.72894], [-118.08047, 33.7293], [-118.08063, 33.72945], [-118.08073, 33.72938], [-118.08114, 33.72943], [-118.08125, 33.72954]]]]} | Open Access 1 | Sunset Harbor | 26046 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 27.078 | Sunset Harbor | ||
10121 | 10121 | 10120 | {"type": "Polygon", "coordinates": [[[-117.96399, 33.63508], [-117.96237, 33.63687], [-117.96074, 33.63584], [-117.95743, 33.63372], [-117.958, 33.63182], [-117.96399, 33.63508]]]} | Unknown Access 4 | Talbert Marsh | 26170 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 34.688 | Talbert Marsh |
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]);