units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
13 rows where COUNTY = 17, DES_TP = 3 and MNG_AGENCY = 87
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, PARK_URL, LABEL_NAME, YR_EST
ACCESS_TYP 2
MNG_AG_TYP 1
MNG_AGENCY 1
- East Bay Regional Park District · 13 ✖
DES_TP 1
- Local Recreation Area · 13 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
218 | 218 | 217 | {"type": "MultiPolygon", "coordinates": [[[[-122.00283, 37.56787], [-122.00528, 37.56886], [-122.00536, 37.56876], [-122.00637, 37.56915], [-122.00646, 37.56905], [-122.00694, 37.56924], [-122.00841, 37.57037], [-122.00605, 37.57247], [-122.00581, 37.57272], [-122.00563, 37.57245], [-122.00561, 37.57245], [-122.00486, 37.57485], [-122.00167, 37.57418], [-122.00088, 37.57663], [-122.00033, 37.5765], [-121.99656, 37.57363], [-121.99685, 37.57277], [-121.99721, 37.57285], [-121.99723, 37.57284], [-121.99743, 37.56696], [-121.99852, 37.56669], [-121.99871, 37.5667], [-121.9987, 37.56677], [-121.99916, 37.56686], [-121.99961, 37.56698], [-122.00112, 37.56756], [-122.0012, 37.56746], [-122.00224, 37.56786], [-122.00235, 37.56771], [-122.00283, 37.56787]]], [[[-122.00227, 37.57706], [-122.00224, 37.57716], [-122.00227, 37.57718], [-122.00203, 37.57784], [-122.0005, 37.57666], [-122.00227, 37.57706]]], [[[-122.01347, 37.57268], [-122.01183, 37.57446], [-122.01014, 37.57619], [-122.00994, 37.57635], [-122.00973, 37.57651], [-122.00895, 37.57696], [-122.00821, 37.57742], [-122.00796, 37.57759], [-122.0077, 37.57782], [-122.00748, 37.57808], [-122.0073, 37.57835], [-122.00718, 37.57862], [-122.00706, 37.5786], [-122.00686, 37.57917], [-122.00811, 37.57947], [-122.00818, 37.57956], [-122.00772, 37.58092], [-122.00605, 37.58056], [-122.00568, 37.58164], [-122.00418, 37.58051], [-122.00216, 37.57896], [-122.00209, 37.57889], [-122.00203, 37.5788], [-122.00198, 37.57866], [-122.002, 37.57851], [-122.00244, 37.57734], [-122.00248, 37.57728], [-122.00258, 37.57724], [-122.003, 37.57733], [-122.00424, 37.57807], [-122.00588, 37.57674], [-122.00592, 37.57631], [-122.01114, 37.57138], [-122.01347, 37.57268]]]]} | Open Access 1 | 586 | Quarry Lakes Regional Recreation Area | 30594 | 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 | Alameda 17 | 254.616 | Quarry Lakes Reg. Rec. Area | 2001 | Local Recreation Area 3 | 4 | |
6007 | 6007 | 6006 | {"type": "Polygon", "coordinates": [[[-121.85372, 37.67067], [-121.84528, 37.67162], [-121.84527, 37.67159], [-121.83346, 37.67283], [-121.83347, 37.66804], [-121.83003, 37.6675], [-121.83007, 37.66576], [-121.83764, 37.66573], [-121.84017, 37.66573], [-121.84066, 37.66594], [-121.84179, 37.66599], [-121.84221, 37.66575], [-121.84532, 37.66574], [-121.84531, 37.66757], [-121.84781, 37.6683], [-121.84917, 37.6683], [-121.85004, 37.66837], [-121.85104, 37.66906], [-121.85107, 37.66961], [-121.85181, 37.66963], [-121.8524, 37.66936], [-121.85336, 37.66841], [-121.85372, 37.67067]]]} | Open Access 1 | 690 | Shadow Cliffs Regional Recreation Area | 3312 | 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 | http://www.ebparks.org/parks/shadow_cliffs | Alameda 17 | 253.728 | Shadow Cliffs Reg. Rec. Area | 1971 | Local Recreation Area 3 | 4 |
11508 | 11508 | 11507 | {"type": "Polygon", "coordinates": [[[-122.00857, 37.57719], [-122.00838, 37.57734], [-122.00814, 37.57765], [-122.00798, 37.57795], [-122.00791, 37.57818], [-122.00786, 37.57854], [-122.00788, 37.57885], [-122.00793, 37.5791], [-122.0079, 37.57918], [-122.00795, 37.57921], [-122.00802, 37.57938], [-122.00812, 37.57947], [-122.00685, 37.57917], [-122.00706, 37.57859], [-122.00718, 37.57861], [-122.00735, 37.57827], [-122.0076, 37.57793], [-122.00781, 37.57772], [-122.008, 37.57756], [-122.00857, 37.57719]]]} | Open Access 1 | 29555 | Quarry Lakes Regional Recreation Area | 30594 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 2.872 | Quarry Lakes Reg. Rec. Area | 2001 | Local Recreation Area 3 | 4 | |
11576 | 11576 | 11575 | {"type": "Polygon", "coordinates": [[[-122.21582, 37.7497], [-122.2122, 37.75089], [-122.21219, 37.7509], [-122.21281, 37.75156], [-122.21461, 37.75149], [-122.21142, 37.75331], [-122.21104, 37.75277], [-122.21118, 37.75272], [-122.21131, 37.75252], [-122.21132, 37.75241], [-122.21105, 37.75174], [-122.21078, 37.75094], [-122.21108, 37.75075], [-122.21072, 37.75029], [-122.2115, 37.74985], [-122.21127, 37.74958], [-122.21182, 37.74903], [-122.21102, 37.74812], [-122.21109, 37.74794], [-122.2099, 37.74658], [-122.20975, 37.74657], [-122.20956, 37.74634], [-122.20952, 37.74636], [-122.20871, 37.74544], [-122.20851, 37.74554], [-122.20847, 37.7455], [-122.20866, 37.74539], [-122.20866, 37.74538], [-122.20713, 37.74363], [-122.20579, 37.74437], [-122.20566, 37.74422], [-122.20795, 37.74294], [-122.20849, 37.74357], [-122.2085, 37.74356], [-122.20844, 37.74313], [-122.21245, 37.74313], [-122.21582, 37.7497]]]} | Open Access 1 | 23671 | Oakport Field | 23035 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 92.032 | Oakport Field | 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 | |
16638 | 16638 | 16637 | {"type": "MultiPolygon", "coordinates": [[[[-121.68009, 37.56802], [-121.68007, 37.57196], [-121.67069, 37.57206], [-121.67068, 37.57153], [-121.67092, 37.56801], [-121.68009, 37.56802]]], [[[-121.75246, 37.62111], [-121.7509, 37.62112], [-121.74958, 37.62186], [-121.74837, 37.62184], [-121.74806, 37.62246], [-121.74691, 37.62312], [-121.74699, 37.62353], [-121.74526, 37.62599], [-121.74283, 37.62803], [-121.74131, 37.62789], [-121.74099, 37.62211], [-121.73255, 37.62201], [-121.72876, 37.61978], [-121.72583, 37.61775], [-121.72459, 37.61429], [-121.72235, 37.60768], [-121.72202, 37.60661], [-121.71757, 37.60609], [-121.71465, 37.60075], [-121.70746, 37.60051], [-121.70274, 37.60031], [-121.69821, 37.60029], [-121.6969, 37.60016], [-121.69481, 37.60002], [-121.68929, 37.59975], [-121.68806, 37.60524], [-121.68772, 37.60502], [-121.68755, 37.60487], [-121.68735, 37.60465], [-121.68719, 37.60441], [-121.6871, 37.60422], [-121.68703, 37.60403], [-121.68698, 37.60376], [-121.68698, 37.60355], [-121.687, 37.60335], [-121.68705, 37.60315], [-121.68712, 37.60296], [-121.68722, 37.60277], [-121.68734, 37.60259], [-121.68749, 37.60242], [-121.68852, 37.60137], [-121.68868, 37.60116], [-121.68882, 37.60093], [-121.68895, 37.60057], [-121.68905, 37.59996], [-121.68916, 37.59976], [-121.68915, 37.59974], [-121.68908, 37.59974], [-121.68907, 37.59964], [-121.68913, 37.5994], [-121.68924, 37.59917], [-121.68967, 37.59852], [-121.68977, 37.5983], [-121.68982, 37.59812], [-121.68983, 37.59793], [-121.68982, 37.59774], [-121.68977, 37.59756], [-121.68966, 37.59734], [-121.68921, 37.59661], [-121.69368, 37.59664], [-121.69366, 37.59323], [-121.68823, 37.59339], [-121.68825, 37.59314], [-121.68843, 37.59202], [-121.68842, 37.59178], [-121.68836, 37.59155], [-121.68825, 37.59133], [-121.68805, 37.59109], [-121.68789, 37.59095], [-121.68733, 37.59055], [-121.68714, 37.59037], [-121.68705, 37.59023], [-121.68698, 37.59009], [-121.68694, 37.58997], [-121.68691, 37.5898], [-121.68693, 37.58959], [-121.68763, 37.58629], [-121.68796, 37.58607], [-121.68796, 37.58606], [-121.68035, 37.58639], [-121.68036, 37.56411], [-121.6895, 37.56405], [-121.68904, 37.56571], [-121.68899, 37.56577], [-121.69498, 37.56996], [-121.70798, 37.57891], [-121.71095, 37.58324], [-121.71589, 37.5859], [-121.71967, 37.58835], [-121.72581, 37.59067], [-121.73422, 37.59831], [-121.7459, 37.60902], [-121.74736, 37.61049], [-121.74896, 37.61319], [-121.74962, 37.61621], [-121.74793, 37.61702], [-121.74793, 37.61704], [-121.74834, 37.61757], [-121.74891, 37.61788], [-121.75182, 37.61916], [-121.7518, 37.6192], [-121.7515, 37.62024], [-121.75246, 37.62111]], [[-121.74972, 37.62053], [-121.75031, 37.61969], [-121.74918, 37.6192], [-121.7486, 37.62004], [-121.74972, 37.62053]]]]} | Open Access 1 | 47527 | Lake Del Valle State Recreation Area | 31232 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.parks.ca.gov/?page_id=537 | Alameda 17 | 3851.412 | Lake Del Valle SRA | 1967 | Local Recreation Area 3 | 4 |
16835 | 16835 | 16834 | {"type": "Polygon", "coordinates": [[[-122.13351, 37.56302], [-122.13306, 37.56334], [-122.1327, 37.56375], [-122.13236, 37.56416], [-122.132, 37.56456], [-122.13157, 37.56495], [-122.13129, 37.56517], [-122.13101, 37.56552], [-122.13072, 37.56578], [-122.13038, 37.56613], [-122.13007, 37.56649], [-122.12981, 37.56695], [-122.12955, 37.56725], [-122.1289, 37.56823], [-122.12817, 37.56919], [-122.12787, 37.56949], [-122.12739, 37.56984], [-122.12708, 37.57017], [-122.12643, 37.57065], [-122.12634, 37.57073], [-122.12608, 37.57079], [-122.12576, 37.57103], [-122.12531, 37.57134], [-122.12415, 37.57182], [-122.12302, 37.57223], [-122.12227, 37.57238], [-122.1208, 37.57251], [-122.12026, 37.57254], [-122.11951, 37.57253], [-122.1188, 37.57236], [-122.11797, 37.57231], [-122.11684, 37.57204], [-122.1158, 37.57174], [-122.11464, 37.57126], [-122.11255, 37.57048], [-122.11149, 37.57014], [-122.1104, 37.56968], [-122.10985, 37.5695], [-122.10908, 37.56933], [-122.10854, 37.5691], [-122.10833, 37.56859], [-122.10777, 37.56845], [-122.107, 37.56819], [-122.10605, 37.56797], [-122.10518, 37.56774], [-122.10407, 37.56733], [-122.103, 37.56699], [-122.10204, 37.56671], [-122.1011, 37.5664], [-122.1003, 37.56618], [-122.09933, 37.56581], [-122.09831, 37.56551], [-122.09763, 37.56548], [-122.09696, 37.56536], [-122.09637, 37.56506], [-122.09549, 37.56475], [-122.09399, 37.56432], [-122.09177, 37.56363], [-122.0908, 37.56343], [-122.08964, 37.56329], [-122.0887, 37.56308], [-122.08761, 37.56294], [-122.08656, 37.5629], [-122.08475, 37.56261], [-122.08346, 37.56255], [-122.08236, 37.56253], [-122.08137, 37.56237], [-122.08031, 37.5623], [-122.07911, 37.56244], [-122.07799, 37.56254], [-122.07626, 37.56298], [-122.07491, 37.5632], [-122.07417, 37.56324], [-122.07248, 37.56353], [-122.07171, 37.56357], [-122.07097, 37.56376], [-122.06956, 37.5644], [-122.06886, 37.56487], [-122.06814, 37.56559], [-122.06727, 37.56654], [-122.06637, 37.56762], [-122.06566, 37.56848], [-122.06466, 37.56983], [-122.06363, 37.57109], [-122.06254, 37.57226], [-122.06099, 37.57414], [-122.05924, 37.57613], [-122.05817, 37.57731], [-122.05772, 37.57777], [-122.05702, 37.57824], [-122.05597, 37.57882], [-122.05507, 37.57925], [-122.05411, 37.5798], [-122.0533, 37.58059], [-122.05273, 37.58121], [-122.05214, 37.58196], [-122.05161, 37.58256], [-122.05102, 37.58337], [-122.05055, 37.58393], [-122.05003, 37.58472], [-122.04928, 37.5856], [-122.04764, 37.58677], [-122.04704, 37.58703], [-122.04591, 37.58745], [-122.04543, 37.58751], [-122.04491, 37.58765], [-122.04414, 37.5879], [-122.04287, 37.58816], [-122.04178, 37.58825], [-122.04036, 37.58831], [-122.03914, 37.58827], [-122.03812, 37.58815], [-122.03695, 37.58771], [-122.03536, 37.58719], [-122.0337, 37.58661], [-122.03272, 37.58618], [-122.03166, 37.58531], [-122.02989, 37.58361], [-122.02924, 37.58286], [-122.02849, 37.58207], [-122.02727, 37.58085], [-122.02625, 37.57991], [-122.02543, 37.57901], [-122.02443, 37.57806], [-122.02334, 37.57724], [-122.0217, 37.57653], [-122.02073, 37.57608], [-122.02011, 37.57567], [-122.01936, 37.57544], [-122.01811, 37.57498], [-122.01706, 37.57434], [-122.01543, 37.57351], [-122.01497, 37.57323], [-122.0139, 37.57271], [-122.01307, 37.57324], [-122.0138, 37.57248], [-122.01216, 37.57164], [-122.00991, 37.57036], [-122.00094, 37.56685], [-121.9997, 37.56635], [-121.9987, 37.56616], [-121.99784, 37.56612], [-121.99401, 37.56636], [-121.99349, 37.56643], [-121.99308, 37.56651], [-121.99246, 37.56667], [-121.99189, 37.56688], [-121.99133, 37.56712], [-121.99042, 37.5677], [-121.98945, 37.56849], [-121.98921, 37.56879], [-121.98879, 37.56914], [-121.9874, 37.57027], [-121.98649, 37.57103], [-121.98602, 37.57136], [-121.98573, 37.57156], [-121.98545, 37.57169], [-121.98453, 37.57221], [-121.98396, 37.5724], [-121.98328, 37.57253], [-121.9817, 37.57251], [-121.98058, 37.57241], [-121.98039, 37.57296], [-121.9796, 37.5728], [-121.97854, 37.57255], [-121.97635, 37.57235], [-121.97522, 37.57246], [-121.97432, 37.57253], [-121.9736, 37.57271], [-121.97292, 37.57303], [-121.97233, 37.57337], [-121.97199, 37.5737], [-121.9712, 37.57413], [-121.97072, 37.57455], [-121.97053, 37.57496], [-121.97, 37.57556], [-121.96943, 37.57627], [-121.96913, 37.57698], [-121.96901, 37.57734], [-121.96889, 37.57793], [-121.96877, 37.57841], [-121.96762, 37.57849], [-121.96761, 37.57819], [-121.96768, 37.57766], [-121.96779, 37.57725], [-121.96808, 37.5767], [-121.96837, 37.57604], [-121.96872, 37.57535], [-121.96893, 37.57479], [-121.96955, 37.57372], [-121.97004, 37.57332], [-121.97061, 37.57291], [-121.97116, 37.57248], [-121.97206, 37.57213], [-121.97278, 37.57192], [-121.97339, 37.57172], [-121.97436, 37.57146], [-121.97478, 37.57123], [-121.97547, 37.5709], [-121.97647, 37.5707], [-121.97659, 37.57096], [-121.97732, 37.57085], [-121.97776, 37.57088], [-121.97814, 37.57093], [-121.97925, 37.57118], [-121.98007, 37.57142], [-121.98053, 37.57158], [-121.9817, 37.57173], [-121.98211, 37.57174], [-121.98265, 37.57167], [-121.98356, 37.57147], [-121.98429, 37.5712], [-121.98503, 37.57079], [-121.98549, 37.57027], [-121.98586, 37.56994], [-121.98671, 37.56924], [-121.98813, 37.56831], [-121.98897, 37.56765], [-121.9895, 37.56715], [-121.99088, 37.56624], [-121.99193, 37.56588], [-121.99405, 37.56548], [-121.99645, 37.56532], [-121.9975, 37.56538], [-121.99888, 37.56535], [-121.99985, 37.56555], [-122.00039, 37.56569], [-122.00107, 37.56596], [-122.00195, 37.56616], [-122.00267, 37.56649], [-122.00373, 37.5669], [-122.00493, 37.56731], [-122.00632, 37.56793], [-122.00696, 37.56817], [-122.00788, 37.56842], [-122.0085, 37.56874], [-122.00934, 37.56906], [-122.01024, 37.56942], [-122.01111, 37.56973], [-122.01217, 37.57028], [-122.01281, 37.5707], [-122.01314, 37.57098], [-122.01368, 37.57129], [-122.0142, 37.57153], [-122.01457, 37.57177], [-122.01561, 37.57239], [-122.01618, 37.57267], [-122.0168, 37.57304], [-122.01745, 37.57339], [-122.01857, 37.57404], [-122.01909, 37.57424], [-122.01983, 37.57447], [-122.02047, 37.57471], [-122.02095, 37.57498], [-122.02131, 37.57514], [-122.02186, 37.57533], [-122.02313, 37.57586], [-122.02363, 37.57619], [-122.02428, 37.57658], [-122.02474, 37.57697], [-122.02517, 37.5773], [-122.02559, 37.57768], [-122.02708, 37.57916], [-122.02752, 37.57961], [-122.02788, 37.58004], [-122.02878, 37.58097], [-122.02913, 37.58126], [-122.02953, 37.58167], [-122.03019, 37.5824], [-122.03113, 37.58319], [-122.03174, 37.58377], [-122.03209, 37.5843], [-122.03373, 37.58525], [-122.0341, 37.58561], [-122.03538, 37.58605], [-122.03584, 37.58623], [-122.03615, 37.58636], [-122.03742, 37.58668], [-122.03792, 37.58683], [-122.03851, 37.58698], [-122.0393, 37.58715], [-122.03986, 37.58724], [-122.04072, 37.58726], [-122.04129, 37.58721], [-122.04289, 37.58699], [-122.04362, 37.58687], [-122.04416, 37.58674], [-122.04577, 37.58627], [-122.04646, 37.58601], [-122.047, 37.58577], [-122.04728, 37.58549], [-122.04792, 37.58498], [-122.04847, 37.58447], [-122.04947, 37.58344], [-122.05005, 37.58264], [-122.05054, 37.58214], [-122.05063, 37.58183], [-122.05109, 37.58132], [-122.05169, 37.58073], [-122.05227, 37.58018], [-122.05264, 37.57971], [-122.05308, 37.57899], [-122.0538, 37.57868], [-122.05443, 37.5783], [-122.05536, 37.57789], [-122.05631, 37.57721], [-122.057, 37.5766], [-122.05762, 37.57577], [-122.05858, 37.57489], [-122.05969, 37.57334], [-122.06029, 37.57263], [-122.06199, 37.57081], [-122.063, 37.56961], [-122.06438, 37.56762], [-122.06513, 37.56666], [-122.06551, 37.56636], [-122.06608, 37.56568], [-122.06653, 37.56529], [-122.06695, 37.56487], [-122.06717, 37.56456], [-122.06769, 37.56403], [-122.06849, 37.56357], [-122.06898, 37.56325], [-122.06957, 37.56293], [-122.0701, 37.56273], [-122.07155, 37.56229], [-122.07239, 37.56214], [-122.07304, 37.56205], [-122.07525, 37.56163], [-122.07645, 37.56128], [-122.07831, 37.56104], [-122.08075, 37.56064], [-122.08198, 37.5606], [-122.08349, 37.56074], [-122.08572, 37.56107], [-122.08832, 37.56133], [-122.09086, 37.56162], [-122.09238, 37.56198], [-122.09393, 37.56229], [-122.09533, 37.56276], [-122.09669, 37.56304], [-122.09686, 37.5631], [-122.09795, 37.56382], [-122.09927, 37.56422], [-122.10024, 37.56447], [-122.10169, 37.56449], [-122.10339, 37.56498], [-122.10574, 37.5658], [-122.10856, 37.56651], [-122.11091, 37.5675], [-122.11363, 37.56862], [-122.11552, 37.56899], [-122.11774, 37.56978], [-122.11877, 37.57016], [-122.11981, 37.57033], [-122.1216, 37.57], [-122.12346, 37.56932], [-122.12472, 37.56819], [-122.12658, 37.56692], [-122.12784, 37.56588], [-122.12901, 37.56474], [-122.13006, 37.56358], [-122.13084, 37.56281], [-122.13261, 37.56298], [-122.13323, 37.56284], [-122.13351, 37.56302]]]} | Open Access 1 | 3455 | Alameda Creek Regional Trail | 3205 | 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 | http://www.ebparks.org/parks/trails/alameda_creek | Alameda 17 | 667.245 | Alameda Creek Reg. Trail | 1992 | Local Recreation Area 3 | 4 |
16852 | 16852 | 16851 | {"type": "Polygon", "coordinates": [[[-122.06054, 37.71153], [-122.06043, 37.71157], [-122.0603, 37.71167], [-122.06017, 37.71178], [-122.06019, 37.71182], [-122.06007, 37.71189], [-122.06019, 37.7124], [-122.06032, 37.71239], [-122.06038, 37.71255], [-122.06024, 37.71258], [-122.06036, 37.71312], [-122.06053, 37.71317], [-122.0601, 37.71443], [-122.0581, 37.71415], [-122.05794, 37.71437], [-122.0578, 37.71435], [-122.0574, 37.71481], [-122.05788, 37.71593], [-122.05643, 37.71632], [-122.05602, 37.7164], [-122.0559, 37.71652], [-122.05385, 37.71618], [-122.05385, 37.71614], [-122.05389, 37.716], [-122.05378, 37.71565], [-122.05375, 37.71565], [-122.05376, 37.71549], [-122.05383, 37.71522], [-122.05398, 37.71503], [-122.0545, 37.71473], [-122.05467, 37.7146], [-122.0548, 37.71446], [-122.05495, 37.7143], [-122.05504, 37.71406], [-122.05507, 37.71391], [-122.05507, 37.71358], [-122.05504, 37.71326], [-122.05504, 37.71298], [-122.05499, 37.71279], [-122.05499, 37.71255], [-122.05496, 37.71232], [-122.05497, 37.71216], [-122.05505, 37.71182], [-122.05508, 37.71139], [-122.05507, 37.71111], [-122.05478, 37.71026], [-122.05465, 37.70995], [-122.05453, 37.70953], [-122.05449, 37.70925], [-122.05449, 37.70908], [-122.05454, 37.70883], [-122.05467, 37.70849], [-122.05467, 37.70834], [-122.0548, 37.70793], [-122.05491, 37.70744], [-122.05486, 37.70718], [-122.05481, 37.70703], [-122.05475, 37.70686], [-122.05466, 37.70675], [-122.0545, 37.70637], [-122.05446, 37.70615], [-122.05441, 37.70602], [-122.05441, 37.70586], [-122.05443, 37.70571], [-122.05453, 37.70544], [-122.05472, 37.7052], [-122.05496, 37.70468], [-122.05515, 37.70402], [-122.05517, 37.70387], [-122.05687, 37.70404], [-122.05721, 37.7049], [-122.05741, 37.7059], [-122.05671, 37.70631], [-122.05715, 37.70716], [-122.0571, 37.70749], [-122.05861, 37.70765], [-122.05855, 37.7082], [-122.05813, 37.70821], [-122.05771, 37.70818], [-122.05763, 37.70871], [-122.0579, 37.70874], [-122.05791, 37.70878], [-122.05803, 37.7088], [-122.05824, 37.70892], [-122.05839, 37.70898], [-122.05855, 37.70912], [-122.05853, 37.70915], [-122.05849, 37.70913], [-122.0584, 37.70923], [-122.05843, 37.70926], [-122.05789, 37.70988], [-122.05846, 37.71022], [-122.05884, 37.7105], [-122.05906, 37.71074], [-122.05911, 37.71084], [-122.05922, 37.71098], [-122.05924, 37.7111], [-122.05982, 37.71124], [-122.05994, 37.71115], [-122.06051, 37.71121], [-122.06054, 37.71153]]]} | Open Access 1 | 43107 | Cull Canyon Regional Recreation Area | 3247 | 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 | http://www.ebparks.org/parks/cull_canyon | Alameda 17 | 109.685 | Cull Canyon Reg. Rec. Area | 1964 | Local Recreation Area 3 | 4 |
16857 | 16857 | 16856 | {"type": "Polygon", "coordinates": [[[-122.16525, 37.78676], [-122.16506, 37.78688], [-122.16491, 37.78714], [-122.16476, 37.78733], [-122.16457, 37.78752], [-122.16421, 37.78766], [-122.16373, 37.78763], [-122.16354, 37.78767], [-122.1629, 37.78754], [-122.16274, 37.78736], [-122.16258, 37.78761], [-122.16245, 37.78776], [-122.16234, 37.78786], [-122.16203, 37.78835], [-122.16177, 37.78857], [-122.16157, 37.78861], [-122.16137, 37.78923], [-122.16043, 37.78943], [-122.16001, 37.78928], [-122.15824, 37.78893], [-122.15759, 37.78815], [-122.15745, 37.78804], [-122.15629, 37.78755], [-122.15559, 37.78706], [-122.15504, 37.78605], [-122.15448, 37.78564], [-122.15416, 37.78575], [-122.15443, 37.78605], [-122.15217, 37.78722], [-122.15125, 37.78633], [-122.15082, 37.7865], [-122.1481, 37.78385], [-122.14729, 37.78418], [-122.14632, 37.78324], [-122.14717, 37.78258], [-122.14639, 37.78191], [-122.14535, 37.7826], [-122.1441, 37.78144], [-122.14443, 37.78126], [-122.14444, 37.78011], [-122.14421, 37.77962], [-122.14389, 37.77932], [-122.14361, 37.7788], [-122.14269, 37.77805], [-122.14293, 37.77764], [-122.14312, 37.77694], [-122.14214, 37.77641], [-122.14156, 37.77587], [-122.14158, 37.77572], [-122.14071, 37.77463], [-122.14364, 37.77317], [-122.14385, 37.77327], [-122.1436, 37.77386], [-122.14447, 37.77466], [-122.14494, 37.7756], [-122.14548, 37.77601], [-122.14569, 37.77594], [-122.14746, 37.77701], [-122.14792, 37.77762], [-122.14793, 37.77761], [-122.14774, 37.77684], [-122.14723, 37.7765], [-122.14726, 37.77641], [-122.14726, 37.77617], [-122.14639, 37.77551], [-122.14603, 37.77537], [-122.14643, 37.77506], [-122.14682, 37.77504], [-122.14742, 37.77574], [-122.15095, 37.77612], [-122.15046, 37.77682], [-122.15219, 37.77819], [-122.15346, 37.77871], [-122.15343, 37.77878], [-122.15164, 37.78013], [-122.15253, 37.78086], [-122.15355, 37.78118], [-122.15398, 37.78099], [-122.15464, 37.78148], [-122.1556, 37.78194], [-122.1555, 37.78278], [-122.15631, 37.78297], [-122.15682, 37.78317], [-122.15727, 37.78351], [-122.1581, 37.78461], [-122.15869, 37.784], [-122.1589, 37.78419], [-122.15953, 37.78446], [-122.16022, 37.78487], [-122.16076, 37.78526], [-122.16109, 37.78562], [-122.16157, 37.78596], [-122.16184, 37.7862], [-122.16259, 37.78645], [-122.16331, 37.78679], [-122.16337, 37.78696], [-122.1634, 37.78749], [-122.16382, 37.78749], [-122.16415, 37.78742], [-122.16454, 37.78728], [-122.16467, 37.78702], [-122.16473, 37.78683], [-122.16519, 37.78661], [-122.16525, 37.78676]]]} | Open Access 1 | 17344 | Leona Heights Regional Open Space | 3282 | 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 | http://www.ebparks.org/parks/leona | Alameda 17 | 297.093 | Leona Heights Reg. OS | 1986 | Local Recreation Area 3 | 4 |
16858 | 16858 | 16857 | {"type": "MultiPolygon", "coordinates": [[[[-121.98493, 37.5708], [-121.98481, 37.57087], [-121.98262, 37.57146], [-121.98203, 37.57131], [-121.98023, 37.57119], [-121.97789, 37.57078], [-121.9779, 37.5707], [-121.97775, 37.57068], [-121.97773, 37.57078], [-121.977, 37.57083], [-121.97696, 37.57073], [-121.98405, 37.56827], [-121.98493, 37.5708]]], [[[-121.99743, 37.56696], [-121.99723, 37.57285], [-121.99477, 37.57234], [-121.99378, 37.57157], [-121.99365, 37.57126], [-121.99304, 37.57095], [-121.99247, 37.57058], [-121.99015, 37.56877], [-121.99037, 37.56856], [-121.99004, 37.56832], [-121.99026, 37.56812], [-121.99056, 37.56788], [-121.99081, 37.56771], [-121.99114, 37.56752], [-121.9911, 37.56747], [-121.99154, 37.56722], [-121.99207, 37.56699], [-121.99205, 37.56693], [-121.99208, 37.56692], [-121.99227, 37.56709], [-121.99486, 37.56652], [-121.99505, 37.56755], [-121.99743, 37.56696]]], [[[-121.99115, 37.57124], [-121.991, 37.57166], [-121.99084, 37.57163], [-121.99073, 37.57183], [-121.99048, 37.5721], [-121.99009, 37.57282], [-121.98985, 37.57304], [-121.98934, 37.57292], [-121.98923, 37.57292], [-121.98838, 37.57274], [-121.98724, 37.5731], [-121.98639, 37.57303], [-121.98538, 37.57299], [-121.9853, 37.57301], [-121.98483, 37.5721], [-121.98514, 37.57196], [-121.98552, 37.57177], [-121.98587, 37.57157], [-121.98621, 37.57134], [-121.98653, 37.5711], [-121.98856, 37.56942], [-121.99115, 37.57124]]], [[[-122.01114, 37.57138], [-122.00593, 37.5763], [-122.00588, 37.57674], [-122.00424, 37.57807], [-122.003, 37.57733], [-122.00399, 37.57753], [-122.00402, 37.57742], [-122.00241, 37.57709], [-122.00243, 37.57698], [-122.00088, 37.57663], [-122.00167, 37.57417], [-122.00486, 37.57485], [-122.00562, 37.57243], [-122.00581, 37.57271], [-122.00605, 37.57247], [-122.00876, 37.57006], [-122.01114, 37.57138]]]]} | Open Access 1 | 46968 | Quarry Lakes Regional Recreation Area | 30594 | 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 | 204.467 | Quarry Lakes Reg. Rec. Area | 2001 | Local Recreation Area 3 | 4 | |
16861 | 16861 | 16860 | {"type": "Polygon", "coordinates": [[[-122.23423, 37.84806], [-122.23387, 37.84811], [-122.23133, 37.84855], [-122.23093, 37.84854], [-122.23092, 37.84849], [-122.23072, 37.84844], [-122.23046, 37.84833], [-122.22978, 37.84732], [-122.22937, 37.84681], [-122.2272, 37.84436], [-122.22702, 37.84396], [-122.22653, 37.84358], [-122.22626, 37.84324], [-122.22763, 37.84318], [-122.22763, 37.84316], [-122.22741, 37.843], [-122.22768, 37.84299], [-122.2279, 37.84337], [-122.22902, 37.8442], [-122.22949, 37.84395], [-122.23023, 37.84486], [-122.23105, 37.84504], [-122.23144, 37.84543], [-122.23117, 37.8456], [-122.23142, 37.84586], [-122.23376, 37.84711], [-122.2341, 37.84738], [-122.23415, 37.84776], [-122.23423, 37.84806]]]} | Open Access 1 | 1433 | Temescal Regional Recreation Area | 26233 | 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 | Alameda 17 | 38.546 | Temescal Reg. Rec. Area | 1936 | Local Recreation Area 3 | 4 | |
16864 | 16864 | 16863 | {"type": "MultiPolygon", "coordinates": [[[[-122.0584, 37.72949], [-122.05756, 37.72994], [-122.05711, 37.7304], [-122.05695, 37.73082], [-122.05697, 37.73149], [-122.05711, 37.73173], [-122.05651, 37.73213], [-122.05596, 37.73273], [-122.05588, 37.73327], [-122.05611, 37.73362], [-122.05153, 37.73277], [-122.05151, 37.73254], [-122.05146, 37.73241], [-122.05134, 37.73217], [-122.05116, 37.7319], [-122.05095, 37.73149], [-122.05095, 37.73138], [-122.05102, 37.7312], [-122.05116, 37.73105], [-122.05124, 37.73094], [-122.05128, 37.73076], [-122.05127, 37.73027], [-122.05131, 37.73012], [-122.05149, 37.72987], [-122.05164, 37.72972], [-122.05182, 37.72958], [-122.05206, 37.72933], [-122.05215, 37.72921], [-122.0523, 37.72893], [-122.05227, 37.72871], [-122.05216, 37.72828], [-122.05215, 37.72812], [-122.05216, 37.728], [-122.05221, 37.72786], [-122.05227, 37.72782], [-122.05224, 37.72773], [-122.05227, 37.72757], [-122.0524, 37.72727], [-122.05243, 37.72712], [-122.05243, 37.72684], [-122.0524, 37.72669], [-122.05217, 37.7262], [-122.05208, 37.72588], [-122.05206, 37.72575], [-122.05208, 37.72561], [-122.05206, 37.72545], [-122.05209, 37.72517], [-122.05208, 37.72489], [-122.05203, 37.72443], [-122.05198, 37.72426], [-122.05193, 37.72387], [-122.05192, 37.72366], [-122.05198, 37.72344], [-122.05206, 37.72332], [-122.05218, 37.72325], [-122.05227, 37.72307], [-122.0524, 37.72291], [-122.05276, 37.72232], [-122.05309, 37.72159], [-122.05344, 37.72061], [-122.05363, 37.7199], [-122.05385, 37.71914], [-122.05391, 37.71901], [-122.05395, 37.71878], [-122.05393, 37.71867], [-122.05395, 37.71855], [-122.05396, 37.71836], [-122.05412, 37.71801], [-122.05428, 37.71772], [-122.05428, 37.71748], [-122.05426, 37.71736], [-122.05404, 37.71695], [-122.05396, 37.71684], [-122.05388, 37.71659], [-122.05385, 37.71647], [-122.05385, 37.71618], [-122.0559, 37.71652], [-122.05547, 37.71699], [-122.05608, 37.71786], [-122.05547, 37.71815], [-122.05684, 37.72014], [-122.05642, 37.72051], [-122.05628, 37.722], [-122.05645, 37.72212], [-122.05645, 37.72222], [-122.05726, 37.72286], [-122.0576, 37.72411], [-122.05735, 37.7244], [-122.05726, 37.72432], [-122.0571, 37.7242], [-122.05681, 37.72404], [-122.05663, 37.72398], [-122.05648, 37.72397], [-122.05634, 37.72394], [-122.05602, 37.72396], [-122.05596, 37.72399], [-122.05581, 37.72398], [-122.05544, 37.72452], [-122.0554, 37.72496], [-122.05572, 37.72534], [-122.05606, 37.72545], [-122.0574, 37.72649], [-122.05731, 37.72704], [-122.05716, 37.72713], [-122.05728, 37.72726], [-122.05726, 37.72737], [-122.057, 37.72753], [-122.05702, 37.72767], [-122.05825, 37.72891], [-122.05833, 37.72907], [-122.0584, 37.72949]]], [[[-122.06542, 37.72054], [-122.0654, 37.72096], [-122.06534, 37.72128], [-122.06506, 37.7223], [-122.06455, 37.72316], [-122.06456, 37.72317], [-122.06447, 37.72443], [-122.06427, 37.72563], [-122.06277, 37.73329], [-122.06164, 37.73527], [-122.0615, 37.73677], [-122.06103, 37.73876], [-122.05812, 37.7351], [-122.05844, 37.73494], [-122.05835, 37.7345], [-122.05929, 37.73498], [-122.06011, 37.73458], [-122.06077, 37.73415], [-122.06095, 37.7338], [-122.06111, 37.73371], [-122.06191, 37.73334], [-122.06174, 37.73312], [-122.06178, 37.73309], [-122.06135, 37.73234], [-122.06151, 37.73229], [-122.06155, 37.7318], [-122.0608, 37.73048], [-122.06077, 37.73048], [-122.06075, 37.73045], [-122.06043, 37.7305], [-122.0599, 37.73053], [-122.05982, 37.73028], [-122.0598, 37.7301], [-122.06009, 37.72989], [-122.06059, 37.72963], [-122.06069, 37.72943], [-122.06054, 37.72924], [-122.06042, 37.72903], [-122.06065, 37.72872], [-122.0608, 37.72861], [-122.06144, 37.72907], [-122.06173, 37.72895], [-122.06234, 37.72862], [-122.06262, 37.72843], [-122.06281, 37.72824], [-122.06289, 37.72811], [-122.06293, 37.72799], [-122.06291, 37.72798], [-122.06282, 37.72807], [-122.06241, 37.7268], [-122.06174, 37.72609], [-122.06212, 37.72514], [-122.06172, 37.72455], [-122.06176, 37.72453], [-122.06176, 37.72451], [-122.0612, 37.72441], [-122.06174, 37.72444], [-122.06265, 37.724], [-122.06262, 37.72394], [-122.06222, 37.72347], [-122.06226, 37.72343], [-122.06218, 37.72332], [-122.06246, 37.72329], [-122.06268, 37.72312], [-122.06267, 37.72327], [-122.06431, 37.72316], [-122.06484, 37.7208], [-122.06484, 37.72078], [-122.06479, 37.72078], [-122.06487, 37.72049], [-122.06491, 37.72049], [-122.06492, 37.72052], [-122.06542, 37.72054]]]]} | Open Access 1 | 15150 | Cull Canyon Regional Recreation Area | 3247 | 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 | http://www.ebparks.org/parks/cull_canyon | Alameda 17 | 245.944 | Cull Canyon Reg. Rec. Area | 1964 | Local Recreation Area 3 | 4 |
16865 | 16865 | 16864 | {"type": "Polygon", "coordinates": [[[-122.05729, 37.69054], [-122.05732, 37.69085], [-122.05729, 37.69148], [-122.05633, 37.69209], [-122.05634, 37.6921], [-122.05717, 37.69218], [-122.05717, 37.69221], [-122.05697, 37.6922], [-122.05678, 37.69223], [-122.05659, 37.69231], [-122.05652, 37.6924], [-122.05651, 37.69247], [-122.05681, 37.69276], [-122.05683, 37.69285], [-122.054, 37.69283], [-122.05267, 37.69268], [-122.05186, 37.69251], [-122.05066, 37.6925], [-122.04958, 37.69254], [-122.04867, 37.69261], [-122.04792, 37.69283], [-122.04737, 37.69305], [-122.04695, 37.69323], [-122.04462, 37.69495], [-122.04445, 37.69518], [-122.0443, 37.69495], [-122.04441, 37.69486], [-122.0444, 37.69484], [-122.04436, 37.69484], [-122.04435, 37.69471], [-122.04447, 37.69457], [-122.04474, 37.69442], [-122.04516, 37.69407], [-122.04494, 37.69362], [-122.04498, 37.69344], [-122.04451, 37.69339], [-122.0444, 37.69311], [-122.04449, 37.69281], [-122.04454, 37.69281], [-122.04455, 37.6928], [-122.04437, 37.69253], [-122.04448, 37.69232], [-122.04501, 37.69184], [-122.0468, 37.69227], [-122.04681, 37.69226], [-122.04649, 37.69079], [-122.04436, 37.68999], [-122.0459, 37.68885], [-122.04634, 37.68978], [-122.04766, 37.69015], [-122.04857, 37.69003], [-122.04902, 37.69009], [-122.04925, 37.69005], [-122.04971, 37.68979], [-122.0496, 37.68951], [-122.05131, 37.68901], [-122.05114, 37.68863], [-122.05124, 37.68858], [-122.05202, 37.69024], [-122.0525, 37.69017], [-122.05276, 37.68967], [-122.05267, 37.6895], [-122.05299, 37.6894], [-122.05313, 37.68929], [-122.05364, 37.68902], [-122.05376, 37.68926], [-122.05485, 37.68961], [-122.05486, 37.6896], [-122.05485, 37.68952], [-122.05486, 37.68945], [-122.05493, 37.68947], [-122.05512, 37.68946], [-122.05515, 37.6897], [-122.05513, 37.6897], [-122.05511, 37.68989], [-122.0562, 37.68985], [-122.05698, 37.69056], [-122.05729, 37.69054]]]} | Open Access 1 | 49046 | Don Castro Regional Recreation Area | 18199 | 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 | https://www.ebparks.org/parks/don_castro/ | Alameda 17 | 91.383 | Don Castro Reg. Rec. Area | 1969 | 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]);