units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
14,510 rows where ACCESS_TYP = 1 sorted by DES_TP descending
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 1
- Open Access · 14,510 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17041 | 17041 | 17040 | {"type": "Polygon", "coordinates": [[[-119.64521, 36.32075], [-119.64478, 36.32081], [-119.64471, 36.3205], [-119.64439, 36.32055], [-119.64438, 36.31957], [-119.6452, 36.31956], [-119.64521, 36.32075]]]} | Open Access 1 | 34881 | Longfield Center Grounds | 21455 | 1129 | Hanford, City of 349 | City 2 | City Agency 2 | http://www.ci.hanford.ca.us/depts/rec/default.asp | City 2 | 1129 | Hanford, City of 346 | City 2 | City Agency 2 | Kings 44 | 2.224 | Longfield Ctr. Grounds | None 1426 | |||
17034 | 17034 | 17033 | {"type": "Polygon", "coordinates": [[[-122.2788, 37.98436], [-122.2785, 37.98528], [-122.27786, 37.98514], [-122.27775, 37.98544], [-122.27731, 37.98536], [-122.27739, 37.98517], [-122.27736, 37.98512], [-122.27739, 37.98511], [-122.2774, 37.9851], [-122.2772, 37.98472], [-122.27713, 37.9847], [-122.27736, 37.9843], [-122.27755, 37.98439], [-122.27874, 37.98431], [-122.2788, 37.98436]]]} | Open Access 1 | 23687 | Pinole Swim Center & Tiny Tots | 23701 | 1252 | Pinole, City of 357 | City 2 | City Agency 2 | http://www.ci.pinole.ca.us/recreation/parks.html | City 2 | 1252 | Pinole, City of 354 | City 2 | City Agency 2 | Contra Costa 12 | 3.095 | Pinole Swim Ctr. & Tiny Tots | None 1425 | |||
17011 | 17011 | 17010 | {"type": "Polygon", "coordinates": [[[-122.27265, 37.86963], [-122.27067, 37.86986], [-122.27054, 37.86916], [-122.27257, 37.86887], [-122.27265, 37.86963]], [[-122.2712, 37.86973], [-122.27121, 37.86971], [-122.27111, 37.86918], [-122.27062, 37.86925], [-122.27073, 37.86979], [-122.2712, 37.86973]]]} | Open Access 1 | 13855 | MLK Memorial Park (Civic Center) | 22335 | 1028 | Berkeley, City of 337 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | Alameda 17 | 2.955 | MLK Memorial Park (Civic Ctr.) | None 1423 | |||
16964 | 16964 | 16963 | {"type": "Polygon", "coordinates": [[[-122.44907, 37.70164], [-122.44695, 37.70279], [-122.44598, 37.70227], [-122.44575, 37.70217], [-122.44551, 37.70208], [-122.44361, 37.70161], [-122.44327, 37.70156], [-122.44284, 37.70156], [-122.44274, 37.70138], [-122.44263, 37.70126], [-122.4419, 37.7008], [-122.44065, 37.70092], [-122.44064, 37.70094], [-122.44125, 37.70273], [-122.44096, 37.7037], [-122.4397, 37.7037], [-122.43851, 37.70406], [-122.438, 37.70399], [-122.43697, 37.70439], [-122.4362, 37.7043], [-122.43532, 37.7044], [-122.43459, 37.70436], [-122.43413, 37.70446], [-122.43398, 37.70467], [-122.43383, 37.70462], [-122.4336, 37.70461], [-122.43349, 37.70458], [-122.43338, 37.70453], [-122.4332, 37.70439], [-122.43303, 37.70432], [-122.43276, 37.70429], [-122.43247, 37.7043], [-122.43192, 37.70404], [-122.43161, 37.70431], [-122.43171, 37.70461], [-122.43152, 37.70478], [-122.43141, 37.70481], [-122.43141, 37.70483], [-122.43148, 37.70482], [-122.43136, 37.70488], [-122.43118, 37.7049], [-122.43072, 37.70478], [-122.43052, 37.70476], [-122.43031, 37.70475], [-122.42995, 37.7048], [-122.42937, 37.70497], [-122.42917, 37.70497], [-122.429, 37.70494], [-122.42897, 37.70491], [-122.42902, 37.70474], [-122.42902, 37.70461], [-122.42888, 37.70403], [-122.42876, 37.70374], [-122.4285, 37.70331], [-122.42839, 37.70321], [-122.42792, 37.70287], [-122.4272, 37.70349], [-122.42551, 37.70158], [-122.42569, 37.70113], [-122.42477, 37.70004], [-122.42375, 37.70022], [-122.42353, 37.70032], [-122.42283, 37.70025], [-122.42269, 37.70022], [-122.42217, 37.69846], [-122.42341, 37.69681], [-122.42365, 37.69657], [-122.42396, 37.69637], [-122.42431, 37.69623], [-122.42468, 37.69614], [-122.42508, 37.69612], [-122.42534, 37.69614], [-122.42565, 37.69621], [-122.42589, 37.69629], [-122.42612, 37.6964], [-122.42887, 37.69833], [-122.42919, 37.69852], [-122.42949, 37.69862], [-122.42987, 37.6987], [-122.43026, 37.69871], [-122.43065, 37.69866], [-122.43096, 37.69857], [-122.43124, 37.69843], [-122.43149, 37.69826], [-122.4317, 37.69806], [-122.4318, 37.69793], [-122.43191, 37.69774], [-122.43243, 37.69655], [-122.43257, 37.69637], [-122.43274, 37.6962], [-122.43299, 37.69604], [-122.43333, 37.69591], [-122.4337, 37.69584], [-122.43408, 37.69585], [-122.43429, 37.69589], [-122.4345, 37.69595], [-122.43627, 37.69661], [-122.43688, 37.69687], [-122.43746, 37.69717], [-122.43981, 37.69866], [-122.44012, 37.69883], [-122.44045, 37.69896], [-122.44753, 37.70159], [-122.44784, 37.70167], [-122.44817, 37.70169], [-122.44855, 37.70167], [-122.44893, 37.70159], [-122.44907, 37.70164]]]} | Open Access 1 | 16001 | San Bruno Mountain State Park | 30691 | 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 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | http://www.parks.ca.gov/?page_id=518 | San Mateo 15 | 297.853 | San Bruno Mtn. SP | 1980 | None 1421 | |
16910 | 16910 | 16909 | {"type": "Polygon", "coordinates": [[[-122.33036, 37.52058], [-122.33006, 37.52091], [-122.32899, 37.52069], [-122.32764, 37.52097], [-122.32656, 37.52146], [-122.32553, 37.52223], [-122.32553, 37.52224], [-122.32578, 37.52241], [-122.32567, 37.52252], [-122.32538, 37.52262], [-122.32526, 37.5227], [-122.32521, 37.52266], [-122.32513, 37.52271], [-122.32518, 37.52276], [-122.32501, 37.52288], [-122.32517, 37.52303], [-122.32506, 37.5232], [-122.32496, 37.52343], [-122.3248, 37.52339], [-122.32441, 37.52369], [-122.32445, 37.52385], [-122.32402, 37.52429], [-122.32415, 37.52442], [-122.32402, 37.52458], [-122.32394, 37.52475], [-122.32391, 37.52494], [-122.32393, 37.52514], [-122.32413, 37.52511], [-122.32418, 37.52525], [-122.32427, 37.52539], [-122.32435, 37.52547], [-122.32441, 37.52548], [-122.32456, 37.5256], [-122.32476, 37.52581], [-122.32498, 37.52623], [-122.32507, 37.52633], [-122.32512, 37.52634], [-122.32524, 37.52648], [-122.32573, 37.5272], [-122.32554, 37.52728], [-122.32526, 37.52685], [-122.32487, 37.52699], [-122.32485, 37.52692], [-122.32439, 37.52702], [-122.32443, 37.52721], [-122.32427, 37.52725], [-122.3243, 37.5275], [-122.32399, 37.52749], [-122.32378, 37.52753], [-122.32371, 37.52736], [-122.32365, 37.52737], [-122.32331, 37.52727], [-122.32215, 37.52724], [-122.32196, 37.52811], [-122.32151, 37.52822], [-122.32126, 37.52752], [-122.32126, 37.52721], [-122.32119, 37.52705], [-122.32095, 37.527], [-122.32063, 37.52711], [-122.32044, 37.52723], [-122.32059, 37.52748], [-122.32045, 37.52773], [-122.32041, 37.52801], [-122.32006, 37.52816], [-122.32001, 37.52815], [-122.3198, 37.52794], [-122.31951, 37.52812], [-122.31953, 37.52823], [-122.31945, 37.52824], [-122.31943, 37.52816], [-122.31874, 37.52819], [-122.31849, 37.52826], [-122.3179, 37.52849], [-122.31767, 37.52852], [-122.31746, 37.52856], [-122.31722, 37.52857], [-122.31683, 37.52877], [-122.31637, 37.52843], [-122.31597, 37.52836], [-122.31579, 37.52842], [-122.31555, 37.52795], [-122.31563, 37.52785], [-122.31581, 37.52781], [-122.31583, 37.52792], [-122.31606, 37.52781], [-122.31626, 37.52772], [-122.31635, 37.52758], [-122.31658, 37.52761], [-122.31667, 37.52757], [-122.3167, 37.52742], [-122.31676, 37.52734], [-122.31694, 37.52746], [-122.31705, 37.52746], [-122.31724, 37.52736], [-122.31725, 37.52726], [-122.31751, 37.52726], [-122.31802, 37.52711], [-122.3184, 37.52708], [-122.31841, 37.52705], [-122.3185, 37.52705], [-122.31857, 37.52702], [-122.31857, 37.5269], [-122.31835, 37.52691], [-122.3183, 37.52677], [-122.31786, 37.52677], [-122.31737, 37.52684], [-122.31705, 37.52693], [-122.31679, 37.52702], [-122.31587, 37.5263], [-122.31625, 37.52599], [-122.31624, 37.52597], [-122.31434, 37.52534], [-122.3142, 37.52521], [-122.31453, 37.52477], [-122.31459, 37.52438], [-122.31429, 37.52405], [-122.31419, 37.52386], [-122.31412, 37.52358], [-122.31328, 37.52356], [-122.31324, 37.52381], [-122.31335, 37.5242], [-122.31331, 37.52455], [-122.3129, 37.52486], [-122.3136, 37.52621], [-122.31334, 37.52678], [-122.31307, 37.5269], [-122.313, 37.52675], [-122.31217, 37.5269], [-122.31232, 37.52669], [-122.31225, 37.5263], [-122.31204, 37.52592], [-122.31169, 37.52551], [-122.31204, 37.52522], [-122.31199, 37.52511], [-122.31215, 37.5251], [-122.31214, 37.52503], [-122.31231, 37.52468], [-122.31189, 37.52452], [-122.312, 37.52426], [-122.31196, 37.52424], [-122.31262, 37.52268], [-122.31339, 37.52159], [-122.31382, 37.52142], [-122.31423, 37.5214], [-122.31455, 37.52114], [-122.31472, 37.52074], [-122.3148, 37.52014], [-122.31492, 37.51953], [-122.31506, 37.51925], [-122.31538, 37.51923], [-122.31606, 37.51943], [-122.31641, 37.51946], [-122.31735, 37.51937], [-122.31782, 37.51923], [-122.3186, 37.51929], [-122.31928, 37.51925], [-122.31963, 37.51946], [-122.32012, 37.51983], [-122.32056, 37.52046], [-122.32155, 37.5212], [-122.32184, 37.52121], [-122.32248, 37.52097], [-122.32277, 37.52082], [-122.32291, 37.52076], [-122.3232, 37.5207], [-122.32329, 37.52074], [-122.32337, 37.52085], [-122.3235, 37.52099], [-122.32375, 37.521], [-122.32441, 37.5205], [-122.32458, 37.52028], [-122.32497, 37.52018], [-122.32533, 37.51988], [-122.32543, 37.51959], [-122.32545, 37.51935], [-122.32554, 37.51908], [-122.32546, 37.51879], [-122.32538, 37.51865], [-122.32525, 37.51853], [-122.32513, 37.51846], [-122.32511, 37.51836], [-122.32516, 37.51809], [-122.32506, 37.51782], [-122.32508, 37.51769], [-122.32505, 37.51753], [-122.32489, 37.51731], [-122.32492, 37.51724], [-122.32519, 37.51715], [-122.32556, 37.51712], [-122.32578, 37.51686], [-122.32585, 37.51672], [-122.32587, 37.51658], [-122.32593, 37.51647], [-122.32675, 37.51559], [-122.32691, 37.51532], [-122.32691, 37.51505], [-122.32736, 37.51541], [-122.32679, 37.51587], [-122.32722, 37.51663], [-122.32694, 37.51683], [-122.32623, 37.51782], [-122.3269, 37.51829], [-122.32788, 37.51813], [-122.32848, 37.5177], [-122.32923, 37.51866], [-122.32761, 37.51891], [-122.32704, 37.51962], [-122.32729, 37.52014], [-122.32815, 37.52034], [-122.3294, 37.5199], [-122.32963, 37.52028], [-122.33036, 37.52058]]]} | Open Access 1 | 14062 | Laurelwood Park and Sugarloaf Mountain | 29306 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?NID=2449 | San Mateo 15 | 236.587 | Laurelwood Park and Sugarloaf Mtn. | 2000 | None 1420 | |
16821 | 16821 | 16820 | {"type": "Polygon", "coordinates": [[[-121.22734, 38.6885], [-121.22734, 38.68895], [-121.22702, 38.68895], [-121.22701, 38.6894], [-121.22603, 38.68939], [-121.22602, 38.68894], [-121.22555, 38.68893], [-121.22556, 38.68849], [-121.22734, 38.6885]]]} | Open Access 1 | 24282 | Youth Center, & Kids Korner Buildings | 27794 | 2248 | Orangevale Recreation and Park District 928 | Special District 4 | Recreation/Parks District 4 | http://www.orangevalecommunitycenter.com/ | Special District 4 | 2248 | Orangevale Recreation and Park District 901 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 2.971 | Youth Ctr., & Kids Korner Buildings | None 1419 | |||
16796 | 16796 | 16795 | {"type": "Polygon", "coordinates": [[[-118.86603, 34.26242], [-118.86562, 34.26252], [-118.86522, 34.26265], [-118.86394, 34.26316], [-118.86356, 34.26328], [-118.86317, 34.26338], [-118.86264, 34.26347], [-118.86097, 34.26347], [-118.86089, 34.2628], [-118.8609, 34.26237], [-118.86095, 34.26211], [-118.861, 34.2619], [-118.86109, 34.26165], [-118.86118, 34.26145], [-118.86138, 34.26111], [-118.86163, 34.2608], [-118.86183, 34.2606], [-118.86237, 34.26013], [-118.8626, 34.25991], [-118.86281, 34.25968], [-118.86305, 34.25937], [-118.86326, 34.25903], [-118.86447, 34.25686], [-118.86461, 34.25655], [-118.8647, 34.25629], [-118.86476, 34.25603], [-118.86479, 34.2557], [-118.86478, 34.25538], [-118.86473, 34.25506], [-118.86461, 34.25464], [-118.86413, 34.25349], [-118.86405, 34.25324], [-118.86401, 34.25298], [-118.86399, 34.25267], [-118.86401, 34.25241], [-118.86406, 34.2521], [-118.86415, 34.2518], [-118.86428, 34.25151], [-118.86444, 34.25123], [-118.86461, 34.25101], [-118.86483, 34.25076], [-118.86509, 34.25053], [-118.86537, 34.25033], [-118.86568, 34.25015], [-118.86601, 34.25], [-118.86601, 34.25267], [-118.86509, 34.25268], [-118.86509, 34.25349], [-118.86601, 34.2535], [-118.86603, 34.26242]]]} | Open Access 1 | 49014 | Moorpark Watershed, Parks, Recreation and Conservation Authority Open Space | 33712 | 502 | Moorpark Watershed, Parks, Recreation and Conservation Authority 1175 | Joint 8 | Joint Powers Authority 24 | http://smmc.ca.gov/Moorpark%20Watershed%20Parks%20Recreation%20and%20Conservation%20Authority.html | Special District 4 | 502 | Moorpark Watershed, Parks, Recreation and Conservation Authority 1115 | Joint 8 | Joint Powers Authority 23 | Ventura 8 | 80.677 | Moorpark Watershed, Parks, Rec. and Conservation Authority OS | None 1418 | |||
16690 | 16690 | 16689 | {"type": "Polygon", "coordinates": [[[-121.78746, 39.7124], [-121.78712, 39.71247], [-121.78382, 39.71293], [-121.78234, 39.71292], [-121.78172, 39.71297], [-121.78061, 39.7131], [-121.78031, 39.71316], [-121.77964, 39.7132], [-121.77914, 39.71317], [-121.77773, 39.7129], [-121.77777, 39.71176], [-121.77777, 39.70713], [-121.77781, 39.70459], [-121.77727, 39.70261], [-121.78695, 39.70468], [-121.78734, 39.71127], [-121.78746, 39.71128], [-121.78746, 39.7124]]]} | Open Access 1 | 15788 | USFS Genetic Resource and Conservation Center | 26745 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 204.578 | USFS Genetic Resource and Conservation Ctr. | None 1416 | |||
16629 | 16629 | 16628 | {"type": "Polygon", "coordinates": [[[-117.8006, 33.92776], [-117.80026, 33.92786], [-117.8002, 33.92778], [-117.79901, 33.92814], [-117.79903, 33.92826], [-117.79854, 33.92841], [-117.7982, 33.92855], [-117.79788, 33.92877], [-117.79778, 33.92871], [-117.79751, 33.92896], [-117.79677, 33.9299], [-117.79685, 33.92998], [-117.79642, 33.93059], [-117.79628, 33.93096], [-117.79612, 33.93152], [-117.79598, 33.93188], [-117.79581, 33.93221], [-117.79581, 33.93222], [-117.79585, 33.93222], [-117.79567, 33.93244], [-117.79541, 33.93268], [-117.79471, 33.93301], [-117.79448, 33.93309], [-117.79426, 33.93322], [-117.7938, 33.93371], [-117.79355, 33.93392], [-117.79313, 33.93412], [-117.79276, 33.93426], [-117.79247, 33.93447], [-117.79229, 33.93468], [-117.79217, 33.93495], [-117.79212, 33.93524], [-117.7921, 33.93562], [-117.79212, 33.93577], [-117.78316, 33.93569], [-117.783, 33.93214], [-117.78306, 33.92837], [-117.79162, 33.92847], [-117.79167, 33.92489], [-117.80058, 33.92502], [-117.8006, 33.92508], [-117.8006, 33.92776]]]} | Open Access 1 | 45015 | Chino Hills State Park | 28288 | 2340 | Castaic Lake Water Agency 1002 | Special District 4 | Water District 13 | http://clwa.org/ | Special District 4 | 2340 | Castaic Lake Water Agency 1111 | Special District 4 | Water District 13 | http://www.parks.ca.gov/?page_id=648 | Orange 3 | 301.431 | Chino Hills SP | 1981 | None 1415 | |
16592 | 16592 | 16591 | {"type": "Polygon", "coordinates": [[[-122.32764, 37.88931], [-122.32767, 37.88943], [-122.3277, 37.88994], [-122.32777, 37.89025], [-122.32775, 37.89047], [-122.32776, 37.8908], [-122.32755, 37.89163], [-122.32748, 37.89129], [-122.3275, 37.89097], [-122.32745, 37.89074], [-122.32717, 37.89084], [-122.32691, 37.89087], [-122.3265, 37.89088], [-122.326, 37.89082], [-122.32568, 37.8908], [-122.32561, 37.89111], [-122.32559, 37.89174], [-122.32566, 37.89202], [-122.32592, 37.89206], [-122.32599, 37.89234], [-122.32573, 37.89251], [-122.32444, 37.89221], [-122.32409, 37.89132], [-122.32356, 37.89131], [-122.32311, 37.8899], [-122.31991, 37.88993], [-122.31763, 37.89086], [-122.31635, 37.8909], [-122.31625, 37.89169], [-122.31393, 37.8917], [-122.31197, 37.89022], [-122.312, 37.88997], [-122.31333, 37.88985], [-122.31333, 37.88964], [-122.31592, 37.88964], [-122.31593, 37.88793], [-122.31595, 37.88794], [-122.31602, 37.88795], [-122.31709, 37.88922], [-122.31722, 37.88925], [-122.32312, 37.8891], [-122.32321, 37.88893], [-122.32315, 37.88872], [-122.32319, 37.88833], [-122.32341, 37.88824], [-122.32374, 37.88809], [-122.32431, 37.88803], [-122.32463, 37.88788], [-122.32501, 37.88804], [-122.3254, 37.88804], [-122.32577, 37.88823], [-122.32585, 37.88825], [-122.32584, 37.88827], [-122.32619, 37.88847], [-122.32661, 37.88861], [-122.32695, 37.88868], [-122.32718, 37.88871], [-122.32763, 37.88855], [-122.32756, 37.88886], [-122.32764, 37.88931]]]} | Open Access 1 | 29694 | McLaughlin Eastshore State Park | 29199 | 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.ebparks.org/parks/eastshore | Alameda 17 | 71.308 | McLaughlin Eastshore SP | None 1414 | ||
16547 | 16547 | 16546 | {"type": "MultiPolygon", "coordinates": [[[[-122.32, 37.89774], [-122.31954, 37.89799], [-122.31891, 37.89855], [-122.31905, 37.89825], [-122.31963, 37.89787], [-122.32, 37.89774]]], [[[-122.32553, 37.89867], [-122.3253, 37.89925], [-122.32527, 37.89971], [-122.32522, 37.89971], [-122.32521, 37.89938], [-122.32487, 37.89938], [-122.32487, 37.89924], [-122.32464, 37.89867], [-122.32456, 37.89855], [-122.3243, 37.8983], [-122.32386, 37.89801], [-122.32482, 37.89704], [-122.32226, 37.89542], [-122.32129, 37.89638], [-122.32156, 37.89656], [-122.32103, 37.89709], [-122.32103, 37.89664], [-122.32117, 37.8962], [-122.32142, 37.89597], [-122.32151, 37.89571], [-122.32216, 37.8953], [-122.32275, 37.89529], [-122.32298, 37.89561], [-122.32319, 37.89586], [-122.32496, 37.89698], [-122.32459, 37.89744], [-122.32537, 37.89797], [-122.32535, 37.89834], [-122.32553, 37.89867]]], [[[-122.3261, 37.90816], [-122.32595, 37.90814], [-122.32579, 37.90809], [-122.32458, 37.9076], [-122.3235, 37.90705], [-122.32313, 37.90684], [-122.3228, 37.9066], [-122.32235, 37.90632], [-122.32211, 37.90606], [-122.32159, 37.90561], [-122.32125, 37.90533], [-122.32088, 37.90498], [-122.3203, 37.90434], [-122.31987, 37.90381], [-122.32522, 37.90109], [-122.32523, 37.90161], [-122.32526, 37.90164], [-122.32525, 37.90223], [-122.32528, 37.90303], [-122.32537, 37.9072], [-122.3261, 37.90816]]], [[[-122.3256, 37.90938], [-122.32441, 37.90871], [-122.32387, 37.90873], [-122.32346, 37.90851], [-122.32331, 37.90864], [-122.32054, 37.90518], [-122.32029, 37.90492], [-122.31957, 37.90397], [-122.32022, 37.90468], [-122.32039, 37.90483], [-122.32094, 37.9054], [-122.32145, 37.90584], [-122.32205, 37.90627], [-122.32317, 37.90701], [-122.32432, 37.90764], [-122.32454, 37.90774], [-122.32475, 37.9078], [-122.32557, 37.90811], [-122.3256, 37.90938]]]]} | Open Access 1 | 35120 | McLaughlin Eastshore State Park | 29199 | 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.ebparks.org/parks/eastshore | Contra Costa 12 | 69.746 | McLaughlin Eastshore SP | 0 | None 1413 | |
16545 | 16545 | 16544 | {"type": "Polygon", "coordinates": [[[-118.47215, 34.37798], [-118.4698, 34.37797], [-118.46941, 34.37814], [-118.46787, 34.37869], [-118.46751, 34.37884], [-118.46721, 34.37901], [-118.46691, 34.37922], [-118.46662, 34.37947], [-118.46656, 34.37798], [-118.45784, 34.37806], [-118.44845, 34.37819], [-118.44591, 34.37819], [-118.44558, 34.37818], [-118.44434, 34.3781], [-118.44193, 34.37808], [-118.44195, 34.37454], [-118.43979, 34.37452], [-118.43984, 34.37077], [-118.43763, 34.37076], [-118.43768, 34.36702], [-118.44865, 34.36697], [-118.44855, 34.37077], [-118.44637, 34.37078], [-118.44628, 34.37455], [-118.44846, 34.37457], [-118.44846, 34.37502], [-118.44954, 34.37498], [-118.4508, 34.3763], [-118.45314, 34.37623], [-118.45315, 34.37668], [-118.45553, 34.37708], [-118.46218, 34.3768], [-118.46217, 34.37599], [-118.46648, 34.37589], [-118.46642, 34.37381], [-118.47113, 34.37386], [-118.47116, 34.37591], [-118.47212, 34.37593], [-118.47213, 34.37611], [-118.47187, 34.37622], [-118.4716, 34.37638], [-118.47142, 34.37651], [-118.47129, 34.37664], [-118.47121, 34.37659], [-118.47117, 34.37662], [-118.47118, 34.37709], [-118.47119, 34.37709], [-118.4715, 34.37681], [-118.47143, 34.37674], [-118.47158, 34.37661], [-118.47194, 34.37638], [-118.47213, 34.37629], [-118.47215, 34.37798]]]} | Open Access 1 | 12567 | Placerita Canyon State Park | 32485 | 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 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://www.parks.ca.gov/?page_id=622 | Los Angeles 6 | 359.799 | Placerita Canyon SP | None 1412 | ||
16532 | 16532 | 16531 | {"type": "Polygon", "coordinates": [[[-122.12131, 36.99905], [-122.12095, 36.99935], [-122.12072, 36.99916], [-122.12107, 36.99886], [-122.12131, 36.99905]]]} | Open Access 1 | 1870 | Wilder Ranch State Park | 27506 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.parks.ca.gov/?page_id=549 | Santa Cruz 5 | 0.336 | Wilder Ranch SP | 1974 | None 1411 | |
16511 | 16511 | 16510 | {"type": "MultiPolygon", "coordinates": [[[[-117.42036, 33.89827], [-117.41851, 33.89932], [-117.4162, 33.8965], [-117.41663, 33.89624], [-117.41665, 33.89616], [-117.41647, 33.89589], [-117.41644, 33.89575], [-117.41647, 33.89559], [-117.41663, 33.89533], [-117.41535, 33.89528], [-117.4153, 33.89523], [-117.41665, 33.89524], [-117.41632, 33.89488], [-117.41609, 33.89488], [-117.41566, 33.89478], [-117.41492, 33.89449], [-117.41484, 33.89459], [-117.41385, 33.89471], [-117.41322, 33.89429], [-117.41256, 33.89429], [-117.41204, 33.89435], [-117.412, 33.89406], [-117.41183, 33.89388], [-117.41166, 33.89379], [-117.41111, 33.89291], [-117.41054, 33.89225], [-117.4102, 33.89208], [-117.41, 33.89204], [-117.40959, 33.89169], [-117.4093, 33.89168], [-117.40904, 33.89161], [-117.40943, 33.89155], [-117.40951, 33.8914], [-117.40941, 33.89114], [-117.4096, 33.89087], [-117.40925, 33.89053], [-117.40871, 33.89016], [-117.40837, 33.88975], [-117.40834, 33.8893], [-117.40809, 33.88889], [-117.40735, 33.88827], [-117.40711, 33.88799], [-117.40725, 33.88721], [-117.40755, 33.88702], [-117.4097, 33.88701], [-117.40989, 33.88734], [-117.40977, 33.88754], [-117.4093, 33.88773], [-117.40926, 33.88786], [-117.40949, 33.88808], [-117.40985, 33.88821], [-117.40998, 33.88863], [-117.41021, 33.88855], [-117.41045, 33.88821], [-117.41049, 33.88849], [-117.4106, 33.88852], [-117.41085, 33.88845], [-117.41084, 33.88867], [-117.41128, 33.88888], [-117.41121, 33.88913], [-117.41144, 33.88925], [-117.41134, 33.88943], [-117.41159, 33.88938], [-117.4116, 33.88955], [-117.41174, 33.88952], [-117.41175, 33.88963], [-117.41186, 33.88968], [-117.41184, 33.88987], [-117.41195, 33.88993], [-117.41194, 33.89031], [-117.41236, 33.89029], [-117.41254, 33.89021], [-117.41272, 33.89], [-117.41285, 33.88995], [-117.41287, 33.89013], [-117.413, 33.89022], [-117.41309, 33.89036], [-117.41332, 33.89056], [-117.4133, 33.8907], [-117.41341, 33.89088], [-117.41333, 33.891], [-117.41336, 33.89147], [-117.4133, 33.89158], [-117.4134, 33.89163], [-117.41354, 33.89164], [-117.4135, 33.89185], [-117.41376, 33.89199], [-117.41404, 33.89198], [-117.4144, 33.89203], [-117.41451, 33.89196], [-117.41431, 33.89159], [-117.41442, 33.89158], [-117.41441, 33.89148], [-117.41446, 33.89129], [-117.41441, 33.89119], [-117.41443, 33.89103], [-117.41431, 33.89089], [-117.41431, 33.89082], [-117.41447, 33.89082], [-117.41453, 33.8907], [-117.41438, 33.89054], [-117.41427, 33.89011], [-117.41449, 33.89053], [-117.41464, 33.89057], [-117.41472, 33.89067], [-117.41473, 33.89083], [-117.41482, 33.89098], [-117.41493, 33.89086], [-117.415, 33.89084], [-117.4151, 33.89065], [-117.41511, 33.8908], [-117.41518, 33.89084], [-117.41508, 33.89094], [-117.41511, 33.89106], [-117.41541, 33.89094], [-117.41584, 33.89039], [-117.41797, 33.89199], [-117.418, 33.89201], [-117.41759, 33.89239], [-117.41755, 33.89263], [-117.41808, 33.8932], [-117.41845, 33.89311], [-117.41869, 33.89345], [-117.41907, 33.89345], [-117.4193, 33.89373], [-117.41976, 33.89373], [-117.42014, 33.8941], [-117.42015, 33.89415], [-117.42003, 33.89418], [-117.41986, 33.89428], [-117.41995, 33.89439], [-117.42012, 33.89439], [-117.42021, 33.89448], [-117.42029, 33.89534], [-117.42006, 33.89559], [-117.41899, 33.89581], [-117.4186, 33.89529], [-117.41837, 33.89535], [-117.41812, 33.89552], [-117.42036, 33.89827]]], [[[-117.42232, 33.90418], [-117.41881, 33.90616], [-117.41756, 33.90463], [-117.42107, 33.90265], [-117.42232, 33.90418]]], [[[-117.42967, 33.90001], [-117.42254, 33.90406], [-117.42128, 33.90253], [-117.42311, 33.90146], [-117.42331, 33.90095], [-117.42404, 33.89999], [-117.42415, 33.8999], [-117.42428, 33.89985], [-117.42441, 33.89984], [-117.42454, 33.89986], [-117.42466, 33.89992], [-117.42483, 33.89998], [-117.42567, 33.90001], [-117.4284, 33.89846], [-117.42967, 33.90001]]]]} | Open Access 1 | 30006 | California Citrus State Historic Park | 16687 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 193.189 | California Citrus SHP | 1984 | None 1410 | ||
16470 | 16470 | 16469 | {"type": "Polygon", "coordinates": [[[-121.84919, 36.922], [-121.84892, 36.9225], [-121.84829, 36.92229], [-121.84857, 36.92178], [-121.84919, 36.922]]]} | Open Access 1 | 17541 | Manresa State Beach - SCWD | 21759 | 2157 | Soquel Creek Water District 592 | Special District 4 | Water District 13 | http://www.soquelcreekwater.org/ | Special District 4 | 2157 | Soquel Creek Water District 582 | Special District 4 | Water District 13 | http://www.parks.ca.gov/?page_id=545 | Santa Cruz 5 | 0.932 | Manresa SB - SCWD | None 1408 | ||
16467 | 16467 | 16466 | {"type": "MultiPolygon", "coordinates": [[[[-122.02819, 36.95221], [-122.02734, 36.95194], [-122.02712, 36.9519], [-122.0266, 36.95189], [-122.0264, 36.95193], [-122.02623, 36.95203], [-122.02612, 36.95217], [-122.02604, 36.95238], [-122.02594, 36.95255], [-122.02585, 36.95251], [-122.02559, 36.95287], [-122.02549, 36.95286], [-122.02547, 36.95282], [-122.0254, 36.95277], [-122.02542, 36.95275], [-122.02547, 36.95275], [-122.0255, 36.95273], [-122.02551, 36.95268], [-122.0255, 36.95258], [-122.02551, 36.95253], [-122.02561, 36.95261], [-122.02567, 36.95261], [-122.02583, 36.9525], [-122.02594, 36.95232], [-122.02597, 36.95232], [-122.02598, 36.95234], [-122.02599, 36.95233], [-122.02596, 36.95216], [-122.02586, 36.95205], [-122.02584, 36.95195], [-122.02584, 36.95187], [-122.02588, 36.95181], [-122.02595, 36.95176], [-122.02599, 36.95176], [-122.02604, 36.95178], [-122.02602, 36.9517], [-122.02603, 36.95156], [-122.02601, 36.95153], [-122.02587, 36.95145], [-122.02587, 36.95137], [-122.02595, 36.95118], [-122.02609, 36.95108], [-122.02615, 36.95114], [-122.02615, 36.95122], [-122.0263, 36.95131], [-122.02639, 36.95133], [-122.02644, 36.95132], [-122.02647, 36.95129], [-122.02648, 36.95126], [-122.02647, 36.95118], [-122.02654, 36.95106], [-122.02655, 36.95099], [-122.02649, 36.95085], [-122.02647, 36.95057], [-122.02651, 36.9505], [-122.02653, 36.9504], [-122.02655, 36.95038], [-122.02659, 36.95039], [-122.02674, 36.95059], [-122.0267, 36.95074], [-122.0267, 36.95082], [-122.02671, 36.95086], [-122.02677, 36.95093], [-122.02678, 36.95099], [-122.0268, 36.95099], [-122.02683, 36.95096], [-122.02683, 36.95077], [-122.02688, 36.95071], [-122.02695, 36.95071], [-122.02706, 36.95083], [-122.02708, 36.95096], [-122.02693, 36.95104], [-122.02688, 36.95112], [-122.02696, 36.95112], [-122.02702, 36.9511], [-122.02705, 36.95111], [-122.02703, 36.95123], [-122.02706, 36.95127], [-122.02709, 36.9514], [-122.02719, 36.95155], [-122.02732, 36.95167], [-122.02736, 36.95166], [-122.02738, 36.95162], [-122.02746, 36.95163], [-122.02762, 36.95175], [-122.02765, 36.95175], [-122.02767, 36.95173], [-122.02773, 36.95175], [-122.02773, 36.95165], [-122.02779, 36.95164], [-122.02795, 36.95178], [-122.02796, 36.95182], [-122.02801, 36.95188], [-122.0281, 36.95192], [-122.02819, 36.95188], [-122.02819, 36.95221]]], [[[-122.03355, 36.95212], [-122.03327, 36.95213], [-122.0328, 36.95202], [-122.0323, 36.95194], [-122.03229, 36.95186], [-122.03352, 36.95195], [-122.03355, 36.95212]]]]} | Open Access 1 | 17345 | Lighthouse Field State Beach | 21231 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.parks.ca.gov/?page_id=550 | Santa Cruz 5 | 4.44 | Lighthouse Field SB | 1978 | None 1407 | |
16464 | 16464 | 16463 | {"type": "Polygon", "coordinates": [[[-121.89454, 36.5976], [-121.89449, 36.59761], [-121.89418, 36.59759], [-121.89428, 36.59721], [-121.89431, 36.59721], [-121.89457, 36.59751], [-121.89457, 36.59756], [-121.89454, 36.5976]]]} | Open Access 1 | 17961 | Monterey State Historic Park | 22433 | 1212 | Monterey, City of 37 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | Monterey 14 | 0.229 | Monterey SHP | 1916 | None 1406 | ||
16457 | 16457 | 16456 | {"type": "MultiPolygon", "coordinates": [[[[-118.80898, 34.00167], [-118.80844, 34.00168], [-118.80836, 34.00194], [-118.80839, 34.00212], [-118.80832, 34.00218], [-118.8085, 34.00262], [-118.80779, 34.00333], [-118.80764, 34.00318], [-118.80753, 34.00313], [-118.80741, 34.00309], [-118.80721, 34.00309], [-118.80709, 34.00312], [-118.80699, 34.00317], [-118.8068, 34.00334], [-118.80494, 34.00517], [-118.80356, 34.0046], [-118.80388, 34.00424], [-118.8039, 34.00424], [-118.80434, 34.00367], [-118.80467, 34.00312], [-118.80476, 34.00286], [-118.80492, 34.00255], [-118.80497, 34.00249], [-118.80498, 34.00229], [-118.80497, 34.00221], [-118.8049, 34.0021], [-118.80488, 34.00191], [-118.80483, 34.00167], [-118.80481, 34.00149], [-118.80483, 34.00124], [-118.80486, 34.0011], [-118.80492, 34.00097], [-118.805, 34.0009], [-118.80511, 34.00052], [-118.80516, 34.00041], [-118.80533, 34.00029], [-118.80561, 34.00019], [-118.8058, 34.00015], [-118.80622, 34.00019], [-118.80646, 34.0001], [-118.8066, 34.00006], [-118.80683, 34.00012], [-118.80712, 34.00026], [-118.80747, 34.00048], [-118.80755, 34.00051], [-118.80783, 34.00078], [-118.80801, 34.00088], [-118.80854, 34.00135], [-118.80874, 34.00148], [-118.80898, 34.00167]]], [[[-118.81723, 34.01059], [-118.81678, 34.01091], [-118.81662, 34.01076], [-118.81653, 34.01093], [-118.8164, 34.01069], [-118.81631, 34.01073], [-118.81614, 34.01041], [-118.81637, 34.01031], [-118.81671, 34.01008], [-118.81723, 34.01059]]]]} | Open Access 1 | 8716 | Point Dume State Beach | 30686 | 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 | 378 | Los Angeles County Department of Beaches and Harbors, County of 827 | County 3 | County Agency - Other 8 | http://www.parks.ca.gov/?page_id=623 | Los Angeles 6 | 34.961 | Point Dume SB | 1958 | None 1405 | |
16454 | 16454 | 16453 | {"type": "MultiPolygon", "coordinates": [[[[-117.29601, 33.04852], [-117.29434, 33.04867], [-117.29425, 33.04809], [-117.29422, 33.04808], [-117.2942, 33.04794], [-117.2959, 33.04778], [-117.29595, 33.04815], [-117.29601, 33.04852]]], [[[-117.29802, 33.04877], [-117.29769, 33.0488], [-117.29769, 33.04872], [-117.29776, 33.04866], [-117.29781, 33.04865], [-117.2979, 33.04869], [-117.29798, 33.04869], [-117.29801, 33.04872], [-117.29802, 33.04877]]], [[[-117.29663, 33.04875], [-117.29631, 33.04878], [-117.29629, 33.04866], [-117.29661, 33.04863], [-117.29663, 33.04875]]], [[[-117.29605, 33.04882], [-117.29572, 33.04885], [-117.2957, 33.04871], [-117.29603, 33.04868], [-117.29605, 33.04882]]], [[[-117.29565, 33.04886], [-117.29534, 33.04888], [-117.29532, 33.04875], [-117.29564, 33.04872], [-117.29565, 33.04886]]], [[[-117.29466, 33.04895], [-117.29438, 33.04898], [-117.29436, 33.04884], [-117.29464, 33.04881], [-117.29466, 33.04895]]], [[[-117.29921, 33.04945], [-117.29911, 33.04946], [-117.29906, 33.04935], [-117.29873, 33.04939], [-117.29861, 33.04844], [-117.29812, 33.04848], [-117.29811, 33.04845], [-117.29806, 33.04846], [-117.29797, 33.04843], [-117.29789, 33.04845], [-117.29781, 33.0485], [-117.2978, 33.04856], [-117.29777, 33.0486], [-117.29765, 33.04867], [-117.29763, 33.04871], [-117.29763, 33.04881], [-117.2973, 33.04883], [-117.29724, 33.0484], [-117.29627, 33.04849], [-117.29608, 33.04721], [-117.29743, 33.04707], [-117.29736, 33.04645], [-117.29767, 33.04642], [-117.29749, 33.04498], [-117.29747, 33.04497], [-117.29745, 33.04483], [-117.29747, 33.04482], [-117.29725, 33.0431], [-117.29727, 33.04302], [-117.29734, 33.04365], [-117.29745, 33.04422], [-117.29804, 33.04641], [-117.29814, 33.04686], [-117.29815, 33.04688], [-117.29822, 33.04688], [-117.2988, 33.04824], [-117.29921, 33.04945]]]]} | Open Access 1 | 5464 | Moonlight State Beach | 30664 | 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 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Beaches | San Diego 4 | 15.875 | Moonlight SB | 1949 | None 1404 | |
16452 | 16452 | 16451 | {"type": "Polygon", "coordinates": [[[-117.31058, 33.07647], [-117.31024, 33.07647], [-117.30983, 33.07527], [-117.30891, 33.07324], [-117.30866, 33.07256], [-117.30669, 33.06808], [-117.30625, 33.06704], [-117.30608, 33.0665], [-117.30551, 33.06583], [-117.30541, 33.0655], [-117.30479, 33.06563], [-117.30446, 33.06469], [-117.30483, 33.06459], [-117.30492, 33.06399], [-117.30429, 33.06269], [-117.30461, 33.06262], [-117.30504, 33.06328], [-117.30518, 33.06356], [-117.3054, 33.06412], [-117.30551, 33.06446], [-117.30564, 33.06468], [-117.30568, 33.06484], [-117.30572, 33.06532], [-117.30575, 33.06545], [-117.30593, 33.06584], [-117.30644, 33.06646], [-117.30657, 33.06663], [-117.30681, 33.06708], [-117.30691, 33.06733], [-117.30715, 33.06807], [-117.30726, 33.0683], [-117.30735, 33.06859], [-117.30748, 33.06898], [-117.30764, 33.06936], [-117.30785, 33.06979], [-117.30805, 33.07028], [-117.30825, 33.07082], [-117.30893, 33.07212], [-117.30901, 33.0724], [-117.3091, 33.07289], [-117.31058, 33.07647]]]} | Open Access 1 | 4045 | Leucadia State Beach | 30658 | 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 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Beaches | San Diego 4 | 15.812 | Leucadia SB | 1949 | None 1403 |
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]);