units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
266 rows where AGNCY_LEV = 7 sorted by SUID_NMA
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP, MNG_AG_LEV, PARK_URL, COUNTY, YR_EST, GAP_STS
MNG_AGENCY >30
- Woodbridge Village Association 31
- Home Owners Association - Unknown Name 27
- Rancho Santa Margarita Landscape and Recreation Corporation 18
- Valley-Wide Recreation and Park District 7
- Amerige Heights Community Association 7
- Bellflower, City of 6
- San Clemente, City of 4
- Paseo Westpark Maintenance Association 4
- Deerfield Community Association 4
- Nellie Gail Ranch Owners Association 4
- Westpark Maintenance District 4
- Sierra Bonita Community Association 4
- Town Center Association 4
- Irvine, City of 3
- Quail Hill Community Association 3
- Private Landowner 3
- Wildlands Inc 3
- East Highlands Ranch MHOA 3
- Northpark Square Maintenance Association 3
- Turtle Rock Broadmoor Community Association 3
- Summerly Homes 2
- San Jacinto, City of 2
- Chino, City of 2
- Paramount, City of 2
- West Hollywood, City of 2
- Oak Creek Village Maintenance Association 2
- King City, City of 2
- Broadmoor Campus View Community Association 2
- McCloud River Railroad Company 2
- Woodbridge Owners Association 2
- …
DES_TP 19
- Private Recreation or Education 193
- Local Park 36
- Private Conservation 16
- Local Recreation Area 6
- Local Conservation Area 1
- Local Other or Unknown 1
- State Recreation Area 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
MNG_AG_TYP 12
ACCESS_TYP 4
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16692 | 16692 | 16691 | {"type": "Polygon", "coordinates": [[[-121.42227, 36.74537], [-121.41401, 36.7565], [-121.40419, 36.75221], [-121.40404, 36.7525], [-121.40396, 36.75279], [-121.4037, 36.75322], [-121.4035, 36.75336], [-121.40337, 36.75341], [-121.40309, 36.7538], [-121.403, 36.75394], [-121.40287, 36.75408], [-121.40248, 36.75456], [-121.40064, 36.75395], [-121.40084, 36.75358], [-121.40089, 36.7534], [-121.40105, 36.75331], [-121.4012, 36.75321], [-121.40134, 36.75305], [-121.4014, 36.75287], [-121.40148, 36.75279], [-121.40151, 36.7527], [-121.40159, 36.75265], [-121.40164, 36.75256], [-121.40165, 36.75238], [-121.40174, 36.75231], [-121.40179, 36.75223], [-121.40179, 36.75215], [-121.40203, 36.75203], [-121.40207, 36.75179], [-121.40218, 36.75164], [-121.40225, 36.75158], [-121.40227, 36.75155], [-121.40226, 36.75148], [-121.4022, 36.75136], [-121.40224, 36.75119], [-121.40243, 36.75104], [-121.40254, 36.75098], [-121.40272, 36.7508], [-121.40277, 36.75064], [-121.40276, 36.7506], [-121.40278, 36.75043], [-121.40276, 36.75037], [-121.40279, 36.75033], [-121.4029, 36.75022], [-121.40467, 36.75106], [-121.40623, 36.74897], [-121.4083, 36.74988], [-121.40942, 36.74838], [-121.41193, 36.74948], [-121.41574, 36.74435], [-121.41574, 36.74355], [-121.41776, 36.7434], [-121.42227, 36.74537]]]} | Open Access 1 | 44462 | Hollister Hills State Vehicular Recreation Area | 4250 | 6069 | Green Valley Homeowners Recreation Association 1101 | Private 7 | Home Owners Association 16 | http://www.gvhra.com/ | Private 14 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://ohv.parks.ca.gov/?page_id=1179 | San Benito 38 | 277.458 | Hollister Hills SVRA | 1975 | State Recreation Area 39 | 4 |
10368 | 10368 | 10367 | {"type": "Polygon", "coordinates": [[[-117.79989, 33.68697], [-117.79927, 33.6872], [-117.79887, 33.68726], [-117.79854, 33.68729], [-117.79848, 33.68702], [-117.79851, 33.68686], [-117.79845, 33.68645], [-117.79837, 33.68625], [-117.79871, 33.68622], [-117.79873, 33.68615], [-117.79871, 33.68595], [-117.79882, 33.68594], [-117.79893, 33.68597], [-117.79881, 33.68622], [-117.79989, 33.68697]]]} | Restricted Access 2 | 18302 | Arrowhead Park | 15607 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 2.518 | Arrowhead Park | 0 | Private Recreation or Education 65 | 4 | |
14221 | 14221 | 14220 | {"type": "Polygon", "coordinates": [[[-117.62494, 33.63432], [-117.62492, 33.63451], [-117.62456, 33.6347], [-117.62445, 33.63478], [-117.62433, 33.63493], [-117.62414, 33.63535], [-117.62415, 33.63555], [-117.62405, 33.63568], [-117.62393, 33.63575], [-117.62393, 33.63581], [-117.62396, 33.63585], [-117.62407, 33.63592], [-117.62427, 33.63665], [-117.6243, 33.63707], [-117.62415, 33.6374], [-117.62377, 33.63756], [-117.62391, 33.63778], [-117.62385, 33.63777], [-117.62357, 33.63747], [-117.62341, 33.63734], [-117.62324, 33.63723], [-117.62284, 33.63707], [-117.62223, 33.6369], [-117.62215, 33.63685], [-117.62214, 33.63683], [-117.62216, 33.63675], [-117.6223, 33.63656], [-117.62239, 33.63643], [-117.62258, 33.63624], [-117.62278, 33.63612], [-117.62291, 33.6361], [-117.62314, 33.63612], [-117.62322, 33.63604], [-117.62321, 33.63597], [-117.62322, 33.63596], [-117.62318, 33.63592], [-117.62325, 33.63584], [-117.62316, 33.63558], [-117.6228, 33.63534], [-117.62275, 33.63533], [-117.62276, 33.63524], [-117.62265, 33.63503], [-117.6229, 33.63486], [-117.62297, 33.63511], [-117.62321, 33.6354], [-117.62348, 33.63518], [-117.62343, 33.63504], [-117.62349, 33.63502], [-117.62352, 33.63499], [-117.62354, 33.6348], [-117.62356, 33.63476], [-117.62392, 33.63436], [-117.62401, 33.63429], [-117.62413, 33.63421], [-117.62442, 33.63409], [-117.62465, 33.63399], [-117.62471, 33.63399], [-117.62487, 33.63411], [-117.62492, 33.63416], [-117.62491, 33.63421], [-117.62468, 33.63407], [-117.62421, 33.63427], [-117.62407, 33.63437], [-117.62388, 33.63454], [-117.62369, 33.63476], [-117.62369, 33.63492], [-117.6236, 33.63516], [-117.62329, 33.63542], [-117.62336, 33.63566], [-117.6235, 33.6359], [-117.62375, 33.63606], [-117.62379, 33.63597], [-117.62379, 33.63591], [-117.62376, 33.63582], [-117.62377, 33.63575], [-117.62381, 33.63567], [-117.62393, 33.63559], [-117.62396, 33.63555], [-117.62397, 33.63549], [-117.62395, 33.63537], [-117.62414, 33.63494], [-117.62423, 33.6348], [-117.62428, 33.63472], [-117.6244, 33.63461], [-117.62452, 33.63454], [-117.62484, 33.63439], [-117.62494, 33.63432]]]} | Restricted Access 2 | 44100 | Arroyo Park | 15623 | 6068 | Arroyo Maintenance Corporation 1102 | Private 7 | Home Owners Association 16 | http://www.progressivecm.com/arroyo/index.html | Private 14 | 6068 | Arroyo Maintenance Corporation 1056 | Private 7 | Home Owners Association 15 | Orange 3 | 8.012 | Arroyo Park | 0 | Private Recreation or Education 65 | 4 | |
1592 | 1592 | 1591 | {"type": "Polygon", "coordinates": [[[-117.78781, 33.67973], [-117.78686, 33.68064], [-117.78636, 33.68028], [-117.7873, 33.67937], [-117.78781, 33.67973]]]} | Restricted Access 2 | 12155 | Ashwood Park | 15658 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 2.011 | Ashwood Park | 0 | Private Recreation or Education 65 | 4 | |
779 | 779 | 778 | {"type": "Polygon", "coordinates": [[[-117.80378, 33.68325], [-117.80318, 33.68385], [-117.8024, 33.68332], [-117.80299, 33.68272], [-117.80378, 33.68325]]]} | Restricted Access 2 | 5060 | Birdsong Park | 16124 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 1.997 | Birdsong Park | 0 | Private Recreation or Education 65 | 4 | |
6878 | 6878 | 6877 | {"type": "Polygon", "coordinates": [[[-117.80159, 33.68926], [-117.80114, 33.68972], [-117.80084, 33.68974], [-117.80076, 33.68915], [-117.80078, 33.68909], [-117.80112, 33.68894], [-117.80159, 33.68926]]]} | Restricted Access 2 | 5540 | Blue Jay Park | 16177 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 1.077 | Blue Jay Park | 0 | Private Recreation or Education 65 | 4 | |
8088 | 8088 | 8087 | {"type": "Polygon", "coordinates": [[[-117.7966, 33.66983], [-117.79631, 33.67068], [-117.79544, 33.67047], [-117.79574, 33.66964], [-117.79578, 33.66962], [-117.7966, 33.66983]]]} | Restricted Access 2 | 12162 | Briarglen Park | 16371 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 2.017 | Briarglen Park | 0 | Private Recreation or Education 65 | 4 | |
8319 | 8319 | 8318 | {"type": "Polygon", "coordinates": [[[-117.96092, 33.88396], [-117.9602, 33.88594], [-117.96003, 33.88589], [-117.96075, 33.88391], [-117.96092, 33.88396]]]} | Restricted Access 2 | 12793 | Burdorf Park | 16516 | 6062 | Amerige Heights Community Association 263 | Private 7 | Home Owners Association 16 | http://www.amerigeheights.org/ | Private 14 | 6062 | Amerige Heights Community Association 259 | Private 7 | Home Owners Association 15 | Orange 3 | 0.954 | Burdorf Park | 0 | Private Recreation or Education 65 | 4 | |
1595 | 1595 | 1594 | {"type": "Polygon", "coordinates": [[[-117.33591, 33.13338], [-117.33487, 33.13375], [-117.33448, 33.13298], [-117.33535, 33.13267], [-117.3354, 33.13267], [-117.33591, 33.13338]]]} | Open Access 1 | 12167 | Cannon Park | 16804 | 6076 | San Diego Gas and Electric 389 | Private 7 | Utility 21 | http://www.sdge.com/ | Private 14 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/facilities/north/cannon.asp | San Diego 4 | 2.282 | Cannon Park | 0 | Local Park 2 | 4 |
8087 | 8087 | 8086 | {"type": "Polygon", "coordinates": [[[-117.7745, 33.6464], [-117.77409, 33.64642], [-117.77402, 33.64586], [-117.77398, 33.64527], [-117.77395, 33.64518], [-117.77384, 33.64503], [-117.77389, 33.6449], [-117.77386, 33.64479], [-117.77383, 33.64478], [-117.77388, 33.64475], [-117.77385, 33.64452], [-117.77371, 33.64448], [-117.77371, 33.64441], [-117.77368, 33.64437], [-117.77378, 33.6443], [-117.77374, 33.64398], [-117.77357, 33.64362], [-117.77347, 33.64359], [-117.77345, 33.64351], [-117.77342, 33.64347], [-117.77348, 33.64339], [-117.77344, 33.64323], [-117.77344, 33.64295], [-117.77347, 33.64291], [-117.77331, 33.64267], [-117.77328, 33.64258], [-117.77321, 33.64254], [-117.77326, 33.64242], [-117.77312, 33.6422], [-117.7735, 33.64203], [-117.77358, 33.64201], [-117.77377, 33.64198], [-117.77402, 33.64201], [-117.77425, 33.6421], [-117.77442, 33.64219], [-117.77446, 33.64223], [-117.77445, 33.64226], [-117.77431, 33.64238], [-117.77417, 33.64252], [-117.77408, 33.64265], [-117.77401, 33.64278], [-117.77397, 33.64292], [-117.77394, 33.64317], [-117.77396, 33.6433], [-117.77399, 33.6434], [-117.77447, 33.64453], [-117.77457, 33.6449], [-117.7746, 33.64528], [-117.7746, 33.64546], [-117.7745, 33.6464]]]} | Restricted Access 2 | 12174 | Cascade Park | 16939 | 6019 | Quail Hill Community Association 408 | Private 7 | Home Owners Association 16 | http://www.quailhillhoa.org/ | Private 14 | 6019 | Quail Hill Community Association 402 | Private 7 | Home Owners Association 15 | Orange 3 | 7.136 | Cascade Park | 0 | Private Recreation or Education 65 | 4 | |
1604 | 1604 | 1603 | {"type": "Polygon", "coordinates": [[[-117.81184, 33.66673], [-117.81155, 33.66748], [-117.81149, 33.66751], [-117.81146, 33.66746], [-117.81132, 33.66739], [-117.81062, 33.66726], [-117.81077, 33.66651], [-117.81184, 33.66673]]]} | Restricted Access 2 | 12272 | Clearbrook Park | 17414 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 2.0 | Clearbrook Park | 0 | Private Recreation or Education 65 | 4 | |
1607 | 1607 | 1606 | {"type": "Polygon", "coordinates": [[[-117.79116, 33.71292], [-117.79129, 33.71293], [-117.79145, 33.71298], [-117.79158, 33.71304], [-117.79169, 33.71312], [-117.79176, 33.71321], [-117.79182, 33.71332], [-117.79186, 33.71344], [-117.79186, 33.71356], [-117.79184, 33.71366], [-117.79179, 33.71378], [-117.79173, 33.71387], [-117.79161, 33.71397], [-117.79149, 33.71404], [-117.79138, 33.71409], [-117.79123, 33.71411], [-117.79109, 33.71412], [-117.79096, 33.7141], [-117.79082, 33.71405], [-117.79071, 33.714], [-117.79061, 33.71391], [-117.79052, 33.71381], [-117.79046, 33.7137], [-117.79043, 33.71357], [-117.79043, 33.71347], [-117.79046, 33.71335], [-117.79052, 33.71324], [-117.79058, 33.71315], [-117.79068, 33.71306], [-117.79081, 33.71299], [-117.79092, 33.71295], [-117.79116, 33.71292]]]} | Restricted Access 2 | 12278 | Colorado Park | 17543 | 6008 | Harvard Square Maintenance Association 393 | Private 7 | Home Owners Association 16 | http://www.progressivecm.com/harvardsquare/ | Private 14 | 6008 | Harvard Square Maintenance Association 387 | Private 7 | Home Owners Association 15 | Orange 3 | 3.401 | Colorado Park | 0 | Private Recreation or Education 65 | 4 | |
3525 | 3525 | 3524 | {"type": "Polygon", "coordinates": [[[-118.1436, 33.87107], [-118.14301, 33.87107], [-118.14301, 33.87037], [-118.14299, 33.87036], [-118.14299, 33.86965], [-118.1436, 33.86965], [-118.1436, 33.87107]]]} | Open Access 1 | 20595 | Constitution Park | 17598 | 6073 | Southern California Edison 655 | Private 7 | Utility 21 | https://www.sce.com | Private 14 | 1024 | Bellflower, City of 443 | City 2 | City Agency 2 | Los Angeles 6 | 2.156 | Constitution Park | 0 | Local Park 2 | 4 | |
10862 | 10862 | 10861 | {"type": "Polygon", "coordinates": [[[-118.52166, 34.37788], [-118.52155, 34.37794], [-118.5216, 34.37802], [-118.52101, 34.37832], [-118.51896, 34.37592], [-118.51945, 34.37515], [-118.52016, 34.37582], [-118.52058, 34.37646], [-118.52104, 34.37623], [-118.52134, 34.37749], [-118.52166, 34.37788]]]} | Open Access 1 | 20660 | Creekview Park | 17788 | 6102 | The Master's College 959 | Private 7 | Education 35 | http://www.masters.edu/ | Private 14 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=411 | Los Angeles 6 | 8.223 | Creekview Park | 0 | Local Park 2 | 4 |
8121 | 8121 | 8120 | {"type": "Polygon", "coordinates": [[[-117.78826, 33.67677], [-117.78752, 33.67755], [-117.78658, 33.67687], [-117.78681, 33.67669], [-117.78706, 33.67673], [-117.78726, 33.67673], [-117.78759, 33.67667], [-117.78789, 33.67665], [-117.78817, 33.67669], [-117.78825, 33.67673], [-117.78826, 33.67677]]]} | Restricted Access 2 | 12288 | Crestbrook Park | 17805 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 2.069 | Crestbrook Park | 0 | Private Recreation or Education 65 | 4 | |
8122 | 8122 | 8121 | {"type": "Polygon", "coordinates": [[[-117.81073, 33.67563], [-117.81009, 33.67625], [-117.80942, 33.67578], [-117.8094, 33.67575], [-117.80941, 33.67571], [-117.81, 33.67513], [-117.81073, 33.67563]]]} | Restricted Access 2 | 12293 | Daybreak Park | 17962 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 1.95 | Daybreak Park | 0 | Private Recreation or Education 65 | 4 | |
5153 | 5153 | 5152 | {"type": "Polygon", "coordinates": [[[-117.81503, 33.66922], [-117.8143, 33.66981], [-117.81368, 33.66911], [-117.81433, 33.66861], [-117.81503, 33.66922]]]} | Restricted Access 2 | 12301 | Echo Run Park | 18421 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 2.05 | Echo Run Park | 0 | Private Recreation or Education 65 | 4 | |
10847 | 10847 | 10846 | {"type": "Polygon", "coordinates": [[[-118.12837, 34.0455], [-118.12829, 34.04553], [-118.12817, 34.04553], [-118.12743, 34.04535], [-118.1272, 34.04532], [-118.11801, 34.04309], [-118.11799, 34.04277], [-118.11801, 34.04266], [-118.12629, 34.04467], [-118.12828, 34.0447], [-118.12838, 34.04547], [-118.12837, 34.0455]]]} | Open Access 1 | 20633 | Edison Trails Park | 18447 | 6073 | Southern California Edison 655 | Private 7 | Utility 21 | https://www.sce.com | Private 14 | 1213 | Monterey Park, City of 130 | City 2 | City Agency 2 | Los Angeles 6 | 12.372 | Edison Trails Park | 0 | Local Park 2 | 4 | |
8128 | 8128 | 8127 | {"type": "Polygon", "coordinates": [[[-117.78342, 33.67945], [-117.78277, 33.68011], [-117.78207, 33.67962], [-117.78272, 33.67895], [-117.78282, 33.67903], [-117.78298, 33.67918], [-117.78308, 33.67921], [-117.78342, 33.67945]]]} | Restricted Access 2 | 12306 | Fallbrook Park | 18834 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 2.0 | Fallbrook Park | 0 | Private Recreation or Education 65 | 4 | |
8130 | 8130 | 8129 | {"type": "Polygon", "coordinates": [[[-117.79209, 33.67836], [-117.79147, 33.67898], [-117.79106, 33.6787], [-117.79096, 33.6786], [-117.79068, 33.6782], [-117.79081, 33.67818], [-117.79087, 33.67825], [-117.79093, 33.67826], [-117.79103, 33.67825], [-117.79107, 33.67821], [-117.79118, 33.67803], [-117.79136, 33.67785], [-117.79209, 33.67836]]]} | Restricted Access 2 | 12308 | Firwood Park | 18917 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 1.968 | Firwood Park | 0 | Private Recreation or Education 65 | 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]);