units_with_maps

Table actions

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

48 rows where ACCESS_TYP = 1 and DES_TP = 65

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP

ACCESS_TYP 1

  • Open Access · 48 ✖
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
1523 1523 1522 {"type": "Polygon", "coordinates": [[[-116.78494, 33.12411], [-116.78019, 33.12414], [-116.7802, 33.12031], [-116.7849, 33.12029], [-116.78494, 33.12411]]]} Open Access 1 12843 Corral Mountain Open Space 17655 3066 San Dieguito River Valley Land Conservancy 378 Non Profit 6 Non Profit - Land Trust 10 http://www.sdrvc.org/ Non Governmental Organization 10 3066 San Dieguito River Valley Land Conservancy 373 Non Profit 6 Non Profit - Land Trust 10   San Diego 4 46.202 Corral Mtn. OS 0 Private Recreation or Education 65 4
1961 1961 1960 {"type": "Polygon", "coordinates": [[[-119.64038, 37.32984], [-119.64037, 37.33056], [-119.6394, 37.33019], [-119.63911, 37.33026], [-119.63852, 37.33009], [-119.63833, 37.32985], [-119.63942, 37.32983], [-119.64038, 37.32984]]]} Open Access 1 16718 Fresno Flats Historic Park 19111 3078 Sierra Historic Sites Association 462 Non Profit 6 Non Profit - Other 22 http://www.fresnoflatsmuseum.org/ Non Governmental Organization 10 3078 Sierra Historic Sites Association 455 Non Profit 6 Non Profit - Other 20   Madera 48 2.12 Fresno Flats Historic Park 0 Private Recreation or Education 65 4
2838 2838 2837 {"type": "Polygon", "coordinates": [[[-121.93421, 36.60999], [-121.93184, 36.60975], [-121.932, 36.60951], [-121.93212, 36.60925], [-121.93222, 36.60897], [-121.93226, 36.6088], [-121.93229, 36.60854], [-121.93229, 36.60833], [-121.93227, 36.60812], [-121.93222, 36.60787], [-121.93214, 36.60765], [-121.93203, 36.60742], [-121.9319, 36.60721], [-121.93327, 36.60681], [-121.93327, 36.60718], [-121.9333, 36.60759], [-121.9334, 36.60812], [-121.9335, 36.60851], [-121.93372, 36.60916], [-121.93395, 36.60967], [-121.93405, 36.60983], [-121.93421, 36.60999]]]} Open Access 1 65 Rip Van Winkle Open Space 24395 3016 Del Monte Forest Foundation 559 Non Profit 6 Non Profit - Conservation 12 http://www.delmonteforestfoundation.org/ Non Governmental Organization 10 3016 Del Monte Forest Foundation 552 Non Profit 6 Non Profit - Conservation 12   Monterey 14 9.948 Rip Van Winkle OS 0 Private Recreation or Education 65 4
2962 2962 2961 {"type": "Polygon", "coordinates": [[[-118.29523, 33.84631], [-118.29172, 33.84632], [-118.29173, 33.84625], [-118.2918, 33.84624], [-118.29178, 33.84558], [-118.29179, 33.84535], [-118.29492, 33.84531], [-118.29492, 33.84546], [-118.29489, 33.84556], [-118.29491, 33.84563], [-118.29498, 33.8457], [-118.29507, 33.84574], [-118.29523, 33.84572], [-118.29523, 33.84631]]]} Open Access 1 48646 Wishing Tree Park 33392 3269 Los Angeles Neighborhood Land Trust 564 Non Profit 6 Non Profit - Land Trust 10 http://www.lanlt.org/ Non Governmental Organization 10 3269 Los Angeles Neighborhood Land Trust 556 Non Profit 6 Non Profit - Land Trust 10 https://www.lanlt.org/projectupdates Los Angeles 6 8.29 Wishing Tree Park 2020 Private Recreation or Education 65 4
2966 2966 2965 {"type": "Polygon", "coordinates": [[[-118.28333, 34.05806], [-118.28325, 34.05818], [-118.28282, 34.05798], [-118.2829, 34.05786], [-118.28333, 34.05806]]]} Open Access 1 48647 Golden Age Park 33393 3269 Los Angeles Neighborhood Land Trust 564 Non Profit 6 Non Profit - Land Trust 10 http://www.lanlt.org/ Non Governmental Organization 10 3269 Los Angeles Neighborhood Land Trust 556 Non Profit 6 Non Profit - Land Trust 10 https://www.lanlt.org/projectupdates Los Angeles 6 0.172 Golden Age Park 2019 Private Recreation or Education 65 4
3808 3808 3807 {"type": "Polygon", "coordinates": [[[-121.77003, 37.62324], [-121.77003, 37.62946], [-121.76542, 37.62945], [-121.76621, 37.62868], [-121.76783, 37.62822], [-121.76803, 37.62682], [-121.76808, 37.62681], [-121.76802, 37.62328], [-121.76102, 37.62522], [-121.76017, 37.6241], [-121.75799, 37.62352], [-121.75806, 37.62347], [-121.75914, 37.62234], [-121.76547, 37.62237], [-121.76549, 37.62329], [-121.76734, 37.62327], [-121.76735, 37.62313], [-121.76821, 37.62312], [-121.76822, 37.62326], [-121.77003, 37.62324]]]} Open Access 1 35127 Sycamore Grove Park 26129 3083 Tri-Valley Conservancy 687 Non Profit 6 Non Profit - Land Trust 10 http://www.trivalleyconservancy.org/ Non Governmental Organization 10 3083 Tri-Valley Conservancy 678 Non Profit 6 Non Profit - Land Trust 10   Alameda 17 73.084 Sycamore Grove Park 0 Private Recreation or Education 65 4
3845 3845 3844 {"type": "Polygon", "coordinates": [[[-118.18362, 34.14471], [-118.18351, 34.1448], [-118.18343, 34.14491], [-118.18336, 34.1451], [-118.18336, 34.1453], [-118.1834, 34.14542], [-118.18348, 34.14554], [-118.18357, 34.14564], [-118.18353, 34.1458], [-118.18343, 34.14596], [-118.1821, 34.14546], [-118.18217, 34.14478], [-118.18267, 34.14401], [-118.18325, 34.14443], [-118.18319, 34.14449], [-118.18324, 34.14457], [-118.18336, 34.14452], [-118.18362, 34.14471]]]} Open Access 1 46810 Eagle Rock Canyon Trail 30271 3367 The Collaborative Eagle Rock Beautiful 692 Non Profit 6 Non Profit - Other 22 http://www.cerb.us/ Non Governmental Organization 10 3367 The Collaborative Eagle Rock Beautiful 682 Non Profit 6 Non Profit - Other 20 http://www.cerb.us/ Los Angeles 6 4.567 Eagle Rock Canyon Trail 0 Private Recreation or Education 65 4
3931 3931 3930 {"type": "Polygon", "coordinates": [[[-117.15178, 32.71015], [-117.15154, 32.71016], [-117.15154, 32.71036], [-117.15114, 32.71036], [-117.15113, 32.70953], [-117.15178, 32.70953], [-117.15178, 32.71015]]]} Open Access 1 48832 Fault Line Park 33551 6133 Pinnacle International Development, Inc 701 Private 7 Commercial 20 http://www.pinnacleinternational.ca/resume Private 14 6133 Pinnacle International Development, Inc 689 Private 7 Commercial 18   San Diego 4 1.249 Fault Line Park 0 Private Recreation or Education 65 4
4022 4022 4021 {"type": "Polygon", "coordinates": [[[-118.29141, 33.96539], [-118.29091, 33.96539], [-118.29091, 33.96521], [-118.29141, 33.96521], [-118.29141, 33.96539]]]} Open Access 1 46884 Vermont Miracle Park 32598 3269 Los Angeles Neighborhood Land Trust 564 Non Profit 6 Non Profit - Land Trust 10 http://www.lanlt.org/ Non Governmental Organization 10 3269 Los Angeles Neighborhood Land Trust 556 Non Profit 6 Non Profit - Land Trust 10   Los Angeles 6 0.23 Vermont Miracle Park 0 Private Recreation or Education 65 4
4024 4024 4023 {"type": "Polygon", "coordinates": [[[-119.29637, 34.28467], [-119.29622, 34.28505], [-119.29605, 34.2852], [-119.29592, 34.28522], [-119.29579, 34.28522], [-119.29576, 34.28518], [-119.29569, 34.28521], [-119.29557, 34.28515], [-119.29543, 34.28497], [-119.29559, 34.28481], [-119.29613, 34.2845], [-119.29628, 34.28453], [-119.29637, 34.28467]]]} Open Access 1 46895 Serra Cross Park 30394 3369 San Buenaventura Heritage 711 Non Profit 6 Non Profit - Other 22 http://dudleyhouse.org/ Non Governmental Organization 10 3370 Serra Cross Conservancy 696 Non Profit 6 Non Profit - Conservation 12   Ventura 8 1.051 Serra Cross Park 0 Private Recreation or Education 65 4
4108 4108 4107 {"type": "Polygon", "coordinates": [[[-123.7877, 39.63706], [-123.78765, 39.63715], [-123.78756, 39.63709], [-123.78747, 39.63706], [-123.78742, 39.637], [-123.78734, 39.63695], [-123.78728, 39.63696], [-123.78707, 39.63694], [-123.78693, 39.63696], [-123.78677, 39.63716], [-123.7867, 39.63731], [-123.78664, 39.63756], [-123.78663, 39.63766], [-123.78665, 39.63786], [-123.78672, 39.63793], [-123.78675, 39.63799], [-123.78679, 39.63805], [-123.78703, 39.63809], [-123.78709, 39.63817], [-123.78709, 39.63824], [-123.78705, 39.63828], [-123.78701, 39.6383], [-123.78677, 39.63832], [-123.78672, 39.63838], [-123.78583, 39.63835], [-123.78581, 39.63823], [-123.78569, 39.63822], [-123.78568, 39.63835], [-123.78539, 39.63835], [-123.78536, 39.6379], [-123.785, 39.63789], [-123.78502, 39.63729], [-123.785, 39.63673], [-123.78517, 39.63673], [-123.78518, 39.63661], [-123.78502, 39.63659], [-123.785, 39.63648], [-123.7852, 39.63649], [-123.78521, 39.63616], [-123.785, 39.63614], [-123.785, 39.63607], [-123.78515, 39.63606], [-123.78514, 39.63598], [-123.785, 39.63598], [-123.78501, 39.6358], [-123.78536, 39.6358], [-123.78538, 39.63565], [-123.78636, 39.63564], [-123.78647, 39.63567], [-123.78654, 39.63571], [-123.78654, 39.63579], [-123.7865, 39.63582], [-123.78642, 39.63586], [-123.78625, 39.63582], [-123.78619, 39.63582], [-123.78615, 39.63585], [-123.78613, 39.6359], [-123.78613, 39.63594], [-123.78616, 39.636], [-123.7862, 39.63604], [-123.78636, 39.63606], [-123.78643, 39.63609], [-123.78645, 39.63618], [-123.78636, 39.63628], [-123.78634, 39.63634], [-123.78636, 39.63639], [-123.78656, 39.63645], [-123.78683, 39.63661], [-123.78692, 39.63669], [-123.78707, 39.63669], [-123.78713, 39.63662], [-123.78723, 39.63664], [-123.78731, 39.63668], [-123.78739, 39.63676], [-123.78757, 39.63684], [-123.78764, 39.6369], [-123.78769, 39.63698], [-123.7877, 39.63706]]]} Open Access 1 47070 Westport Headlands Park 30721 3375 Westport Village Society 722 Non Profit 6 Non Profit - Conservation 12 http://www.westportvillagesociety.org/ Non Governmental Organization 10 3375 Westport Village Society 707 Non Profit 6 Non Profit - Conservation 12   Mendocino 24 10.269 Westport Headlands Park 0 Private Recreation or Education 65 4
4158 4158 4157 {"type": "Polygon", "coordinates": [[[-118.26097, 33.95842], [-118.26096, 33.95916], [-118.26076, 33.95916], [-118.26076, 33.95842], [-118.26097, 33.95842]]]} Open Access 1 45111 WAYS Reading and Fitness Park 28122 3352 Heal the Bay 726 Non Profit 6 Non Profit - Other 22 http://www.healthebay.org/ Non Governmental Organization 10 3352 Heal the Bay 711 Non Profit 6 Non Profit - Other 20   Los Angeles 6 0.387 WAYS Reading and Fitness Park 0 Private Recreation or Education 65 4
4230 4230 4229 {"type": "Polygon", "coordinates": [[[-118.25946, 34.06588], [-118.25927, 34.06617], [-118.25885, 34.06598], [-118.25904, 34.06569], [-118.25946, 34.06588]]]} Open Access 1 45071 Patton Street Park 28079 3094 Trust for Public Land 734 Non Profit 6 Non Profit - Conservation 12 http://www.tpl.org/ Non Governmental Organization 10 3094 Trust for Public Land 718 Non Profit 6 Non Profit - Conservation 12 https://www.tpl.org/our-work/parks-for-people/patton-street-park Los Angeles 6 0.4 Patton Street Park 0 Private Recreation or Education 65 4
4311 4311 4310 {"type": "Polygon", "coordinates": [[[-124.14215, 41.06163], [-124.14216, 41.06222], [-124.14214, 41.06229], [-124.14209, 41.0624], [-124.14204, 41.06246], [-124.14198, 41.06251], [-124.14186, 41.06258], [-124.14184, 41.06248], [-124.14083, 41.06253], [-124.14052, 41.06219], [-124.14117, 41.06192], [-124.14071, 41.06151], [-124.14108, 41.06136], [-124.14118, 41.06161], [-124.14194, 41.0615], [-124.14195, 41.0613], [-124.14192, 41.06121], [-124.14212, 41.06118], [-124.14215, 41.06163]]]} Open Access 1 45379 Saunders Park 27897 3203 Trinidad Coastal Land Trust 690 Non Profit 6 Non Profit - Land Trust 10 http://www.trinidadcoastallandtrust.org/ Non Governmental Organization 10 3203 Trinidad Coastal Land Trust 680 Non Profit 6 Non Profit - Land Trust 10 http://www.trinidadcoastallandtrust.org/holdings/index.html Humboldt 45 3.134 Saunders Park 0 Private Recreation or Education 65 4
4344 4344 4343 {"type": "Polygon", "coordinates": [[[-122.27181, 38.09791], [-122.27075, 38.09848], [-122.27064, 38.0983], [-122.27039, 38.09693], [-122.26917, 38.09562], [-122.26946, 38.09542], [-122.26965, 38.09541], [-122.26971, 38.09524], [-122.26973, 38.09524], [-122.2697, 38.0956], [-122.27179, 38.09785], [-122.27181, 38.09791]]]} Open Access 1 45605 Mare Island Historic Park 31265 3379 Mare Island Historic Park Foundation 751 Non Profit 6 Non Profit - Other 22 http://www.mareislandhpf.org/ Non Governmental Organization 10 3379 Mare Island Historic Park Foundation 737 Non Profit 6 Non Profit - Other 20 http://www.mareislandhpf.org/index.html Solano 26 4.996 Mare Island Historic Park 0 Private Recreation or Education 65 4
5006 5006 5005 {"type": "Polygon", "coordinates": [[[-118.62819, 34.09631], [-118.62814, 34.1035], [-118.62683, 34.10349], [-118.62683, 34.10402], [-118.62661, 34.10402], [-118.6266, 34.10349], [-118.6238, 34.10347], [-118.62382, 34.09987], [-118.62381, 34.09806], [-118.61947, 34.09805], [-118.61948, 34.09625], [-118.62381, 34.09625], [-118.62819, 34.09631]]]} Open Access 1 12508 Mountains Restoration Trust Parkland 22563 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 99.528 Mtns. Restoration Trust Parkland 0 Private Recreation or Education 65 4
5266 5266 5265 {"type": "Polygon", "coordinates": [[[-117.35459, 33.20901], [-117.35406, 33.21043], [-117.35407, 33.21045], [-117.35412, 33.21045], [-117.3539, 33.21053], [-117.35388, 33.21048], [-117.35389, 33.21042], [-117.35409, 33.20978], [-117.35417, 33.20964], [-117.35418, 33.20959], [-117.35417, 33.20953], [-117.35411, 33.20946], [-117.35404, 33.20943], [-117.35393, 33.20943], [-117.35337, 33.20918], [-117.35314, 33.20899], [-117.35395, 33.20875], [-117.35416, 33.20875], [-117.35447, 33.20877], [-117.35455, 33.20899], [-117.35459, 33.20901]]]} Open Access 1 949 North County Humane Society and SPCA Dog Park 29112 3361 San Diego Humane Society and SPCA 803 Non Profit 6 Non Profit - Other 22 http://www.sdhumane.org/ Non Governmental Organization 10 3361 San Diego Humane Society and SPCA 783 Non Profit 6 Non Profit - Other 20 http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/dogpark.asp San Diego 4 2.32 North County Humane Society and SPCA Dog Park 0 Private Recreation or Education 65 4
5407 5407 5406 {"type": "Polygon", "coordinates": [[[-118.44355, 34.10751], [-118.443, 34.10752], [-118.44352, 34.10878], [-118.44023, 34.10877], [-118.44022, 34.10977], [-118.43891, 34.10965], [-118.4389, 34.11005], [-118.43864, 34.11005], [-118.43799, 34.10993], [-118.43749, 34.10981], [-118.43745, 34.10968], [-118.43747, 34.10956], [-118.43721, 34.10939], [-118.43722, 34.10936], [-118.43714, 34.10934], [-118.43707, 34.10929], [-118.43709, 34.10922], [-118.43709, 34.10895], [-118.43705, 34.10884], [-118.43772, 34.10905], [-118.43841, 34.10906], [-118.4389, 34.1088], [-118.43891, 34.10871], [-118.44022, 34.10836], [-118.44023, 34.10745], [-118.44353, 34.10745], [-118.44355, 34.10751]]]} Open Access 1 12500 Mountains Restoration Trust Parkland 22563 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 18.111 Mtns. Restoration Trust Parkland 0 Private Recreation or Education 65 4
5701 5701 5700 {"type": "Polygon", "coordinates": [[[-118.46593, 34.21588], [-118.46567, 34.21583], [-118.46558, 34.21553], [-118.46555, 34.21552], [-118.46554, 34.21541], [-118.46585, 34.21547], [-118.46593, 34.21588]]]} Open Access 1 45758 Marson Park 28763 3269 Los Angeles Neighborhood Land Trust 564 Non Profit 6 Non Profit - Land Trust 10 http://www.lanlt.org/ Non Governmental Organization 10 3269 Los Angeles Neighborhood Land Trust 556 Non Profit 6 Non Profit - Land Trust 10 http://www.lanlt.org/parks-and-gardens.php#marson Los Angeles 6 0.288 Marson Park 0 Private Recreation or Education 65 4
5982 5982 5981 {"type": "MultiPolygon", "coordinates": [[[[-120.15031, 38.07513], [-120.15021, 38.0767], [-120.15017, 38.0788], [-120.1503, 38.07975], [-120.15007, 38.08129], [-120.14928, 38.08265], [-120.14892, 38.08205], [-120.14846, 38.08111], [-120.14743, 38.08057], [-120.14611, 38.08037], [-120.14582, 38.08042], [-120.14567, 38.08036], [-120.14566, 38.08026], [-120.14575, 38.0801], [-120.14657, 38.07944], [-120.14735, 38.07842], [-120.14738, 38.0774], [-120.14754, 38.0764], [-120.14785, 38.07644], [-120.14808, 38.07548], [-120.14814, 38.075], [-120.14814, 38.07479], [-120.14821, 38.07416], [-120.14982, 38.07453], [-120.15031, 38.07513]]], [[[-120.15315, 38.08292], [-120.15299, 38.08306], [-120.15302, 38.08341], [-120.15262, 38.08363], [-120.15246, 38.0834], [-120.15153, 38.08386], [-120.1512, 38.08408], [-120.15116, 38.08418], [-120.15116, 38.08431], [-120.15123, 38.08441], [-120.15098, 38.08462], [-120.15073, 38.08492], [-120.15035, 38.08507], [-120.15003, 38.08485], [-120.15022, 38.08462], [-120.14991, 38.08444], [-120.14965, 38.08382], [-120.14963, 38.0837], [-120.14974, 38.08333], [-120.14974, 38.08285], [-120.14939, 38.08282], [-120.14945, 38.08274], [-120.15032, 38.08131], [-120.15055, 38.0798], [-120.15088, 38.08009], [-120.15087, 38.08057], [-120.15094, 38.08099], [-120.15096, 38.08105], [-120.15148, 38.08155], [-120.15173, 38.08183], [-120.15218, 38.08213], [-120.15241, 38.08263], [-120.15255, 38.08268], [-120.15281, 38.08281], [-120.15315, 38.08292]]]]} Open Access 1 575 Odd Fellows High Sierra Park 23069 3050 Odd Fellows Sierra Recreation Association 821 Non Profit 6 Non Profit - Other 22 http://ofsraparkmgt.wix.com/home Non Governmental Organization 10 3050 Odd Fellows Sierra Recreation Association 799 Non Profit 6 Non Profit - Other 20   Tuolumne 21 69.024 Odd Fellows High Sierra Park 0 Private Recreation or Education 65 4

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