units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10,524 rows where MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 452
- Los Angeles, City of 387
- Sacramento, City of 208
- San Jose, City of 193
- San Francisco, City and County of 164
- Ventura, City of 132
- Roseville, City of 127
- Long Beach, City of 123
- Oakland, City of 102
- Napa, City of 80
- Irvine, City of 73
- Modesto, City of 72
- Tracy, City of 65
- Davis, City of 64
- Poway, City of 63
- Torrance, City of 61
- Stockton, City of 60
- Santa Cruz, City of 57
- Fresno, City of 57
- Chula Vista, City of 57
- Santa Rosa, City of 56
- San Ramon, City of 56
- Rocklin, City of 56
- Huntington Beach, City of 54
- Brentwood, City of 53
- San Luis Obispo, City of 52
- Manteca, City of 52
- Riverside, City of 51
- Murrieta, City of 49
- Anaheim, City of 48
- …
DES_TP >30
- Local Park 5,773
- Local Recreation Area 1,275
- Local Other or Unknown 645
- Local Conservation Area 115
- Local Historic or Cultural Area 30
- National Monument or Landmark 5
- Local Resource Management Area 4
- National Forest 1
- National Recreation Area 1
- National Wildlife Refuge 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
ACCESS_TYP 4
- Open Access 7,927
- Restricted Access 337
- No Public Access 183
- Unknown Access 22
MNG_AG_TYP 1
- City Agency · 8,469 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2770 | 2770 | 2769 | {"type": "Polygon", "coordinates": [[[-117.28011, 32.82509], [-117.28009, 32.82536], [-117.28002, 32.82566], [-117.27999, 32.82612], [-117.27954, 32.82622], [-117.27953, 32.82616], [-117.27953, 32.82584], [-117.27996, 32.82511], [-117.28011, 32.82509]]]} | Open Access 1 | 18505 | Hermosa Terrace Park | 30053 | 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 | 0.993 | Hermosa Terrace Park | 0 | Local Park 2 | 4 | |
2771 | 2771 | 2770 | {"type": "Polygon", "coordinates": [[[-122.46746, 37.58568], [-122.46682, 37.58703], [-122.46548, 37.5881], [-122.46587, 37.58833], [-122.46498, 37.58832], [-122.46384, 37.58843], [-122.46356, 37.58842], [-122.46248, 37.58827], [-122.4622, 37.58821], [-122.46167, 37.58804], [-122.46003, 37.58769], [-122.45809, 37.58706], [-122.45803, 37.58698], [-122.4658, 37.58332], [-122.46672, 37.58456], [-122.46656, 37.58464], [-122.46645, 37.58476], [-122.46641, 37.58486], [-122.46629, 37.58528], [-122.46626, 37.58531], [-122.46621, 37.58532], [-122.46618, 37.58545], [-122.46746, 37.58568]]]} | Open Access 1 | 18507 | Frontierland Park | 19135 | 1239 | Pacifica, City of 409 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/default.asp | City 2 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | San Mateo 15 | 61.615 | Frontierland Park | 0 | Local Park 2 | 4 | |
2772 | 2772 | 2771 | {"type": "Polygon", "coordinates": [[[-121.86747, 36.59748], [-121.867, 36.59835], [-121.86617, 36.59777], [-121.86625, 36.59767], [-121.86747, 36.59748]]]} | Open Access 1 | 18508 | Peter Ferrante Park | 23626 | 1212 | Monterey, City of 37 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | Monterey 14 | 1.352 | Peter Ferrante Park | 0 | Local Park 2 | 4 | |
2773 | 2773 | 2772 | {"type": "Polygon", "coordinates": [[[-121.04521, 37.68382], [-121.04325, 37.6844], [-121.04323, 37.68302], [-121.0452, 37.68299], [-121.04521, 37.68382]]]} | Open Access 1 | 18509 | Chrysler 99 Park | 17235 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 5.253 | Chrysler 99 Park | 0 | Local Park 2 | 4 | |
2774 | 2774 | 2773 | {"type": "Polygon", "coordinates": [[[-119.669, 36.82146], [-119.66889, 36.82161], [-119.66842, 36.82165], [-119.66797, 36.82148], [-119.66803, 36.82136], [-119.66806, 36.82116], [-119.66808, 36.82115], [-119.66849, 36.82115], [-119.66878, 36.82112], [-119.66881, 36.82113], [-119.66887, 36.82127], [-119.669, 36.82143], [-119.669, 36.82146]]]} | Open Access 1 | 18514 | Westcal New Colony Park | 27384 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 1.011 | Westcal New Colony Park | 0 | Local Park 2 | 4 | |
2775 | 2775 | 2774 | {"type": "Polygon", "coordinates": [[[-117.86187, 33.71588], [-117.86187, 33.71593], [-117.85943, 33.71591], [-117.85943, 33.71477], [-117.86041, 33.71478], [-117.86042, 33.71469], [-117.86078, 33.71471], [-117.86106, 33.71478], [-117.86186, 33.7148], [-117.86187, 33.71531], [-117.8616, 33.71552], [-117.8614, 33.71553], [-117.86139, 33.71587], [-117.86187, 33.71588]]]} | Open Access 1 | 18530 | Delhi Park | 18066 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 6.656 | Delhi Park | 0 | Local Park 2 | 4 | |
2776 | 2776 | 2775 | {"type": "Polygon", "coordinates": [[[-117.32965, 34.14366], [-117.32965, 34.14531], [-117.326, 34.1453], [-117.32535, 34.14463], [-117.32565, 34.14443], [-117.32553, 34.14429], [-117.32565, 34.14421], [-117.32564, 34.14418], [-117.32594, 34.14397], [-117.32512, 34.14311], [-117.32512, 34.14283], [-117.32607, 34.14283], [-117.32686, 34.14366], [-117.32965, 34.14366]]]} | Open Access 1 | 18537 | Delmann Heights Park | 18067 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 18.956 | Delmann Heights Park | 0 | Local Park 2 | 4 | |
2777 | 2777 | 2776 | {"type": "Polygon", "coordinates": [[[-117.24598, 32.85902], [-117.24599, 32.85969], [-117.24598, 32.85977], [-117.24591, 32.85992], [-117.24578, 32.86005], [-117.24495, 32.86044], [-117.24472, 32.86048], [-117.24414, 32.86051], [-117.24598, 32.85902]]]} | Open Access 1 | 18516 | La Jolla Open Space | 20766 | 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 | 2.612 | La Jolla OS | 0 | Local Recreation Area 3 | 4 | |
2778 | 2778 | 2777 | {"type": "Polygon", "coordinates": [[[-117.04655, 32.98981], [-117.04644, 32.99002], [-117.04624, 32.98988], [-117.04549, 32.99], [-117.04438, 32.98961], [-117.04432, 32.98956], [-117.04366, 32.98955], [-117.04282, 32.99048], [-117.04281, 32.99102], [-117.04207, 32.99065], [-117.04173, 32.99079], [-117.04172, 32.99156], [-117.04071, 32.99164], [-117.04067, 32.98935], [-117.04001, 32.98937], [-117.03979, 32.9893], [-117.03874, 32.9893], [-117.03872, 32.98932], [-117.0387, 32.98932], [-117.03452, 32.98928], [-117.03447, 32.98902], [-117.03441, 32.98896], [-117.03432, 32.98895], [-117.03425, 32.98881], [-117.03424, 32.98875], [-117.03456, 32.98881], [-117.03497, 32.98871], [-117.03501, 32.9882], [-117.03501, 32.98798], [-117.0346, 32.98742], [-117.03455, 32.98719], [-117.03413, 32.98665], [-117.03405, 32.9862], [-117.03378, 32.98578], [-117.03374, 32.98563], [-117.03632, 32.98566], [-117.03637, 32.9884], [-117.04066, 32.98844], [-117.04062, 32.98567], [-117.04493, 32.98579], [-117.04494, 32.98939], [-117.04639, 32.98941], [-117.04636, 32.98975], [-117.04655, 32.98981]]]} | Open Access 1 | 18531 | Twin Peaks Open Space | 26620 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://powaytrails.com/trails/TwinPeaksTrail/ | San Diego 4 | 81.613 | Twin Peaks OS | 0 | Local Recreation Area 3 | 4 |
2780 | 2780 | 2779 | {"type": "MultiPolygon", "coordinates": [[[[-116.97064, 32.98874], [-116.97048, 32.99571], [-116.97003, 32.99569], [-116.96974, 32.9957], [-116.96935, 32.99576], [-116.96907, 32.99583], [-116.96869, 32.99598], [-116.96747, 32.99662], [-116.96603, 32.99716], [-116.96572, 32.99726], [-116.96537, 32.99735], [-116.965, 32.99742], [-116.9641, 32.99752], [-116.96409, 32.99739], [-116.96193, 32.99737], [-116.96202, 32.99245], [-116.95777, 32.99241], [-116.95776, 32.9887], [-116.96204, 32.98869], [-116.97064, 32.98874]]], [[[-116.97043, 32.99718], [-116.97037, 33.00014], [-116.96611, 33.0001], [-116.96618, 32.99841], [-116.96646, 32.99827], [-116.968, 32.99778], [-116.96936, 32.99733], [-116.97043, 32.99718]]]]} | Open Access 1 | 18539 | Rock Haven Spring Open Space | 24509 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 244.004 | Rock Haven Spring OS | 0 | Local Recreation Area 3 | 4 | |
2783 | 2783 | 2782 | {"type": "Polygon", "coordinates": [[[-116.50843, 33.80945], [-116.50824, 33.80934], [-116.5073, 33.81041], [-116.50623, 33.80975], [-116.50623, 33.80959], [-116.50489, 33.80877], [-116.50453, 33.8086], [-116.49734, 33.8086], [-116.49734, 33.80757], [-116.49883, 33.8075], [-116.49907, 33.80725], [-116.50078, 33.8072], [-116.50083, 33.80672], [-116.50179, 33.80632], [-116.50396, 33.80652], [-116.5042, 33.8067], [-116.50473, 33.80698], [-116.50497, 33.80723], [-116.50544, 33.80748], [-116.50598, 33.80782], [-116.50597, 33.8086], [-116.50843, 33.80861], [-116.50843, 33.80945]]]} | Open Access 1 | 18549 | Demuth Park | 18082 | 1241 | Palm Springs, City of 553 | City 2 | City Agency 2 | http://www.ci.palm-springs.ca.us/index.aspx?page=80 | City 2 | 1241 | Palm Springs, City of 546 | City 2 | City Agency 2 | Riverside 10 | 44.804 | Demuth Park | 0 | Local Park 2 | 4 | |
2784 | 2784 | 2783 | {"type": "Polygon", "coordinates": [[[-121.23513, 36.32734], [-121.23453, 36.32767], [-121.23445, 36.32757], [-121.23443, 36.32747], [-121.23439, 36.32741], [-121.23433, 36.32738], [-121.23426, 36.32737], [-121.23419, 36.32738], [-121.23414, 36.32741], [-121.23399, 36.32723], [-121.23469, 36.32683], [-121.23513, 36.32734]]]} | Open Access 1 | 18554 | Vintage Park | 30768 | 1124 | Greenfield, City of 176 | City 2 | City Agency 2 | http://www.ci.greenfield.ca.us/index.aspx?page=179 | City 2 | 1124 | Greenfield, City of 172 | City 2 | City Agency 2 | Monterey 14 | 1.141 | Vintage Park | 0 | Local Park 2 | 4 | |
2787 | 2787 | 2786 | {"type": "MultiPolygon", "coordinates": [[[[-117.1655, 32.74559], [-117.1651, 32.7456], [-117.16509, 32.74433], [-117.1655, 32.74432], [-117.1655, 32.74559]]], [[[-117.16661, 32.74404], [-117.1661, 32.74404], [-117.16611, 32.74459], [-117.16556, 32.7446], [-117.16555, 32.74405], [-117.16556, 32.74392], [-117.16661, 32.7439], [-117.16661, 32.74404]]], [[[-117.16849, 32.74062], [-117.16808, 32.74063], [-117.16809, 32.74086], [-117.16797, 32.74096], [-117.16759, 32.74142], [-117.16751, 32.74153], [-117.16669, 32.74154], [-117.16668, 32.74105], [-117.16763, 32.74103], [-117.16764, 32.74064], [-117.16763, 32.74022], [-117.16809, 32.74021], [-117.16809, 32.73983], [-117.16848, 32.73982], [-117.16849, 32.74062]]], [[[-117.16935, 32.73926], [-117.16914, 32.73957], [-117.16907, 32.7397], [-117.169, 32.73971], [-117.16899, 32.73918], [-117.16934, 32.73918], [-117.16935, 32.73926]]]]} | Open Access 1 | 18557 | Albatross Canyon Open Space | 15332 | 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 | 5.812 | Albatross Canyon OS | 0 | Local Recreation Area 3 | 4 | |
2794 | 2794 | 2793 | {"type": "MultiPolygon", "coordinates": [[[[-120.97132, 37.66022], [-120.97118, 37.66023], [-120.97109, 37.66025], [-120.97108, 37.65921], [-120.97126, 37.65948], [-120.97137, 37.65961], [-120.97162, 37.65984], [-120.97177, 37.65994], [-120.97209, 37.66011], [-120.97244, 37.66023], [-120.97292, 37.66036], [-120.97295, 37.6604], [-120.97281, 37.66074], [-120.9727, 37.66088], [-120.97261, 37.66095], [-120.9725, 37.66102], [-120.97231, 37.66108], [-120.97218, 37.6611], [-120.97184, 37.6611], [-120.97182, 37.66109], [-120.9718, 37.66106], [-120.97179, 37.66059], [-120.97175, 37.66045], [-120.97167, 37.66036], [-120.97157, 37.66029], [-120.97145, 37.66024], [-120.97132, 37.66022]]], [[[-120.97548, 37.65992], [-120.97549, 37.66111], [-120.97547, 37.66114], [-120.97544, 37.66115], [-120.97541, 37.66114], [-120.97529, 37.661], [-120.97515, 37.66089], [-120.975, 37.66078], [-120.97467, 37.66059], [-120.9743, 37.66046], [-120.97238, 37.65995], [-120.97223, 37.65989], [-120.97195, 37.65974], [-120.97171, 37.65955], [-120.9716, 37.65944], [-120.97143, 37.65921], [-120.97131, 37.65896], [-120.97127, 37.65883], [-120.97123, 37.65856], [-120.97439, 37.65856], [-120.9744, 37.65991], [-120.97548, 37.65992]]]]} | Open Access 1 | 18570 | Downey Community Park | 18254 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 16.389 | Downey Community Park | 0 | Local Park 2 | 4 | |
2795 | 2795 | 2794 | {"type": "Polygon", "coordinates": [[[-121.84621, 38.45144], [-121.84632, 38.45163], [-121.84634, 38.4519], [-121.84631, 38.45227], [-121.84622, 38.45247], [-121.84596, 38.45276], [-121.84502, 38.45261], [-121.84451, 38.45267], [-121.84414, 38.4528], [-121.84395, 38.45265], [-121.84375, 38.45206], [-121.84371, 38.45182], [-121.8439, 38.4516], [-121.84483, 38.45168], [-121.84562, 38.45164], [-121.84621, 38.45144]]]} | Open Access 1 | 18574 | Patwin Park | 23524 | 1087 | Dixon, City of 426 | City 2 | City Agency 2 | http://www.ci.dixon.ca.us/ | City 2 | 1087 | Dixon, City of 420 | City 2 | City Agency 2 | Solano 26 | 6.284 | Patwin Park | 0 | Local Park 2 | 4 | |
2796 | 2796 | 2795 | {"type": "Polygon", "coordinates": [[[-120.44383, 34.64848], [-120.44381, 34.64997], [-120.44255, 34.64995], [-120.44256, 34.64847], [-120.44383, 34.64848]]]} | Open Access 1 | 18575 | Pioneer Park | 23724 | 1183 | Lompoc, City of 39 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | Santa Barbara 7 | 4.712 | Pioneer Park | 0 | Local Park 2 | 4 | |
2798 | 2798 | 2797 | {"type": "Polygon", "coordinates": [[[-118.07956, 33.86085], [-118.07681, 33.86088], [-118.07678, 33.85867], [-118.07681, 33.85862], [-118.0788, 33.8586], [-118.07871, 33.8587], [-118.07874, 33.85878], [-118.07884, 33.85886], [-118.07911, 33.85896], [-118.07955, 33.85959], [-118.07956, 33.86085]]]} | Open Access 1 | 18581 | Artesia Park | 15639 | 1010 | Artesia, City of 556 | City 2 | City Agency 2 | http://www.cityofartesia.us/index.aspx?nid=127 | City 2 | 1010 | Artesia, City of 549 | City 2 | City Agency 2 | Los Angeles 6 | 14.786 | Artesia Park | 0 | Local Park 2 | 4 | |
2799 | 2799 | 2798 | {"type": "MultiPolygon", "coordinates": [[[[-117.05969, 32.76384], [-117.05963, 32.76392], [-117.05829, 32.76395], [-117.05834, 32.7639], [-117.05835, 32.76382], [-117.05963, 32.76378], [-117.05966, 32.76379], [-117.05969, 32.76384]]], [[[-117.06115, 32.76232], [-117.06114, 32.76248], [-117.06111, 32.76257], [-117.06106, 32.76264], [-117.06009, 32.76351], [-117.06004, 32.76235], [-117.06115, 32.76232]]]]} | Restricted Access 2 | 18582 | Clay Neighborhood Park | 31592 | 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 | 2.413 | Clay Neighborhood Park | 0 | Local Park 2 | 4 | |
2801 | 2801 | 2800 | {"type": "Polygon", "coordinates": [[[-118.32488, 34.26118], [-118.32485, 34.26121], [-118.32482, 34.26122], [-118.32268, 34.26137], [-118.32225, 34.26137], [-118.32224, 34.26139], [-118.32064, 34.26139], [-118.32037, 34.26157], [-118.32005, 34.26185], [-118.31993, 34.26192], [-118.3198, 34.26196], [-118.31972, 34.26196], [-118.31964, 34.26193], [-118.3196, 34.26184], [-118.31962, 34.26176], [-118.31982, 34.26152], [-118.32, 34.2612], [-118.32007, 34.26115], [-118.32019, 34.26111], [-118.3202, 34.25982], [-118.32072, 34.25982], [-118.32073, 34.25985], [-118.32201, 34.25986], [-118.3222, 34.25989], [-118.32223, 34.25993], [-118.32225, 34.25989], [-118.3224, 34.25993], [-118.32269, 34.26004], [-118.32485, 34.26112], [-118.32487, 34.26114], [-118.32488, 34.26118]]]} | Open Access 1 | 14571 | Sunland Park | 26001 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 14.336 | Sunland Park | 0 | Local Park 2 | 4 | |
2802 | 2802 | 2801 | {"type": "Polygon", "coordinates": [[[-121.60581, 37.02401], [-121.60433, 37.02404], [-121.60401, 37.0238], [-121.60443, 37.02348], [-121.60456, 37.02333], [-121.60468, 37.02314], [-121.60521, 37.02315], [-121.60571, 37.02308], [-121.60575, 37.0231], [-121.60577, 37.02314], [-121.60578, 37.02363], [-121.60573, 37.02371], [-121.60573, 37.02376], [-121.60575, 37.02382], [-121.60581, 37.02387], [-121.60581, 37.02401]]]} | Open Access 1 | 14572 | Del Rey Park | 18052 | 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 | 3.122 | Del Rey 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]);