units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
198 rows where MNG_AG_TYP = 17 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, PARK_URL, COUNTY, ACRES, YR_EST, GAP_STS
LABEL_NAME 192 ✖
- Armona Rec. Park 2
- Betschart Park 2
- Eastwood Park 2
- Lichtenberger Park 2
- New York Creek Nature Trail 2
- Waddle Ranch 2
- Alan Lindsey Park 1
- Altamont Park 1
- American Heroes Park 1
- Amundson Park 1
- Backer Park 1
- Baker Park 1
- Bartholomew Park 1
- Bartholomew Sports Park 1
- Batey Park 1
- Bear Valley Park 1
- Beeman Park 1
- Berens Park 1
- Bertelsen Park 1
- Bethany Park 1
- Bowmen's Archery Range 1
- Bradford Park 1
- Bridgeview Park 1
- Brooktrails Disc GC 1
- Buscher Park 1
- Camden Park Greenbelt 1
- Cameron Park Lake 1
- Case Park 1
- Castello Park 1
- Caterino Park 1
- Caytano Park 1
- Cedar Creek Park 1
- Central Community Park 1
- Christa McAuliffe Park 1
- Chuck Clay Memorial Park 1
- Colton Park 1
- Constellation Park 1
- Covington Park 1
- Creek Park 1
- Creekside Greens Park 1
- Creekside Park 1
- Dairyland Park 1
- Dave West Park 1
- Davis Park 1
- Del Meyer Park 1
- Derr-Okamoto Park 1
- Desert Shores Community Park 1
- EDH Community Park 1
- Eastvale Community Park 1
- Ehrhardt Oaks Park 1
- El Dorado Hills Community Service District 1 1
- Elk Grove Park 1
- Eproson Park 1
- Evers Park 1
- Fairchild Park 1
- Fales Park 1
- Feickert Park 1
- Ferini Park 1
- Fiscalini Ranch Preserve 1
- Fite Park 1
- Fleming Park 1
- Foulks Park 1
- Gage Park 1
- Gale Zinc Memorial Park 1
- Gates Park 1
- Gateway Park 1
- Golden Hills Nature Park 1
- Governor's Park 1
- Green Belt Park 1
- Guttridge Park 1
- Hacienda Park 1
- Harada Heritage Park 1
- Harris Ranch Park 1
- Hawk Hill 1
- Hawkins Park 1
- Helendale Community Park 1
- Helendale Dog Park 1
- Henderson Park 1
- Herburger Park 1
- Hill Park 1
- Hiller Park Playground and Picnic Area 1
- Home Garden Community Park 1
- Hoo Hoo Park 1
- Houde Park 1
- Hrepich Park 1
- Island Park 1
- James C. Huber Park 1
- Johnson Park 1
- Johnston Park 1
- Jones Park 1
- Jordan Family Park 1
- Jungkeit Park 1
- Kalithea Park 1
- Karamanos Park 1
- Kay Park 1
- Keema Park 1
- King Park 1
- Kirkwood Greenbelt 1
- Kloss Park 1
- Kott Park 1
- Kramer Park 1
- Kunsting Park 1
- Laguna Community Park 1
- Lake Forest Park 1
- Lake Shastina 1
- Larissa Park 1
- Las Gallinas Park 1
- Laurel Oaks Park 1
- Lawrence Park 1
- Lawson Park 1
- Leon Rose Ball Park 1
- Lewis Park 1
- Lippincott Park 1
- Lombardi Park 1
- Luttig Park 1
- Machado Dairy Park 1
- Manila Community Park 1
- Manila Dunes Rec. Area 1
- Marinwood OS 1
- Mary Laveroni Community Park 1
- McConnel Park 1
- McCune Family Park 1
- Memorial Park 1
- Mendoza Park 1
- Mesa Park 1
- Miles Park 1
- Miwok Park 1
- Mix Park 1
- Montego Park 1
- Morse Park 1
- Mountainview Park 1
- Mtn. Gate Community Spec. Dist. 1 1
- Mtn. House Community Services District 1 1
- Murray Homestead Park 1
- Northview Park 1
- Nottoli Park 1
- OHL Redwood Grove Park 1
- Oak Knoll Park 1
- Oneto Park 1
- Orchard Park 1
- Overlook Park 1
- Parkview Heights Park 1
- Pedersen Park 1
- Perez Park 1
- Perry Park 1
- Pierson Park 1
- Pinkerton Park 1
- Promenade Park 1
- Promontory Community Park 1
- Providence Ranch Park 1
- Questa Park 1
- RP 1
- Rasmussen Park 1
- Rau Park 1
- Ravenswood Park 1
- Redwood Park 1
- Ridgeview 7 Park 1
- Riverfront Park 1
- Rose Garden Park 1
- Rose Park 1
- Rossmoor Park 1
- Rush Park 1
- Russell Park 1
- Salton City Community Park 1
- Schauer Park 1
- Scotia Fireman's Park 1
- Simpson Park 1
- Smedberg Park 1
- Stephenson Park 1
- Storybook Woods Park 1
- Strong Park 1
- Teen Ctr. & Skate Park 1
- Tom Jermin Senior Community Park 1
- Tomales Village Community Services District 1 1
- Town Square Park 1
- Triangle Park 1
- Twain Harte Tennis Courts 1
- Underwood Park 1
- United Street Park 1
- Van Doren Park 1
- Veterans Park 1
- Wackman Park 1
- Waterford Park 1
- Weisberg Park 1
- Wickland Park 1
- Willard Park 1
- William C. "Bill" McCabe Park 1
- Windsor Point Park 1
- Womack Park 1
- Wright Park 1
- Zehnder Park 1
- Zimbelman Park 1
MNG_AGENCY 38
- Consumnes Community Services District 94
- El Dorado Hills Community Service District 25
- Jurupa Community Services District 10
- Cameron Park Community Services District 8
- Mountain House Community Services District 7
- McKinleyville Community Services District 4
- Tamalpais Community Services District 4
- Brooktrails Community Services District 3
- Marinwood Community Service District 3
- Rossmore Community Services District 2
- Twain Harte Community Services District 2
- Groveland Community Services District 2
- Manila Community Services District 2
- Truckee Tahoe Airport District 2
- Indian Valley Community Services District 2
- Aromona Community Services District 2
- Helendale Community Services District 2
- Pajaro Community Services District 2
- Salton Community Services District 2
- Templeton Community Services District 2
- Discovery Bay Community Service District 1
- Scotia Community Services District 1
- Bear Valley Springs Community Services District 1
- Morongo Valley Community Services District 1
- Cambria Community Services District 1
- Rosamond Community Services District 1
- Los Alamos Community Services District 1
- Golden Hills Community Service District 1
- Happy Camp Community Services District 1
- McCloud Community Services District 1
- Lake Shastina Community Services District 1
- Concord Landscaping and Lighting Maintenance District No. 3 1
- Tomales Village Community Services District 1
- Bolinas Community Public Utility District 1
- Bel Marin Keys Community Services District 1
- Mountain Gate Community Special District 1
- Willow Creek Community Services District 1
- Home Garden Community Services District 1
DES_TP 12
- Local Park 173
- Local Recreation Area 14
- Local Other or Unknown 2
- Local Conservation Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 2
- Open Access 194
- Restricted Access 4
MNG_AG_TYP 1
- Community Services District · 198 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7492 | 7492 | 7491 | {"type": "Polygon", "coordinates": [[[-120.94993, 40.13923], [-120.94987, 40.13929], [-120.94983, 40.13929], [-120.94982, 40.13916], [-120.94993, 40.13923]]]} | Open Access 1 | 48943 | Triangle Park | 33659 | 2229 | Indian Valley Community Services District 869 | Special District 4 | Community Services District 19 | Special District 4 | 2229 | Indian Valley Community Services District 848 | Special District 4 | Community Services District 17 | http://cloud2.snappages.com/14694d9d5e0e722731c9a38ca07276495d3755a5/IVCSD%20Properties.pdf | Plumas 57 | 0.02 | Triangle Park | 0 | Local Park 2 | 4 | |
4136 | 4136 | 4135 | {"type": "Polygon", "coordinates": [[[-122.5342, 37.88202], [-122.53409, 37.88227], [-122.53409, 37.88227], [-122.53403, 37.88222], [-122.53403, 37.882], [-122.5342, 37.88202]]]} | Open Access 1 | 47184 | Kott Park | 30876 | 2261 | Tamalpais Community Services District 723 | Special District 4 | Community Services District 19 | http://www.tcsd.us/ | Special District 4 | 2261 | Tamalpais Community Services District 708 | Special District 4 | Community Services District 17 | Marin 23 | 0.068 | Kott Park | 0 | Local Park 2 | 4 | |
8335 | 8335 | 8334 | {"type": "Polygon", "coordinates": [[[-121.07801, 38.69279], [-121.07777, 38.69282], [-121.07777, 38.69263], [-121.07784, 38.69262], [-121.07786, 38.69264], [-121.07792, 38.69263], [-121.07799, 38.69273], [-121.07801, 38.69279]]]} | Open Access 1 | 47800 | New York Creek Nature Trail | 30318 | 2220 | El Dorado Irrigation District 890 | Special District 4 | Irrigation District 17 | http://www.eid.org/ | Special District 4 | 2197 | El Dorado Hills Community Service District 560 | Special District 4 | Community Services District 17 | http://www.eldoradohillscsd.org/images/park_detail_popups/new-york-creek/index.html | El Dorado 34 | 0.089 | New York Creek Nature Trail | 0 | Local Recreation Area 3 | 4 |
14168 | 14168 | 14167 | {"type": "Polygon", "coordinates": [[[-122.33651, 40.70968], [-122.33649, 40.71002], [-122.33604, 40.7099], [-122.33608, 40.70968], [-122.33651, 40.70968]]]} | Open Access 1 | 43063 | Mountain Gate Community Special District 1 | 22539 | 2292 | Mountain Gate Community Special District 1093 | Special District 4 | Community Services District 19 | http://mountaingatecsd.com/ | Special District 4 | 2292 | Mountain Gate Community Special District 1048 | Special District 4 | Community Services District 17 | Shasta 27 | 0.286 | Mtn. Gate Community Spec. Dist. 1 | None 1205 | |||
7518 | 7518 | 7517 | {"type": "Polygon", "coordinates": [[[-120.83763, 40.07496], [-120.83763, 40.07516], [-120.837, 40.07515], [-120.837, 40.07495], [-120.83763, 40.07496]]]} | Open Access 1 | 48944 | Chuck Clay Memorial Park | 33660 | 2229 | Indian Valley Community Services District 869 | Special District 4 | Community Services District 19 | Special District 4 | 2229 | Indian Valley Community Services District 848 | Special District 4 | Community Services District 17 | http://cloud2.snappages.com/14694d9d5e0e722731c9a38ca07276495d3755a5/IVCSD%20Properties.pdf | Plumas 57 | 0.296 | Chuck Clay Memorial Park | 0 | Local Park 2 | 4 | |
4122 | 4122 | 4121 | {"type": "Polygon", "coordinates": [[[-121.45166, 38.42828], [-121.45123, 38.42827], [-121.45104, 38.42799], [-121.45153, 38.428], [-121.45166, 38.42828]]]} | Open Access 1 | 47130 | Harris Ranch Park | 30807 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 0.311 | Harris Ranch Park | 0 | Local Park 2 | 4 | |
3352 | 3352 | 3351 | {"type": "Polygon", "coordinates": [[[-124.10338, 40.95518], [-124.10286, 40.95518], [-124.10286, 40.95491], [-124.10338, 40.95491], [-124.10338, 40.95518]]]} | Open Access 1 | 24241 | Larissa Park | 21027 | 2238 | McKinleyville Community Services District 624 | Special District 4 | Community Services District 19 | http://mckinleyvillecsd.com/ | Special District 4 | 2238 | McKinleyville Community Services District 613 | Special District 4 | Community Services District 17 | Humboldt 45 | 0.324 | Larissa Park | 0 | Local Park 2 | 4 | |
9448 | 9448 | 9447 | {"type": "Polygon", "coordinates": [[[-120.28014, 34.74428], [-120.28011, 34.74478], [-120.27969, 34.74476], [-120.27972, 34.74426], [-120.28014, 34.74428]]]} | Open Access 1 | 15799 | Ferini Park | 18873 | 2065 | Los Alamos Community Services District 914 | Special District 4 | Community Services District 19 | http://www.losalamoscsd.com/ | Special District 4 | 2065 | Los Alamos Community Services District 887 | Special District 4 | Community Services District 17 | Santa Barbara 7 | 0.527 | Ferini Park | 0 | Local Park 2 | 4 | |
11845 | 11845 | 11844 | {"type": "Polygon", "coordinates": [[[-122.53104, 37.87812], [-122.53069, 37.87812], [-122.53071, 37.87847], [-122.53069, 37.87847], [-122.53066, 37.87812], [-122.53012, 37.87813], [-122.53019, 37.87787], [-122.52976, 37.87779], [-122.52977, 37.87776], [-122.5302, 37.87784], [-122.53024, 37.8777], [-122.53044, 37.87775], [-122.53075, 37.87793], [-122.53093, 37.87762], [-122.53095, 37.87764], [-122.53077, 37.87795], [-122.53104, 37.87812]]]} | Open Access 1 | 24248 | Kay Park | 20563 | 2261 | Tamalpais Community Services District 723 | Special District 4 | Community Services District 19 | http://www.tcsd.us/ | Special District 4 | 2261 | Tamalpais Community Services District 708 | Special District 4 | Community Services District 17 | Marin 23 | 0.614 | Kay Park | 0 | Local Park 2 | 4 | |
11839 | 11839 | 11838 | {"type": "Polygon", "coordinates": [[[-121.75839, 36.87566], [-121.75803, 36.87597], [-121.75767, 36.87552], [-121.7581, 36.87529], [-121.75839, 36.87566]]]} | Open Access 1 | 24251 | Caytano Park | 16984 | 2249 | Pajaro Community Services District 992 | Special District 4 | Community Services District 19 | http://pajarosunnymesa.com/ | Special District 4 | 2249 | Pajaro Community Services District 956 | Special District 4 | Community Services District 17 | Monterey 14 | 0.618 | Caytano Park | 0 | Local Park 2 | 4 | |
3095 | 3095 | 3094 | {"type": "Polygon", "coordinates": [[[-121.08995, 38.67612], [-121.08966, 38.67632], [-121.08929, 38.67632], [-121.08942, 38.67575], [-121.08946, 38.67572], [-121.0895, 38.67571], [-121.08958, 38.67574], [-121.08977, 38.67585], [-121.08987, 38.67597], [-121.08995, 38.67612]]]} | Open Access 1 | 25180 | Ridgeview 7 Park | 24357 | 2197 | El Dorado Hills Community Service District 568 | Special District 4 | Community Services District 19 | http://www.edhcsd.org/ | Special District 4 | 2197 | El Dorado Hills Community Service District 560 | Special District 4 | Community Services District 17 | El Dorado 34 | 0.632 | Ridgeview 7 Park | 0 | Local Park 2 | 4 | |
11759 | 11759 | 11758 | {"type": "Polygon", "coordinates": [[[-121.43856, 38.4322], [-121.43773, 38.43316], [-121.43751, 38.43309], [-121.4383, 38.43218], [-121.43841, 38.43218], [-121.43856, 38.4322]]]} | Open Access 1 | 24052 | Betschart Park | 16049 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 0.634 | Betschart Park | 0 | Local Park 2 | 4 | |
3019 | 3019 | 3018 | {"type": "Polygon", "coordinates": [[[-120.23769, 38.03201], [-120.23715, 38.03226], [-120.237, 38.03217], [-120.23668, 38.03234], [-120.2365, 38.03222], [-120.23722, 38.03183], [-120.23702, 38.03158], [-120.23769, 38.03201]]]} | Open Access 1 | 24324 | Twain Harte Tennis Courts | 26608 | 2264 | Twain Harte Community Services District 574 | Special District 4 | Community Services District 19 | http://www.twainhartecsd.com/ | Special District 4 | 2264 | Twain Harte Community Services District 566 | Special District 4 | Community Services District 17 | Tuolumne 21 | 0.715 | Twain Harte Tennis Courts | 0 | Local Recreation Area 3 | 4 | |
12548 | 12548 | 12547 | {"type": "Polygon", "coordinates": [[[-121.3714, 38.4211], [-121.3709, 38.4211], [-121.37034, 38.42063], [-121.3714, 38.42063], [-121.3714, 38.4211]]]} | Open Access 1 | 29052 | Del Meyer Park | 18039 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 0.886 | Del Meyer Park | 0 | Local Park 2 | 4 | |
14474 | 14474 | 14473 | {"type": "Polygon", "coordinates": [[[-121.40937, 38.39491], [-121.40933, 38.39492], [-121.40931, 38.39494], [-121.40931, 38.39518], [-121.40915, 38.39516], [-121.40907, 38.39518], [-121.40901, 38.39524], [-121.409, 38.39531], [-121.40903, 38.39538], [-121.40903, 38.39545], [-121.40856, 38.39544], [-121.40857, 38.39481], [-121.40908, 38.39481], [-121.40937, 38.39491]]]} | Open Access 1 | 47132 | Bridgeview Park | 30809 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/595/Bridgeview-Park | Sacramento 41 | 0.925 | Bridgeview Park | 0 | Local Park 2 | 4 |
11785 | 11785 | 11784 | {"type": "Polygon", "coordinates": [[[-121.36093, 38.40781], [-121.36092, 38.40783], [-121.36087, 38.40785], [-121.36024, 38.40785], [-121.36023, 38.4072], [-121.36073, 38.4072], [-121.36073, 38.40729], [-121.36076, 38.40741], [-121.3609, 38.40767], [-121.36093, 38.40781]]]} | Open Access 1 | 24080 | Russell Park | 24740 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 0.931 | Russell Park | 0 | Local Park 2 | 4 | |
13752 | 13752 | 13751 | {"type": "Polygon", "coordinates": [[[-122.90593, 38.24517], [-122.90588, 38.24564], [-122.90514, 38.24561], [-122.90498, 38.24542], [-122.90498, 38.24515], [-122.90593, 38.24517]]]} | Open Access 1 | 36263 | Tomales Village Community Services District 1 | 26396 | 2334 | Tomales Village Community Services District 1067 | Special District 4 | Community Services District 19 | http://www.tomalescsd.ca.gov/ | Special District 4 | 2334 | Tomales Village Community Services District 1025 | Special District 4 | Community Services District 17 | Marin 23 | 0.987 | Tomales Village Community Services District 1 | None 1185 | |||
11757 | 11757 | 11756 | {"type": "Polygon", "coordinates": [[[-121.42936, 38.43427], [-121.42939, 38.43439], [-121.4294, 38.4345], [-121.42939, 38.43453], [-121.42935, 38.43456], [-121.42833, 38.43455], [-121.42829, 38.43454], [-121.42826, 38.43451], [-121.42826, 38.43426], [-121.42828, 38.43405], [-121.42867, 38.43409], [-121.42881, 38.43413], [-121.42894, 38.43423], [-121.42903, 38.43435], [-121.42936, 38.43427]]]} | Open Access 1 | 24050 | Davis Park | 17953 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 0.996 | Davis Park | 0 | Local Park 2 | 4 | |
14481 | 14481 | 14480 | {"type": "Polygon", "coordinates": [[[-121.4142, 38.3979], [-121.41422, 38.39797], [-121.41419, 38.39807], [-121.41414, 38.39816], [-121.41406, 38.39824], [-121.41396, 38.39831], [-121.41384, 38.39835], [-121.41365, 38.39839], [-121.41344, 38.39836], [-121.41326, 38.39828], [-121.41313, 38.39816], [-121.41307, 38.39807], [-121.41304, 38.39796], [-121.41306, 38.3979], [-121.41333, 38.39793], [-121.41363, 38.39795], [-121.41394, 38.39793], [-121.4142, 38.3979]]]} | Open Access 1 | 47136 | Rose Garden Park | 30813 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/624/Rose-Garden-Park | Sacramento 41 | 0.996 | Rose Garden Park | 0 | Local Park 2 | 4 |
11737 | 11737 | 11736 | {"type": "Polygon", "coordinates": [[[-121.3624, 38.41993], [-121.3624, 38.42089], [-121.36205, 38.4209], [-121.36201, 38.42086], [-121.36188, 38.42039], [-121.36186, 38.4202], [-121.36186, 38.41995], [-121.3624, 38.41993]]]} | Open Access 1 | 24063 | Van Doren Park | 26826 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 1.115 | Van Doren 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]);