units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
194 rows where ACCESS_TYP = 2 and DES_TP = 65 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP, LAYER, MNG_AG_LEV, COUNTY
MNG_AGENCY >30
- Woodbridge Village Association 30
- Home Owners Association - Unknown Name 25
- Rancho Santa Margarita Landscape and Recreation Corporation 17
- Amerige Heights Community Association 7
- Paseo Westpark Maintenance Association 4
- Deerfield Community Association 4
- Nellie Gail Ranch Owners Association 4
- Westpark Maintenance District 4
- Sierra Bonita Community Association 4
- Town Center Association 4
- Northpark Square Maintenance Association 3
- Turtle Rock Broadmoor Community Association 3
- Oak Creek Village Maintenance Association 2
- Quail Hill Community Association 2
- Mountains Restoration Trust 2
- Truckee Donner Land Trust 2
- Broadmoor Campus View Community Association 2
- Woodbridge Owners Association 2
- Northpark Maintenance Association 2
- Windwood Homeowners Association 2
- Johnson Ranch Community Association 2
- Woodbury Community Association 2
- Petco Park Owner 1
- Arroyos and Foothills Conservancy 1
- Harvard Square Maintenance Association 1
- Liberty Park Homeowners Association 1
- Friends of the Dunes 1
- Turtle Rock Ridge Association 1
- Parkside Community Association 1
- Wagon Wheel Canyon Community Association 1
- …
MNG_AG_TYP 7
DES_TP 1
- Private Recreation or Education · 194 ✖
ACCESS_TYP 1
- Restricted Access · 194 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16969 | 16969 | 16968 | {"type": "Polygon", "coordinates": [[[-118.6238, 34.10536], [-118.62339, 34.10535], [-118.62338, 34.10426], [-118.62367, 34.10438], [-118.6238, 34.10442], [-118.6238, 34.10536]]]} | Restricted Access 2 | 12501 | Mountains Restoration Trust Parkland | 29662 | 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 | 1.053 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
16418 | 16418 | 16417 | {"type": "Polygon", "coordinates": [[[-117.59014, 33.62644], [-117.58955, 33.6267], [-117.58932, 33.62718], [-117.58911, 33.62751], [-117.58878, 33.62766], [-117.58851, 33.62759], [-117.58811, 33.62759], [-117.58789, 33.62764], [-117.58737, 33.62751], [-117.58704, 33.62726], [-117.58642, 33.62719], [-117.58659, 33.62671], [-117.58671, 33.62632], [-117.58679, 33.62628], [-117.58696, 33.62629], [-117.58718, 33.62627], [-117.58752, 33.62631], [-117.58764, 33.6263], [-117.58776, 33.62627], [-117.58791, 33.62618], [-117.58819, 33.62594], [-117.58822, 33.62594], [-117.58832, 33.62578], [-117.58836, 33.62565], [-117.58835, 33.62548], [-117.58828, 33.62533], [-117.58847, 33.62533], [-117.58856, 33.62488], [-117.58954, 33.6252], [-117.5897, 33.62528], [-117.5898, 33.62571], [-117.59003, 33.62582], [-117.59015, 33.62615], [-117.59014, 33.62644]]]} | Restricted Access 2 | 36104 | Coto Sports And Recreation Park | 32378 | 6037 | CZ Master Association 1172 | Private 7 | Home Owners Association 16 | http://www.czmaster.org/ | Private 14 | 6037 | CZ Master Association 1110 | Private 7 | Home Owners Association 15 | Orange 3 | 14.251 | Coto Sports And Rec. Park | 0 | Private Recreation or Education 65 | 4 | |
16192 | 16192 | 16191 | {"type": "MultiPolygon", "coordinates": [[[[-121.24954, 38.73854], [-121.24936, 38.73872], [-121.24931, 38.73881], [-121.24927, 38.73893], [-121.24799, 38.73868], [-121.24772, 38.73942], [-121.24706, 38.73873], [-121.24742, 38.73848], [-121.24758, 38.73833], [-121.24774, 38.73816], [-121.24816, 38.73826], [-121.2492, 38.7383], [-121.24954, 38.73854]]], [[[-121.25006, 38.73908], [-121.2499, 38.73932], [-121.24943, 38.73905], [-121.24945, 38.73893], [-121.24949, 38.73883], [-121.24955, 38.73875], [-121.24963, 38.73866], [-121.24999, 38.73892], [-121.25006, 38.73908]]]]} | Restricted Access 2 | 29490 | HOA Open Space | 31747 | 6065 | Winchester Owners Association 1165 | Private 7 | Home Owners Association 16 | Private 14 | 6065 | Winchester Owners Association 1107 | Private 7 | Home Owners Association 15 | Placer 35 | 3.833 | HOA OS | 0 | Private Recreation or Education 65 | 4 | ||
15725 | 15725 | 15724 | {"type": "MultiPolygon", "coordinates": [[[[-120.16777, 39.32371], [-120.16732, 39.32424], [-120.16563, 39.32376], [-120.16561, 39.32386], [-120.16581, 39.3241], [-120.16572, 39.32418], [-120.1656, 39.32411], [-120.16508, 39.32443], [-120.16493, 39.32458], [-120.16286, 39.32477], [-120.16153, 39.32476], [-120.16136, 39.32504], [-120.16135, 39.32548], [-120.16125, 39.32555], [-120.16113, 39.32561], [-120.161, 39.32564], [-120.16081, 39.32566], [-120.16081, 39.32247], [-120.16499, 39.32236], [-120.16777, 39.32371]]], [[[-120.17072, 39.32608], [-120.17051, 39.32637], [-120.17011, 39.32617], [-120.1701, 39.32604], [-120.16081, 39.32611], [-120.16081, 39.32583], [-120.1611, 39.3258], [-120.16131, 39.32572], [-120.16138, 39.32581], [-120.16245, 39.32571], [-120.16317, 39.32559], [-120.1645, 39.32524], [-120.16475, 39.32561], [-120.16713, 39.325], [-120.16742, 39.32482], [-120.16718, 39.32458], [-120.16732, 39.32449], [-120.16745, 39.32437], [-120.16794, 39.32379], [-120.17013, 39.32486], [-120.17072, 39.32608]]]]} | Restricted Access 2 | 44739 | Ponderosa Golf Course | 33109 | 3104 | Truckee Donner Land Trust 673 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.tdlandtrust.org/ | Non Governmental Organization 10 | 3104 | Truckee Donner Land Trust 663 | Non Profit 6 | Non Profit - Land Trust 10 | Nevada 30 | 52.893 | Ponderosa GC | 0 | Private Recreation or Education 65 | 4 | |
15724 | 15724 | 15723 | {"type": "Polygon", "coordinates": [[[-120.15979, 39.35605], [-120.15917, 39.35687], [-120.15867, 39.35761], [-120.15837, 39.35812], [-120.15809, 39.35864], [-120.15766, 39.35956], [-120.15084, 39.35953], [-120.14169, 39.35945], [-120.1417, 39.35904], [-120.14249, 39.35866], [-120.1432, 39.35835], [-120.14388, 39.35799], [-120.14467, 39.3575], [-120.14541, 39.35696], [-120.14578, 39.35665], [-120.1489, 39.35367], [-120.15846, 39.34589], [-120.15693, 39.3498], [-120.15755, 39.3498], [-120.15794, 39.34996], [-120.15825, 39.35026], [-120.15839, 39.35056], [-120.15794, 39.3547], [-120.15803, 39.35493], [-120.15833, 39.3553], [-120.15979, 39.35605]]]} | Restricted Access 2 | 44736 | Old Greenwood Golf Course | 33108 | 3104 | Truckee Donner Land Trust 673 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.tdlandtrust.org/ | Non Governmental Organization 10 | 3104 | Truckee Donner Land Trust 663 | Non Profit 6 | Non Profit - Land Trust 10 | Nevada 30 | 258.402 | Old Greenwood GC | 0 | Private Recreation or Education 65 | 4 | |
15427 | 15427 | 15426 | {"type": "Polygon", "coordinates": [[[-116.96631, 32.65277], [-116.96564, 32.6533], [-116.96602, 32.65375], [-116.96606, 32.65404], [-116.96482, 32.65413], [-116.96359, 32.65388], [-116.96354, 32.65344], [-116.96469, 32.65281], [-116.96408, 32.6518], [-116.9643, 32.65168], [-116.96476, 32.65241], [-116.96542, 32.65319], [-116.96614, 32.65261], [-116.96631, 32.65277]]]} | Restricted Access 2 | 46691 | Scobee Park | 30036 | 6103 | Private Landowner 584 | Private 7 | Other 25 | Private 14 | 6103 | Private Landowner 774 | Private 7 | Other 26 | San Diego 4 | 7.196 | Scobee Park | 0 | Private Recreation or Education 65 | 4 | ||
14798 | 14798 | 14797 | {"type": "Polygon", "coordinates": [[[-117.82281, 33.64763], [-117.82244, 33.64779], [-117.82239, 33.64787], [-117.82226, 33.6479], [-117.82208, 33.64809], [-117.82193, 33.64822], [-117.82179, 33.64802], [-117.82131, 33.64815], [-117.82077, 33.64819], [-117.82075, 33.6484], [-117.82014, 33.64812], [-117.81988, 33.64803], [-117.81985, 33.64799], [-117.81986, 33.64794], [-117.82032, 33.64809], [-117.82039, 33.6481], [-117.82078, 33.64809], [-117.82113, 33.64806], [-117.82148, 33.648], [-117.82195, 33.64788], [-117.8223, 33.64776], [-117.82276, 33.64756], [-117.82281, 33.64763]]]} | Restricted Access 2 | 47981 | HOA Community Park | 32337 | 6001 | Broadmoor Campus View Community Association 691 | Private 7 | Home Owners Association 16 | Private 14 | 6001 | Broadmoor Campus View Community Association 681 | Private 7 | Home Owners Association 15 | Orange 3 | 1.023 | HOA Community Park | 0 | Private Recreation or Education 65 | 4 | ||
14797 | 14797 | 14796 | {"type": "Polygon", "coordinates": [[[-116.97573, 32.61392], [-116.97559, 32.61421], [-116.97545, 32.61416], [-116.97534, 32.61417], [-116.97525, 32.61422], [-116.9752, 32.6143], [-116.97465, 32.61411], [-116.97466, 32.61409], [-116.97479, 32.61409], [-116.97496, 32.61406], [-116.97549, 32.61389], [-116.97561, 32.61388], [-116.97573, 32.6139], [-116.97573, 32.61392]]]} | Restricted Access 2 | 45183 | Terracotta Park | 33352 | 6074 | Home Owners Association - Unknown Name 640 | Private 7 | Home Owners Association 16 | Private 14 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | San Diego 4 | 0.546 | Terracotta Park | 0 | Private Recreation or Education 65 | 4 | ||
14796 | 14796 | 14795 | {"type": "Polygon", "coordinates": [[[-117.00158, 32.64883], [-117.00127, 32.64895], [-117.00104, 32.64919], [-117.00075, 32.64957], [-117.00074, 32.64972], [-117.00066, 32.64986], [-117.00056, 32.64961], [-117.00018, 32.64972], [-117.00016, 32.64965], [-117.00053, 32.64954], [-117.00037, 32.64912], [-117.00096, 32.64895], [-117.00084, 32.64865], [-117.00104, 32.6486], [-117.00118, 32.64862], [-117.00145, 32.6487], [-117.00158, 32.64883]]]} | Restricted Access 2 | 45182 | Bonitas Haciendas Mini-Park | 33347 | 6074 | Home Owners Association - Unknown Name 640 | Private 7 | Home Owners Association 16 | Private 14 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | San Diego 4 | 1.39 | Bonitas Haciendas Mini-Park | 0 | Private Recreation or Education 65 | 4 | ||
14795 | 14795 | 14794 | {"type": "Polygon", "coordinates": [[[-117.09011, 32.59473], [-117.08972, 32.59469], [-117.08918, 32.59467], [-117.08903, 32.5938], [-117.08962, 32.59389], [-117.08963, 32.59399], [-117.08946, 32.59415], [-117.08978, 32.59442], [-117.08985, 32.5944], [-117.08996, 32.59434], [-117.09002, 32.59442], [-117.09011, 32.59473]]]} | Restricted Access 2 | 45181 | Swiss Park | 33368 | 6074 | Home Owners Association - Unknown Name 640 | Private 7 | Home Owners Association 16 | Private 14 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | San Diego 4 | 1.419 | Swiss Park | 0 | Private Recreation or Education 65 | 4 | ||
14794 | 14794 | 14793 | {"type": "Polygon", "coordinates": [[[-116.95852, 32.65971], [-116.95848, 32.65998], [-116.95841, 32.66002], [-116.95813, 32.66], [-116.95816, 32.65968], [-116.95852, 32.65971]]]} | Restricted Access 2 | 45180 | Kensington Road Park | 33346 | 6074 | Home Owners Association - Unknown Name 640 | Private 7 | Home Owners Association 16 | Private 14 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | San Diego 4 | 0.287 | Kensington Road Park | 0 | Private Recreation or Education 65 | 4 | ||
14793 | 14793 | 14792 | {"type": "Polygon", "coordinates": [[[-116.97964, 32.65322], [-116.97946, 32.65338], [-116.97929, 32.65355], [-116.97916, 32.65372], [-116.97904, 32.65392], [-116.97898, 32.65372], [-116.97898, 32.65359], [-116.979, 32.65344], [-116.97897, 32.65339], [-116.97893, 32.65338], [-116.97888, 32.65338], [-116.97879, 32.65349], [-116.97871, 32.65353], [-116.97847, 32.65357], [-116.97835, 32.65366], [-116.97829, 32.65369], [-116.9782, 32.65371], [-116.97813, 32.65369], [-116.97806, 32.65365], [-116.97801, 32.65358], [-116.97795, 32.6532], [-116.97789, 32.65307], [-116.97778, 32.65298], [-116.97745, 32.65283], [-116.97781, 32.65226], [-116.97964, 32.65319], [-116.97964, 32.65322]]]} | Restricted Access 2 | 45164 | East Lake Beach Club | 33361 | 6074 | Home Owners Association - Unknown Name 640 | Private 7 | Home Owners Association 16 | Private 14 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | San Diego 4 | 4.065 | East Lake Beach Club | 0 | Private Recreation or Education 65 | 4 | ||
14788 | 14788 | 14787 | {"type": "Polygon", "coordinates": [[[-116.99842, 32.62091], [-116.9984, 32.62094], [-116.99795, 32.62104], [-116.99791, 32.62102], [-116.99774, 32.62046], [-116.99776, 32.62042], [-116.99821, 32.62033], [-116.99825, 32.62035], [-116.99842, 32.62091]]]} | Restricted Access 2 | 45176 | Wisteria Park | 33350 | 6074 | Home Owners Association - Unknown Name 640 | Private 7 | Home Owners Association 16 | Private 14 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | San Diego 4 | 0.858 | Wisteria Park | 0 | Private Recreation or Education 65 | 4 | ||
14787 | 14787 | 14786 | {"type": "Polygon", "coordinates": [[[-117.0031, 32.62517], [-117.00301, 32.62553], [-117.00297, 32.62555], [-117.00229, 32.62541], [-117.00226, 32.62538], [-117.00235, 32.62501], [-117.00239, 32.62499], [-117.00308, 32.62513], [-117.0031, 32.62517]]]} | Restricted Access 2 | 45174 | Orchard Park | 33354 | 6074 | Home Owners Association - Unknown Name 640 | Private 7 | Home Owners Association 16 | Private 14 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | San Diego 4 | 0.846 | Orchard Park | 0 | Private Recreation or Education 65 | 4 | ||
14786 | 14786 | 14785 | {"type": "Polygon", "coordinates": [[[-116.99738, 32.61585], [-116.99737, 32.61587], [-116.99645, 32.61622], [-116.99642, 32.61621], [-116.99622, 32.61584], [-116.99623, 32.61582], [-116.99716, 32.61547], [-116.99719, 32.61548], [-116.99738, 32.61585]]]} | Restricted Access 2 | 45173 | Jacaranda Park | 33362 | 6074 | Home Owners Association - Unknown Name 640 | Private 7 | Home Owners Association 16 | Private 14 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | San Diego 4 | 1.199 | Jacaranda Park | 0 | Private Recreation or Education 65 | 4 | ||
14785 | 14785 | 14784 | {"type": "Polygon", "coordinates": [[[-116.98144, 32.61519], [-116.98142, 32.61521], [-116.9809, 32.61533], [-116.98087, 32.61531], [-116.98071, 32.6148], [-116.98073, 32.61478], [-116.98126, 32.61466], [-116.98128, 32.61468], [-116.98144, 32.61519]]]} | Restricted Access 2 | 45172 | Mulberry Park | 33359 | 6074 | Home Owners Association - Unknown Name 640 | Private 7 | Home Owners Association 16 | Private 14 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | San Diego 4 | 0.858 | Mulberry Park | 0 | Private Recreation or Education 65 | 4 | ||
14784 | 14784 | 14783 | {"type": "Polygon", "coordinates": [[[-116.99018, 32.63505], [-116.99014, 32.63512], [-116.98962, 32.63527], [-116.98954, 32.63523], [-116.98938, 32.63482], [-116.99002, 32.63464], [-116.99018, 32.63505]]]} | Restricted Access 2 | 45171 | Alcala Park | 33366 | 6074 | Home Owners Association - Unknown Name 640 | Private 7 | Home Owners Association 16 | Private 14 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | San Diego 4 | 0.85 | Alcala Park | 0 | Private Recreation or Education 65 | 4 | ||
14782 | 14782 | 14781 | {"type": "Polygon", "coordinates": [[[-116.98239, 32.62449], [-116.98165, 32.62469], [-116.98153, 32.62438], [-116.98226, 32.62417], [-116.98239, 32.62449]]]} | Restricted Access 2 | 45169 | Sienna Park | 33365 | 6074 | Home Owners Association - Unknown Name 640 | Private 7 | Home Owners Association 16 | Private 14 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | San Diego 4 | 0.67 | Sienna Park | 0 | Private Recreation or Education 65 | 4 | ||
14779 | 14779 | 14778 | {"type": "Polygon", "coordinates": [[[-116.95147, 32.64226], [-116.95151, 32.64236], [-116.95151, 32.64247], [-116.95145, 32.64258], [-116.95133, 32.64266], [-116.95118, 32.64269], [-116.95105, 32.64267], [-116.95093, 32.6426], [-116.95086, 32.6425], [-116.95084, 32.6424], [-116.95087, 32.6423], [-116.95094, 32.64221], [-116.95103, 32.64215], [-116.95116, 32.64212], [-116.95126, 32.64213], [-116.95138, 32.64218], [-116.95147, 32.64226]]]} | Restricted Access 2 | 45167 | Circle Park | 33367 | 6074 | Home Owners Association - Unknown Name 640 | Private 7 | Home Owners Association 16 | Private 14 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | San Diego 4 | 0.754 | Circle Park | 0 | Private Recreation or Education 65 | 4 | ||
14778 | 14778 | 14777 | {"type": "Polygon", "coordinates": [[[-116.95784, 32.6469], [-116.95776, 32.64726], [-116.95776, 32.64742], [-116.95656, 32.64741], [-116.95641, 32.64735], [-116.95632, 32.64703], [-116.95625, 32.64688], [-116.95615, 32.64672], [-116.95619, 32.64666], [-116.95674, 32.64628], [-116.95698, 32.64648], [-116.95726, 32.64666], [-116.95755, 32.6468], [-116.95784, 32.6469]]]} | Restricted Access 2 | 45166 | Augusta Park | 33363 | 6074 | Home Owners Association - Unknown Name 640 | Private 7 | Home Owners Association 16 | Private 14 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | San Diego 4 | 3.216 | Augusta Park | 0 | Private Recreation or Education 65 | 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]);