superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
72 rows where ACCESS_TYP = 1 and MNG_AGENCY = 29 sorted by map
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP
ACCESS_TYP 1
- Open Access · 72 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9716 | 9716 | 9715 | {"type": "MultiPolygon", "coordinates": [[[[-122.63954, 38.46598], [-122.63951, 38.46603], [-122.63858, 38.46611], [-122.63834, 38.46616], [-122.63805, 38.46624], [-122.6376, 38.46642], [-122.63681, 38.46685], [-122.63661, 38.46692], [-122.63643, 38.46696], [-122.63643, 38.46686], [-122.63665, 38.46672], [-122.63667, 38.46645], [-122.63634, 38.46638], [-122.6362, 38.46615], [-122.63593, 38.46594], [-122.63559, 38.46578], [-122.63463, 38.46566], [-122.63425, 38.46523], [-122.63429, 38.46511], [-122.63442, 38.46493], [-122.6345, 38.46476], [-122.63493, 38.46478], [-122.63594, 38.46493], [-122.63706, 38.465], [-122.63703, 38.46523], [-122.63786, 38.46587], [-122.63806, 38.46577], [-122.63854, 38.46578], [-122.63878, 38.4657], [-122.63925, 38.46571], [-122.63946, 38.46568], [-122.63954, 38.46598]]], [[[-122.64276, 38.46243], [-122.64271, 38.46272], [-122.64274, 38.46295], [-122.6428, 38.46311], [-122.64314, 38.46368], [-122.64318, 38.46381], [-122.64319, 38.46396], [-122.64315, 38.46412], [-122.64293, 38.46449], [-122.64276, 38.46484], [-122.64272, 38.46497], [-122.64266, 38.46521], [-122.6426, 38.46533], [-122.64254, 38.46542], [-122.64243, 38.46553], [-122.64231, 38.46561], [-122.64217, 38.46568], [-122.64201, 38.46573], [-122.64172, 38.46575], [-122.64129, 38.4657], [-122.64097, 38.46571], [-122.64075, 38.46574], [-122.63988, 38.46596], [-122.63981, 38.46598], [-122.63975, 38.46596], [-122.63965, 38.46563], [-122.63995, 38.46556], [-122.64013, 38.46537], [-122.64026, 38.46537], [-122.64042, 38.46524], [-122.64067, 38.46524], [-122.64089, 38.46516], [-122.64121, 38.46519], [-122.64139, 38.46506], [-122.64174, 38.46493], [-122.64199, 38.46474], [-122.64222, 38.46475], [-122.64235, 38.46468], [-122.64246, 38.46458], [-122.64245, 38.46452], [-122.64251, 38.46451], [-122.64257, 38.46239], [-122.64276, 38.46243]]], [[[-122.64526, 38.46328], [-122.64495, 38.46371], [-122.6449, 38.46375], [-122.64459, 38.4638], [-122.64454, 38.46376], [-122.64436, 38.46376], [-122.64434, 38.46378], [-122.64375, 38.46374], [-122.64361, 38.46405], [-122.64352, 38.46402], [-122.64352, 38.46382], [-122.64349, 38.46368], [-122.64344, 38.46355], [-122.64335, 38.4634], [-122.64376, 38.46324], [-122.64409, 38.46328], [-122.64435, 38.46334], [-122.64439, 38.463], [-122.64526, 38.46328]]]]} | Open Access 1 | Skyhawk Parks | 25535 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 20.009 | Skyhawk Parks | ||
7567 | 7567 | 7566 | {"type": "Polygon", "coordinates": [[[-122.65695, 38.47237], [-122.65661, 38.47241], [-122.65663, 38.4726], [-122.65583, 38.47267], [-122.65577, 38.47231], [-122.65546, 38.47228], [-122.65536, 38.47187], [-122.65566, 38.47179], [-122.65568, 38.47108], [-122.6564, 38.47113], [-122.65656, 38.47214], [-122.65693, 38.47223], [-122.65695, 38.47237]]]} | Open Access 1 | Oak Lake Green Park | 22985 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 3.471 | Oak Lake Green Park | ||
10222 | 10222 | 10221 | {"type": "Polygon", "coordinates": [[[-122.66242, 38.47114], [-122.66213, 38.47116], [-122.66213, 38.47141], [-122.66207, 38.47141], [-122.66205, 38.47119], [-122.66201, 38.47116], [-122.66181, 38.47119], [-122.66165, 38.47124], [-122.66158, 38.47128], [-122.66148, 38.47136], [-122.66139, 38.47148], [-122.66134, 38.47158], [-122.66138, 38.47161], [-122.66165, 38.47167], [-122.66163, 38.47172], [-122.66121, 38.47167], [-122.66055, 38.47169], [-122.66082, 38.47198], [-122.66076, 38.47205], [-122.66041, 38.472], [-122.6607, 38.47278], [-122.66079, 38.47294], [-122.66069, 38.47298], [-122.66028, 38.47227], [-122.66019, 38.47203], [-122.66005, 38.47195], [-122.65984, 38.4719], [-122.65972, 38.47189], [-122.65961, 38.47193], [-122.65961, 38.47196], [-122.65973, 38.47217], [-122.65968, 38.47221], [-122.65941, 38.47206], [-122.6593, 38.47218], [-122.6593, 38.47224], [-122.65895, 38.47225], [-122.65893, 38.47227], [-122.65897, 38.47249], [-122.65891, 38.47252], [-122.65871, 38.47234], [-122.65847, 38.47254], [-122.65823, 38.47252], [-122.65819, 38.47273], [-122.65811, 38.47274], [-122.65799, 38.47254], [-122.65781, 38.4726], [-122.65772, 38.47271], [-122.6577, 38.47289], [-122.65823, 38.47383], [-122.65798, 38.47392], [-122.65784, 38.47368], [-122.65768, 38.47373], [-122.65754, 38.47274], [-122.65752, 38.47272], [-122.65748, 38.47249], [-122.65713, 38.47243], [-122.65711, 38.4723], [-122.65747, 38.47227], [-122.65765, 38.47233], [-122.65833, 38.47224], [-122.65853, 38.47206], [-122.65851, 38.4719], [-122.65872, 38.47188], [-122.6587, 38.47167], [-122.65881, 38.47168], [-122.6589, 38.47164], [-122.65894, 38.47156], [-122.65892, 38.47146], [-122.66105, 38.47127], [-122.66098, 38.47103], [-122.66125, 38.4708], [-122.66134, 38.47078], [-122.66153, 38.47076], [-122.66159, 38.4708], [-122.6616, 38.47083], [-122.66166, 38.47084], [-122.66172, 38.47081], [-122.66174, 38.47076], [-122.66234, 38.47095], [-122.66242, 38.47114]]]} | Open Access 1 | Tanglewood Park | 26180 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 7.794 | Tanglewood Park | ||
10021 | 10021 | 10020 | {"type": "Polygon", "coordinates": [[[-122.66325, 38.43481], [-122.66313, 38.43483], [-122.66294, 38.43482], [-122.66279, 38.43441], [-122.66268, 38.43428], [-122.66239, 38.43408], [-122.66209, 38.43431], [-122.66145, 38.43386], [-122.66126, 38.43385], [-122.66119, 38.4338], [-122.66084, 38.43381], [-122.66107, 38.4331], [-122.66125, 38.43277], [-122.66103, 38.43254], [-122.66094, 38.43234], [-122.66074, 38.43231], [-122.66046, 38.43221], [-122.66054, 38.43203], [-122.66093, 38.43212], [-122.66114, 38.4322], [-122.66121, 38.43233], [-122.66144, 38.43253], [-122.66168, 38.4325], [-122.66175, 38.43255], [-122.66164, 38.43256], [-122.66163, 38.43258], [-122.66183, 38.43275], [-122.66187, 38.43282], [-122.66187, 38.43315], [-122.66195, 38.43331], [-122.66209, 38.43341], [-122.6624, 38.43352], [-122.66254, 38.43363], [-122.66264, 38.43378], [-122.66295, 38.43402], [-122.66313, 38.43412], [-122.66315, 38.43419], [-122.6632, 38.43424], [-122.66317, 38.43453], [-122.66325, 38.43481]]]} | Open Access 1 | Strawberry Park | 25916 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 5.37 | Strawberry Park | ||
4473 | 4473 | 4472 | {"type": "Polygon", "coordinates": [[[-122.66368, 38.41889], [-122.66292, 38.41936], [-122.66115, 38.4199], [-122.65968, 38.41989], [-122.65968, 38.41787], [-122.65839, 38.41785], [-122.65799, 38.41691], [-122.6615, 38.41693], [-122.66368, 38.41889]]]} | Open Access 1 | Galvin Park | 19183 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 24.146 | Galvin Park | ||
8712 | 8712 | 8711 | {"type": "Polygon", "coordinates": [[[-122.66503, 38.48047], [-122.66507, 38.48062], [-122.66507, 38.48074], [-122.66505, 38.48087], [-122.66498, 38.48107], [-122.66496, 38.48119], [-122.66497, 38.48269], [-122.66322, 38.483], [-122.66293, 38.48249], [-122.66263, 38.48192], [-122.66259, 38.48191], [-122.66235, 38.48147], [-122.66342, 38.48127], [-122.66343, 38.48125], [-122.66201, 38.47875], [-122.6625, 38.47876], [-122.66282, 38.47874], [-122.66322, 38.4787], [-122.66362, 38.47862], [-122.6647, 38.48057], [-122.66503, 38.48047]]]} | Open Access 1 | Rincon Valley Community Park | 24371 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 18.755 | Rincon Valley Community Park | ||
3265 | 3265 | 3264 | {"type": "Polygon", "coordinates": [[[-122.66692, 38.43193], [-122.66671, 38.43182], [-122.66654, 38.43177], [-122.66633, 38.43194], [-122.66629, 38.43208], [-122.66588, 38.43202], [-122.66587, 38.432], [-122.66551, 38.43187], [-122.66457, 38.43138], [-122.66443, 38.43128], [-122.66431, 38.43116], [-122.66448, 38.43108], [-122.66447, 38.43084], [-122.66505, 38.43084], [-122.66506, 38.43086], [-122.66692, 38.43176], [-122.66692, 38.43193]]]} | Open Access 1 | Creekside Park | 17780 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 3.52 | Creekside Park | ||
10440 | 10440 | 10439 | {"type": "Polygon", "coordinates": [[[-122.66792, 38.46122], [-122.66782, 38.46129], [-122.66773, 38.46132], [-122.66731, 38.46157], [-122.66726, 38.46163], [-122.66714, 38.4613], [-122.66776, 38.46098], [-122.66792, 38.46122]]]} | Open Access 1 | Trailhead Park | 26509 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 0.533 | Trailhead Park | ||
8112 | 8112 | 8111 | {"type": "Polygon", "coordinates": [[[-122.66983, 38.44622], [-122.66942, 38.44646], [-122.66856, 38.44559], [-122.66887, 38.44549], [-122.66888, 38.44548], [-122.66836, 38.44493], [-122.66851, 38.44486], [-122.66983, 38.44622]]]} | Open Access 1 | Peter Springs Park | 23629 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1.6 | Peter Springs Park | ||
5274 | 5274 | 5273 | {"type": "Polygon", "coordinates": [[[-122.6718, 38.45488], [-122.6715, 38.45491], [-122.67052, 38.45514], [-122.66999, 38.45567], [-122.66937, 38.45577], [-122.664, 38.4564], [-122.66196, 38.4572], [-122.66201, 38.45754], [-122.66181, 38.45757], [-122.66059, 38.45805], [-122.66056, 38.45805], [-122.65974, 38.45828], [-122.65973, 38.45625], [-122.6609, 38.4552], [-122.6609, 38.45518], [-122.66088, 38.45517], [-122.66193, 38.4541], [-122.66192, 38.45408], [-122.66197, 38.45406], [-122.66737, 38.45035], [-122.66768, 38.44951], [-122.66805, 38.44909], [-122.6682, 38.44925], [-122.66856, 38.44969], [-122.66934, 38.45101], [-122.6718, 38.45488]]]} | Open Access 1 | Howarth Park | 20122 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 111.55 | Howarth Park | 1970 | |
6753 | 6753 | 6752 | {"type": "Polygon", "coordinates": [[[-122.67198, 38.43672], [-122.67163, 38.43671], [-122.67165, 38.43646], [-122.67173, 38.43598], [-122.67152, 38.43563], [-122.67188, 38.43551], [-122.67205, 38.4358], [-122.67208, 38.43593], [-122.67208, 38.43604], [-122.67204, 38.43622], [-122.67198, 38.43672]]]} | Open Access 1 | Matanzas Park | 21948 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1.031 | Matanzas Park | ||
6960 | 6960 | 6959 | {"type": "Polygon", "coordinates": [[[-122.67335, 38.42801], [-122.67288, 38.42828], [-122.67285, 38.42825], [-122.67287, 38.42816], [-122.67285, 38.42811], [-122.67279, 38.42807], [-122.67269, 38.42808], [-122.67264, 38.42812], [-122.67263, 38.42817], [-122.67267, 38.42825], [-122.67275, 38.42834], [-122.67152, 38.42905], [-122.6715, 38.42775], [-122.67151, 38.42747], [-122.6724, 38.42746], [-122.67242, 38.42735], [-122.67303, 38.42735], [-122.67304, 38.42768], [-122.67335, 38.42801]]]} | Open Access 1 | Mesquite Park | 22186 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 4.468 | Mesquite Park | ||
8714 | 8714 | 8713 | {"type": "Polygon", "coordinates": [[[-122.67494, 38.46701], [-122.67483, 38.46705], [-122.67479, 38.46712], [-122.6748, 38.4672], [-122.67489, 38.46727], [-122.67491, 38.46731], [-122.6741, 38.46748], [-122.67319, 38.4677], [-122.67352, 38.46749], [-122.67365, 38.46738], [-122.67374, 38.46724], [-122.67378, 38.46711], [-122.67402, 38.46693], [-122.67454, 38.46643], [-122.67469, 38.46656], [-122.67479, 38.46669], [-122.6749, 38.46689], [-122.67494, 38.46701]]]} | Open Access 1 | Rinconada Park | 24373 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 2.022 | Rinconada Park | ||
4246 | 4246 | 4245 | {"type": "Polygon", "coordinates": [[[-122.67816, 38.4529], [-122.67762, 38.45386], [-122.67755, 38.45412], [-122.67671, 38.4539], [-122.67688, 38.45341], [-122.67693, 38.45318], [-122.6772, 38.45246], [-122.67816, 38.4529]]]} | Open Access 1 | Flat Rock Park | 18940 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 3.264 | Flat Rock Park | ||
10577 | 10577 | 10576 | {"type": "Polygon", "coordinates": [[[-122.68098, 38.48165], [-122.68094, 38.48213], [-122.67952, 38.48214], [-122.67946, 38.48203], [-122.67932, 38.48196], [-122.67915, 38.48201], [-122.67893, 38.48202], [-122.67864, 38.48182], [-122.67844, 38.48158], [-122.678, 38.48132], [-122.67824, 38.48072], [-122.67829, 38.48031], [-122.67817, 38.47986], [-122.67832, 38.47949], [-122.67847, 38.4793], [-122.67921, 38.48004], [-122.6801, 38.48011], [-122.67998, 38.48159], [-122.68098, 38.48165]]]} | Open Access 1 | Upper Brush Creek Park | 26726 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 10.444 | Upper Brush Creek Park | ||
2287 | 2287 | 2286 | {"type": "Polygon", "coordinates": [[[-122.68198, 38.46239], [-122.68133, 38.4633], [-122.68079, 38.46269], [-122.68076, 38.46258], [-122.68051, 38.46228], [-122.68082, 38.46212], [-122.68198, 38.46239]]]} | Open Access 1 | Brush Creek Park | 16453 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 2.058 | Brush Creek Park | ||
8711 | 8711 | 8710 | {"type": "Polygon", "coordinates": [[[-122.69381, 38.48999], [-122.69379, 38.49004], [-122.69375, 38.49006], [-122.69343, 38.49011], [-122.69317, 38.49012], [-122.69239, 38.49008], [-122.69236, 38.49005], [-122.69238, 38.4897], [-122.69237, 38.48951], [-122.69231, 38.48939], [-122.69218, 38.48923], [-122.69204, 38.48914], [-122.69189, 38.48908], [-122.69146, 38.489], [-122.69126, 38.48894], [-122.69096, 38.48877], [-122.69078, 38.48865], [-122.69125, 38.48827], [-122.69152, 38.48843], [-122.69216, 38.48858], [-122.69245, 38.48857], [-122.69273, 38.48852], [-122.69314, 38.48835], [-122.69317, 38.48824], [-122.69296, 38.48806], [-122.69306, 38.48799], [-122.69316, 38.48795], [-122.69332, 38.48792], [-122.69337, 38.48793], [-122.6934, 38.48797], [-122.69343, 38.48816], [-122.6935, 38.48892], [-122.69361, 38.48938], [-122.69369, 38.48967], [-122.69381, 38.48999]]]} | Open Access 1 | Rincon Ridge Park | 24370 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 7.265 | Rincon Ridge Park | ||
1046 | 1046 | 1045 | {"type": "Polygon", "coordinates": [[[-122.69406, 38.42745], [-122.69385, 38.42747], [-122.69367, 38.42746], [-122.69323, 38.42733], [-122.69295, 38.42728], [-122.69276, 38.42728], [-122.69252, 38.42729], [-122.6925, 38.42728], [-122.69245, 38.42715], [-122.69226, 38.4268], [-122.6925, 38.4267], [-122.69262, 38.42662], [-122.69273, 38.42651], [-122.6928, 38.42637], [-122.69306, 38.42644], [-122.69312, 38.42649], [-122.69314, 38.42658], [-122.69322, 38.42669], [-122.69329, 38.42675], [-122.69343, 38.42681], [-122.69351, 38.42687], [-122.69368, 38.42704], [-122.69378, 38.42716], [-122.69384, 38.42728], [-122.694, 38.42736], [-122.69406, 38.42745]]]} | Open Access 1 | Dauenhauer Park | https://srcity.org/Facilities/Facility/Details/Dauenhauer-Park-59 | 32822 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 2.291 | Dauenhauer Park | |
2990 | 2990 | 2989 | {"type": "Polygon", "coordinates": [[[-122.69702, 38.44707], [-122.69667, 38.44712], [-122.69664, 38.44728], [-122.69643, 38.44733], [-122.69631, 38.4472], [-122.69599, 38.44727], [-122.69594, 38.44715], [-122.69636, 38.44706], [-122.69699, 38.44694], [-122.69702, 38.44707]]]} | Open Access 1 | Eastside Park | 18400 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 0.421 | Eastside Park | ||
3697 | 3697 | 3696 | {"type": "Polygon", "coordinates": [[[-122.69985, 38.43896], [-122.69973, 38.43922], [-122.69957, 38.43929], [-122.69935, 38.43966], [-122.69914, 38.43967], [-122.69902, 38.43988], [-122.69885, 38.43999], [-122.69873, 38.43998], [-122.69789, 38.44012], [-122.69763, 38.44002], [-122.69723, 38.44004], [-122.69707, 38.44015], [-122.69663, 38.44035], [-122.69639, 38.44033], [-122.69625, 38.44048], [-122.69587, 38.44045], [-122.69574, 38.44049], [-122.69535, 38.44019], [-122.69525, 38.44048], [-122.69476, 38.44073], [-122.69456, 38.44078], [-122.6943, 38.44094], [-122.69388, 38.44108], [-122.69412, 38.4409], [-122.69326, 38.44], [-122.69282, 38.43949], [-122.69287, 38.43943], [-122.69297, 38.43927], [-122.69313, 38.43917], [-122.69333, 38.43912], [-122.69332, 38.43909], [-122.69351, 38.43888], [-122.69374, 38.43867], [-122.69372, 38.43861], [-122.6941, 38.43834], [-122.69447, 38.43846], [-122.69494, 38.43873], [-122.69546, 38.43892], [-122.69586, 38.43913], [-122.69611, 38.43929], [-122.6965, 38.43937], [-122.69668, 38.43929], [-122.6971, 38.43881], [-122.69765, 38.43904], [-122.69809, 38.43902], [-122.69859, 38.43876], [-122.69924, 38.43896], [-122.69985, 38.43896]]]} | Open Access 1 | Doyle Park | 18260 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 21.6 | Doyle 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]);