units_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

15 rows where DES_TP = 87, MNG_AGENCY = 280 and MNG_AG_LEV = 1 sorted by id

This data as json, copyable, CSV (advanced)

Suggested facets: UNIT_NAME, SUID_NMA, COUNTY, LABEL_NAME

MNG_AG_TYP 1

MNG_AGENCY 1

  • Other Federal · 15 ✖

DES_TP 1

  • Federal Other or Unknown · 15 ✖
Link rowid id ▼ map ACCESS_TYP UNIT_ID UNIT_NAME SUID_NMA AGNCY_ID AGNCY_NAME AGNCY_LEV AGNCY_TYP AGNCY_WEB LAYER MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP PARK_URL COUNTY ACRES LABEL_NAME YR_EST DES_TP GAP_STS
947 947 946 {"type": "MultiPolygon", "coordinates": [[[[-118.30927, 33.77858], [-118.30758, 33.77901], [-118.3066, 33.7792], [-118.30555, 33.77935], [-118.30359, 33.77951], [-118.30379, 33.77922], [-118.30356, 33.7791], [-118.30373, 33.77882], [-118.30371, 33.77863], [-118.30258, 33.77836], [-118.30228, 33.77858], [-118.30213, 33.77866], [-118.30196, 33.77871], [-118.30179, 33.77874], [-118.30145, 33.77873], [-118.30114, 33.77863], [-118.30124, 33.77834], [-118.3011, 33.7783], [-118.30143, 33.77756], [-118.3013, 33.77738], [-118.30092, 33.7772], [-118.30093, 33.77658], [-118.30075, 33.77653], [-118.30073, 33.77656], [-118.3002, 33.77642], [-118.30015, 33.77669], [-118.30004, 33.7768], [-118.29989, 33.77685], [-118.29945, 33.77691], [-118.29942, 33.77696], [-118.29941, 33.77494], [-118.296, 33.77494], [-118.2959, 33.77466], [-118.29444, 33.77083], [-118.29424, 33.77018], [-118.29413, 33.76975], [-118.29404, 33.76934], [-118.29402, 33.76908], [-118.29401, 33.76865], [-118.29405, 33.76753], [-118.29404, 33.76724], [-118.294, 33.76667], [-118.29394, 33.76629], [-118.29718, 33.76629], [-118.29719, 33.76641], [-118.29801, 33.76687], [-118.29825, 33.76705], [-118.29891, 33.76743], [-118.29912, 33.76759], [-118.29932, 33.7677], [-118.30005, 33.76787], [-118.30059, 33.76797], [-118.30179, 33.76827], [-118.30185, 33.76825], [-118.30188, 33.76819], [-118.30407, 33.76881], [-118.30522, 33.76959], [-118.30699, 33.77065], [-118.30701, 33.77105], [-118.30741, 33.77167], [-118.30772, 33.77175], [-118.30895, 33.77159], [-118.30875, 33.77225], [-118.30863, 33.77282], [-118.30859, 33.77321], [-118.3086, 33.77377], [-118.30863, 33.77407], [-118.30927, 33.77858]]], [[[-118.30012, 33.77981], [-118.29971, 33.77989], [-118.29931, 33.78001], [-118.29894, 33.78016], [-118.29858, 33.78034], [-118.29825, 33.78056], [-118.29796, 33.78081], [-118.29759, 33.78122], [-118.2974, 33.78122], [-118.29726, 33.78129], [-118.29689, 33.78086], [-118.29719, 33.7805], [-118.29739, 33.7803], [-118.2976, 33.78013], [-118.2979, 33.77991], [-118.29838, 33.77962], [-118.29904, 33.77935], [-118.29933, 33.77926], [-118.29938, 33.77939], [-118.29967, 33.77967], [-118.29978, 33.77974], [-118.3001, 33.77979], [-118.30012, 33.77981]]]]} Restricted Access 2 5975 Defense Fuel Supply Point (DFSP) - Hab. Restoration 18013 199 Other Federal 284 Federal 1 Federal Agency 1   Other Federal 13 199 Other Federal 280 Federal 1 Federal Agency 1   Los Angeles 6 326.646 Defense Fuel Supply Point (DFSP) - Hab. Restoration 0 Federal Other or Unknown 87 4
2768 2768 2767 {"type": "Polygon", "coordinates": [[[-121.39863, 38.87619], [-121.38647, 38.87621], [-121.3864, 38.87334], [-121.38634, 38.86807], [-121.39569, 38.86804], [-121.39849, 38.86801], [-121.39863, 38.87619]]]} No Public Access 3 21550 US Air Force 26741 199 Other Federal 284 Federal 1 Federal Agency 1   Other Federal 13 199 Other Federal 280 Federal 1 Federal Agency 1   Placer 35 236.307 US Air Force 0 Federal Other or Unknown 87 4
3126 3126 3125 {"type": "Polygon", "coordinates": [[[-124.40959, 40.43808], [-124.40951, 40.43842], [-124.40911, 40.43904], [-124.40909, 40.4399], [-124.40922, 40.44018], [-124.40919, 40.4405], [-124.40914, 40.44056], [-124.40888, 40.44096], [-124.40861, 40.4432], [-124.40831, 40.44347], [-124.40777, 40.4445], [-124.40762, 40.4451], [-124.40694, 40.44581], [-124.40685, 40.44369], [-124.39606, 40.44363], [-124.39606, 40.44008], [-124.40082, 40.44002], [-124.40086, 40.43661], [-124.40676, 40.43647], [-124.40675, 40.43542], [-124.40714, 40.43567], [-124.40757, 40.43584], [-124.40771, 40.43598], [-124.40797, 40.43603], [-124.40813, 40.43615], [-124.40828, 40.43652], [-124.40906, 40.43711], [-124.40912, 40.43739], [-124.40959, 40.43808]]]} Open Access 1 25764 Other Federal 23248 199 Other Federal 284 Federal 1 Federal Agency 1   Other Federal 13 199 Other Federal 280 Federal 1 Federal Agency 1   Humboldt 45 181.407 Other Federal 0 Federal Other or Unknown 87 4
3128 3128 3127 {"type": "Polygon", "coordinates": [[[-121.52562, 38.55872], [-121.51758, 38.55761], [-121.51649, 38.55513], [-121.52493, 38.55425], [-121.52562, 38.55872]]]} Open Access 1 21571 United States of America 26668 199 Other Federal 284 Federal 1 Federal Agency 1   Other Federal 13 199 Other Federal 280 Federal 1 Federal Agency 1   Yolo 33 68.326 United States of America 0 Federal Other or Unknown 87 4
3154 3154 3153 {"type": "Polygon", "coordinates": [[[-121.66267, 38.17881], [-121.66233, 38.1796], [-121.66183, 38.18015], [-121.66057, 38.18049], [-121.6572, 38.18162], [-121.65543, 38.18198], [-121.65393, 38.18244], [-121.65201, 38.1828], [-121.64803, 38.18428], [-121.64712, 38.17403], [-121.65009, 38.17464], [-121.65383, 38.17571], [-121.65488, 38.1762], [-121.6556, 38.17642], [-121.65777, 38.17653], [-121.6602, 38.17778], [-121.6615, 38.17807], [-121.66216, 38.1784], [-121.66267, 38.17881]]]} Open Access 1 21759 Delta Protection 18074 199 Other Federal 284 Federal 1 Federal Agency 1   Other Federal 13 199 Other Federal 280 Federal 1 Federal Agency 1   Sacramento 41 214.905 Delta Protection 0 Federal Other or Unknown 87 4
4476 4476 4475 {"type": "Polygon", "coordinates": [[[-117.65558, 33.90986], [-117.6554, 33.91873], [-117.65315, 33.91871], [-117.65252, 33.91691], [-117.65255, 33.91689], [-117.65245, 33.9166], [-117.65241, 33.91659], [-117.65165, 33.91438], [-117.65169, 33.91436], [-117.65166, 33.91426], [-117.65161, 33.91426], [-117.65146, 33.91385], [-117.6516, 33.91359], [-117.65131, 33.91341], [-117.65124, 33.91319], [-117.6516, 33.9131], [-117.65161, 33.91309], [-117.65123, 33.91201], [-117.65089, 33.91209], [-117.65019, 33.91006], [-117.65189, 33.91007], [-117.65558, 33.90986]]]} Open Access 1 3702 Unnamed site - Other Federal 28636 199 Other Federal 284 Federal 1 Federal Agency 1   Other Federal 13 199 Other Federal 280 Federal 1 Federal Agency 1   Riverside 10 83.657   0 Federal Other or Unknown 87 4
4488 4488 4487 {"type": "Polygon", "coordinates": [[[-117.65093, 33.90642], [-117.64926, 33.90648], [-117.64867, 33.90481], [-117.64847, 33.90433], [-117.64801, 33.90334], [-117.65091, 33.90307], [-117.65093, 33.90642]]]} Open Access 1 4845 Unnamed site - Other Federal 28636 199 Other Federal 284 Federal 1 Federal Agency 1   Other Federal 13 199 Other Federal 280 Federal 1 Federal Agency 1   Riverside 10 18.733   0 Federal Other or Unknown 87 4
4767 4767 4766 {"type": "MultiPolygon", "coordinates": [[[[-124.07188, 40.02141], [-124.0717, 40.02154], [-124.07142, 40.02186], [-124.07138, 40.02194], [-124.07093, 40.02203], [-124.07077, 40.022], [-124.07039, 40.02228], [-124.07027, 40.02238], [-124.07015, 40.02271], [-124.0698, 40.02258], [-124.06982, 40.02124], [-124.07026, 40.02134], [-124.0705, 40.02146], [-124.0707, 40.02155], [-124.07077, 40.02147], [-124.07095, 40.02136], [-124.07113, 40.02143], [-124.07099, 40.02123], [-124.07099, 40.02112], [-124.07109, 40.02104], [-124.0712, 40.02104], [-124.0715, 40.02123], [-124.07164, 40.02124], [-124.07185, 40.02127], [-124.07188, 40.02141]]], [[[-124.07536, 40.02553], [-124.07492, 40.0256], [-124.07487, 40.02547], [-124.0753, 40.02539], [-124.07536, 40.02553]]], [[[-124.07571, 40.02705], [-124.07534, 40.02713], [-124.07525, 40.02686], [-124.07566, 40.02676], [-124.07571, 40.02689], [-124.07571, 40.02705]]], [[[-124.07823, 40.02907], [-124.07811, 40.02949], [-124.07799, 40.02951], [-124.07792, 40.02949], [-124.07753, 40.02925], [-124.07779, 40.02903], [-124.07788, 40.02915], [-124.07778, 40.02926], [-124.07778, 40.02928], [-124.07791, 40.02918], [-124.07802, 40.02918], [-124.07823, 40.02907]]], [[[-124.07922, 40.0299], [-124.07922, 40.03005], [-124.07911, 40.03018], [-124.079, 40.03028], [-124.07875, 40.03011], [-124.07908, 40.02984], [-124.07922, 40.0299]]], [[[-124.07933, 40.03016], [-124.07925, 40.03046], [-124.07904, 40.03031], [-124.07922, 40.03015], [-124.07933, 40.03016]]], [[[-124.1686, 40.57766], [-124.16517, 40.57763], [-124.16391, 40.57524], [-124.16225, 40.57413], [-124.162, 40.57379], [-124.16671, 40.57381], [-124.16859, 40.57486], [-124.1686, 40.57766]]], [[[-124.20702, 40.62484], [-124.20654, 40.62667], [-124.20601, 40.62727], [-124.20538, 40.62782], [-124.20538, 40.62856], [-124.20373, 40.62856], [-124.20373, 40.62912], [-124.20237, 40.62912], [-124.20235, 40.62812], [-124.20222, 40.62451], [-124.20505, 40.62454], [-124.20545, 40.62473], [-124.20547, 40.62483], [-124.20702, 40.62484]]], [[[-124.24507, 40.70111], [-124.23975, 40.70113], [-124.23978, 40.70493], [-124.24384, 40.70491], [-124.24362, 40.70559], [-124.24366, 40.70705], [-124.24345, 40.70806], [-124.2428, 40.70893], [-124.24271, 40.7093], [-124.24081, 40.71136], [-124.23989, 40.71261], [-124.23923, 40.71499], [-124.23912, 40.71609], [-124.2355, 40.71611], [-124.23546, 40.71493], [-124.23555, 40.71084], [-124.23554, 40.70677], [-124.23558, 40.70283], [-124.23689, 40.70132], [-124.23685, 40.70119], [-124.23558, 40.7026], [-124.23559, 40.69411], [-124.24021, 40.69417], [-124.24029, 40.69762], [-124.24506, 40.69761], [-124.24507, 40.70111]]]]} Unknown Access 4 46914 Unnamed site - Other Federal 30495 199 Other Federal 284 Federal 1 Federal Agency 1   Other Federal 13 199 Other Federal 280 Federal 1 Federal Agency 1   Humboldt 45 389.611   0 Federal Other or Unknown 87 4
5184 5184 5183 {"type": "Polygon", "coordinates": [[[-122.00444, 36.96745], [-122.00387, 36.96749], [-122.00391, 36.96788], [-122.00368, 36.96786], [-122.00366, 36.96704], [-122.004, 36.96702], [-122.00401, 36.96714], [-122.00434, 36.96712], [-122.00444, 36.96745]]]} Open Access 1 1479 Twin Lakes - USA 26615 199 Other Federal 284 Federal 1 Federal Agency 1   Other Federal 13 199 Other Federal 280 Federal 1 Federal Agency 1   Santa Cruz 5 0.895 Twin Lakes - USA 0 Federal Other or Unknown 87 4
9848 9848 9847 {"type": "Polygon", "coordinates": [[[-119.62642, 36.59749], [-119.62573, 36.5975], [-119.62574, 36.5981], [-119.62256, 36.59811], [-119.62256, 36.59635], [-119.62389, 36.59572], [-119.62388, 36.59489], [-119.6232, 36.59416], [-119.62192, 36.59418], [-119.62191, 36.59289], [-119.62419, 36.59288], [-119.6242, 36.59467], [-119.62497, 36.59528], [-119.62541, 36.59616], [-119.62639, 36.59616], [-119.62642, 36.59749]]]} No Public Access 3 16838 Young Pond Federal Wetlands/Selma Pres 27789 199 Other Federal 284 Federal 1 Federal Agency 1   Other Federal 13 199 Other Federal 280 Federal 1 Federal Agency 1   Fresno 9 29.786 Young Pond Federal Wetlands/Selma Pres 0 Federal Other or Unknown 87 4
11273 11273 11272 {"type": "Polygon", "coordinates": [[[-121.47577, 38.46692], [-121.47575, 38.47575], [-121.47456, 38.47572], [-121.47455, 38.47575], [-121.47313, 38.47576], [-121.47314, 38.48009], [-121.47415, 38.48009], [-121.47416, 38.48135], [-121.47101, 38.48135], [-121.47101, 38.47516], [-121.46887, 38.47515], [-121.46888, 38.47237], [-121.46923, 38.47236], [-121.46925, 38.47036], [-121.4692, 38.47035], [-121.46888, 38.47039], [-121.46888, 38.46696], [-121.46891, 38.46695], [-121.46888, 38.46693], [-121.47577, 38.46692]]]} Open Access 1 21779 United States Of America 26669 199 Other Federal 284 Federal 1 Federal Agency 1   Other Federal 13 199 Other Federal 280 Federal 1 Federal Agency 1   Sacramento 41 172.155 United States Of America 0 Federal Other or Unknown 87 4
11423 11423 11422 {"type": "MultiPolygon", "coordinates": [[[[-121.30305, 38.54735], [-121.30211, 38.5479], [-121.30127, 38.54837], [-121.2953, 38.55181], [-121.29482, 38.55207], [-121.29427, 38.55231], [-121.2937, 38.5525], [-121.29335, 38.5526], [-121.29265, 38.55275], [-121.29246, 38.55278], [-121.29003, 38.5528], [-121.28957, 38.55274], [-121.28897, 38.55261], [-121.28836, 38.55242], [-121.28791, 38.55226], [-121.28551, 38.5512], [-121.28518, 38.55109], [-121.28486, 38.55102], [-121.28379, 38.55086], [-121.28308, 38.55082], [-121.28265, 38.55083], [-121.28259, 38.54964], [-121.28298, 38.54965], [-121.28397, 38.54949], [-121.28537, 38.54886], [-121.28599, 38.54831], [-121.28692, 38.54751], [-121.28713, 38.54683], [-121.28788, 38.54565], [-121.28812, 38.54522], [-121.28839, 38.54526], [-121.28848, 38.54518], [-121.29005, 38.54547], [-121.29024, 38.54486], [-121.29018, 38.54435], [-121.28998, 38.54383], [-121.28964, 38.54334], [-121.28791, 38.54363], [-121.28759, 38.54403], [-121.28589, 38.54301], [-121.28583, 38.54294], [-121.28639, 38.54202], [-121.28574, 38.54162], [-121.28514, 38.54238], [-121.28501, 38.54227], [-121.28488, 38.54207], [-121.28543, 38.54142], [-121.28547, 38.54098], [-121.28481, 38.54044], [-121.28397, 38.54], [-121.28293, 38.54004], [-121.28244, 38.54027], [-121.28118, 38.53964], [-121.28064, 38.53961], [-121.27946, 38.54002], [-121.27897, 38.54049], [-121.27866, 38.54086], [-121.2783, 38.54113], [-121.27786, 38.54135], [-121.27631, 38.54189], [-121.2764, 38.54203], [-121.27556, 38.54252], [-121.27453, 38.54244], [-121.27376, 38.54246], [-121.27307, 38.54332], [-121.27282, 38.54358], [-121.27375, 38.54468], [-121.27278, 38.54507], [-121.27227, 38.54435], [-121.27224, 38.54368], [-121.27233, 38.54302], [-121.27252, 38.54256], [-121.27246, 38.54215], [-121.27209, 38.54127], [-121.27177, 38.54079], [-121.27132, 38.5405], [-121.27142, 38.5403], [-121.27227, 38.54066], [-121.27301, 38.5409], [-121.27377, 38.54112], [-121.27493, 38.54155], [-121.27598, 38.54132], [-121.27663, 38.54074], [-121.2757, 38.53913], [-121.27535, 38.53918], [-121.27453, 38.53879], [-121.2726, 38.53884], [-121.27114, 38.53948], [-121.27019, 38.54032], [-121.26992, 38.54086], [-121.26982, 38.54135], [-121.26894, 38.54175], [-121.26856, 38.54449], [-121.2689, 38.54555], [-121.26937, 38.54647], [-121.26788, 38.54711], [-121.26917, 38.54757], [-121.26919, 38.54759], [-121.26923, 38.54765], [-121.2689, 38.54865], [-121.2688, 38.54869], [-121.26872, 38.54877], [-121.26856, 38.54887], [-121.26839, 38.54894], [-121.26831, 38.549], [-121.26706, 38.54949], [-121.26703, 38.54956], [-121.2661, 38.54997], [-121.26584, 38.54992], [-121.26464, 38.54933], [-121.26446, 38.54912], [-121.2637, 38.54838], [-121.26341, 38.54821], [-121.26297, 38.54721], [-121.26298, 38.54713], [-121.26297, 38.54709], [-121.26302, 38.54687], [-121.26313, 38.54672], [-121.26313, 38.5467], [-121.26121, 38.54672], [-121.2612, 38.54482], [-121.26109, 38.54475], [-121.26111, 38.53501], [-121.26859, 38.53502], [-121.26859, 38.53527], [-121.28764, 38.5349], [-121.29213, 38.53601], [-121.2884, 38.53879], [-121.28755, 38.53809], [-121.28787, 38.53781], [-121.28787, 38.53779], [-121.28664, 38.53694], [-121.2863, 38.53673], [-121.28504, 38.53627], [-121.28387, 38.53604], [-121.28242, 38.53602], [-121.28172, 38.5361], [-121.28183, 38.53748], [-121.28205, 38.5376], [-121.28355, 38.53763], [-121.28389, 38.53766], [-121.28467, 38.53784], [-121.28628, 38.5387], [-121.28665, 38.5387], [-121.28746, 38.53816], [-121.28831, 38.53886], [-121.28745, 38.53963], [-121.28745, 38.53965], [-121.30255, 38.53981], [-121.30254, 38.54027], [-121.29962, 38.54163], [-121.30305, 38.54735]]], [[[-121.27303, 38.54697], [-121.27298, 38.54745], [-121.27276, 38.5477], [-121.27231, 38.54795], [-121.27189, 38.54805], [-121.27153, 38.54807], [-121.27114, 38.54797], [-121.27069, 38.5477], [-121.27032, 38.54743], [-121.27016, 38.54712], [-121.27014, 38.54691], [-121.27016, 38.54678], [-121.27086, 38.54634], [-121.27185, 38.54597], [-121.27209, 38.54611], [-121.27236, 38.54639], [-121.27303, 38.54697]]]]} Restricted Access 2 22251 Mather 21950 199 Other Federal 284 Federal 1 Federal Agency 1   Other Federal 13 199 Other Federal 280 Federal 1 Federal Agency 1   Sacramento 41 927.044 Mather 0 Federal Other or Unknown 87 4
11425 11425 11424 {"type": "MultiPolygon", "coordinates": [[[[-121.3675, 38.67299], [-121.36388, 38.67606], [-121.36391, 38.67519], [-121.36103, 38.6752], [-121.36093, 38.67293], [-121.3675, 38.67299]]], [[[-121.38686, 38.71035], [-121.38621, 38.71061], [-121.38139, 38.71218], [-121.3813, 38.71244], [-121.38071, 38.71244], [-121.38078, 38.71216], [-121.38077, 38.71215], [-121.37652, 38.71218], [-121.37402, 38.71051], [-121.37491, 38.70982], [-121.37505, 38.70977], [-121.37599, 38.70985], [-121.37658, 38.71005], [-121.37976, 38.71], [-121.38052, 38.71011], [-121.38227, 38.71018], [-121.38356, 38.71001], [-121.38466, 38.70975], [-121.38501, 38.70956], [-121.38548, 38.70963], [-121.38581, 38.70997], [-121.38634, 38.71026], [-121.38686, 38.71035]]]]} No Public Access 3 22268 Other Federal 23247 199 Other Federal 284 Federal 1 Federal Agency 1   Other Federal 13 199 Other Federal 280 Federal 1 Federal Agency 1   Sacramento 41 79.009 Other Federal 0 Federal Other or Unknown 87 4
13191 13191 13190 {"type": "Polygon", "coordinates": [[[-119.59575, 34.43281], [-119.59564, 34.43307], [-119.59546, 34.43319], [-119.59384, 34.43328], [-119.59369, 34.43331], [-119.59333, 34.43348], [-119.59312, 34.43349], [-119.59281, 34.43347], [-119.59284, 34.43339], [-119.59284, 34.43338], [-119.59234, 34.43335], [-119.59198, 34.43329], [-119.59177, 34.43314], [-119.59175, 34.43216], [-119.59211, 34.43175], [-119.59211, 34.43153], [-119.59198, 34.43142], [-119.59259, 34.43061], [-119.59274, 34.43063], [-119.59274, 34.43066], [-119.59381, 34.43143], [-119.59438, 34.43089], [-119.5947, 34.43111], [-119.59536, 34.43216], [-119.59571, 34.43254], [-119.59575, 34.43281]], [[-119.59418, 34.43196], [-119.59398, 34.4318], [-119.59389, 34.43185], [-119.59367, 34.43172], [-119.59367, 34.43226], [-119.59343, 34.43324], [-119.59383, 34.43314], [-119.59535, 34.43305], [-119.59548, 34.433], [-119.59451, 34.43225], [-119.59418, 34.43196]]]} Open Access 1 35185 Other Federal 2 23250 199 Other Federal 284 Federal 1 Federal Agency 1   Other Federal 13 199 Other Federal 280 Federal 1 Federal Agency 1   Santa Barbara 7 15.854 Other Federal 2 0 Federal Other or Unknown 87 4
13999 13999 13998 {"type": "Polygon", "coordinates": [[[-119.48741, 34.40656], [-119.48735, 34.40708], [-119.48605, 34.40761], [-119.48503, 34.40646], [-119.48517, 34.40627], [-119.48575, 34.40581], [-119.48603, 34.40565], [-119.48683, 34.40595], [-119.48689, 34.40614], [-119.48741, 34.40656]]]} Open Access 1 36692 Other Federal 1 23249 199 Other Federal 284 Federal 1 Federal Agency 1   Other Federal 13 199 Other Federal 280 Federal 1 Federal Agency 1   Santa Barbara 7 7.122 Other Federal 1 0 Federal Other or Unknown 87 4

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE units_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  UNIT_ID INT,
  UNIT_NAME TEXT,
  SUID_NMA INT,
  AGNCY_ID INT,
  AGNCY_NAME INT,
  AGNCY_LEV INT,
  AGNCY_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  PARK_URL TEXT,
  COUNTY INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
  DES_TP INT,
  GAP_STS TEXT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]),
   FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]),
   FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]),
   FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]),
   FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]),
   FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id])
);
CREATE INDEX [idx_units_with_maps_DES_TP]
    ON [units_with_maps] ([DES_TP]);
CREATE INDEX [idx_units_with_maps_COUNTY]
    ON [units_with_maps] ([COUNTY]);
CREATE INDEX [idx_units_with_maps_MNG_AG_TYP]
    ON [units_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_units_with_maps_MNG_AG_LEV]
    ON [units_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_units_with_maps_MNG_AGENCY]
    ON [units_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_units_with_maps_LAYER]
    ON [units_with_maps] ([LAYER]);
CREATE INDEX [idx_units_with_maps_AGNCY_TYP]
    ON [units_with_maps] ([AGNCY_TYP]);
CREATE INDEX [idx_units_with_maps_AGNCY_LEV]
    ON [units_with_maps] ([AGNCY_LEV]);
CREATE INDEX [idx_units_with_maps_AGNCY_NAME]
    ON [units_with_maps] ([AGNCY_NAME]);
CREATE INDEX [idx_units_with_maps_ACCESS_TYP]
    ON [units_with_maps] ([ACCESS_TYP]);