units_with_maps

Table actions

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

361 rows where COUNTY = 23

This data as json, copyable, CSV (advanced)

Suggested facets: AGNCY_LEV, AGNCY_TYP, LAYER, MNG_AG_LEV, GAP_STS

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
105 105 104 {"type": "Polygon", "coordinates": [[[-122.66428, 38.02321], [-122.65316, 38.02895], [-122.6525, 38.02785], [-122.652, 38.02795], [-122.65175, 38.02796], [-122.6513, 38.02794], [-122.65109, 38.02806], [-122.65106, 38.02782], [-122.65177, 38.0272], [-122.6525, 38.02645], [-122.65162, 38.015], [-122.65212, 38.01498], [-122.65215, 38.01512], [-122.65396, 38.01499], [-122.654, 38.0149], [-122.65811, 38.01477], [-122.6581, 38.01483], [-122.65809, 38.01484], [-122.65808, 38.01486], [-122.65811, 38.01504], [-122.65817, 38.01517], [-122.65826, 38.01528], [-122.6584, 38.01537], [-122.65892, 38.01548], [-122.65871, 38.01594], [-122.65871, 38.01595], [-122.65969, 38.01626], [-122.65973, 38.01634], [-122.66083, 38.01663], [-122.66241, 38.01653], [-122.66247, 38.01681], [-122.66323, 38.01713], [-122.66375, 38.0171], [-122.66378, 38.01731], [-122.66378, 38.01752], [-122.66374, 38.01773], [-122.66368, 38.01793], [-122.66345, 38.01848], [-122.66321, 38.01886], [-122.66316, 38.01893], [-122.66208, 38.01993], [-122.66031, 38.02172], [-122.66017, 38.0219], [-122.66012, 38.022], [-122.66005, 38.02221], [-122.66005, 38.02229], [-122.66008, 38.02244], [-122.66015, 38.02259], [-122.66024, 38.02273], [-122.66036, 38.02285], [-122.66053, 38.02293], [-122.6607, 38.023], [-122.66088, 38.02304], [-122.66107, 38.02305], [-122.66127, 38.02304], [-122.66213, 38.02273], [-122.66266, 38.0225], [-122.66279, 38.02243], [-122.66302, 38.02236], [-122.66326, 38.02233], [-122.66358, 38.02236], [-122.6638, 38.02244], [-122.66392, 38.02252], [-122.66397, 38.02257], [-122.66405, 38.02269], [-122.6642, 38.02297], [-122.66428, 38.02321]]]} Open Access 1 294 Roy's Redwoods Open Space Preserve 29292 2070 Marin County Open Space District 44 Special District 4 Recreation/Parks District 4 http://www.marincountyparks.org/Depts/PK.aspx Special District 4 2070 Marin County Open Space District 43 Special District 4 Recreation/Parks District 4 http://www.marincountyparks.org/depts/pk/divisions/open-space/roys-redwoods Marin 23 281.798 Roy's Redwoods OSP 1978 Local Conservation Area 4 2
374 374 373 {"type": "Polygon", "coordinates": [[[-122.51401, 38.08952], [-122.50961, 38.09217], [-122.5071, 38.09337], [-122.50547, 38.08821], [-122.50462, 38.08689], [-122.50476, 38.08671], [-122.50434, 38.08636], [-122.50461, 38.086], [-122.50537, 38.08538], [-122.50578, 38.08514], [-122.50622, 38.08495], [-122.50736, 38.08466], [-122.50838, 38.08465], [-122.50977, 38.08483], [-122.5107, 38.08507], [-122.51158, 38.08542], [-122.51221, 38.08579], [-122.51271, 38.0862], [-122.51324, 38.08682], [-122.51374, 38.08778], [-122.51391, 38.08855], [-122.51402, 38.08937], [-122.51401, 38.08952]]]} Open Access 1 1105 North Antenna Field 22804 209 California State Lands Commission 75 State 5 State Agency 5 http://www.slc.ca.gov/ Other State 5 209 California State Lands Commission 73 State 5 State Agency 5   Marin 23 128.205 North Antenna Field   None 38  
377 377 376 {"type": "MultiPolygon", "coordinates": [[[[-122.63741, 38.12007], [-122.63652, 38.12048], [-122.63581, 38.12056], [-122.63427, 38.12059], [-122.63219, 38.12082], [-122.63072, 38.12113], [-122.63011, 38.12046], [-122.63011, 38.12018], [-122.63741, 38.12007]]], [[[-122.65936, 38.11021], [-122.65936, 38.11113], [-122.65811, 38.11088], [-122.65765, 38.11101], [-122.65744, 38.11116], [-122.65704, 38.11178], [-122.65712, 38.11228], [-122.65707, 38.11254], [-122.65714, 38.11312], [-122.65688, 38.11345], [-122.65636, 38.11364], [-122.65601, 38.11358], [-122.65542, 38.11317], [-122.65416, 38.11323], [-122.65372, 38.11339], [-122.65371, 38.11369], [-122.65377, 38.11389], [-122.65395, 38.11408], [-122.65437, 38.11443], [-122.65407, 38.11581], [-122.65247, 38.11544], [-122.65221, 38.11541], [-122.65197, 38.11541], [-122.65156, 38.11549], [-122.65117, 38.11566], [-122.65054, 38.11598], [-122.64716, 38.11789], [-122.64712, 38.11622], [-122.65079, 38.11475], [-122.6518, 38.11272], [-122.65291, 38.11126], [-122.65452, 38.11062], [-122.65452, 38.10997], [-122.65048, 38.10962], [-122.647, 38.11051], [-122.64693, 38.10718], [-122.65128, 38.10727], [-122.65565, 38.10662], [-122.65936, 38.11021]]]]} Open Access 1 1118 Stafford Lake County Park 25774 306 Marin County Parks Department, County of 154 County 3 County Agency - Parks 7 http://www.marincountyparks.org/depts/pk County 3 306 Marin County Parks Department, County of 150 County 3 County Agency - Parks 7   Marin 23 151.667 Stafford Lake County Park 2000 Local Park 2 4
403 403 402 {"type": "Polygon", "coordinates": [[[-122.51336, 37.9088], [-122.51314, 37.90905], [-122.51286, 37.9095], [-122.51262, 37.91045], [-122.51268, 37.91098], [-122.51245, 37.91139], [-122.51184, 37.91121], [-122.51148, 37.91148], [-122.51096, 37.91151], [-122.51099, 37.91097], [-122.51073, 37.90717], [-122.51103, 37.90745], [-122.51151, 37.90854], [-122.51207, 37.90839], [-122.51279, 37.90839], [-122.51308, 37.90879], [-122.51336, 37.9088]]]} Open Access 1 1554 Tiburon Ridge Open Space Preserve 26341 2070 Marin County Open Space District 44 Special District 4 Recreation/Parks District 4 http://www.marincountyparks.org/Depts/PK.aspx Special District 4 2070 Marin County Open Space District 43 Special District 4 Recreation/Parks District 4   Marin 23 14.684 Tiburon Ridge OSP 0 Local Conservation Area 4 2
436 436 435 {"type": "MultiPolygon", "coordinates": [[[[-122.50735, 38.11473], [-122.50721, 38.11477], [-122.50708, 38.11492], [-122.50687, 38.11486], [-122.50673, 38.11475], [-122.50645, 38.11496], [-122.50608, 38.11467], [-122.50597, 38.11454], [-122.5062, 38.11444], [-122.50605, 38.11434], [-122.50643, 38.1142], [-122.50655, 38.11334], [-122.50673, 38.11403], [-122.50667, 38.11408], [-122.50674, 38.11407], [-122.50688, 38.11442], [-122.5068, 38.1145], [-122.50682, 38.11454], [-122.50703, 38.11464], [-122.50716, 38.11469], [-122.50735, 38.11473]]], [[[-122.50745, 38.11324], [-122.50722, 38.11345], [-122.50723, 38.11346], [-122.50737, 38.11346], [-122.50737, 38.11352], [-122.50703, 38.11382], [-122.50688, 38.11383], [-122.50682, 38.11385], [-122.50685, 38.11358], [-122.50677, 38.11331], [-122.50745, 38.11324]]]]} Open Access 1 840 Black Point Boat Launch 16137 306 Marin County Parks Department, County of 154 County 3 County Agency - Parks 7 http://www.marincountyparks.org/depts/pk County 3 306 Marin County Parks Department, County of 150 County 3 County Agency - Parks 7   Marin 23 2.255 Black Point Boat Launch   None 45  
637 637 636 {"type": "Polygon", "coordinates": [[[-122.56171, 37.90549], [-122.56153, 37.90597], [-122.56084, 37.90597], [-122.56053, 37.90588], [-122.5609, 37.9053], [-122.56144, 37.905], [-122.56164, 37.90502], [-122.56165, 37.90534], [-122.56171, 37.90549]]]} Open Access 1 4911 Earnscliff Canyon Park 18357 1204 Mill Valley, City of 227 City 2 City Agency 2 http://www.cityofmillvalley.org/Index.aspx?page=416 City 2 1204 Mill Valley, City of 223 City 2 City Agency 2   Marin 23 1.834 Earnscliff Canyon Park 0 Local Park 2 4
758 758 757 {"type": "Polygon", "coordinates": [[[-122.55923, 37.90312], [-122.55909, 37.9032], [-122.55885, 37.90307], [-122.55846, 37.90316], [-122.55821, 37.90333], [-122.55809, 37.90333], [-122.5574, 37.9029], [-122.55707, 37.90266], [-122.5576, 37.90241], [-122.55842, 37.90238], [-122.55874, 37.90234], [-122.55897, 37.9025], [-122.5592, 37.90278], [-122.55923, 37.90312]]]} Open Access 1 4950 Watershed Lands 27306 2071 Marin Municipal Water District 254 Special District 4 Water District 13 http://www.marinwater.org/ Special District 4 2071 Marin Municipal Water District 250 Special District 4 Water District 13   Marin 23 3.312 Watershed Lands   None 70  
759 759 758 {"type": "Polygon", "coordinates": [[[-122.5442, 37.91301], [-122.54403, 37.91312], [-122.54383, 37.91293], [-122.54399, 37.91283], [-122.54405, 37.91288], [-122.54417, 37.91281], [-122.5442, 37.91301]]]} Open Access 1 4954 Watershed Lands 27306 2071 Marin Municipal Water District 254 Special District 4 Water District 13 http://www.marinwater.org/ Special District 4 2071 Marin Municipal Water District 250 Special District 4 Water District 13   Marin 23 0.152 Watershed Lands   None 71  
767 767 766 {"type": "Polygon", "coordinates": [[[-122.56127, 37.90272], [-122.56111, 37.90294], [-122.56104, 37.90321], [-122.56096, 37.90329], [-122.56054, 37.90341], [-122.56012, 37.90317], [-122.55964, 37.90307], [-122.55927, 37.90288], [-122.559, 37.9024], [-122.55868, 37.90221], [-122.55918, 37.90164], [-122.55976, 37.90179], [-122.55993, 37.90166], [-122.5605, 37.90225], [-122.56127, 37.90272]]]} Open Access 1 5001 Edgewood Park 18441 1204 Mill Valley, City of 227 City 2 City Agency 2 http://www.cityofmillvalley.org/Index.aspx?page=416 City 2 1204 Mill Valley, City of 223 City 2 City Agency 2   Marin 23 5.983 Edgewood Park 0 Local Park 2 4
769 769 768 {"type": "Polygon", "coordinates": [[[-122.54807, 37.9076], [-122.5477, 37.9077], [-122.54767, 37.90763], [-122.54751, 37.90744], [-122.54733, 37.90731], [-122.54718, 37.90725], [-122.54716, 37.90719], [-122.54716, 37.90716], [-122.54723, 37.90719], [-122.5476, 37.90693], [-122.54792, 37.90723], [-122.54807, 37.9076]]]} Open Access 1 5019 Mill Velley City Park 22237 1204 Mill Valley, City of 227 City 2 City Agency 2 http://www.cityofmillvalley.org/Index.aspx?page=416 City 2 1204 Mill Valley, City of 223 City 2 City Agency 2   Marin 23 0.821 Mill Velley City Park 0 Local Park 2 4
799 799 798 {"type": "MultiPolygon", "coordinates": [[[[-122.49991, 37.92691], [-122.49942, 37.92654], [-122.49818, 37.92572], [-122.49764, 37.92506], [-122.49509, 37.9251], [-122.49504, 37.92293], [-122.49312, 37.92144], [-122.49266, 37.92106], [-122.49265, 37.92043], [-122.49443, 37.92114], [-122.4948, 37.92124], [-122.49531, 37.9213], [-122.49545, 37.92131], [-122.49582, 37.92128], [-122.49619, 37.92123], [-122.49656, 37.92115], [-122.49691, 37.92104], [-122.4973, 37.92089], [-122.49736, 37.92428], [-122.49981, 37.92613], [-122.49991, 37.92691]]], [[[-122.50704, 37.92484], [-122.50678, 37.92501], [-122.50662, 37.92499], [-122.50631, 37.92523], [-122.5058, 37.92533], [-122.50532, 37.92522], [-122.50562, 37.92509], [-122.50587, 37.92491], [-122.50632, 37.9244], [-122.50704, 37.92484]]]]} No Public Access 3 5189 Triangle Marsh 26529 3039 Marin Audubon Society 261 Non Profit 6 Non Profit - Conservation 12 http://www.marinaudubon.org Non Governmental Organization 10 3039 Marin Audubon Society 257 Non Profit 6 Non Profit - Conservation 12   Marin 23 33.876 Triangle Marsh 1999 Private Conservation 16 2
842 842 841 {"type": "MultiPolygon", "coordinates": [[[[-122.54096, 37.90615], [-122.54093, 37.90638], [-122.54083, 37.90634], [-122.54085, 37.90616], [-122.54069, 37.90599], [-122.54027, 37.90594], [-122.54011, 37.90602], [-122.54012, 37.90627], [-122.53975, 37.9063], [-122.53916, 37.9065], [-122.53892, 37.90674], [-122.53856, 37.90649], [-122.53811, 37.90567], [-122.53785, 37.90537], [-122.53769, 37.90537], [-122.5378, 37.905], [-122.53838, 37.90496], [-122.53828, 37.90534], [-122.53841, 37.90535], [-122.53885, 37.90385], [-122.53915, 37.90385], [-122.53881, 37.90491], [-122.53912, 37.90581], [-122.5396, 37.90603], [-122.54025, 37.90584], [-122.54057, 37.90586], [-122.54058, 37.90588], [-122.54068, 37.90591], [-122.54079, 37.90589], [-122.54096, 37.90615]]], [[[-122.5387, 37.90385], [-122.53841, 37.90484], [-122.53787, 37.90489], [-122.53792, 37.90474], [-122.53795, 37.90454], [-122.53776, 37.90455], [-122.53771, 37.90435], [-122.53773, 37.90434], [-122.53778, 37.90453], [-122.53808, 37.9045], [-122.53808, 37.9044], [-122.53811, 37.90439], [-122.53807, 37.90384], [-122.5387, 37.90385]]]]} Open Access 1 4948 Boyle Park 16317 1204 Mill Valley, City of 227 City 2 City Agency 2 http://www.cityofmillvalley.org/Index.aspx?page=416 City 2 1204 Mill Valley, City of 223 City 2 City Agency 2   Marin 23 6.861 Boyle Park 0 Local Park 2 4
847 847 846 {"type": "Polygon", "coordinates": [[[-122.53111, 37.89916], [-122.53088, 37.89927], [-122.53057, 37.89945], [-122.53032, 37.89967], [-122.5302, 37.89979], [-122.53006, 37.89974], [-122.53013, 37.89958], [-122.53076, 37.89894], [-122.53111, 37.89916]]]} Open Access 1 4979 Freeman Park 19092 1204 Mill Valley, City of 227 City 2 City Agency 2 http://www.cityofmillvalley.org/Index.aspx?page=416 City 2 1204 Mill Valley, City of 223 City 2 City Agency 2   Marin 23 0.66 Freeman Park 0 Local Park 2 4
898 898 897 {"type": "Polygon", "coordinates": [[[-122.55026, 37.90193], [-122.54988, 37.90234], [-122.54978, 37.90226], [-122.54932, 37.90212], [-122.54961, 37.90158], [-122.5498, 37.90167], [-122.55001, 37.90147], [-122.55005, 37.90145], [-122.55026, 37.90161], [-122.55026, 37.90193]]]} Open Access 1 5020 Kathleen Norris Memorial Park 20558 1204 Mill Valley, City of 227 City 2 City Agency 2 http://www.cityofmillvalley.org/Index.aspx?page=416 City 2 1204 Mill Valley, City of 223 City 2 City Agency 2   Marin 23 1.194 Kathleen Norris Memorial Park 0 Local Park 2 4
1192 1192 1191 {"type": "MultiPolygon", "coordinates": [[[[-122.48372, 37.92711], [-122.47966, 37.92717], [-122.4794, 37.92537], [-122.48367, 37.9253], [-122.48372, 37.92711]]], [[[-122.49518, 37.92873], [-122.48832, 37.92884], [-122.48822, 37.92522], [-122.49509, 37.9251], [-122.49518, 37.92873]]], [[[-122.49976, 37.92865], [-122.49747, 37.92869], [-122.49739, 37.92507], [-122.49764, 37.92506], [-122.49818, 37.92572], [-122.49942, 37.92654], [-122.49972, 37.92677], [-122.49976, 37.92865]]]]} Open Access 1 6910 Water Lots 27294 2070 Marin County Open Space District 44 Special District 4 Recreation/Parks District 4 http://www.marincountyparks.org/Depts/PK.aspx Special District 4 2070 Marin County Open Space District 43 Special District 4 Recreation/Parks District 4   Marin 23 93.387 Water Lots 0 Local Other or Unknown 14 4
1349 1349 1348 {"type": "Polygon", "coordinates": [[[-122.53016, 37.96819], [-122.53012, 37.96849], [-122.52961, 37.96844], [-122.52958, 37.96857], [-122.52959, 37.96858], [-122.5301, 37.96863], [-122.5299, 37.96998], [-122.52887, 37.96988], [-122.52883, 37.9701], [-122.52651, 37.96875], [-122.52664, 37.96792], [-122.52781, 37.96801], [-122.52783, 37.96793], [-122.53016, 37.96819]]]} Open Access 1 7681 Albert Park 15338 1312 San Rafael, City of 352 City 2 City Agency 2 http://www.cityofsanrafael.org/comsvcs-home/ City 2 1312 San Rafael, City of 349 City 2 City Agency 2   Marin 23 13.115 Albert Park 0 Local Park 2 4
1642 1642 1641 {"type": "MultiPolygon", "coordinates": [[[[-122.91501, 38.23223], [-122.91436, 38.23304], [-122.91323, 38.23292], [-122.91298, 38.23269], [-122.91332, 38.23235], [-122.91362, 38.23199], [-122.91396, 38.23141], [-122.91403, 38.23117], [-122.91417, 38.23093], [-122.91444, 38.23065], [-122.91472, 38.2304], [-122.91498, 38.23013], [-122.91479, 38.23083], [-122.91501, 38.23223]]], [[[-122.92228, 38.22119], [-122.92219, 38.22138], [-122.9222, 38.2214], [-122.92205, 38.22171], [-122.921, 38.22207], [-122.92063, 38.22229], [-122.91984, 38.22279], [-122.9192, 38.22313], [-122.91832, 38.22349], [-122.91766, 38.22384], [-122.9169, 38.22438], [-122.91676, 38.22491], [-122.91692, 38.22544], [-122.91697, 38.2261], [-122.91706, 38.22669], [-122.9171, 38.22705], [-122.91691, 38.22739], [-122.9167, 38.22796], [-122.91636, 38.22833], [-122.91608, 38.22869], [-122.9155, 38.22952], [-122.91512, 38.22995], [-122.91571, 38.22916], [-122.91592, 38.2289], [-122.91618, 38.22848], [-122.91635, 38.22809], [-122.91629, 38.22676], [-122.91608, 38.22537], [-122.91611, 38.22521], [-122.91622, 38.22491], [-122.91629, 38.22477], [-122.91649, 38.22449], [-122.91673, 38.22425], [-122.91702, 38.22406], [-122.91779, 38.22361], [-122.91846, 38.22313], [-122.91928, 38.22288], [-122.9198, 38.22249], [-122.92014, 38.22228], [-122.92196, 38.22151], [-122.92215, 38.22137], [-122.92228, 38.22119]]]]} Open Access 1 1917 Keys Creek Fishing Access 32194 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/ California Department of Fish and Wildlife 6 201 California Department of Fish and Wildlife 25 State 5 State Agency 5   Marin 23 15.8 Keys Creek FA 0 State Recreation Area 39 4
1845 1845 1844 {"type": "Polygon", "coordinates": [[[-122.50067, 37.9218], [-122.49945, 37.92181], [-122.49936, 37.9201], [-122.50047, 37.91971], [-122.50066, 37.92009], [-122.50067, 37.9218]]]} Open Access 1 14087 San Clemente Park 24850 1070 Corte Madera, Town of 431 City 2 City Agency 2 http://www.ci.corte-madera.ca.us/199/Parks-Recreation City 2 1070 Corte Madera, Town of 425 City 2 City Agency 2   Marin 23 5.785 San Clemente Park 0 Local Park 2 4
1863 1863 1862 {"type": "MultiPolygon", "coordinates": [[[[-122.58022, 37.98301], [-122.58014, 37.98311], [-122.57993, 37.98309], [-122.57917, 37.98294], [-122.57907, 37.98292], [-122.57872, 37.98261], [-122.57838, 37.98254], [-122.57833, 37.98259], [-122.57821, 37.98251], [-122.5781, 37.98251], [-122.57801, 37.9826], [-122.57779, 37.98246], [-122.57791, 37.98233], [-122.57834, 37.98228], [-122.57848, 37.98228], [-122.57864, 37.98235], [-122.57887, 37.98237], [-122.57877, 37.98255], [-122.57895, 37.98269], [-122.57906, 37.98272], [-122.57908, 37.98268], [-122.5792, 37.98277], [-122.57919, 37.98281], [-122.57933, 37.98285], [-122.57947, 37.98287], [-122.57953, 37.98292], [-122.58022, 37.98301]]], [[[-122.57817, 37.98218], [-122.57799, 37.9822], [-122.5779, 37.98195], [-122.57804, 37.98182], [-122.57817, 37.98218]]]]} Open Access 1 14215 Lansdale Park 21015 1292 San Anselmo, City of 437 City 2 City Agency 2 http://www.townofsananselmo.org/index.aspx?nid=106 City 2 1292 San Anselmo, City of 431 City 2 City Agency 2   Marin 23 1.158 Lansdale Park 0 Local Park 2 4
1873 1873 1872 {"type": "Polygon", "coordinates": [[[-122.46707, 37.88146], [-122.46653, 37.88124], [-122.46589, 37.88087], [-122.46559, 37.88065], [-122.46532, 37.88041], [-122.46513, 37.88021], [-122.46483, 37.87984], [-122.46419, 37.87897], [-122.46388, 37.87861], [-122.46349, 37.87828], [-122.4633, 37.87796], [-122.46307, 37.87767], [-122.46282, 37.87739], [-122.46263, 37.87722], [-122.46342, 37.87788], [-122.46385, 37.87832], [-122.46603, 37.88068], [-122.46632, 37.88098], [-122.46669, 37.88126], [-122.46707, 37.88146]]]} Open Access 1 16022 Belvedere Lands 004 15999 1026 Belvedere, City of 443 City 2 City Agency 2 http://www.cityofbelvedere.org/ City 2 1026 Belvedere, City of 437 City 2 City Agency 2   Marin 23 2.781 Belvedere Lands 004   None 152  

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