units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
101 rows where MNG_AGENCY = 266 sorted by UNIT_ID descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER
DES_TP 7
- Local Park 59
- Local Other or Unknown 29
- Local Recreation Area 9
- Local Conservation Area 1
- None 1
- None 1
- None 1
ACCESS_TYP 2
- Open Access 100
- No Public Access 1
MNG_AG_TYP 1
- City Agency 101
MNG_AGENCY 1
- Irvine, City of · 101 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11155 | 11155 | 11154 | {"type": "Polygon", "coordinates": [[[-117.71514, 33.7026], [-117.71503, 33.70272], [-117.71348, 33.70165], [-117.71319, 33.70188], [-117.71283, 33.70221], [-117.71279, 33.70214], [-117.71274, 33.70194], [-117.71273, 33.70165], [-117.71268, 33.70136], [-117.71281, 33.70133], [-117.71297, 33.70113], [-117.71496, 33.70241], [-117.715, 33.70239], [-117.71508, 33.70244], [-117.71514, 33.7026]]]} | Open Access 1 | 48695 | Orchard Trail Park | 33407 | 6128 | Portola Springs Community Association 967 | Private 7 | Home Owners Association 16 | https://portolasprings.org/ | Private 14 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 2.227 | Orchard Trail Park | 0 | Local Park 2 | 4 | |
11154 | 11154 | 11153 | {"type": "Polygon", "coordinates": [[[-117.79698, 33.70006], [-117.79706, 33.70012], [-117.79707, 33.70016], [-117.79689, 33.70036], [-117.79686, 33.70044], [-117.79687, 33.70049], [-117.79677, 33.70052], [-117.7967, 33.70048], [-117.79666, 33.70047], [-117.79649, 33.70063], [-117.79644, 33.7006], [-117.79664, 33.7004], [-117.79662, 33.70038], [-117.79668, 33.70036], [-117.79698, 33.70006]]]} | Open Access 1 | 48692 | Flagstone Park | 18936 | 6033 | Windwood Homeowners Association 926 | Private 7 | Home Owners Association 16 | Private 14 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 0.248 | Flagstone Park | 0 | Local Park 2 | 4 | ||
10903 | 10903 | 10902 | {"type": "Polygon", "coordinates": [[[-117.70737, 33.69604], [-117.70643, 33.6954], [-117.70213, 33.69972], [-117.70191, 33.69964], [-117.70162, 33.69931], [-117.70047, 33.6986], [-117.70041, 33.69852], [-117.70056, 33.698], [-117.7004, 33.69787], [-117.70015, 33.69789], [-117.69959, 33.69802], [-117.69959, 33.69807], [-117.69842, 33.69803], [-117.69805, 33.69753], [-117.69777, 33.69751], [-117.69626, 33.69685], [-117.69623, 33.69676], [-117.69612, 33.6967], [-117.69603, 33.69672], [-117.69543, 33.69641], [-117.69458, 33.69585], [-117.69459, 33.6958], [-117.69451, 33.69572], [-117.69442, 33.69574], [-117.69414, 33.69555], [-117.69411, 33.69534], [-117.69409, 33.69528], [-117.69448, 33.69518], [-117.69491, 33.69511], [-117.69535, 33.69505], [-117.69579, 33.69502], [-117.69645, 33.69503], [-117.69805, 33.69516], [-117.69853, 33.69518], [-117.699, 33.69518], [-117.69948, 33.69515], [-117.69995, 33.69509], [-117.70462, 33.69436], [-117.70527, 33.69431], [-117.70591, 33.69431], [-117.70612, 33.69432], [-117.70737, 33.69604]]]} | Open Access 1 | 48665 | Portola Springs Community Park | 33412 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 85.788 | Portola Springs Community Park | 0 | Local Park 2 | 4 | |
5035 | 5035 | 5034 | {"type": "Polygon", "coordinates": [[[-117.75315, 33.69738], [-117.75187, 33.69866], [-117.75179, 33.69867], [-117.75168, 33.69878], [-117.75168, 33.69884], [-117.75097, 33.69955], [-117.75091, 33.69955], [-117.74986, 33.69882], [-117.75088, 33.6978], [-117.75088, 33.69779], [-117.75082, 33.69775], [-117.75203, 33.69654], [-117.75314, 33.69732], [-117.75315, 33.69734], [-117.75315, 33.69738]]]} | Open Access 1 | 48664 | Woodbury Community Park | 33411 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 10.743 | Woodbury Community Park | 0 | Local Park 2 | 4 | |
10887 | 10887 | 10886 | {"type": "Polygon", "coordinates": [[[-117.7503, 33.71658], [-117.74985, 33.71697], [-117.74946, 33.71734], [-117.74941, 33.71732], [-117.74938, 33.71735], [-117.74772, 33.71619], [-117.74855, 33.71536], [-117.7503, 33.71658]]]} | Open Access 1 | 48663 | Eastwood Neighborhood Park | 33410 | 6129 | Irvine Community Development Company LLC 961 | Private 7 | Commercial 20 | https://www.irvinecompany.com/ | Private 14 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 6.129 | Eastwood Neighborhood Park | 0 | Local Park 2 | 4 | |
3013 | 3013 | 3012 | {"type": "Polygon", "coordinates": [[[-117.75861, 33.68706], [-117.75734, 33.68834], [-117.75725, 33.68835], [-117.75724, 33.68826], [-117.75719, 33.68819], [-117.7558, 33.68722], [-117.75572, 33.6872], [-117.7556, 33.6872], [-117.7556, 33.68713], [-117.75688, 33.68585], [-117.75861, 33.68706]]]} | Open Access 1 | 48662 | Cypress Grove Park | 33409 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 9.424 | Cypress Grove Park | 0 | Local Park 2 | 4 | |
3012 | 3012 | 3011 | {"type": "Polygon", "coordinates": [[[-117.82541, 33.62489], [-117.82527, 33.62514], [-117.82498, 33.62504], [-117.82473, 33.62498], [-117.82493, 33.62461], [-117.8253, 33.62454], [-117.82541, 33.62489]]]} | Open Access 1 | 48661 | Bommer Vista Point Park | 33408 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 0.662 | Bommer Vista Point Park | 0 | Local Park 2 | 4 | |
3011 | 3011 | 3010 | {"type": "Polygon", "coordinates": [[[-117.71297, 33.70113], [-117.71281, 33.70134], [-117.71268, 33.70136], [-117.71263, 33.70123], [-117.71255, 33.70111], [-117.71244, 33.70099], [-117.71233, 33.70091], [-117.71232, 33.70082], [-117.7124, 33.70073], [-117.71297, 33.70113]]]} | Open Access 1 | 48660 | Orchard Trail Park | 33407 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 0.424 | Orchard Trail Park | 0 | Local Park 2 | 4 | |
14910 | 14910 | 14909 | {"type": "Polygon", "coordinates": [[[-117.80446, 33.67603], [-117.80354, 33.67696], [-117.80273, 33.67773], [-117.80154, 33.67675], [-117.80103, 33.67639], [-117.80036, 33.67589], [-117.79995, 33.67571], [-117.80052, 33.67562], [-117.80077, 33.67524], [-117.80076, 33.67522], [-117.80076, 33.67515], [-117.80071, 33.67512], [-117.80105, 33.6747], [-117.80104, 33.6746], [-117.80118, 33.67444], [-117.80107, 33.67401], [-117.80071, 33.67381], [-117.80015, 33.67355], [-117.80031, 33.67336], [-117.80038, 33.67336], [-117.80061, 33.67343], [-117.8012, 33.67369], [-117.80202, 33.67412], [-117.8027, 33.67454], [-117.80327, 33.67495], [-117.8039, 33.67546], [-117.80444, 33.67593], [-117.80446, 33.67603]]]} | Open Access 1 | 45466 | Mike Ward Community Park - Woodbridge | 28276 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.cityofirvine.org/cityhall/cs/commparks/cparks/cparks_woodbridge.asp | Orange 3 | 22.31 | Mike Ward Community Park - Woodbridge | None 1286 | ||
4327 | 4327 | 4326 | {"type": "Polygon", "coordinates": [[[-117.76611, 33.69081], [-117.76411, 33.69277], [-117.76228, 33.69163], [-117.76216, 33.69146], [-117.76347, 33.69013], [-117.76434, 33.69078], [-117.76503, 33.69011], [-117.76611, 33.69081]]]} | Open Access 1 | 45463 | Cypress Community Park | 28273 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.cityofirvine.org/cityhall/cs/commparks/cparks/cypress_community_park.asp | Orange 3 | 14.139 | Cypress Community Park | 0 | Local Park 2 | 4 |
16232 | 16232 | 16231 | {"type": "MultiPolygon", "coordinates": [[[[-117.75608, 33.70195], [-117.75607, 33.70204], [-117.75468, 33.70342], [-117.75347, 33.70465], [-117.75188, 33.70622], [-117.75167, 33.70637], [-117.75113, 33.70692], [-117.75101, 33.70701], [-117.7508, 33.70702], [-117.7499, 33.70641], [-117.75001, 33.70633], [-117.75013, 33.70637], [-117.75022, 33.70635], [-117.75026, 33.70632], [-117.75032, 33.70622], [-117.75185, 33.70468], [-117.75191, 33.70459], [-117.75192, 33.70453], [-117.75197, 33.70453], [-117.75244, 33.70405], [-117.75241, 33.70396], [-117.75249, 33.70394], [-117.75254, 33.7039], [-117.75473, 33.70167], [-117.75481, 33.70162], [-117.75497, 33.70158], [-117.75503, 33.70154], [-117.75506, 33.70151], [-117.75505, 33.70142], [-117.75504, 33.70139], [-117.75499, 33.70135], [-117.7549, 33.70133], [-117.75491, 33.70121], [-117.75519, 33.70141], [-117.75496, 33.70165], [-117.75498, 33.70168], [-117.7553, 33.70139], [-117.75608, 33.70195]]], [[[-117.76164, 33.69643], [-117.7592, 33.69889], [-117.75922, 33.69892], [-117.75842, 33.69973], [-117.75726, 33.70089], [-117.75642, 33.70171], [-117.75631, 33.70173], [-117.75585, 33.70141], [-117.75733, 33.69994], [-117.7586, 33.69865], [-117.7586, 33.69863], [-117.75873, 33.6985], [-117.75904, 33.6987], [-117.7591, 33.69871], [-117.75914, 33.6987], [-117.7603, 33.69749], [-117.76083, 33.69687], [-117.76085, 33.6968], [-117.76078, 33.69658], [-117.76049, 33.69637], [-117.76096, 33.69587], [-117.76161, 33.69635], [-117.76164, 33.69643]]], [[[-117.76719, 33.6909], [-117.76472, 33.69345], [-117.76204, 33.69616], [-117.76138, 33.69574], [-117.76675, 33.69044], [-117.76719, 33.6909]]]]} | Open Access 1 | 45462 | Jeffrey Open Space Trail | 28272 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | https://www.cityofirvine.org/cityhall/cs/openspace/jost.asp | Orange 3 | 44.391 | Jeffrey OS Trail | 0 | Local Recreation Area 3 | 4 |
4326 | 4326 | 4325 | {"type": "Polygon", "coordinates": [[[-117.74192, 33.7062], [-117.74122, 33.70692], [-117.74093, 33.70719], [-117.74067, 33.70702], [-117.74058, 33.70702], [-117.74049, 33.70706], [-117.74046, 33.70705], [-117.73924, 33.7062], [-117.73914, 33.70618], [-117.73906, 33.70623], [-117.739, 33.70619], [-117.73902, 33.70615], [-117.7402, 33.70496], [-117.74022, 33.70497], [-117.74028, 33.70492], [-117.74123, 33.70558], [-117.74119, 33.70562], [-117.74119, 33.70563], [-117.7414, 33.70581], [-117.74192, 33.70617], [-117.74191, 33.70619], [-117.74192, 33.7062]]]} | Open Access 1 | 45461 | Stonegate Park | 28267 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.cityofirvine.org/cityhall/cs/commparks/nparks/default.asp | Orange 3 | 8.581 | Stonegate Park | 0 | Local Park 2 | 4 |
14643 | 14643 | 14642 | {"type": "Polygon", "coordinates": [[[-117.76612, 33.67667], [-117.76534, 33.67745], [-117.76468, 33.67701], [-117.76546, 33.67622], [-117.76612, 33.67667]]]} | Open Access 1 | 44891 | Central Bark | 17045 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 2.187 | Central Bark | None 1249 | |||
4040 | 4040 | 4039 | {"type": "Polygon", "coordinates": [[[-117.76064, 33.73966], [-117.76012, 33.74012], [-117.75743, 33.73842], [-117.75801, 33.73776], [-117.75829, 33.73758], [-117.75908, 33.73774], [-117.7599, 33.7381], [-117.76039, 33.73872], [-117.76064, 33.73966]]]} | Open Access 1 | 44285 | Settlers Park | 25324 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 10.852 | Settlers Park | 0 | Local Park 2 | 4 | |
13585 | 13585 | 13584 | {"type": "Polygon", "coordinates": [[[-117.80728, 33.65595], [-117.8071, 33.65617], [-117.80699, 33.65623], [-117.80688, 33.6565], [-117.80619, 33.65604], [-117.80526, 33.65309], [-117.80397, 33.653], [-117.80342, 33.65245], [-117.80294, 33.65193], [-117.80251, 33.65149], [-117.80225, 33.65111], [-117.80202, 33.65073], [-117.80187, 33.65029], [-117.80179, 33.64988], [-117.80176, 33.64869], [-117.80155, 33.64818], [-117.80126, 33.64758], [-117.80082, 33.64675], [-117.80073, 33.64643], [-117.80072, 33.64581], [-117.80077, 33.64553], [-117.80094, 33.64516], [-117.80114, 33.64484], [-117.80142, 33.64454], [-117.80176, 33.64425], [-117.80185, 33.64478], [-117.80221, 33.64497], [-117.80231, 33.64525], [-117.80213, 33.64549], [-117.80214, 33.64577], [-117.80227, 33.64605], [-117.80224, 33.64656], [-117.80257, 33.64701], [-117.80322, 33.64727], [-117.80369, 33.64716], [-117.80456, 33.64648], [-117.80467, 33.64685], [-117.80457, 33.64746], [-117.80457, 33.64759], [-117.80431, 33.64778], [-117.80418, 33.64815], [-117.80419, 33.64848], [-117.80432, 33.64881], [-117.80447, 33.64914], [-117.80455, 33.64938], [-117.80438, 33.64975], [-117.80449, 33.65002], [-117.80501, 33.65003], [-117.80525, 33.64976], [-117.80557, 33.6496], [-117.80596, 33.64923], [-117.8062, 33.64924], [-117.80586, 33.64977], [-117.80567, 33.65027], [-117.80574, 33.65061], [-117.80571, 33.65089], [-117.80559, 33.65128], [-117.80576, 33.65151], [-117.80611, 33.65171], [-117.80676, 33.65147], [-117.80557, 33.65302], [-117.80587, 33.65319], [-117.80583, 33.6537], [-117.80589, 33.65395], [-117.80611, 33.65414], [-117.80633, 33.65487], [-117.80659, 33.65525], [-117.80728, 33.65595]]]} | Open Access 1 | 35918 | Irvine holding 20 | 20250 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 60.956 | Irvine holding 20 | 0 | Local Other or Unknown 14 | 4 | |
13583 | 13583 | 13582 | {"type": "Polygon", "coordinates": [[[-117.7653, 33.65872], [-117.76509, 33.6588], [-117.76437, 33.65776], [-117.76351, 33.65795], [-117.76318, 33.65841], [-117.76248, 33.65813], [-117.76217, 33.65813], [-117.76223, 33.65785], [-117.76297, 33.65781], [-117.76335, 33.65777], [-117.76452, 33.65754], [-117.7653, 33.65872]]]} | Open Access 1 | 35917 | Irvine holding 33 | 20264 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 2.659 | Irvine holding 33 | 0 | Local Other or Unknown 14 | 4 | |
13582 | 13582 | 13581 | {"type": "Polygon", "coordinates": [[[-117.8353, 33.67402], [-117.83521, 33.67442], [-117.83504, 33.6743], [-117.83174, 33.6732], [-117.83183, 33.67292], [-117.8353, 33.67402]]]} | Open Access 1 | 35916 | Irvine holding 32 | 20263 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 3.024 | Irvine holding 32 | 0 | Local Other or Unknown 14 | 4 | |
13581 | 13581 | 13580 | {"type": "Polygon", "coordinates": [[[-117.82618, 33.62079], [-117.82531, 33.62145], [-117.82379, 33.62061], [-117.82443, 33.62051], [-117.82478, 33.62026], [-117.82498, 33.61989], [-117.82509, 33.61926], [-117.82491, 33.61905], [-117.82477, 33.61886], [-117.82468, 33.61853], [-117.82468, 33.61806], [-117.82476, 33.61702], [-117.82445, 33.61717], [-117.82345, 33.61752], [-117.82274, 33.61757], [-117.82201, 33.6176], [-117.82157, 33.61755], [-117.82103, 33.61764], [-117.82074, 33.61773], [-117.82058, 33.6171], [-117.82105, 33.61684], [-117.82151, 33.61674], [-117.82196, 33.61684], [-117.82232, 33.61688], [-117.82271, 33.61698], [-117.82322, 33.61703], [-117.82374, 33.61671], [-117.82405, 33.61637], [-117.82432, 33.61626], [-117.82473, 33.61636], [-117.82497, 33.61655], [-117.82524, 33.61666], [-117.82549, 33.61668], [-117.8257, 33.61658], [-117.82578, 33.61658], [-117.82593, 33.61808], [-117.82596, 33.61921], [-117.82618, 33.62079]]]} | Open Access 1 | 35915 | Irvine holding 28 | 20258 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 22.328 | Irvine holding 28 | 0 | Local Other or Unknown 14 | 4 | |
12866 | 12866 | 12865 | {"type": "Polygon", "coordinates": [[[-117.77295, 33.68528], [-117.76975, 33.68834], [-117.76927, 33.68793], [-117.77229, 33.68487], [-117.77295, 33.68528]]]} | Open Access 1 | 35914 | Irvine holding 21 | 20251 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 7.653 | Irvine holding 21 | 0 | Local Other or Unknown 14 | 4 | |
13569 | 13569 | 13568 | {"type": "Polygon", "coordinates": [[[-117.83143, 33.67563], [-117.83123, 33.6757], [-117.83111, 33.67534], [-117.83103, 33.67494], [-117.83089, 33.67409], [-117.83092, 33.6736], [-117.8311, 33.6731], [-117.83133, 33.67316], [-117.83119, 33.67364], [-117.83119, 33.67456], [-117.83127, 33.67498], [-117.83137, 33.67533], [-117.83143, 33.67563]]]} | Open Access 1 | 35913 | Irvine holding 30 | 20261 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 1.639 | Irvine holding 30 | 0 | Local Other or Unknown 14 | 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]);