units_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

45 rows where ACCESS_TYP = 3, MNG_AG_TYP = 12 and YR_EST = 0

This data as json, copyable, CSV (advanced)

Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_WEB, COUNTY, GAP_STS

MNG_AG_TYP 1

  • Non Profit - Conservation · 45 ✖

ACCESS_TYP 1

  • No Public Access · 45 ✖
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
196 196 195 {"type": "Polygon", "coordinates": [[[-116.80824, 32.84466], [-116.80813, 32.84546], [-116.80736, 32.84567], [-116.80702, 32.84516], [-116.80704, 32.84466], [-116.80824, 32.84466]]]} No Public Access 3 46830 Palmer Property 30298 3208 Endangered Habitats Conservancy 79 Non Profit 6 Non Profit - Conservation 12 http://www.ehleague.org/EndangeredHabitatsConservancy.html Non Governmental Organization 10 3208 Endangered Habitats Conservancy 77 Non Profit 6 Non Profit - Conservation 12   San Diego 4 2.548 Palmer Property 0 Private Conservation 16 2
1753 1753 1752 {"type": "Polygon", "coordinates": [[[-122.49925, 38.63647], [-122.49421, 38.63642], [-122.49417, 38.63271], [-122.48533, 38.63279], [-122.48527, 38.62564], [-122.47606, 38.62561], [-122.4761, 38.62202], [-122.48526, 38.62206], [-122.48527, 38.62563], [-122.48765, 38.62558], [-122.48985, 38.62546], [-122.49439, 38.62527], [-122.49434, 38.62156], [-122.49886, 38.62131], [-122.49897, 38.62494], [-122.49908, 38.62919], [-122.49915, 38.63266], [-122.49925, 38.63647]]]} No Public Access 3 13101 Cleary Reserve 17417 3011 California Biological Field Studies Association 420 Non Profit 6 Non Profit - Conservation 12   Non Governmental Organization 10 3011 California Biological Field Studies Association 414 Non Profit 6 Non Profit - Conservation 12   Napa 11 406.373 Cleary Reserve 0 Private Conservation 16 2
2539 2539 2538 {"type": "Polygon", "coordinates": [[[-118.6218, 34.10061], [-118.62167, 34.10067], [-118.6216, 34.10059], [-118.62174, 34.10053], [-118.6218, 34.10061]]]} No Public Access 3 12510 Mountains Restoration Trust Parkland 29660 3044 Mountains Restoration Trust 533 Non Profit 6 Non Profit - Conservation 12 http://www.mountainstrust.org/ Non Governmental Organization 10 3044 Mountains Restoration Trust 526 Non Profit 6 Non Profit - Conservation 12   Los Angeles 6 0.038 Mtns. Restoration Trust Parkland 0 Private Recreation or Education 65 4
2577 2577 2576 {"type": "Polygon", "coordinates": [[[-118.61509, 34.08307], [-118.61508, 34.08325], [-118.61399, 34.08325], [-118.61398, 34.08307], [-118.61509, 34.08307]]]} No Public Access 3 12513 Mountains Restoration Trust Parkland 29660 3044 Mountains Restoration Trust 533 Non Profit 6 Non Profit - Conservation 12 http://www.mountainstrust.org/ Non Governmental Organization 10 3044 Mountains Restoration Trust 526 Non Profit 6 Non Profit - Conservation 12   Los Angeles 6 0.501 Mtns. Restoration Trust Parkland 0 Private Recreation or Education 65 4
2800 2800 2799 {"type": "Polygon", "coordinates": [[[-118.62165, 34.10163], [-118.62148, 34.10166], [-118.62143, 34.10159], [-118.62157, 34.10153], [-118.62165, 34.10163]]]} No Public Access 3 12515 Mountains Restoration Trust Parkland 29660 3044 Mountains Restoration Trust 533 Non Profit 6 Non Profit - Conservation 12 http://www.mountainstrust.org/ Non Governmental Organization 10 3044 Mountains Restoration Trust 526 Non Profit 6 Non Profit - Conservation 12   Los Angeles 6 0.042 Mtns. Restoration Trust Parkland 0 Private Recreation or Education 65 4
3308 3308 3307 {"type": "Polygon", "coordinates": [[[-116.87605, 32.81198], [-116.87602, 32.81296], [-116.87303, 32.81508], [-116.87286, 32.81473], [-116.87304, 32.8145], [-116.87303, 32.81413], [-116.87289, 32.81331], [-116.87318, 32.8132], [-116.87335, 32.81308], [-116.87345, 32.81299], [-116.87353, 32.81288], [-116.87364, 32.81257], [-116.87401, 32.81237], [-116.87427, 32.81228], [-116.87453, 32.81222], [-116.87555, 32.8121], [-116.8758, 32.81205], [-116.87605, 32.81198]]]} No Public Access 3 46828 La Cresta Hills Property 30296 3208 Endangered Habitats Conservancy 79 Non Profit 6 Non Profit - Conservation 12 http://www.ehleague.org/EndangeredHabitatsConservancy.html Non Governmental Organization 10 3208 Endangered Habitats Conservancy 77 Non Profit 6 Non Profit - Conservation 12   San Diego 4 12.874 La Cresta Hills Property 0 Private Conservation 16 2
3309 3309 3308 {"type": "Polygon", "coordinates": [[[-116.86574, 32.79365], [-116.86293, 32.79371], [-116.86299, 32.79622], [-116.86104, 32.79623], [-116.861, 32.79604], [-116.85956, 32.79629], [-116.85947, 32.79387], [-116.85842, 32.79388], [-116.85828, 32.78993], [-116.86564, 32.79012], [-116.86574, 32.79365]]]} No Public Access 3 46829 Michelson Property 30297 3208 Endangered Habitats Conservancy 79 Non Profit 6 Non Profit - Conservation 12 http://www.ehleague.org/EndangeredHabitatsConservancy.html Non Governmental Organization 10 3208 Endangered Habitats Conservancy 77 Non Profit 6 Non Profit - Conservation 12   San Diego 4 91.593 Michelson Property 0 Private Conservation 16 2
3313 3313 3312 {"type": "Polygon", "coordinates": [[[-116.86309, 32.80074], [-116.86305, 32.80446], [-116.86307, 32.8054], [-116.85868, 32.80542], [-116.85866, 32.80438], [-116.85442, 32.80443], [-116.85445, 32.80069], [-116.85863, 32.80069], [-116.86309, 32.80074]]]} No Public Access 3 46834 Ulrich Property 30302 3208 Endangered Habitats Conservancy 79 Non Profit 6 Non Profit - Conservation 12 http://www.ehleague.org/EndangeredHabitatsConservancy.html Non Governmental Organization 10 3208 Endangered Habitats Conservancy 77 Non Profit 6 Non Profit - Conservation 12   San Diego 4 93.312 Ulrich Property 0 Private Conservation 16 2
3739 3739 3738 {"type": "Polygon", "coordinates": [[[-122.53527, 38.06893], [-122.5352, 38.06916], [-122.53501, 38.06911], [-122.53442, 38.06923], [-122.53406, 38.06927], [-122.53308, 38.06944], [-122.53252, 38.06952], [-122.53229, 38.06957], [-122.53239, 38.06949], [-122.53251, 38.06943], [-122.5325, 38.06937], [-122.53297, 38.06927], [-122.53439, 38.06908], [-122.53527, 38.06893]]]} No Public Access 3 31028 Marin Audubon Society 21815 3039 Marin Audubon Society 261 Non Profit 6 Non Profit - Conservation 12 http://www.marinaudubon.org Non Governmental Organization 10 3039 Marin Audubon Society 257 Non Profit 6 Non Profit - Conservation 12   Marin 23 1.098 Marin Audubon Society 0 Private Conservation 16 2
4129 4129 4128 {"type": "Polygon", "coordinates": [[[-118.5962, 34.10228], [-118.59481, 34.10227], [-118.59481, 34.10169], [-118.59619, 34.1017], [-118.5962, 34.10228]]]} No Public Access 3 12686 Topanga Open Space 29663 3044 Mountains Restoration Trust 533 Non Profit 6 Non Profit - Conservation 12 http://www.mountainstrust.org/ Non Governmental Organization 10 3044 Mountains Restoration Trust 526 Non Profit 6 Non Profit - Conservation 12   Los Angeles 6 2.028 Topanga OS 0 Private Recreation or Education 65 4
5115 5115 5114 {"type": "Polygon", "coordinates": [[[-118.61183, 34.07805], [-118.61181, 34.07986], [-118.61069, 34.07986], [-118.61071, 34.07804], [-118.61183, 34.07805]]]} No Public Access 3 12499 Mountains Restoration Trust Parkland 29660 3044 Mountains Restoration Trust 533 Non Profit 6 Non Profit - Conservation 12 http://www.mountainstrust.org/ Non Governmental Organization 10 3044 Mountains Restoration Trust 526 Non Profit 6 Non Profit - Conservation 12   Los Angeles 6 5.129 Mtns. Restoration Trust Parkland 0 Private Recreation or Education 65 4
5116 5116 5115 {"type": "Polygon", "coordinates": [[[-118.6151, 34.08172], [-118.61509, 34.08198], [-118.61399, 34.08198], [-118.61399, 34.08171], [-118.6151, 34.08172]]]} No Public Access 3 12503 Mountains Restoration Trust Parkland 29660 3044 Mountains Restoration Trust 533 Non Profit 6 Non Profit - Conservation 12 http://www.mountainstrust.org/ Non Governmental Organization 10 3044 Mountains Restoration Trust 526 Non Profit 6 Non Profit - Conservation 12   Los Angeles 6 0.733 Mtns. Restoration Trust Parkland 0 Private Recreation or Education 65 4
5406 5406 5405 {"type": "Polygon", "coordinates": [[[-118.77959, 34.0458], [-118.7791, 34.0458], [-118.7791, 34.04539], [-118.77959, 34.04539], [-118.77959, 34.0458]]]} No Public Access 3 12498 Mountains Restoration Trust Parkland 29660 3044 Mountains Restoration Trust 533 Non Profit 6 Non Profit - Conservation 12 http://www.mountainstrust.org/ Non Governmental Organization 10 3044 Mountains Restoration Trust 526 Non Profit 6 Non Profit - Conservation 12   Los Angeles 6 0.514 Mtns. Restoration Trust Parkland 0 Private Recreation or Education 65 4
6810 6810 6809 {"type": "MultiPolygon", "coordinates": [[[[-122.65173, 37.90384], [-122.65158, 37.90401], [-122.65115, 37.90382], [-122.65129, 37.90362], [-122.65173, 37.90384]]], [[[-122.81765, 38.06146], [-122.81754, 38.06146], [-122.81245, 38.06286], [-122.81194, 38.06173], [-122.81125, 38.0612], [-122.81059, 38.06056], [-122.81039, 38.06027], [-122.81315, 38.06025], [-122.812, 38.0582], [-122.81371, 38.05837], [-122.81468, 38.05828], [-122.81566, 38.05855], [-122.81608, 38.05902], [-122.81638, 38.05949], [-122.81568, 38.05977], [-122.8158, 38.06056], [-122.81601, 38.06082], [-122.8167, 38.06063], [-122.81701, 38.06047], [-122.81765, 38.06146]]], [[[-122.84113, 38.10518], [-122.84095, 38.10548], [-122.84078, 38.10549], [-122.84085, 38.1053], [-122.84071, 38.10517], [-122.8379, 38.10183], [-122.83231, 38.09736], [-122.8317, 38.09725], [-122.83173, 38.09716], [-122.83238, 38.09725], [-122.83803, 38.10165], [-122.84015, 38.10423], [-122.84113, 38.10518]]], [[[-122.83548, 38.08171], [-122.8341, 38.08231], [-122.83189, 38.08006], [-122.83318, 38.07953], [-122.83486, 38.08077], [-122.83548, 38.08171]]], [[[-122.84228, 38.08864], [-122.84103, 38.08934], [-122.84025, 38.08854], [-122.8415, 38.08785], [-122.84196, 38.08828], [-122.84228, 38.08864]]], [[[-122.85899, 38.10407], [-122.85845, 38.10455], [-122.85783, 38.10436], [-122.85849, 38.10377], [-122.85899, 38.10407]]], [[[-122.88891, 38.15011], [-122.88843, 38.15017], [-122.88843, 38.15004], [-122.88809, 38.14962], [-122.88773, 38.14911], [-122.88745, 38.14878], [-122.8871, 38.14862], [-122.88702, 38.1485], [-122.88743, 38.14817], [-122.88891, 38.15011]]], [[[-122.90414, 38.17203], [-122.90388, 38.1729], [-122.90099, 38.17342], [-122.90073, 38.17342], [-122.90071, 38.17341], [-122.90057, 38.17348], [-122.89968, 38.17359], [-122.89957, 38.17346], [-122.89817, 38.17223], [-122.89797, 38.1721], [-122.89788, 38.17201], [-122.8981, 38.17137], [-122.89817, 38.17107], [-122.89817, 38.17075], [-122.89666, 38.16946], [-122.89646, 38.16909], [-122.89614, 38.16871], [-122.89591, 38.16839], [-122.89553, 38.16803], [-122.89503, 38.16771], [-122.89481, 38.16759], [-122.89522, 38.16725], [-122.89567, 38.16713], [-122.89675, 38.16701], [-122.89643, 38.16566], [-122.89875, 38.16535], [-122.89916, 38.16474], [-122.89978, 38.16476], [-122.89978, 38.16475], [-122.89764, 38.16335], [-122.8959, 38.16296], [-122.89509, 38.16292], [-122.89436, 38.16304], [-122.89316, 38.16389], [-122.89236, 38.16462], [-122.89211, 38.16516], [-122.89186, 38.16501], [-122.89146, 38.16489], [-122.89135, 38.16483], [-122.89129, 38.16478], [-122.89125, 38.16471], [-122.89124, 38.1646], [-122.89127, 38.16448], [-122.89132, 38.16436], [-122.8914, 38.16425], [-122.8915, 38.16416], [-122.89186, 38.1639], [-122.89328, 38.16265], [-122.89357, 38.16257], [-122.89441, 38.16289], [-122.8947, 38.16257], [-122.89613, 38.16248], [-122.89614, 38.16233], [-122.89659, 38.16232], [-122.89876, 38.16323], [-122.89926, 38.16406], [-122.8998, 38.16436], [-122.8998, 38.16438], [-122.9005, 38.16468], [-122.90055, 38.16467], [-122.9016, 38.16537], [-122.90178, 38.16563], [-122.90182, 38.16565], [-122.90374, 38.16866], [-122.90376, 38.17108], [-122.90414, 38.17203]]], [[[-122.8953, 38.15984], [-122.89499, 38.16023], [-122.89451, 38.16011], [-122.89461, 38.15988], [-122.89466, 38.15964], [-122.89466, 38.15951], [-122.89463, 38.15927], [-122.89519, 38.15913], [-122.89532, 38.15957], [-122.8953, 38.15984]]], [[[-122.9089, 38.17946], [-122.90852, 38.17959], [-122.90767, 38.17868], [-122.90822, 38.1784], [-122.90889, 38.17903], [-122.9089, 38.17946]]], [[[-122.91023, 38.18131], [-122.90988, 38.18144], [-122.90983, 38.18128], [-122.90925, 38.18048], [-122.9092, 38.18027], [-122.90917, 38.18024], [-122.90944, 38.18015], [-122.90968, 38.18042], [-122.91023, 38.18131]]], [[[-122.9139, 38.18884], [-122.91364, 38.18905], [-122.91333, 38.18876], [-122.91308, 38.18846], [-122.91357, 38.18817], [-122.91378, 38.18817], [-122.9139, 38.18884]]], [[[-122.9214, 38.19643], [-122.9201, 38.19691], [-122.91995, 38.19678], [-122.9198, 38.19668], [-122.91973, 38.1966], [-122.91967, 38.1965], [-122.91962, 38.19635], [-122.91961, 38.19605], [-122.91957, 38.19585], [-122.91937, 38.19542], [-122.91927, 38.19517], [-122.92039, 38.19433], [-122.92138, 38.19633], [-122.9214, 38.19643]]], [[[-122.93386, 38.21111], [-122.9338, 38.21165], [-122.93265, 38.21197], [-122.93186, 38.21209], [-122.93142, 38.21286], [-122.92912, 38.21517], [-122.92848, 38.21643], [-122.9281, 38.21748], [-122.9263, 38.21878], [-122.92671, 38.21776], [-122.92653, 38.21229], [-122.92681, 38.20867], [-122.92772, 38.20701], [-122.92895, 38.20698], [-122.92999, 38.20915], [-122.93386, 38.21111]]], [[[-122.95406, 38.21874], [-122.95301, 38.22084], [-122.95266, 38.22165], [-122.95101, 38.22065], [-122.94925, 38.22001], [-122.94862, 38.21989], [-122.94773, 38.22016], [-122.94698, 38.21992], [-122.94759, 38.21871], [-122.94857, 38.21768], [-122.94896, 38.21746], [-122.94924, 38.2168], [-122.95, 38.21597], [-122.94996, 38.21568], [-122.95169, 38.21495], [-122.95283, 38.21445], [-122.95303, 38.21456], [-122.9531, 38.21482], [-122.95354, 38.21541], [-122.95386, 38.21699], [-122.95364, 38.2184], [-122.95369, 38.21852], [-122.95406, 38.21874]]]]} No Public Access 3 5363 Audubon Canyon Ranch 15702 3005 Audubon Canyon Ranch 837 Non Profit 6 Non Profit - Conservation 12 http://www.egret.org Non Governmental Organization 10 3005 Audubon Canyon Ranch 814 Non Profit 6 Non Profit - Conservation 12   Marin 23 380.201 Audubon Canyon Ranch 0 Private Conservation 16 2
7240 7240 7239 {"type": "MultiPolygon", "coordinates": [[[[-118.63834, 34.05331], [-118.63828, 34.05338], [-118.63796, 34.05287], [-118.63805, 34.05287], [-118.63822, 34.05318], [-118.63834, 34.05331]]], [[[-118.6403, 34.06405], [-118.63999, 34.06447], [-118.63883, 34.06406], [-118.63887, 34.06394], [-118.63886, 34.06386], [-118.63882, 34.06371], [-118.63874, 34.06362], [-118.63846, 34.06342], [-118.63832, 34.06326], [-118.63943, 34.06277], [-118.63948, 34.06284], [-118.63955, 34.06289], [-118.63962, 34.06291], [-118.63971, 34.06301], [-118.63979, 34.06313], [-118.63977, 34.06316], [-118.64005, 34.06353], [-118.64004, 34.06366], [-118.64009, 34.06377], [-118.6403, 34.06405]]]]} No Public Access 3 6434 Las Flores Canyon Open Space 29666 3044 Mountains Restoration Trust 533 Non Profit 6 Non Profit - Conservation 12 http://www.mountainstrust.org/ Non Governmental Organization 10 3044 Mountains Restoration Trust 526 Non Profit 6 Non Profit - Conservation 12   Los Angeles 6 4.661 Las Flores Canyon OS 0 Private Recreation or Education 65 4
7266 7266 7265 {"type": "Polygon", "coordinates": [[[-118.61947, 34.11809], [-118.61505, 34.11808], [-118.61507, 34.11444], [-118.61946, 34.11443], [-118.61947, 34.11809]]]} No Public Access 3 6454 Henry Ridge Open Space 29664 3044 Mountains Restoration Trust 533 Non Profit 6 Non Profit - Conservation 12 http://www.mountainstrust.org/ Non Governmental Organization 10 3044 Mountains Restoration Trust 526 Non Profit 6 Non Profit - Conservation 12   Los Angeles 6 40.702 Henry Ridge OS 0 Private Recreation or Education 65 4
11527 11527 11526 {"type": "Polygon", "coordinates": [[[-116.89504, 32.80952], [-116.89448, 32.80974], [-116.89425, 32.80982], [-116.89392, 32.80989], [-116.89358, 32.80992], [-116.89315, 32.80992], [-116.89296, 32.80991], [-116.89182, 32.80963], [-116.89176, 32.80812], [-116.89229, 32.80568], [-116.89368, 32.8059], [-116.89443, 32.80579], [-116.894, 32.80809], [-116.89504, 32.80952]]]} No Public Access 3 46835 Walker Priest/La Cresta Property 30303 3208 Endangered Habitats Conservancy 79 Non Profit 6 Non Profit - Conservation 12 http://www.ehleague.org/EndangeredHabitatsConservancy.html Non Governmental Organization 10 3208 Endangered Habitats Conservancy 77 Non Profit 6 Non Profit - Conservation 12   San Diego 4 25.204 Walker Priest/La Cresta Property 0 Private Conservation 16 2
11530 11530 11529 {"type": "MultiPolygon", "coordinates": [[[[-116.84201, 32.81202], [-116.84191, 32.8121], [-116.84131, 32.81251], [-116.8413, 32.81202], [-116.84201, 32.81202]]], [[[-116.84567, 32.81198], [-116.84566, 32.81571], [-116.84136, 32.8157], [-116.84133, 32.81349], [-116.84145, 32.81348], [-116.84145, 32.81308], [-116.84132, 32.81295], [-116.84132, 32.81279], [-116.84209, 32.81225], [-116.84236, 32.81201], [-116.84567, 32.81198]]]]} No Public Access 3 46826 Harbison Canyon Property 30294 3208 Endangered Habitats Conservancy 79 Non Profit 6 Non Profit - Conservation 12 http://www.ehleague.org/EndangeredHabitatsConservancy.html Non Governmental Organization 10 3208 Endangered Habitats Conservancy 77 Non Profit 6 Non Profit - Conservation 12   San Diego 4 40.355 Harbison Canyon Property 0 Private Conservation 16 2
11539 11539 11538 {"type": "Polygon", "coordinates": [[[-116.89741, 32.80669], [-116.89677, 32.80745], [-116.89737, 32.80782], [-116.89656, 32.80874], [-116.8966, 32.80905], [-116.89615, 32.80913], [-116.89571, 32.80924], [-116.89504, 32.80952], [-116.894, 32.80809], [-116.89443, 32.80579], [-116.89458, 32.80576], [-116.89741, 32.80669]]]} No Public Access 3 46831 Sarjay/La Cresta Property 30299 3208 Endangered Habitats Conservancy 79 Non Profit 6 Non Profit - Conservation 12 http://www.ehleague.org/EndangeredHabitatsConservancy.html Non Governmental Organization 10 3208 Endangered Habitats Conservancy 77 Non Profit 6 Non Profit - Conservation 12   San Diego 4 21.548 Sarjay/La Cresta Property 0 Private Conservation 16 2
11540 11540 11539 {"type": "Polygon", "coordinates": [[[-116.88944, 32.80854], [-116.88892, 32.80921], [-116.88842, 32.809], [-116.8881, 32.80881], [-116.88819, 32.80758], [-116.88937, 32.8079], [-116.88944, 32.80854]]]} No Public Access 3 46832 Saxena/La Cresta Property 30300 3208 Endangered Habitats Conservancy 79 Non Profit 6 Non Profit - Conservation 12 http://www.ehleague.org/EndangeredHabitatsConservancy.html Non Governmental Organization 10 3208 Endangered Habitats Conservancy 77 Non Profit 6 Non Profit - Conservation 12   San Diego 4 4.044 Saxena/La Cresta Property 0 Private Conservation 16 2

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);