units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9,376 rows where DES_TP = 2
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, City of 229
- San Diego, City of 211
- Sacramento, City of 181
- San Jose, City of 133
- Consumnes Community Services District 92
- Long Beach, City of 83
- Oakland, City of 82
- San Francisco, City and County of 78
- East Bay Regional Park District 75
- Los Angeles, County of 70
- Roseville, City of 65
- Tracy, City of 61
- Hayward Area Recreation and Park District 59
- Mountains Recreation and Conservation Authority 56
- Valley-Wide Recreation and Park District 56
- Modesto, City of 56
- San Diego, County of 52
- Huntington Beach, City of 52
- Fresno, City of 50
- Brentwood, City of 49
- Chula Vista, City of 47
- Stockton, City of 47
- Napa, City of 45
- Manteca, City of 45
- Santa Rosa, City of 42
- San Ramon, City of 42
- Bakersfield, City of 41
- El Dorado, County of 41
- Murrieta, City of 40
- Folsom, City of 40
- …
MNG_AG_TYP 15
- City Agency 5,733
- Recreation/Parks District 610
- County Agency 500
- Community Services District 165
- County Agency - Parks 135
- Open Space District 61
- Water District 36
- School District 31
- Port/Harbor District 20
- Flood District 15
- Special District - Other 9
- County Agency - Other 5
- Cemetery District 1
- Irrigation District 1
- Joint Powers Authority 1
ACCESS_TYP 4
- Open Access 7,048
- Restricted Access 200
- No Public Access 70
- Unknown Access 5
DES_TP 1
- Local Park · 7,323 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2848 | 2848 | 2847 | {"type": "MultiPolygon", "coordinates": [[[[-120.97023, 37.62482], [-120.97022, 37.62563], [-120.96975, 37.62563], [-120.96974, 37.62527], [-120.96906, 37.62527], [-120.96906, 37.62492], [-120.96944, 37.62487], [-120.96964, 37.62479], [-120.9698, 37.62476], [-120.96997, 37.62477], [-120.97023, 37.62482]]], [[[-120.97081, 37.62564], [-120.97036, 37.62563], [-120.97037, 37.62486], [-120.97081, 37.62495], [-120.97081, 37.62564]]]]} | Open Access 1 | 18777 | Orville Wright Park / George Rogers Park | 23230 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 2.467 | Orville Wright Park / George Rogers Park | 0 | Local Park 2 | 4 | |
2849 | 2849 | 2848 | {"type": "Polygon", "coordinates": [[[-120.98416, 37.60551], [-120.98131, 37.60551], [-120.98113, 37.60552], [-120.98079, 37.60558], [-120.9807, 37.60561], [-120.98048, 37.60564], [-120.98042, 37.6051], [-120.98416, 37.60508], [-120.98416, 37.60551]]]} | Open Access 1 | 18780 | Parklawn Park | 23444 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 3.907 | Parklawn Park | 0 | Local Park 2 | 4 | |
2850 | 2850 | 2849 | {"type": "Polygon", "coordinates": [[[-117.13628, 33.53783], [-117.1363, 33.53802], [-117.13629, 33.53814], [-117.13615, 33.53855], [-117.13606, 33.53872], [-117.13577, 33.53862], [-117.13556, 33.53846], [-117.13547, 33.53844], [-117.13542, 33.53845], [-117.13535, 33.53849], [-117.13532, 33.53853], [-117.13532, 33.53858], [-117.13521, 33.53864], [-117.13517, 33.53863], [-117.1351, 33.53885], [-117.13473, 33.53879], [-117.13436, 33.53867], [-117.13439, 33.5383], [-117.13445, 33.53824], [-117.13628, 33.53783]]]} | Open Access 1 | 22139 | Nicholas Road Park | 22746 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 2.913 | Nicholas Road Park | 0 | Local Park 2 | 4 | |
2851 | 2851 | 2850 | {"type": "Polygon", "coordinates": [[[-117.13417, 33.5384], [-117.13414, 33.53866], [-117.13392, 33.5387], [-117.13353, 33.53869], [-117.13336, 33.53866], [-117.1325, 33.5387], [-117.13407, 33.53834], [-117.13417, 33.5384]]]} | Open Access 1 | 22140 | Voorburg Park | 27197 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 0.728 | Voorburg Park | 0 | Local Park 2 | 4 | |
2852 | 2852 | 2851 | {"type": "Polygon", "coordinates": [[[-121.00528, 37.66562], [-121.00415, 37.6656], [-121.00414, 37.66569], [-121.00317, 37.66566], [-121.00316, 37.66396], [-121.00527, 37.66401], [-121.00528, 37.66562]]]} | Open Access 1 | 18802 | Roosevelt Park | 24598 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 8.445 | Roosevelt Park | 0 | Local Park 2 | 4 | |
2857 | 2857 | 2856 | {"type": "Polygon", "coordinates": [[[-121.03778, 37.64938], [-121.03551, 37.6494], [-121.03549, 37.64852], [-121.0366, 37.64803], [-121.03752, 37.64807], [-121.03777, 37.64817], [-121.03778, 37.64938]]]} | Open Access 1 | 18813 | Charles M. Sharp Park | 17140 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 6.766 | Charles M. Sharp Park | 0 | Local Park 2 | 4 | |
2859 | 2859 | 2858 | {"type": "Polygon", "coordinates": [[[-121.24939, 36.3241], [-121.24918, 36.32421], [-121.24905, 36.32407], [-121.24905, 36.32404], [-121.24907, 36.324], [-121.24924, 36.32392], [-121.24939, 36.3241]]]} | Open Access 1 | 18833 | Primavera Park | 24000 | 1124 | Greenfield, City of 176 | City 2 | City Agency 2 | http://www.ci.greenfield.ca.us/index.aspx?page=179 | City 2 | 1124 | Greenfield, City of 172 | City 2 | City Agency 2 | Monterey 14 | 0.14 | Primavera Park | 0 | Local Park 2 | 4 | |
2860 | 2860 | 2859 | {"type": "Polygon", "coordinates": [[[-120.95248, 37.66346], [-120.95127, 37.66345], [-120.95126, 37.66173], [-120.95238, 37.66173], [-120.95238, 37.66214], [-120.95227, 37.66225], [-120.95224, 37.66231], [-120.95226, 37.66237], [-120.9523, 37.66242], [-120.95237, 37.66245], [-120.95245, 37.66245], [-120.95249, 37.66287], [-120.95248, 37.66346]]]} | Open Access 1 | 18834 | Sonoma Park | 25616 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 4.823 | Sonoma Park | 0 | Local Park 2 | 4 | |
2861 | 2861 | 2860 | {"type": "Polygon", "coordinates": [[[-117.13342, 33.14761], [-117.13288, 33.14884], [-117.13241, 33.14999], [-117.13211, 33.15068], [-117.12988, 33.15061], [-117.1299, 33.15021], [-117.13084, 33.15023], [-117.13094, 33.14816], [-117.13177, 33.14817], [-117.13179, 33.14755], [-117.13342, 33.14761]]]} | Open Access 1 | 1834 | Woodland Park | 27724 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.san-marcos.net/Home/Components/FacilityDirectory/FacilityDirectory/167/1081?npage=2 | San Diego 4 | 14.507 | Woodland Park | 0 | Local Park 2 | 4 |
2862 | 2862 | 2861 | {"type": "MultiPolygon", "coordinates": [[[[-117.22617, 33.20984], [-117.22447, 33.21056], [-117.22419, 33.21105], [-117.22304, 33.21187], [-117.22327, 33.21226], [-117.22299, 33.21329], [-117.22306, 33.21334], [-117.22292, 33.21354], [-117.22278, 33.2137], [-117.22273, 33.21374], [-117.22251, 33.21382], [-117.22239, 33.2139], [-117.22185, 33.21442], [-117.22178, 33.21452], [-117.22141, 33.21444], [-117.21999, 33.2146], [-117.21886, 33.21438], [-117.21913, 33.21433], [-117.2193, 33.21442], [-117.21977, 33.21441], [-117.22009, 33.2145], [-117.22026, 33.21443], [-117.2212, 33.21425], [-117.22155, 33.21408], [-117.2217, 33.21404], [-117.2218, 33.21408], [-117.22196, 33.21402], [-117.22216, 33.2139], [-117.22254, 33.21363], [-117.22259, 33.21355], [-117.22278, 33.21334], [-117.22289, 33.21309], [-117.22296, 33.21283], [-117.22296, 33.21266], [-117.22307, 33.21244], [-117.22288, 33.21211], [-117.22157, 33.21212], [-117.22081, 33.2121], [-117.21744, 33.21208], [-117.21744, 33.2114], [-117.21746, 33.21139], [-117.21746, 33.20968], [-117.21822, 33.20818], [-117.21705, 33.20793], [-117.21728, 33.20743], [-117.21733, 33.20744], [-117.21749, 33.20676], [-117.21822, 33.20691], [-117.21879, 33.20596], [-117.21894, 33.20604], [-117.2199, 33.20671], [-117.22312, 33.20886], [-117.22346, 33.2089], [-117.22389, 33.20897], [-117.22505, 33.20907], [-117.22616, 33.20902], [-117.22617, 33.20984]]], [[[-117.21836, 33.21428], [-117.21754, 33.21413], [-117.21746, 33.21397], [-117.21746, 33.21377], [-117.21811, 33.21403], [-117.21836, 33.2141], [-117.21837, 33.21413], [-117.21836, 33.21428]]]]} | Open Access 1 | 1844 | Brengle Terrace Park | 16350 | 1369 | Vista, City of 159 | City 2 | City Agency 2 | http://www.cityofvista.com/departments/parks/parks_and_facilities.cfm | City 2 | 1369 | Vista, City of 155 | City 2 | City Agency 2 | http://www.cityofvista.com/services/parks-and-facilities | San Diego 4 | 85.637 | Brengle Terrace Park | 0 | Local Park 2 | 4 |
2865 | 2865 | 2864 | {"type": "Polygon", "coordinates": [[[-117.96216, 33.65367], [-117.96217, 33.65436], [-117.96215, 33.6544], [-117.9621, 33.65444], [-117.96168, 33.65444], [-117.96167, 33.65417], [-117.95797, 33.65419], [-117.95797, 33.65472], [-117.95756, 33.65473], [-117.95755, 33.65454], [-117.95718, 33.65454], [-117.95717, 33.65419], [-117.95382, 33.65421], [-117.95382, 33.65372], [-117.96216, 33.65367]]]} | Open Access 1 | 996 | Gisler Park | 19304 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/gisler-park.cfm | Orange 3 | 11.741 | Gisler Park | 0 | Local Park 2 | 4 |
2866 | 2866 | 2865 | {"type": "MultiPolygon", "coordinates": [[[[-117.07543, 32.54723], [-117.07334, 32.54725], [-117.07265, 32.54719], [-117.07205, 32.54707], [-117.07148, 32.54689], [-117.0711, 32.54673], [-117.07109, 32.54619], [-117.0715, 32.54637], [-117.07191, 32.54654], [-117.07243, 32.54667], [-117.07273, 32.54673], [-117.07335, 32.54678], [-117.07543, 32.54677], [-117.07543, 32.54723]]], [[[-117.07531, 32.56113], [-117.07484, 32.56105], [-117.07453, 32.56098], [-117.07423, 32.56089], [-117.07377, 32.56072], [-117.07348, 32.56061], [-117.0732, 32.56047], [-117.07246, 32.56004], [-117.07531, 32.56004], [-117.07531, 32.56113]]], [[[-117.08397, 32.55455], [-117.08325, 32.55455], [-117.08325, 32.55408], [-117.08397, 32.55408], [-117.08398, 32.55438], [-117.08397, 32.55455]]], [[[-117.08438, 32.55435], [-117.08437, 32.55447], [-117.08419, 32.55448], [-117.08419, 32.55436], [-117.08438, 32.55435]]], [[[-117.08848, 32.54379], [-117.08838, 32.54365], [-117.08828, 32.54358], [-117.08847, 32.54358], [-117.08848, 32.54379]]]]} | Open Access 1 | 997 | Tijuana River Valley Regional Park | 26363 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sdparks.org/content/sdparks/en/park-pages/TJRVRP.html | San Diego 4 | 11.187 | Tijuana River Valley RP | 0 | Local Park 2 | 4 |
2867 | 2867 | 2866 | {"type": "Polygon", "coordinates": [[[-117.53403, 33.81452], [-117.53381, 33.8147], [-117.53285, 33.81636], [-117.53282, 33.81686], [-117.53209, 33.81689], [-117.53207, 33.81691], [-117.53166, 33.81689], [-117.53138, 33.81684], [-117.5312, 33.81679], [-117.53061, 33.81651], [-117.53073, 33.81636], [-117.53088, 33.81612], [-117.53106, 33.81571], [-117.53112, 33.81549], [-117.53118, 33.81518], [-117.5312, 33.81496], [-117.5312, 33.81465], [-117.53124, 33.81462], [-117.53374, 33.81438], [-117.53375, 33.81446], [-117.53381, 33.81452], [-117.53403, 33.81452]]]} | Open Access 1 | 18848 | Eagle Glen Community Park | 18338 | 1068 | Corona, City of 65 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | Riverside 10 | 13.491 | Eagle Glen Community Park | 0 | Local Park 2 | 4 | |
2868 | 2868 | 2867 | {"type": "Polygon", "coordinates": [[[-122.06456, 37.08051], [-122.06575, 37.08186], [-122.06516, 37.08188], [-122.06511, 37.08397], [-122.06795, 37.08404], [-122.06788, 37.08414], [-122.06787, 37.08425], [-122.06814, 37.08465], [-122.06759, 37.08465], [-122.06753, 37.08556], [-122.06777, 37.08559], [-122.0675, 37.09096], [-122.0622, 37.09094], [-122.05739, 37.09066], [-122.05741, 37.08554], [-122.06002, 37.08555], [-122.06005, 37.07987], [-122.0576, 37.07982], [-122.05766, 37.07656], [-122.05927, 37.07841], [-122.06113, 37.07958], [-122.06188, 37.07978], [-122.06215, 37.07992], [-122.06335, 37.0792], [-122.06456, 37.08051]]]} | Open Access 1 | 18850 | Quail Hollow Ranch Park | 12092 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/quail_hollow.html | Santa Cruz 5 | 227.323 | Quail Hollow Ranch Park | 0 | Local Park 2 | 4 |
2869 | 2869 | 2868 | {"type": "Polygon", "coordinates": [[[-120.92088, 37.64184], [-120.92083, 37.64294], [-120.92085, 37.6445], [-120.9177, 37.64453], [-120.9177, 37.64508], [-120.91664, 37.64509], [-120.91657, 37.64213], [-120.91894, 37.64212], [-120.91895, 37.64185], [-120.92088, 37.64184]]]} | Open Access 1 | 18851 | Sutton Community Park | 26088 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 27.309 | Sutton Community Park | 0 | Local Park 2 | 4 | |
2872 | 2872 | 2871 | {"type": "Polygon", "coordinates": [[[-119.67658, 36.6335], [-119.67576, 36.6341], [-119.67502, 36.63341], [-119.67585, 36.63282], [-119.67658, 36.6335]]]} | Open Access 1 | 18866 | Edwin Blayney Senior Center and Park | 18460 | 1112 | Fowler, City of 560 | City 2 | City Agency 2 | http://www.fowlercity.org/ | City 2 | 1112 | Fowler, City of 553 | City 2 | City Agency 2 | Fresno 9 | 2.442 | Edwin Blayney Senior Ctr. and Park | 0 | Local Park 2 | 4 | |
2873 | 2873 | 2872 | {"type": "Polygon", "coordinates": [[[-122.41342, 37.74714], [-122.41342, 37.74714], [-122.41055, 37.74731], [-122.41073, 37.74697], [-122.41339, 37.74681], [-122.41342, 37.74714]]]} | Open Access 1 | 18872 | Precita Park | 23979 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 2.209 | Precita Park | 0 | Local Park 2 | 4 | |
2874 | 2874 | 2873 | {"type": "Polygon", "coordinates": [[[-117.14485, 32.76313], [-117.14397, 32.76313], [-117.14396, 32.76342], [-117.14397, 32.76345], [-117.14372, 32.76346], [-117.14373, 32.76523], [-117.14395, 32.76524], [-117.14396, 32.76581], [-117.14304, 32.76603], [-117.14301, 32.7631], [-117.1426, 32.76309], [-117.14264, 32.76296], [-117.1427, 32.76295], [-117.14269, 32.76278], [-117.14298, 32.76265], [-117.14321, 32.76259], [-117.14485, 32.76258], [-117.14485, 32.76313]]]} | Open Access 1 | 18879 | Old Trolley Barn Neighborhood Park | 30171 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 8.531 | Old Trolley Barn Neighborhood Park | 0 | Local Park 2 | 4 | |
2875 | 2875 | 2874 | {"type": "Polygon", "coordinates": [[[-121.00813, 37.69463], [-121.00552, 37.69539], [-121.00549, 37.69342], [-121.00718, 37.69344], [-121.00755, 37.69341], [-121.00758, 37.69344], [-121.00813, 37.69463]]]} | Open Access 1 | 18882 | Wesson Ranch Park | 27350 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 9.238 | Wesson Ranch Park | 0 | Local Park 2 | 4 | |
2878 | 2878 | 2877 | {"type": "Polygon", "coordinates": [[[-118.31233, 34.03401], [-118.31231, 34.03394], [-118.31235, 34.03388], [-118.31242, 34.03384], [-118.31252, 34.03386], [-118.31252, 34.03389], [-118.31239, 34.03402], [-118.31236, 34.03402], [-118.31233, 34.03401]]]} | Open Access 1 | 18875 | Gramercy Park | 29322 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.056 | Gramercy Park | 0 | Local Park 2 | 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]);