units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
113 rows where ACCESS_TYP = 3 and DES_TP = 3 sorted by UNIT_ID descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP, LAYER, MNG_AG_LEV, PARK_URL, COUNTY, YR_EST
MNG_AGENCY >30
- Las Virgenes Municipal Water District 28
- Littlerock Creek Irrigation District 12
- Los Angeles - Department of Water and Power, City of 5
- Kinneloa Irrigation District 5
- East Bay Municipal Utility District 5
- East Bay Regional Park District 4
- Vacaville, City of 4
- San Diego, City of 3
- Long Beach, City of 3
- Saint Helena, City of 3
- Chico, City of 3
- Los Angeles, County of 2
- La Verne, City of 2
- Conejo Open Space Conservation Agency 2
- Valley Center Water District 2
- Monterey, County of 1
- Los Angeles, City of 1
- Santa Rosa, City of 1
- Monterey Peninsula Regional Park District 1
- Oceanside, City of 1
- Escondido, City of 1
- San Diego, County of 1
- Poway, City of 1
- Petaluma, City of 1
- Santa Monica, City of 1
- San Marcos, City of 1
- Fairfield, City of 1
- Irvine, City of 1
- Los Angeles County Flood Control District 1
- West Covina, City of 1
- …
MNG_AG_TYP 7
DES_TP 1
- Local Recreation Area · 113 ✖
ACCESS_TYP 1
- No Public Access · 113 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10005 | 10005 | 10004 | {"type": "Polygon", "coordinates": [[[-117.13531, 32.80963], [-117.13296, 32.80967], [-117.13295, 32.80886], [-117.13279, 32.80885], [-117.13274, 32.80882], [-117.13263, 32.8087], [-117.13257, 32.80854], [-117.13257, 32.80843], [-117.13265, 32.80791], [-117.13264, 32.80786], [-117.1326, 32.8078], [-117.13254, 32.80778], [-117.13225, 32.80775], [-117.13215, 32.80763], [-117.13295, 32.80762], [-117.13296, 32.80837], [-117.13529, 32.80833], [-117.13531, 32.80963]]]} | No Public Access 3 | 47974 | City of San Diego Open Space | 32304 | 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 | 9.034 | City of San Diego OS | 0 | Local Recreation Area 3 | 4 | |
10000 | 10000 | 9999 | {"type": "Polygon", "coordinates": [[[-117.00123, 32.56466], [-117.00121, 32.56728], [-117.00107, 32.56728], [-117.00106, 32.56732], [-117.00068, 32.56736], [-117.00055, 32.56745], [-117.00053, 32.56778], [-117.00042, 32.56807], [-116.99905, 32.56804], [-116.99908, 32.56463], [-117.00123, 32.56466]]]} | No Public Access 3 | 47970 | Otay Mesa Open Space | 32281 | 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 | 17.649 | Otay Mesa OS | 0 | Local Recreation Area 3 | 4 | |
16087 | 16087 | 16086 | {"type": "MultiPolygon", "coordinates": [[[[-116.90152, 33.10587], [-116.89724, 33.10587], [-116.89719, 33.10206], [-116.89513, 33.10205], [-116.89508, 33.10392], [-116.89076, 33.10399], [-116.89074, 33.10215], [-116.89295, 33.10209], [-116.89298, 33.09483], [-116.89275, 33.08392], [-116.90146, 33.08384], [-116.90148, 33.08369], [-116.90146, 33.08771], [-116.89987, 33.08735], [-116.8997, 33.08734], [-116.89919, 33.08738], [-116.89898, 33.08738], [-116.89802, 33.08726], [-116.89789, 33.08727], [-116.89777, 33.0873], [-116.89716, 33.08761], [-116.89689, 33.08767], [-116.89679, 33.08771], [-116.8967, 33.08775], [-116.89665, 33.08781], [-116.89661, 33.08793], [-116.89663, 33.08808], [-116.89657, 33.08829], [-116.89633, 33.08876], [-116.89605, 33.08912], [-116.89595, 33.08934], [-116.89596, 33.08943], [-116.89612, 33.08973], [-116.89632, 33.08999], [-116.89646, 33.09033], [-116.89664, 33.09052], [-116.8967, 33.09062], [-116.89672, 33.09068], [-116.89672, 33.09073], [-116.89656, 33.09103], [-116.89643, 33.09145], [-116.89626, 33.09176], [-116.896, 33.09212], [-116.89594, 33.09225], [-116.89588, 33.09244], [-116.89584, 33.09273], [-116.89577, 33.09306], [-116.89575, 33.09322], [-116.89565, 33.0938], [-116.89555, 33.09451], [-116.8955, 33.09464], [-116.89534, 33.09481], [-116.8955, 33.09482], [-116.8956, 33.09471], [-116.89567, 33.0946], [-116.89578, 33.09376], [-116.89588, 33.09326], [-116.89589, 33.09313], [-116.89607, 33.09227], [-116.89614, 33.09212], [-116.89637, 33.09182], [-116.89654, 33.09153], [-116.89666, 33.09113], [-116.89684, 33.09077], [-116.89685, 33.09067], [-116.89684, 33.09059], [-116.89674, 33.09046], [-116.89664, 33.09036], [-116.89658, 33.09028], [-116.89643, 33.08994], [-116.89626, 33.08971], [-116.89609, 33.0894], [-116.89609, 33.08935], [-116.89617, 33.08916], [-116.89644, 33.08879], [-116.89669, 33.08833], [-116.89675, 33.08817], [-116.89675, 33.0879], [-116.89678, 33.08784], [-116.89693, 33.08777], [-116.89718, 33.08773], [-116.89783, 33.0874], [-116.89791, 33.08737], [-116.89801, 33.08737], [-116.89902, 33.08748], [-116.89923, 33.08748], [-116.89969, 33.08745], [-116.89986, 33.08746], [-116.90146, 33.08783], [-116.90149, 33.09135], [-116.90152, 33.10587]]], [[[-116.91016, 33.11349], [-116.90585, 33.11346], [-116.90585, 33.12475], [-116.89299, 33.12481], [-116.89298, 33.12095], [-116.90158, 33.12097], [-116.90154, 33.11025], [-116.91014, 33.11012], [-116.91016, 33.11349]]]]} | No Public Access 3 | 47726 | San Pasqual Trails Open Space | 31514 | 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 | https://www.sandiego.gov/park-and-recreation/parks/osp/sanpasqual | San Diego 4 | 738.003 | San Pasqual Trails OS | 0 | Local Recreation Area 3 | 4 |
14455 | 14455 | 14454 | {"type": "Polygon", "coordinates": [[[-121.57028, 36.98526], [-121.57016, 36.98644], [-121.56903, 36.98732], [-121.56823, 36.98827], [-121.56752, 36.98805], [-121.56739, 36.98809], [-121.56746, 36.98845], [-121.56736, 36.98862], [-121.56746, 36.98889], [-121.56765, 36.98897], [-121.56788, 36.98964], [-121.56506, 36.98952], [-121.56478, 36.98881], [-121.56469, 36.9885], [-121.56463, 36.98809], [-121.56442, 36.98752], [-121.56438, 36.98698], [-121.56318, 36.98696], [-121.56293, 36.98677], [-121.56207, 36.98458], [-121.56254, 36.98461], [-121.56288, 36.98455], [-121.5632, 36.98441], [-121.56365, 36.98448], [-121.56456, 36.9845], [-121.56485, 36.98467], [-121.56583, 36.9838], [-121.5667, 36.9842], [-121.56682, 36.98537], [-121.56721, 36.9857], [-121.56945, 36.98464], [-121.57028, 36.98526]]]} | No Public Access 3 | 47073 | Gilroy Sports Park | 30723 | 1118 | Gilroy, City of 407 | City 2 | City Agency 2 | http://www.cityofgilroy.org/cityofgilroy/community/parks/default.aspx | City 2 | 1118 | Gilroy, City of 401 | City 2 | City Agency 2 | Santa Clara 19 | 64.09 | Gilroy Sports Park | 0 | Local Recreation Area 3 | 4 | |
16860 | 16860 | 16859 | {"type": "MultiPolygon", "coordinates": [[[[-121.60916, 37.93276], [-121.60904, 37.93276], [-121.60902, 37.93271], [-121.6081, 37.93272], [-121.60864, 37.93598], [-121.60795, 37.93658], [-121.60834, 37.93867], [-121.60825, 37.93905], [-121.59819, 37.93913], [-121.5981, 37.93466], [-121.59229, 37.93078], [-121.59228, 37.92974], [-121.60063, 37.92967], [-121.60064, 37.92938], [-121.60198, 37.92936], [-121.60206, 37.92927], [-121.60211, 37.91785], [-121.60386, 37.91775], [-121.60391, 37.91959], [-121.6042, 37.92372], [-121.60742, 37.92337], [-121.6077, 37.92498], [-121.60431, 37.92535], [-121.60458, 37.92936], [-121.60442, 37.92964], [-121.60866, 37.92961], [-121.60872, 37.92983], [-121.60916, 37.93276]]], [[[-121.6409, 37.95462], [-121.64089, 37.96179], [-121.63483, 37.96181], [-121.63484, 37.9688], [-121.63566, 37.96881], [-121.6353, 37.96884], [-121.62825, 37.96876], [-121.62721, 37.96876], [-121.62716, 37.9654], [-121.62013, 37.96544], [-121.61998, 37.95458], [-121.62267, 37.95456], [-121.64086, 37.95454], [-121.64086, 37.95461], [-121.6409, 37.95462]]], [[[-121.63638, 37.96886], [-121.63635, 37.97242], [-121.62718, 37.97244], [-121.62709, 37.96887], [-121.62825, 37.96887], [-121.6353, 37.96895], [-121.63638, 37.96886]]]]} | No Public Access 3 | 46995 | Delta Access Regional Recreation Area | 30632 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 986.689 | Delta Access Reg. Rec. Area | 0 | Local Recreation Area 3 | 4 | |
13126 | 13126 | 13125 | {"type": "Polygon", "coordinates": [[[-121.97561, 37.57073], [-121.97355, 37.57142], [-121.97349, 37.57127], [-121.97245, 37.57159], [-121.97094, 37.57232], [-121.97064, 37.57203], [-121.97072, 37.57045], [-121.97094, 37.5703], [-121.97132, 37.57017], [-121.97167, 37.57028], [-121.97219, 37.57057], [-121.97251, 37.57061], [-121.97248, 37.57023], [-121.97265, 37.56971], [-121.97407, 37.56935], [-121.97486, 37.57004], [-121.97518, 37.57025], [-121.97535, 37.57038], [-121.97561, 37.57073]]]} | No Public Access 3 | 46965 | Quarry Lakes Regional Recreation Area | 30596 | 2000 | Alameda County Flood Control and Water Conservation District 771 | Special District 4 | Flood District 8 | http://acfloodcontrol.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 17.733 | Quarry Lakes Reg. Rec. Area | 2001 | Local Recreation Area 3 | 4 | |
16183 | 16183 | 16182 | {"type": "Polygon", "coordinates": [[[-116.96262, 32.66755], [-116.96258, 32.67203], [-116.9624, 32.67632], [-116.96061, 32.6763], [-116.96057, 32.67812], [-116.95842, 32.67809], [-116.95815, 32.68544], [-116.95389, 32.68549], [-116.9496, 32.68532], [-116.94952, 32.67935], [-116.94962, 32.66718], [-116.95173, 32.66721], [-116.95171, 32.67086], [-116.95136, 32.67085], [-116.95135, 32.67086], [-116.95145, 32.67118], [-116.9517, 32.67172], [-116.95188, 32.67188], [-116.95185, 32.67227], [-116.95191, 32.67262], [-116.9519, 32.67282], [-116.95177, 32.67289], [-116.95196, 32.6732], [-116.95169, 32.67409], [-116.95183, 32.67443], [-116.95208, 32.67451], [-116.95247, 32.67456], [-116.9524, 32.67497], [-116.95235, 32.67565], [-116.95234, 32.67634], [-116.95242, 32.67715], [-116.95232, 32.67769], [-116.95227, 32.67865], [-116.95263, 32.67895], [-116.9528, 32.67927], [-116.95272, 32.67965], [-116.95259, 32.68069], [-116.95268, 32.68104], [-116.95291, 32.68152], [-116.95313, 32.68161], [-116.95414, 32.68165], [-116.95455, 32.68221], [-116.95477, 32.68236], [-116.95507, 32.68269], [-116.95534, 32.68301], [-116.95553, 32.68311], [-116.95598, 32.68351], [-116.95623, 32.68353], [-116.95641, 32.6833], [-116.95648, 32.68294], [-116.95691, 32.6828], [-116.95718, 32.68259], [-116.95736, 32.68229], [-116.95749, 32.68199], [-116.95741, 32.68142], [-116.9572, 32.68091], [-116.95737, 32.68062], [-116.95743, 32.68033], [-116.95743, 32.68007], [-116.9575, 32.67979], [-116.95762, 32.67949], [-116.95764, 32.67923], [-116.95759, 32.67898], [-116.95759, 32.67872], [-116.95752, 32.67844], [-116.95757, 32.67783], [-116.95772, 32.67749], [-116.95798, 32.67702], [-116.95829, 32.67654], [-116.95842, 32.67622], [-116.95892, 32.67575], [-116.96005, 32.67517], [-116.96004, 32.67482], [-116.96017, 32.67458], [-116.96029, 32.67422], [-116.96058, 32.67373], [-116.96067, 32.6735], [-116.96068, 32.67316], [-116.96065, 32.67274], [-116.96045, 32.67188], [-116.96041, 32.67153], [-116.96048, 32.67116], [-116.96048, 32.67092], [-116.96103, 32.67029], [-116.9616, 32.66946], [-116.96178, 32.66878], [-116.96214, 32.66815], [-116.96242, 32.66771], [-116.96262, 32.66755]]]} | No Public Access 3 | 46836 | Mount Miguel Open Space | 30305 | 2401 | Otay Water District 1164 | Special District 4 | Water District 13 | http://www.otaywater.gov/ | Special District 4 | 2401 | Otay Water District 1106 | Special District 4 | Water District 13 | San Diego 4 | 231.148 | Mount Miguel OS | 0 | Local Recreation Area 3 | 4 | |
15407 | 15407 | 15406 | {"type": "MultiPolygon", "coordinates": [[[[-118.19258, 33.84372], [-118.18742, 33.84551], [-118.1873, 33.84546], [-118.18731, 33.84541], [-118.18836, 33.84504], [-118.18837, 33.84497], [-118.18857, 33.84497], [-118.18981, 33.84454], [-118.18982, 33.84458], [-118.19067, 33.84429], [-118.19068, 33.84423], [-118.19254, 33.8436], [-118.19258, 33.84372]]], [[[-118.19442, 33.8431], [-118.19291, 33.84361], [-118.19283, 33.84363], [-118.19279, 33.84352], [-118.194, 33.8431], [-118.19442, 33.8431]]]]} | No Public Access 3 | 46631 | Sleepy Hollow Greenbelt | 29956 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 2.297 | Sleepy Hollow Greenbelt | 0 | Local Recreation Area 3 | 4 | |
15401 | 15401 | 15400 | {"type": "MultiPolygon", "coordinates": [[[[-118.1485, 33.77888], [-118.14796, 33.77888], [-118.14599, 33.77761], [-118.14599, 33.77723], [-118.14605, 33.77723], [-118.14796, 33.77847], [-118.14797, 33.77854], [-118.1485, 33.77888]]], [[[-118.15014, 33.78025], [-118.14868, 33.77931], [-118.14828, 33.77905], [-118.1488, 33.77905], [-118.15013, 33.7799], [-118.15014, 33.78025]]]]} | No Public Access 3 | 46622 | Pacific Electric Greenbelt | 29943 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 3.703 | Pacific Electric Greenbelt | 0 | Local Recreation Area 3 | 4 | |
15149 | 15149 | 15148 | {"type": "Polygon", "coordinates": [[[-117.22985, 33.12069], [-117.22559, 33.1207], [-117.22559, 33.12034], [-117.22632, 33.12033], [-117.2275, 33.11994], [-117.22846, 33.11978], [-117.22826, 33.11881], [-117.22822, 33.11871], [-117.2277, 33.11842], [-117.22665, 33.11804], [-117.22645, 33.11788], [-117.2261, 33.1179], [-117.22608, 33.1176], [-117.22604, 33.11748], [-117.22594, 33.11732], [-117.22574, 33.11714], [-117.22573, 33.11712], [-117.22574, 33.11708], [-117.22579, 33.11704], [-117.22666, 33.11703], [-117.22668, 33.11773], [-117.22982, 33.11772], [-117.22985, 33.12069]]]} | No Public Access 3 | 45992 | Diamond Trail | 29166 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/content/dam/sdc/dpw/WATERSHED_PROTECTION_PROGRAM/Pacific%20Watersheds.pdf | San Diego 4 | 19.749 | Diamond Trail | 0 | Local Recreation Area 3 | 4 |
16227 | 16227 | 16226 | {"type": "Polygon", "coordinates": [[[-117.91283, 34.03821], [-117.91283, 34.03899], [-117.91275, 34.03962], [-117.9127, 34.0399], [-117.91261, 34.04022], [-117.9125, 34.04056], [-117.91237, 34.04089], [-117.91209, 34.04146], [-117.91176, 34.04199], [-117.91145, 34.04239], [-117.91062, 34.04338], [-117.9068, 34.0425], [-117.9068, 34.04242], [-117.90687, 34.04244], [-117.9069, 34.04236], [-117.90686, 34.04212], [-117.90703, 34.04191], [-117.907, 34.04164], [-117.90695, 34.04141], [-117.90686, 34.04117], [-117.90723, 34.04103], [-117.9074, 34.04095], [-117.9077, 34.04076], [-117.90797, 34.04194], [-117.9081, 34.04194], [-117.90836, 34.04217], [-117.90888, 34.0422], [-117.9092, 34.04178], [-117.9092, 34.04176], [-117.90879, 34.04158], [-117.90868, 34.04151], [-117.90863, 34.04145], [-117.90852, 34.04124], [-117.90817, 34.04033], [-117.90908, 34.03917], [-117.90866, 34.0401], [-117.90909, 34.04119], [-117.91045, 34.04181], [-117.91066, 34.04186], [-117.91145, 34.0417], [-117.912, 34.04119], [-117.91214, 34.04079], [-117.91193, 34.04047], [-117.91203, 34.04013], [-117.91245, 34.03993], [-117.91257, 34.03967], [-117.91242, 34.03907], [-117.91225, 34.0388], [-117.91189, 34.03836], [-117.91192, 34.03815], [-117.91215, 34.03816], [-117.91278, 34.03816], [-117.91283, 34.03821]]]} | No Public Access 3 | 45356 | City Open Space | 17340 | 1374 | West Covina, City of 318 | City 2 | City Agency 2 | http://www.westcovina.org/departments/community-recreation-services/park-facility-rentals | City 2 | 1374 | West Covina, City of 315 | City 2 | City Agency 2 | http://www.nlc.org/Documents/Utility%20Navigation/About%20NLC/Awards/2008%20West%20Covina%20Nomination.pdf | Los Angeles 6 | 22.107 | City OS | 0 | Local Recreation Area 3 | 4 |
7819 | 7819 | 7818 | {"type": "Polygon", "coordinates": [[[-117.03972, 33.04402], [-117.03943, 33.0444], [-117.03888, 33.04486], [-117.03845, 33.04501], [-117.03841, 33.04513], [-117.03859, 33.04512], [-117.03865, 33.04535], [-117.03844, 33.04562], [-117.03814, 33.04572], [-117.03826, 33.04578], [-117.03836, 33.04591], [-117.03828, 33.04624], [-117.03818, 33.04641], [-117.03827, 33.04668], [-117.03823, 33.04682], [-117.03792, 33.04698], [-117.03759, 33.047], [-117.03783, 33.04722], [-117.03797, 33.04745], [-117.03789, 33.048], [-117.03771, 33.04806], [-117.0377, 33.04816], [-117.03778, 33.04815], [-117.03782, 33.04825], [-117.03805, 33.04818], [-117.03825, 33.0486], [-117.03828, 33.04894], [-117.03825, 33.04912], [-117.03773, 33.05005], [-117.03685, 33.05007], [-117.03641, 33.0508], [-117.03551, 33.05159], [-117.03526, 33.05167], [-117.03535, 33.05175], [-117.03535, 33.05196], [-117.03492, 33.05207], [-117.03493, 33.05208], [-117.03535, 33.05209], [-117.03564, 33.05265], [-117.03564, 33.05294], [-117.03546, 33.0533], [-117.03525, 33.05341], [-117.03491, 33.05349], [-117.03449, 33.05379], [-117.03405, 33.05399], [-117.03372, 33.05402], [-117.03355, 33.05395], [-117.0332, 33.0535], [-117.03299, 33.0536], [-117.03251, 33.05366], [-117.0322, 33.05358], [-117.0319, 33.05323], [-117.0317, 33.05276], [-117.03172, 33.0526], [-117.03161, 33.05254], [-117.03152, 33.05235], [-117.03142, 33.05222], [-117.03121, 33.05205], [-117.03118, 33.05189], [-117.031, 33.05176], [-117.03082, 33.05168], [-117.03078, 33.05199], [-117.03021, 33.05221], [-117.03018, 33.05235], [-117.03005, 33.05247], [-117.0298, 33.05251], [-117.02974, 33.05266], [-117.02965, 33.05275], [-117.02977, 33.05283], [-117.02994, 33.05303], [-117.02985, 33.05319], [-117.03003, 33.0532], [-117.03029, 33.05356], [-117.02997, 33.05366], [-117.03029, 33.05384], [-117.03015, 33.05422], [-117.02991, 33.05429], [-117.03009, 33.05449], [-117.0301, 33.0548], [-117.02958, 33.05524], [-117.02954, 33.05553], [-117.02843, 33.05665], [-117.02719, 33.05498], [-117.02941, 33.05187], [-117.02865, 33.05038], [-117.02823, 33.05039], [-117.02836, 33.05023], [-117.0285, 33.04996], [-117.02865, 33.04978], [-117.03273, 33.04973], [-117.03274, 33.04972], [-117.0327, 33.04686], [-117.03187, 33.04596], [-117.03187, 33.04407], [-117.0268, 33.04408], [-117.02681, 33.04403], [-117.02936, 33.04402], [-117.02925, 33.04297], [-117.02982, 33.0424], [-117.03205, 33.04177], [-117.03183, 33.03683], [-117.03128, 33.03703], [-117.03115, 33.03705], [-117.03105, 33.03702], [-117.03078, 33.03701], [-117.03029, 33.03705], [-117.03004, 33.03693], [-117.03, 33.03687], [-117.02993, 33.03669], [-117.02962, 33.03636], [-117.0295, 33.03605], [-117.02942, 33.03576], [-117.02934, 33.03565], [-117.02929, 33.03539], [-117.02918, 33.03537], [-117.0287, 33.03495], [-117.02858, 33.03483], [-117.02838, 33.03472], [-117.02919, 33.03406], [-117.02919, 33.03422], [-117.02916, 33.03453], [-117.02944, 33.03467], [-117.03002, 33.03461], [-117.03033, 33.03469], [-117.03025, 33.03518], [-117.02965, 33.03624], [-117.03035, 33.03686], [-117.03087, 33.03678], [-117.03125, 33.0362], [-117.03135, 33.03618], [-117.0315, 33.03609], [-117.03161, 33.03599], [-117.03171, 33.03587], [-117.03179, 33.03561], [-117.03179, 33.03547], [-117.03175, 33.03535], [-117.03168, 33.0352], [-117.03157, 33.03508], [-117.03066, 33.03436], [-117.03054, 33.03421], [-117.03048, 33.03405], [-117.03071, 33.034], [-117.03078, 33.03386], [-117.0313, 33.03387], [-117.03106, 33.03315], [-117.03106, 33.03288], [-117.03202, 33.03289], [-117.03187, 33.03648], [-117.03222, 33.04407], [-117.03972, 33.04402]]]} | No Public Access 3 | 45249 | City of Poway Open Space | 17327 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 193.801 | City of Poway OS | 0 | Local Recreation Area 3 | 4 | |
3826 | 3826 | 3825 | {"type": "Polygon", "coordinates": [[[-117.046, 33.25229], [-117.0459, 33.25362], [-117.04581, 33.25622], [-117.04584, 33.25988], [-117.04315, 33.25987], [-117.04304, 33.25622], [-117.04149, 33.2562], [-117.04135, 33.25228], [-117.046, 33.25229]]]} | No Public Access 3 | 45243 | Valley Center MWDD Open Space | 26786 | 2321 | Valley Center Water District 689 | Special District 4 | Water District 13 | http://www.vcmwd.org/ | Special District 4 | 2321 | Valley Center Water District 672 | Special District 4 | Water District 13 | San Diego 4 | 70.32 | Valley Ctr. MWDD OS | 0 | Local Recreation Area 3 | 4 | |
3822 | 3822 | 3821 | {"type": "MultiPolygon", "coordinates": [[[[-117.16091, 33.13937], [-117.15846, 33.14101], [-117.15822, 33.14036], [-117.15821, 33.14035], [-117.15831, 33.14084], [-117.1584, 33.14105], [-117.15769, 33.14153], [-117.1577, 33.14159], [-117.15715, 33.14168], [-117.15661, 33.14181], [-117.15656, 33.14167], [-117.15663, 33.14161], [-117.15665, 33.14152], [-117.15663, 33.14145], [-117.15659, 33.14141], [-117.15691, 33.14112], [-117.15709, 33.14098], [-117.15796, 33.14043], [-117.16037, 33.13882], [-117.16091, 33.13937]]], [[[-117.16212, 33.13866], [-117.16175, 33.13905], [-117.16107, 33.13923], [-117.1605, 33.13865], [-117.16073, 33.13857], [-117.1615, 33.13836], [-117.16206, 33.1385], [-117.16212, 33.13866]]]]} | No Public Access 3 | 45235 | San Marcos City Open Space | 24944 | 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 | San Diego 4 | 10.993 | San Marcos City OS | 0 | Local Recreation Area 3 | 4 | |
7817 | 7817 | 7816 | {"type": "Polygon", "coordinates": [[[-117.17922, 33.14242], [-117.17907, 33.14299], [-117.179, 33.1431], [-117.17875, 33.14407], [-117.17743, 33.14475], [-117.17679, 33.14467], [-117.17664, 33.14497], [-117.17557, 33.14511], [-117.1745, 33.14495], [-117.17378, 33.14443], [-117.17724, 33.14084], [-117.17856, 33.14177], [-117.17826, 33.14195], [-117.17847, 33.14217], [-117.17847, 33.14223], [-117.17882, 33.14246], [-117.17913, 33.14233], [-117.17922, 33.14242]]]} | No Public Access 3 | 45233 | Vallecitos Water District Open Space | 26776 | 2170 | Vallecitos Water District 879 | Special District 4 | Water District 13 | http://www.vwd.org/ | Special District 4 | 2170 | Vallecitos Water District 855 | Special District 4 | Water District 13 | San Diego 4 | 32.528 | Vallecitos Water District OS | 0 | Local Recreation Area 3 | 4 | |
14812 | 14812 | 14811 | {"type": "Polygon", "coordinates": [[[-117.16355, 33.32333], [-117.16351, 33.3234], [-117.1635, 33.32347], [-117.16199, 33.32369], [-117.16233, 33.32531], [-117.16102, 33.32539], [-117.1606, 33.32476], [-117.16061, 33.32239], [-117.16165, 33.32151], [-117.16302, 33.32258], [-117.16335, 33.32234], [-117.16355, 33.32333]]]} | No Public Access 3 | 45232 | Rainbow Municipal Water Distrt Open Space | 24086 | 2328 | Rainbow Municipal Water District 1123 | Special District 4 | Water District 13 | http://www.rainbowmwd.com/ | Special District 4 | 2328 | Rainbow Municipal Water District 1078 | Special District 4 | Water District 13 | San Diego 4 | 17.723 | Rainbow Municipal Water Distrt OS | 0 | Local Recreation Area 3 | 4 | |
14757 | 14757 | 14756 | {"type": "MultiPolygon", "coordinates": [[[[-117.08543, 33.22613], [-117.08543, 33.22629], [-117.08327, 33.22627], [-117.08316, 33.22632], [-117.08297, 33.22611], [-117.08291, 33.22611], [-117.08156, 33.22666], [-117.0814, 33.22676], [-117.08134, 33.22684], [-117.08129, 33.22695], [-117.08125, 33.22713], [-117.08129, 33.22768], [-117.08127, 33.22783], [-117.0812, 33.22796], [-117.0811, 33.22805], [-117.08093, 33.22813], [-117.08054, 33.22816], [-117.08033, 33.22821], [-117.07993, 33.22836], [-117.07975, 33.22838], [-117.07957, 33.22839], [-117.07936, 33.22837], [-117.07813, 33.22815], [-117.0768, 33.22785], [-117.07542, 33.22747], [-117.07349, 33.22687], [-117.07315, 33.22673], [-117.07274, 33.22649], [-117.07253, 33.2264], [-117.07253, 33.22601], [-117.07042, 33.22599], [-117.0704, 33.22233], [-117.06955, 33.22231], [-117.06954, 33.22217], [-117.06815, 33.22216], [-117.06808, 33.21864], [-117.07262, 33.21865], [-117.08118, 33.21878], [-117.08117, 33.22244], [-117.08321, 33.22248], [-117.08319, 33.2261], [-117.08543, 33.22613]]], [[[-117.08151, 33.22978], [-117.07891, 33.22974], [-117.07894, 33.22846], [-117.0794, 33.22855], [-117.07975, 33.22855], [-117.08005, 33.2285], [-117.08033, 33.22838], [-117.0805, 33.22834], [-117.08102, 33.22827], [-117.08121, 33.22819], [-117.08136, 33.22805], [-117.08145, 33.22788], [-117.08149, 33.22768], [-117.08154, 33.22811], [-117.08151, 33.22978]]]]} | No Public Access 3 | 45135 | Turner Lake Reservoir | 26585 | 2321 | Valley Center Water District 689 | Special District 4 | Water District 13 | http://www.vcmwd.org/ | Special District 4 | 2321 | Valley Center Water District 672 | Special District 4 | Water District 13 | San Diego 4 | 290.169 | Turner Lake Reservoir | 0 | Local Recreation Area 3 | 4 | |
3798 | 3798 | 3797 | {"type": "MultiPolygon", "coordinates": [[[[-116.9578, 33.32443], [-116.94941, 33.3289], [-116.94271, 33.33233], [-116.93544, 33.32958], [-116.92862, 33.32705], [-116.91095, 33.32034], [-116.90797, 33.31919], [-116.91534, 33.31418], [-116.92002, 33.31102], [-116.92765, 33.31311], [-116.92793, 33.31298], [-116.92835, 33.31273], [-116.92842, 33.31228], [-116.929, 33.31186], [-116.92931, 33.31159], [-116.92979, 33.31131], [-116.93077, 33.311], [-116.93042, 33.31167], [-116.92952, 33.31213], [-116.92917, 33.31283], [-116.92805, 33.31344], [-116.92704, 33.31409], [-116.92582, 33.31491], [-116.92483, 33.31573], [-116.92386, 33.31674], [-116.92361, 33.31727], [-116.92383, 33.31777], [-116.92675, 33.31811], [-116.93088, 33.31862], [-116.93485, 33.318], [-116.93823, 33.31644], [-116.93821, 33.31671], [-116.93823, 33.31709], [-116.9382, 33.31734], [-116.93815, 33.31744], [-116.93808, 33.31751], [-116.93778, 33.31765], [-116.93785, 33.31774], [-116.93818, 33.31759], [-116.93827, 33.31749], [-116.93832, 33.31739], [-116.93836, 33.31715], [-116.93834, 33.31671], [-116.93837, 33.31633], [-116.94031, 33.31541], [-116.94087, 33.31561], [-116.94023, 33.31693], [-116.94024, 33.31695], [-116.94325, 33.31647], [-116.94478, 33.31671], [-116.94578, 33.31681], [-116.94575, 33.31803], [-116.94491, 33.31761], [-116.94483, 33.31757], [-116.94482, 33.31758], [-116.94292, 33.32426], [-116.95073, 33.32383], [-116.9542, 33.32362], [-116.9578, 33.32443]]], [[[-116.92717, 33.31458], [-116.92717, 33.31471], [-116.927, 33.31471], [-116.927, 33.31458], [-116.92717, 33.31458]]]]} | No Public Access 3 | 45133 | YMWD Open Space | 27772 | 2320 | Yuima Municipal Water District 684 | Special District 4 | Water District 13 | http://www.yuimamwd.com/ | Special District 4 | 2320 | Yuima Municipal Water District 675 | Special District 4 | Water District 13 | San Diego 4 | 1090.211 | YMWD OS | 0 | Local Recreation Area 3 | 4 | |
14695 | 14695 | 14694 | {"type": "MultiPolygon", "coordinates": [[[[-121.84325, 39.73187], [-121.84302, 39.73192], [-121.84284, 39.7319], [-121.8422, 39.73193], [-121.84217, 39.73192], [-121.84212, 39.73178], [-121.84229, 39.73181], [-121.84258, 39.7318], [-121.84284, 39.73176], [-121.84292, 39.73172], [-121.8431, 39.73171], [-121.84317, 39.73169], [-121.84325, 39.73187]]], [[[-121.8483, 39.72901], [-121.84825, 39.72906], [-121.84809, 39.72914], [-121.84775, 39.72926], [-121.84745, 39.72934], [-121.84724, 39.72943], [-121.84701, 39.72956], [-121.84693, 39.72964], [-121.84664, 39.73034], [-121.84626, 39.73047], [-121.84533, 39.73053], [-121.8451, 39.73057], [-121.84483, 39.73066], [-121.84461, 39.73079], [-121.84442, 39.73095], [-121.84438, 39.73092], [-121.84423, 39.73115], [-121.84412, 39.73137], [-121.84389, 39.73163], [-121.84382, 39.73172], [-121.84344, 39.73192], [-121.84338, 39.73185], [-121.84331, 39.73187], [-121.84322, 39.73166], [-121.84325, 39.73162], [-121.84348, 39.73146], [-121.84363, 39.73136], [-121.84379, 39.73128], [-121.84391, 39.73119], [-121.84403, 39.73107], [-121.84412, 39.7309], [-121.84423, 39.73057], [-121.84431, 39.73045], [-121.84438, 39.73039], [-121.84469, 39.73023], [-121.84494, 39.73022], [-121.84504, 39.73015], [-121.84512, 39.73011], [-121.8453, 39.73009], [-121.84578, 39.73006], [-121.84608, 39.73008], [-121.84626, 39.73003], [-121.8464, 39.72995], [-121.84652, 39.72982], [-121.84662, 39.72962], [-121.84663, 39.72953], [-121.84673, 39.72936], [-121.8468, 39.72928], [-121.84694, 39.72919], [-121.8472, 39.72907], [-121.84743, 39.72901], [-121.84782, 39.72895], [-121.84786, 39.72891], [-121.84794, 39.72886], [-121.84801, 39.72875], [-121.8483, 39.72901]]], [[[-121.85008, 39.72685], [-121.84992, 39.72697], [-121.84966, 39.72711], [-121.84932, 39.7274], [-121.84909, 39.72756], [-121.84895, 39.72763], [-121.84884, 39.72766], [-121.84868, 39.72775], [-121.8486, 39.72781], [-121.84849, 39.72795], [-121.84844, 39.72805], [-121.84837, 39.72832], [-121.84848, 39.72843], [-121.84856, 39.72859], [-121.8486, 39.72873], [-121.84857, 39.72885], [-121.84847, 39.72892], [-121.848, 39.72838], [-121.84804, 39.72817], [-121.84803, 39.72807], [-121.84809, 39.72795], [-121.84797, 39.72791], [-121.84809, 39.72764], [-121.84834, 39.72746], [-121.84855, 39.72742], [-121.84872, 39.72736], [-121.84919, 39.72713], [-121.84954, 39.72687], [-121.84986, 39.72666], [-121.85008, 39.72685]]], [[[-121.8512, 39.72593], [-121.85116, 39.72596], [-121.85119, 39.72599], [-121.8503, 39.72669], [-121.85018, 39.72659], [-121.8504, 39.72642], [-121.85079, 39.72605], [-121.85108, 39.72583], [-121.8512, 39.72593]]], [[[-121.86328, 39.72721], [-121.86263, 39.72725], [-121.8612, 39.72719], [-121.86002, 39.72711], [-121.85943, 39.72703], [-121.85906, 39.72692], [-121.85858, 39.72666], [-121.85839, 39.7266], [-121.85768, 39.7262], [-121.85723, 39.72585], [-121.85702, 39.7254], [-121.85697, 39.72523], [-121.85686, 39.72523], [-121.8561, 39.72558], [-121.85451, 39.72559], [-121.85403, 39.72573], [-121.85311, 39.72573], [-121.85237, 39.72569], [-121.85169, 39.72575], [-121.85138, 39.72585], [-121.85126, 39.7257], [-121.85142, 39.72564], [-121.85167, 39.72557], [-121.85199, 39.72557], [-121.85202, 39.72548], [-121.85209, 39.72541], [-121.85218, 39.72536], [-121.8523, 39.72534], [-121.85254, 39.72537], [-121.85272, 39.72543], [-121.85293, 39.72553], [-121.85326, 39.72561], [-121.85353, 39.72565], [-121.85371, 39.72566], [-121.85381, 39.72565], [-121.85429, 39.7255], [-121.85471, 39.72544], [-121.85547, 39.7254], [-121.85597, 39.72543], [-121.85597, 39.72537], [-121.85619, 39.72535], [-121.85641, 39.72522], [-121.8565, 39.72518], [-121.85661, 39.72506], [-121.85683, 39.72489], [-121.8569, 39.72487], [-121.85698, 39.72487], [-121.85711, 39.72494], [-121.85721, 39.72502], [-121.85724, 39.72507], [-121.85724, 39.7251], [-121.85727, 39.72514], [-121.85723, 39.72537], [-121.85725, 39.72547], [-121.85729, 39.7256], [-121.85738, 39.72571], [-121.85741, 39.72581], [-121.85746, 39.72584], [-121.85761, 39.72598], [-121.85777, 39.72606], [-121.85814, 39.72618], [-121.8583, 39.72625], [-121.85865, 39.7266], [-121.85876, 39.72669], [-121.85887, 39.72676], [-121.85899, 39.72679], [-121.85929, 39.72684], [-121.85967, 39.72699], [-121.85978, 39.72701], [-121.8607, 39.72698], [-121.86125, 39.72705], [-121.86152, 39.72709], [-121.8623, 39.72711], [-121.86296, 39.72709], [-121.86325, 39.72706], [-121.86328, 39.72721]]], [[[-121.88182, 39.72846], [-121.88181, 39.72884], [-121.88173, 39.72876], [-121.881, 39.72855], [-121.88033, 39.7281], [-121.87939, 39.72783], [-121.87927, 39.72773], [-121.87885, 39.72768], [-121.87833, 39.72773], [-121.87807, 39.72762], [-121.87754, 39.72657], [-121.87719, 39.72646], [-121.87653, 39.72635], [-121.87582, 39.72599], [-121.87462, 39.72552], [-121.87396, 39.72505], [-121.87318, 39.72512], [-121.87248, 39.72505], [-121.87209, 39.72507], [-121.87158, 39.72511], [-121.87086, 39.72494], [-121.87042, 39.72497], [-121.86931, 39.72491], [-121.8688, 39.72496], [-121.86836, 39.72481], [-121.86786, 39.72441], [-121.86763, 39.72442], [-121.86694, 39.72482], [-121.86674, 39.72503], [-121.86566, 39.72545], [-121.86534, 39.7259], [-121.86486, 39.72674], [-121.8647, 39.72681], [-121.86355, 39.72717], [-121.86353, 39.72705], [-121.86366, 39.72704], [-121.86424, 39.72678], [-121.86473, 39.72666], [-121.86483, 39.72657], [-121.86512, 39.72589], [-121.8653, 39.72573], [-121.86558, 39.7253], [-121.86592, 39.72526], [-121.86679, 39.72487], [-121.86725, 39.72445], [-121.86755, 39.72432], [-121.86794, 39.7243], [-121.86842, 39.72471], [-121.86888, 39.72485], [-121.86933, 39.72479], [-121.87007, 39.72482], [-121.87043, 39.72486], [-121.87059, 39.72485], [-121.87108, 39.72475], [-121.8717, 39.72495], [-121.8727, 39.72489], [-121.87293, 39.72492], [-121.87324, 39.72501], [-121.87334, 39.725], [-121.87345, 39.72494], [-121.87383, 39.72484], [-121.87393, 39.72482], [-121.87402, 39.72483], [-121.87417, 39.72495], [-121.87425, 39.72497], [-121.87444, 39.72511], [-121.87462, 39.72521], [-121.87531, 39.72551], [-121.87658, 39.72618], [-121.87676, 39.72623], [-121.877, 39.72624], [-121.87734, 39.72622], [-121.87745, 39.72624], [-121.87752, 39.72628], [-121.87763, 39.7264], [-121.8777, 39.7265], [-121.87776, 39.72665], [-121.8778, 39.72684], [-121.87786, 39.72691], [-121.87798, 39.72694], [-121.87843, 39.72696], [-121.87864, 39.72699], [-121.87871, 39.72704], [-121.87876, 39.72718], [-121.87878, 39.72721], [-121.87892, 39.72736], [-121.87907, 39.72746], [-121.87933, 39.72753], [-121.87953, 39.72761], [-121.87962, 39.72768], [-121.87983, 39.72777], [-121.88016, 39.72782], [-121.8804, 39.72781], [-121.88053, 39.72783], [-121.88074, 39.72795], [-121.88104, 39.72818], [-121.88134, 39.72839], [-121.88165, 39.72846], [-121.88182, 39.72846]]]]} | No Public Access 3 | 45025 | Big Chico Creek Greenway | 28979 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 23.271 | Big Chico Creek Greenway | 0 | Local Recreation Area 3 | 4 | |
13088 | 13088 | 13087 | {"type": "Polygon", "coordinates": [[[-121.82501, 39.71158], [-121.82298, 39.71164], [-121.82226, 39.71162], [-121.82184, 39.71159], [-121.82151, 39.71169], [-121.82076, 39.71183], [-121.82027, 39.71179], [-121.81914, 39.71142], [-121.81785, 39.71191], [-121.81759, 39.7123], [-121.81671, 39.71257], [-121.8152, 39.71355], [-121.81442, 39.71402], [-121.81349, 39.71308], [-121.81331, 39.71295], [-121.81451, 39.7125], [-121.81821, 39.71095], [-121.81822, 39.71093], [-121.81069, 39.70943], [-121.80962, 39.70915], [-121.80952, 39.70889], [-121.81481, 39.71001], [-121.8191, 39.71083], [-121.8205, 39.71111], [-121.82101, 39.7112], [-121.82129, 39.71123], [-121.82187, 39.71057], [-121.82195, 39.71036], [-121.82252, 39.71002], [-121.82267, 39.70976], [-121.82339, 39.70937], [-121.82365, 39.7088], [-121.82408, 39.70921], [-121.824, 39.70943], [-121.82372, 39.70977], [-121.82342, 39.71001], [-121.82306, 39.71036], [-121.82299, 39.71051], [-121.8226, 39.71052], [-121.82242, 39.71075], [-121.82236, 39.7111], [-121.82209, 39.71132], [-121.825, 39.71138], [-121.82501, 39.71158]]]} | No Public Access 3 | 45023 | Comanche Creek Greenway | 28967 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 29.62 | Comanche Creek Greenway | 0 | Local Recreation Area 3 | 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]);