units_with_maps

Table actions

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

24 rows where COUNTY = 24 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 24 ✖

ACCESS_TYP 1

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
3052 3052 3051 {"type": "Polygon", "coordinates": [[[-123.35231, 39.41342], [-123.35228, 39.41253], [-123.35322, 39.41253], [-123.35324, 39.41254], [-123.35326, 39.41341], [-123.35233, 39.41343], [-123.35231, 39.41342]]]} Open Access 1 24553 Willits City Park 27571 1414 Willits, City of 578 City 2 City Agency 2 http://thecityofwillits.com/ City 2 1414 Willits, City of 570 City 2 City Agency 2   Mendocino 24 2.013 Willits City Park 0 Local Park 2 4
4788 4788 4787 {"type": "Polygon", "coordinates": [[[-123.69419, 38.90966], [-123.69413, 38.91095], [-123.69408, 38.91142], [-123.69342, 38.91138], [-123.69342, 38.91022], [-123.69387, 38.91002], [-123.69374, 38.90991], [-123.69342, 38.90992], [-123.69342, 38.9096], [-123.69319, 38.9096], [-123.69319, 38.90939], [-123.69351, 38.90939], [-123.69352, 38.90931], [-123.69407, 38.90932], [-123.69406, 38.90939], [-123.69388, 38.90964], [-123.69419, 38.90966]]]} Open Access 1 48100 Unnamed site - Point Arena, City of 32605 1697 Point Arena, City of 781 City 2 City Agency 2 http://www.cityofpointarena.com/ City 2 1697 Point Arena, City of 761 City 2 City Agency 2   Mendocino 24 3.377   0 Local Other or Unknown 14 4
5143 5143 5142 {"type": "Polygon", "coordinates": [[[-123.21229, 39.1384], [-123.21159, 39.13851], [-123.21138, 39.13701], [-123.21209, 39.1369], [-123.21229, 39.1384]]]} Open Access 1 44983 Observatory Park Trail 23046 1413 Ukiah, City of 796 City 2 City Agency 2 http://www.cityofukiah.com/recreation/ City 2 1413 Ukiah, City of 776 City 2 City Agency 2   Mendocino 24 2.559 Observatory Park Trail 0 Local Recreation Area 3 4
8290 8290 8289 {"type": "Polygon", "coordinates": [[[-123.81691, 39.44486], [-123.81691, 39.44495], [-123.81682, 39.44505], [-123.8167, 39.44512], [-123.81643, 39.44514], [-123.81629, 39.44522], [-123.81621, 39.44518], [-123.81615, 39.44522], [-123.81615, 39.44529], [-123.81603, 39.44532], [-123.81582, 39.44532], [-123.81562, 39.44537], [-123.81547, 39.44547], [-123.81522, 39.44569], [-123.81502, 39.44595], [-123.81492, 39.44597], [-123.8148, 39.44605], [-123.81475, 39.44615], [-123.81477, 39.44629], [-123.81473, 39.44649], [-123.81461, 39.44674], [-123.8146, 39.44697], [-123.81469, 39.44717], [-123.81462, 39.44726], [-123.8146, 39.44739], [-123.81469, 39.44747], [-123.81473, 39.44759], [-123.81487, 39.44773], [-123.81482, 39.44789], [-123.81478, 39.44796], [-123.8147, 39.44803], [-123.81458, 39.44803], [-123.81444, 39.44808], [-123.81423, 39.4481], [-123.81411, 39.44813], [-123.814, 39.44824], [-123.8139, 39.44828], [-123.81379, 39.44836], [-123.8137, 39.44859], [-123.81368, 39.44874], [-123.81363, 39.44887], [-123.81364, 39.44896], [-123.81367, 39.44904], [-123.81366, 39.44912], [-123.81368, 39.44929], [-123.81379, 39.44944], [-123.81375, 39.44953], [-123.81355, 39.44965], [-123.81349, 39.44975], [-123.81359, 39.44987], [-123.81367, 39.44994], [-123.8137, 39.45], [-123.81368, 39.45008], [-123.81357, 39.45018], [-123.81355, 39.45026], [-123.81358, 39.45036], [-123.81377, 39.45049], [-123.81407, 39.45056], [-123.81414, 39.45061], [-123.81418, 39.45068], [-123.81418, 39.45081], [-123.81424, 39.45096], [-123.81446, 39.45108], [-123.81455, 39.45116], [-123.81462, 39.45125], [-123.8146, 39.45136], [-123.8144, 39.45147], [-123.81433, 39.45141], [-123.81427, 39.45144], [-123.81429, 39.45153], [-123.81414, 39.4516], [-123.81409, 39.45166], [-123.81409, 39.4518], [-123.81196, 39.45181], [-123.81194, 39.45136], [-123.81215, 39.45107], [-123.81219, 39.45059], [-123.81295, 39.44915], [-123.81293, 39.44884], [-123.81314, 39.4482], [-123.81399, 39.44758], [-123.81393, 39.44708], [-123.81383, 39.4469], [-123.81373, 39.44625], [-123.81385, 39.44518], [-123.81357, 39.44448], [-123.81249, 39.44354], [-123.81338, 39.44314], [-123.81371, 39.44333], [-123.81397, 39.44352], [-123.81408, 39.44355], [-123.81429, 39.44356], [-123.81447, 39.44347], [-123.81447, 39.4435], [-123.81449, 39.44352], [-123.81451, 39.44356], [-123.81455, 39.44356], [-123.81467, 39.44363], [-123.81474, 39.44359], [-123.81474, 39.44358], [-123.81472, 39.44354], [-123.81463, 39.44349], [-123.81456, 39.44342], [-123.81461, 39.44341], [-123.81487, 39.44345], [-123.81494, 39.44351], [-123.81493, 39.44356], [-123.81496, 39.4436], [-123.81495, 39.44366], [-123.81489, 39.44378], [-123.81478, 39.44383], [-123.81477, 39.44376], [-123.81474, 39.44374], [-123.81466, 39.44379], [-123.81465, 39.44383], [-123.81466, 39.44388], [-123.81474, 39.44387], [-123.81471, 39.44393], [-123.8147, 39.44407], [-123.81476, 39.4442], [-123.81483, 39.44429], [-123.81497, 39.44432], [-123.81509, 39.4443], [-123.81515, 39.44426], [-123.81519, 39.44428], [-123.81535, 39.44425], [-123.81537, 39.4442], [-123.81539, 39.4442], [-123.81553, 39.44426], [-123.81568, 39.44453], [-123.81582, 39.44458], [-123.81582, 39.44461], [-123.81588, 39.44461], [-123.81592, 39.44459], [-123.81609, 39.44455], [-123.81624, 39.44458], [-123.81635, 39.44464], [-123.81641, 39.44472], [-123.81659, 39.44483], [-123.8167, 39.44485], [-123.81673, 39.44491], [-123.81683, 39.44491], [-123.81683, 39.44485], [-123.81691, 39.44486]], [[-123.81462, 39.44378], [-123.81463, 39.4437], [-123.81446, 39.44367], [-123.81443, 39.44362], [-123.81437, 39.44363], [-123.81436, 39.4437], [-123.81436, 39.44374], [-123.81442, 39.44381], [-123.81455, 39.44384], [-123.8146, 39.44381], [-123.81462, 39.44378]], [[-123.81474, 39.44418], [-123.81468, 39.44415], [-123.81461, 39.44417], [-123.81461, 39.44425], [-123.81471, 39.44428], [-123.81475, 39.44422], [-123.81474, 39.44418]], [[-123.81479, 39.44368], [-123.81483, 39.44371], [-123.81489, 39.4437], [-123.81491, 39.44367], [-123.81487, 39.44362], [-123.81484, 39.44361], [-123.8148, 39.44362], [-123.81478, 39.44365], [-123.81479, 39.44368]], [[-123.81529, 39.44441], [-123.81527, 39.44435], [-123.81523, 39.44434], [-123.81514, 39.44437], [-123.81513, 39.44444], [-123.81517, 39.44447], [-123.81525, 39.44447], [-123.8153, 39.44444], [-123.81529, 39.44441]]]} Open Access 1 47780 Fort Bragg Coastal Park 19005 1412 Fort Bragg, City of 889 City 2 City Agency 2 http://city.fortbragg.com/ City 2 1412 Fort Bragg, City of 864 City 2 City Agency 2 http://www.parks.ca.gov/?page_id=26445 Mendocino 24 29.199 Fort Bragg Coastal Park 2015 Local Park 2 4
10425 10425 10424 {"type": "Polygon", "coordinates": [[[-123.35091, 39.39959], [-123.35091, 39.39959], [-123.34977, 39.40072], [-123.34971, 39.3996], [-123.35091, 39.39959]]]} Open Access 1 24768 Babcock Park 15744 1414 Willits, City of 578 City 2 City Agency 2 http://thecityofwillits.com/ City 2 1414 Willits, City of 570 City 2 City Agency 2   Mendocino 24 1.603 Babcock Park 0 Local Park 2 4
11412 11412 11411 {"type": "Polygon", "coordinates": [[[-123.69388, 38.91003], [-123.69342, 38.91022], [-123.69342, 38.91022], [-123.69342, 38.90992], [-123.69374, 38.90991], [-123.69388, 38.91003]]]} Open Access 1 48101 Fisherman's Playground 32606 1697 Point Arena, City of 781 City 2 City Agency 2 http://www.cityofpointarena.com/ City 2 1697 Point Arena, City of 761 City 2 City Agency 2 https://pointarena.ca.gov/government/departments/parks-streets/ Mendocino 24 0.214 Fisherman's Playground 0 Local Recreation Area 3 4
11413 11413 11412 {"type": "Polygon", "coordinates": [[[-123.6942, 38.90931], [-123.69419, 38.90966], [-123.69387, 38.90965], [-123.69406, 38.9094], [-123.69407, 38.90932], [-123.6942, 38.90931]]]} Open Access 1 48102 Point Arena Community Garden 32607 1697 Point Arena, City of 781 City 2 City Agency 2 http://www.cityofpointarena.com/ City 2 1697 Point Arena, City of 761 City 2 City Agency 2 https://pointarena.ca.gov/government/departments/parks-streets/ Mendocino 24 0.169 Point Arena Community Garden 0 Local Park 2 4
11414 11414 11413 {"type": "Polygon", "coordinates": [[[-123.69313, 38.90955], [-123.69313, 38.90959], [-123.69252, 38.90959], [-123.69252, 38.90945], [-123.69283, 38.90945], [-123.69283, 38.90955], [-123.69313, 38.90955]]]} Open Access 1 48103 Centennial Plaza Memorial Garden 32608 1697 Point Arena, City of 781 City 2 City Agency 2 http://www.cityofpointarena.com/ City 2 1697 Point Arena, City of 761 City 2 City Agency 2   Mendocino 24 0.139 Centennial Plaza Memorial Garden 0 Local Park 2 4
11500 11500 11499 {"type": "Polygon", "coordinates": [[[-123.70998, 38.91406], [-123.71015, 38.91456], [-123.71027, 38.91481], [-123.70981, 38.91483], [-123.7099, 38.91463], [-123.70916, 38.91441], [-123.70848, 38.91412], [-123.70852, 38.91404], [-123.70852, 38.91403], [-123.70629, 38.91322], [-123.70628, 38.91295], [-123.70876, 38.91318], [-123.70976, 38.91348], [-123.70998, 38.91406]]]} Open Access 1 48188 Point Arena Cove & Fishing Pier 32724 1697 Point Arena, City of 781 City 2 City Agency 2 http://www.cityofpointarena.com/ City 2 1697 Point Arena, City of 761 City 2 City Agency 2 https://www.mendocino.com/?id=3423&url= Mendocino 24 6.991 Point Arena Cove & Fishing Pier 0 None 1022  
11932 11932 11931 {"type": "Polygon", "coordinates": [[[-123.22308, 39.15217], [-123.22221, 39.15218], [-123.22214, 39.15121], [-123.22179, 39.15122], [-123.22179, 39.1513], [-123.2213, 39.15129], [-123.22064, 39.15207], [-123.22029, 39.15192], [-123.22076, 39.15107], [-123.22095, 39.15112], [-123.2211, 39.15084], [-123.2211, 39.15083], [-123.22067, 39.15069], [-123.22112, 39.15002], [-123.22208, 39.14999], [-123.22215, 39.14955], [-123.22223, 39.14958], [-123.22224, 39.14953], [-123.22226, 39.14954], [-123.22231, 39.1496], [-123.22235, 39.1496], [-123.22236, 39.14972], [-123.22272, 39.14973], [-123.22283, 39.14978], [-123.22302, 39.14976], [-123.22298, 39.14998], [-123.22307, 39.14999], [-123.22312, 39.15119], [-123.22308, 39.15217]]]} Open Access 1 24546 Giorno Park/Anton Stadium 19301 1413 Ukiah, City of 796 City 2 City Agency 2 http://www.cityofukiah.com/recreation/ City 2 1413 Ukiah, City of 776 City 2 City Agency 2   Mendocino 24 10.198 Giorno Park/Anton Stadium   None 1049  
11933 11933 11932 {"type": "Polygon", "coordinates": [[[-123.21197, 39.1479], [-123.21127, 39.14804], [-123.21114, 39.1475], [-123.21183, 39.14738], [-123.21197, 39.1479]]]} Open Access 1 24547 McGarvey Park 22032 1413 Ukiah, City of 796 City 2 City Agency 2 http://www.cityofukiah.com/recreation/ City 2 1413 Ukiah, City of 776 City 2 City Agency 2   Mendocino 24 0.926 McGarvey Park 0 Local Park 2 4
11934 11934 11933 {"type": "Polygon", "coordinates": [[[-123.19386, 39.14724], [-123.19337, 39.14723], [-123.19227, 39.14734], [-123.19201, 39.14546], [-123.19224, 39.14543], [-123.19277, 39.14585], [-123.19307, 39.14606], [-123.19316, 39.14619], [-123.19357, 39.14691], [-123.19386, 39.14724]]]} Open Access 1 24548 Oak Manor Park 22986 1413 Ukiah, City of 796 City 2 City Agency 2 http://www.cityofukiah.com/recreation/ City 2 1413 Ukiah, City of 776 City 2 City Agency 2   Mendocino 24 4.526 Oak Manor Park 0 Local Park 2 4
11935 11935 11934 {"type": "Polygon", "coordinates": [[[-123.22136, 39.15252], [-123.22095, 39.15405], [-123.22088, 39.15409], [-123.22035, 39.15418], [-123.21818, 39.15212], [-123.21982, 39.15189], [-123.22136, 39.15252]]]} Open Access 1 24549 Todd Grove Park 26383 1413 Ukiah, City of 796 City 2 City Agency 2 http://www.cityofukiah.com/recreation/ City 2 1413 Ukiah, City of 776 City 2 City Agency 2   Mendocino 24 9.42 Todd Grove Park 0 Local Park 2 4
11936 11936 11935 {"type": "Polygon", "coordinates": [[[-123.19803, 39.16147], [-123.19777, 39.16132], [-123.19706, 39.16098], [-123.19584, 39.16063], [-123.19504, 39.16045], [-123.19363, 39.1604], [-123.19299, 39.15994], [-123.19205, 39.15918], [-123.19305, 39.15931], [-123.19354, 39.15926], [-123.19472, 39.15902], [-123.19543, 39.15884], [-123.19602, 39.15882], [-123.19676, 39.15886], [-123.1977, 39.15864], [-123.19794, 39.1595], [-123.19776, 39.15951], [-123.19793, 39.16065], [-123.198, 39.16129], [-123.19803, 39.16147]]]} Open Access 1 24550 Ukiah Softball Complex 26646 1413 Ukiah, City of 796 City 2 City Agency 2 http://www.cityofukiah.com/recreation/ City 2 1413 Ukiah, City of 776 City 2 City Agency 2   Mendocino 24 20.165 Ukiah Softball Complex 0 Local Recreation Area 3 4
11937 11937 11936 {"type": "Polygon", "coordinates": [[[-123.21346, 39.16223], [-123.21127, 39.16243], [-123.21123, 39.16233], [-123.21122, 39.1622], [-123.21148, 39.16163], [-123.21151, 39.16146], [-123.21148, 39.16135], [-123.21291, 39.16125], [-123.21309, 39.16122], [-123.21346, 39.16223]]]} Open Access 1 24551 Vinewood Park 27133 1413 Ukiah, City of 796 City 2 City Agency 2 http://www.cityofukiah.com/recreation/ City 2 1413 Ukiah, City of 776 City 2 City Agency 2   Mendocino 24 4.763 Vinewood Park 0 Local Park 2 4
12219 12219 12218 {"type": "Polygon", "coordinates": [[[-123.79557, 39.44475], [-123.79553, 39.44475], [-123.79546, 39.44488], [-123.79492, 39.44513], [-123.79494, 39.4454], [-123.79333, 39.4454], [-123.79327, 39.4443], [-123.79328, 39.44402], [-123.79347, 39.44402], [-123.79348, 39.44405], [-123.79384, 39.44405], [-123.79385, 39.4441], [-123.79413, 39.44409], [-123.79414, 39.44415], [-123.79491, 39.44414], [-123.79491, 39.44408], [-123.79531, 39.44407], [-123.79532, 39.4442], [-123.79557, 39.4442], [-123.79557, 39.44475]]]} Open Access 1 25413 Otis R. Johnson Wilderness Park 23267 1412 Fort Bragg, City of 889 City 2 City Agency 2 http://city.fortbragg.com/ City 2 1412 Fort Bragg, City of 864 City 2 City Agency 2   Mendocino 24 6.276 Otis R. Johnson Wilderness Park 0 Local Conservation Area 4 2
12220 12220 12219 {"type": "MultiPolygon", "coordinates": [[[[-123.80138, 39.44472], [-123.80137, 39.44512], [-123.80131, 39.44513], [-123.80131, 39.4454], [-123.80084, 39.44539], [-123.80084, 39.44471], [-123.80138, 39.44472]]], [[[-123.80198, 39.44513], [-123.80197, 39.44541], [-123.80171, 39.4454], [-123.80171, 39.44513], [-123.80144, 39.44513], [-123.80145, 39.44472], [-123.80197, 39.4447], [-123.80198, 39.44513]]]]} Open Access 1 25414 Harold O. Bainbridge Park 19685 1412 Fort Bragg, City of 889 City 2 City Agency 2 http://city.fortbragg.com/ City 2 1412 Fort Bragg, City of 864 City 2 City Agency 2   Mendocino 24 1.529 Harold O. Bainbridge Park 0 Local Park 2 4
12221 12221 12220 {"type": "Polygon", "coordinates": [[[-123.8191, 39.42406], [-123.81909, 39.42415], [-123.81893, 39.42425], [-123.81872, 39.42428], [-123.81865, 39.4243], [-123.81859, 39.42437], [-123.81815, 39.42445], [-123.81804, 39.42444], [-123.81784, 39.4245], [-123.81769, 39.42453], [-123.81763, 39.42458], [-123.81766, 39.42462], [-123.81776, 39.42466], [-123.81791, 39.4247], [-123.81796, 39.42476], [-123.81784, 39.42487], [-123.81778, 39.42491], [-123.81778, 39.42498], [-123.81787, 39.425], [-123.81843, 39.42501], [-123.81859, 39.42505], [-123.81867, 39.4251], [-123.81867, 39.4252], [-123.81863, 39.42524], [-123.81859, 39.42534], [-123.81869, 39.4254], [-123.81873, 39.42543], [-123.81872, 39.42554], [-123.81858, 39.42558], [-123.81845, 39.42558], [-123.81836, 39.42564], [-123.81825, 39.42568], [-123.818, 39.42566], [-123.81781, 39.42571], [-123.81759, 39.42574], [-123.81739, 39.42574], [-123.81708, 39.42565], [-123.81693, 39.42566], [-123.81683, 39.42573], [-123.81688, 39.42583], [-123.81693, 39.4259], [-123.81692, 39.42594], [-123.81694, 39.426], [-123.81702, 39.4261], [-123.81702, 39.42617], [-123.81682, 39.42619], [-123.81648, 39.4262], [-123.81624, 39.42612], [-123.81598, 39.4259], [-123.81585, 39.42588], [-123.81572, 39.42575], [-123.81561, 39.42571], [-123.81526, 39.42571], [-123.81508, 39.42569], [-123.81481, 39.42574], [-123.81443, 39.42568], [-123.81427, 39.42561], [-123.81416, 39.42557], [-123.81401, 39.42557], [-123.8136, 39.42561], [-123.81329, 39.42567], [-123.81307, 39.4257], [-123.81265, 39.42581], [-123.81222, 39.42598], [-123.81195, 39.42604], [-123.81182, 39.42609], [-123.81142, 39.42611], [-123.81126, 39.42614], [-123.811, 39.42621], [-123.81078, 39.42622], [-123.81061, 39.42619], [-123.81044, 39.4262], [-123.81031, 39.42626], [-123.81023, 39.42634], [-123.81011, 39.42645], [-123.80997, 39.42666], [-123.80988, 39.42686], [-123.80966, 39.4271], [-123.80958, 39.42728], [-123.80946, 39.42733], [-123.80925, 39.42729], [-123.80904, 39.42722], [-123.8088, 39.42716], [-123.80879, 39.42618], [-123.80895, 39.42616], [-123.80933, 39.42618], [-123.80933, 39.4259], [-123.80964, 39.4259], [-123.80961, 39.42563], [-123.81037, 39.42562], [-123.81036, 39.42539], [-123.81174, 39.42535], [-123.81176, 39.42507], [-123.81213, 39.42505], [-123.81692, 39.42499], [-123.81695, 39.42417], [-123.81694, 39.42355], [-123.81732, 39.42362], [-123.81752, 39.4237], [-123.81777, 39.42374], [-123.8182, 39.42378], [-123.81838, 39.42384], [-123.81855, 39.42385], [-123.81877, 39.4238], [-123.81886, 39.42387], [-123.81893, 39.42394], [-123.81902, 39.42398], [-123.8191, 39.42406]]]} Open Access 1 25415 Pomo Bluffs Park 23879 1412 Fort Bragg, City of 889 City 2 City Agency 2 http://city.fortbragg.com/ City 2 1412 Fort Bragg, City of 864 City 2 City Agency 2   Mendocino 24 23.606 Pomo Bluffs Park 0 Local Park 2 4
14231 14231 14230 {"type": "Polygon", "coordinates": [[[-123.20606, 39.14817], [-123.20523, 39.14828], [-123.20523, 39.14823], [-123.20524, 39.14815], [-123.20521, 39.14809], [-123.20506, 39.14793], [-123.20522, 39.1479], [-123.20523, 39.14774], [-123.20532, 39.14765], [-123.20544, 39.14767], [-123.20548, 39.14771], [-123.20592, 39.14763], [-123.20606, 39.14817]]]} Open Access 1 48853 Hudson-Carpenter Park 33573 1413 Ukiah, City of 796 City 2 City Agency 2 http://www.cityofukiah.com/recreation/ City 2 1413 Ukiah, City of 776 City 2 City Agency 2 https://www.cityofukiah.com/parks-facilities/ Mendocino 24 1.056 Hudson-Carpenter Park 0 Local Park 2 4
14250 14250 14249 {"type": "Polygon", "coordinates": [[[-123.18507, 39.14617], [-123.18355, 39.14629], [-123.18334, 39.14633], [-123.18285, 39.14639], [-123.18261, 39.1464], [-123.18255, 39.14638], [-123.18247, 39.14631], [-123.18244, 39.14618], [-123.18243, 39.14541], [-123.18235, 39.14482], [-123.18242, 39.14451], [-123.1826, 39.14446], [-123.18327, 39.14459], [-123.18469, 39.14438], [-123.18482, 39.14492], [-123.18507, 39.14617]]]} Open Access 1 48854 Riverside Park 33574 1413 Ukiah, City of 796 City 2 City Agency 2 http://www.cityofukiah.com/recreation/ City 2 1413 Ukiah, City of 776 City 2 City Agency 2 https://www.cityofukiah.com/parks-facilities/ Mendocino 24 10.577 Riverside Park 0 Local Park 2 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]);