units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
95 rows where MNG_AGENCY = 14 sorted by ACRES descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6531 | 6531 | 6530 | {"type": "MultiPolygon", "coordinates": [[[[-119.77984, 36.87156], [-119.77966, 36.87362], [-119.77899, 36.87362], [-119.77909, 36.87304], [-119.77923, 36.8718], [-119.77984, 36.87156]]], [[[-119.77985, 36.8713], [-119.77924, 36.87154], [-119.77958, 36.86783], [-119.77973, 36.86805], [-119.77993, 36.8686], [-119.77999, 36.86929], [-119.77985, 36.8713]]], [[[-119.79146, 36.87061], [-119.78963, 36.87074], [-119.78963, 36.87116], [-119.78948, 36.87117], [-119.78764, 36.8717], [-119.78655, 36.87182], [-119.78507, 36.87095], [-119.78472, 36.87079], [-119.78321, 36.87199], [-119.78336, 36.8725], [-119.78317, 36.87293], [-119.78262, 36.87323], [-119.78149, 36.87337], [-119.78108, 36.87363], [-119.77986, 36.87363], [-119.78006, 36.87141], [-119.78019, 36.86928], [-119.78012, 36.86857], [-119.77992, 36.868], [-119.77961, 36.86751], [-119.77973, 36.86629], [-119.77997, 36.86552], [-119.78036, 36.86468], [-119.78061, 36.86427], [-119.7828, 36.86076], [-119.78288, 36.86073], [-119.78347, 36.86095], [-119.78398, 36.86117], [-119.78432, 36.86127], [-119.78469, 36.86134], [-119.78481, 36.86134], [-119.78498, 36.86136], [-119.78531, 36.86136], [-119.78674, 36.86118], [-119.78719, 36.86116], [-119.78817, 36.86119], [-119.78935, 36.86117], [-119.79014, 36.86126], [-119.79103, 36.86126], [-119.7911, 36.86129], [-119.79113, 36.86134], [-119.79118, 36.86235], [-119.79119, 36.8629], [-119.7914, 36.86729], [-119.79136, 36.87004], [-119.79125, 36.87043], [-119.7913, 36.87054], [-119.79146, 36.87061]]]]} | Open Access 1 | 2849 | Woodward Regional Park | 3935 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/government/departmentdirectory/parksandrecreation/parksandfacilities/regional+parks/woodwardpark.htm | Fresno 9 | 290.772 | Woodward RP | 0 | Local Park 2 | 4 |
3952 | 3952 | 3951 | {"type": "Polygon", "coordinates": [[[-119.83147, 36.70554], [-119.83023, 36.70554], [-119.83022, 36.70578], [-119.82573, 36.70578], [-119.8257, 36.69951], [-119.82599, 36.69934], [-119.82601, 36.69581], [-119.82675, 36.6958], [-119.82675, 36.69228], [-119.82703, 36.69232], [-119.82914, 36.69231], [-119.82914, 36.69402], [-119.83132, 36.69402], [-119.83133, 36.70305], [-119.83147, 36.70306], [-119.83147, 36.70554]]]} | Open Access 1 | 1125 | Jensen-West Regional Park | 20394 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 164.801 | Jensen-West RP | 0 | Local Park 2 | 4 | |
501 | 501 | 500 | {"type": "Polygon", "coordinates": [[[-119.82816, 36.75561], [-119.82654, 36.75563], [-119.82655, 36.75724], [-119.82652, 36.75731], [-119.82644, 36.75736], [-119.82178, 36.75742], [-119.81757, 36.7535], [-119.81589, 36.75199], [-119.81569, 36.75175], [-119.81557, 36.75157], [-119.81551, 36.75137], [-119.81553, 36.75121], [-119.81561, 36.75107], [-119.8158, 36.75094], [-119.8159, 36.75082], [-119.81596, 36.75072], [-119.816, 36.75057], [-119.81604, 36.7505], [-119.81612, 36.75045], [-119.81624, 36.75042], [-119.81624, 36.75039], [-119.82394, 36.75033], [-119.82395, 36.75035], [-119.82412, 36.75037], [-119.8243, 36.75041], [-119.82446, 36.75049], [-119.82463, 36.75061], [-119.82561, 36.75163], [-119.82719, 36.7537], [-119.82734, 36.75394], [-119.82816, 36.75561]]]} | Open Access 1 | 2033 | Roeding Park | 24557 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 144.652 | Roeding Park | 0 | Local Park 2 | 4 | |
15707 | 15707 | 15706 | {"type": "Polygon", "coordinates": [[[-119.71112, 36.77661], [-119.71034, 36.77693], [-119.71087, 36.77789], [-119.7109, 36.77817], [-119.71106, 36.77893], [-119.71107, 36.77916], [-119.71098, 36.77922], [-119.71095, 36.7793], [-119.70509, 36.77924], [-119.70404, 36.77885], [-119.70354, 36.77875], [-119.70312, 36.77872], [-119.70259, 36.77873], [-119.70203, 36.77891], [-119.70122, 36.77919], [-119.70095, 36.77921], [-119.7011, 36.77741], [-119.70133, 36.77645], [-119.70172, 36.77585], [-119.7019, 36.7757], [-119.70334, 36.77575], [-119.70395, 36.77575], [-119.70417, 36.77573], [-119.7044, 36.77567], [-119.7046, 36.77557], [-119.70476, 36.77545], [-119.70509, 36.77507], [-119.70515, 36.77506], [-119.70642, 36.77578], [-119.70767, 36.77435], [-119.70773, 36.77432], [-119.7078, 36.77432], [-119.70787, 36.77434], [-119.70931, 36.77518], [-119.71086, 36.77614], [-119.71112, 36.77661]]]} | Restricted Access 2 | 25456 | Airways Municipal Golf Course | 33086 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 88.161 | Airways Municipal GC | 0 | Local Recreation Area 3 | 4 | |
16845 | 16845 | 16844 | {"type": "Polygon", "coordinates": [[[-119.83569, 36.69941], [-119.83184, 36.69942], [-119.83183, 36.69403], [-119.83132, 36.69402], [-119.83132, 36.6923], [-119.83569, 36.69229], [-119.83569, 36.69941]]]} | Open Access 1 | 24165 | Regional Sports Park | 24277 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 69.372 | Reg. Sports Park | 0 | Local Recreation Area 3 | 4 | |
3519 | 3519 | 3518 | {"type": "Polygon", "coordinates": [[[-119.90601, 36.84991], [-119.90514, 36.85098], [-119.90334, 36.8516], [-119.89998, 36.85175], [-119.8968, 36.85271], [-119.8963, 36.85226], [-119.89313, 36.85186], [-119.89311, 36.85193], [-119.89311, 36.85227], [-119.89279, 36.85211], [-119.8925, 36.852], [-119.89239, 36.85197], [-119.89231, 36.85193], [-119.89166, 36.85179], [-119.89119, 36.85175], [-119.89085, 36.85175], [-119.89017, 36.85181], [-119.88985, 36.85188], [-119.88952, 36.85198], [-119.88916, 36.85211], [-119.88936, 36.85126], [-119.88934, 36.85125], [-119.88939, 36.851], [-119.89048, 36.85117], [-119.89102, 36.85119], [-119.89182, 36.85127], [-119.89197, 36.85126], [-119.89206, 36.8513], [-119.89216, 36.8513], [-119.89237, 36.85134], [-119.8925, 36.85132], [-119.89259, 36.85135], [-119.89281, 36.85138], [-119.893, 36.85138], [-119.8931, 36.85136], [-119.89311, 36.85138], [-119.89352, 36.85142], [-119.8942, 36.85139], [-119.89439, 36.85135], [-119.89457, 36.85124], [-119.89461, 36.85124], [-119.89479, 36.85133], [-119.89495, 36.85136], [-119.89599, 36.85117], [-119.89622, 36.8511], [-119.89647, 36.85107], [-119.89672, 36.851], [-119.8968, 36.85091], [-119.89685, 36.85089], [-119.89709, 36.85087], [-119.89718, 36.85083], [-119.89729, 36.85082], [-119.8974, 36.85077], [-119.89761, 36.85052], [-119.89793, 36.85047], [-119.89817, 36.85016], [-119.89815, 36.85013], [-119.89822, 36.85009], [-119.89888, 36.84987], [-119.89952, 36.84974], [-119.89995, 36.84962], [-119.90022, 36.84965], [-119.90068, 36.84957], [-119.90181, 36.84954], [-119.90254, 36.84948], [-119.90325, 36.84925], [-119.90334, 36.84931], [-119.90346, 36.84927], [-119.90349, 36.84934], [-119.90349, 36.8494], [-119.90346, 36.84947], [-119.90341, 36.84952], [-119.9029, 36.84981], [-119.90261, 36.84989], [-119.90094, 36.85005], [-119.90107, 36.85103], [-119.90151, 36.85099], [-119.90155, 36.85107], [-119.9025, 36.85122], [-119.90255, 36.85131], [-119.90264, 36.85128], [-119.90258, 36.85115], [-119.9016, 36.851], [-119.90159, 36.85098], [-119.90337, 36.85082], [-119.90449, 36.85024], [-119.90397, 36.84955], [-119.90351, 36.84925], [-119.90358, 36.84923], [-119.90444, 36.84977], [-119.90533, 36.84896], [-119.90567, 36.84919], [-119.90538, 36.8495], [-119.90601, 36.84991]]]} | Open Access 1 | 28049 | Riverbottom Park | 24437 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 49.154 | Riverbottom Park | 0 | Local Park 2 | 4 | |
481 | 481 | 480 | {"type": "Polygon", "coordinates": [[[-119.68579, 36.78219], [-119.68225, 36.78221], [-119.68223, 36.77949], [-119.68575, 36.77947], [-119.68579, 36.78219]]]} | Open Access 1 | 1650 | Melody Park | 22111 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 23.499 | Melody Park | 0 | Local Park 2 | 4 | |
6366 | 6366 | 6365 | {"type": "MultiPolygon", "coordinates": [[[[-119.78683, 36.85228], [-119.78498, 36.85367], [-119.7841, 36.85433], [-119.78406, 36.85412], [-119.78674, 36.85212], [-119.78683, 36.85228]]], [[[-119.78372, 36.85461], [-119.76849, 36.86602], [-119.76817, 36.86623], [-119.76778, 36.86623], [-119.76811, 36.86606], [-119.76841, 36.86586], [-119.78372, 36.85438], [-119.78372, 36.85461]]], [[[-119.76748, 36.86652], [-119.76705, 36.86663], [-119.7667, 36.86669], [-119.76634, 36.86671], [-119.7659, 36.86671], [-119.7659, 36.86654], [-119.76748, 36.86652]]], [[[-119.76569, 36.86671], [-119.75699, 36.86679], [-119.75698, 36.86662], [-119.76569, 36.86654], [-119.76569, 36.86671]]], [[[-119.75657, 36.86679], [-119.74799, 36.86687], [-119.74799, 36.86678], [-119.74786, 36.86677], [-119.74786, 36.86671], [-119.75512, 36.86667], [-119.75657, 36.86663], [-119.75657, 36.86679]]], [[[-119.74761, 36.86687], [-119.74389, 36.8669], [-119.7389, 36.86694], [-119.7389, 36.86679], [-119.74183, 36.86677], [-119.74187, 36.86679], [-119.74761, 36.86677], [-119.74761, 36.86687]]], [[[-119.73869, 36.86694], [-119.73431, 36.86698], [-119.73431, 36.86683], [-119.73869, 36.8668], [-119.73869, 36.86694]]]]} | Open Access 1 | 1743 | Sugar Pine Trail | 25944 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 21.648 | Sugar Pine Trail | 0 | Local Recreation Area 3 | 4 | |
145 | 145 | 144 | {"type": "Polygon", "coordinates": [[[-119.86216, 36.76989], [-119.86214, 36.77167], [-119.86209, 36.77171], [-119.86059, 36.77173], [-119.86058, 36.77176], [-119.86044, 36.77177], [-119.85782, 36.77178], [-119.85781, 36.76991], [-119.86216, 36.76989]]]} | Open Access 1 | 365 | Victoria West Community Park | 27084 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 19.669 | Victoria West Community Park | 0 | Local Park 2 | 4 | |
6099 | 6099 | 6098 | {"type": "Polygon", "coordinates": [[[-119.81773, 36.71687], [-119.81772, 36.7176], [-119.81768, 36.71761], [-119.81768, 36.71769], [-119.81736, 36.71769], [-119.81732, 36.71765], [-119.81725, 36.71761], [-119.81224, 36.71764], [-119.81224, 36.71684], [-119.81244, 36.71655], [-119.81261, 36.71635], [-119.81283, 36.71618], [-119.81322, 36.716], [-119.81336, 36.71596], [-119.81337, 36.71604], [-119.81393, 36.71588], [-119.81415, 36.71584], [-119.81448, 36.71582], [-119.81487, 36.71582], [-119.81506, 36.71586], [-119.81559, 36.71585], [-119.8156, 36.71604], [-119.81773, 36.71687]]]} | Open Access 1 | 1019 | Hyde Park | 20165 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 19.493 | Hyde Park | 0 | Local Park 2 | 4 | |
1393 | 1393 | 1392 | {"type": "Polygon", "coordinates": [[[-119.75015, 36.71483], [-119.75014, 36.7177], [-119.74792, 36.71771], [-119.74793, 36.71426], [-119.74995, 36.71425], [-119.74995, 36.71483], [-119.75015, 36.71483]]]} | Open Access 1 | 12202 | Calwa Park | 16743 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 18.484 | Calwa Park | 0 | Local Park 2 | 4 | |
438 | 438 | 437 | {"type": "Polygon", "coordinates": [[[-119.84426, 36.80273], [-119.83996, 36.80275], [-119.83995, 36.80098], [-119.84162, 36.80098], [-119.84205, 36.80106], [-119.84262, 36.80112], [-119.84422, 36.80112], [-119.84426, 36.80273]]]} | Open Access 1 | 1388 | Lions Park | 21319 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 17.754 | Lions Park | 0 | Local Park 2 | 4 | |
517 | 517 | 516 | {"type": "Polygon", "coordinates": [[[-119.77001, 36.80122], [-119.76779, 36.80122], [-119.76779, 36.79947], [-119.76789, 36.79945], [-119.76789, 36.79825], [-119.76891, 36.79825], [-119.76891, 36.79772], [-119.77, 36.79772], [-119.77001, 36.80122]]]} | Open Access 1 | 2141 | Rotary Park West | 24703 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 17.219 | Rotary Park West | 0 | Local Park 2 | 4 | |
11832 | 11832 | 11831 | {"type": "Polygon", "coordinates": [[[-119.68886, 36.75301], [-119.68793, 36.75307], [-119.68654, 36.75303], [-119.68652, 36.75053], [-119.68884, 36.75054], [-119.68886, 36.75301]]]} | Open Access 1 | 24157 | Al Radka Park | 15310 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 14.34 | Al Radka Park | 0 | Local Park 2 | 4 | |
11835 | 11835 | 11834 | {"type": "Polygon", "coordinates": [[[-119.73183, 36.73241], [-119.73183, 36.73319], [-119.73176, 36.73335], [-119.73177, 36.73342], [-119.73182, 36.73347], [-119.73182, 36.73371], [-119.72755, 36.73371], [-119.72756, 36.73248], [-119.72762, 36.73243], [-119.72793, 36.73243], [-119.7281, 36.73241], [-119.73183, 36.73241]]]} | Open Access 1 | 24161 | Pilibos Neighborhood Park | 23669 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 13.58 | Pilibos Neighborhood Park | 0 | Local Park 2 | 4 | |
193 | 193 | 192 | {"type": "Polygon", "coordinates": [[[-119.76796, 36.7851], [-119.76795, 36.78577], [-119.76709, 36.78578], [-119.76707, 36.78673], [-119.76453, 36.78674], [-119.76455, 36.78559], [-119.76459, 36.78548], [-119.76458, 36.78543], [-119.76455, 36.78538], [-119.76467, 36.78503], [-119.76736, 36.78502], [-119.7674, 36.78511], [-119.7675, 36.78515], [-119.76759, 36.78515], [-119.76771, 36.7851], [-119.76796, 36.7851]]]} | Open Access 1 | 535 | Einstein Park | 18471 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 12.015 | Einstein Park | 0 | Local Park 2 | 4 | |
211 | 211 | 210 | {"type": "Polygon", "coordinates": [[[-119.80854, 36.73507], [-119.80853, 36.73775], [-119.80829, 36.73838], [-119.80717, 36.73775], [-119.80712, 36.73767], [-119.8067, 36.73737], [-119.8063, 36.73715], [-119.80607, 36.73691], [-119.80606, 36.73684], [-119.80773, 36.73567], [-119.80854, 36.73507]]]} | Open Access 1 | 664 | Fink-White Park | 18902 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 10.68 | Fink-White Park | 0 | Local Park 2 | 4 | |
513 | 513 | 512 | {"type": "Polygon", "coordinates": [[[-119.7453, 36.72622], [-119.7453, 36.72842], [-119.74397, 36.72843], [-119.74397, 36.72726], [-119.74285, 36.72727], [-119.74292, 36.7271], [-119.74286, 36.72663], [-119.7421, 36.72662], [-119.7421, 36.72625], [-119.7453, 36.72622]]]} | Open Access 1 | 1712 | Mosqueda Park | 22510 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 10.646 | Mosqueda Park | 0 | Local Park 2 | 4 | |
473 | 473 | 472 | {"type": "Polygon", "coordinates": [[[-119.7814, 36.78136], [-119.78138, 36.78318], [-119.77927, 36.78318], [-119.77929, 36.78137], [-119.7814, 36.78136]]]} | Open Access 1 | 1521 | Manchester Park | 21731 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 9.421 | Manchester Park | 0 | Local Park 2 | 4 | |
11833 | 11833 | 11832 | {"type": "Polygon", "coordinates": [[[-119.7477, 36.86655], [-119.74555, 36.86657], [-119.74555, 36.86479], [-119.7477, 36.86477], [-119.7477, 36.86655]]]} | Open Access 1 | 24159 | Selma Layne Park | 25291 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 9.348 | Selma Layne Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
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]);