units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
40 rows where DES_TP = 4 and MNG_AGENCY = 87 sorted by PARK_URL
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, PARK_URL, COUNTY, LABEL_NAME, YR_EST
ACCESS_TYP 3
MNG_AG_TYP 1
MNG_AGENCY 1
- East Bay Regional Park District · 40 ✖
DES_TP 1
- Local Conservation Area · 40 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3486 | 3486 | 3485 | {"type": "Polygon", "coordinates": [[[-122.04254, 37.69324], [-122.04258, 37.69353], [-122.04254, 37.69359], [-122.04245, 37.69363], [-122.04168, 37.69356], [-122.04021, 37.69367], [-122.04031, 37.69501], [-122.0398, 37.6962], [-122.03857, 37.69573], [-122.03373, 37.69642], [-122.03244, 37.69557], [-122.0294, 37.69336], [-122.02923, 37.6932], [-122.02911, 37.69298], [-122.02965, 37.69307], [-122.03009, 37.6934], [-122.03051, 37.69331], [-122.03084, 37.69344], [-122.03097, 37.69365], [-122.03108, 37.69367], [-122.03129, 37.69369], [-122.03163, 37.69355], [-122.03186, 37.69322], [-122.03235, 37.69309], [-122.03281, 37.69308], [-122.03302, 37.69322], [-122.03334, 37.69316], [-122.03333, 37.69293], [-122.03356, 37.69289], [-122.03402, 37.69255], [-122.03407, 37.69237], [-122.03435, 37.69371], [-122.04, 37.69298], [-122.04254, 37.69324]]]} | No Public Access 3 | 46879 | Chabot - Garin Trail Corridor | 30360 | 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 | 63.522 | Chabot - Garin Trail Corridor | 0 | Local Conservation Area 4 | 2 | |
3558 | 3558 | 3557 | {"type": "Polygon", "coordinates": [[[-122.34141, 37.899], [-122.33912, 37.89903], [-122.33911, 37.89846], [-122.3414, 37.89842], [-122.34141, 37.899]]]} | No Public Access 3 | 15364 | Brooks Island Regional Preserve | 31524 | 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 | 3.177 | Brooks Island RPr | 0 | 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 | |
4034 | 4034 | 4033 | {"type": "Polygon", "coordinates": [[[-121.91611, 37.5378], [-121.91556, 37.53803], [-121.91495, 37.53842], [-121.91451, 37.53888], [-121.91415, 37.53911], [-121.91397, 37.53932], [-121.91364, 37.53952], [-121.91302, 37.53939], [-121.91255, 37.53955], [-121.91174, 37.53993], [-121.91138, 37.54002], [-121.90953, 37.54067], [-121.90916, 37.54088], [-121.90818, 37.54109], [-121.90735, 37.54153], [-121.90688, 37.54203], [-121.90661, 37.54204], [-121.90612, 37.5403], [-121.90456, 37.5375], [-121.90418, 37.53666], [-121.90346, 37.53544], [-121.89974, 37.52963], [-121.89885, 37.5284], [-121.89859, 37.52788], [-121.8989, 37.52754], [-121.8994, 37.52728], [-121.90004, 37.52698], [-121.90089, 37.52646], [-121.90117, 37.52558], [-121.90143, 37.52518], [-121.90186, 37.52478], [-121.90249, 37.5246], [-121.90397, 37.52429], [-121.90517, 37.52427], [-121.9059, 37.52461], [-121.90612, 37.52479], [-121.90738, 37.52603], [-121.90881, 37.52554], [-121.90905, 37.52543], [-121.91005, 37.52485], [-121.91163, 37.52391], [-121.9122, 37.52617], [-121.91243, 37.52617], [-121.91252, 37.52614], [-121.91258, 37.52614], [-121.91266, 37.52619], [-121.91269, 37.52626], [-121.91271, 37.52705], [-121.91275, 37.52708], [-121.913, 37.52708], [-121.913, 37.52723], [-121.91273, 37.52724], [-121.91262, 37.5274], [-121.91263, 37.52745], [-121.91233, 37.52727], [-121.91199, 37.52714], [-121.91133, 37.52703], [-121.91108, 37.52705], [-121.91012, 37.52766], [-121.90997, 37.52829], [-121.91015, 37.52879], [-121.9104, 37.52907], [-121.91043, 37.52907], [-121.91051, 37.52939], [-121.91046, 37.52995], [-121.91009, 37.53017], [-121.90941, 37.53032], [-121.90902, 37.53037], [-121.90894, 37.53044], [-121.90888, 37.5306], [-121.90889, 37.53065], [-121.90906, 37.53091], [-121.90922, 37.53108], [-121.90935, 37.53128], [-121.91138, 37.53258], [-121.91098, 37.53266], [-121.91084, 37.53271], [-121.91022, 37.53305], [-121.91019, 37.53309], [-121.91019, 37.53315], [-121.91021, 37.53319], [-121.9103, 37.53326], [-121.91041, 37.53328], [-121.91051, 37.53332], [-121.91079, 37.53351], [-121.91131, 37.53334], [-121.91171, 37.53472], [-121.91254, 37.53694], [-121.91321, 37.53668], [-121.91405, 37.53642], [-121.91406, 37.5364], [-121.91547, 37.53595], [-121.91611, 37.5378]]]} | No Public Access 3 | 46970 | Mission Peak Regional Preserve | 30597 | 235 | Desert and Mountain Conservation Authority 713 | State 5 | State Agency 5 | http://www.dmca.ca.gov/ | Other State 5 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 374.957 | Mission Peak RPr | 0 | Local Conservation Area 4 | 2 | |
4940 | 4940 | 4939 | {"type": "Polygon", "coordinates": [[[-122.02404, 37.66917], [-122.02383, 37.66911], [-122.02395, 37.66891], [-122.02396, 37.66892], [-122.02404, 37.66917]]]} | Restricted Access 2 | 10715 | Chabot - Garin Trail Corridor | 17108 | 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 | 0.064 | Chabot - Garin Trail Corridor | 0 | 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 | |
14182 | 14182 | 14181 | {"type": "Polygon", "coordinates": [[[-122.3732, 37.97143], [-122.37282, 37.97158], [-122.37227, 37.97224], [-122.37225, 37.97251], [-122.37217, 37.97255], [-122.37148, 37.97255], [-122.37238, 37.97143], [-122.3732, 37.97143]]]} | No Public Access 3 | 43103 | North Richmond Wetlands | 22856 | 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 | 1.61 | North Richmond Wetlands | 0 | Local Conservation Area 4 | 2 | |
16269 | 16269 | 16268 | {"type": "MultiPolygon", "coordinates": [[[[-122.09309, 38.02548], [-122.09136, 38.02546], [-122.09051, 38.02486], [-122.09062, 38.02432], [-122.08536, 38.02144], [-122.08566, 38.02128], [-122.0859, 38.02156], [-122.08606, 38.0217], [-122.08625, 38.02183], [-122.09209, 38.02504], [-122.09258, 38.02528], [-122.09309, 38.02548]]], [[[-122.10178, 38.0258], [-122.1017, 38.02577], [-122.10165, 38.02573], [-122.10163, 38.02568], [-122.10162, 38.02559], [-122.10158, 38.02548], [-122.10152, 38.02539], [-122.10144, 38.02532], [-122.1013, 38.02524], [-122.10114, 38.0252], [-122.10092, 38.02521], [-122.09939, 38.02551], [-122.09913, 38.02553], [-122.09901, 38.02556], [-122.09877, 38.02564], [-122.09733, 38.02593], [-122.09693, 38.02598], [-122.09652, 38.02601], [-122.09612, 38.026], [-122.09571, 38.02596], [-122.09526, 38.02587], [-122.0948, 38.02548], [-122.09377, 38.02548], [-122.09361, 38.02543], [-122.09306, 38.02526], [-122.09255, 38.02504], [-122.09223, 38.02488], [-122.0865, 38.02174], [-122.08632, 38.02164], [-122.08616, 38.02151], [-122.08602, 38.02138], [-122.08585, 38.02118], [-122.08806, 38.01999], [-122.08699, 38.01876], [-122.09154, 38.01629], [-122.09512, 38.01871], [-122.09553, 38.01872], [-122.09605, 38.01912], [-122.09656, 38.01944], [-122.0965, 38.01951], [-122.09651, 38.01952], [-122.09753, 38.01999], [-122.09921, 38.02059], [-122.10033, 38.02104], [-122.0982, 38.02414], [-122.09867, 38.02459], [-122.09877, 38.02479], [-122.09884, 38.025], [-122.09887, 38.02504], [-122.09893, 38.02508], [-122.09911, 38.02513], [-122.09926, 38.0252], [-122.09944, 38.02536], [-122.10088, 38.02507], [-122.10105, 38.02506], [-122.10121, 38.02507], [-122.10135, 38.02511], [-122.10148, 38.02517], [-122.10159, 38.02525], [-122.10168, 38.02534], [-122.10176, 38.02551], [-122.10178, 38.0258]]], [[[-122.09837, 38.02591], [-122.09824, 38.02609], [-122.09819, 38.02618], [-122.09814, 38.02637], [-122.09587, 38.02682], [-122.09605, 38.02653], [-122.09558, 38.02613], [-122.09599, 38.02619], [-122.09639, 38.0262], [-122.0968, 38.02619], [-122.0972, 38.02614], [-122.09837, 38.02591]]], [[[-122.10098, 38.02539], [-122.10105, 38.02539], [-122.10118, 38.0254], [-122.10131, 38.02548], [-122.10136, 38.02557], [-122.10137, 38.02563], [-122.10137, 38.02568], [-122.10134, 38.02573], [-122.10129, 38.02577], [-122.10122, 38.02579], [-122.10037, 38.02562], [-122.0999, 38.02561], [-122.10098, 38.02539]]]]} | No Public Access 3 | 731 | Waterbird Regional Preserve | 27298 | 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 | 198.259 | Waterbird RPr | 2002 | Local Conservation Area 4 | 2 | |
16270 | 16270 | 16269 | {"type": "Polygon", "coordinates": [[[-121.91452, 37.94328], [-121.91433, 37.94326], [-121.91403, 37.94329], [-121.91378, 37.94337], [-121.91358, 37.94352], [-121.91169, 37.9458], [-121.91149, 37.94602], [-121.91126, 37.94623], [-121.9109, 37.94647], [-121.90846, 37.94792], [-121.9083, 37.94799], [-121.9081, 37.94802], [-121.90712, 37.94792], [-121.90565, 37.94808], [-121.9056, 37.9463], [-121.89632, 37.94622], [-121.89127, 37.94621], [-121.874, 37.94627], [-121.87386, 37.93899], [-121.85005, 37.93907], [-121.85002, 37.93628], [-121.85002, 37.93555], [-121.85001, 37.93554], [-121.85002, 37.93212], [-121.83951, 37.93209], [-121.83948, 37.92876], [-121.84076, 37.92773], [-121.84342, 37.92548], [-121.84341, 37.92547], [-121.84077, 37.92548], [-121.84078, 37.92186], [-121.85003, 37.92186], [-121.85004, 37.92545], [-121.85465, 37.92543], [-121.85462, 37.91102], [-121.85877, 37.91102], [-121.85869, 37.90353], [-121.85857, 37.89987], [-121.85981, 37.89987], [-121.8615, 37.89983], [-121.86173, 37.89994], [-121.86195, 37.90003], [-121.86219, 37.90009], [-121.86243, 37.90014], [-121.86266, 37.90016], [-121.86341, 37.9002], [-121.86447, 37.90019], [-121.8646, 37.9002], [-121.86484, 37.90025], [-121.86495, 37.90028], [-121.86697, 37.90116], [-121.86731, 37.90136], [-121.8684, 37.90211], [-121.86861, 37.90219], [-121.8692, 37.90235], [-121.86943, 37.90243], [-121.86964, 37.90253], [-121.87109, 37.90329], [-121.8713, 37.90343], [-121.87147, 37.90359], [-121.87196, 37.9042], [-121.87221, 37.90443], [-121.87248, 37.90464], [-121.87338, 37.90526], [-121.87358, 37.90542], [-121.87376, 37.90559], [-121.87391, 37.90578], [-121.87424, 37.90634], [-121.87446, 37.90658], [-121.87473, 37.90677], [-121.87577, 37.90731], [-121.87593, 37.90743], [-121.87601, 37.90753], [-121.87607, 37.9077], [-121.87608, 37.9078], [-121.87605, 37.90815], [-121.87607, 37.90828], [-121.87613, 37.9084], [-121.87627, 37.90855], [-121.8764, 37.90863], [-121.8765, 37.90868], [-121.87771, 37.90908], [-121.87801, 37.9092], [-121.87848, 37.90948], [-121.87914, 37.9102], [-121.87984, 37.9108], [-121.88036, 37.91122], [-121.88068, 37.9114], [-121.88136, 37.9117], [-121.88151, 37.91179], [-121.88198, 37.91213], [-121.8822, 37.91223], [-121.88232, 37.91226], [-121.88256, 37.9123], [-121.88272, 37.91231], [-121.88432, 37.91228], [-121.88452, 37.9123], [-121.8849, 37.91239], [-121.88525, 37.91254], [-121.88547, 37.91269], [-121.88546, 37.91272], [-121.88586, 37.91304], [-121.88587, 37.91315], [-121.88641, 37.91359], [-121.88637, 37.91363], [-121.88662, 37.91383], [-121.887, 37.91447], [-121.88594, 37.91482], [-121.88618, 37.92153], [-121.87675, 37.92163], [-121.87674, 37.92534], [-121.89497, 37.92517], [-121.89614, 37.93219], [-121.91442, 37.93215], [-121.91445, 37.93618], [-121.91452, 37.94328]]]} | No Public Access 3 | 13078 | Clayton Ranch Regional Preserve | 30627 | 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 | 4131.029 | Clayton Ranch RPr | 0 | Local Conservation Area 4 | 2 | |
16272 | 16272 | 16271 | {"type": "MultiPolygon", "coordinates": [[[[-121.8323, 37.81744], [-121.82307, 37.81755], [-121.8232, 37.82443], [-121.80977, 37.82434], [-121.80523, 37.82419], [-121.80526, 37.81714], [-121.80523, 37.81543], [-121.80528, 37.81019], [-121.83217, 37.81014], [-121.8323, 37.81744]], [[-121.80846, 37.81457], [-121.80845, 37.81456], [-121.80822, 37.81452], [-121.80818, 37.81463], [-121.80843, 37.81468], [-121.80846, 37.81457]]], [[[-121.85021, 37.86746], [-121.84095, 37.86747], [-121.84101, 37.85307], [-121.83203, 37.85309], [-121.83213, 37.84579], [-121.83744, 37.84582], [-121.83761, 37.84596], [-121.83898, 37.84662], [-121.8394, 37.84711], [-121.83988, 37.84728], [-121.84104, 37.84817], [-121.84102, 37.8522], [-121.84124, 37.85225], [-121.8415, 37.85221], [-121.84169, 37.85221], [-121.84234, 37.85232], [-121.84254, 37.85233], [-121.84323, 37.8523], [-121.84334, 37.85227], [-121.84347, 37.85217], [-121.84361, 37.8521], [-121.84378, 37.85207], [-121.84402, 37.8521], [-121.84402, 37.85305], [-121.84787, 37.85304], [-121.84831, 37.85382], [-121.84841, 37.85495], [-121.84864, 37.85614], [-121.84892, 37.85712], [-121.8487, 37.85785], [-121.84901, 37.85876], [-121.84923, 37.85928], [-121.84982, 37.85981], [-121.84977, 37.86039], [-121.84995, 37.86064], [-121.84495, 37.86065], [-121.84503, 37.86318], [-121.8502, 37.86446], [-121.85021, 37.86746]]], [[[-121.84407, 37.84584], [-121.84404, 37.84923], [-121.84326, 37.84904], [-121.84251, 37.8487], [-121.84199, 37.8483], [-121.84122, 37.84808], [-121.84104, 37.84794], [-121.84104, 37.84649], [-121.83937, 37.84678], [-121.83913, 37.8465], [-121.83771, 37.84582], [-121.84407, 37.84584]]], [[[-121.85936, 37.86025], [-121.85019, 37.86026], [-121.85018, 37.85755], [-121.84893, 37.85755], [-121.84906, 37.8571], [-121.84878, 37.85614], [-121.84855, 37.85494], [-121.84845, 37.8538], [-121.84803, 37.85304], [-121.85092, 37.85302], [-121.85932, 37.853], [-121.85936, 37.86025]]]]} | No Public Access 3 | 29629 | Morgan Territory Regional Preserve | 22488 | 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 | 1385.441 | Morgan Territory RPr | 1975 | Local Conservation Area 4 | 2 | |
16275 | 16275 | 16274 | {"type": "Polygon", "coordinates": [[[-121.70305, 37.80995], [-121.70228, 37.80996], [-121.70228, 37.8138], [-121.70217, 37.81544], [-121.69737, 37.81188], [-121.69619, 37.81188], [-121.69618, 37.80997], [-121.69597, 37.80998], [-121.69595, 37.81134], [-121.69246, 37.81133], [-121.69231, 37.81105], [-121.69219, 37.81049], [-121.69215, 37.8104], [-121.69205, 37.81029], [-121.69172, 37.81009], [-121.69158, 37.80993], [-121.69153, 37.80989], [-121.69077, 37.80964], [-121.69067, 37.80963], [-121.69038, 37.80966], [-121.69025, 37.80969], [-121.69012, 37.80976], [-121.68984, 37.81006], [-121.68859, 37.80936], [-121.68849, 37.80894], [-121.68823, 37.80872], [-121.6869, 37.80815], [-121.68663, 37.80811], [-121.68639, 37.8082], [-121.68613, 37.80842], [-121.68569, 37.80872], [-121.68496, 37.80892], [-121.6842, 37.80889], [-121.68397, 37.80881], [-121.68178, 37.80814], [-121.6813, 37.80808], [-121.68029, 37.80828], [-121.67977, 37.80807], [-121.67968, 37.80764], [-121.68001, 37.80704], [-121.67996, 37.80685], [-121.67925, 37.80627], [-121.67892, 37.80629], [-121.678, 37.80698], [-121.67785, 37.80755], [-121.67689, 37.80772], [-121.67609, 37.8078], [-121.67572, 37.80766], [-121.67541, 37.80729], [-121.6751, 37.80698], [-121.67445, 37.80668], [-121.67429, 37.8064], [-121.67422, 37.80609], [-121.67438, 37.80564], [-121.67497, 37.80511], [-121.67539, 37.80335], [-121.67556, 37.80299], [-121.6757, 37.80256], [-121.67577, 37.80226], [-121.67581, 37.80197], [-121.67583, 37.8007], [-121.67592, 37.80004], [-121.67621, 37.79988], [-121.6761, 37.79964], [-121.67632, 37.79925], [-121.67685, 37.79862], [-121.67709, 37.79847], [-121.67819, 37.79809], [-121.68181, 37.79776], [-121.68233, 37.79749], [-121.68253, 37.79729], [-121.68296, 37.79701], [-121.68353, 37.79696], [-121.68502, 37.7972], [-121.6863, 37.7961], [-121.68737, 37.79489], [-121.68959, 37.79371], [-121.68963, 37.79366], [-121.69001, 37.79362], [-121.69006, 37.79365], [-121.69094, 37.7936], [-121.69142, 37.7931], [-121.69228, 37.79309], [-121.69245, 37.79302], [-121.69248, 37.79734], [-121.69593, 37.79734], [-121.69595, 37.80358], [-121.70305, 37.80995]]]} | Restricted Access 2 | 47727 | Vasco Caves Regional Preserve | 31516 | 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 | 718.817 | Vasco Caves RPr | 1997 | Local Conservation Area 4 | 2 | |
16287 | 16287 | 16286 | {"type": "Polygon", "coordinates": [[[-122.22124, 37.86457], [-122.22068, 37.86515], [-122.21997, 37.86481], [-122.21728, 37.86206], [-122.21756, 37.8619], [-122.21817, 37.86235], [-122.21846, 37.86264], [-122.21904, 37.86315], [-122.21933, 37.86325], [-122.21963, 37.86351], [-122.22001, 37.86389], [-122.22037, 37.86416], [-122.22067, 37.86434], [-122.22124, 37.86457]]]} | Open Access 1 | 22015 | Claremont Canyon Regional Preserve | 17381 | 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 | 6.337 | Claremont Canyon RPr | 1985 | Local Conservation Area 4 | 2 | |
16288 | 16288 | 16287 | {"type": "Polygon", "coordinates": [[[-122.35803, 37.90099], [-122.35788, 37.9011], [-122.35775, 37.90094], [-122.35773, 37.90094], [-122.35775, 37.90181], [-122.35294, 37.90189], [-122.35282, 37.89694], [-122.35278, 37.8969], [-122.35261, 37.89649], [-122.35227, 37.89631], [-122.352, 37.89603], [-122.35174, 37.89554], [-122.35149, 37.89464], [-122.35146, 37.89464], [-122.35081, 37.89382], [-122.35107, 37.89355], [-122.35136, 37.8937], [-122.35141, 37.89407], [-122.35191, 37.89435], [-122.35246, 37.8945], [-122.35306, 37.89475], [-122.35457, 37.89471], [-122.35471, 37.89435], [-122.3563, 37.89461], [-122.35659, 37.89494], [-122.35687, 37.8949], [-122.35717, 37.89509], [-122.35742, 37.89558], [-122.3575, 37.89591], [-122.35721, 37.89654], [-122.35737, 37.89693], [-122.35716, 37.89727], [-122.35749, 37.89766], [-122.35772, 37.89812], [-122.35737, 37.89887], [-122.3572, 37.89912], [-122.3574, 37.8997], [-122.3576, 37.90062], [-122.35781, 37.9007], [-122.35803, 37.90099]]]} | Restricted Access 2 | 25299 | Brooks Island Regional Preserve | 31525 | 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 | 85.832 | Brooks Island RPr | 0 | Local Conservation Area 4 | 2 | |
16292 | 16292 | 16291 | {"type": "MultiPolygon", "coordinates": [[[[-121.67806, 37.79522], [-121.67803, 37.79746], [-121.67656, 37.7979], [-121.67616, 37.79857], [-121.67612, 37.79859], [-121.67597, 37.79878], [-121.6754, 37.7997], [-121.67492, 37.80009], [-121.67541, 37.80039], [-121.67538, 37.80065], [-121.67536, 37.80197], [-121.67532, 37.80224], [-121.67526, 37.80251], [-121.67517, 37.80278], [-121.67506, 37.80304], [-121.6748, 37.80351], [-121.67451, 37.80389], [-121.67258, 37.8059], [-121.67234, 37.80613], [-121.67208, 37.80635], [-121.6718, 37.80655], [-121.67145, 37.80676], [-121.67056, 37.80724], [-121.6694, 37.80781], [-121.66898, 37.80786], [-121.66769, 37.80896], [-121.66685, 37.80846], [-121.66602, 37.80903], [-121.66557, 37.80902], [-121.6654, 37.80925], [-121.66545, 37.81035], [-121.6652, 37.81067], [-121.66313, 37.8119], [-121.66159, 37.81407], [-121.66136, 37.81479], [-121.66138, 37.81545], [-121.6597, 37.81654], [-121.65071, 37.81652], [-121.65068, 37.8092], [-121.65067, 37.80919], [-121.64118, 37.80928], [-121.64132, 37.81849], [-121.64125, 37.81861], [-121.64123, 37.81872], [-121.64125, 37.82008], [-121.63212, 37.82017], [-121.63206, 37.81663], [-121.62298, 37.81671], [-121.62296, 37.81534], [-121.62287, 37.81524], [-121.62277, 37.80946], [-121.64117, 37.80928], [-121.64107, 37.80217], [-121.65063, 37.80208], [-121.65066, 37.79507], [-121.65956, 37.7951], [-121.65957, 37.79539], [-121.66106, 37.79539], [-121.67806, 37.79522]]], [[[-121.6549, 37.82518], [-121.65508, 37.82781], [-121.65506, 37.82809], [-121.65507, 37.82849], [-121.65505, 37.82891], [-121.65501, 37.82933], [-121.65491, 37.82988], [-121.65484, 37.83016], [-121.65435, 37.83148], [-121.65402, 37.83287], [-121.65386, 37.83332], [-121.65364, 37.83375], [-121.65339, 37.8341], [-121.65267, 37.8344], [-121.65286, 37.8347], [-121.65276, 37.83481], [-121.65226, 37.83516], [-121.65176, 37.83543], [-121.64933, 37.83643], [-121.649, 37.83659], [-121.64869, 37.83677], [-121.64825, 37.83706], [-121.64785, 37.83739], [-121.64749, 37.83775], [-121.6472, 37.83812], [-121.64171, 37.83818], [-121.6416, 37.83149], [-121.64187, 37.83108], [-121.64172, 37.8305], [-121.64159, 37.83019], [-121.64159, 37.82926], [-121.65076, 37.82923], [-121.65072, 37.82378], [-121.65482, 37.82378], [-121.65485, 37.82477], [-121.65487, 37.82489], [-121.65488, 37.82517], [-121.6549, 37.82518]]]]} | No Public Access 3 | 29412 | Byron Vernal Pools Regional Preserve | 31517 | 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 | 1863.721 | Byron Vernal Pools RPr | 0 | Local Conservation Area 4 | 2 | |
16294 | 16294 | 16293 | {"type": "MultiPolygon", "coordinates": [[[[-121.6472, 37.83812], [-121.64695, 37.83853], [-121.64675, 37.83896], [-121.64661, 37.83941], [-121.64653, 37.83986], [-121.64644, 37.84114], [-121.64636, 37.84347], [-121.64651, 37.84454], [-121.6465, 37.84475], [-121.64634, 37.84558], [-121.64166, 37.84563], [-121.64162, 37.83824], [-121.6417, 37.83823], [-121.64171, 37.83818], [-121.6472, 37.83812]]], [[[-121.70874, 37.81939], [-121.70702, 37.81946], [-121.70141, 37.82264], [-121.70141, 37.82368], [-121.70253, 37.82482], [-121.70252, 37.82763], [-121.67806, 37.82763], [-121.66808, 37.82748], [-121.66808, 37.8311], [-121.67427, 37.83118], [-121.68342, 37.8352], [-121.68343, 37.83846], [-121.69015, 37.83851], [-121.69015, 37.84072], [-121.68992, 37.84072], [-121.68753, 37.84246], [-121.68753, 37.84567], [-121.67812, 37.84561], [-121.67811, 37.84926], [-121.68753, 37.84928], [-121.68753, 37.85098], [-121.68287, 37.8529], [-121.67813, 37.85291], [-121.65983, 37.8528], [-121.65987, 37.84544], [-121.65982, 37.83823], [-121.65356, 37.83817], [-121.6536, 37.84551], [-121.64702, 37.84558], [-121.64695, 37.84481], [-121.64696, 37.84457], [-121.64713, 37.84381], [-121.647, 37.84264], [-121.64702, 37.84173], [-121.6472, 37.84018], [-121.64723, 37.83987], [-121.6473, 37.83948], [-121.64743, 37.83909], [-121.64761, 37.83872], [-121.64787, 37.8383], [-121.64922, 37.83699], [-121.65187, 37.83588], [-121.65228, 37.83569], [-121.65259, 37.83551], [-121.65289, 37.83532], [-121.65369, 37.83472], [-121.65375, 37.83466], [-121.65411, 37.83421], [-121.65429, 37.83394], [-121.65442, 37.83371], [-121.655, 37.83291], [-121.65536, 37.83121], [-121.65581, 37.83041], [-121.65561, 37.83029], [-121.65538, 37.83025], [-121.65541, 37.83012], [-121.65608, 37.83012], [-121.65648, 37.82914], [-121.65977, 37.82913], [-121.65971, 37.81784], [-121.66021, 37.81761], [-121.66163, 37.81657], [-121.66219, 37.81576], [-121.66287, 37.81326], [-121.66299, 37.8131], [-121.66416, 37.8128], [-121.6647, 37.81229], [-121.66503, 37.8121], [-121.66584, 37.81148], [-121.66612, 37.81111], [-121.66658, 37.81084], [-121.66706, 37.81048], [-121.66743, 37.81013], [-121.66824, 37.80925], [-121.66851, 37.80898], [-121.66887, 37.80869], [-121.66913, 37.80852], [-121.66941, 37.80835], [-121.67107, 37.80805], [-121.67207, 37.80767], [-121.67254, 37.80801], [-121.67326, 37.80765], [-121.67492, 37.80766], [-121.67644, 37.8081], [-121.67691, 37.80771], [-121.67785, 37.80755], [-121.678, 37.80698], [-121.67892, 37.80629], [-121.67925, 37.80627], [-121.67996, 37.80685], [-121.68002, 37.80704], [-121.67968, 37.80764], [-121.67977, 37.80806], [-121.68029, 37.80828], [-121.6813, 37.80808], [-121.68178, 37.80814], [-121.68397, 37.80881], [-121.6842, 37.80889], [-121.68496, 37.80892], [-121.68569, 37.80872], [-121.68613, 37.80842], [-121.68639, 37.8082], [-121.68663, 37.80811], [-121.6869, 37.80815], [-121.68823, 37.80872], [-121.68849, 37.80894], [-121.68859, 37.80936], [-121.68983, 37.81006], [-121.69012, 37.80976], [-121.69025, 37.80969], [-121.69038, 37.80966], [-121.69067, 37.80963], [-121.69077, 37.80964], [-121.69153, 37.80989], [-121.69158, 37.80993], [-121.69172, 37.81009], [-121.69205, 37.81029], [-121.69215, 37.8104], [-121.69219, 37.81049], [-121.69231, 37.81106], [-121.69247, 37.81133], [-121.69594, 37.81134], [-121.69597, 37.80997], [-121.69618, 37.80997], [-121.69619, 37.81188], [-121.69737, 37.81188], [-121.70217, 37.81544], [-121.70532, 37.81749], [-121.70821, 37.81724], [-121.70874, 37.81939]]]]} | No Public Access 3 | 46989 | Vasco Hills Regional Preserve | 30625 | 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 | 3499.978 | Vasco Hills RPr | 0 | Local Conservation Area 4 | 2 | |
16624 | 16624 | 16623 | {"type": "Polygon", "coordinates": [[[-121.87428, 37.53505], [-121.87423, 37.5359], [-121.87414, 37.53845], [-121.87396, 37.54089], [-121.87396, 37.54203], [-121.8701, 37.54196], [-121.86955, 37.54176], [-121.86885, 37.5417], [-121.86885, 37.54142], [-121.86879, 37.54132], [-121.86353, 37.54128], [-121.8583, 37.54118], [-121.85764, 37.54027], [-121.85813, 37.53995], [-121.8586, 37.53948], [-121.85881, 37.53898], [-121.85889, 37.53895], [-121.85897, 37.53881], [-121.85912, 37.53863], [-121.85894, 37.53812], [-121.85795, 37.53698], [-121.85796, 37.53576], [-121.8569, 37.53481], [-121.8564, 37.53431], [-121.85545, 37.53365], [-121.85473, 37.53091], [-121.85356, 37.53043], [-121.85308, 37.53044], [-121.85304, 37.53025], [-121.85296, 37.53001], [-121.85259, 37.52957], [-121.85242, 37.52932], [-121.85221, 37.52907], [-121.85197, 37.52883], [-121.85173, 37.52861], [-121.85152, 37.52838], [-121.85112, 37.52787], [-121.8504, 37.52725], [-121.85003, 37.52682], [-121.84984, 37.52663], [-121.84971, 37.52644], [-121.84964, 37.52623], [-121.84954, 37.526], [-121.849, 37.52561], [-121.84881, 37.52536], [-121.84845, 37.52483], [-121.84831, 37.52456], [-121.84807, 37.524], [-121.84798, 37.52372], [-121.84791, 37.52344], [-121.84793, 37.52314], [-121.8479, 37.52282], [-121.84795, 37.52218], [-121.84789, 37.52187], [-121.84773, 37.52161], [-121.84769, 37.52139], [-121.84782, 37.5212], [-121.84802, 37.52104], [-121.86052, 37.52093], [-121.8695, 37.5209], [-121.86968, 37.535], [-121.87428, 37.53505]]]} | No Public Access 3 | 46962 | Sunol Regional Wilderness | 30582 | 321 | San Francisco - Public Utilities Commission, City and County of 31 | County 3 | County Agency - Other 9 | http://sfwater.org/ | County 3 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 864.645 | Sunol Reg. Wilderness | 1962 | Local Conservation Area 4 | 2 | |
16663 | 16663 | 16662 | {"type": "MultiPolygon", "coordinates": [[[[-121.71852, 37.51173], [-121.70991, 37.5118], [-121.70994, 37.51904], [-121.70083, 37.51921], [-121.70032, 37.50454], [-121.71847, 37.50456], [-121.71852, 37.51173]]], [[[-121.7275, 37.52604], [-121.72747, 37.53491], [-121.71859, 37.53497], [-121.71856, 37.51888], [-121.72291, 37.51887], [-121.72294, 37.52605], [-121.7275, 37.52604]]], [[[-121.79134, 37.51904], [-121.79112, 37.52629], [-121.79108, 37.53558], [-121.79025, 37.5356], [-121.77904, 37.53529], [-121.77395, 37.52985], [-121.77096, 37.53506], [-121.77056, 37.54979], [-121.75292, 37.54967], [-121.75275, 37.53519], [-121.73628, 37.53508], [-121.73649, 37.51935], [-121.75448, 37.51942], [-121.77329, 37.51942], [-121.79134, 37.51904]]], [[[-121.75469, 37.50453], [-121.75448, 37.51217], [-121.74546, 37.51221], [-121.7455, 37.50444], [-121.75108, 37.50451], [-121.75469, 37.50453]]]]} | No Public Access 3 | 46973 | Ohlone Regional Wilderness | 30605 | 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 | 3606.6 | Ohlone Reg. Wilderness | 0 | Local Conservation Area 4 | 2 | |
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 |
15878 | 15878 | 15877 | {"type": "Polygon", "coordinates": [[[-121.98852, 37.75987], [-121.98834, 37.75984], [-121.9883, 37.7598], [-121.98824, 37.75977], [-121.98812, 37.75978], [-121.98819, 37.75965], [-121.98807, 37.7595], [-121.98768, 37.75937], [-121.98733, 37.75935], [-121.98716, 37.75927], [-121.98679, 37.75931], [-121.9866, 37.7593], [-121.98647, 37.75926], [-121.98664, 37.75878], [-121.9864, 37.75821], [-121.98609, 37.75774], [-121.98563, 37.75771], [-121.98486, 37.75786], [-121.985, 37.75706], [-121.98475, 37.7569], [-121.98357, 37.75653], [-121.98353, 37.75657], [-121.98313, 37.75629], [-121.98264, 37.75642], [-121.98212, 37.75639], [-121.98203, 37.75632], [-121.98174, 37.75635], [-121.98158, 37.75632], [-121.98136, 37.75635], [-121.98103, 37.7563], [-121.98095, 37.75625], [-121.98063, 37.75622], [-121.98059, 37.75616], [-121.98028, 37.75625], [-121.98023, 37.75623], [-121.97999, 37.75625], [-121.97994, 37.75621], [-121.97977, 37.75621], [-121.97978, 37.75616], [-121.97959, 37.75606], [-121.97959, 37.75597], [-121.97938, 37.75585], [-121.97941, 37.75577], [-121.97879, 37.75548], [-121.97841, 37.7554], [-121.97842, 37.75536], [-121.97816, 37.75528], [-121.97814, 37.75525], [-121.97794, 37.75519], [-121.97768, 37.75508], [-121.97706, 37.75497], [-121.97678, 37.75488], [-121.9767, 37.75481], [-121.97665, 37.75465], [-121.97657, 37.75452], [-121.97629, 37.7542], [-121.97624, 37.75422], [-121.97607, 37.75438], [-121.97576, 37.75453], [-121.97543, 37.7545], [-121.97509, 37.75451], [-121.97455, 37.75392], [-121.9741, 37.75397], [-121.97368, 37.75369], [-121.97347, 37.75361], [-121.97292, 37.75348], [-121.97281, 37.75332], [-121.97263, 37.75313], [-121.9723, 37.75299], [-121.97207, 37.75303], [-121.97176, 37.75343], [-121.97172, 37.75351], [-121.9711, 37.75332], [-121.97103, 37.75328], [-121.97071, 37.7533], [-121.9704, 37.75335], [-121.9701, 37.7532], [-121.96953, 37.75308], [-121.96918, 37.75327], [-121.96896, 37.75331], [-121.96878, 37.75318], [-121.96893, 37.75285], [-121.96901, 37.75271], [-121.969, 37.75262], [-121.96882, 37.75222], [-121.96853, 37.75191], [-121.96843, 37.75182], [-121.96845, 37.7517], [-121.96828, 37.75143], [-121.96766, 37.75113], [-121.96743, 37.75106], [-121.96718, 37.75104], [-121.96704, 37.75106], [-121.96696, 37.7509], [-121.9667, 37.75082], [-121.96648, 37.75096], [-121.96625, 37.75081], [-121.96604, 37.75062], [-121.96579, 37.75044], [-121.96556, 37.75031], [-121.96547, 37.75029], [-121.96524, 37.75014], [-121.96497, 37.75002], [-121.96491, 37.74988], [-121.96466, 37.74999], [-121.96454, 37.75019], [-121.96417, 37.75007], [-121.964, 37.75], [-121.96374, 37.74985], [-121.96353, 37.74969], [-121.96332, 37.74959], [-121.96307, 37.74952], [-121.96278, 37.7495], [-121.96254, 37.74952], [-121.96232, 37.74959], [-121.96218, 37.74938], [-121.97749, 37.74314], [-121.98852, 37.75987]]]} | Open Access 1 | 734 | Bishop Ranch Regional Open Space Preserve | 31523 | 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/bishop | Contra Costa 12 | 370.753 | Bishop Ranch Reg. OSP | 1978 | Local Conservation Area 4 | 2 |
16855 | 16855 | 16854 | {"type": "Polygon", "coordinates": [[[-121.98762, 37.73256], [-121.98753, 37.73799], [-121.9876, 37.73928], [-121.98704, 37.73931], [-121.98615, 37.73907], [-121.98568, 37.73909], [-121.98472, 37.73927], [-121.98444, 37.73942], [-121.98365, 37.73993], [-121.98327, 37.74042], [-121.98322, 37.74076], [-121.98399, 37.74087], [-121.98398, 37.74098], [-121.9832, 37.74088], [-121.98318, 37.7413], [-121.98366, 37.74186], [-121.98064, 37.74173], [-121.97896, 37.74275], [-121.97917, 37.74361], [-121.98011, 37.7449], [-121.982, 37.74574], [-121.98584, 37.74524], [-121.98637, 37.7457], [-121.98625, 37.74612], [-121.98606, 37.74617], [-121.98531, 37.74627], [-121.98496, 37.74691], [-121.9851, 37.74767], [-121.98619, 37.74749], [-121.98627, 37.74753], [-121.98634, 37.74799], [-121.98635, 37.74822], [-121.98634, 37.74846], [-121.98629, 37.7487], [-121.98622, 37.74893], [-121.98611, 37.74915], [-121.98477, 37.74899], [-121.98429, 37.74911], [-121.9844, 37.74926], [-121.98437, 37.75009], [-121.98596, 37.75252], [-121.98368, 37.75252], [-121.98337, 37.75206], [-121.98195, 37.74976], [-121.97896, 37.74536], [-121.97749, 37.74314], [-121.96998, 37.73069], [-121.97852, 37.73081], [-121.97855, 37.72967], [-121.97963, 37.72981], [-121.98688, 37.73202], [-121.98762, 37.73256]]]} | No Public Access 3 | 46957 | Bishop Ranch Regional Open Space Preserve | 31521 | 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/bishop | Contra Costa 12 | 436.568 | Bishop Ranch Reg. OSP | 0 | 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]);