units_with_maps

Table actions

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

201 rows where ACCESS_TYP = 1, COUNTY = 16 and DES_TP = 2

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP

ACCESS_TYP 1

  • Open Access · 201 ✖
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
62 62 61 {"type": "Polygon", "coordinates": [[[-122.66503, 38.48047], [-122.66507, 38.48062], [-122.66507, 38.48074], [-122.66505, 38.48087], [-122.66498, 38.48107], [-122.66496, 38.48119], [-122.66497, 38.48269], [-122.66322, 38.483], [-122.66293, 38.48249], [-122.66263, 38.48191], [-122.66259, 38.48191], [-122.66235, 38.48147], [-122.66342, 38.48127], [-122.66343, 38.48126], [-122.66201, 38.47875], [-122.6625, 38.47876], [-122.66282, 38.47874], [-122.66322, 38.4787], [-122.66362, 38.47862], [-122.6647, 38.48058], [-122.66503, 38.48047]]]} Open Access 1 151 Rincon Valley Community Park 24371 1324 Santa Rosa, City of 30 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 1324 Santa Rosa, City of 29 City 2 City Agency 2   Sonoma 16 18.752 Rincon Valley Community Park 0 Local Park 2 4
200 200 199 {"type": "Polygon", "coordinates": [[[-122.73156, 38.45287], [-122.73152, 38.45293], [-122.7309, 38.45305], [-122.73084, 38.45292], [-122.73075, 38.45281], [-122.73039, 38.4517], [-122.73106, 38.45137], [-122.73117, 38.4516], [-122.73156, 38.45287]]]} Open Access 1 47323 Finali Park 31030 1324 Santa Rosa, City of 30 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 1324 Santa Rosa, City of 29 City 2 City Agency 2 https://srcity.org/Facilities/Facility/Details/Finali-Park-66 Sonoma 16 2.768 Finali Park 2016 Local Park 2 4
302 302 301 {"type": "Polygon", "coordinates": [[[-122.73498, 38.41334], [-122.73206, 38.41414], [-122.732, 38.41029], [-122.73412, 38.41036], [-122.73414, 38.41144], [-122.73498, 38.41334]]]} Open Access 1 1039 Southwest Community Park 25702 1324 Santa Rosa, City of 30 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 1324 Santa Rosa, City of 29 City 2 City Agency 2   Sonoma 16 19.939 Southwest Community Park 2000 Local Park 2 4
361 361 360 {"type": "Polygon", "coordinates": [[[-122.63718, 38.23184], [-122.63689, 38.23236], [-122.6359, 38.23199], [-122.63619, 38.23148], [-122.63718, 38.23184]]]} Open Access 1 10069 Walnut Park 27241 1249 Petaluma, City of 148 City 2 City Agency 2 http://cityofpetaluma.net/parksnrec/index.html City 2 1249 Petaluma, City of 144 City 2 City Agency 2   Sonoma 16 1.484 Walnut Park 0 Local Park 2 4
446 446 445 {"type": "Polygon", "coordinates": [[[-122.66242, 38.47114], [-122.66213, 38.47116], [-122.66213, 38.47141], [-122.66207, 38.47141], [-122.66205, 38.47119], [-122.662, 38.47116], [-122.66181, 38.47119], [-122.66165, 38.47124], [-122.66159, 38.47128], [-122.66148, 38.47136], [-122.66139, 38.47148], [-122.66134, 38.47158], [-122.66137, 38.47161], [-122.66165, 38.47167], [-122.66163, 38.47172], [-122.66122, 38.47168], [-122.66121, 38.47167], [-122.66054, 38.47168], [-122.66082, 38.47198], [-122.66076, 38.47205], [-122.6604, 38.47199], [-122.6607, 38.47278], [-122.66079, 38.47294], [-122.66069, 38.47298], [-122.66028, 38.47227], [-122.66019, 38.47203], [-122.66005, 38.47195], [-122.65984, 38.4719], [-122.65972, 38.47189], [-122.65961, 38.47193], [-122.65961, 38.47195], [-122.65973, 38.47217], [-122.65968, 38.47221], [-122.65941, 38.47206], [-122.6593, 38.47218], [-122.6593, 38.47224], [-122.65895, 38.47224], [-122.65893, 38.47227], [-122.65897, 38.47249], [-122.6589, 38.47252], [-122.65871, 38.47234], [-122.65847, 38.47254], [-122.65823, 38.47252], [-122.65819, 38.47273], [-122.65811, 38.47274], [-122.65799, 38.47254], [-122.65781, 38.4726], [-122.65772, 38.47271], [-122.65769, 38.47289], [-122.65823, 38.47383], [-122.65798, 38.47392], [-122.65784, 38.47368], [-122.65768, 38.47373], [-122.65754, 38.47273], [-122.65752, 38.47273], [-122.65748, 38.47249], [-122.65713, 38.47243], [-122.65711, 38.4723], [-122.65747, 38.47227], [-122.65765, 38.47233], [-122.65769, 38.47231], [-122.65833, 38.47224], [-122.65853, 38.47206], [-122.65851, 38.4719], [-122.65872, 38.47188], [-122.6587, 38.47167], [-122.65881, 38.47168], [-122.6589, 38.47164], [-122.65894, 38.47156], [-122.65892, 38.47146], [-122.66106, 38.47127], [-122.66098, 38.47103], [-122.66125, 38.4708], [-122.66134, 38.47078], [-122.66153, 38.47076], [-122.66159, 38.4708], [-122.66159, 38.47083], [-122.66166, 38.47084], [-122.66172, 38.47081], [-122.66174, 38.47076], [-122.66234, 38.47095], [-122.66242, 38.47114]]]} Open Access 1 1405 Tanglewood Park 26180 1324 Santa Rosa, City of 30 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 1324 Santa Rosa, City of 29 City 2 City Agency 2   Sonoma 16 7.775 Tanglewood Park 0 Local Park 2 4
509 509 508 {"type": "Polygon", "coordinates": [[[-123.01254, 38.82071], [-123.01186, 38.82152], [-123.01112, 38.82235], [-123.01076, 38.82218], [-123.0119, 38.82141], [-123.01148, 38.82068], [-123.01202, 38.81948], [-123.01254, 38.82071]]]} Open Access 1 1700 Cloverdale River Park 17444 328 Sonoma County Regional Parks Dept., County of 193 County 3 County Agency - Parks 7 http://parks.sonomacounty.ca.gov/ County 3 328 Sonoma County Regional Parks Dept., County of 189 County 3 County Agency - Parks 7   Sonoma 16 3.11 Cloverdale River Park 0 Local Park 2 4
1104 1104 1103 {"type": "Polygon", "coordinates": [[[-122.69418, 38.3653], [-122.69389, 38.36545], [-122.69385, 38.3655], [-122.69408, 38.36577], [-122.69408, 38.36583], [-122.69319, 38.36637], [-122.69305, 38.36658], [-122.6928, 38.36729], [-122.69185, 38.36717], [-122.69074, 38.36727], [-122.6906, 38.36705], [-122.69092, 38.36689], [-122.69111, 38.36677], [-122.6913, 38.36662], [-122.69146, 38.36645], [-122.69158, 38.36631], [-122.69174, 38.36602], [-122.69184, 38.3657], [-122.69233, 38.36574], [-122.69238, 38.36572], [-122.69351, 38.36483], [-122.69418, 38.3653]]]} Open Access 1 7057 Honeybee Park 20068 1281 Rohnert Park, City of 316 City 2 City Agency 2 http://www.ci.rohnert-park.ca.us/index.aspx?page=74 City 2 1281 Rohnert Park, City of 313 City 2 City Agency 2   Sonoma 16 9.109 Honeybee Park 1962 Local Park 2 4
1197 1197 1196 {"type": "Polygon", "coordinates": [[[-122.81481, 38.55745], [-122.81465, 38.5576], [-122.81458, 38.55768], [-122.81453, 38.55775], [-122.81445, 38.55793], [-122.81443, 38.55808], [-122.81444, 38.55849], [-122.81388, 38.55853], [-122.81385, 38.55851], [-122.81316, 38.55853], [-122.81316, 38.55701], [-122.81349, 38.55699], [-122.81356, 38.55671], [-122.8138, 38.55675], [-122.81406, 38.55685], [-122.8148, 38.55737], [-122.81481, 38.55745]]]} Open Access 1 8248 Michael Hall Park 22197 1382 Windsor, Town of 331 City 2 City Agency 2 http://www.ci.windsor.ca.us/index.aspx?nid=171 City 2 1382 Windsor, Town of 328 City 2 City Agency 2   Sonoma 16 5.308 Michael Hall Park 0 Local Park 2 4
1206 1206 1205 {"type": "Polygon", "coordinates": [[[-122.69481, 38.34006], [-122.6948, 38.3401], [-122.69443, 38.34011], [-122.69437, 38.34025], [-122.69369, 38.33982], [-122.69282, 38.33935], [-122.6926, 38.33958], [-122.6919, 38.33919], [-122.69186, 38.33914], [-122.69191, 38.33898], [-122.69192, 38.3389], [-122.69229, 38.3389], [-122.69228, 38.33872], [-122.69224, 38.33849], [-122.69215, 38.33812], [-122.69255, 38.3382], [-122.69262, 38.33827], [-122.69308, 38.33902], [-122.6931, 38.3391], [-122.6932, 38.33916], [-122.69347, 38.33943], [-122.69359, 38.33934], [-122.69379, 38.33956], [-122.69374, 38.33961], [-122.69373, 38.33968], [-122.69374, 38.33971], [-122.69379, 38.33976], [-122.6939, 38.3398], [-122.69422, 38.34006], [-122.69434, 38.34], [-122.69441, 38.34003], [-122.69481, 38.34006]]]} Open Access 1 8435 Caterpillar Park 16973 1281 Rohnert Park, City of 316 City 2 City Agency 2 http://www.ci.rohnert-park.ca.us/index.aspx?page=74 City 2 1281 Rohnert Park, City of 313 City 2 City Agency 2   Sonoma 16 3.241 Caterpillar Park 1962 Local Park 2 4
1207 1207 1206 {"type": "Polygon", "coordinates": [[[-122.70189, 38.33494], [-122.70176, 38.3354], [-122.70189, 38.33561], [-122.70048, 38.33619], [-122.7005, 38.33624], [-122.69917, 38.33674], [-122.69927, 38.33693], [-122.69936, 38.3369], [-122.69964, 38.33736], [-122.69877, 38.33769], [-122.69843, 38.33712], [-122.69844, 38.33707], [-122.69859, 38.33701], [-122.69875, 38.33689], [-122.69884, 38.3368], [-122.69893, 38.33661], [-122.69894, 38.33646], [-122.69891, 38.33637], [-122.69885, 38.33625], [-122.69866, 38.33595], [-122.70127, 38.33495], [-122.70152, 38.33476], [-122.70176, 38.3349], [-122.70189, 38.33494]]]} Open Access 1 8446 Benicia Park 16012 1281 Rohnert Park, City of 316 City 2 City Agency 2 http://www.ci.rohnert-park.ca.us/index.aspx?page=74 City 2 1281 Rohnert Park, City of 313 City 2 City Agency 2   Sonoma 16 8.436 Benicia Park 1962 Local Park 2 4
1225 1225 1224 {"type": "Polygon", "coordinates": [[[-122.60828, 38.227], [-122.60689, 38.2283], [-122.60534, 38.22861], [-122.60511, 38.22845], [-122.60348, 38.22942], [-122.60099, 38.2291], [-122.59955, 38.22805], [-122.59813, 38.22962], [-122.59712, 38.22934], [-122.59572, 38.22889], [-122.58667, 38.22545], [-122.58472, 38.22752], [-122.58065, 38.22602], [-122.58089, 38.22576], [-122.58083, 38.22535], [-122.57915, 38.22443], [-122.57979, 38.22381], [-122.58026, 38.22347], [-122.58051, 38.22326], [-122.58068, 38.22298], [-122.58181, 38.2234], [-122.58545, 38.21911], [-122.58592, 38.21923], [-122.58644, 38.21924], [-122.58741, 38.2193], [-122.58767, 38.21927], [-122.58832, 38.21912], [-122.58881, 38.21891], [-122.58985, 38.21833], [-122.59071, 38.218], [-122.5915, 38.21787], [-122.59165, 38.21787], [-122.59273, 38.21894], [-122.59312, 38.21949], [-122.59357, 38.22006], [-122.59404, 38.22053], [-122.59456, 38.22086], [-122.59507, 38.22105], [-122.59564, 38.22119], [-122.5964, 38.22125], [-122.59841, 38.22082], [-122.59919, 38.22081], [-122.60016, 38.22118], [-122.60112, 38.22129], [-122.60174, 38.22118], [-122.60284, 38.22117], [-122.60389, 38.22166], [-122.60493, 38.22272], [-122.60556, 38.22413], [-122.60673, 38.22506], [-122.60825, 38.22572], [-122.6084, 38.22616], [-122.60841, 38.22662], [-122.60828, 38.227]]]} Open Access 1 7020 Shollenberger Park 8553 1249 Petaluma, City of 148 City 2 City Agency 2 http://cityofpetaluma.net/parksnrec/index.html City 2 1249 Petaluma, City of 144 City 2 City Agency 2 http://cityofpetaluma.net/parksnrec/parks-pages/shollenberger.html Sonoma 16 455.472 Shollenberger Park 0 Local Park 2 4
1283 1283 1282 {"type": "Polygon", "coordinates": [[[-122.63231, 38.24197], [-122.63157, 38.24277], [-122.63066, 38.24226], [-122.63059, 38.24198], [-122.63119, 38.24133], [-122.63231, 38.24197]]]} Open Access 1 9981 Kenilworth Park 20597 1249 Petaluma, City of 148 City 2 City Agency 2 http://cityofpetaluma.net/parksnrec/index.html City 2 1249 Petaluma, City of 144 City 2 City Agency 2   Sonoma 16 3.259 Kenilworth Park 0 Local Park 2 4
1302 1302 1301 {"type": "Polygon", "coordinates": [[[-122.7616, 38.42519], [-122.7609, 38.42525], [-122.76082, 38.42464], [-122.76085, 38.4246], [-122.76086, 38.42454], [-122.76083, 38.42446], [-122.7608, 38.42413], [-122.76146, 38.42409], [-122.7616, 38.42519]]]} Open Access 1 10458 Village Green Park 27116 1324 Santa Rosa, City of 30 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 1324 Santa Rosa, City of 29 City 2 City Agency 2   Sonoma 16 1.837 Village Green Park 0 Local Park 2 4
1325 1325 1324 {"type": "Polygon", "coordinates": [[[-122.70256, 38.47544], [-122.70255, 38.47547], [-122.70224, 38.47541], [-122.70162, 38.47624], [-122.70157, 38.47671], [-122.7013, 38.47657], [-122.70121, 38.4765], [-122.70093, 38.47617], [-122.70076, 38.47599], [-122.70056, 38.47583], [-122.69975, 38.47539], [-122.6998, 38.47531], [-122.69915, 38.47498], [-122.69895, 38.47484], [-122.69885, 38.47467], [-122.70244, 38.47464], [-122.7023, 38.47517], [-122.70221, 38.47536], [-122.70256, 38.47544]]]} Open Access 1 10821 Hidden Valley Park 19920 1324 Santa Rosa, City of 30 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 1324 Santa Rosa, City of 29 City 2 City Agency 2   Sonoma 16 8.794 Hidden Valley Park 0 Local Park 2 4
1327 1327 1326 {"type": "Polygon", "coordinates": [[[-122.69381, 38.48999], [-122.69379, 38.49004], [-122.69375, 38.49006], [-122.69344, 38.49011], [-122.69317, 38.49012], [-122.69239, 38.49008], [-122.69236, 38.49005], [-122.69238, 38.4897], [-122.69237, 38.48951], [-122.69231, 38.48938], [-122.69218, 38.48923], [-122.69204, 38.48914], [-122.69189, 38.48908], [-122.69146, 38.489], [-122.69126, 38.48894], [-122.69096, 38.48877], [-122.69078, 38.48865], [-122.69125, 38.48827], [-122.69152, 38.48843], [-122.69216, 38.48858], [-122.69245, 38.48857], [-122.69273, 38.48852], [-122.69314, 38.48835], [-122.69317, 38.48825], [-122.69296, 38.48806], [-122.69306, 38.48799], [-122.69316, 38.48795], [-122.69332, 38.48792], [-122.69337, 38.48793], [-122.6934, 38.48797], [-122.69343, 38.48816], [-122.6935, 38.48892], [-122.69361, 38.48938], [-122.69369, 38.48967], [-122.69381, 38.48999]]]} Open Access 1 10830 Rincon Ridge Park 24370 1324 Santa Rosa, City of 30 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 1324 Santa Rosa, City of 29 City 2 City Agency 2   Sonoma 16 7.263 Rincon Ridge Park 0 Local Park 2 4
1376 1376 1375 {"type": "Polygon", "coordinates": [[[-122.80515, 38.53149], [-122.80495, 38.53148], [-122.80486, 38.53145], [-122.80479, 38.5314], [-122.80435, 38.53092], [-122.80437, 38.53082], [-122.80476, 38.53061], [-122.80485, 38.53063], [-122.80513, 38.53096], [-122.80514, 38.53102], [-122.80515, 38.53149]]]} Open Access 1 8364 Mitchell Park 22326 1382 Windsor, Town of 331 City 2 City Agency 2 http://www.ci.windsor.ca.us/index.aspx?nid=171 City 2 1382 Windsor, Town of 328 City 2 City Agency 2   Sonoma 16 1.061 Mitchell Park 0 Local Park 2 4
1377 1377 1376 {"type": "Polygon", "coordinates": [[[-122.68811, 38.34604], [-122.6881, 38.34708], [-122.68795, 38.34709], [-122.68794, 38.34737], [-122.68766, 38.34739], [-122.68746, 38.34744], [-122.68726, 38.34753], [-122.68714, 38.34759], [-122.6865, 38.34808], [-122.68621, 38.34821], [-122.68598, 38.34827], [-122.68572, 38.34827], [-122.68566, 38.34823], [-122.68565, 38.3482], [-122.68565, 38.34599], [-122.68568, 38.34595], [-122.68572, 38.34593], [-122.68686, 38.34592], [-122.68775, 38.34599], [-122.68811, 38.34604]]]} Open Access 1 8394 Sunrise Park 26026 1281 Rohnert Park, City of 316 City 2 City Agency 2 http://www.ci.rohnert-park.ca.us/index.aspx?page=74 City 2 1281 Rohnert Park, City of 313 City 2 City Agency 2   Sonoma 16 10.821 Sunrise Park 1962 Local Park 2 4
1379 1379 1378 {"type": "Polygon", "coordinates": [[[-122.69158, 38.34574], [-122.69136, 38.34566], [-122.69118, 38.34562], [-122.69114, 38.34559], [-122.69112, 38.34555], [-122.69118, 38.34527], [-122.69157, 38.34527], [-122.69161, 38.34561], [-122.69161, 38.34569], [-122.69158, 38.34574]]]} Open Access 1 8405 San Simeon Park 24993 1281 Rohnert Park, City of 316 City 2 City Agency 2 http://www.ci.rohnert-park.ca.us/index.aspx?page=74 City 2 1281 Rohnert Park, City of 313 City 2 City Agency 2   Sonoma 16 0.422 San Simeon Park 1962 Local Park 2 4
1381 1381 1380 {"type": "Polygon", "coordinates": [[[-122.69368, 38.34124], [-122.69329, 38.3419], [-122.69329, 38.3423], [-122.69148, 38.34232], [-122.69146, 38.34161], [-122.69155, 38.34158], [-122.6916, 38.34155], [-122.6924, 38.34064], [-122.69295, 38.34094], [-122.69322, 38.34106], [-122.69368, 38.34124]]]} Open Access 1 8416 Colegio Vista Park 17489 1281 Rohnert Park, City of 316 City 2 City Agency 2 http://www.ci.rohnert-park.ca.us/index.aspx?page=74 City 2 1281 Rohnert Park, City of 313 City 2 City Agency 2   Sonoma 16 5.985 Colegio Vista Park 1962 Local Park 2 4
1382 1382 1381 {"type": "Polygon", "coordinates": [[[-122.70788, 38.34198], [-122.70682, 38.34199], [-122.70676, 38.34111], [-122.70675, 38.34001], [-122.70784, 38.34001], [-122.70788, 38.34198]]]} Open Access 1 8424 Alicia Park 15365 1281 Rohnert Park, City of 316 City 2 City Agency 2 http://www.ci.rohnert-park.ca.us/index.aspx?page=74 City 2 1281 Rohnert Park, City of 313 City 2 City Agency 2   Sonoma 16 5.133 Alicia Park 1962 Local Park 2 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]);