units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
143 rows where DES_TP = 4 and MNG_AG_TYP = 2 sorted by rowid descending
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 9
- Watsonville, City of 5
- Redlands, City of 5
- Los Angeles, City of 4
- Glendora, City of 4
- Burbank, City of 4
- Palo Alto, City of 4
- Carlsbad, City of 3
- La Verne, City of 3
- Gilroy, City of 3
- Chico, City of 3
- Roseville, City of 3
- Claremont, City of 2
- Santa Barbara, City of 2
- Fullerton, City of 2
- Riverside, City of 2
- Rolling Hills Estates, City of 2
- Rancho Palos Verdes, City of 2
- Long Beach, City of 2
- Sierra Madre, City of 2
- Murrieta, City of 2
- Sacramento, City of 2
- Arcata, City of 2
- Sebastopol, City of 2
- Oakdale, City of 1
- Santa Cruz, City of 1
- Lancaster, City of 1
- San Francisco, City and County of 1
- San Luis Obispo, City of 1
- Santa Rosa, City of 1
- …
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency · 123 ✖
DES_TP 1
- Local Conservation Area · 123 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14680 | 14680 | 14679 | {"type": "Polygon", "coordinates": [[[-118.19722, 34.66567], [-118.19715, 34.66672], [-118.19712, 34.66685], [-118.19704, 34.66703], [-118.19701, 34.66714], [-118.197, 34.6675], [-118.19464, 34.66751], [-118.19464, 34.66842], [-118.1924, 34.66844], [-118.19241, 34.67111], [-118.19025, 34.6711], [-118.19022, 34.66753], [-118.19238, 34.66752], [-118.19238, 34.6657], [-118.19722, 34.66567]]]} | Open Access 1 | 44988 | Prime Desert Woodland Preserve | 24002 | 1169 | Lancaster, City of 11 | City 2 | City Agency 2 | http://www.cityoflancasterca.org/index.aspx?page=23 | City 2 | 1169 | Lancaster, City of 11 | City 2 | City Agency 2 | Los Angeles 6 | 46.397 | Prime Desert Woodland Preserve | 0 | Local Conservation Area 4 | 2 | |
14656 | 14656 | 14655 | {"type": "Polygon", "coordinates": [[[-122.26076, 38.07691], [-122.26064, 38.0769], [-122.26063, 38.07694], [-122.25758, 38.07677], [-122.2557, 38.07638], [-122.25595, 38.07779], [-122.2569, 38.07836], [-122.25772, 38.0818], [-122.25793, 38.08285], [-122.25917, 38.08302], [-122.25879, 38.08349], [-122.25825, 38.08339], [-122.25824, 38.0834], [-122.25873, 38.08378], [-122.25901, 38.08386], [-122.26016, 38.08403], [-122.25886, 38.0844], [-122.26004, 38.08473], [-122.25888, 38.08472], [-122.2582, 38.08463], [-122.25799, 38.08463], [-122.25783, 38.08472], [-122.25682, 38.08369], [-122.25648, 38.08233], [-122.25642, 38.0818], [-122.25625, 38.08136], [-122.25608, 38.08105], [-122.2553, 38.08068], [-122.25544, 38.08059], [-122.25543, 38.08058], [-122.25322, 38.07996], [-122.25387, 38.0795], [-122.25321, 38.07877], [-122.25264, 38.07903], [-122.2507, 38.07665], [-122.25133, 38.0765], [-122.25284, 38.0755], [-122.25368, 38.07531], [-122.25483, 38.0753], [-122.25564, 38.07534], [-122.25591, 38.07527], [-122.25604, 38.07515], [-122.25659, 38.07432], [-122.25704, 38.07441], [-122.25737, 38.07472], [-122.25771, 38.07484], [-122.25796, 38.07497], [-122.25807, 38.07533], [-122.25857, 38.07549], [-122.25899, 38.07592], [-122.25921, 38.076], [-122.25952, 38.0763], [-122.26039, 38.07621], [-122.26043, 38.07599], [-122.2605, 38.07594], [-122.26059, 38.07596], [-122.26042, 38.07647], [-122.26076, 38.07691]]]} | Open Access 1 | 44916 | Mare Island Shoreline Heritage Preserve | 21800 | 1365 | Vallejo, City of 531 | City 2 | City Agency 2 | http://www.ci.vallejo.ca.us/attractions___events/sports___recreation/parks___trails | City 2 | 1365 | Vallejo, City of 524 | City 2 | City Agency 2 | Solano 26 | 83.482 | Mare Island Shoreline Heritage Preserve | 0 | Local Conservation Area 4 | 2 | |
14632 | 14632 | 14631 | {"type": "Polygon", "coordinates": [[[-121.57824, 36.98649], [-121.57805, 36.98652], [-121.57788, 36.98656], [-121.57773, 36.98664], [-121.57749, 36.9868], [-121.57735, 36.98687], [-121.5772, 36.98691], [-121.57689, 36.98694], [-121.57673, 36.98698], [-121.57658, 36.98703], [-121.57644, 36.98711], [-121.57627, 36.98726], [-121.57614, 36.98744], [-121.57609, 36.98755], [-121.57599, 36.98788], [-121.57592, 36.988], [-121.57582, 36.98811], [-121.57563, 36.98822], [-121.57541, 36.98829], [-121.57491, 36.98831], [-121.57473, 36.98833], [-121.57449, 36.98843], [-121.57435, 36.98852], [-121.57413, 36.98871], [-121.57394, 36.9888], [-121.57379, 36.98884], [-121.57362, 36.98885], [-121.57354, 36.98878], [-121.57354, 36.98841], [-121.57386, 36.98828], [-121.57385, 36.98795], [-121.57409, 36.98792], [-121.57485, 36.98791], [-121.57503, 36.98787], [-121.57529, 36.98776], [-121.57543, 36.98767], [-121.57556, 36.98755], [-121.57604, 36.98688], [-121.57615, 36.98678], [-121.57629, 36.98669], [-121.57645, 36.98662], [-121.57679, 36.98654], [-121.57733, 36.98632], [-121.57734, 36.98649], [-121.57824, 36.98649]]]} | Open Access 1 | 44895 | Babbs Creek Park Preserve | 15743 | 1118 | Gilroy, City of 407 | City 2 | City Agency 2 | http://www.cityofgilroy.org/cityofgilroy/community/parks/default.aspx | City 2 | 1118 | Gilroy, City of 401 | City 2 | City Agency 2 | Santa Clara 19 | 5.752 | Babbs Creek Park Preserve | 0 | Local Conservation Area 4 | 2 | |
14489 | 14489 | 14488 | {"type": "Polygon", "coordinates": [[[-121.95603, 37.54103], [-121.95584, 37.5411], [-121.95561, 37.53966], [-121.95519, 37.5368], [-121.9548, 37.53434], [-121.95503, 37.53453], [-121.95537, 37.53662], [-121.95603, 37.54103]]]} | Open Access 1 | 47148 | East Bay Greenway Trail Corridor | 30830 | 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 | 3.364 | East Bay Greenway Trail Corridor | 0 | Local Conservation Area 4 | 2 | |
14468 | 14468 | 14467 | {"type": "MultiPolygon", "coordinates": [[[[-117.29626, 33.92407], [-117.29615, 33.92376], [-117.296, 33.92348], [-117.29579, 33.92318], [-117.29557, 33.92294], [-117.29533, 33.92272], [-117.2951, 33.92255], [-117.29343, 33.92152], [-117.29311, 33.92127], [-117.29286, 33.92103], [-117.29264, 33.92076], [-117.29247, 33.92047], [-117.29234, 33.92017], [-117.29282, 33.92017], [-117.29336, 33.92028], [-117.29562, 33.92026], [-117.29625, 33.92143], [-117.29626, 33.92407]]], [[[-117.30959, 33.92395], [-117.30437, 33.92747], [-117.30115, 33.92705], [-117.30114, 33.92402], [-117.30959, 33.92395]]], [[[-117.33562, 33.9346], [-117.33559, 33.9351], [-117.33551, 33.93552], [-117.33539, 33.93593], [-117.33518, 33.93638], [-117.33498, 33.93673], [-117.33474, 33.93705], [-117.3337, 33.93822], [-117.33121, 33.93822], [-117.33119, 33.94092], [-117.33065, 33.94196], [-117.33015, 33.94236], [-117.33016, 33.94288], [-117.32975, 33.94328], [-117.32976, 33.94413], [-117.32953, 33.94449], [-117.32994, 33.94506], [-117.32971, 33.94594], [-117.33007, 33.94647], [-117.33007, 33.94662], [-117.32252, 33.9466], [-117.32248, 33.95022], [-117.32246, 33.95383], [-117.31984, 33.95381], [-117.31985, 33.95479], [-117.31914, 33.95501], [-117.31879, 33.95514], [-117.31848, 33.95528], [-117.31788, 33.95558], [-117.31607, 33.95659], [-117.31599, 33.95657], [-117.31589, 33.95643], [-117.31581, 33.95628], [-117.31577, 33.95613], [-117.31575, 33.95596], [-117.31639, 33.956], [-117.31665, 33.95545], [-117.31698, 33.95521], [-117.31697, 33.95499], [-117.31702, 33.95409], [-117.3164, 33.95331], [-117.3159, 33.95295], [-117.3155, 33.95276], [-117.31453, 33.95269], [-117.31439, 33.95313], [-117.31415, 33.9531], [-117.3138, 33.95309], [-117.31379, 33.95308], [-117.31335, 33.95305], [-117.31309, 33.95299], [-117.31281, 33.95289], [-117.31262, 33.95277], [-117.31246, 33.95266], [-117.31232, 33.95253], [-117.3122, 33.95238], [-117.31205, 33.95211], [-117.3119, 33.95163], [-117.31181, 33.95145], [-117.31167, 33.95123], [-117.31149, 33.95103], [-117.31122, 33.95082], [-117.31051, 33.95041], [-117.31021, 33.95026], [-117.30986, 33.95012], [-117.31142, 33.95011], [-117.31151, 33.94987], [-117.31166, 33.94926], [-117.31159, 33.94868], [-117.31147, 33.94823], [-117.31127, 33.94783], [-117.31085, 33.94738], [-117.31096, 33.94681], [-117.31095, 33.94594], [-117.31109, 33.94572], [-117.31116, 33.94534], [-117.31123, 33.94418], [-117.31165, 33.94369], [-117.3132, 33.94256], [-117.31351, 33.94194], [-117.31279, 33.93981], [-117.30957, 33.93997], [-117.30958, 33.93677], [-117.30965, 33.93675], [-117.30972, 33.93672], [-117.30976, 33.93666], [-117.30977, 33.9366], [-117.30976, 33.93654], [-117.30972, 33.93649], [-117.30965, 33.93645], [-117.30958, 33.93644], [-117.30958, 33.93079], [-117.30897, 33.93001], [-117.30686, 33.92858], [-117.30672, 33.92804], [-117.30627, 33.92775], [-117.30537, 33.92764], [-117.30512, 33.92764], [-117.30511, 33.92756], [-117.30473, 33.92752], [-117.31001, 33.92395], [-117.31387, 33.92391], [-117.31395, 33.92761], [-117.31828, 33.92758], [-117.31828, 33.9271], [-117.31921, 33.92679], [-117.31945, 33.92714], [-117.31876, 33.92788], [-117.3176, 33.92842], [-117.31763, 33.92921], [-117.31949, 33.93068], [-117.32109, 33.93119], [-117.32288, 33.93116], [-117.32337, 33.9319], [-117.32445, 33.93227], [-117.32515, 33.93244], [-117.32669, 33.93222], [-117.32664, 33.92973], [-117.33128, 33.92966], [-117.33128, 33.93101], [-117.33347, 33.93101], [-117.33346, 33.9328], [-117.33455, 33.9328], [-117.33454, 33.9346], [-117.33562, 33.9346]]]]} | Open Access 1 | 47099 | Sycamore Canyon Wilderness Park | 30758 | 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 | 1281.186 | Sycamore Canyon Wilderness Park | 0 | Local Conservation Area 4 | 2 | |
14366 | 14366 | 14365 | {"type": "MultiPolygon", "coordinates": [[[[-124.0907, 40.87504], [-124.09043, 40.87498], [-124.09043, 40.87491], [-124.09035, 40.87489], [-124.0905, 40.87451], [-124.0907, 40.87504]]], [[[-124.09106, 40.87533], [-124.09096, 40.87542], [-124.09102, 40.87562], [-124.09096, 40.87576], [-124.09097, 40.87604], [-124.09089, 40.87657], [-124.09081, 40.8764], [-124.09075, 40.8762], [-124.09062, 40.87551], [-124.09044, 40.87505], [-124.09103, 40.87517], [-124.09106, 40.87533]]], [[[-124.09083, 40.87428], [-124.09074, 40.87443], [-124.09073, 40.87459], [-124.09067, 40.87467], [-124.09055, 40.87437], [-124.0906, 40.87423], [-124.09083, 40.87428]]]]} | Open Access 1 | 47025 | Dellanina Nature Preserve | 30674 | 1432 | Arcata, City of 587 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | Humboldt 45 | 1.331 | Dellanina Nature Preserve | 0 | Local Conservation Area 4 | 2 | |
14069 | 14069 | 14068 | {"type": "Polygon", "coordinates": [[[-116.31953, 33.65617], [-116.32016, 33.6585], [-116.3202, 33.6588], [-116.32022, 33.6591], [-116.32022, 33.65941], [-116.32019, 33.65971], [-116.32012, 33.66008], [-116.32001, 33.66045], [-116.31986, 33.66081], [-116.31967, 33.66116], [-116.31951, 33.6614], [-116.31829, 33.66299], [-116.31802, 33.66342], [-116.31803, 33.66343], [-116.31811, 33.66343], [-116.31796, 33.66386], [-116.31783, 33.66438], [-116.31776, 33.66491], [-116.31774, 33.66544], [-116.31777, 33.66597], [-116.31786, 33.6665], [-116.31807, 33.66701], [-116.31724, 33.66614], [-116.31706, 33.6659], [-116.31692, 33.66566], [-116.31681, 33.6654], [-116.31671, 33.66501], [-116.31668, 33.66465], [-116.3167, 33.66433], [-116.31675, 33.66411], [-116.31682, 33.66389], [-116.31691, 33.66367], [-116.31704, 33.66343], [-116.31735, 33.66303], [-116.31797, 33.66244], [-116.31817, 33.66222], [-116.31838, 33.6619], [-116.31856, 33.6615], [-116.31863, 33.66127], [-116.31942, 33.65795], [-116.31946, 33.65772], [-116.31948, 33.65736], [-116.31944, 33.65703], [-116.31938, 33.65676], [-116.31918, 33.65617], [-116.31953, 33.65617]]]} | Open Access 1 | 39078 | Fred Wolff Nature Preserve | 19077 | 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 | 22.526 | Fred Wolff Nature Preserve | 0 | Local Conservation Area 4 | 2 | |
14022 | 14022 | 14021 | {"type": "Polygon", "coordinates": [[[-121.96133, 37.4083], [-121.96132, 37.40834], [-121.96127, 37.4084], [-121.961, 37.40863], [-121.96084, 37.4088], [-121.96041, 37.4094], [-121.9599, 37.40918], [-121.95662, 37.40804], [-121.95591, 37.40775], [-121.9554, 37.40749], [-121.95485, 37.40715], [-121.95433, 37.40676], [-121.95376, 37.40626], [-121.95343, 37.40591], [-121.95318, 37.4056], [-121.95296, 37.40528], [-121.95273, 37.40489], [-121.9525, 37.40458], [-121.95219, 37.40423], [-121.95183, 37.4039], [-121.95371, 37.4031], [-121.95399, 37.40346], [-121.95417, 37.40364], [-121.95436, 37.40379], [-121.95467, 37.404], [-121.95566, 37.40454], [-121.95582, 37.40464], [-121.95597, 37.40478], [-121.95617, 37.405], [-121.95649, 37.40543], [-121.95668, 37.40565], [-121.95757, 37.40687], [-121.95772, 37.40703], [-121.95789, 37.40717], [-121.95815, 37.40732], [-121.95945, 37.40794], [-121.95971, 37.40801], [-121.96001, 37.40806], [-121.96075, 37.40805], [-121.96095, 37.40806], [-121.96106, 37.4081], [-121.96124, 37.4082], [-121.9613, 37.40825], [-121.96133, 37.4083]]]} | Open Access 1 | 38013 | Ulistac Natural Area | 26648 | 1318 | Santa Clara, City of 401 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | Santa Clara 19 | 42.464 | Ulistac Natural Area | 0 | Local Conservation Area 4 | 2 | |
13899 | 13899 | 13898 | {"type": "Polygon", "coordinates": [[[-121.7736, 36.90511], [-121.77056, 36.90721], [-121.77033, 36.90877], [-121.77033, 36.90885], [-121.7704, 36.90898], [-121.77059, 36.90911], [-121.77068, 36.90926], [-121.7708, 36.90935], [-121.77111, 36.90952], [-121.76947, 36.90947], [-121.76947, 36.90919], [-121.76878, 36.90923], [-121.76876, 36.90919], [-121.76916, 36.90906], [-121.76915, 36.90904], [-121.76899, 36.90903], [-121.76903, 36.90896], [-121.76906, 36.90887], [-121.76904, 36.90873], [-121.76945, 36.90828], [-121.76949, 36.90796], [-121.76968, 36.90783], [-121.76914, 36.90683], [-121.77055, 36.90589], [-121.77139, 36.90613], [-121.77341, 36.90474], [-121.7736, 36.90511]]]} | Open Access 1 | 36509 | Watsonville Slough | 28585 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 13.721 | Watsonville Slough | 0 | Local Conservation Area 4 | 2 | |
13794 | 13794 | 13793 | {"type": "Polygon", "coordinates": [[[-122.28173, 38.30282], [-122.28177, 38.30281], [-122.28187, 38.30284], [-122.28199, 38.30295], [-122.28213, 38.30313], [-122.2823, 38.30365], [-122.28241, 38.30419], [-122.2824, 38.30431], [-122.28236, 38.30442], [-122.28231, 38.3047], [-122.28223, 38.305], [-122.28213, 38.30518], [-122.28199, 38.30533], [-122.28194, 38.30541], [-122.2816, 38.30576], [-122.2815, 38.30588], [-122.28044, 38.3068], [-122.28003, 38.30667], [-122.2801, 38.3057], [-122.28032, 38.30569], [-122.28044, 38.30503], [-122.28063, 38.30497], [-122.28081, 38.30483], [-122.28096, 38.30459], [-122.28097, 38.30452], [-122.28111, 38.30437], [-122.28133, 38.30392], [-122.28154, 38.30356], [-122.28157, 38.30317], [-122.28173, 38.30282]]]} | Open Access 1 | 36362 | Oxbow Preserve | 28577 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 10.376 | Oxbow Preserve | 0 | Local Conservation Area 4 | 2 | |
13707 | 13707 | 13706 | {"type": "MultiPolygon", "coordinates": [[[[-121.77899, 39.72934], [-121.77873, 39.7295], [-121.77861, 39.72949], [-121.77845, 39.72935], [-121.77833, 39.72941], [-121.77802, 39.72945], [-121.77802, 39.72992], [-121.77386, 39.73195], [-121.77333, 39.73185], [-121.77331, 39.73068], [-121.77334, 39.73068], [-121.77335, 39.73104], [-121.774, 39.73102], [-121.774, 39.73091], [-121.77429, 39.73083], [-121.77467, 39.7308], [-121.77522, 39.73068], [-121.77551, 39.73065], [-121.7756, 39.73059], [-121.77563, 39.7305], [-121.77637, 39.7305], [-121.7766, 39.73038], [-121.77672, 39.73037], [-121.77679, 39.73031], [-121.77722, 39.73031], [-121.77722, 39.72916], [-121.77802, 39.72915], [-121.77816, 39.72911], [-121.77822, 39.72906], [-121.77828, 39.72898], [-121.77839, 39.72893], [-121.779, 39.72921], [-121.77902, 39.72924], [-121.77899, 39.72934]]], [[[-121.77943, 39.72965], [-121.77914, 39.72969], [-121.77906, 39.72935], [-121.77909, 39.72928], [-121.77916, 39.72927], [-121.77929, 39.72931], [-121.77934, 39.72935], [-121.77936, 39.72938], [-121.77938, 39.72952], [-121.77943, 39.72965]]], [[[-121.78023, 39.72944], [-121.78012, 39.72956], [-121.77961, 39.72963], [-121.77955, 39.72949], [-121.77953, 39.72935], [-121.77949, 39.72928], [-121.7794, 39.7292], [-121.77925, 39.72915], [-121.77922, 39.72911], [-121.77943, 39.72877], [-121.77961, 39.7286], [-121.77975, 39.72853], [-121.77987, 39.72849], [-121.7802, 39.72843], [-121.78028, 39.7287], [-121.7802, 39.72884], [-121.78021, 39.72903], [-121.78013, 39.72912], [-121.7799, 39.72917], [-121.77988, 39.72918], [-121.78023, 39.72944]]]]} | Open Access 1 | 36082 | Hillview Preserve | 19996 | 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 | 9.976 | Hillview Preserve | 0 | Local Conservation Area 4 | 2 | |
13669 | 13669 | 13668 | {"type": "Polygon", "coordinates": [[[-122.32205, 40.55148], [-122.32199, 40.55645], [-122.3148, 40.55648], [-122.31478, 40.55437], [-122.31469, 40.55436], [-122.31468, 40.55392], [-122.31465, 40.55367], [-122.31461, 40.55302], [-122.31457, 40.55291], [-122.31451, 40.55278], [-122.31431, 40.55258], [-122.3141, 40.55241], [-122.31391, 40.55227], [-122.31346, 40.55207], [-122.31328, 40.55193], [-122.31297, 40.55162], [-122.31212, 40.55114], [-122.31165, 40.55096], [-122.31126, 40.55071], [-122.31081, 40.55051], [-122.3106, 40.55038], [-122.30834, 40.54925], [-122.31485, 40.54923], [-122.31486, 40.54926], [-122.31508, 40.54926], [-122.31556, 40.54969], [-122.31615, 40.54982], [-122.31622, 40.54973], [-122.31576, 40.54931], [-122.31848, 40.54931], [-122.31848, 40.54977], [-122.31852, 40.54977], [-122.31852, 40.55097], [-122.31848, 40.55102], [-122.31848, 40.55103], [-122.32024, 40.552], [-122.32066, 40.55188], [-122.32067, 40.55147], [-122.32205, 40.55148]]]} | Open Access 1 | 36037 | Clover Creek Preserve | 17436 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 127.579 | Clover Creek Preserve | 0 | Local Conservation Area 4 | 2 | |
13642 | 13642 | 13641 | {"type": "MultiPolygon", "coordinates": [[[[-121.18821, 38.69751], [-121.18796, 38.69788], [-121.18743, 38.69852], [-121.1872, 38.69842], [-121.1847, 38.69719], [-121.18512, 38.6954], [-121.18515, 38.69494], [-121.18498, 38.69438], [-121.18495, 38.69431], [-121.18437, 38.69352], [-121.18388, 38.69307], [-121.18309, 38.69262], [-121.18226, 38.69195], [-121.18229, 38.68996], [-121.18261, 38.69034], [-121.18366, 38.69038], [-121.18369, 38.69063], [-121.18319, 38.69105], [-121.18342, 38.69163], [-121.18432, 38.69187], [-121.18482, 38.69223], [-121.18559, 38.69269], [-121.18591, 38.69281], [-121.1861, 38.69247], [-121.18614, 38.69249], [-121.18576, 38.69327], [-121.1861, 38.6939], [-121.18658, 38.69391], [-121.18664, 38.69393], [-121.18689, 38.6948], [-121.18688, 38.69523], [-121.18671, 38.69569], [-121.18638, 38.69603], [-121.18627, 38.69643], [-121.18661, 38.69693], [-121.18675, 38.69697], [-121.18726, 38.69684], [-121.18821, 38.69751]]], [[[-121.18563, 38.68925], [-121.18556, 38.68927], [-121.18542, 38.68899], [-121.1852, 38.68874], [-121.18494, 38.68852], [-121.18397, 38.68802], [-121.18341, 38.68827], [-121.18328, 38.68906], [-121.18311, 38.68914], [-121.18287, 38.68914], [-121.18283, 38.68954], [-121.18291, 38.68968], [-121.18285, 38.6897], [-121.18276, 38.68956], [-121.18232, 38.68937], [-121.18246, 38.68625], [-121.18269, 38.68643], [-121.18341, 38.68683], [-121.18381, 38.68688], [-121.18423, 38.68659], [-121.18464, 38.68638], [-121.18515, 38.68636], [-121.18468, 38.68665], [-121.18442, 38.68706], [-121.18448, 38.68747], [-121.18487, 38.6883], [-121.18546, 38.68893], [-121.18563, 38.68925]]]]} | Open Access 1 | 36009 | Hinkle Creek Nature Area | 20002 | 1108 | Folsom, City of 565 | City 2 | City Agency 2 | http://www.folsom.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1108 | Folsom, City of 557 | City 2 | City Agency 2 | Sacramento 41 | 45.196 | Hinkle Creek Nature Area | 0 | Local Conservation Area 4 | 2 | |
12737 | 12737 | 12736 | {"type": "Polygon", "coordinates": [[[-121.58177, 36.99424], [-121.58128, 36.99477], [-121.58054, 36.99548], [-121.58009, 36.99522], [-121.57938, 36.99487], [-121.57938, 36.99428], [-121.57656, 36.99303], [-121.57636, 36.99289], [-121.57636, 36.99286], [-121.57621, 36.99278], [-121.57619, 36.99279], [-121.57606, 36.99269], [-121.57594, 36.99264], [-121.57586, 36.99261], [-121.57369, 36.99262], [-121.57301, 36.99274], [-121.57263, 36.99262], [-121.57205, 36.99225], [-121.57161, 36.99224], [-121.57148, 36.99217], [-121.5713, 36.99211], [-121.57116, 36.99209], [-121.57096, 36.9921], [-121.57165, 36.992], [-121.57202, 36.99192], [-121.57294, 36.99262], [-121.57369, 36.99248], [-121.57369, 36.99206], [-121.57546, 36.99163], [-121.57686, 36.99256], [-121.57938, 36.99376], [-121.5794, 36.99375], [-121.57939, 36.99313], [-121.58013, 36.99361], [-121.5813, 36.99402], [-121.58177, 36.99424]]]} | Open Access 1 | 29769 | Uvas Creek Park Preserve | 30316 | 1118 | Gilroy, City of 407 | City 2 | City Agency 2 | http://www.cityofgilroy.org/cityofgilroy/community/parks/default.aspx | City 2 | 1118 | Gilroy, City of 401 | City 2 | City Agency 2 | Santa Clara 19 | 17.866 | Uvas Creek Park Preserve | 0 | Local Conservation Area 4 | 2 | |
12639 | 12639 | 12638 | {"type": "Polygon", "coordinates": [[[-121.30026, 38.79227], [-121.30023, 38.79305], [-121.29371, 38.78839], [-121.29355, 38.7888], [-121.29311, 38.78954], [-121.29308, 38.78965], [-121.29301, 38.79074], [-121.29284, 38.79061], [-121.29194, 38.7901], [-121.29214, 38.78992], [-121.29216, 38.78884], [-121.29193, 38.78862], [-121.29199, 38.78839], [-121.29221, 38.78817], [-121.29201, 38.78784], [-121.29298, 38.78674], [-121.29257, 38.78589], [-121.29243, 38.78543], [-121.29201, 38.78533], [-121.29208, 38.78461], [-121.29138, 38.78388], [-121.2904, 38.78326], [-121.29028, 38.78266], [-121.29035, 38.78211], [-121.29021, 38.78146], [-121.2901, 38.78134], [-121.28912, 38.78136], [-121.2884, 38.78154], [-121.28729, 38.78154], [-121.28732, 38.78083], [-121.28738, 38.78036], [-121.28745, 38.78003], [-121.28755, 38.77972], [-121.28865, 38.77989], [-121.28946, 38.77918], [-121.28969, 38.7793], [-121.29091, 38.78004], [-121.29051, 38.78043], [-121.2908, 38.78103], [-121.29073, 38.78109], [-121.2908, 38.78127], [-121.29081, 38.78144], [-121.29069, 38.78285], [-121.29072, 38.783], [-121.29076, 38.78306], [-121.29113, 38.78323], [-121.29119, 38.78326], [-121.29135, 38.78326], [-121.29152, 38.7833], [-121.29174, 38.78342], [-121.29181, 38.78349], [-121.29244, 38.78452], [-121.29279, 38.78471], [-121.29336, 38.78479], [-121.29425, 38.78549], [-121.29444, 38.78608], [-121.29373, 38.78639], [-121.29385, 38.78769], [-121.30026, 38.79227]]]} | Open Access 1 | 29463 | Wetlands | 27445 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 50.045 | Wetlands | 0 | Local Conservation Area 4 | 2 | |
12368 | 12368 | 12367 | {"type": "Polygon", "coordinates": [[[-122.81825, 38.40854], [-122.81815, 38.40879], [-122.81802, 38.40903], [-122.81771, 38.40944], [-122.81761, 38.40955], [-122.81723, 38.40989], [-122.81689, 38.41011], [-122.81676, 38.41022], [-122.81642, 38.41022], [-122.8171, 38.40934], [-122.81709, 38.40932], [-122.81257, 38.40934], [-122.81258, 38.40564], [-122.81277, 38.40543], [-122.81323, 38.40525], [-122.81293, 38.4047], [-122.81573, 38.4037], [-122.81636, 38.40354], [-122.81639, 38.40358], [-122.81665, 38.40373], [-122.8168, 38.40416], [-122.81718, 38.40598], [-122.81793, 38.40805], [-122.81792, 38.40819], [-122.81763, 38.40819], [-122.81772, 38.40847], [-122.81769, 38.40854], [-122.81825, 38.40854]]]} | Open Access 1 | 26070 | Laguna de Santa Rosa Wetlands Preserve | 20853 | 1331 | Sebastopol, City of 605 | City 2 | City Agency 2 | http://ci.sebastopol.ca.us/page/city-parks | City 2 | 1331 | Sebastopol, City of 594 | City 2 | City Agency 2 | Sonoma 16 | 61.2 | Laguna de Santa Rosa Wetlands Preserve | 0 | Local Conservation Area 4 | 2 | |
12219 | 12219 | 12218 | {"type": "Polygon", "coordinates": [[[-123.79557, 39.44475], [-123.79553, 39.44475], [-123.79546, 39.44488], [-123.79492, 39.44513], [-123.79494, 39.4454], [-123.79333, 39.4454], [-123.79327, 39.4443], [-123.79328, 39.44402], [-123.79347, 39.44402], [-123.79348, 39.44405], [-123.79384, 39.44405], [-123.79385, 39.4441], [-123.79413, 39.44409], [-123.79414, 39.44415], [-123.79491, 39.44414], [-123.79491, 39.44408], [-123.79531, 39.44407], [-123.79532, 39.4442], [-123.79557, 39.4442], [-123.79557, 39.44475]]]} | Open Access 1 | 25413 | Otis R. Johnson Wilderness Park | 23267 | 1412 | Fort Bragg, City of 889 | City 2 | City Agency 2 | http://city.fortbragg.com/ | City 2 | 1412 | Fort Bragg, City of 864 | City 2 | City Agency 2 | Mendocino 24 | 6.276 | Otis R. Johnson Wilderness Park | 0 | Local Conservation Area 4 | 2 | |
12214 | 12214 | 12213 | {"type": "MultiPolygon", "coordinates": [[[[-124.0922, 40.85233], [-124.09217, 40.85237], [-124.09208, 40.85261], [-124.09198, 40.85277], [-124.09195, 40.85289], [-124.09192, 40.85295], [-124.09191, 40.85305], [-124.09182, 40.85328], [-124.09181, 40.85336], [-124.09173, 40.85337], [-124.09169, 40.85341], [-124.09169, 40.85343], [-124.09173, 40.85348], [-124.09167, 40.85366], [-124.09157, 40.85371], [-124.09157, 40.85374], [-124.09162, 40.85379], [-124.09161, 40.85386], [-124.09154, 40.85392], [-124.09147, 40.85408], [-124.09139, 40.8543], [-124.09136, 40.85443], [-124.09125, 40.85461], [-124.09119, 40.85468], [-124.0911, 40.85476], [-124.09093, 40.85484], [-124.09088, 40.8549], [-124.09081, 40.8549], [-124.09077, 40.85493], [-124.09069, 40.85491], [-124.09058, 40.85492], [-124.08966, 40.8546], [-124.08891, 40.85519], [-124.08854, 40.85492], [-124.0858, 40.85304], [-124.08464, 40.85214], [-124.08416, 40.85171], [-124.08351, 40.85098], [-124.0832, 40.85056], [-124.08307, 40.85033], [-124.08348, 40.85033], [-124.08347, 40.85012], [-124.08388, 40.84935], [-124.08421, 40.84866], [-124.08428, 40.84847], [-124.08437, 40.84857], [-124.08442, 40.84867], [-124.08445, 40.84869], [-124.08445, 40.8488], [-124.0845, 40.84884], [-124.08457, 40.84887], [-124.08451, 40.84889], [-124.08454, 40.84892], [-124.08452, 40.84895], [-124.08462, 40.849], [-124.08463, 40.84906], [-124.08462, 40.8491], [-124.08468, 40.8492], [-124.0847, 40.8493], [-124.08472, 40.84932], [-124.08477, 40.84932], [-124.08488, 40.84929], [-124.08491, 40.8493], [-124.08493, 40.84933], [-124.08491, 40.84935], [-124.08487, 40.84935], [-124.08491, 40.84939], [-124.08488, 40.84946], [-124.0849, 40.84948], [-124.08499, 40.84946], [-124.08497, 40.8494], [-124.08498, 40.84938], [-124.085, 40.84942], [-124.08506, 40.84946], [-124.08527, 40.84947], [-124.0863, 40.84945], [-124.08703, 40.8494], [-124.08735, 40.84934], [-124.08737, 40.84938], [-124.08739, 40.84939], [-124.08747, 40.84932], [-124.08835, 40.84911], [-124.08866, 40.84906], [-124.08893, 40.84899], [-124.09039, 40.84871], [-124.09053, 40.84867], [-124.0906, 40.84866], [-124.09085, 40.84869], [-124.09104, 40.84876], [-124.09123, 40.84889], [-124.09137, 40.84909], [-124.09142, 40.8492], [-124.09144, 40.84928], [-124.09153, 40.84949], [-124.09164, 40.84995], [-124.09173, 40.85017], [-124.09176, 40.8503], [-124.09176, 40.85036], [-124.09182, 40.85046], [-124.09186, 40.85057], [-124.09196, 40.85099], [-124.09205, 40.85129], [-124.09213, 40.85139], [-124.09213, 40.85145], [-124.09218, 40.85155], [-124.09217, 40.85166], [-124.0922, 40.85178], [-124.09218, 40.85184], [-124.09223, 40.85202], [-124.09217, 40.85221], [-124.09217, 40.85225], [-124.09215, 40.85229], [-124.0922, 40.85233]]], [[[-124.09288, 40.86131], [-124.09233, 40.86198], [-124.08922, 40.86191], [-124.08921, 40.86125], [-124.08924, 40.86109], [-124.08936, 40.86058], [-124.08901, 40.8605], [-124.08951, 40.85919], [-124.08989, 40.85814], [-124.08992, 40.85752], [-124.0895, 40.85628], [-124.08941, 40.85607], [-124.08932, 40.8559], [-124.08918, 40.85571], [-124.08897, 40.85547], [-124.08919, 40.85561], [-124.0896, 40.85596], [-124.09038, 40.85673], [-124.09101, 40.85744], [-124.0915, 40.8581], [-124.09191, 40.85878], [-124.09215, 40.85924], [-124.09236, 40.85971], [-124.09243, 40.85988], [-124.09269, 40.8607], [-124.09277, 40.86087], [-124.09288, 40.86131]]], [[[-124.09302, 40.86339], [-124.09163, 40.863], [-124.09292, 40.86147], [-124.093, 40.86205], [-124.09303, 40.86246], [-124.09304, 40.86295], [-124.09302, 40.86339]]], [[[-124.10303, 40.86232], [-124.10334, 40.86264], [-124.10336, 40.8627], [-124.10336, 40.86281], [-124.1033, 40.86302], [-124.10326, 40.86308], [-124.10312, 40.86323], [-124.10288, 40.8634], [-124.1028, 40.86351], [-124.10277, 40.86358], [-124.10253, 40.86395], [-124.10204, 40.86408], [-124.10168, 40.86419], [-124.10189, 40.86465], [-124.10226, 40.86484], [-124.10237, 40.86492], [-124.10241, 40.86497], [-124.10243, 40.86513], [-124.10247, 40.8652], [-124.10292, 40.86556], [-124.10302, 40.86563], [-124.10308, 40.86571], [-124.10311, 40.8658], [-124.10309, 40.8659], [-124.10298, 40.86611], [-124.10292, 40.86618], [-124.10288, 40.86622], [-124.10275, 40.86627], [-124.10243, 40.86646], [-124.10239, 40.86695], [-124.10229, 40.86746], [-124.10181, 40.8675], [-124.10212, 40.86729], [-124.10215, 40.86708], [-124.10209, 40.86683], [-124.10224, 40.86614], [-124.10239, 40.86608], [-124.10246, 40.86575], [-124.10239, 40.86561], [-124.10216, 40.86535], [-124.10208, 40.86506], [-124.10164, 40.86479], [-124.09866, 40.86479], [-124.0984, 40.86542], [-124.0975, 40.86524], [-124.09736, 40.86557], [-124.09736, 40.86587], [-124.09543, 40.86547], [-124.09576, 40.86468], [-124.09314, 40.86393], [-124.09319, 40.86344], [-124.09322, 40.86268], [-124.09318, 40.86204], [-124.09306, 40.8613], [-124.09401, 40.86015], [-124.09505, 40.85893], [-124.0951, 40.85892], [-124.09517, 40.85895], [-124.09529, 40.85919], [-124.09541, 40.85934], [-124.09554, 40.85945], [-124.09574, 40.85955], [-124.09593, 40.85961], [-124.09638, 40.85966], [-124.09679, 40.85962], [-124.0968, 40.85961], [-124.09592, 40.85949], [-124.09568, 40.85939], [-124.09556, 40.85931], [-124.09543, 40.85916], [-124.0952, 40.85867], [-124.09512, 40.85863], [-124.09503, 40.85863], [-124.09496, 40.85867], [-124.09495, 40.8587], [-124.09495, 40.85883], [-124.09493, 40.85887], [-124.09387, 40.86011], [-124.09303, 40.86114], [-124.09295, 40.86086], [-124.09281, 40.86051], [-124.09262, 40.85988], [-124.09236, 40.85926], [-124.09209, 40.85874], [-124.09174, 40.85817], [-124.09137, 40.85765], [-124.09083, 40.85698], [-124.09047, 40.85659], [-124.09037, 40.85632], [-124.09158, 40.85532], [-124.09172, 40.8553], [-124.09178, 40.85527], [-124.09179, 40.85525], [-124.09178, 40.85521], [-124.0918, 40.85517], [-124.09191, 40.85507], [-124.09234, 40.85459], [-124.09283, 40.85414], [-124.09301, 40.85393], [-124.09315, 40.85381], [-124.09323, 40.85376], [-124.0934, 40.85372], [-124.0936, 40.85371], [-124.09385, 40.85375], [-124.09408, 40.85376], [-124.09499, 40.85403], [-124.09519, 40.85412], [-124.09576, 40.85429], [-124.09614, 40.85442], [-124.09623, 40.85447], [-124.09628, 40.85448], [-124.09634, 40.85452], [-124.09687, 40.8547], [-124.09726, 40.85486], [-124.09757, 40.85496], [-124.09828, 40.85524], [-124.09844, 40.85537], [-124.09857, 40.85553], [-124.09861, 40.85559], [-124.09862, 40.85579], [-124.09854, 40.85603], [-124.09843, 40.85622], [-124.09847, 40.85636], [-124.09846, 40.85643], [-124.09838, 40.85664], [-124.09823, 40.85662], [-124.09768, 40.85819], [-124.09827, 40.85834], [-124.09854, 40.85836], [-124.09888, 40.85836], [-124.09989, 40.85815], [-124.10004, 40.85815], [-124.10027, 40.85818], [-124.10047, 40.8583], [-124.10059, 40.8584], [-124.10061, 40.85846], [-124.09991, 40.8586], [-124.09982, 40.85879], [-124.09984, 40.85888], [-124.10008, 40.85926], [-124.1002, 40.8595], [-124.10025, 40.85956], [-124.10031, 40.8596], [-124.1004, 40.85964], [-124.10096, 40.85977], [-124.10103, 40.85981], [-124.10107, 40.85986], [-124.10074, 40.86022], [-124.10055, 40.86034], [-124.10046, 40.86045], [-124.10041, 40.86063], [-124.10041, 40.86091], [-124.10042, 40.86097], [-124.10088, 40.86186], [-124.10121, 40.86266], [-124.10134, 40.86277], [-124.10153, 40.86286], [-124.1017, 40.8629], [-124.10192, 40.8629], [-124.10223, 40.86276], [-124.10264, 40.8624], [-124.10272, 40.86234], [-124.10278, 40.86232], [-124.1029, 40.8623], [-124.10303, 40.86232]]]]} | Open Access 1 | 25405 | Arcata Marsh & Wildlife Sanctuary | 15570 | 1432 | Arcata, City of 587 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | Humboldt 45 | 316.49 | Arcata Marsh & Wildlife Sanctuary | 0 | Local Conservation Area 4 | 2 | |
11709 | 11709 | 11708 | {"type": "Polygon", "coordinates": [[[-121.31468, 38.25154], [-121.31467, 38.2521], [-121.31464, 38.25231], [-121.31421, 38.25231], [-121.31423, 38.25211], [-121.31424, 38.25158], [-121.3143, 38.25154], [-121.31468, 38.25154]]]} | Open Access 1 | 24100 | Fumasi Oak Preserve | 19150 | 1407 | Galt, City of 623 | City 2 | City Agency 2 | http://www.ci.galt.ca.us/index.aspx?page=71 | City 2 | 1407 | Galt, City of 612 | City 2 | City Agency 2 | Sacramento 41 | 0.802 | Fumasi Oak Preserve | 0 | Local Conservation Area 4 | 2 | |
11346 | 11346 | 11345 | {"type": "Polygon", "coordinates": [[[-117.16593, 33.56862], [-117.16586, 33.56897], [-117.16579, 33.5691], [-117.16527, 33.56964], [-117.16532, 33.5698], [-117.16534, 33.57], [-117.16557, 33.57018], [-117.1657, 33.57022], [-117.16576, 33.57032], [-117.16436, 33.57091], [-117.16277, 33.5697], [-117.16282, 33.56928], [-117.16347, 33.56856], [-117.16367, 33.56785], [-117.16336, 33.56729], [-117.16169, 33.56666], [-117.16142, 33.56455], [-117.16143, 33.56389], [-117.16253, 33.56391], [-117.16262, 33.56394], [-117.16206, 33.5648], [-117.16196, 33.56501], [-117.16192, 33.56523], [-117.16205, 33.56555], [-117.16196, 33.56566], [-117.16191, 33.56578], [-117.16192, 33.56591], [-117.16198, 33.56602], [-117.16208, 33.56622], [-117.16226, 33.56619], [-117.16258, 33.56636], [-117.16306, 33.56652], [-117.16326, 33.56666], [-117.16337, 33.56677], [-117.16401, 33.5672], [-117.16412, 33.56732], [-117.16415, 33.56743], [-117.16424, 33.56751], [-117.1645, 33.56764], [-117.16462, 33.56802], [-117.16497, 33.56791], [-117.16513, 33.56815], [-117.16535, 33.56836], [-117.16562, 33.56852], [-117.16593, 33.56862]]]} | Open Access 1 | 22129 | Warm Springs Park and Preserve | 33164 | 1391 | Murrieta, City of 329 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | Riverside 10 | 23.783 | Warm Springs Park and Preserve | 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]);