units_with_maps

Table actions

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

363 rows where ACCESS_TYP = 2, MNG_AG_LEV = 2 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

Suggested facets: AGNCY_TYP, LAYER, YR_EST, GAP_STS

MNG_AG_TYP 1

  • City Agency · 363 ✖

ACCESS_TYP 1

  • Restricted Access · 363 ✖
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
3 3 2 {"type": "Polygon", "coordinates": [[[-120.81796, 37.78801], [-120.81602, 37.78793], [-120.81565, 37.78787], [-120.81358, 37.7878], [-120.81268, 37.78774], [-120.8117, 37.78776], [-120.8111, 37.78789], [-120.81064, 37.78764], [-120.80991, 37.78733], [-120.80928, 37.78757], [-120.80895, 37.78704], [-120.80743, 37.78568], [-120.80702, 37.78537], [-120.80701, 37.78515], [-120.80703, 37.78338], [-120.80993, 37.78254], [-120.81293, 37.78022], [-120.81292, 37.77802], [-120.81434, 37.77723], [-120.81693, 37.77715], [-120.81697, 37.78113], [-120.81726, 37.78253], [-120.81756, 37.78477], [-120.81686, 37.78479], [-120.81635, 37.78482], [-120.8157, 37.78465], [-120.81513, 37.78463], [-120.81405, 37.78454], [-120.81371, 37.7843], [-120.81343, 37.78428], [-120.81288, 37.78427], [-120.81092, 37.78458], [-120.81058, 37.78429], [-120.81017, 37.78433], [-120.80902, 37.785], [-120.80861, 37.78529], [-120.80875, 37.78561], [-120.80897, 37.78583], [-120.80941, 37.78606], [-120.80994, 37.78614], [-120.81072, 37.78613], [-120.81093, 37.78596], [-120.8114, 37.78609], [-120.81224, 37.78639], [-120.81288, 37.78655], [-120.8129, 37.78674], [-120.81368, 37.78684], [-120.8148, 37.78683], [-120.81525, 37.78688], [-120.81579, 37.78697], [-120.81674, 37.78697], [-120.81725, 37.78683], [-120.81777, 37.7866], [-120.81796, 37.78801]], [[-120.81641, 37.7829], [-120.81637, 37.78261], [-120.81576, 37.78291], [-120.81539, 37.78302], [-120.81522, 37.78337], [-120.81521, 37.78348], [-120.8154, 37.78386], [-120.81556, 37.78389], [-120.81566, 37.78395], [-120.81602, 37.78396], [-120.81609, 37.784], [-120.81655, 37.78409], [-120.81655, 37.78401], [-120.81644, 37.78328], [-120.81641, 37.7829]]]} Restricted Access 2 9 Oakdale Golf & Country Club 32983 1227 Oakdale, City of 2 City 2 City Agency 2 http://www.oakdalegov.com/#!recreation/c222d City 2 1227 Oakdale, City of 2 City 2 City Agency 2   Stanislaus 2 137.317 Oakdale Golf & Country Club 0 Local Recreation Area 3 4
4 4 3 {"type": "Polygon", "coordinates": [[[-120.8183, 37.79059], [-120.81762, 37.7907], [-120.81665, 37.79072], [-120.81597, 37.7907], [-120.81518, 37.79071], [-120.81444, 37.7908], [-120.81354, 37.79068], [-120.81324, 37.79069], [-120.81119, 37.79087], [-120.81012, 37.79017], [-120.80995, 37.78962], [-120.81, 37.78839], [-120.80928, 37.78757], [-120.80991, 37.78733], [-120.81064, 37.78764], [-120.8111, 37.78789], [-120.81169, 37.78776], [-120.81268, 37.78774], [-120.81358, 37.7878], [-120.81565, 37.78787], [-120.81602, 37.78793], [-120.81796, 37.78801], [-120.8183, 37.79059]]]} Restricted Access 2 24 Stanley Wakefield Wilderness Area 25790 1227 Oakdale, City of 2 City 2 City Agency 2 http://www.oakdalegov.com/#!recreation/c222d City 2 1227 Oakdale, City of 2 City 2 City Agency 2   Stanislaus 2 57.379 Stanley Wakefield Wilderness Area 0 Local Conservation Area 4 2
177 177 176 {"type": "Polygon", "coordinates": [[[-119.74164, 34.43295], [-119.74153, 34.43576], [-119.73893, 34.43575], [-119.73887, 34.43693], [-119.73869, 34.43693], [-119.73853, 34.43695], [-119.73837, 34.437], [-119.73822, 34.43708], [-119.73804, 34.43724], [-119.73783, 34.43753], [-119.73766, 34.43766], [-119.73751, 34.43772], [-119.73402, 34.43838], [-119.73394, 34.43798], [-119.73391, 34.43769], [-119.73392, 34.43573], [-119.73369, 34.43572], [-119.73366, 34.43384], [-119.73517, 34.43387], [-119.73518, 34.43141], [-119.73888, 34.43138], [-119.73888, 34.42908], [-119.73969, 34.42935], [-119.74016, 34.42954], [-119.74079, 34.42982], [-119.7407, 34.4325], [-119.74164, 34.43295]]]} Restricted Access 2 492 Santa Barbara Golf Club 32988 1317 Santa Barbara, City of 26 City 2 City Agency 2 http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp City 2 1317 Santa Barbara, City of 26 City 2 City Agency 2   Santa Barbara 7 110.039 Santa Barbara Golf Club 0 Local Recreation Area 3 4
280 280 279 {"type": "Polygon", "coordinates": [[[-121.85612, 36.61199], [-121.8561, 36.6123], [-121.85602, 36.6123], [-121.85604, 36.61196], [-121.85607, 36.61194], [-121.85612, 36.61199]]]} Restricted Access 2 956 South Monterey Dunes 25664 1330 Seaside, City of 115 City 2 City Agency 2 http://www.ci.seaside.ca.us/index.aspx?page=313 City 2 1330 Seaside, City of 112 City 2 City Agency 2   Monterey 14 0.07 South Monterey Dunes   None 30  
347 347 346 {"type": "Polygon", "coordinates": [[[-117.85051, 34.14864], [-117.85051, 34.14999], [-117.84989, 34.15], [-117.84989, 34.15052], [-117.84633, 34.15052], [-117.84629, 34.15049], [-117.84629, 34.14964], [-117.84651, 34.14929], [-117.84697, 34.14876], [-117.84774, 34.14876], [-117.84775, 34.14814], [-117.84839, 34.14815], [-117.84839, 34.14865], [-117.85051, 34.14864]]]} Restricted Access 2 953 George Manooshian Park 29754 2312 Glendora Unified School District 141 Special District 4 School District 14 http://www.glendora.k12.ca.us/ Special District 4 1120 Glendora, City of 74 City 2 City Agency 2   Los Angeles 6 18.865 George Manooshian Park 0 Local Park 2 4
672 672 671 {"type": "Polygon", "coordinates": [[[-122.10311, 37.87618], [-122.10304, 37.87629], [-122.10157, 37.87704], [-122.10079, 37.87704], [-122.10071, 37.87693], [-122.10056, 37.87677], [-122.09956, 37.8759], [-122.09896, 37.87548], [-122.09889, 37.87537], [-122.09866, 37.87468], [-122.09864, 37.87453], [-122.10311, 37.87618]]]} Restricted Access 2 5104 711 St. Mary's Road Park 15210 1163 Lafayette, City of 236 City 2 City Agency 2 http://www.ci.lafayette.ca.us/index.aspx?page=87 City 2 1163 Lafayette, City of 232 City 2 City Agency 2   Contra Costa 12 11.502 711 St. Mary's Road Park 1983 Local Park 2 4
770 770 769 {"type": "MultiPolygon", "coordinates": [[[[-119.5289, 34.39581], [-119.52824, 34.3972], [-119.52811, 34.3971], [-119.52714, 34.39789], [-119.52649, 34.39736], [-119.52855, 34.39567], [-119.5289, 34.39581]]], [[[-119.52817, 34.39735], [-119.52805, 34.39762], [-119.52771, 34.39836], [-119.52732, 34.39804], [-119.52817, 34.39735]]]]} Restricted Access 2 4493 Carpinteria Salt Marsh Reserve 16899 1047 Carpinteria, City of 72 City 2 City Agency 2 http://www.carpinteria.ca.us/parks_rec/index.shtml City 2 1047 Carpinteria, City of 70 City 2 City Agency 2   Santa Barbara 7 5.768 Carpinteria Salt Marsh Reserve 0 Local Conservation Area 4 2
781 781 780 {"type": "Polygon", "coordinates": [[[-121.83892, 37.69284], [-121.83892, 37.69497], [-121.83838, 37.69541], [-121.83777, 37.69567], [-121.83724, 37.69614], [-121.83653, 37.69638], [-121.83615, 37.6966], [-121.8359, 37.6971], [-121.83545, 37.69735], [-121.83435, 37.69759], [-121.83308, 37.69793], [-121.83316, 37.69844], [-121.83289, 37.69879], [-121.83205, 37.69921], [-121.83202, 37.6983], [-121.82998, 37.69835], [-121.82998, 37.70055], [-121.82094, 37.70062], [-121.81888, 37.69912], [-121.81883, 37.69713], [-121.82405, 37.69676], [-121.8243, 37.69635], [-121.82403, 37.6952], [-121.82983, 37.6953], [-121.83021, 37.69279], [-121.83892, 37.69284]]]} Restricted Access 2 5062 Las Positas Golf Course 33002 1178 Livermore, City of 256 City 2 City Agency 2 http://www.larpd.org/parks/parks.html City 2 1178 Livermore, City of 252 City 2 City Agency 2   Alameda 17 216.12 Las Positas GC 0 Local Recreation Area 3 4
824 824 823 {"type": "Polygon", "coordinates": [[[-118.29688, 34.18375], [-118.2965, 34.18411], [-118.29645, 34.18412], [-118.29561, 34.18351], [-118.2956, 34.18348], [-118.296, 34.18308], [-118.29685, 34.1837], [-118.29688, 34.18375]]]} Restricted Access 2 5370 Miller Park 29568 1038 Burbank, City of 138 City 2 City Agency 2 http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities City 2 1038 Burbank, City of 135 City 2 City Agency 2 http://www.burbankca.gov/departments/parks-and-recreation/parks-facilities/miller-park Los Angeles 6 1.599 Miller Park 0 Local Park 2 4
968 968 967 {"type": "Polygon", "coordinates": [[[-118.10763, 33.83029], [-118.10763, 33.83204], [-118.10759, 33.8321], [-118.09924, 33.83206], [-118.09919, 33.83205], [-118.09916, 33.83201], [-118.09956, 33.8307], [-118.09974, 33.83027], [-118.10362, 33.83028], [-118.10363, 33.83055], [-118.10507, 33.83056], [-118.10508, 33.83028], [-118.10763, 33.83029]]]} Restricted Access 2 6607 Heartwell Golf Course 33019 1184 Long Beach, City of 298 City 2 City Agency 2 http://www.longbeach.gov/park/default.asp City 2 1184 Long Beach, City of 294 City 2 City Agency 2   Los Angeles 6 36.514 Heartwell GC 0 Local Recreation Area 3 4
1030 1030 1029 {"type": "Polygon", "coordinates": [[[-118.04152, 33.87135], [-118.04149, 33.87145], [-118.04152, 33.87159], [-118.04153, 33.87191], [-118.04149, 33.87195], [-118.04002, 33.87196], [-118.03998, 33.87195], [-118.03997, 33.87192], [-118.04, 33.87181], [-118.03999, 33.87176], [-118.03996, 33.87172], [-118.0399, 33.87171], [-118.03989, 33.87119], [-118.04023, 33.87119], [-118.04045, 33.87115], [-118.04068, 33.87106], [-118.04094, 33.87089], [-118.04112, 33.87082], [-118.04125, 33.8708], [-118.04146, 33.8708], [-118.0415, 33.87082], [-118.04152, 33.87135]]]} Restricted Access 2 5646 Friendship Park 19120 1051 Cerritos, City of 225 City 2 City Agency 2 http://www.ci.cerritos.ca.us/ City 2 1051 Cerritos, City of 221 City 2 City Agency 2   Los Angeles 6 3.848 Friendship Park 0 Local Park 2 4
1140 1140 1139 {"type": "Polygon", "coordinates": [[[-118.1547, 33.95388], [-118.15452, 33.95422], [-118.15424, 33.9546], [-118.15397, 33.95488], [-118.15371, 33.95511], [-118.15347, 33.95528], [-118.14778, 33.95833], [-118.14294, 33.95579], [-118.14293, 33.95577], [-118.14293, 33.95574], [-118.14549, 33.95228], [-118.14787, 33.95356], [-118.14876, 33.95237], [-118.15149, 33.95385], [-118.15239, 33.95264], [-118.1547, 33.95388]]]} Restricted Access 2 6710 Rio Hondo Golf Club 33020 1088 Downey, City of 82 City 2 City Agency 2 http://www.downeyca.org/services/cs/default.asp City 2 1088 Downey, City of 80 City 2 City Agency 2   Los Angeles 6 101.146 Rio Hondo Golf Club 0 Local Recreation Area 3 4
1392 1392 1391 {"type": "MultiPolygon", "coordinates": [[[[-117.69075, 33.62392], [-117.68979, 33.62464], [-117.6881, 33.62602], [-117.68796, 33.62602], [-117.68764, 33.62571], [-117.68732, 33.6253], [-117.68703, 33.62485], [-117.68795, 33.62401], [-117.68946, 33.62275], [-117.69075, 33.62392]]], [[[-117.69308, 33.61785], [-117.69279, 33.61798], [-117.69244, 33.61822], [-117.69209, 33.61852], [-117.69108, 33.62006], [-117.69044, 33.6209], [-117.69044, 33.62091], [-117.69115, 33.62121], [-117.69006, 33.62215], [-117.68996, 33.62243], [-117.68983, 33.62274], [-117.68763, 33.62065], [-117.68806, 33.62016], [-117.68832, 33.61992], [-117.68852, 33.6197], [-117.68907, 33.61929], [-117.68969, 33.61891], [-117.69138, 33.61803], [-117.69201, 33.61773], [-117.69254, 33.61741], [-117.69268, 33.61741], [-117.69308, 33.61785]]]]} Restricted Access 2 30526 Lake Forest Golf Course 33099 1167 Lake Forest, City of 235 City 2 City Agency 2 http://www.lakeforestca.gov/depts/cs/city_parks/default.asp City 2 1167 Lake Forest, City of 231 City 2 City Agency 2   Orange 3 40.437 Lake Forest GC 0 Local Recreation Area 3 4
1429 1429 1428 {"type": "Polygon", "coordinates": [[[-117.00998, 32.57781], [-117.00559, 32.57765], [-117.00559, 32.57912], [-117.00537, 32.57895], [-117.00513, 32.57883], [-117.00486, 32.57878], [-117.0046, 32.57878], [-117.00434, 32.57884], [-117.00415, 32.57892], [-117.00402, 32.579], [-117.00369, 32.57861], [-117.00357, 32.57838], [-117.00352, 32.5782], [-117.0035, 32.57805], [-117.0035, 32.57572], [-117.00456, 32.57575], [-117.00457, 32.57563], [-117.00487, 32.57547], [-117.00504, 32.57543], [-117.00514, 32.57544], [-117.00571, 32.5757], [-117.00584, 32.5757], [-117.00599, 32.57551], [-117.00621, 32.57533], [-117.00643, 32.57533], [-117.00656, 32.57537], [-117.0068, 32.57512], [-117.00705, 32.57482], [-117.00727, 32.57423], [-117.00733, 32.57399], [-117.00696, 32.57363], [-117.00645, 32.57334], [-117.00621, 32.57316], [-117.00602, 32.57284], [-117.00594, 32.57263], [-117.00594, 32.57243], [-117.00626, 32.57237], [-117.00647, 32.57236], [-117.00649, 32.57158], [-117.00647, 32.57157], [-117.00652, 32.57069], [-117.0065, 32.57067], [-117.00652, 32.57059], [-117.00652, 32.57031], [-117.00654, 32.5703], [-117.00654, 32.56915], [-117.00618, 32.56914], [-117.00587, 32.56895], [-117.00586, 32.56882], [-117.00553, 32.56882], [-117.00553, 32.56854], [-117.00572, 32.56854], [-117.00575, 32.56846], [-117.00583, 32.56841], [-117.00749, 32.56842], [-117.00798, 32.56847], [-117.00925, 32.56848], [-117.00925, 32.56886], [-117.00841, 32.56886], [-117.0084, 32.56946], [-117.00888, 32.5703], [-117.00988, 32.5703], [-117.00998, 32.57781]]]} Restricted Access 2 47693 Dennery Preserve 31429 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 1297 San Diego, City of 4 City 2 City Agency 2   San Diego 4 98.129 Dennery Preserve 0 Local Conservation Area 4 2
1684 1684 1683 {"type": "Polygon", "coordinates": [[[-121.62835, 37.01723], [-121.62822, 37.01731], [-121.62818, 37.01737], [-121.62816, 37.01744], [-121.62812, 37.01964], [-121.6281, 37.01972], [-121.6266, 37.01771], [-121.62576, 37.0171], [-121.62163, 37.01641], [-121.62107, 37.016], [-121.62127, 37.0158], [-121.62088, 37.01542], [-121.62085, 37.01515], [-121.61929, 37.01516], [-121.61925, 37.01194], [-121.62047, 37.01194], [-121.62137, 37.0119], [-121.62504, 37.01167], [-121.62506, 37.01172], [-121.62571, 37.0117], [-121.62583, 37.01172], [-121.62595, 37.01177], [-121.62605, 37.01184], [-121.62614, 37.01198], [-121.62619, 37.01246], [-121.62661, 37.01244], [-121.62667, 37.01302], [-121.62678, 37.01382], [-121.62688, 37.01413], [-121.62707, 37.01457], [-121.62725, 37.01481], [-121.62808, 37.01556], [-121.62821, 37.01575], [-121.62828, 37.01596], [-121.62832, 37.01616], [-121.62833, 37.01637], [-121.62831, 37.01698], [-121.62835, 37.01723]]]} Restricted Access 2 14574 Gilroy Golf Course 33040 1118 Gilroy, City of 407 City 2 City Agency 2 http://www.cityofgilroy.org/cityofgilroy/community/parks/default.aspx City 2 1118 Gilroy, City of 401 City 2 City Agency 2   Santa Clara 19 96.909 Gilroy GC 0 Local Recreation Area 3 4
2092 2092 2091 {"type": "Polygon", "coordinates": [[[-118.39572, 33.91443], [-118.39518, 33.91444], [-118.39517, 33.91445], [-118.39529, 33.9147], [-118.39505, 33.91479], [-118.39406, 33.91293], [-118.39392, 33.9127], [-118.39375, 33.91247], [-118.39352, 33.9122], [-118.39318, 33.91187], [-118.39199, 33.91086], [-118.39445, 33.90986], [-118.39456, 33.90961], [-118.39553, 33.9096], [-118.39553, 33.90815], [-118.3951, 33.90815], [-118.3951, 33.90799], [-118.39556, 33.90798], [-118.39562, 33.908], [-118.39567, 33.90806], [-118.39568, 33.9096], [-118.39569, 33.9098], [-118.39572, 33.90991], [-118.39572, 33.91443]]]} Restricted Access 2 6138 The Lakes at El Segundo Municipal Golf Course 33006 1096 El Segundo, City of 300 City 2 City Agency 2 http://www.elsegundo.org/depts/recreation/default.asp City 2 1096 El Segundo, City of 296 City 2 City Agency 2   Los Angeles 6 26.418 The Lakes at El Segundo Municipal GC 0 Local Recreation Area 3 4
2098 2098 2097 {"type": "Polygon", "coordinates": [[[-121.89542, 37.75272], [-121.89511, 37.75373], [-121.89391, 37.75351], [-121.89423, 37.75248], [-121.89542, 37.75272]]]} Restricted Access 2 47568 Live Oak School Park 31293 2309 San Ramon Valley Unified School District 478 Special District 4 School District 14 http://www.srvusd.net/ Special District 4 1313 San Ramon, City of 68 City 2 City Agency 2   Contra Costa 12 3.116 Live Oak School Park 0 Local Park 2 4
2099 2099 2098 {"type": "Polygon", "coordinates": [[[-121.94503, 37.73765], [-121.94369, 37.73818], [-121.94322, 37.73744], [-121.94227, 37.7378], [-121.94234, 37.73798], [-121.94192, 37.73811], [-121.94168, 37.73772], [-121.94145, 37.73739], [-121.94426, 37.7363], [-121.9444, 37.73653], [-121.94433, 37.7366], [-121.94433, 37.73668], [-121.94438, 37.73674], [-121.94449, 37.73676], [-121.94503, 37.73765]]]} Restricted Access 2 47569 Pine Valley Middle School Parks and Community Gym 31294 2309 San Ramon Valley Unified School District 478 Special District 4 School District 14 http://www.srvusd.net/ Special District 4 1313 San Ramon, City of 68 City 2 City Agency 2   Contra Costa 12 8.075 Pine Valley Middle School Parks and Community Gym 0 Local Recreation Area 3 4
2159 2159 2158 {"type": "Polygon", "coordinates": [[[-122.5122, 37.93636], [-122.50745, 37.93685], [-122.50733, 37.93585], [-122.50733, 37.93514], [-122.50753, 37.93394], [-122.50773, 37.93298], [-122.50798, 37.93199], [-122.50819, 37.9308], [-122.50832, 37.93034], [-122.50839, 37.92998], [-122.50843, 37.92956], [-122.50862, 37.92877], [-122.50865, 37.92853], [-122.50876, 37.92835], [-122.50901, 37.92814], [-122.50954, 37.92788], [-122.50987, 37.92778], [-122.5106, 37.92744], [-122.51067, 37.9274], [-122.51066, 37.9273], [-122.51068, 37.92728], [-122.51062, 37.9269], [-122.51051, 37.92633], [-122.51056, 37.9263], [-122.51068, 37.92631], [-122.51084, 37.92759], [-122.51106, 37.9289], [-122.5122, 37.93636]]]} Restricted Access 2 16168 Muzzi Marsh 22617 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 77.169 Muzzi Marsh   None 177  
2216 2216 2215 {"type": "Polygon", "coordinates": [[[-121.90955, 37.75216], [-121.90924, 37.75257], [-121.90894, 37.75304], [-121.90858, 37.75288], [-121.90819, 37.75274], [-121.90782, 37.75266], [-121.90741, 37.75261], [-121.90741, 37.7522], [-121.90735, 37.75209], [-121.90718, 37.752], [-121.90702, 37.75197], [-121.90676, 37.75208], [-121.9058, 37.75097], [-121.9068, 37.75041], [-121.90754, 37.75103], [-121.90769, 37.7511], [-121.90786, 37.75114], [-121.90802, 37.75114], [-121.90823, 37.75111], [-121.90845, 37.75099], [-121.90955, 37.75216]]]} Restricted Access 2 47570 Windemere Ranch School Park 31295 2309 San Ramon Valley Unified School District 478 Special District 4 School District 14 http://www.srvusd.net/ Special District 4 1313 San Ramon, City of 68 City 2 City Agency 2   Contra Costa 12 11.225 Windemere Ranch School 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]);