superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
56 rows where MNG_AGENCY = 569 sorted by map
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14185 | 14185 | 14184 | {"type": "MultiPolygon", "coordinates": [[[[-121.20025, 38.80451], [-121.20011, 38.80463], [-121.19978, 38.80457], [-121.19988, 38.80436], [-121.19994, 38.80434], [-121.19999, 38.80435], [-121.20025, 38.80451]]], [[[-121.20098, 38.80218], [-121.20095, 38.80387], [-121.20031, 38.80445], [-121.20003, 38.80428], [-121.20002, 38.80423], [-121.2001, 38.80415], [-121.20041, 38.80395], [-121.20055, 38.80383], [-121.20068, 38.80368], [-121.20079, 38.80349], [-121.20086, 38.8033], [-121.2009, 38.8031], [-121.20093, 38.80218], [-121.20098, 38.80218]]]]} | Open Access 1 | Christine Anderson Park | 33734 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1.247 | Christine Anderson Park | 2018 | |
13739 | 13739 | 13738 | {"type": "MultiPolygon", "coordinates": [[[[-121.24123, 38.78667], [-121.24048, 38.78772], [-121.23964, 38.78911], [-121.23956, 38.78942], [-121.2394, 38.78974], [-121.23896, 38.79039], [-121.23813, 38.7915], [-121.23812, 38.79153], [-121.23792, 38.79183], [-121.23792, 38.79207], [-121.23799, 38.79208], [-121.23838, 38.79222], [-121.23754, 38.79338], [-121.23695, 38.79369], [-121.23684, 38.79379], [-121.23661, 38.79371], [-121.23635, 38.79405], [-121.23618, 38.79417], [-121.23576, 38.79403], [-121.23625, 38.79329], [-121.24039, 38.78759], [-121.24109, 38.78655], [-121.24123, 38.78667]]], [[[-121.23865, 38.7919], [-121.23859, 38.79198], [-121.23817, 38.79179], [-121.23817, 38.79168], [-121.23865, 38.7919]]]]} | Open Access 1 | Peter Hill Heritage Park | http://www.rocklin.ca.us/location/peter-hill-heritage-park | 31246 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 11.208 | Peter Hill Heritage Park | |
15445 | 15445 | 15444 | {"type": "MultiPolygon", "coordinates": [[[[-121.24935, 38.79757], [-121.24887, 38.7976], [-121.24887, 38.79736], [-121.24862, 38.79729], [-121.24859, 38.79701], [-121.24788, 38.79639], [-121.24756, 38.79629], [-121.24638, 38.79603], [-121.24591, 38.79611], [-121.24558, 38.79621], [-121.24526, 38.79664], [-121.24512, 38.79694], [-121.24485, 38.79709], [-121.24378, 38.7975], [-121.24095, 38.79876], [-121.24094, 38.79878], [-121.24112, 38.79902], [-121.24073, 38.79922], [-121.24054, 38.79896], [-121.23974, 38.79931], [-121.23958, 38.79911], [-121.23981, 38.7985], [-121.23945, 38.79817], [-121.2406, 38.79786], [-121.24374, 38.79649], [-121.2443, 38.79582], [-121.24429, 38.7958], [-121.2442, 38.7958], [-121.24484, 38.79531], [-121.24604, 38.79445], [-121.24636, 38.79473], [-121.24652, 38.79518], [-121.24729, 38.79541], [-121.2479, 38.79543], [-121.24805, 38.79534], [-121.24878, 38.79605], [-121.24909, 38.79654], [-121.24928, 38.79708], [-121.24934, 38.79735], [-121.24935, 38.79757]]], [[[-121.25255, 38.7998], [-121.25224, 38.80002], [-121.25251, 38.80029], [-121.25098, 38.80127], [-121.24815, 38.80404], [-121.24782, 38.80431], [-121.24743, 38.80455], [-121.24494, 38.8056], [-121.24452, 38.80574], [-121.24408, 38.80574], [-121.24396, 38.80605], [-121.24361, 38.80596], [-121.2433, 38.80582], [-121.24304, 38.80562], [-121.24284, 38.80538], [-121.24271, 38.80511], [-121.24237, 38.80408], [-121.24228, 38.80386], [-121.24216, 38.80366], [-121.242, 38.80347], [-121.24184, 38.80331], [-121.24168, 38.80319], [-121.24193, 38.80295], [-121.24086, 38.80233], [-121.24045, 38.80189], [-121.24021, 38.80132], [-121.24015, 38.8003], [-121.24006, 38.80006], [-121.24074, 38.79973], [-121.24057, 38.79946], [-121.24109, 38.79923], [-121.24126, 38.79947], [-121.24142, 38.79983], [-121.24149, 38.80031], [-121.24174, 38.80044], [-121.24235, 38.80036], [-121.24253, 38.80015], [-121.24231, 38.79946], [-121.2421, 38.79913], [-121.24418, 38.79821], [-121.24535, 38.79776], [-121.24594, 38.79761], [-121.24654, 38.79765], [-121.2474, 38.79783], [-121.24743, 38.79896], [-121.24579, 38.79935], [-121.24484, 38.79916], [-121.24397, 38.7995], [-121.244, 38.80063], [-121.24357, 38.80114], [-121.24342, 38.8019], [-121.24445, 38.80209], [-121.24565, 38.80187], [-121.24573, 38.80237], [-121.24541, 38.80249], [-121.24543, 38.80278], [-121.24583, 38.80285], [-121.2465, 38.80259], [-121.24734, 38.80186], [-121.24764, 38.80162], [-121.24906, 38.80072], [-121.24952, 38.80026], [-121.25005, 38.79988], [-121.2504, 38.79967], [-121.25064, 38.79948], [-121.25112, 38.799], [-121.25148, 38.79878], [-121.25255, 38.7998]]], [[[-121.26336, 38.7949], [-121.26216, 38.79573], [-121.26081, 38.79691], [-121.25822, 38.79824], [-121.25393, 38.79935], [-121.25344, 38.79967], [-121.25314, 38.79939], [-121.25282, 38.7996], [-121.25177, 38.7986], [-121.2521, 38.7984], [-121.25393, 38.79763], [-121.25471, 38.79763], [-121.25541, 38.7972], [-121.25571, 38.79678], [-121.25665, 38.79627], [-121.25694, 38.7964], [-121.25724, 38.79647], [-121.25756, 38.79649], [-121.25786, 38.79644], [-121.25816, 38.79633], [-121.25931, 38.79573], [-121.25953, 38.79557], [-121.26037, 38.79477], [-121.26072, 38.7945], [-121.26198, 38.79366], [-121.26336, 38.7949]]]]} | Open Access 1 | Sunset Whitney Recreation Area | https://www.rocklin.ca.us/news/west-trails-sunset-whitney-rec-area-now-open | 33741 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 178.772 | Sunset Whitney Rec. Area | 2018 |
9372 | 9372 | 9371 | {"type": "Polygon", "coordinates": [[[-121.21328, 38.78029], [-121.21327, 38.78079], [-121.21324, 38.78083], [-121.21206, 38.78087], [-121.21202, 38.78086], [-121.212, 38.78083], [-121.21198, 38.78064], [-121.212, 38.78052], [-121.21203, 38.78041], [-121.2121, 38.7803], [-121.21328, 38.78029]]]} | Open Access 1 | Sasaki Park | 25163 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1.669 | Sasaki Park | ||
7127 | 7127 | 7126 | {"type": "Polygon", "coordinates": [[[-121.21492, 38.78493], [-121.21492, 38.78686], [-121.2123, 38.78695], [-121.21229, 38.78497], [-121.21492, 38.78493]]]} | Open Access 1 | Monte Verde Park | 22393 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 12.254 | Monte Verde Park | ||
7512 | 7512 | 7511 | {"type": "Polygon", "coordinates": [[[-121.22313, 38.77883], [-121.22314, 38.77916], [-121.22309, 38.77938], [-121.22302, 38.77959], [-121.22281, 38.77996], [-121.22272, 38.78016], [-121.22267, 38.78018], [-121.22244, 38.78016], [-121.22213, 38.78017], [-121.22192, 38.78021], [-121.22151, 38.78033], [-121.22134, 38.78035], [-121.22129, 38.78033], [-121.22128, 38.78029], [-121.2213, 38.78013], [-121.22146, 38.77976], [-121.22149, 38.77952], [-121.22147, 38.77931], [-121.22144, 38.77917], [-121.22133, 38.77897], [-121.22122, 38.77883], [-121.22313, 38.77883]]]} | Open Access 1 | Corral-Alva Park | 33737 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 5.279 | Corral-Alva Park | ||
14186 | 14186 | 14185 | {"type": "Polygon", "coordinates": [[[-121.22404, 38.79398], [-121.2241, 38.79461], [-121.22386, 38.79562], [-121.22379, 38.79568], [-121.22352, 38.79566], [-121.22328, 38.79577], [-121.22288, 38.79523], [-121.22277, 38.79498], [-121.22272, 38.79473], [-121.22273, 38.79397], [-121.22404, 38.79398]]]} | Open Access 1 | Sierra Meadows Park | 33739 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 4.822 | Sierra Meadows Park | ||
4528 | 4528 | 4527 | {"type": "Polygon", "coordinates": [[[-121.22788, 38.80669], [-121.22749, 38.80797], [-121.22717, 38.80791], [-121.22719, 38.80786], [-121.22718, 38.8078], [-121.22715, 38.80777], [-121.22709, 38.80774], [-121.22698, 38.80775], [-121.22687, 38.80783], [-121.22679, 38.80782], [-121.22678, 38.80778], [-121.22678, 38.80717], [-121.2267, 38.80681], [-121.2267, 38.80668], [-121.22788, 38.80669]]]} | Open Access 1 | Gayaldo Park | 19244 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 2.626 | Gayaldo Park | ||
8861 | 8861 | 8860 | {"type": "Polygon", "coordinates": [[[-121.23015, 38.83665], [-121.22932, 38.83664], [-121.2292, 38.8355], [-121.22932, 38.8355], [-121.22944, 38.83578], [-121.22963, 38.8361], [-121.22986, 38.83639], [-121.23015, 38.83665]]]} | Open Access 1 | Rocklin holding 5 | 24528 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1.085 | Rocklin holding 5 | ||
5539 | 5539 | 5538 | {"type": "Polygon", "coordinates": [[[-121.23155, 38.77167], [-121.23143, 38.77234], [-121.23137, 38.77242], [-121.23108, 38.7723], [-121.23087, 38.77225], [-121.23066, 38.77222], [-121.23015, 38.77223], [-121.22978, 38.7723], [-121.22973, 38.77227], [-121.22965, 38.77205], [-121.22965, 38.77182], [-121.22971, 38.77162], [-121.22978, 38.7715], [-121.22999, 38.77123], [-121.23008, 38.77107], [-121.23027, 38.77115], [-121.23083, 38.77166], [-121.23155, 38.77167]]]} | Open Access 1 | Joe Hernandez Park | 20420 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 3.528 | Joe Hernandez Park | ||
2166 | 2166 | 2165 | {"type": "Polygon", "coordinates": [[[-121.23289, 38.83923], [-121.23166, 38.83923], [-121.23148, 38.83918], [-121.23116, 38.83917], [-121.22968, 38.83909], [-121.22968, 38.83892], [-121.22943, 38.83761], [-121.23047, 38.83762], [-121.2305, 38.83696], [-121.2312, 38.83751], [-121.23166, 38.83783], [-121.23216, 38.83813], [-121.23242, 38.83825], [-121.2327, 38.83836], [-121.23267, 38.83845], [-121.23268, 38.83854], [-121.23288, 38.83891], [-121.23289, 38.83923]]]} | Open Access 1 | Boulder Ridge Park | 16297 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 11.154 | Boulder Ridge Park | ||
6919 | 6919 | 6918 | {"type": "Polygon", "coordinates": [[[-121.23462, 38.78913], [-121.23412, 38.78977], [-121.23355, 38.78951], [-121.23407, 38.78888], [-121.23462, 38.78913]]]} | Open Access 1 | Memorial Park | 22130 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1.143 | Memorial Park | ||
13726 | 13726 | 13725 | {"type": "Polygon", "coordinates": [[[-121.23775, 38.78795], [-121.23712, 38.78886], [-121.23657, 38.78847], [-121.23348, 38.78851], [-121.23348, 38.78844], [-121.23346, 38.78838], [-121.23364, 38.78798], [-121.23355, 38.78794], [-121.23365, 38.78772], [-121.23368, 38.78756], [-121.23373, 38.78745], [-121.23377, 38.7874], [-121.23405, 38.78746], [-121.23416, 38.78746], [-121.23471, 38.78696], [-121.23518, 38.78708], [-121.23599, 38.78614], [-121.23685, 38.78652], [-121.23757, 38.78701], [-121.23711, 38.78772], [-121.23775, 38.78795]]]} | Open Access 1 | Quarry Park | http://www.rocklin.ca.us/quarry-park | 31242 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 15.681 | Quarry Park | |
8851 | 8851 | 8850 | {"type": "Polygon", "coordinates": [[[-121.23974, 38.82421], [-121.23937, 38.82442], [-121.23779, 38.82586], [-121.2375, 38.82602], [-121.2368, 38.82659], [-121.23489, 38.82856], [-121.23477, 38.82889], [-121.23305, 38.83123], [-121.23265, 38.83258], [-121.23247, 38.83254], [-121.23254, 38.83145], [-121.23391, 38.82914], [-121.23607, 38.82689], [-121.23606, 38.82687], [-121.23568, 38.82667], [-121.23601, 38.82647], [-121.23626, 38.82593], [-121.2368, 38.82579], [-121.23684, 38.82608], [-121.23686, 38.82609], [-121.23924, 38.82425], [-121.23974, 38.82421]]]} | Open Access 1 | Rocklin holding 11 | 24518 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 10.487 | Rocklin holding 11 | ||
14438 | 14438 | 14437 | {"type": "Polygon", "coordinates": [[[-121.23986, 38.78689], [-121.23937, 38.78755], [-121.23887, 38.78744], [-121.23924, 38.78697], [-121.23913, 38.7869], [-121.23934, 38.78663], [-121.23986, 38.78689]]]} | Open Access 1 | Deer Creek Park | 33729 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1.052 | Deer Creek Park | ||
14441 | 14441 | 14440 | {"type": "Polygon", "coordinates": [[[-121.24285, 38.7747], [-121.24256, 38.77498], [-121.24217, 38.77545], [-121.242, 38.77559], [-121.24189, 38.77564], [-121.24183, 38.77573], [-121.24146, 38.77569], [-121.24119, 38.77586], [-121.24113, 38.77583], [-121.24105, 38.77582], [-121.24102, 38.77557], [-121.24076, 38.77531], [-121.24238, 38.77431], [-121.24285, 38.7747]]]} | Open Access 1 | Woodside Park | 33744 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 3.564 | Woodside Park | ||
3035 | 3035 | 3034 | {"type": "Polygon", "coordinates": [[[-121.24331, 38.80602], [-121.2432, 38.80631], [-121.24303, 38.80634], [-121.24295, 38.80653], [-121.24276, 38.80664], [-121.24263, 38.80694], [-121.2429, 38.80719], [-121.24268, 38.80733], [-121.24243, 38.8071], [-121.24221, 38.80711], [-121.24204, 38.80721], [-121.24158, 38.80677], [-121.2422, 38.80622], [-121.24189, 38.80598], [-121.24214, 38.8058], [-121.24244, 38.80565], [-121.24265, 38.80556], [-121.24271, 38.80556], [-121.24287, 38.80573], [-121.24303, 38.80586], [-121.24331, 38.80602]]]} | Open Access 1 | Clover Valley Park | 17439 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 3.73 | Clover Valley Park | ||
3013 | 3013 | 3012 | {"type": "Polygon", "coordinates": [[[-121.24385, 38.81066], [-121.24348, 38.81184], [-121.24341, 38.81205], [-121.2433, 38.81226], [-121.24299, 38.81279], [-121.24256, 38.81348], [-121.24111, 38.81281], [-121.2418, 38.81213], [-121.24265, 38.81212], [-121.24265, 38.81049], [-121.24303, 38.81049], [-121.24385, 38.81066]]]} | Open Access 1 | Clarke Dominguez Park | 17390 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 8.034 | Clarke Dominguez Park | ||
14562 | 14562 | 14561 | {"type": "Polygon", "coordinates": [[[-121.24386, 38.82628], [-121.24338, 38.82653], [-121.24316, 38.82678], [-121.24269, 38.82757], [-121.2426, 38.82819], [-121.24261, 38.82837], [-121.24276, 38.8288], [-121.24279, 38.82901], [-121.24259, 38.82921], [-121.24234, 38.82955], [-121.24214, 38.82972], [-121.24193, 38.82984], [-121.24176, 38.8299], [-121.2412, 38.83005], [-121.24087, 38.83021], [-121.24074, 38.8303], [-121.24061, 38.83041], [-121.24031, 38.83079], [-121.24, 38.83066], [-121.23921, 38.8312], [-121.23844, 38.83177], [-121.23802, 38.83236], [-121.2377, 38.83295], [-121.23717, 38.83334], [-121.23708, 38.83352], [-121.23724, 38.83378], [-121.237, 38.83387], [-121.23689, 38.83389], [-121.23676, 38.83388], [-121.2366, 38.83384], [-121.23616, 38.83363], [-121.23625, 38.83326], [-121.2365, 38.83304], [-121.23661, 38.83289], [-121.23668, 38.83256], [-121.23696, 38.83233], [-121.23696, 38.83231], [-121.23655, 38.83225], [-121.23609, 38.83253], [-121.23603, 38.83253], [-121.23596, 38.83255], [-121.2359, 38.83231], [-121.23563, 38.83231], [-121.23541, 38.8322], [-121.23533, 38.8322], [-121.23527, 38.83223], [-121.23521, 38.83228], [-121.23511, 38.83249], [-121.23495, 38.8326], [-121.23491, 38.83267], [-121.23488, 38.83279], [-121.23481, 38.83289], [-121.23455, 38.83364], [-121.23458, 38.83372], [-121.23484, 38.83381], [-121.23462, 38.83412], [-121.2345, 38.83421], [-121.23325, 38.83502], [-121.23312, 38.83505], [-121.23298, 38.83504], [-121.23286, 38.835], [-121.23274, 38.8349], [-121.2327, 38.83482], [-121.23269, 38.83473], [-121.2327, 38.83467], [-121.23275, 38.83459], [-121.23316, 38.83423], [-121.23331, 38.83406], [-121.23336, 38.83407], [-121.2334, 38.83399], [-121.23347, 38.83383], [-121.23349, 38.83371], [-121.23345, 38.83369], [-121.23346, 38.83356], [-121.2335, 38.83344], [-121.23355, 38.83336], [-121.23377, 38.83337], [-121.23403, 38.83351], [-121.2341, 38.83345], [-121.23416, 38.83309], [-121.23391, 38.83279], [-121.23382, 38.83239], [-121.23383, 38.8323], [-121.23432, 38.83137], [-121.23448, 38.83114], [-121.23552, 38.83011], [-121.23588, 38.83006], [-121.23637, 38.82985], [-121.23661, 38.82979], [-121.23686, 38.82976], [-121.23739, 38.82976], [-121.2377, 38.82974], [-121.23799, 38.82966], [-121.23827, 38.82953], [-121.23886, 38.82911], [-121.23874, 38.82898], [-121.23878, 38.82893], [-121.2387, 38.82884], [-121.23864, 38.82873], [-121.23857, 38.82865], [-121.23867, 38.82856], [-121.23851, 38.82842], [-121.23847, 38.82836], [-121.23747, 38.82747], [-121.23738, 38.82745], [-121.23745, 38.82736], [-121.23721, 38.82713], [-121.23788, 38.82657], [-121.23813, 38.82644], [-121.23824, 38.82636], [-121.23982, 38.82494], [-121.24003, 38.82478], [-121.2403, 38.82463], [-121.2405, 38.82453], [-121.24081, 38.82441], [-121.24087, 38.82451], [-121.2408, 38.82454], [-121.24053, 38.82512], [-121.24106, 38.82544], [-121.24183, 38.82536], [-121.24209, 38.82551], [-121.24235, 38.82551], [-121.24333, 38.82605], [-121.24361, 38.82597], [-121.24386, 38.82628]]]} | Restricted Access 2 | City of Rocklin Golf Courses | 33073 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 89.96 | City of Rocklin GC | ||
8852 | 8852 | 8851 | {"type": "Polygon", "coordinates": [[[-121.24491, 38.81284], [-121.24339, 38.81598], [-121.24115, 38.81686], [-121.24144, 38.81658], [-121.24264, 38.81567], [-121.2435, 38.81429], [-121.24363, 38.81433], [-121.24393, 38.81353], [-121.24396, 38.81278], [-121.24348, 38.81269], [-121.24337, 38.81273], [-121.24361, 38.81234], [-121.24491, 38.81284]]]} | Open Access 1 | Rocklin holding 12 | 24519 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 7.89 | Rocklin holding 12 |
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]);