units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10,524 rows where MNG_AG_TYP = 2 sorted by DES_TP descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, LAYER
MNG_AGENCY >30
- San Diego, City of 533
- Los Angeles, City of 491
- San Jose, City of 253
- San Francisco, City and County of 240
- Sacramento, City of 220
- Ventura, City of 151
- Long Beach, City of 148
- Roseville, City of 130
- Oakland, City of 122
- Irvine, City of 101
- Fresno, City of 95
- Modesto, City of 85
- Santa Rosa, City of 83
- Stockton, City of 81
- Napa, City of 81
- Huntington Beach, City of 76
- Torrance, City of 73
- Tracy, City of 73
- Santa Cruz, City of 72
- Chula Vista, City of 70
- Brentwood, City of 68
- Poway, City of 67
- San Luis Obispo, City of 66
- Newport Beach, City of 65
- Davis, City of 65
- Santa Barbara, City of 64
- Clovis, City of 62
- Glendale, City of 61
- Riverside, City of 61
- Bakersfield, City of 61
- …
DES_TP >30
- Local Park 7,486
- Local Recreation Area 1,440
- Local Other or Unknown 663
- Local Conservation Area 143
- Local Historic or Cultural Area 37
- Local Resource Management Area 6
- National Monument or Landmark 5
- None 1
- None 1
- National Forest 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
ACCESS_TYP 4
- Open Access 9,925
- Restricted Access 363
- No Public Access 207
- Unknown Access 29
MNG_AG_TYP 1
- City Agency · 10,524 ✖
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 | |||
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 | |
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 | |||
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 | ||
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 | ||
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 | |
16436 | 16436 | 16435 | {"type": "MultiPolygon", "coordinates": [[[[-118.51739, 34.02521], [-118.51653, 34.02589], [-118.51439, 34.02481], [-118.51406, 34.02525], [-118.5134, 34.02491], [-118.51238, 34.02435], [-118.51199, 34.02412], [-118.51237, 34.0237], [-118.51161, 34.0232], [-118.5112, 34.0236], [-118.51097, 34.02344], [-118.51137, 34.02304], [-118.50904, 34.02123], [-118.50859, 34.02159], [-118.50852, 34.02154], [-118.50853, 34.0215], [-118.50769, 34.02085], [-118.50809, 34.02048], [-118.50677, 34.01947], [-118.50634, 34.01983], [-118.50632, 34.01982], [-118.50673, 34.01945], [-118.50659, 34.01933], [-118.50617, 34.0197], [-118.50581, 34.01942], [-118.50622, 34.01905], [-118.50587, 34.01877], [-118.50545, 34.01913], [-118.50524, 34.01897], [-118.50565, 34.0186], [-118.50523, 34.01825], [-118.5048, 34.01862], [-118.50458, 34.01846], [-118.50501, 34.01807], [-118.50473, 34.01785], [-118.5043, 34.01822], [-118.50403, 34.01802], [-118.50448, 34.01765], [-118.50435, 34.01754], [-118.50388, 34.01791], [-118.50193, 34.01637], [-118.50222, 34.01612], [-118.50373, 34.01741], [-118.50378, 34.01738], [-118.50123, 34.01521], [-118.50097, 34.01506], [-118.49608, 34.0106], [-118.49497, 34.00952], [-118.49503, 34.00947], [-118.49498, 34.00936], [-118.4947, 34.0091], [-118.49465, 34.00908], [-118.49457, 34.00914], [-118.49188, 34.00657], [-118.49169, 34.00641], [-118.49144, 34.00614], [-118.49146, 34.00611], [-118.49135, 34.006], [-118.49133, 34.006], [-118.48736, 34.00198], [-118.48698, 34.00157], [-118.48726, 34.0014], [-118.48792, 34.00211], [-118.48814, 34.00196], [-118.48693, 34.00069], [-118.48689, 34.0007], [-118.48681, 34.00062], [-118.48676, 34.00061], [-118.48666, 34.00053], [-118.48649, 34.00059], [-118.48639, 34.00049], [-118.48652, 34.00037], [-118.48642, 34.00027], [-118.48646, 34.00024], [-118.48635, 34.00013], [-118.48638, 34.0001], [-118.48629, 33.99999], [-118.48636, 33.99995], [-118.48622, 33.99979], [-118.48628, 33.99974], [-118.4861, 33.99955], [-118.48549, 33.99996], [-118.48409, 33.99847], [-118.48355, 33.99794], [-118.48411, 33.99757], [-118.48411, 33.99755], [-118.48402, 33.99748], [-118.48387, 33.99748], [-118.48347, 33.99773], [-118.48336, 33.99775], [-118.48265, 33.99704], [-118.48266, 33.99682], [-118.48261, 33.99671], [-118.48254, 33.99663], [-118.48245, 33.99655], [-118.48212, 33.99647], [-118.48193, 33.99627], [-118.482, 33.99621], [-118.48163, 33.99581], [-118.48214, 33.99547], [-118.48257, 33.99589], [-118.48352, 33.99534], [-118.48429, 33.99629], [-118.48542, 33.99756], [-118.48626, 33.9987], [-118.48672, 33.99921], [-118.48679, 33.99935], [-118.48711, 33.99973], [-118.48732, 33.99988], [-118.48764, 34.00019], [-118.48802, 34.00047], [-118.48827, 34.00069], [-118.48869, 34.00121], [-118.48893, 34.00156], [-118.48981, 34.00261], [-118.49033, 34.00315], [-118.49117, 34.00405], [-118.49219, 34.00526], [-118.49346, 34.00642], [-118.49466, 34.00733], [-118.49572, 34.00794], [-118.49658, 34.00837], [-118.49746, 34.00864], [-118.49796, 34.00895], [-118.49851, 34.00949], [-118.49904, 34.0098], [-118.49966, 34.00998], [-118.50024, 34.0104], [-118.501, 34.01129], [-118.50147, 34.01199], [-118.50289, 34.01419], [-118.50413, 34.01521], [-118.50517, 34.0161], [-118.50641, 34.0172], [-118.50874, 34.01906], [-118.50938, 34.01951], [-118.51008, 34.02018], [-118.51093, 34.02084], [-118.51237, 34.02183], [-118.51313, 34.02238], [-118.51402, 34.02295], [-118.51468, 34.0234], [-118.51565, 34.02398], [-118.51729, 34.02516], [-118.51739, 34.02521]]], [[[-118.49294, 34.00767], [-118.49265, 34.00791], [-118.49195, 34.00725], [-118.49225, 34.00701], [-118.49294, 34.00767]]], [[[-118.49444, 34.0091], [-118.49414, 34.00934], [-118.49379, 34.00901], [-118.49409, 34.00877], [-118.49444, 34.0091]]], [[[-118.49478, 34.00943], [-118.49449, 34.00967], [-118.49432, 34.0095], [-118.49461, 34.00926], [-118.49478, 34.00943]]], [[[-118.49544, 34.01006], [-118.49512, 34.01031], [-118.49465, 34.00986], [-118.49496, 34.0096], [-118.49544, 34.01006]]], [[[-118.49751, 34.01198], [-118.49725, 34.01217], [-118.497, 34.01196], [-118.49725, 34.01176], [-118.49751, 34.01198]]], [[[-118.49825, 34.01266], [-118.49801, 34.01286], [-118.4974, 34.01231], [-118.49766, 34.01212], [-118.49825, 34.01266]]], [[[-118.50218, 34.01609], [-118.50188, 34.01633], [-118.50134, 34.0159], [-118.50043, 34.01511], [-118.5007, 34.01489], [-118.50095, 34.01512], [-118.50119, 34.01525], [-118.50218, 34.01609]]]]} | Open Access 1 | 6337 | Santa Monica State Beach | 1737 | 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 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | http://www.smgov.net/portals/beach/ | Los Angeles 6 | 204.076 | Santa Monica SB | 1948 | None 1402 | |
16256 | 16256 | 16255 | {"type": "Polygon", "coordinates": [[[-116.2991, 33.67725], [-116.29848, 33.67726], [-116.29819, 33.67781], [-116.29846, 33.67792], [-116.29847, 33.67807], [-116.29667, 33.67807], [-116.29668, 33.67762], [-116.29641, 33.67711], [-116.29615, 33.67709], [-116.29614, 33.67642], [-116.29865, 33.67642], [-116.29897, 33.6765], [-116.2991, 33.67651], [-116.2991, 33.67725]]]} | Open Access 1 | 39075 | Civic Center Campus | 17349 | 1161 | La Quinta, City of 612 | City 2 | City Agency 2 | http://www.la-quinta.org/your-government/community-services/city-parks | City 2 | 1161 | La Quinta, City of 601 | City 2 | City Agency 2 | Riverside 10 | 9.687 | Civic Ctr. Campus | None 1396 | |||
16235 | 16235 | 16234 | {"type": "Polygon", "coordinates": [[[-121.90527, 37.49358], [-121.9052, 37.49364], [-121.90471, 37.49366], [-121.90456, 37.49364], [-121.90442, 37.49372], [-121.90408, 37.49378], [-121.90368, 37.49411], [-121.90363, 37.49437], [-121.90355, 37.49439], [-121.90348, 37.49455], [-121.90325, 37.49465], [-121.90315, 37.49491], [-121.90248, 37.49516], [-121.9024, 37.49534], [-121.90229, 37.49542], [-121.90177, 37.49562], [-121.90156, 37.49585], [-121.90097, 37.49594], [-121.90084, 37.49614], [-121.90056, 37.49617], [-121.89998, 37.49613], [-121.8998, 37.49602], [-121.89974, 37.49574], [-121.89986, 37.4957], [-121.89973, 37.49537], [-121.89955, 37.49532], [-121.89943, 37.49536], [-121.89882, 37.49529], [-121.89845, 37.49496], [-121.89838, 37.49473], [-121.89801, 37.49457], [-121.89793, 37.49432], [-121.8977, 37.49424], [-121.89727, 37.49438], [-121.89699, 37.49434], [-121.89673, 37.49487], [-121.89596, 37.49633], [-121.89529, 37.49776], [-121.89423, 37.49959], [-121.87661, 37.50034], [-121.87655, 37.50024], [-121.87577, 37.49798], [-121.87328, 37.49109], [-121.8745, 37.48905], [-121.87416, 37.48824], [-121.88426, 37.48716], [-121.88426, 37.48713], [-121.88511, 37.48551], [-121.88591, 37.48351], [-121.88572, 37.48314], [-121.88587, 37.48215], [-121.88616, 37.48178], [-121.88617, 37.48153], [-121.88602, 37.48132], [-121.88578, 37.48131], [-121.88506, 37.48093], [-121.88517, 37.48071], [-121.88332, 37.47962], [-121.88417, 37.47872], [-121.88427, 37.47857], [-121.88435, 37.4784], [-121.88432, 37.4782], [-121.89052, 37.47614], [-121.89123, 37.47752], [-121.88921, 37.47817], [-121.88976, 37.47925], [-121.89093, 37.47887], [-121.89129, 37.4789], [-121.8913, 37.48002], [-121.89194, 37.47978], [-121.89223, 37.47964], [-121.89264, 37.47948], [-121.89322, 37.47935], [-121.89409, 37.4794], [-121.89446, 37.47931], [-121.89499, 37.47944], [-121.89526, 37.47959], [-121.89528, 37.48093], [-121.89506, 37.48116], [-121.89528, 37.48185], [-121.89638, 37.48301], [-121.89647, 37.48309], [-121.89662, 37.48318], [-121.89683, 37.48327], [-121.89701, 37.48331], [-121.89717, 37.48333], [-121.89718, 37.48355], [-121.89721, 37.48373], [-121.89729, 37.48393], [-121.89741, 37.48415], [-121.89758, 37.48434], [-121.89775, 37.48449], [-121.89793, 37.48461], [-121.89818, 37.48474], [-121.89803, 37.4849], [-121.89793, 37.48504], [-121.89786, 37.48522], [-121.89782, 37.4854], [-121.89782, 37.48558], [-121.89785, 37.48576], [-121.89791, 37.48594], [-121.898, 37.48609], [-121.89811, 37.48622], [-121.89824, 37.48633], [-121.89841, 37.48643], [-121.89859, 37.48651], [-121.8988, 37.48657], [-121.899, 37.48661], [-121.89922, 37.48663], [-121.89944, 37.48662], [-121.89949, 37.48682], [-121.8996, 37.48709], [-121.89974, 37.48732], [-121.89991, 37.48754], [-121.90012, 37.48773], [-121.90031, 37.48789], [-121.90053, 37.48802], [-121.9008, 37.48815], [-121.90118, 37.48828], [-121.90167, 37.48838], [-121.90203, 37.4884], [-121.90318, 37.48839], [-121.90331, 37.48903], [-121.90383, 37.4901], [-121.90369, 37.49084], [-121.90527, 37.49358]]]} | No Public Access 3 | 45940 | Hill Face Open Space City of Fremont | 29020 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 1038.333 | Hill Face OS City of Fremont | 1976 | None 1395 | ||
16197 | 16197 | 16196 | {"type": "Polygon", "coordinates": [[[-117.08623, 34.07475], [-117.08622, 34.07518], [-117.07978, 34.07482], [-117.08623, 34.07475], [-117.08623, 34.07475]]]} | Open Access 1 | 29528 | Open Space - Flood Plain | 23148 | 1269 | Redlands, City of 101 | City 2 | City Agency 2 | http://www.cityofredlands.org/ | City 2 | 1269 | Redlands, City of 99 | City 2 | City Agency 2 | San Bernardino 22 | 3.457 | OS - Flood Plain | None 1394 | |||
16181 | 16181 | 16180 | {"type": "MultiPolygon", "coordinates": [[[[-118.04589, 33.85038], [-118.04337, 33.85041], [-118.04206, 33.85041], [-118.04208, 33.85026], [-118.04213, 33.85007], [-118.04214, 33.84994], [-118.04587, 33.8499], [-118.04589, 33.85038]]], [[[-118.04201, 33.84993], [-118.04199, 33.8501], [-118.04195, 33.85022], [-118.04194, 33.85041], [-118.03746, 33.85045], [-118.03745, 33.84997], [-118.04201, 33.84993]]], [[[-118.03719, 33.85044], [-118.03307, 33.85049], [-118.03306, 33.85], [-118.03693, 33.84996], [-118.03709, 33.84997], [-118.03716, 33.84999], [-118.03718, 33.85004], [-118.03719, 33.85044]]], [[[-118.03291, 33.85049], [-118.02873, 33.85051], [-118.02872, 33.85003], [-118.0329, 33.85], [-118.03291, 33.85049]]], [[[-118.02826, 33.85055], [-118.02737, 33.85056], [-118.02736, 33.85052], [-118.02439, 33.85057], [-118.02438, 33.85008], [-118.02825, 33.85004], [-118.02826, 33.85055]]], [[[-118.02418, 33.85055], [-118.01996, 33.85059], [-118.01995, 33.85011], [-118.02418, 33.85008], [-118.02418, 33.85055]]], [[[-118.01975, 33.85061], [-118.01969, 33.85066], [-118.01968, 33.85068], [-118.01777, 33.8507], [-118.01775, 33.85014], [-118.01974, 33.85012], [-118.01975, 33.85061]]], [[[-118.01098, 33.85068], [-118.00761, 33.85072], [-118.00644, 33.85072], [-118.00648, 33.85024], [-118.00896, 33.85022], [-118.01097, 33.8502], [-118.01098, 33.85068]]]]} | Open Access 1 | 28331 | El Rancho Verde Open Space Corridor | 29980 | 1159 | La Palma, City of 635 | City 2 | City Agency 2 | http://www.cityoflapalma.org/index.aspx?nid=225 | City 2 | 1159 | La Palma, City of 624 | City 2 | City Agency 2 | Orange 3 | 38.522 | El Rancho Verde OS Corridor | 0 | None 1392 | ||
16179 | 16179 | 16178 | {"type": "Polygon", "coordinates": [[[-121.44009, 39.01395], [-121.44006, 39.01396], [-121.43968, 39.01366], [-121.43961, 39.01365], [-121.43959, 39.01361], [-121.43962, 39.01356], [-121.43863, 39.01196], [-121.43883, 39.01188], [-121.44009, 39.01395]]]} | Open Access 1 | 22171 | Open Space Path to Park | 23149 | 1379 | Wheatland, City of 569 | City 2 | City Agency 2 | http://www.wheatland.ca.gov/ | City 2 | 1379 | Wheatland, City of 561 | City 2 | City Agency 2 | Yuba 25 | 1.088 | OS Path to Park | None 1391 | |||
16124 | 16124 | 16123 | {"type": "Polygon", "coordinates": [[[-122.46579, 37.89233], [-122.46575, 37.89237], [-122.46477, 37.89165], [-122.46485, 37.89155], [-122.46516, 37.89151], [-122.46534, 37.89166], [-122.46538, 37.89171], [-122.46544, 37.89207], [-122.46579, 37.89233]]]} | Open Access 1 | 16201 | Agins Subdivision Open Space Dedication | 15286 | 1348 | Tiburon, Town of 486 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | Marin 23 | 0.542 | Agins Subdivision OS Dedication | None 1386 | |||
16104 | 16104 | 16103 | {"type": "Polygon", "coordinates": [[[-117.8334, 34.03678], [-117.83333, 34.03689], [-117.83325, 34.03705], [-117.83301, 34.03783], [-117.83295, 34.03795], [-117.83288, 34.03805], [-117.83275, 34.03817], [-117.83252, 34.03829], [-117.8323, 34.03834], [-117.83215, 34.03835], [-117.83339, 34.03677], [-117.8334, 34.03678]], [[-117.83253, 34.03812], [-117.83253, 34.0381], [-117.83246, 34.03805], [-117.83231, 34.03819], [-117.83239, 34.03825], [-117.83253, 34.03812]]]} | Open Access 1 | 12743 | Walnut City Open Space Lands | 27223 | 1370 | Walnut, City of 317 | City 2 | City Agency 2 | http://www.ci.walnut.ca.us/general.asp?id=135 | City 2 | 1370 | Walnut, City of 314 | City 2 | City Agency 2 | Los Angeles 6 | 1.048 | Walnut City OS Lands | None 1381 | |||
16103 | 16103 | 16102 | {"type": "Polygon", "coordinates": [[[-117.85032, 34.04877], [-117.8498, 34.04895], [-117.84968, 34.04888], [-117.84956, 34.04888], [-117.84951, 34.0489], [-117.84932, 34.04901], [-117.84922, 34.04908], [-117.84912, 34.04919], [-117.84901, 34.04937], [-117.84864, 34.04929], [-117.84874, 34.04906], [-117.84883, 34.0489], [-117.84897, 34.04873], [-117.8492, 34.04849], [-117.84951, 34.04826], [-117.84967, 34.04816], [-117.84991, 34.04805], [-117.84999, 34.04806], [-117.85002, 34.04809], [-117.85032, 34.04877]]]} | Open Access 1 | 12742 | Walnut City Open Space Lands | 27223 | 1370 | Walnut, City of 317 | City 2 | City Agency 2 | http://www.ci.walnut.ca.us/general.asp?id=135 | City 2 | 1370 | Walnut, City of 314 | City 2 | City Agency 2 | Los Angeles 6 | 2.443 | Walnut City OS Lands | None 1380 |
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]);