units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
77 rows where ACCESS_TYP = 3 and DES_TP = 2 sorted by AGNCY_WEB
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, LAYER, MNG_AG_ID, MNG_AG_LEV, PARK_URL, COUNTY, YR_EST
MNG_AGENCY 26
- East Bay Regional Park District 23
- Los Angeles, City of 16
- Santa Clara County Parks and Recreation Dept., County of 4
- San Diego, City of 3
- Napa County Regional Park and Open Space District 3
- Rolling Hills, City of 3
- Mountains Recreation and Conservation Authority 2
- San Diego, County of 2
- San Marcos, City of 2
- Napa, City of 2
- Rocklin, City of 2
- Los Angeles, County of 1
- San Mateo County Parks and Recreation Dept., County of 1
- Santee, City of 1
- Marin County Open Space District 1
- Rosemead, City of 1
- Sonoma County Regional Parks Dept., County of 1
- Palmdale, City of 1
- Norwalk, City of 1
- Bakersfield, City of 1
- Long Beach, City of 1
- La Verne, City of 1
- Agoura Hills, City of 1
- Roseville, City of 1
- South El Monte, City of 1
- San Dieguito River Park Joint Powers Authority 1
MNG_AG_TYP 5
DES_TP 1
- Local Park · 77 ✖
ACCESS_TYP 1
- No Public Access · 77 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1270 | 1270 | 1269 | {"type": "Polygon", "coordinates": [[[-118.56523, 34.13034], [-118.56473, 34.13106], [-118.56429, 34.13106], [-118.56418, 34.13093], [-118.56397, 34.13076], [-118.56397, 34.13019], [-118.56387, 34.13018], [-118.56387, 34.12948], [-118.5652, 34.12947], [-118.56479, 34.13017], [-118.56523, 34.13034]]]} | No Public Access 3 | 7159 | Los Angeles City Water Resource Parkland | 21477 | 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 | 4.129 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
1271 | 1271 | 1270 | {"type": "Polygon", "coordinates": [[[-118.44484, 34.1151], [-118.44483, 34.11604], [-118.44451, 34.11604], [-118.44418, 34.11581], [-118.44418, 34.11543], [-118.4445, 34.11515], [-118.44451, 34.1151], [-118.44484, 34.1151]]]} | No Public Access 3 | 7160 | Los Angeles City Water Resource Parkland | 21477 | 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 | 1.317 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
1340 | 1340 | 1339 | {"type": "Polygon", "coordinates": [[[-118.38142, 34.10854], [-118.38114, 34.10871], [-118.38103, 34.10855], [-118.38131, 34.10838], [-118.38142, 34.10854]]]} | No Public Access 3 | 12809 | Los Angeles City Water Resource Parkland | 21477 | 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.163 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
1489 | 1489 | 1488 | {"type": "Polygon", "coordinates": [[[-118.46789, 34.09611], [-118.46633, 34.09612], [-118.46623, 34.09617], [-118.46611, 34.09595], [-118.46593, 34.09571], [-118.46592, 34.09565], [-118.46593, 34.09559], [-118.46595, 34.09555], [-118.46601, 34.09548], [-118.46614, 34.09544], [-118.4678, 34.09543], [-118.46792, 34.09583], [-118.46789, 34.09611]]]} | No Public Access 3 | 12701 | Los Angeles City Water Resource Parkland | 21477 | 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 | 3.182 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
2803 | 2803 | 2802 | {"type": "Polygon", "coordinates": [[[-118.37097, 34.13187], [-118.37053, 34.13214], [-118.36993, 34.13183], [-118.37013, 34.13145], [-118.37097, 34.13187]]]} | No Public Access 3 | 12817 | Los Angeles City Water Resource Parkland | 21477 | 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.89 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
5168 | 5168 | 5167 | {"type": "Polygon", "coordinates": [[[-118.37164, 34.13145], [-118.37153, 34.13213], [-118.37007, 34.13142], [-118.37071, 34.1309], [-118.37084, 34.13153], [-118.37164, 34.13145]]]} | No Public Access 3 | 12818 | Los Angeles City Water Resource Parkland | 21477 | 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 | 1.768 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
5411 | 5411 | 5410 | {"type": "Polygon", "coordinates": [[[-118.58708, 34.13904], [-118.58568, 34.13904], [-118.58568, 34.13813], [-118.58707, 34.13866], [-118.58708, 34.13904]]]} | No Public Access 3 | 7166 | Los Angeles City Water Resource Parkland | 21477 | 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 | 2.267 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
5495 | 5495 | 5494 | {"type": "Polygon", "coordinates": [[[-118.38093, 34.1267], [-118.38083, 34.12681], [-118.38083, 34.12701], [-118.38061, 34.12707], [-118.38043, 34.12717], [-118.38031, 34.12721], [-118.3802, 34.12721], [-118.38011, 34.12718], [-118.38003, 34.12714], [-118.37992, 34.12701], [-118.3798, 34.12694], [-118.37975, 34.12694], [-118.37974, 34.12695], [-118.37963, 34.12692], [-118.37943, 34.1269], [-118.37939, 34.12686], [-118.37941, 34.12663], [-118.38093, 34.1267]]]} | No Public Access 3 | 12819 | Los Angeles City Water Resource Parkland | 21477 | 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 | 1.441 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
5496 | 5496 | 5495 | {"type": "Polygon", "coordinates": [[[-118.39301, 34.11863], [-118.39283, 34.11899], [-118.39267, 34.11881], [-118.39276, 34.11874], [-118.39271, 34.11868], [-118.3926, 34.11875], [-118.39249, 34.11863], [-118.39234, 34.11881], [-118.39226, 34.11887], [-118.39219, 34.11889], [-118.39201, 34.11889], [-118.39183, 34.11881], [-118.39175, 34.11874], [-118.39223, 34.11873], [-118.39222, 34.11808], [-118.39228, 34.11821], [-118.39284, 34.11848], [-118.39299, 34.11857], [-118.39297, 34.1186], [-118.39301, 34.11863]]]} | No Public Access 3 | 12820 | Los Angeles City Water Resource Parkland | 21477 | 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.964 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
5497 | 5497 | 5496 | {"type": "Polygon", "coordinates": [[[-118.39276, 34.11874], [-118.39267, 34.11881], [-118.3926, 34.11875], [-118.39271, 34.11867], [-118.39276, 34.11874]]]} | No Public Access 3 | 12821 | Los Angeles City Water Resource Parkland | 21477 | 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.028 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
7551 | 7551 | 7550 | {"type": "Polygon", "coordinates": [[[-118.44367, 34.1295], [-118.4417, 34.12943], [-118.4417, 34.12935], [-118.44173, 34.12926], [-118.44203, 34.12886], [-118.44206, 34.12877], [-118.44212, 34.12843], [-118.4427, 34.12846], [-118.44271, 34.12848], [-118.44294, 34.12848], [-118.44294, 34.12861], [-118.4431, 34.12855], [-118.44318, 34.12855], [-118.44328, 34.12859], [-118.44334, 34.12867], [-118.44367, 34.1295]]]} | No Public Access 3 | 7161 | Los Angeles City Water Resource Parkland | 21477 | 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 | 3.797 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
7936 | 7936 | 7935 | {"type": "Polygon", "coordinates": [[[-118.36765, 34.12534], [-118.36714, 34.12607], [-118.36565, 34.126], [-118.3668, 34.12438], [-118.3669, 34.12456], [-118.36735, 34.12491], [-118.36715, 34.12508], [-118.36715, 34.1251], [-118.36765, 34.12534]]]} | No Public Access 3 | 12815 | Los Angeles City Water Resource Parkland | 21477 | 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 | 4.385 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
7948 | 7948 | 7947 | {"type": "Polygon", "coordinates": [[[-118.37369, 34.12306], [-118.3737, 34.12323], [-118.37362, 34.12338], [-118.37328, 34.12338], [-118.37328, 34.12313], [-118.3733, 34.12309], [-118.37349, 34.12293], [-118.37369, 34.12306]]]} | No Public Access 3 | 12814 | Los Angeles City Water Resource Parkland | 21477 | 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.377 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
8264 | 8264 | 8263 | {"type": "Polygon", "coordinates": [[[-118.38077, 34.1079], [-118.38075, 34.10838], [-118.38056, 34.10851], [-118.3804, 34.10844], [-118.38058, 34.10801], [-118.38077, 34.1079]]]} | No Public Access 3 | 12810 | Los Angeles City Water Resource Parkland | 21477 | 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.337 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
8326 | 8326 | 8325 | {"type": "Polygon", "coordinates": [[[-118.38131, 34.10838], [-118.38103, 34.10855], [-118.38075, 34.10838], [-118.38077, 34.1079], [-118.38091, 34.10781], [-118.38131, 34.10838]]]} | No Public Access 3 | 12808 | Los Angeles City Water Resource Parkland | 21477 | 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.602 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
8327 | 8327 | 8326 | {"type": "Polygon", "coordinates": [[[-118.38766, 34.10102], [-118.38766, 34.10162], [-118.38733, 34.10162], [-118.38682, 34.10136], [-118.38679, 34.10134], [-118.3867, 34.10118], [-118.38646, 34.10102], [-118.38651, 34.10098], [-118.38678, 34.10116], [-118.38686, 34.10109], [-118.38711, 34.10102], [-118.38766, 34.10102]]]} | No Public Access 3 | 12811 | Los Angeles City Water Resource Parkland | 21477 | 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 | 1.168 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
7804 | 7804 | 7803 | {"type": "Polygon", "coordinates": [[[-122.42274, 38.39449], [-122.41856, 38.39451], [-122.4184, 38.39435], [-122.41835, 38.39431], [-122.41799, 38.39415], [-122.4177, 38.39404], [-122.41652, 38.39341], [-122.41618, 38.39306], [-122.41604, 38.39295], [-122.41586, 38.39286], [-122.4159, 38.39281], [-122.41587, 38.39273], [-122.41593, 38.39256], [-122.41485, 38.39153], [-122.4144, 38.39119], [-122.41397, 38.39091], [-122.41853, 38.39089], [-122.41855, 38.39111], [-122.4213, 38.39198], [-122.42177, 38.39216], [-122.42274, 38.39449]]]} | No Public Access 3 | 47687 | Amy's Grove | 31415 | 2268 | Napa County Regional Park and Open Space District 362 | Special District 4 | Recreation/Parks District 4 | http://napaoutdoors.org/ | Special District 4 | 2268 | Napa County Regional Park and Open Space District 108 | Special District 4 | Recreation/Parks District 4 | Napa 11 | 46.448 | Amy's Grove | 0 | Local Park 2 | 4 | |
12695 | 12695 | 12694 | {"type": "Polygon", "coordinates": [[[-122.40964, 38.68011], [-122.40956, 38.68365], [-122.40952, 38.68724], [-122.40478, 38.68709], [-122.4047, 38.6907], [-122.39951, 38.69062], [-122.39527, 38.69057], [-122.39504, 38.69578], [-122.39039, 38.69587], [-122.39061, 38.69034], [-122.38763, 38.69028], [-122.38649, 38.69024], [-122.38121, 38.69002], [-122.38133, 38.68643], [-122.37682, 38.68621], [-122.37676, 38.68424], [-122.37681, 38.68268], [-122.37452, 38.68259], [-122.37214, 38.68246], [-122.37213, 38.68245], [-122.36757, 38.68254], [-122.36765, 38.68161], [-122.36767, 38.68121], [-122.36768, 38.68084], [-122.36787, 38.67553], [-122.37239, 38.67547], [-122.37274, 38.66956], [-122.37293, 38.66506], [-122.37302, 38.66206], [-122.37758, 38.66211], [-122.37756, 38.66521], [-122.39123, 38.66557], [-122.39093, 38.66867], [-122.40056, 38.66905], [-122.40041, 38.67376], [-122.40037, 38.67625], [-122.40505, 38.67637], [-122.40505, 38.67781], [-122.40498, 38.67991], [-122.40964, 38.68011]]]} | No Public Access 3 | 29687 | Spanish Valley Park | 25713 | 2268 | Napa County Regional Park and Open Space District 362 | Special District 4 | Recreation/Parks District 4 | http://napaoutdoors.org/ | Special District 4 | 2268 | Napa County Regional Park and Open Space District 108 | Special District 4 | Recreation/Parks District 4 | Napa 11 | 1869.617 | Spanish Valley Park | 0 | Local Park 2 | 4 | |
12750 | 12750 | 12749 | {"type": "Polygon", "coordinates": [[[-122.38127, 38.70509], [-122.38078, 38.70507], [-122.37824, 38.7051], [-122.3786, 38.70485], [-122.37859, 38.70483], [-122.37331, 38.70478], [-122.3714, 38.70479], [-122.37159, 38.69807], [-122.37114, 38.69802], [-122.37067, 38.69808], [-122.36978, 38.69825], [-122.36949, 38.69832], [-122.36923, 38.69836], [-122.3688, 38.69841], [-122.36838, 38.6984], [-122.36814, 38.69816], [-122.36784, 38.6978], [-122.36761, 38.69742], [-122.36733, 38.6972], [-122.36713, 38.69721], [-122.36712, 38.69704], [-122.36619, 38.69633], [-122.3661, 38.6962], [-122.36593, 38.69603], [-122.36533, 38.69557], [-122.36488, 38.69588], [-122.36327, 38.69474], [-122.362, 38.69372], [-122.36072, 38.69367], [-122.35807, 38.6936], [-122.3581, 38.68997], [-122.37187, 38.68962], [-122.37206, 38.68997], [-122.37181, 38.69006], [-122.37188, 38.69016], [-122.37147, 38.69036], [-122.37179, 38.69049], [-122.37161, 38.69114], [-122.37177, 38.69193], [-122.37056, 38.69187], [-122.37054, 38.69248], [-122.37055, 38.69283], [-122.37196, 38.69288], [-122.37193, 38.69346], [-122.37248, 38.69419], [-122.37326, 38.6953], [-122.37328, 38.69553], [-122.37364, 38.69545], [-122.37369, 38.6956], [-122.37336, 38.69568], [-122.37326, 38.69569], [-122.37324, 38.69604], [-122.37316, 38.6967], [-122.37352, 38.69766], [-122.37423, 38.69847], [-122.37399, 38.69901], [-122.37434, 38.6991], [-122.37431, 38.69925], [-122.37387, 38.69922], [-122.37381, 38.69941], [-122.37374, 38.69958], [-122.37399, 38.70068], [-122.37387, 38.70119], [-122.37401, 38.70131], [-122.37398, 38.70139], [-122.37395, 38.70142], [-122.37365, 38.70124], [-122.37355, 38.70113], [-122.37349, 38.70101], [-122.37344, 38.70073], [-122.37324, 38.70074], [-122.37304, 38.70134], [-122.37295, 38.70159], [-122.37293, 38.70158], [-122.37267, 38.70236], [-122.37296, 38.70301], [-122.37356, 38.7035], [-122.37569, 38.70411], [-122.37701, 38.70406], [-122.37915, 38.70369], [-122.37995, 38.70354], [-122.38078, 38.70348], [-122.38127, 38.70509]]]} | No Public Access 3 | 29781 | Stone Corral Park | 25866 | 2268 | Napa County Regional Park and Open Space District 362 | Special District 4 | Recreation/Parks District 4 | http://napaoutdoors.org/ | Special District 4 | 2268 | Napa County Regional Park and Open Space District 108 | Special District 4 | Recreation/Parks District 4 | Napa 11 | 260.006 | Stone Corral Park | 0 | Local Park 2 | 4 | |
15248 | 15248 | 15247 | {"type": "MultiPolygon", "coordinates": [[[[-117.82076, 34.50651], [-117.81973, 34.50699], [-117.81803, 34.50778], [-117.81802, 34.50641], [-117.81848, 34.50646], [-117.81894, 34.50649], [-117.82076, 34.50651]]], [[[-117.82283, 34.50772], [-117.82137, 34.5084], [-117.82128, 34.50829], [-117.82054, 34.50863], [-117.82054, 34.50864], [-117.82062, 34.50875], [-117.81915, 34.50943], [-117.81813, 34.50793], [-117.82116, 34.50651], [-117.82201, 34.50652], [-117.82283, 34.50772]]], [[[-117.82395, 34.50937], [-117.82028, 34.51109], [-117.81925, 34.50958], [-117.82071, 34.5089], [-117.8208, 34.50901], [-117.82121, 34.50882], [-117.82154, 34.50867], [-117.82147, 34.50855], [-117.82293, 34.50787], [-117.82395, 34.50937]]], [[[-117.82134, 34.50864], [-117.82087, 34.50885], [-117.82074, 34.50866], [-117.82121, 34.50845], [-117.82134, 34.50864]]], [[[-117.82342, 34.50815], [-117.82232, 34.50652], [-117.82232, 34.50652], [-117.82341, 34.50648], [-117.82342, 34.50815]]]]} | No Public Access 3 | 46291 | Shady Bend Park | 29584 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 42.987 | Shady Bend 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]);