units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
106 rows where ACCESS_TYP = 3 and MNG_AG_TYP = 4 sorted by YR_EST descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_TYP, AGNCY_WEB, MNG_AG_ID, PARK_URL, COUNTY, GAP_STS
DES_TP 21
MNG_AGENCY 8
- East Bay Regional Park District 47
- Midpeninsula Regional Open Space District 19
- Santa Clara Valley Open Space Authority 18
- Sonoma County Agricultural Preservation and Open Space District 11
- Napa County Regional Park and Open Space District 7
- Monterey Peninsula Regional Park District 2
- Marin County Open Space District 1
- Livermore Area Recreation and Park District 1
MNG_AG_TYP 1
- Recreation/Parks District · 106 ✖
MNG_AG_LEV 1 ✖
- Special District 106
ACCESS_TYP 1
- No Public Access · 106 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16432 | 16432 | 16431 | {"type": "MultiPolygon", "coordinates": [[[[-121.96819, 37.97315], [-121.96792, 37.97337], [-121.96771, 37.97352], [-121.96741, 37.97369], [-121.96718, 37.9738], [-121.96144, 37.97591], [-121.96093, 37.97613], [-121.96063, 37.97632], [-121.95394, 37.98082], [-121.95365, 37.98098], [-121.95276, 37.98141], [-121.95259, 37.98152], [-121.95245, 37.98166], [-121.95234, 37.98181], [-121.95228, 37.98197], [-121.95225, 37.98215], [-121.95226, 37.98228], [-121.95229, 37.9824], [-121.95235, 37.98253], [-121.95251, 37.98279], [-121.95259, 37.98316], [-121.95254, 37.98366], [-121.95238, 37.98411], [-121.95187, 37.98476], [-121.95185, 37.98489], [-121.95179, 37.98503], [-121.95175, 37.98523], [-121.95169, 37.98588], [-121.95165, 37.98601], [-121.95162, 37.98632], [-121.95151, 37.98667], [-121.95124, 37.98704], [-121.93914, 37.97988], [-121.93914, 37.9716], [-121.94048, 37.96768], [-121.94552, 37.96345], [-121.94855, 37.96307], [-121.95269, 37.96447], [-121.95349, 37.96501], [-121.95518, 37.96584], [-121.95556, 37.96638], [-121.95649, 37.96675], [-121.95687, 37.96703], [-121.95717, 37.96715], [-121.95749, 37.96718], [-121.95808, 37.96705], [-121.95893, 37.96768], [-121.95921, 37.96766], [-121.95901, 37.96816], [-121.95853, 37.96857], [-121.95853, 37.96858], [-121.96076, 37.97003], [-121.96122, 37.97051], [-121.9639, 37.97284], [-121.96754, 37.973], [-121.96819, 37.97315]]], [[[-121.99781, 38.00868], [-121.9971, 38.01085], [-121.99703, 38.01085], [-121.99695, 38.01109], [-121.99692, 38.0111], [-121.99652, 38.01104], [-121.99628, 38.01104], [-121.99603, 38.01105], [-121.99572, 38.0111], [-121.99549, 38.01116], [-121.99519, 38.01126], [-121.99492, 38.0114], [-121.99474, 38.01152], [-121.99451, 38.01171], [-121.99432, 38.01191], [-121.99303, 38.01354], [-121.99295, 38.01375], [-121.99216, 38.01458], [-121.9904, 38.01478], [-121.98772, 38.01583], [-121.96871, 37.99738], [-121.9514, 37.98714], [-121.95163, 37.98689], [-121.95172, 37.98674], [-121.95179, 37.98658], [-121.95186, 37.98631], [-121.95191, 37.9858], [-121.95193, 37.98573], [-121.95198, 37.98528], [-121.95213, 37.9849], [-121.95238, 37.98472], [-121.95261, 37.98437], [-121.95262, 37.98417], [-121.95272, 37.9839], [-121.95283, 37.98343], [-121.95285, 37.98319], [-121.9528, 37.98294], [-121.95272, 37.98276], [-121.95252, 37.98242], [-121.95247, 37.98227], [-121.95246, 37.98215], [-121.95247, 37.98203], [-121.95255, 37.98185], [-121.95265, 37.98171], [-121.95283, 37.98157], [-121.95376, 37.98112], [-121.95414, 37.9809], [-121.96076, 37.97644], [-121.96103, 37.97628], [-121.96226, 37.97633], [-121.96351, 37.9763], [-121.96527, 37.97638], [-121.96611, 37.97652], [-121.96659, 37.97666], [-121.96688, 37.9768], [-121.96709, 37.97692], [-121.9674, 37.97715], [-121.96801, 37.97774], [-121.96869, 37.97735], [-121.96963, 37.97587], [-121.97008, 37.97606], [-121.97034, 37.97639], [-121.97058, 37.9766], [-121.97089, 37.97697], [-121.97086, 37.97711], [-121.9709, 37.97729], [-121.97111, 37.97754], [-121.97113, 37.9778], [-121.97108, 37.97796], [-121.97081, 37.97796], [-121.97079, 37.97851], [-121.97069, 37.9791], [-121.9717, 37.97942], [-121.97243, 37.97979], [-121.97247, 37.97986], [-121.97214, 37.98039], [-121.97152, 37.98099], [-121.97133, 37.98124], [-121.97113, 37.98165], [-121.97099, 37.98175], [-121.9706, 37.98254], [-121.97055, 37.98271], [-121.97056, 37.98285], [-121.9706, 37.98295], [-121.97068, 37.98308], [-121.97077, 37.98316], [-121.97087, 37.98323], [-121.97099, 37.98328], [-121.97133, 37.98335], [-121.97133, 37.98344], [-121.97136, 37.98351], [-121.97211, 37.98492], [-121.97218, 37.98509], [-121.97235, 37.98519], [-121.97252, 37.98496], [-121.97222, 37.9847], [-121.97157, 37.98348], [-121.97159, 37.98345], [-121.9719, 37.98363], [-121.97219, 37.9837], [-121.97235, 37.98403], [-121.9725, 37.98423], [-121.97266, 37.98437], [-121.97298, 37.98457], [-121.97335, 37.98489], [-121.97365, 37.98547], [-121.97371, 37.98574], [-121.97374, 37.98583], [-121.97395, 37.98608], [-121.97422, 37.98616], [-121.97445, 37.98617], [-121.97457, 37.98615], [-121.97477, 37.98608], [-121.97492, 37.98597], [-121.97496, 37.98602], [-121.97498, 37.98615], [-121.97484, 37.98668], [-121.97495, 37.98683], [-121.97504, 37.98691], [-121.97515, 37.98696], [-121.97563, 37.98712], [-121.97576, 37.98714], [-121.97597, 37.98713], [-121.97618, 37.98705], [-121.97651, 37.98704], [-121.9766, 37.98721], [-121.97703, 37.98766], [-121.97746, 37.98795], [-121.97798, 37.98808], [-121.9786, 37.98814], [-121.97919, 37.98842], [-121.97926, 37.98855], [-121.97969, 37.98883], [-121.97984, 37.98889], [-121.98007, 37.98877], [-121.98013, 37.9887], [-121.98051, 37.98881], [-121.98045, 37.98917], [-121.98047, 37.98928], [-121.9805, 37.98939], [-121.98056, 37.98949], [-121.98064, 37.98958], [-121.98077, 37.98968], [-121.98089, 37.98974], [-121.98111, 37.98981], [-121.98139, 37.98981], [-121.98182, 37.98963], [-121.98222, 37.98972], [-121.98264, 37.99022], [-121.98319, 37.99064], [-121.98302, 37.99113], [-121.98314, 37.99139], [-121.98316, 37.99177], [-121.98324, 37.99202], [-121.98339, 37.9924], [-121.98354, 37.99258], [-121.9837, 37.9927], [-121.98444, 37.99317], [-121.98473, 37.99345], [-121.98495, 37.99387], [-121.9852, 37.99424], [-121.98533, 37.99438], [-121.98554, 37.99452], [-121.98596, 37.99466], [-121.98643, 37.99476], [-121.98666, 37.99477], [-121.98683, 37.99482], [-121.98685, 37.99488], [-121.98695, 37.99481], [-121.98764, 37.99504], [-121.98781, 37.99505], [-121.98809, 37.99502], [-121.98853, 37.99505], [-121.98883, 37.99501], [-121.9878, 37.99775], [-121.98801, 37.99832], [-121.98857, 37.99946], [-121.98924, 38.00038], [-121.98988, 38.00106], [-121.99044, 38.00195], [-121.99085, 38.0025], [-121.99136, 38.00283], [-121.99268, 38.00346], [-121.99264, 38.00375], [-121.99288, 38.00377], [-121.99291, 38.00358], [-121.99364, 38.00396], [-121.99425, 38.00623], [-121.99277, 38.00685], [-121.99226, 38.00758], [-121.9918, 38.00787], [-121.99061, 38.00794], [-121.99012, 38.00769], [-121.98971, 38.00741], [-121.98936, 38.00697], [-121.98873, 38.0065], [-121.98802, 38.00488], [-121.98733, 38.00583], [-121.98926, 38.00726], [-121.98955, 38.00766], [-121.99041, 38.00811], [-121.99115, 38.00821], [-121.99144, 38.00835], [-121.99241, 38.00773], [-121.99342, 38.00749], [-121.99448, 38.00649], [-121.99659, 38.00754], [-121.99756, 38.00863], [-121.99781, 38.00868]], [[-121.98279, 37.99643], [-121.98236, 37.99557], [-121.98228, 37.99546], [-121.98156, 37.99483], [-121.98144, 37.99478], [-121.98052, 37.99451], [-121.98047, 37.99447], [-121.98004, 37.99393], [-121.97969, 37.9925], [-121.97964, 37.99241], [-121.97907, 37.9917], [-121.97873, 37.99046], [-121.97869, 37.99038], [-121.97758, 37.98903], [-121.97562, 37.98747], [-121.97463, 37.98685], [-121.97483, 37.98669], [-121.97483, 37.98667], [-121.97264, 37.98559], [-121.97205, 37.98526], [-121.97197, 37.98536], [-121.97197, 37.98538], [-121.9745, 37.98696], [-121.9745, 37.98698], [-121.97545, 37.98757], [-121.97743, 37.98915], [-121.97853, 37.99051], [-121.97887, 37.99176], [-121.9795, 37.99255], [-121.97982, 37.99391], [-121.97988, 37.99403], [-121.9803, 37.99456], [-121.98038, 37.99463], [-121.98052, 37.99469], [-121.98144, 37.99496], [-121.98212, 37.99557], [-121.98217, 37.99563], [-121.98272, 37.99673], [-121.9852, 37.99886], [-121.98615, 38.00003], [-121.98621, 38.00011], [-121.98684, 38.00138], [-121.98703, 38.00264], [-121.98701, 38.00285], [-121.98716, 38.00363], [-121.9878, 38.00501], [-121.98782, 38.00501], [-121.98795, 38.00483], [-121.98739, 38.00364], [-121.98705, 38.00135], [-121.98639, 38.00002], [-121.98536, 37.99876], [-121.98292, 37.99666], [-121.98288, 37.99662], [-121.98279, 37.99643]]]]} | No Public Access 3 | 49041 | Concord Hills Regional Park | 33747 | 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 | https://www.ebparks.org/parks/concord_hills/ | Contra Costa 12 | 2544.276 | Concord Hills RP | 2019 | Local Park 2 | 4 |
9627 | 9627 | 9626 | {"type": "Polygon", "coordinates": [[[-121.77853, 37.07588], [-121.76509, 37.07542], [-121.76501, 37.07143], [-121.76791, 37.06968], [-121.76826, 37.07015], [-121.76836, 37.07057], [-121.76857, 37.07105], [-121.76854, 37.07122], [-121.76835, 37.07142], [-121.76851, 37.07179], [-121.76829, 37.07195], [-121.76806, 37.07225], [-121.76777, 37.07252], [-121.76769, 37.0727], [-121.76771, 37.07293], [-121.76757, 37.07329], [-121.76764, 37.07378], [-121.76775, 37.07403], [-121.76803, 37.07423], [-121.76821, 37.07467], [-121.76813, 37.0749], [-121.76814, 37.07492], [-121.77093, 37.07339], [-121.77067, 37.07249], [-121.77067, 37.07238], [-121.77158, 37.07239], [-121.77158, 37.07188], [-121.77848, 37.07211], [-121.77853, 37.07588]]]} | No Public Access 3 | 47848 | Croy Redwoods | 31791 | 2142 | Santa Clara Valley Open Space Authority 475 | Special District 4 | Recreation/Parks District 4 | http://www.openspaceauthority.org/ | Special District 4 | 2142 | Santa Clara Valley Open Space Authority 468 | Special District 4 | Recreation/Parks District 4 | Santa Clara 19 | 115.537 | Croy Redwoods | 2018 | None 818 | ||
9628 | 9628 | 9627 | {"type": "Polygon", "coordinates": [[[-122.69582, 38.54625], [-122.69567, 38.54622], [-122.6949, 38.54581], [-122.69432, 38.54576], [-122.69338, 38.54514], [-122.69307, 38.54474], [-122.69284, 38.54396], [-122.69244, 38.5437], [-122.69183, 38.54277], [-122.69113, 38.54204], [-122.69108, 38.54018], [-122.69581, 38.54015], [-122.69582, 38.54625]]]} | No Public Access 3 | 47850 | Wendle Property | 31796 | 2155 | Sonoma County Agricultural Preservation and Open Space District 387 | Special District 4 | Recreation/Parks District 4 | http://www.sonomaopenspace.org/ | Special District 4 | 2155 | Sonoma County Agricultural Preservation and Open Space District 383 | Special District 4 | Recreation/Parks District 4 | Sonoma 16 | 50.237 | Wendle Property | 2018 | Local Other or Unknown 14 | 4 | |
11521 | 11521 | 11520 | {"type": "MultiPolygon", "coordinates": [[[[-121.84156, 37.15629], [-121.82926, 37.15028], [-121.83063, 37.15028], [-121.83065, 37.14667], [-121.83978, 37.1467], [-121.83977, 37.15017], [-121.84132, 37.15017], [-121.84156, 37.15629]]], [[[-121.83961, 37.14302], [-121.83061, 37.14311], [-121.83054, 37.13592], [-121.83954, 37.1359], [-121.83961, 37.14302]]]]} | No Public Access 3 | 48232 | Barrett Canyon | 32789 | 2142 | Santa Clara Valley Open Space Authority 475 | Special District 4 | Recreation/Parks District 4 | http://www.openspaceauthority.org/ | Special District 4 | 2142 | Santa Clara Valley Open Space Authority 468 | Special District 4 | Recreation/Parks District 4 | Santa Clara 19 | 325.464 | Barrett Canyon | 2018 | None 1026 | ||
11522 | 11522 | 11521 | {"type": "Polygon", "coordinates": [[[-121.83058, 37.13955], [-121.82145, 37.13957], [-121.82142, 37.1362], [-121.82286, 37.1362], [-121.82287, 37.13619], [-121.82286, 37.13563], [-121.82141, 37.13563], [-121.82138, 37.13232], [-121.8305, 37.1323], [-121.83058, 37.13955]]]} | No Public Access 3 | 48233 | Punch Bowl | 32790 | 2142 | Santa Clara Valley Open Space Authority 475 | Special District 4 | Recreation/Parks District 4 | http://www.openspaceauthority.org/ | Special District 4 | 2142 | Santa Clara Valley Open Space Authority 468 | Special District 4 | Recreation/Parks District 4 | Santa Clara 19 | 159.196 | Punch Bowl | 2018 | None 1027 | ||
14532 | 14532 | 14531 | {"type": "Polygon", "coordinates": [[[-121.86443, 37.2402], [-121.86348, 37.24014], [-121.86302, 37.23952], [-121.86246, 37.23953], [-121.8623, 37.23942], [-121.86313, 37.23732], [-121.86382, 37.23753], [-121.86443, 37.2402]]]} | No Public Access 3 | 47776 | Santa Teresa Foothills Open Space Preserve | 31575 | 2142 | Santa Clara Valley Open Space Authority 475 | Special District 4 | Recreation/Parks District 4 | http://www.openspaceauthority.org/ | Special District 4 | 2142 | Santa Clara Valley Open Space Authority 468 | Special District 4 | Recreation/Parks District 4 | http://www.openspaceauthority.org | Santa Clara 19 | 8.63 | Santa Teresa Foothills OSP | 2016 | Local Conservation Area 4 | 2 |
2063 | 2063 | 2062 | {"type": "Polygon", "coordinates": [[[-121.72757, 37.22352], [-121.71451, 37.23235], [-121.71451, 37.23236], [-121.7172, 37.23464], [-121.70907, 37.23466], [-121.70896, 37.22768], [-121.68349, 37.20613], [-121.66781, 37.20618], [-121.67335, 37.20336], [-121.6791, 37.20242], [-121.67911, 37.20067], [-121.69238, 37.20067], [-121.70295, 37.20346], [-121.70715, 37.20748], [-121.71486, 37.20753], [-121.71586, 37.20847], [-121.71755, 37.20724], [-121.71888, 37.2083], [-121.72001, 37.20859], [-121.72022, 37.20878], [-121.71982, 37.20964], [-121.71971, 37.21025], [-121.71956, 37.2107], [-121.71982, 37.21106], [-121.71977, 37.21154], [-121.71979, 37.21168], [-121.71983, 37.21181], [-121.7199, 37.21193], [-121.71999, 37.21205], [-121.72039, 37.21246], [-121.72062, 37.21273], [-121.72078, 37.21297], [-121.72108, 37.21354], [-121.72124, 37.21377], [-121.72235, 37.2151], [-121.72259, 37.21534], [-121.72293, 37.21561], [-121.7233, 37.21586], [-121.72358, 37.216], [-121.72322, 37.21628], [-121.72303, 37.21652], [-121.72234, 37.21764], [-121.72235, 37.21797], [-121.72757, 37.22352]]]} | No Public Access 3 | 47761 | Coyote Ridge Open Space Preserve | 31566 | 2142 | Santa Clara Valley Open Space Authority 475 | Special District 4 | Recreation/Parks District 4 | http://www.openspaceauthority.org/ | Special District 4 | 2142 | Santa Clara Valley Open Space Authority 468 | Special District 4 | Recreation/Parks District 4 | http://www.openspaceauthority.org/ | Santa Clara 19 | 1829.785 | Coyote Ridge OSP | 2015 | Local Conservation Area 4 | 2 |
14682 | 14682 | 14681 | {"type": "Polygon", "coordinates": [[[-121.73283, 37.09323], [-121.72762, 37.09334], [-121.72762, 37.09335], [-121.72779, 37.09344], [-121.72688, 37.09352], [-121.72479, 37.09418], [-121.72218, 37.09522], [-121.72074, 37.09564], [-121.72076, 37.09551], [-121.72075, 37.09539], [-121.7207, 37.09519], [-121.71998, 37.09375], [-121.71994, 37.09361], [-121.71989, 37.09333], [-121.71957, 37.09079], [-121.71952, 37.09058], [-121.71945, 37.09043], [-121.71935, 37.09029], [-121.71892, 37.0899], [-121.71937, 37.09002], [-121.71953, 37.08994], [-121.71966, 37.09], [-121.72003, 37.08994], [-121.72003, 37.08993], [-121.71877, 37.08889], [-121.71944, 37.089], [-121.71969, 37.08875], [-121.71998, 37.08876], [-121.72019, 37.08873], [-121.7202, 37.08866], [-121.71899, 37.08787], [-121.72124, 37.08577], [-121.7269, 37.08502], [-121.73219, 37.08446], [-121.73283, 37.09323]]]} | No Public Access 3 | 47764 | Little Uvas Open Space Preserve | 31569 | 2142 | Santa Clara Valley Open Space Authority 475 | Special District 4 | Recreation/Parks District 4 | http://www.openspaceauthority.org/ | Special District 4 | 2142 | Santa Clara Valley Open Space Authority 468 | Special District 4 | Recreation/Parks District 4 | http://www.openspaceauthority.org/ | Santa Clara 19 | 275.426 | Little Uvas OSP | 2014 | Local Conservation Area 4 | 2 |
6036 | 6036 | 6035 | {"type": "Polygon", "coordinates": [[[-122.55459, 38.44131], [-122.55309, 38.44393], [-122.54848, 38.44397], [-122.54843, 38.43733], [-122.55269, 38.43912], [-122.5535, 38.43944], [-122.55459, 38.44131]]]} | No Public Access 3 | 47347 | Auberge Ceanothus Preserve | 31063 | 2155 | Sonoma County Agricultural Preservation and Open Space District 387 | Special District 4 | Recreation/Parks District 4 | http://www.sonomaopenspace.org/ | Special District 4 | 2155 | Sonoma County Agricultural Preservation and Open Space District 383 | Special District 4 | Recreation/Parks District 4 | Sonoma 16 | 71.713 | Auberge Ceanothus Preserve | 2011 | Local Conservation Area 4 | 2 | |
3773 | 3773 | 3772 | {"type": "Polygon", "coordinates": [[[-121.84132, 37.74732], [-121.84129, 37.7523], [-121.8324, 37.75239], [-121.83241, 37.75942], [-121.82329, 37.75956], [-121.82326, 37.75633], [-121.82328, 37.75238], [-121.8206, 37.75236], [-121.84132, 37.74732]]]} | No Public Access 3 | 35010 | Doolan Canyon Regional Preserve | 33749 | 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 | 283.15 | Doolan Canyon RPr | 2010 | Local Conservation Area 4 | 2 | |
13086 | 13086 | 13085 | {"type": "Polygon", "coordinates": [[[-121.8416, 37.74721], [-121.82304, 37.75175], [-121.82343, 37.73824], [-121.83817, 37.73833], [-121.84157, 37.73832], [-121.8416, 37.74721]]]} | No Public Access 3 | 35002 | Doolan Canyon Regional Preserve | 33749 | 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 | 495.161 | Doolan Canyon RPr | 2010 | Local Conservation Area 4 | 2 | |
13125 | 13125 | 13124 | {"type": "MultiPolygon", "coordinates": [[[[-121.66883, 37.12359], [-121.66674, 37.12357], [-121.66651, 37.12332], [-121.66627, 37.12302], [-121.66598, 37.12252], [-121.66553, 37.12198], [-121.6661, 37.12198], [-121.66632, 37.12234], [-121.66624, 37.12237], [-121.66631, 37.12246], [-121.66637, 37.12244], [-121.66821, 37.12247], [-121.66883, 37.12359]]], [[[-121.67204, 37.11703], [-121.66846, 37.11719], [-121.6659, 37.11598], [-121.66581, 37.1145], [-121.67047, 37.11431], [-121.67204, 37.11703]]]]} | No Public Access 3 | 35041 | El Toro Open Space Preserve | 18545 | 2142 | Santa Clara Valley Open Space Authority 475 | Special District 4 | Recreation/Parks District 4 | http://www.openspaceauthority.org/ | Special District 4 | 2142 | Santa Clara Valley Open Space Authority 468 | Special District 4 | Recreation/Parks District 4 | http://www.openspaceauthority.org | Santa Clara 19 | 39.197 | El Toro OSP | 2010 | Local Conservation Area 4 | 2 |
12369 | 12369 | 12368 | {"type": "Polygon", "coordinates": [[[-122.8295, 38.42575], [-122.82842, 38.4255], [-122.82654, 38.42518], [-122.82585, 38.42504], [-122.82581, 38.4245], [-122.82568, 38.4232], [-122.82723, 38.42319], [-122.82787, 38.42348], [-122.82792, 38.42344], [-122.82827, 38.42365], [-122.82852, 38.42382], [-122.82874, 38.42402], [-122.82893, 38.42424], [-122.82918, 38.42458], [-122.82935, 38.42495], [-122.82946, 38.42528], [-122.82949, 38.42548], [-122.8295, 38.42575]]]} | No Public Access 3 | 26071 | Occidental Road Wetlands | 31262 | 2155 | Sonoma County Agricultural Preservation and Open Space District 387 | Special District 4 | Recreation/Parks District 4 | http://www.sonomaopenspace.org/ | Special District 4 | 2155 | Sonoma County Agricultural Preservation and Open Space District 383 | Special District 4 | Recreation/Parks District 4 | Sonoma 16 | 15.729 | Occidental Road Wetlands | 2008 | Local Conservation Area 4 | 2 | |
15810 | 15810 | 15809 | {"type": "Polygon", "coordinates": [[[-121.4899, 37.01609], [-121.48765, 37.01759], [-121.48766, 37.01763], [-121.48324, 37.02135], [-121.47912, 37.02067], [-121.47955, 37.02882], [-121.47239, 37.02894], [-121.47236, 37.02828], [-121.46133, 37.02794], [-121.45596, 37.02863], [-121.45568, 37.02752], [-121.45566, 37.02711], [-121.456, 37.02498], [-121.45623, 37.02402], [-121.45649, 37.02349], [-121.4568, 37.02296], [-121.45744, 37.02235], [-121.45758, 37.02211], [-121.45803, 37.02126], [-121.4584, 37.02019], [-121.45844, 37.02018], [-121.4585, 37.01998], [-121.45919, 37.01959], [-121.46085, 37.01857], [-121.46124, 37.01828], [-121.46182, 37.01791], [-121.46204, 37.01742], [-121.46255, 37.01718], [-121.46268, 37.01678], [-121.46321, 37.01642], [-121.4643, 37.0159], [-121.46485, 37.0156], [-121.46505, 37.01539], [-121.46516, 37.01485], [-121.46495, 37.0145], [-121.46499, 37.01431], [-121.46502, 37.01423], [-121.47221, 37.01421], [-121.47222, 37.01455], [-121.48628, 37.0148], [-121.48629, 37.01479], [-121.48569, 37.01355], [-121.48667, 37.01355], [-121.48727, 37.01407], [-121.48768, 37.0146], [-121.48803, 37.01492], [-121.48856, 37.01515], [-121.48891, 37.01525], [-121.48929, 37.01529], [-121.48965, 37.01548], [-121.4899, 37.01587], [-121.4899, 37.01609]], [[-121.47211, 37.01834], [-121.47194, 37.01832], [-121.47193, 37.01833], [-121.4721, 37.01835], [-121.47211, 37.01834]]]} | No Public Access 3 | 47763 | Diablo Foothills Open Space Preserve | 31568 | 2142 | Santa Clara Valley Open Space Authority 475 | Special District 4 | Recreation/Parks District 4 | http://www.openspaceauthority.org/ | Special District 4 | 2142 | Santa Clara Valley Open Space Authority 468 | Special District 4 | Recreation/Parks District 4 | http://www.openspaceauthority.org/ | Santa Clara 19 | 819.017 | Diablo Foothills OSP | 2007 | Local Conservation Area 4 | 2 |
9975 | 9975 | 9974 | {"type": "Polygon", "coordinates": [[[-122.11034, 37.25814], [-122.1099, 37.25831], [-122.10963, 37.25848], [-122.10956, 37.25855], [-122.10952, 37.25863], [-122.10951, 37.25873], [-122.10953, 37.25882], [-122.10846, 37.25883], [-122.10844, 37.25755], [-122.11032, 37.25756], [-122.11034, 37.25814]]]} | No Public Access 3 | 47967 | Saratoga Gap Open Space Preserve | 31468 | 373 | Santa Clara, County of 941 | County 3 | County Agency 3 | http://www.sccgov.org/sites/scc/Pages/default.aspx | County 3 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org/preserves/pr_saratoga_gap.asp | Santa Clara 19 | 4.827 | Saratoga Gap OSP | 2006 | Local Conservation Area 4 | 2 |
14016 | 14016 | 14015 | {"type": "Polygon", "coordinates": [[[-122.24273, 38.04095], [-122.24052, 38.04205], [-122.23951, 38.04221], [-122.2386, 38.04314], [-122.23869, 38.0438], [-122.23841, 38.0441], [-122.23718, 38.04447], [-122.23672, 38.0448], [-122.23549, 38.04464], [-122.23425, 38.04336], [-122.23416, 38.04336], [-122.23416, 38.03632], [-122.23583, 38.03721], [-122.2362, 38.03709], [-122.23681, 38.03857], [-122.23851, 38.03866], [-122.23956, 38.03929], [-122.24273, 38.04095]]]} | No Public Access 3 | 46991 | Crockett Hills Regional Park | 17828 | 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 | Contra Costa 12 | 91.433 | Crockett Hills RP | 2006 | Local Park 2 | 4 | |
15940 | 15940 | 15939 | {"type": "MultiPolygon", "coordinates": [[[[-122.12327, 37.27902], [-122.11983, 37.27905], [-122.11985, 37.28017], [-122.11975, 37.28018], [-122.11957, 37.28045], [-122.11951, 37.28047], [-122.11949, 37.27906], [-122.1174, 37.27908], [-122.11738, 37.27836], [-122.11932, 37.27566], [-122.11931, 37.27565], [-122.11773, 37.27566], [-122.11686, 37.27688], [-122.11462, 37.2769], [-122.11464, 37.27878], [-122.11403, 37.27863], [-122.11326, 37.27857], [-122.11297, 37.27842], [-122.11296, 37.2785], [-122.1128, 37.27841], [-122.11273, 37.27832], [-122.11269, 37.2783], [-122.11247, 37.27826], [-122.11221, 37.27825], [-122.11199, 37.27817], [-122.11155, 37.2779], [-122.11143, 37.2778], [-122.11134, 37.27769], [-122.11129, 37.27747], [-122.1113, 37.27736], [-122.11124, 37.27721], [-122.11114, 37.27708], [-122.11, 37.27661], [-122.10962, 37.27637], [-122.10916, 37.27605], [-122.10906, 37.27602], [-122.10875, 37.27604], [-122.10859, 37.276], [-122.10844, 37.27593], [-122.10838, 37.27587], [-122.10823, 37.27581], [-122.10791, 37.27555], [-122.10794, 37.27554], [-122.10792, 37.27551], [-122.10687, 37.27479], [-122.10666, 37.27462], [-122.10643, 37.27448], [-122.10595, 37.27426], [-122.10573, 37.27408], [-122.10573, 37.27389], [-122.10571, 37.27374], [-122.10581, 37.27345], [-122.10582, 37.27322], [-122.10546, 37.27286], [-122.10567, 37.27291], [-122.10576, 37.27296], [-122.10581, 37.273], [-122.10583, 37.273], [-122.10581, 37.27195], [-122.10279, 37.27196], [-122.10288, 37.27176], [-122.103, 37.27178], [-122.10326, 37.27174], [-122.10361, 37.27176], [-122.10399, 37.27185], [-122.10402, 37.27175], [-122.10363, 37.27165], [-122.10325, 37.27163], [-122.10299, 37.27167], [-122.10283, 37.27165], [-122.10242, 37.27135], [-122.10214, 37.27123], [-122.10186, 37.27109], [-122.10136, 37.27072], [-122.10109, 37.27055], [-122.10087, 37.27034], [-122.10052, 37.27027], [-122.10031, 37.27017], [-122.09993, 37.26988], [-122.09964, 37.26971], [-122.09936, 37.26949], [-122.09911, 37.26933], [-122.0987, 37.26913], [-122.09823, 37.26929], [-122.09783, 37.26933], [-122.09742, 37.26927], [-122.0971, 37.26913], [-122.09695, 37.26889], [-122.09604, 37.26866], [-122.09574, 37.26865], [-122.09541, 37.26867], [-122.09529, 37.26865], [-122.09519, 37.26856], [-122.09517, 37.26823], [-122.09508, 37.2681], [-122.09527, 37.26819], [-122.09528, 37.26819], [-122.09527, 37.26469], [-122.0996, 37.26465], [-122.09965, 37.26816], [-122.10386, 37.26845], [-122.10387, 37.26844], [-122.10365, 37.26461], [-122.10404, 37.2646], [-122.10404, 37.26591], [-122.10746, 37.26592], [-122.1075, 37.26457], [-122.1128, 37.26451], [-122.11281, 37.265], [-122.11282, 37.26501], [-122.11282, 37.26561], [-122.11294, 37.27187], [-122.12325, 37.27177], [-122.12327, 37.27902]]], [[[-122.11221, 37.25757], [-122.10328, 37.25752], [-122.10342, 37.26073], [-122.10073, 37.26076], [-122.10118, 37.26091], [-122.10241, 37.26141], [-122.10247, 37.26145], [-122.10255, 37.26153], [-122.10259, 37.26163], [-122.10259, 37.26174], [-122.10257, 37.26179], [-122.10251, 37.26189], [-122.10234, 37.26197], [-122.1022, 37.26199], [-122.10207, 37.26198], [-122.10189, 37.26189], [-122.10154, 37.26151], [-122.10134, 37.26133], [-122.1011, 37.26114], [-122.10097, 37.26107], [-122.10082, 37.26105], [-122.10067, 37.26106], [-122.10015, 37.26124], [-122.09992, 37.26126], [-122.09974, 37.26122], [-122.09941, 37.26111], [-122.09921, 37.26102], [-122.09836, 37.26089], [-122.09823, 37.26083], [-122.09785, 37.2606], [-122.09768, 37.26054], [-122.09741, 37.26048], [-122.09723, 37.2604], [-122.09607, 37.2597], [-122.096, 37.25959], [-122.09597, 37.25946], [-122.09598, 37.2594], [-122.09603, 37.25927], [-122.09619, 37.25902], [-122.09622, 37.25891], [-122.0962, 37.2588], [-122.09609, 37.25861], [-122.09555, 37.25805], [-122.09536, 37.25793], [-122.09528, 37.25791], [-122.09527, 37.25745], [-122.09546, 37.2553], [-122.09738, 37.25427], [-122.098, 37.25379], [-122.09924, 37.25377], [-122.09914, 37.25029], [-122.10334, 37.25026], [-122.10326, 37.24757], [-122.1077, 37.24756], [-122.10775, 37.25023], [-122.11215, 37.25021], [-122.11221, 37.25757]]], [[[-122.12203, 37.28043], [-122.1217, 37.28053], [-122.12169, 37.28023], [-122.12186, 37.28019], [-122.12203, 37.2802], [-122.12203, 37.28043]]]]} | No Public Access 3 | 29584 | Saratoga Gap Open Space Preserve | 31468 | 2079 | Midpeninsula Regional Open Space District 366 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org | Special District 4 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org/preserves/pr_saratoga_gap.asp | Santa Clara 19 | 810.535 | Saratoga Gap OSP | 2006 | Local Conservation Area 4 | 2 |
16389 | 16389 | 16388 | {"type": "MultiPolygon", "coordinates": [[[[-122.20638, 38.01749], [-122.20621, 38.02419], [-122.20616, 38.02702], [-122.20355, 38.02723], [-122.20304, 38.02716], [-122.2027, 38.02672], [-122.20245, 38.02661], [-122.20208, 38.02686], [-122.20134, 38.02652], [-122.20093, 38.02625], [-122.20058, 38.02617], [-122.20013, 38.02597], [-122.20004, 38.02581], [-122.19926, 38.02536], [-122.1989, 38.02513], [-122.19747, 38.02393], [-122.19709, 38.02353], [-122.19692, 38.02349], [-122.19606, 38.02274], [-122.19587, 38.02253], [-122.19574, 38.0223], [-122.19564, 38.02206], [-122.19556, 38.02177], [-122.19527, 38.02031], [-122.19525, 38.01987], [-122.19514, 38.01962], [-122.19496, 38.01933], [-122.19475, 38.01906], [-122.19451, 38.01881], [-122.19423, 38.01858], [-122.19392, 38.01838], [-122.19359, 38.0182], [-122.19324, 38.01805], [-122.19243, 38.01784], [-122.19185, 38.01702], [-122.19147, 38.01666], [-122.19332, 38.01552], [-122.19407, 38.01552], [-122.1952, 38.01443], [-122.19616, 38.01447], [-122.19668, 38.01402], [-122.19757, 38.01365], [-122.19853, 38.01341], [-122.19989, 38.01344], [-122.20172, 38.01322], [-122.20191, 38.01327], [-122.20191, 38.01473], [-122.20198, 38.01669], [-122.20398, 38.01753], [-122.20638, 38.01749]]], [[[-122.22137, 38.04928], [-122.22113, 38.05049], [-122.22082, 38.05056], [-122.22056, 38.04994], [-122.22061, 38.04992], [-122.22055, 38.04978], [-122.22049, 38.04978], [-122.2204, 38.04961], [-122.22044, 38.04958], [-122.22035, 38.04944], [-122.22029, 38.04944], [-122.22021, 38.0493], [-122.22025, 38.04927], [-122.22017, 38.04914], [-122.22011, 38.04914], [-122.22002, 38.04899], [-122.22006, 38.04896], [-122.21996, 38.04881], [-122.21955, 38.04854], [-122.21951, 38.04857], [-122.21868, 38.04803], [-122.21887, 38.04766], [-122.21894, 38.04767], [-122.21895, 38.0476], [-122.21906, 38.04738], [-122.21902, 38.04735], [-122.2191, 38.04719], [-122.21915, 38.0472], [-122.21923, 38.04703], [-122.21911, 38.0468], [-122.21837, 38.04654], [-122.21731, 38.04607], [-122.21677, 38.04663], [-122.21508, 38.0466], [-122.2136, 38.04729], [-122.21203, 38.04733], [-122.2113, 38.04732], [-122.21091, 38.04728], [-122.21042, 38.04693], [-122.20974, 38.04631], [-122.20603, 38.04665], [-122.206, 38.04833], [-122.20467, 38.04873], [-122.20443, 38.04868], [-122.2043, 38.04868], [-122.20389, 38.04872], [-122.20372, 38.04869], [-122.20365, 38.04865], [-122.20356, 38.04858], [-122.20352, 38.04852], [-122.2034, 38.04821], [-122.20332, 38.04809], [-122.20212, 38.04857], [-122.2004, 38.04648], [-122.19939, 38.0464], [-122.19775, 38.0467], [-122.19765, 38.04634], [-122.19761, 38.04628], [-122.19749, 38.04619], [-122.19733, 38.04614], [-122.19724, 38.04614], [-122.19715, 38.04616], [-122.19687, 38.04625], [-122.19698, 38.03667], [-122.19695, 38.03607], [-122.2061, 38.03615], [-122.20623, 38.02854], [-122.20708, 38.0289], [-122.21154, 38.0327], [-122.2149, 38.03542], [-122.21536, 38.03592], [-122.21576, 38.03628], [-122.21568, 38.03659], [-122.21534, 38.03679], [-122.21494, 38.03675], [-122.21428, 38.03641], [-122.21377, 38.03606], [-122.2137, 38.03585], [-122.21336, 38.03562], [-122.21263, 38.03525], [-122.21175, 38.03475], [-122.2109, 38.03459], [-122.21001, 38.03483], [-122.20904, 38.03518], [-122.20874, 38.03542], [-122.20858, 38.03566], [-122.20842, 38.03597], [-122.20858, 38.03623], [-122.20847, 38.03701], [-122.20893, 38.03788], [-122.20971, 38.03868], [-122.21037, 38.03893], [-122.21027, 38.03928], [-122.21043, 38.0395], [-122.21075, 38.0395], [-122.211, 38.03933], [-122.21128, 38.03918], [-122.2115, 38.0392], [-122.21312, 38.03998], [-122.21398, 38.04052], [-122.2149, 38.04167], [-122.2154, 38.04176], [-122.21569, 38.04206], [-122.21653, 38.04279], [-122.21742, 38.04344], [-122.21791, 38.04384], [-122.21816, 38.04418], [-122.21852, 38.04448], [-122.21909, 38.04536], [-122.21952, 38.04622], [-122.22007, 38.04715], [-122.22037, 38.04775], [-122.22075, 38.04804], [-122.22085, 38.04819], [-122.2209, 38.04853], [-122.22099, 38.04872], [-122.22137, 38.04928]], [[-122.20721, 38.04117], [-122.20721, 38.04115], [-122.20654, 38.04092], [-122.20609, 38.04101], [-122.20607, 38.04168], [-122.20689, 38.0417], [-122.20721, 38.04117]]], [[[-122.2046, 38.05045], [-122.20372, 38.0521], [-122.20348, 38.05197], [-122.20324, 38.05191], [-122.20306, 38.05184], [-122.2029, 38.05175], [-122.20278, 38.05163], [-122.20268, 38.05149], [-122.20264, 38.05139], [-122.20261, 38.05122], [-122.20259, 38.05105], [-122.2026, 38.05088], [-122.20263, 38.05071], [-122.20271, 38.05049], [-122.2027, 38.05037], [-122.20263, 38.05025], [-122.20251, 38.05016], [-122.20258, 38.04996], [-122.20267, 38.04926], [-122.20297, 38.04875], [-122.2043, 38.0496], [-122.20398, 38.05024], [-122.2046, 38.05045]]], [[[-122.21065, 38.04928], [-122.21015, 38.04989], [-122.20964, 38.04922], [-122.20892, 38.04956], [-122.20964, 38.05051], [-122.20889, 38.05142], [-122.20884, 38.05174], [-122.20883, 38.05166], [-122.20879, 38.05157], [-122.20872, 38.05149], [-122.20866, 38.05145], [-122.20855, 38.05142], [-122.20843, 38.05141], [-122.20835, 38.05142], [-122.20824, 38.05146], [-122.20793, 38.05167], [-122.20778, 38.05181], [-122.20772, 38.05189], [-122.20763, 38.05207], [-122.2075, 38.05253], [-122.20747, 38.05257], [-122.20739, 38.05262], [-122.2073, 38.05264], [-122.207, 38.05261], [-122.2068, 38.05263], [-122.20663, 38.0527], [-122.2061, 38.05307], [-122.20599, 38.05309], [-122.20586, 38.05304], [-122.20536, 38.0524], [-122.20525, 38.05231], [-122.20518, 38.05229], [-122.20507, 38.05227], [-122.20488, 38.0523], [-122.20482, 38.05233], [-122.20474, 38.0524], [-122.20466, 38.05252], [-122.20462, 38.05256], [-122.2045, 38.0526], [-122.20437, 38.0526], [-122.20427, 38.05254], [-122.20375, 38.05212], [-122.20463, 38.05046], [-122.20597, 38.05088], [-122.206, 38.04838], [-122.20895, 38.0484], [-122.21065, 38.04928]]]]} | No Public Access 3 | 28123 | Crockett Hills Regional Park | 17828 | 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 | 901.661 | Crockett Hills RP | 2006 | Local Park 2 | 4 | |
13000 | 13000 | 12999 | {"type": "MultiPolygon", "coordinates": [[[[-121.71268, 37.73312], [-121.71143, 37.73374], [-121.70831, 37.73055], [-121.71165, 37.73057], [-121.71169, 37.73104], [-121.71185, 37.73158], [-121.71268, 37.73312]]], [[[-121.72398, 37.73426], [-121.72395, 37.73788], [-121.71485, 37.73785], [-121.71491, 37.73422], [-121.72398, 37.73426]]]]} | No Public Access 3 | 46947 | Brushy Peak Regional Preserve | 30574 | 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/Page647.aspx?SourceId=1&ArticleId=1520 | Alameda 17 | 96.379 | Brushy Peak RPr | 2005 | Local Conservation Area 4 | 2 |
15889 | 15889 | 15888 | {"type": "MultiPolygon", "coordinates": [[[[-121.81224, 37.1252], [-121.80327, 37.1255], [-121.80324, 37.12146], [-121.81218, 37.12145], [-121.81224, 37.1252]]], [[[-121.82981, 37.11414], [-121.8211, 37.1142], [-121.82099, 37.10693], [-121.82969, 37.10685], [-121.82981, 37.11414]]], [[[-121.83943, 37.12503], [-121.82128, 37.12507], [-121.82116, 37.11783], [-121.83035, 37.11782], [-121.83032, 37.11413], [-121.83482, 37.1141], [-121.83487, 37.119], [-121.83376, 37.11799], [-121.83248, 37.11871], [-121.83399, 37.12056], [-121.83488, 37.12053], [-121.8349, 37.12136], [-121.83939, 37.12134], [-121.83943, 37.12503]]], [[[-121.83954, 37.1359], [-121.83054, 37.13592], [-121.83047, 37.12867], [-121.83947, 37.12865], [-121.83954, 37.1359]]]]} | No Public Access 3 | 47765 | Mount Chual Open Space Preserve | 31570 | 2142 | Santa Clara Valley Open Space Authority 475 | Special District 4 | Recreation/Parks District 4 | http://www.openspaceauthority.org/ | Special District 4 | 2142 | Santa Clara Valley Open Space Authority 468 | Special District 4 | Recreation/Parks District 4 | http://www.openspaceauthority.org | Santa Clara 19 | 711.546 | Mount Chual OSP | 2002 | Local Conservation Area 4 | 2 |
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]);