units_with_maps

Table actions

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

164 rows where DES_TP = 3, GAP_STS = 4 and MNG_AG_TYP = 4

This data as json, copyable, CSV (advanced)

Suggested facets: AGNCY_LEV, LAYER, PARK_URL, YR_EST

MNG_AG_TYP 1

  • Recreation/Parks District · 164 ✖

DES_TP 1

  • Local Recreation Area · 164 ✖
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
195 195 194 {"type": "Polygon", "coordinates": [[[-117.04739, 34.89181], [-117.04738, 34.89249], [-117.04398, 34.89336], [-117.04397, 34.89172], [-117.04739, 34.89181]]]} Open Access 1 569 Foglesong Park/Eda Henderson Pool 18966 2203 Barstow Recreation and Park District 78 Special District 4 Recreation/Parks District 4   Special District 4 2203 Barstow Recreation and Park District 76 Special District 4 Recreation/Parks District 4   San Bernardino 22 9.887 Foglesong Park/Eda Henderson Pool 0 Local Recreation Area 3 4
218 218 217 {"type": "MultiPolygon", "coordinates": [[[[-122.00283, 37.56787], [-122.00528, 37.56886], [-122.00536, 37.56876], [-122.00637, 37.56915], [-122.00646, 37.56905], [-122.00694, 37.56924], [-122.00841, 37.57037], [-122.00605, 37.57247], [-122.00581, 37.57272], [-122.00563, 37.57245], [-122.00561, 37.57245], [-122.00486, 37.57485], [-122.00167, 37.57418], [-122.00088, 37.57663], [-122.00033, 37.5765], [-121.99656, 37.57363], [-121.99685, 37.57277], [-121.99721, 37.57285], [-121.99723, 37.57284], [-121.99743, 37.56696], [-121.99852, 37.56669], [-121.99871, 37.5667], [-121.9987, 37.56677], [-121.99916, 37.56686], [-121.99961, 37.56698], [-122.00112, 37.56756], [-122.0012, 37.56746], [-122.00224, 37.56786], [-122.00235, 37.56771], [-122.00283, 37.56787]]], [[[-122.00227, 37.57706], [-122.00224, 37.57716], [-122.00227, 37.57718], [-122.00203, 37.57784], [-122.0005, 37.57666], [-122.00227, 37.57706]]], [[[-122.01347, 37.57268], [-122.01183, 37.57446], [-122.01014, 37.57619], [-122.00994, 37.57635], [-122.00973, 37.57651], [-122.00895, 37.57696], [-122.00821, 37.57742], [-122.00796, 37.57759], [-122.0077, 37.57782], [-122.00748, 37.57808], [-122.0073, 37.57835], [-122.00718, 37.57862], [-122.00706, 37.5786], [-122.00686, 37.57917], [-122.00811, 37.57947], [-122.00818, 37.57956], [-122.00772, 37.58092], [-122.00605, 37.58056], [-122.00568, 37.58164], [-122.00418, 37.58051], [-122.00216, 37.57896], [-122.00209, 37.57889], [-122.00203, 37.5788], [-122.00198, 37.57866], [-122.002, 37.57851], [-122.00244, 37.57734], [-122.00248, 37.57728], [-122.00258, 37.57724], [-122.003, 37.57733], [-122.00424, 37.57807], [-122.00588, 37.57674], [-122.00592, 37.57631], [-122.01114, 37.57138], [-122.01347, 37.57268]]]]} Open Access 1 586 Quarry Lakes Regional Recreation Area 30594 2032 East Bay Regional Park District 89 Special District 4 Recreation/Parks District 4 http://www.ebparks.org/ Special District 4 2032 East Bay Regional Park District 87 Special District 4 Recreation/Parks District 4   Alameda 17 254.616 Quarry Lakes Reg. Rec. Area 2001 Local Recreation Area 3 4
385 385 384 {"type": "Polygon", "coordinates": [[[-117.15388, 33.67064], [-117.15386, 33.67362], [-117.15375, 33.67366], [-117.15354, 33.67338], [-117.15342, 33.6733], [-117.15342, 33.67327], [-117.15317, 33.67312], [-117.15276, 33.67299], [-117.15275, 33.67297], [-117.15218, 33.67273], [-117.1521, 33.67268], [-117.15205, 33.67268], [-117.15209, 33.67232], [-117.15206, 33.67228], [-117.15172, 33.67207], [-117.15166, 33.67209], [-117.15161, 33.67209], [-117.15158, 33.67206], [-117.15137, 33.67206], [-117.15114, 33.67216], [-117.15096, 33.67243], [-117.15097, 33.67245], [-117.15093, 33.67262], [-117.15094, 33.67265], [-117.15089, 33.67283], [-117.15091, 33.67286], [-117.15091, 33.67306], [-117.15088, 33.67306], [-117.15083, 33.67326], [-117.15041, 33.67303], [-117.15016, 33.67299], [-117.14999, 33.67287], [-117.14973, 33.67259], [-117.14955, 33.67245], [-117.14936, 33.67232], [-117.14933, 33.67232], [-117.14914, 33.6722], [-117.14911, 33.6722], [-117.14903, 33.67215], [-117.14888, 33.67217], [-117.14849, 33.67226], [-117.1482, 33.67272], [-117.14817, 33.6727], [-117.14817, 33.67261], [-117.14814, 33.67256], [-117.1481, 33.67252], [-117.14802, 33.67247], [-117.14821, 33.67255], [-117.14865, 33.67182], [-117.14797, 33.67065], [-117.14945, 33.67065], [-117.14949, 33.67069], [-117.14974, 33.67069], [-117.14978, 33.67065], [-117.15154, 33.67065], [-117.15159, 33.67069], [-117.15184, 33.67069], [-117.15188, 33.67065], [-117.15388, 33.67064]]]} Open Access 1 48338 Lago Vista Sports Park 32901 2171 Valley-Wide Recreation and Park District 160 Special District 4 Recreation/Parks District 4 https://www.gorecreation.org/ Special District 4 2171 Valley-Wide Recreation and Park District 156 Special District 4 Recreation/Parks District 4 https://www.gorecreation.org/lago-vista-sports-park Riverside 10 28.451 Lago Vista Sports Park 0 Local Recreation Area 3 4
532 532 531 {"type": "Polygon", "coordinates": [[[-118.90336, 34.18406], [-118.90262, 34.18413], [-118.8993, 34.1842], [-118.89928, 34.18407], [-118.89887, 34.18356], [-118.89889, 34.18303], [-118.89872, 34.18292], [-118.89961, 34.18202], [-118.8998, 34.18225], [-118.90006, 34.18231], [-118.90027, 34.18246], [-118.90028, 34.18262], [-118.90087, 34.18263], [-118.90133, 34.18247], [-118.9018, 34.18266], [-118.9019, 34.18329], [-118.90208, 34.18388], [-118.90268, 34.18407], [-118.90324, 34.18397], [-118.90324, 34.18342], [-118.90333, 34.18327], [-118.90336, 34.18406]]]} Open Access 1 1797 Walnut Grove Equestrian Center 27229 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4 http://www.crpd.org/ Special District 4 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4   Ventura 8 13.391 Walnut Grove Equestrian Ctr. 0 Local Recreation Area 3 4
557 557 556 {"type": "Polygon", "coordinates": [[[-117.10253, 33.61115], [-117.1013, 33.61115], [-117.10128, 33.60911], [-117.10251, 33.60901], [-117.10253, 33.61115]]]} Open Access 1 48384 Pourroy Fields 32948 2171 Valley-Wide Recreation and Park District 160 Special District 4 Recreation/Parks District 4 https://www.gorecreation.org/ Special District 4 2171 Valley-Wide Recreation and Park District 156 Special District 4 Recreation/Parks District 4 https://www.gorecreation.org/pourroy-fields Riverside 10 6.552 Pourroy Fields 0 Local Recreation Area 3 4
619 619 618 {"type": "Polygon", "coordinates": [[[-117.07879, 34.21133], [-117.0785, 34.21198], [-117.07792, 34.2117], [-117.07815, 34.21121], [-117.07845, 34.2113], [-117.07848, 34.21124], [-117.07879, 34.21133]]]} Open Access 1 2291 Arrowbear Park Ball Field 15606 2121 Rim of the World Recreation and Park District 224 Special District 4 Recreation/Parks District 4 http://www.rim-rec.org/ Special District 4 2121 Rim of the World Recreation and Park District 220 Special District 4 Recreation/Parks District 4   San Bernardino 22 1.019 Arrowbear Park Ball Field 0 Local Recreation Area 3 4
2046 2046 2045 {"type": "Polygon", "coordinates": [[[-118.90087, 34.21526], [-118.90083, 34.21549], [-118.90044, 34.21561], [-118.90035, 34.21547], [-118.90019, 34.21531], [-118.90026, 34.21519], [-118.90029, 34.21507], [-118.90075, 34.21508], [-118.90087, 34.21526]]]} Open Access 1 15585 Conejo Recreation and Park District 17586 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4 http://www.crpd.org/ Special District 4 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4   Ventura 8 0.656 Conejo Rec. and Park District 0 Local Recreation Area 3 4
2047 2047 2046 {"type": "Polygon", "coordinates": [[[-118.82311, 34.2117], [-118.82304, 34.212], [-118.82178, 34.21232], [-118.8209, 34.21284], [-118.82064, 34.2127], [-118.82024, 34.21277], [-118.81916, 34.21315], [-118.81817, 34.21344], [-118.81724, 34.21322], [-118.81664, 34.21319], [-118.81637, 34.21305], [-118.81624, 34.21296], [-118.81654, 34.21275], [-118.81686, 34.21244], [-118.817, 34.21233], [-118.81723, 34.21222], [-118.81746, 34.21215], [-118.81768, 34.21213], [-118.8179, 34.21214], [-118.82005, 34.21254], [-118.82032, 34.21256], [-118.82056, 34.21256], [-118.82089, 34.2125], [-118.82121, 34.21239], [-118.82229, 34.21176], [-118.82247, 34.21168], [-118.82275, 34.21162], [-118.82299, 34.21161], [-118.82309, 34.21163], [-118.82311, 34.21166], [-118.82311, 34.2117]]]} Open Access 1 15591 Conejo Recreation and Park District 17586 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4 http://www.crpd.org/ Special District 4 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4   Ventura 8 10.413 Conejo Rec. and Park District 0 Local Recreation Area 3 4
2086 2086 2085 {"type": "Polygon", "coordinates": [[[-118.78174, 34.20842], [-118.7775, 34.21463], [-118.76633, 34.21444], [-118.75919, 34.21386], [-118.78174, 34.20842]]]} Open Access 1 17267 Lang Ranch - Montgomery Ranch Open Space 21011 2118 Rancho Simi Recreation and Park District 80 Special District 4 Recreation/Parks District 4 http://www.rsrpd.org/ Special District 4 2118 Rancho Simi Recreation and Park District 78 Special District 4 Recreation/Parks District 4   Ventura 8 154.362 Lang Ranch - Montgomery Ranch OS 0 Local Recreation Area 3 4
2199 2199 2198 {"type": "Polygon", "coordinates": [[[-121.96127, 39.73954], [-121.9611, 39.73965], [-121.96071, 39.73926], [-121.96055, 39.73914], [-121.96029, 39.73899], [-121.96006, 39.7389], [-121.95966, 39.73877], [-121.9598, 39.73858], [-121.95991, 39.73863], [-121.96007, 39.73873], [-121.96046, 39.73889], [-121.96064, 39.73894], [-121.96089, 39.73915], [-121.96127, 39.73954]]]} Open Access 1 16471 Chico Area Recreation & Park District 17191 2017 Chico Area Recreation and Park District 494 Special District 4 Recreation/Parks District 4 http://www.chicorec.com/ Special District 4 2017 Chico Area Recreation and Park District 485 Special District 4 Recreation/Parks District 4   Butte 42 0.797 Chico Area Rec. & Park District 0 Local Recreation Area 3 4
2591 2591 2590 {"type": "MultiPolygon", "coordinates": [[[[-121.89718, 36.61024], [-121.89709, 36.61029], [-121.89629, 36.60934], [-121.8964, 36.60932], [-121.89718, 36.61024]]], [[[-121.89804, 36.61126], [-121.89796, 36.61131], [-121.89719, 36.6104], [-121.89727, 36.61035], [-121.89804, 36.61126]]], [[[-121.89857, 36.61213], [-121.89845, 36.6122], [-121.89841, 36.61202], [-121.89831, 36.61179], [-121.89821, 36.61162], [-121.89805, 36.61143], [-121.89816, 36.61137], [-121.89831, 36.61155], [-121.89846, 36.6118], [-121.89852, 36.61194], [-121.89857, 36.61213]]], [[[-121.89976, 36.61454], [-121.8996, 36.61463], [-121.89874, 36.61359], [-121.89862, 36.61339], [-121.89853, 36.61314], [-121.8985, 36.61297], [-121.89847, 36.61266], [-121.89862, 36.61283], [-121.89864, 36.61302], [-121.89868, 36.61318], [-121.89875, 36.61336], [-121.89886, 36.61355], [-121.89942, 36.61422], [-121.89947, 36.6142], [-121.89976, 36.61454]]], [[[-121.90075, 36.61569], [-121.90057, 36.61579], [-121.89971, 36.61477], [-121.89987, 36.61468], [-121.90006, 36.61489], [-121.90008, 36.61489], [-121.90075, 36.61569]]], [[[-121.90167, 36.61684], [-121.90153, 36.61692], [-121.90067, 36.6159], [-121.9008, 36.61582], [-121.90167, 36.61684]]], [[[-121.90242, 36.6177], [-121.90225, 36.61776], [-121.90163, 36.61703], [-121.90177, 36.61695], [-121.90242, 36.6177]]], [[[-121.90324, 36.61833], [-121.90322, 36.61834], [-121.90314, 36.61831], [-121.903, 36.61821], [-121.90291, 36.61811], [-121.90302, 36.61806], [-121.90324, 36.61833]]]]} Open Access 1 17932 Monterey Bay Coastal Trail 22417 2084 Monterey Peninsula Recreational Trail Joint Powers 537 Special District 4 Recreation/Parks District 4   Special District 4 2084 Monterey Peninsula Recreational Trail Joint Powers 530 Special District 4 Recreation/Parks District 4   Monterey 14 3.184 Monterey Bay Coastal Trail 0 Local Recreation Area 3 4
2664 2664 2663 {"type": "Polygon", "coordinates": [[[-118.79074, 34.17831], [-118.79083, 34.17883], [-118.79085, 34.17913], [-118.79081, 34.17938], [-118.79071, 34.1796], [-118.79039, 34.18012], [-118.79027, 34.18039], [-118.79029, 34.18095], [-118.78987, 34.18098], [-118.78894, 34.18098], [-118.78894, 34.18079], [-118.78879, 34.18062], [-118.78855, 34.1805], [-118.78858, 34.18019], [-118.78876, 34.17983], [-118.78868, 34.17964], [-118.78895, 34.17945], [-118.789, 34.17905], [-118.78924, 34.17889], [-118.78889, 34.17857], [-118.78936, 34.1781], [-118.79015, 34.17831], [-118.79074, 34.17831]]]} Open Access 1 18176 North Ranch Playfield 22854 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4 http://www.crpd.org/ Special District 4 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4   Ventura 8 11.94 North Ranch Playfield 0 Local Recreation Area 3 4
2899 2899 2898 {"type": "Polygon", "coordinates": [[[-118.7465, 34.2681], [-118.7444, 34.26943], [-118.74421, 34.26958], [-118.74398, 34.26982], [-118.74249, 34.26982], [-118.7426, 34.26967], [-118.74271, 34.26946], [-118.74348, 34.26765], [-118.7436, 34.26748], [-118.74386, 34.26733], [-118.7465, 34.2681]]]} Open Access 1 18951 Sycamore Drive Community Center & Pool 26125 2118 Rancho Simi Recreation and Park District 80 Special District 4 Recreation/Parks District 4 http://www.rsrpd.org/ Special District 4 2118 Rancho Simi Recreation and Park District 78 Special District 4 Recreation/Parks District 4   Ventura 8 13.056 Sycamore Drive Community Ctr. & Pool 0 Local Recreation Area 3 4
3023 3023 3022 {"type": "Polygon", "coordinates": [[[-120.16008, 39.33028], [-120.15264, 39.33027], [-120.15263, 39.32975], [-120.15173, 39.32975], [-120.15093, 39.32976], [-120.15107, 39.32712], [-120.15331, 39.32747], [-120.1564, 39.32873], [-120.15785, 39.32925], [-120.1591, 39.32944], [-120.15954, 39.3294], [-120.16008, 39.33028]]]} Open Access 1 24336 River View Sports Park 24428 2263 Truckee-Donner Recreation and Park District 576 Special District 4 Recreation/Parks District 4 http://www.tdrpd.com/ Special District 4 2263 Truckee-Donner Recreation and Park District 568 Special District 4 Recreation/Parks District 4   Nevada 30 38.78 River View Sports Park 0 Local Recreation Area 3 4
3269 3269 3268 {"type": "Polygon", "coordinates": [[[-122.0528, 37.99715], [-122.05267, 37.99768], [-122.05079, 37.99735], [-122.05079, 37.99734], [-122.05051, 37.99729], [-122.05017, 37.99725], [-122.05016, 37.99724], [-122.04978, 37.99725], [-122.04887, 37.99733], [-122.04817, 37.99731], [-122.04823, 37.9969], [-122.04863, 37.99694], [-122.04888, 37.99693], [-122.04913, 37.99691], [-122.04957, 37.9968], [-122.04985, 37.99676], [-122.04986, 37.99675], [-122.05003, 37.99674], [-122.0501, 37.99681], [-122.05025, 37.99683], [-122.05029, 37.99673], [-122.05066, 37.99677], [-122.0528, 37.99715]]]} Open Access 1 29407 Delta/DeAnza Trail 18077 2032 East Bay Regional Park District 89 Special District 4 Recreation/Parks District 4 http://www.ebparks.org/ Special District 4 2032 East Bay Regional Park District 87 Special District 4 Recreation/Parks District 4   Contra Costa 12 5.445 Delta/DeAnza Trail 0 Local Recreation Area 3 4
3355 3355 3354 {"type": "Polygon", "coordinates": [[[-116.36064, 33.7325], [-116.36064, 33.73492], [-116.35884, 33.73445], [-116.35656, 33.73376], [-116.35647, 33.73315], [-116.35647, 33.73251], [-116.36064, 33.7325]]]} Open Access 1 24277 Cook Fields Sports Complex 17615 2216 Desert Recreation District 286 Special District 4 Recreation/Parks District 4 http://www.myrecreationdistrict.com Special District 4 2216 Desert Recreation District 282 Special District 4 Recreation/Parks District 4   Riverside 10 19.46 Cook Fields Sports Complex 0 Local Recreation Area 3 4
3358 3358 3357 {"type": "Polygon", "coordinates": [[[-116.07594, 33.57297], [-116.07593, 33.5744], [-116.0754, 33.57439], [-116.07538, 33.57444], [-116.07467, 33.57442], [-116.07467, 33.573], [-116.07472, 33.57296], [-116.07594, 33.57297]]]} Open Access 1 24269 Mecca Community Center and Park 22102 2216 Desert Recreation District 286 Special District 4 Recreation/Parks District 4 http://www.myrecreationdistrict.com Special District 4 2216 Desert Recreation District 282 Special District 4 Recreation/Parks District 4   Riverside 10 4.682 Mecca Community Ctr. and Park 0 Local Recreation Area 3 4
3364 3364 3363 {"type": "Polygon", "coordinates": [[[-122.06821, 37.96242], [-122.06779, 37.96243], [-122.06778, 37.96239], [-122.06715, 37.9624], [-122.06651, 37.96247], [-122.06646, 37.96233], [-122.06626, 37.96208], [-122.06625, 37.96193], [-122.06635, 37.96168], [-122.06738, 37.96154], [-122.06818, 37.96148], [-122.06821, 37.96242]]]} Open Access 1 31033 Pleasant Hill Community Center / Frank Salfingere Park 23794 2112 Pleasant Hill Recreation and Park District 466 Special District 4 Recreation/Parks District 4 http://www.pleasanthillrec.com Special District 4 2112 Pleasant Hill Recreation and Park District 459 Special District 4 Recreation/Parks District 4   Contra Costa 12 3.829 Pleasant Hill Community Ctr. / Frank Salfingere Park 0 Local Recreation Area 3 4
3502 3502 3501 {"type": "MultiPolygon", "coordinates": [[[[-121.38155, 38.45546], [-121.38133, 38.45552], [-121.38115, 38.45563], [-121.38102, 38.45578], [-121.38096, 38.45595], [-121.38097, 38.45515], [-121.38053, 38.45511], [-121.38059, 38.45505], [-121.3806, 38.45497], [-121.38057, 38.45493], [-121.38053, 38.45491], [-121.38047, 38.4549], [-121.38041, 38.4549], [-121.38041, 38.45474], [-121.38085, 38.45497], [-121.38115, 38.45506], [-121.3814, 38.45506], [-121.38155, 38.45546]]], [[[-121.38319, 38.45988], [-121.38277, 38.45988], [-121.38264, 38.4596], [-121.38272, 38.45954], [-121.38274, 38.45948], [-121.3827, 38.45937], [-121.3827, 38.45913], [-121.38268, 38.45901], [-121.38261, 38.45886], [-121.38245, 38.45861], [-121.38238, 38.45845], [-121.38224, 38.45784], [-121.38214, 38.45762], [-121.38195, 38.4573], [-121.38188, 38.45714], [-121.38182, 38.45694], [-121.38176, 38.45661], [-121.38171, 38.45649], [-121.38156, 38.45622], [-121.38155, 38.45617], [-121.38155, 38.4561], [-121.38154, 38.45606], [-121.38149, 38.45601], [-121.3814, 38.456], [-121.38131, 38.45603], [-121.38128, 38.45611], [-121.38109, 38.45611], [-121.38109, 38.45594], [-121.38113, 38.45583], [-121.38123, 38.4557], [-121.38135, 38.45562], [-121.38148, 38.45558], [-121.38159, 38.45557], [-121.38319, 38.45988]]]]} Open Access 1 36025 Danbury Parkway 17917 2160 Southgate Recreation and Park District 502 Special District 4 Recreation/Parks District 4 http://www.southgaterecandpark.net/ Special District 4 2160 Southgate Recreation and Park District 494 Special District 4 Recreation/Parks District 4   Sacramento 41 3.905 Danbury Parkway 0 Local Recreation Area 3 4
3624 3624 3623 {"type": "Polygon", "coordinates": [[[-121.70748, 37.99957], [-121.7053, 37.99809], [-121.70531, 37.9979], [-121.70746, 37.99794], [-121.70748, 37.99957]]]} Open Access 1 29411 BB Delta Shoreline Trail 15905 2032 East Bay Regional Park District 89 Special District 4 Recreation/Parks District 4 http://www.ebparks.org/ Special District 4 2032 East Bay Regional Park District 87 Special District 4 Recreation/Parks District 4   Contra Costa 12 4.739 BB Delta Shoreline Trail 0 Local Recreation Area 3 4

Next page

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]);