units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP, LAYER
ACCESS_TYP 4
- Open Access 14,497
- Restricted Access 1,200
- No Public Access 969
- Unknown Access 382
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4481 | 4481 | 4480 | {"type": "Polygon", "coordinates": [[[-118.36745, 34.34431], [-118.36743, 34.34613], [-118.36606, 34.34614], [-118.36599, 34.34579], [-118.36591, 34.34567], [-118.36583, 34.34561], [-118.36568, 34.34555], [-118.36509, 34.34549], [-118.36511, 34.34439], [-118.36643, 34.34432], [-118.36745, 34.34431]]]} | Open Access 1 | 4296 | Unnamed site - Santa Monica Mountains Conservancy | 29566 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 9.278 | 0 | Local Other or Unknown 14 | 4 | ||
4482 | 4482 | 4481 | {"type": "Polygon", "coordinates": [[[-118.82809, 34.1109], [-118.82374, 34.11089], [-118.82373, 34.10731], [-118.82808, 34.10728], [-118.82809, 34.1109]]]} | Unknown Access 4 | 4333 | Unnamed site - Santa Monica Mountains Conservancy | 29513 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 39.614 | 0 | Local Other or Unknown 14 | 4 | ||
4483 | 4483 | 4482 | {"type": "Polygon", "coordinates": [[[-118.83243, 34.10717], [-118.83243, 34.10853], [-118.82873, 34.10863], [-118.82809, 34.10863], [-118.82808, 34.10727], [-118.82875, 34.10727], [-118.83243, 34.10717]]]} | Unknown Access 4 | 4342 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 14.94 | 0 | Local Other or Unknown 14 | 4 | ||
4484 | 4484 | 4483 | {"type": "Polygon", "coordinates": [[[-116.0659, 33.7911], [-116.05721, 33.7911], [-116.05721, 33.78748], [-116.0659, 33.78747], [-116.0659, 33.7911]]]} | Unknown Access 4 | 4435 | Unnamed site - The Wildlands Conservancy | 28672 | 3092 | The Wildlands Conservancy 228 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.wildlandsconservancy.org/ | Non Governmental Organization 10 | 3092 | The Wildlands Conservancy 224 | Non Profit 6 | Non Profit - Land Trust 10 | Riverside 10 | 79.972 | 0 | Private Other or Unknown 399 | 4 | ||
4485 | 4485 | 4484 | {"type": "Polygon", "coordinates": [[[-116.23302, 33.58134], [-116.23293, 33.58128], [-116.23136, 33.57741], [-116.23092, 33.57648], [-116.22951, 33.57441], [-116.22812, 33.57509], [-116.22717, 33.57368], [-116.22436, 33.5737], [-116.22436, 33.57461], [-116.22274, 33.57463], [-116.22139, 33.57376], [-116.22098, 33.57302], [-116.22093, 33.57256], [-116.22053, 33.57243], [-116.22029, 33.57202], [-116.21854, 33.57148], [-116.21604, 33.57082], [-116.21605, 33.56939], [-116.22448, 33.56938], [-116.22417, 33.57223], [-116.22418, 33.57224], [-116.22904, 33.56937], [-116.233, 33.56936], [-116.23299, 33.57257], [-116.23302, 33.58134]]]} | Open Access 1 | 4461 | Unnamed site - Riverside County Regional Park and Open Space District | 28656 | 2123 | Riverside County Regional Park and Open Space District 262 | Special District 4 | Recreation/Parks District 4 | http://www.riversidecountyparks.org/ | Special District 4 | 2123 | Riverside County Regional Park and Open Space District 258 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 187.128 | 0 | Local Other or Unknown 14 | 4 | ||
4486 | 4486 | 4485 | {"type": "Polygon", "coordinates": [[[-116.24853, 33.84567], [-116.24851, 33.84812], [-116.24644, 33.84703], [-116.24644, 33.84565], [-116.24853, 33.84567]]]} | Unknown Access 4 | 4473 | Unnamed site - California Wildlife Conservation Board | 28678 | 212 | California Wildlife Conservation Board 766 | State 5 | State Agency 5 | http://www.wcb.ca.gov/ | Other State 5 | 212 | California Wildlife Conservation Board 747 | State 5 | State Agency 5 | Riverside 10 | 10.124 | 0 | State Other or Unknown 104 | 4 | ||
4487 | 4487 | 4486 | {"type": "Polygon", "coordinates": [[[-117.65095, 33.91007], [-117.65019, 33.91006], [-117.64981, 33.90897], [-117.65009, 33.9089], [-117.65007, 33.90881], [-117.65045, 33.90848], [-117.65044, 33.90828], [-117.64965, 33.9076], [-117.64926, 33.90648], [-117.65093, 33.90642], [-117.65095, 33.91007]]]} | Unknown Access 4 | 4844 | Unnamed site - Orange County Water District | 28653 | 2105 | Orange County Water District 768 | Special District 4 | Water District 13 | http://www.ocwd.com/ | Special District 4 | 2105 | Orange County Water District 749 | Special District 4 | Water District 13 | Riverside 10 | 9.715 | 0 | Local Other or Unknown 14 | 4 | ||
4488 | 4488 | 4487 | {"type": "Polygon", "coordinates": [[[-117.65093, 33.90642], [-117.64926, 33.90648], [-117.64867, 33.90481], [-117.64847, 33.90433], [-117.64801, 33.90334], [-117.65091, 33.90307], [-117.65093, 33.90642]]]} | Open Access 1 | 4845 | Unnamed site - Other Federal | 28636 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Riverside 10 | 18.733 | 0 | Federal Other or Unknown 87 | 4 | |||
4489 | 4489 | 4488 | {"type": "MultiPolygon", "coordinates": [[[[-118.21759, 34.10846], [-118.21735, 34.1085], [-118.21726, 34.10813], [-118.21751, 34.10809], [-118.21759, 34.10846]]], [[[-118.21918, 34.10822], [-118.21901, 34.10857], [-118.21832, 34.10834], [-118.21784, 34.10842], [-118.21775, 34.10805], [-118.21837, 34.10795], [-118.21918, 34.10822]]]]} | Unknown Access 4 | 4922 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 1.517 | 0 | Local Other or Unknown 14 | 4 | ||
4492 | 4492 | 4491 | {"type": "Polygon", "coordinates": [[[-118.35128, 33.78024], [-118.35122, 33.78036], [-118.35108, 33.78051], [-118.35086, 33.78065], [-118.35069, 33.7807], [-118.35057, 33.78035], [-118.35093, 33.78032], [-118.35092, 33.78], [-118.35108, 33.78], [-118.35119, 33.78003], [-118.35127, 33.78011], [-118.35128, 33.78024]]]} | Open Access 1 | 5914 | Unnamed site - Westfield Recreation and Park District | 28676 | 2180 | Westfield Recreation and Park District 769 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2180 | Westfield Recreation and Park District 750 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 0.653 | 0 | Local Other or Unknown 14 | 4 | |||
4493 | 4493 | 4492 | {"type": "Polygon", "coordinates": [[[-118.36086, 33.76832], [-118.3608, 33.76862], [-118.36056, 33.76861], [-118.36041, 33.76865], [-118.36031, 33.76842], [-118.36043, 33.76817], [-118.36086, 33.76832]]]} | Open Access 1 | 5915 | Unknown park - Westfield Recreation and Park District | 28677 | 2180 | Westfield Recreation and Park District 769 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2180 | Westfield Recreation and Park District 750 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 0.462 | 0 | Local Other or Unknown 14 | 4 | |||
4494 | 4494 | 4493 | {"type": "MultiPolygon", "coordinates": [[[[-118.48772, 34.08391], [-118.48608, 34.08433], [-118.48643, 34.08403], [-118.48641, 34.0838], [-118.48584, 34.08367], [-118.48547, 34.08363], [-118.48523, 34.08321], [-118.48495, 34.08305], [-118.48428, 34.08244], [-118.48405, 34.08227], [-118.48404, 34.08202], [-118.48463, 34.08151], [-118.48463, 34.08149], [-118.48417, 34.0812], [-118.4839, 34.08119], [-118.48367, 34.08055], [-118.48292, 34.08084], [-118.48286, 34.08076], [-118.48285, 34.0806], [-118.48289, 34.08051], [-118.48297, 34.08043], [-118.48317, 34.0803], [-118.48326, 34.08018], [-118.48328, 34.08012], [-118.48328, 34.07998], [-118.48324, 34.07986], [-118.48355, 34.07978], [-118.48394, 34.07935], [-118.48368, 34.07917], [-118.48344, 34.07892], [-118.48336, 34.07889], [-118.48328, 34.07888], [-118.48317, 34.07892], [-118.48311, 34.07896], [-118.48289, 34.07935], [-118.48269, 34.07953], [-118.48254, 34.07962], [-118.48232, 34.0797], [-118.48228, 34.07956], [-118.48232, 34.07959], [-118.48237, 34.07958], [-118.48254, 34.0795], [-118.48269, 34.0794], [-118.48282, 34.07926], [-118.48301, 34.0789], [-118.48309, 34.07884], [-118.48318, 34.0788], [-118.48332, 34.07878], [-118.48341, 34.0788], [-118.48349, 34.07883], [-118.48374, 34.07908], [-118.48385, 34.07916], [-118.48394, 34.07908], [-118.48445, 34.079], [-118.48445, 34.07898], [-118.48415, 34.07889], [-118.48396, 34.07875], [-118.48384, 34.07863], [-118.48446, 34.0785], [-118.48438, 34.07781], [-118.48492, 34.07793], [-118.48528, 34.07785], [-118.48533, 34.07853], [-118.48703, 34.08031], [-118.48658, 34.08035], [-118.48608, 34.0803], [-118.4858, 34.08015], [-118.48551, 34.08012], [-118.48549, 34.08052], [-118.48531, 34.08051], [-118.48524, 34.08052], [-118.48522, 34.08048], [-118.48494, 34.08073], [-118.4849, 34.08089], [-118.48507, 34.08107], [-118.48499, 34.08114], [-118.48513, 34.08124], [-118.48487, 34.08145], [-118.48542, 34.08176], [-118.4851, 34.08231], [-118.48522, 34.08266], [-118.48577, 34.08254], [-118.48602, 34.08284], [-118.48633, 34.0829], [-118.48701, 34.08282], [-118.48705, 34.08368], [-118.48753, 34.08379], [-118.48757, 34.0837], [-118.48772, 34.08391]]], [[[-118.48863, 34.08368], [-118.48838, 34.08375], [-118.48802, 34.08326], [-118.48819, 34.08317], [-118.48834, 34.08321], [-118.48831, 34.08326], [-118.48838, 34.08346], [-118.48863, 34.08368]]]]} | Open Access 1 | 6379 | Unnamed site - Santa Monica Mountains Conservancy | 29566 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 26.137 | 0 | Local Other or Unknown 14 | 4 | ||
4495 | 4495 | 4494 | {"type": "Polygon", "coordinates": [[[-118.43891, 34.09306], [-118.43861, 34.0933], [-118.43858, 34.0933], [-118.43856, 34.09326], [-118.43886, 34.09303], [-118.43891, 34.09306]]]} | Open Access 1 | 6391 | Unnamed site - Mountains Recreation and Conservation Authority | 29458 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.059 | 0 | Local Other or Unknown 14 | 4 | ||
4496 | 4496 | 4495 | {"type": "Polygon", "coordinates": [[[-118.60626, 34.1253], [-118.60623, 34.13266], [-118.59929, 34.1327], [-118.59961, 34.13183], [-118.59966, 34.13163], [-118.59969, 34.13142], [-118.59969, 34.13121], [-118.59966, 34.13101], [-118.59961, 34.1308], [-118.59943, 34.13031], [-118.59942, 34.13019], [-118.59944, 34.13007], [-118.59949, 34.12996], [-118.59957, 34.12985], [-118.60041, 34.12913], [-118.60052, 34.12902], [-118.60059, 34.1289], [-118.60064, 34.12877], [-118.60066, 34.12864], [-118.60065, 34.1285], [-118.6006, 34.12837], [-118.60053, 34.12825], [-118.60038, 34.12809], [-118.60024, 34.12801], [-118.60002, 34.12793], [-118.59987, 34.12791], [-118.599, 34.12792], [-118.59881, 34.12789], [-118.59869, 34.12784], [-118.59855, 34.12772], [-118.59848, 34.12757], [-118.59847, 34.12746], [-118.59851, 34.12731], [-118.59858, 34.12721], [-118.59868, 34.12714], [-118.59879, 34.12708], [-118.59892, 34.12705], [-118.59959, 34.12704], [-118.59986, 34.127], [-118.60003, 34.12695], [-118.60018, 34.12688], [-118.60032, 34.12678], [-118.60044, 34.12667], [-118.60058, 34.12645], [-118.60063, 34.12625], [-118.60063, 34.12602], [-118.60059, 34.12587], [-118.60052, 34.12573], [-118.60043, 34.12561], [-118.60019, 34.12535], [-118.60626, 34.1253]]]} | Open Access 1 | 6422 | Unnamed site - Santa Monica Mountains Conservancy | 29566 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 119.03 | 0 | Local Other or Unknown 14 | 4 | ||
4497 | 4497 | 4496 | {"type": "MultiPolygon", "coordinates": [[[[-118.61094, 34.12902], [-118.6108, 34.12935], [-118.61077, 34.12954], [-118.61082, 34.12973], [-118.61094, 34.12991], [-118.60624, 34.12989], [-118.60625, 34.129], [-118.61094, 34.12902]]], [[[-118.61483, 34.12903], [-118.61482, 34.12993], [-118.6113, 34.12992], [-118.61127, 34.12984], [-118.61114, 34.12966], [-118.61111, 34.12957], [-118.61111, 34.12943], [-118.6113, 34.12902], [-118.61483, 34.12903]]]]} | Open Access 1 | 6425 | Unnamed site - Santa Monica Mountains Conservancy | 29566 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 18.661 | 0 | Local Other or Unknown 14 | 4 | ||
4498 | 4498 | 4497 | {"type": "Polygon", "coordinates": [[[-118.634, 34.0408], [-118.63396, 34.04093], [-118.63385, 34.04103], [-118.63373, 34.04109], [-118.63327, 34.0412], [-118.63319, 34.04126], [-118.63316, 34.04135], [-118.63256, 34.04136], [-118.63187, 34.04073], [-118.63262, 34.04016], [-118.63324, 34.04077], [-118.63362, 34.04088], [-118.634, 34.0408]]]} | Open Access 1 | 6461 | Unnamed site - Mountains Recreation and Conservation Authority | 29458 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 3.063 | 0 | Local Other or Unknown 14 | 4 | ||
4499 | 4499 | 4498 | {"type": "MultiPolygon", "coordinates": [[[[-118.03255, 33.97371], [-118.03203, 33.9737], [-118.03203, 33.97351], [-118.03246, 33.97351], [-118.03249, 33.97355], [-118.03255, 33.97359], [-118.03255, 33.97371]]], [[[-118.03556, 33.97383], [-118.03511, 33.97384], [-118.0351, 33.9737], [-118.03556, 33.9737], [-118.03556, 33.97383]]], [[[-118.03609, 33.9737], [-118.03608, 33.97384], [-118.03563, 33.97384], [-118.03562, 33.97371], [-118.03609, 33.9737]]], [[[-118.03723, 33.98024], [-118.03676, 33.98024], [-118.03676, 33.98001], [-118.03723, 33.98002], [-118.03723, 33.98024]]], [[[-118.03912, 33.97384], [-118.03866, 33.97384], [-118.03865, 33.97371], [-118.03912, 33.97371], [-118.03912, 33.97384]]], [[[-118.03965, 33.97385], [-118.03919, 33.97384], [-118.03919, 33.97371], [-118.03965, 33.97371], [-118.03965, 33.97385]]], [[[-118.04028, 33.97371], [-118.04027, 33.97385], [-118.03981, 33.97384], [-118.03981, 33.97371], [-118.04028, 33.97371]]], [[[-118.0408, 33.97384], [-118.04035, 33.97385], [-118.04034, 33.97371], [-118.0408, 33.97371], [-118.0408, 33.97384]]], [[[-118.04143, 33.97385], [-118.04096, 33.97384], [-118.04097, 33.97371], [-118.04142, 33.97371], [-118.04143, 33.97385]]], [[[-118.04196, 33.97385], [-118.04149, 33.97385], [-118.04149, 33.97371], [-118.04196, 33.97371], [-118.04196, 33.97385]]], [[[-118.04312, 33.97387], [-118.04306, 33.97383], [-118.04264, 33.97382], [-118.04225, 33.97382], [-118.04219, 33.97387], [-118.04218, 33.97373], [-118.04223, 33.97369], [-118.04311, 33.97369], [-118.04312, 33.97387]]]]} | Open Access 1 | 6534 | Unnamed site - Whittier, City of | 29858 | 1380 | Whittier, City of 291 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 2.108 | 0 | Local Other or Unknown 14 | 4 | ||
4500 | 4500 | 4499 | {"type": "Polygon", "coordinates": [[[-118.14894, 33.76065], [-118.14889, 33.76086], [-118.14849, 33.76069], [-118.14818, 33.7606], [-118.14798, 33.76055], [-118.14796, 33.76053], [-118.14796, 33.76047], [-118.14799, 33.76044], [-118.14804, 33.76043], [-118.14818, 33.76043], [-118.14894, 33.76065]]]} | Open Access 1 | 6605 | Unknown park - Long Beach, City of | 29921 | 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 | 0.432 | 0 | Local Other or Unknown 14 | 4 | ||
4501 | 4501 | 4500 | {"type": "Polygon", "coordinates": [[[-118.37435, 34.11711], [-118.37403, 34.11705], [-118.37409, 34.11687], [-118.37412, 34.11683], [-118.37422, 34.1168], [-118.3743, 34.11685], [-118.37432, 34.11689], [-118.37435, 34.11711]]]} | Open Access 1 | 6903 | Unnamed site - Mountains Recreation and Conservation Authority | 29458 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.175 | 0 | Local Other or Unknown 14 | 4 | ||
4502 | 4502 | 4501 | {"type": "Polygon", "coordinates": [[[-118.3487, 34.22826], [-118.34868, 34.2308], [-118.34849, 34.2308], [-118.34809, 34.23097], [-118.3474, 34.23114], [-118.3467, 34.23152], [-118.34636, 34.23087], [-118.34599, 34.23099], [-118.34557, 34.23118], [-118.34552, 34.23116], [-118.34545, 34.23116], [-118.3454, 34.23097], [-118.34505, 34.23057], [-118.34435, 34.23104], [-118.34439, 34.22813], [-118.3487, 34.22826]]]} | Open Access 1 | 6853 | Unnamed site - Santa Monica Mountains Conservancy | 29566 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 30.789 | 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]);