units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
969 rows where ACCESS_TYP = 3 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- California Department of Fish and Wildlife 77
- East Bay Regional Park District 45
- Los Angeles, City of 36
- The Nature Conservancy 31
- Las Virgenes Municipal Water District 28
- Peninsula Open Space Trust 24
- Natomas Basin Conservancy 22
- Rivers and Lands Conservancy 22
- The Environmental Trust 21
- Torrance, City of 20
- Mountains Restoration Trust 20
- San Diego, City of 19
- Santa Clara Valley Open Space Authority 18
- Midpeninsula Regional Open Space District 18
- Fresno Metropolitan Flood Control District 16
- United States Fish and Wildlife Service 15
- California Department of Parks and Recreation 14
- Endangered Habitats Conservancy 14
- San Diego, County of 13
- Los Angeles County Flood Control District 13
- Kinneloa Irrigation District 13
- Santa Clara County Parks and Recreation Dept., County of 13
- American River Conservancy 13
- Save Mount Diablo 13
- Littlerock Creek Irrigation District 13
- Napa, City of 12
- Sonoma Land Trust 11
- California Department of Water Resources 11
- Sonoma County Agricultural Preservation and Open Space District 10
- Riverside County Habitat Conservation Agency 10
- …
DES_TP >30
- Private Conservation 210
- Local Recreation Area 113
- Local Other or Unknown 88
- Local Park 77
- Local Conservation Area 73
- State Resource Management Area 64
- Private Recreation or Education 25
- Private Other or Unknown 25
- State Conservation Area 21
- State Other or Unknown 19
- National Wildlife Refuge 14
- Local Resource Management Area 8
- Private Agricultural 5
- State Park 4
- Resource Management Area 4
- Federal Other or Unknown 3
- State Historic or Cultural Area 3
- National Public Lands 2
- Conservation Area 2
- National Monument or Landmark 2
- State Recreation Area 1
- Recreation Management Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 20
- Non Profit - Land Trust 216
- City Agency 198
- State Agency 133
- Recreation/Parks District 102
- Flood District 58
- Water District 56
- Non Profit - Conservation 50
- Federal Agency 32
- Irrigation District 29
- County Agency 25
- Open Space District 22
- County Agency - Parks 18
- County Agency - Other 3
- Home Owners Association 1
- Commercial 1
- Sanitation District 1
- Non Profit - Other 1
- Joint Powers Authority 1
- Other 1
- Mitigation Bank 1
ACCESS_TYP 1
- No Public Access · 949 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6088 | 6088 | 6087 | {"type": "MultiPolygon", "coordinates": [[[[-118.76566, 36.21897], [-118.76561, 36.21935], [-118.76554, 36.21939], [-118.76553, 36.21897], [-118.76566, 36.21897]]], [[[-118.80359, 36.20734], [-118.80355, 36.20742], [-118.80349, 36.20775], [-118.80348, 36.20781], [-118.8035, 36.20789], [-118.80349, 36.20795], [-118.80341, 36.20808], [-118.80334, 36.20828], [-118.80335, 36.20835], [-118.8032, 36.20866], [-118.80308, 36.2088], [-118.80303, 36.20897], [-118.8029, 36.20911], [-118.80283, 36.20927], [-118.80272, 36.20942], [-118.80253, 36.20973], [-118.8023, 36.21002], [-118.80221, 36.21018], [-118.80166, 36.21092], [-118.80137, 36.21142], [-118.80119, 36.21183], [-118.79768, 36.21183], [-118.79707, 36.21184], [-118.79709, 36.21574], [-118.79715, 36.21897], [-118.79705, 36.21911], [-118.79693, 36.21941], [-118.78843, 36.21938], [-118.78839, 36.22305], [-118.77009, 36.22297], [-118.7656, 36.22293], [-118.76555, 36.21961], [-118.7658, 36.21943], [-118.76587, 36.21898], [-118.77952, 36.21909], [-118.77933, 36.20853], [-118.77975, 36.20849], [-118.78019, 36.20853], [-118.78076, 36.20854], [-118.78141, 36.20837], [-118.78173, 36.20826], [-118.78219, 36.20796], [-118.78266, 36.2075], [-118.78303, 36.20689], [-118.78341, 36.20642], [-118.78376, 36.20622], [-118.78433, 36.20598], [-118.78483, 36.20553], [-118.78512, 36.20513], [-118.8033, 36.20504], [-118.8033, 36.2051], [-118.80333, 36.20575], [-118.80336, 36.2059], [-118.8034, 36.20595], [-118.80342, 36.20602], [-118.80345, 36.20608], [-118.80348, 36.20621], [-118.80346, 36.20627], [-118.80353, 36.2066], [-118.80358, 36.20667], [-118.8036, 36.20721], [-118.80359, 36.20734]]], [[[-118.78102, 36.20829], [-118.78073, 36.20836], [-118.78021, 36.20835], [-118.77976, 36.20831], [-118.77933, 36.20835], [-118.77933, 36.20827], [-118.78102, 36.20829]]]]} | No Public Access 3 | 898 | Dennison Ditch Co | 18093 | 3076 | Sequoia Riverlands Trust 109 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sequoiariverlands.org | Non Governmental Organization 10 | 3076 | Sequoia Riverlands Trust 106 | Non Profit 6 | Non Profit - Land Trust 10 | Tulare 29 | 901.367 | Dennison Ditch Co | 0 | Private Conservation 16 | 2 | |
6095 | 6095 | 6094 | {"type": "Polygon", "coordinates": [[[-122.17522, 37.2796], [-122.17085, 37.27955], [-122.17074, 37.27583], [-122.17513, 37.27588], [-122.17522, 37.2796]]]} | No Public Access 3 | 979 | Sonntag | 25605 | 3054 | Peninsula Open Space Trust 338 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.openspacetrust.org/ | Non Governmental Organization 10 | 3054 | Peninsula Open Space Trust 335 | Non Profit 6 | Non Profit - Land Trust 10 | San Mateo 15 | 39.667 | Sonntag | 0 | Private Conservation 16 | 2 | |
6781 | 6781 | 6780 | {"type": "MultiPolygon", "coordinates": [[[[-118.87101, 36.2845], [-118.86701, 36.28447], [-118.8669, 36.28058], [-118.87081, 36.28092], [-118.87101, 36.2845]]], [[[-118.8623, 36.25941], [-118.862, 36.26718], [-118.85005, 36.26722], [-118.85009, 36.28028], [-118.85034, 36.29504], [-118.84101, 36.29497], [-118.84108, 36.28018], [-118.84106, 36.2672], [-118.85005, 36.26721], [-118.84987, 36.25951], [-118.8623, 36.25941]]]]} | No Public Access 3 | 1001 | Blue Ridge National Wildlife Refuge | 16187 | 106 | United States Fish and Wildlife Service 45 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | https://www.fws.gov/refuge/blue_ridge/ | Tulare 29 | 891.418 | Blue Ridge NWR | 1982 | National Wildlife Refuge 105 | 2 |
2887 | 2887 | 2886 | {"type": "Polygon", "coordinates": [[[-118.84526, 34.14121], [-118.84508, 34.14159], [-118.84522, 34.14267], [-118.84416, 34.14354], [-118.84341, 34.14305], [-118.8431, 34.14296], [-118.84277, 34.14318], [-118.84221, 34.14277], [-118.84222, 34.14259], [-118.84241, 34.1424], [-118.84258, 34.14219], [-118.84301, 34.14178], [-118.84324, 34.14153], [-118.84343, 34.14145], [-118.84344, 34.1413], [-118.84369, 34.1412], [-118.84394, 34.14106], [-118.84411, 34.14111], [-118.84433, 34.14102], [-118.84434, 34.1409], [-118.84443, 34.14087], [-118.84447, 34.14081], [-118.84456, 34.14084], [-118.84473, 34.14066], [-118.84526, 34.14121]]]} | No Public Access 3 | 1005 | Southshore Hills Open Space | 25695 | 2024 | Conejo Open Space Conservation Agency 504 | Special District 4 | Open Space District 6 | http://www.conejo-openspace.org/ | Special District 4 | 2024 | Conejo Open Space Conservation Agency 496 | Special District 4 | Open Space District 6 | Ventura 8 | 12.796 | Southshore Hills OS | 0 | Local Recreation Area 3 | 4 | |
15788 | 15788 | 15787 | {"type": "MultiPolygon", "coordinates": [[[[-119.29929, 35.90624], [-119.29923, 35.91165], [-119.29481, 35.91165], [-119.29479, 35.90985], [-119.29034, 35.90984], [-119.29033, 35.90623], [-119.29929, 35.90624]]], [[[-119.33321, 35.9009], [-119.3332, 35.90268], [-119.33097, 35.90273], [-119.33098, 35.90092], [-119.33321, 35.9009]]], [[[-119.34447, 35.89873], [-119.33996, 35.89874], [-119.33988, 35.89595], [-119.34441, 35.89591], [-119.34447, 35.89873]]], [[[-119.37569, 35.93517], [-119.36694, 35.93521], [-119.36693, 35.93526], [-119.35817, 35.9353], [-119.35816, 35.93524], [-119.35364, 35.93525], [-119.35338, 35.92067], [-119.34007, 35.92066], [-119.34006, 35.9206], [-119.33998, 35.9206], [-119.33992, 35.90621], [-119.35775, 35.90616], [-119.37553, 35.90605], [-119.37552, 35.9206], [-119.37569, 35.93517]]], [[[-119.42609, 35.92014], [-119.4248, 35.92016], [-119.42477, 35.92379], [-119.42029, 35.92382], [-119.42029, 35.9202], [-119.40462, 35.92038], [-119.40462, 35.92221], [-119.40236, 35.92224], [-119.4023, 35.92778], [-119.39344, 35.92788], [-119.39349, 35.93508], [-119.37584, 35.93516], [-119.37569, 35.92059], [-119.3757, 35.90605], [-119.39353, 35.90593], [-119.41141, 35.90576], [-119.41142, 35.90584], [-119.4155, 35.90579], [-119.42029, 35.9123], [-119.42031, 35.91293], [-119.42076, 35.91292], [-119.42609, 35.92014]]], [[[-119.4155, 35.96387], [-119.39333, 35.96398], [-119.39331, 35.94974], [-119.41547, 35.9495], [-119.4155, 35.96387]]], [[[-119.48434, 36.03645], [-119.48248, 36.03647], [-119.48248, 36.05084], [-119.47347, 36.05086], [-119.47357, 36.03648], [-119.47365, 36.03647], [-119.47364, 36.02558], [-119.46468, 36.02561], [-119.46468, 36.0365], [-119.45575, 36.03653], [-119.4557, 36.04372], [-119.44681, 36.04375], [-119.44682, 36.04235], [-119.44695, 36.0366], [-119.4468, 36.02196], [-119.45869, 36.02197], [-119.45872, 36.01833], [-119.46173, 36.01834], [-119.46171, 36.02197], [-119.46466, 36.02197], [-119.47358, 36.02194], [-119.47758, 36.02556], [-119.4814, 36.02553], [-119.4826, 36.02723], [-119.48434, 36.03645]]]]} | No Public Access 3 | 1006 | Pixley National Wildlife Refuge | 23755 | 106 | United States Fish and Wildlife Service 45 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | Tulare 29 | 6974.604 | Pixley NWR | 1959 | National Wildlife Refuge 105 | 2 | |
15552 | 15552 | 15551 | {"type": "MultiPolygon", "coordinates": [[[[-122.72009, 38.37147], [-122.71926, 38.37177], [-122.71925, 38.37265], [-122.71699, 38.37267], [-122.71616, 38.37133], [-122.71645, 38.37127], [-122.7167, 38.37125], [-122.71693, 38.37125], [-122.72009, 38.37147]]], [[[-122.75284, 38.37969], [-122.75203, 38.38046], [-122.75178, 38.38073], [-122.75159, 38.38099], [-122.7507, 38.3824], [-122.75046, 38.38273], [-122.75017, 38.38308], [-122.74986, 38.3834], [-122.74958, 38.38365], [-122.74834, 38.38466], [-122.74804, 38.38488], [-122.74745, 38.38523], [-122.74682, 38.38552], [-122.74639, 38.38569], [-122.74587, 38.38585], [-122.74528, 38.38599], [-122.74416, 38.38618], [-122.74415, 38.38213], [-122.74624, 38.38209], [-122.74624, 38.37983], [-122.75284, 38.37969]]], [[[-122.75511, 38.38384], [-122.75511, 38.38384], [-122.74981, 38.38391], [-122.75018, 38.3836], [-122.7507, 38.38303], [-122.75099, 38.38264], [-122.75195, 38.38112], [-122.75212, 38.38088], [-122.75228, 38.38071], [-122.75262, 38.38041], [-122.75281, 38.38028], [-122.75306, 38.38016], [-122.75344, 38.38003], [-122.75368, 38.37999], [-122.75398, 38.37997], [-122.75502, 38.37994], [-122.75513, 38.38238], [-122.75511, 38.38384]]], [[[-122.75687, 38.40921], [-122.75684, 38.40955], [-122.75674, 38.41136], [-122.75668, 38.41162], [-122.75661, 38.41296], [-122.75641, 38.41295], [-122.75621, 38.41311], [-122.75615, 38.41401], [-122.75083, 38.41441], [-122.75048, 38.41153], [-122.75072, 38.4115], [-122.75071, 38.40963], [-122.75661, 38.40922], [-122.75664, 38.40878], [-122.75645, 38.40709], [-122.75657, 38.40708], [-122.75674, 38.40877], [-122.75675, 38.40921], [-122.75687, 38.40921]]], [[[-122.76305, 38.39085], [-122.75418, 38.39206], [-122.75418, 38.39561], [-122.75155, 38.39562], [-122.75155, 38.38709], [-122.75184, 38.38711], [-122.75394, 38.387], [-122.75341, 38.38771], [-122.75296, 38.38778], [-122.75275, 38.38798], [-122.75276, 38.38945], [-122.75329, 38.38955], [-122.75343, 38.38954], [-122.75517, 38.38984], [-122.75546, 38.38969], [-122.75586, 38.38943], [-122.75586, 38.3869], [-122.76093, 38.38661], [-122.76096, 38.38738], [-122.76115, 38.38738], [-122.76117, 38.38795], [-122.76199, 38.38795], [-122.762, 38.38784], [-122.76299, 38.38783], [-122.76305, 38.39085]]], [[[-122.7564, 38.40664], [-122.75588, 38.40668], [-122.75572, 38.40677], [-122.75516, 38.40681], [-122.75515, 38.40671], [-122.75479, 38.40667], [-122.75438, 38.40669], [-122.75437, 38.4067], [-122.75179, 38.40668], [-122.75179, 38.4065], [-122.75183, 38.40579], [-122.75607, 38.40552], [-122.75611, 38.40579], [-122.75629, 38.40579], [-122.7564, 38.40664]]], [[[-122.76189, 38.37549], [-122.76121, 38.37551], [-122.76121, 38.37608], [-122.76089, 38.37611], [-122.76074, 38.37614], [-122.76046, 38.37625], [-122.75908, 38.3772], [-122.75876, 38.37721], [-122.75873, 38.376], [-122.75635, 38.37603], [-122.75627, 38.37236], [-122.7542, 38.37239], [-122.75418, 38.37147], [-122.75623, 38.37144], [-122.75619, 38.36922], [-122.75637, 38.36921], [-122.75633, 38.36746], [-122.75408, 38.36747], [-122.75403, 38.36441], [-122.75402, 38.3644], [-122.75391, 38.36448], [-122.7539, 38.36312], [-122.75589, 38.36308], [-122.7561, 38.36294], [-122.75619, 38.36291], [-122.75621, 38.36301], [-122.75804, 38.36296], [-122.75843, 38.36376], [-122.75846, 38.36377], [-122.75853, 38.36632], [-122.75858, 38.36919], [-122.7586, 38.36954], [-122.75864, 38.37126], [-122.75872, 38.37501], [-122.76187, 38.37498], [-122.76189, 38.37549]]], [[[-122.75751, 38.40108], [-122.75671, 38.40118], [-122.75674, 38.4015], [-122.75637, 38.40154], [-122.75508, 38.40156], [-122.75506, 38.39923], [-122.75749, 38.3992], [-122.75751, 38.40108]]], [[[-122.76129, 38.37803], [-122.75889, 38.37806], [-122.75889, 38.37806], [-122.7589, 38.37792], [-122.75894, 38.37781], [-122.75901, 38.37768], [-122.75915, 38.37753], [-122.76066, 38.37647], [-122.76082, 38.37638], [-122.76096, 38.37633], [-122.76122, 38.37629], [-122.76129, 38.37803]]], [[[-122.76589, 38.47792], [-122.76578, 38.47792], [-122.76577, 38.47796], [-122.76491, 38.47796], [-122.7649, 38.47803], [-122.76287, 38.47803], [-122.76286, 38.47715], [-122.76287, 38.47624], [-122.76579, 38.47623], [-122.76579, 38.4778], [-122.76589, 38.47781], [-122.76589, 38.47792]]], [[[-122.76909, 38.39921], [-122.76909, 38.4004], [-122.76849, 38.40049], [-122.76789, 38.40183], [-122.76789, 38.40205], [-122.76738, 38.40205], [-122.76738, 38.4015], [-122.76694, 38.4015], [-122.76693, 38.40178], [-122.76735, 38.40179], [-122.76734, 38.40206], [-122.76672, 38.40206], [-122.76673, 38.39975], [-122.76909, 38.39921]]], [[[-122.77985, 38.38778], [-122.77867, 38.38851], [-122.77242, 38.38856], [-122.76953, 38.38618], [-122.7781, 38.38605], [-122.77985, 38.38778]]], [[[-122.77366, 38.39817], [-122.77366, 38.40077], [-122.77229, 38.40077], [-122.77228, 38.40227], [-122.77143, 38.40228], [-122.77143, 38.40341], [-122.77135, 38.40341], [-122.77135, 38.40123], [-122.77049, 38.40124], [-122.77049, 38.39889], [-122.77366, 38.39817]]], [[[-122.78171, 38.43789], [-122.78119, 38.43789], [-122.78118, 38.43515], [-122.78117, 38.43514], [-122.7811, 38.43515], [-122.78111, 38.43789], [-122.77983, 38.4379], [-122.77982, 38.43755], [-122.77906, 38.43754], [-122.77906, 38.43738], [-122.77884, 38.43738], [-122.77882, 38.4379], [-122.7744, 38.43793], [-122.7744, 38.4362], [-122.77447, 38.43619], [-122.77451, 38.43057], [-122.77141, 38.43056], [-122.77137, 38.42731], [-122.77252, 38.42587], [-122.77359, 38.42481], [-122.77382, 38.42464], [-122.77411, 38.42451], [-122.77447, 38.42443], [-122.77732, 38.42421], [-122.77734, 38.42578], [-122.77679, 38.42579], [-122.7768, 38.42637], [-122.77754, 38.42637], [-122.77754, 38.42599], [-122.77887, 38.42598], [-122.77886, 38.42798], [-122.77888, 38.43065], [-122.78168, 38.43066], [-122.78171, 38.43789]]], [[[-122.77884, 38.51847], [-122.77564, 38.51847], [-122.77563, 38.51795], [-122.77484, 38.51795], [-122.77483, 38.51746], [-122.77563, 38.51745], [-122.77563, 38.51709], [-122.77884, 38.51708], [-122.77884, 38.51847]]], [[[-122.77907, 38.47094], [-122.77901, 38.47094], [-122.77901, 38.47105], [-122.77722, 38.47106], [-122.77723, 38.47045], [-122.77906, 38.47047], [-122.77907, 38.47094]]], [[[-122.78767, 38.38685], [-122.78114, 38.38699], [-122.77999, 38.3877], [-122.77835, 38.38605], [-122.77932, 38.38603], [-122.7796, 38.386], [-122.77973, 38.38595], [-122.78764, 38.38579], [-122.78767, 38.38685]]], [[[-122.78111, 38.44116], [-122.77888, 38.44115], [-122.77886, 38.44013], [-122.77962, 38.44012], [-122.77965, 38.43807], [-122.78103, 38.43806], [-122.7811, 38.4381], [-122.78111, 38.44116]]], [[[-122.78177, 38.47439], [-122.77907, 38.47438], [-122.77903, 38.47268], [-122.77902, 38.47118], [-122.77959, 38.4717], [-122.77955, 38.47175], [-122.77964, 38.47213], [-122.77992, 38.47214], [-122.77991, 38.47219], [-122.77998, 38.47239], [-122.78013, 38.47239], [-122.78013, 38.47243], [-122.78028, 38.47247], [-122.78035, 38.47246], [-122.7806, 38.47221], [-122.78058, 38.47203], [-122.78066, 38.47202], [-122.78071, 38.47198], [-122.7807, 38.47154], [-122.78018, 38.47154], [-122.78018, 38.47162], [-122.77971, 38.47162], [-122.77958, 38.47159], [-122.77916, 38.47119], [-122.77916, 38.47096], [-122.78173, 38.47097], [-122.78177, 38.47439]]]]} | No Public Access 3 | 1044 | Santa Rosa Plain Vernal Pool Ecological Reserve | 32301 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Sonoma 16 | 840.334 | Santa Rosa Plain Vernal Pool ER | 0 | State Conservation Area 8 | 2 | |
6138 | 6138 | 6137 | {"type": "MultiPolygon", "coordinates": [[[[-119.81139, 36.85174], [-119.80965, 36.85279], [-119.80958, 36.85524], [-119.80919, 36.85524], [-119.80918, 36.85525], [-119.80934, 36.85555], [-119.80965, 36.85584], [-119.8098, 36.85603], [-119.81001, 36.8564], [-119.81053, 36.85718], [-119.81052, 36.85757], [-119.81058, 36.85775], [-119.81056, 36.85798], [-119.81032, 36.8589], [-119.81027, 36.85962], [-119.8101, 36.86002], [-119.80955, 36.8605], [-119.80919, 36.86204], [-119.80844, 36.86293], [-119.80636, 36.86382], [-119.80577, 36.8641], [-119.8056, 36.86425], [-119.80474, 36.86484], [-119.80363, 36.8651], [-119.80253, 36.86561], [-119.80219, 36.86584], [-119.80205, 36.86614], [-119.80199, 36.86632], [-119.80175, 36.86632], [-119.80176, 36.86678], [-119.80174, 36.86702], [-119.80158, 36.86727], [-119.80115, 36.86778], [-119.80104, 36.86782], [-119.8008, 36.86795], [-119.80046, 36.86824], [-119.8003, 36.86851], [-119.80023, 36.86891], [-119.8002, 36.86931], [-119.80015, 36.86954], [-119.79995, 36.86991], [-119.79971, 36.87027], [-119.79948, 36.87058], [-119.79916, 36.87082], [-119.79884, 36.87118], [-119.7985, 36.87152], [-119.79837, 36.87158], [-119.79807, 36.8718], [-119.79783, 36.87189], [-119.79749, 36.87211], [-119.79717, 36.87237], [-119.79685, 36.8726], [-119.79671, 36.87276], [-119.7966, 36.87282], [-119.7962, 36.87288], [-119.79596, 36.87301], [-119.79588, 36.87324], [-119.79577, 36.87342], [-119.79537, 36.87362], [-119.79509, 36.87385], [-119.79479, 36.87406], [-119.79409, 36.87471], [-119.79402, 36.8741], [-119.79381, 36.86984], [-119.79435, 36.86947], [-119.79484, 36.86895], [-119.79528, 36.86836], [-119.79634, 36.86631], [-119.79728, 36.86631], [-119.79729, 36.86374], [-119.79741, 36.86334], [-119.79812, 36.86223], [-119.79822, 36.86156], [-119.79828, 36.86147], [-119.79838, 36.86148], [-119.79846, 36.86137], [-119.79916, 36.86075], [-119.79957, 36.86022], [-119.79979, 36.85985], [-119.80008, 36.85919], [-119.80056, 36.85848], [-119.80065, 36.85813], [-119.80064, 36.85809], [-119.80081, 36.85745], [-119.8008, 36.85741], [-119.80117, 36.85692], [-119.80182, 36.85633], [-119.80242, 36.85586], [-119.80241, 36.85583], [-119.80253, 36.85578], [-119.8026, 36.85572], [-119.80321, 36.85532], [-119.80371, 36.85506], [-119.80397, 36.85494], [-119.80419, 36.85478], [-119.80453, 36.85434], [-119.80485, 36.85465], [-119.80484, 36.85469], [-119.80507, 36.85479], [-119.80512, 36.8547], [-119.80511, 36.85464], [-119.80503, 36.85452], [-119.80472, 36.85422], [-119.80545, 36.85374], [-119.80631, 36.85323], [-119.80719, 36.85267], [-119.80743, 36.85307], [-119.80951, 36.85256], [-119.81014, 36.85204], [-119.81072, 36.85175], [-119.81139, 36.85174]]], [[[-119.81549, 36.85967], [-119.81481, 36.86091], [-119.81419, 36.8616], [-119.8121, 36.86351], [-119.81095, 36.86565], [-119.81041, 36.86422], [-119.80935, 36.86353], [-119.81125, 36.85939], [-119.81234, 36.85837], [-119.81252, 36.85743], [-119.81541, 36.8596], [-119.81545, 36.85967], [-119.81549, 36.85967]]]]} | No Public Access 3 | 1129 | Spano River Ranch | 25715 | 233 | San Joaquin River Conservancy 827 | State 5 | State Agency 5 | http://sjrc.ca.gov/ | Other State 5 | 3069 | San Joaquin River Parkway and Conservation Trust 491 | Non Profit 6 | Non Profit - Land Trust 10 | Fresno 9 | 412.564 | Spano River Ranch | 0 | State Other or Unknown 104 | 4 | |
6173 | 6173 | 6172 | {"type": "Polygon", "coordinates": [[[-122.64262, 37.8994], [-122.64213, 37.8998], [-122.64167, 37.8996], [-122.64213, 37.89912], [-122.64242, 37.8992], [-122.64262, 37.8994]]]} | No Public Access 3 | 1204 | Stinson Beach | 32319 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Marin 23 | 0.833 | Stinson Beach | 0 | State Resource Management Area 55 | 3 | |
6179 | 6179 | 6178 | {"type": "Polygon", "coordinates": [[[-117.11321, 33.4123], [-117.11289, 33.41266], [-117.1124, 33.41359], [-117.11121, 33.41278], [-117.11054, 33.41298], [-117.10972, 33.4128], [-117.10938, 33.41231], [-117.10899, 33.41231], [-117.10623, 33.4129], [-117.10374, 33.41236], [-117.1033, 33.4123], [-117.10365, 33.41528], [-117.0977, 33.41534], [-117.09748, 33.41496], [-117.09743, 33.41491], [-117.09735, 33.41487], [-117.09697, 33.41478], [-117.09692, 33.41473], [-117.09693, 33.41467], [-117.09689, 33.41455], [-117.09675, 33.41441], [-117.09648, 33.41432], [-117.09612, 33.414], [-117.09606, 33.41398], [-117.09598, 33.414], [-117.09593, 33.41405], [-117.09582, 33.41435], [-117.09578, 33.41451], [-117.09559, 33.41471], [-117.09566, 33.41531], [-117.09569, 33.41535], [-117.0958, 33.41567], [-117.0958, 33.41579], [-117.09578, 33.41591], [-117.09565, 33.41619], [-117.09546, 33.41631], [-117.09512, 33.4166], [-117.09511, 33.41667], [-117.09518, 33.41676], [-117.09519, 33.41684], [-117.09516, 33.41689], [-117.09497, 33.41701], [-117.09486, 33.41713], [-117.09482, 33.41726], [-117.09484, 33.41742], [-117.09483, 33.4175], [-117.09475, 33.41763], [-117.09472, 33.41775], [-117.09473, 33.41799], [-117.09479, 33.41844], [-117.09481, 33.41855], [-117.09476, 33.41895], [-117.09476, 33.41905], [-117.09483, 33.41908], [-117.09506, 33.41908], [-117.0951, 33.4198], [-117.09514, 33.4209], [-117.09526, 33.42291], [-117.09097, 33.42296], [-117.09102, 33.42379], [-117.08878, 33.42387], [-117.08865, 33.42348], [-117.08854, 33.42301], [-117.09096, 33.42296], [-117.09042, 33.41541], [-117.09032, 33.41197], [-117.0873, 33.41198], [-117.08728, 33.40855], [-117.09023, 33.40853], [-117.09014, 33.40506], [-117.08586, 33.40504], [-117.08585, 33.40349], [-117.08401, 33.40348], [-117.08388, 33.40276], [-117.08385, 33.4021], [-117.08377, 33.40175], [-117.08584, 33.40179], [-117.10209, 33.40231], [-117.10282, 33.40838], [-117.10377, 33.40848], [-117.10378, 33.40847], [-117.10306, 33.40238], [-117.11128, 33.4029], [-117.11148, 33.40933], [-117.11249, 33.40945], [-117.11291, 33.41202], [-117.11321, 33.4123]]]} | No Public Access 3 | 1219 | Mt. Olympus Preserve | 29249 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 801.066 | Mt. Olympus Preserve | 0 | Local Conservation Area 4 | 2 | |
6218 | 6218 | 6217 | {"type": "Polygon", "coordinates": [[[-122.22564, 38.15293], [-122.22516, 38.15364], [-122.22485, 38.15405], [-122.22462, 38.15394], [-122.22416, 38.15388], [-122.22394, 38.15359], [-122.2239, 38.15324], [-122.22435, 38.15302], [-122.22465, 38.15275], [-122.22491, 38.15266], [-122.22559, 38.15271], [-122.22564, 38.15293]]]} | No Public Access 3 | 1275 | Summit Reservoir | 25968 | 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 | 3.617 | Summit Reservoir | 0 | Local Recreation Area 3 | 4 | |
15992 | 15992 | 15991 | {"type": "Polygon", "coordinates": [[[-121.9799, 38.37625], [-121.97978, 38.37626], [-121.97969, 38.37632], [-121.97967, 38.37636], [-121.97967, 38.37641], [-121.97972, 38.3765], [-121.97906, 38.37666], [-121.97898, 38.37672], [-121.97889, 38.3767], [-121.97882, 38.3767], [-121.97877, 38.37672], [-121.97872, 38.37667], [-121.97795, 38.37669], [-121.97733, 38.37393], [-121.97713, 38.37363], [-121.97701, 38.37346], [-121.977, 38.37339], [-121.97718, 38.37325], [-121.97737, 38.37299], [-121.97738, 38.37294], [-121.9774, 38.3729], [-121.97744, 38.37276], [-121.97745, 38.37234], [-121.9775, 38.3723], [-121.97831, 38.37233], [-121.97891, 38.37241], [-121.97913, 38.37242], [-121.97914, 38.37278], [-121.97928, 38.37297], [-121.97928, 38.37308], [-121.9793, 38.37312], [-121.97931, 38.37328], [-121.97934, 38.37343], [-121.97935, 38.37375], [-121.97943, 38.3738], [-121.97942, 38.37399], [-121.97936, 38.37423], [-121.97943, 38.37455], [-121.97952, 38.37459], [-121.9795, 38.37467], [-121.97953, 38.37474], [-121.97948, 38.37477], [-121.97954, 38.37506], [-121.97976, 38.37535], [-121.97972, 38.3754], [-121.97972, 38.37545], [-121.97975, 38.37551], [-121.97981, 38.37556], [-121.9798, 38.37594], [-121.9799, 38.37625]]]} | No Public Access 3 | 1305 | Sunrise Woodcrest Open Space | 26039 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 20.516 | Sunrise Woodcrest OS | 0 | Local Recreation Area 3 | 4 | |
6243 | 6243 | 6242 | {"type": "Polygon", "coordinates": [[[-116.96211, 32.96295], [-116.95351, 32.96324], [-116.95342, 32.95961], [-116.94888, 32.95974], [-116.94878, 32.95602], [-116.94045, 32.9561], [-116.94043, 32.95977], [-116.93185, 32.95964], [-116.93185, 32.95601], [-116.92761, 32.95596], [-116.92763, 32.95203], [-116.93186, 32.95198], [-116.93182, 32.94121], [-116.92765, 32.94122], [-116.92248, 32.94033], [-116.9225, 32.94032], [-116.92218, 32.93627], [-116.92764, 32.93755], [-116.92764, 32.93401], [-116.93615, 32.93378], [-116.93618, 32.93562], [-116.94046, 32.93556], [-116.94047, 32.93366], [-116.9447, 32.93354], [-116.94886, 32.93352], [-116.94892, 32.94093], [-116.95334, 32.9409], [-116.9534, 32.94251], [-116.95366, 32.94251], [-116.95404, 32.94257], [-116.95419, 32.94253], [-116.95424, 32.9425], [-116.95433, 32.94237], [-116.95436, 32.94199], [-116.95436, 32.94189], [-116.95434, 32.94179], [-116.95417, 32.94158], [-116.95413, 32.94147], [-116.95414, 32.94141], [-116.95421, 32.94125], [-116.9543, 32.94118], [-116.95462, 32.94098], [-116.95478, 32.94093], [-116.9549, 32.9409], [-116.95518, 32.94089], [-116.95541, 32.94094], [-116.95553, 32.94095], [-116.95568, 32.94125], [-116.95518, 32.94132], [-116.95504, 32.94139], [-116.95494, 32.94146], [-116.95486, 32.94158], [-116.95481, 32.94169], [-116.95481, 32.94184], [-116.95484, 32.94192], [-116.95488, 32.94211], [-116.95483, 32.94232], [-116.95478, 32.94241], [-116.9547, 32.94251], [-116.95461, 32.94259], [-116.95445, 32.94268], [-116.95429, 32.94272], [-116.95411, 32.94274], [-116.95366, 32.94268], [-116.95324, 32.94271], [-116.95308, 32.94269], [-116.95286, 32.94263], [-116.9527, 32.94263], [-116.95253, 32.94268], [-116.9524, 32.94276], [-116.9513, 32.94378], [-116.95115, 32.94389], [-116.95109, 32.94392], [-116.95165, 32.94469], [-116.94886, 32.94473], [-116.94889, 32.95222], [-116.95298, 32.9522], [-116.95323, 32.95222], [-116.95318, 32.94851], [-116.95783, 32.94845], [-116.95798, 32.95947], [-116.96207, 32.95939], [-116.96211, 32.96295]]]} | No Public Access 3 | 1316 | San Vicente Highlands | 32296 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Diego 4 | 1545.08 | San Vicente Highlands | 0 | State Resource Management Area 55 | 3 | |
5245 | 5245 | 5244 | {"type": "Polygon", "coordinates": [[[-122.52297, 41.8958], [-122.52259, 41.89608], [-122.52198, 41.89642], [-122.5213, 41.89687], [-122.52065, 41.89629], [-122.52078, 41.89611], [-122.52229, 41.89521], [-122.52297, 41.8958]]]} | No Public Access 3 | 1341 | Klamathon Station | 32197 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Siskiyou 28 | 4.018 | Klamathon Station | 0 | State Resource Management Area 55 | 3 | |
6263 | 6263 | 6262 | {"type": "Polygon", "coordinates": [[[-121.79058, 36.52123], [-121.79045, 36.52142], [-121.79048, 36.52155], [-121.79052, 36.52163], [-121.79026, 36.52171], [-121.7886, 36.52066], [-121.78871, 36.52058], [-121.78783, 36.5197], [-121.78919, 36.51943], [-121.7892, 36.51992], [-121.78948, 36.52042], [-121.78993, 36.52087], [-121.79025, 36.52083], [-121.79058, 36.52123]]]} | No Public Access 3 | 1348 | Thomas Open Space | 26308 | 2085 | Monterey Peninsula Regional Park District 47 | Special District 4 | Recreation/Parks District 4 | http://www.mprpd.org/ | Special District 4 | 2085 | Monterey Peninsula Regional Park District 46 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 5.313 | Thomas OS | 0 | Local Recreation Area 3 | 4 | |
6250 | 6250 | 6249 | {"type": "Polygon", "coordinates": [[[-117.1192, 33.10579], [-117.11901, 33.10627], [-117.11885, 33.10655], [-117.11637, 33.10688], [-117.11677, 33.10621], [-117.11701, 33.10622], [-117.11704, 33.1061], [-117.11691, 33.10609], [-117.11713, 33.10571], [-117.11708, 33.10568], [-117.1178, 33.10446], [-117.1192, 33.10579]]]} | No Public Access 3 | 1410 | Escondido Creek | 18706 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 8.905 | Escondido Creek | 0 | Local Other or Unknown 14 | 4 | |
6296 | 6296 | 6295 | {"type": "Polygon", "coordinates": [[[-121.88197, 37.73651], [-121.88144, 37.73642], [-121.874, 37.73118], [-121.87389, 37.72956], [-121.8737, 37.72941], [-121.87354, 37.72903], [-121.87339, 37.72886], [-121.87321, 37.72857], [-121.87321, 37.72841], [-121.87326, 37.72834], [-121.87361, 37.72828], [-121.8737, 37.72821], [-121.87367, 37.72806], [-121.87354, 37.72802], [-121.87327, 37.72806], [-121.87305, 37.72785], [-121.87286, 37.72737], [-121.87287, 37.7271], [-121.87293, 37.72697], [-121.87303, 37.72646], [-121.873, 37.72633], [-121.87291, 37.72631], [-121.87278, 37.72635], [-121.87269, 37.72635], [-121.87258, 37.72621], [-121.87244, 37.72581], [-121.87254, 37.72555], [-121.87256, 37.72525], [-121.87253, 37.72514], [-121.87225, 37.72474], [-121.87185, 37.72446], [-121.87183, 37.72431], [-121.87199, 37.72425], [-121.872, 37.72424], [-121.87166, 37.72419], [-121.87168, 37.72391], [-121.87238, 37.72394], [-121.87288, 37.72369], [-121.87438, 37.72709], [-121.87473, 37.73143], [-121.88197, 37.73651]]]} | No Public Access 3 | 1411 | Tassajara Creek Regional Park | 26194 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 24.514 | Tassajara Creek RP | 1971 | Local Park 2 | 4 | |
6300 | 6300 | 6299 | {"type": "Polygon", "coordinates": [[[-122.00948, 38.34308], [-122.00872, 38.34467], [-122.00701, 38.34922], [-122.00683, 38.34903], [-122.00699, 38.34894], [-122.00699, 38.34892], [-122.00674, 38.34867], [-122.00658, 38.34877], [-122.00653, 38.34873], [-122.00669, 38.34811], [-122.00525, 38.34739], [-122.00384, 38.34625], [-122.00365, 38.34649], [-122.00372, 38.3469], [-122.00364, 38.34691], [-122.00347, 38.34659], [-122.00335, 38.3466], [-122.00333, 38.34675], [-122.00313, 38.34708], [-122.00328, 38.34718], [-122.0034, 38.34738], [-122.00345, 38.34758], [-122.00328, 38.34776], [-122.00331, 38.34791], [-122.00325, 38.34817], [-122.00307, 38.34857], [-122.00277, 38.34889], [-122.00279, 38.3491], [-122.00256, 38.34887], [-122.00265, 38.34871], [-122.00284, 38.34855], [-122.00297, 38.34837], [-122.00309, 38.34797], [-122.00303, 38.34764], [-122.00318, 38.34745], [-122.00312, 38.34727], [-122.00301, 38.34719], [-122.00296, 38.34712], [-122.00307, 38.3466], [-122.00299, 38.34644], [-122.00268, 38.34637], [-122.00253, 38.3462], [-122.00226, 38.34601], [-122.00198, 38.34544], [-122.00181, 38.34515], [-122.00175, 38.34498], [-122.00215, 38.34482], [-122.00702, 38.34317], [-122.00825, 38.343], [-122.00928, 38.34317], [-122.00948, 38.34308]]]} | No Public Access 3 | 1417 | Alamo Terrace Open Space | 15323 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 55.193 | Alamo Terrace OS | 2000 | Local Recreation Area 3 | 4 | |
16448 | 16448 | 16447 | {"type": "MultiPolygon", "coordinates": [[[[-122.49631, 37.69491], [-122.49621, 37.69514], [-122.49615, 37.69533], [-122.49611, 37.69552], [-122.4961, 37.69576], [-122.49612, 37.69608], [-122.4963, 37.69694], [-122.49611, 37.69734], [-122.49598, 37.69752], [-122.4958, 37.69769], [-122.49557, 37.69783], [-122.49524, 37.69709], [-122.49514, 37.69681], [-122.49501, 37.69634], [-122.49494, 37.69596], [-122.49493, 37.69587], [-122.49498, 37.69308], [-122.49583, 37.69503], [-122.49631, 37.69491]]], [[[-122.50073, 37.70099], [-122.49662, 37.70102], [-122.49643, 37.70061], [-122.49767, 37.70059], [-122.49744, 37.7001], [-122.49716, 37.69893], [-122.49696, 37.69836], [-122.49681, 37.69798], [-122.49672, 37.69736], [-122.49678, 37.69707], [-122.49679, 37.69679], [-122.49675, 37.69659], [-122.49665, 37.69624], [-122.49663, 37.69602], [-122.49664, 37.69582], [-122.49669, 37.6956], [-122.49716, 37.69425], [-122.49727, 37.69396], [-122.49737, 37.69363], [-122.49744, 37.6932], [-122.49746, 37.69275], [-122.49855, 37.69271], [-122.49886, 37.69376], [-122.49911, 37.69475], [-122.4995, 37.69584], [-122.49993, 37.69732], [-122.50019, 37.69868], [-122.50073, 37.70099]]]]} | No Public Access 3 | 1533 | Thornton State Beach | 26321 | 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 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=530 | San Mateo 15 | 62.869 | Thornton SB | 1955 | State Park 15 | 4 |
5734 | 5734 | 5733 | {"type": "Polygon", "coordinates": [[[-121.70367, 39.80488], [-121.70358, 39.8067], [-121.69866, 39.8105], [-121.69855, 39.81401], [-121.69396, 39.81401], [-121.69395, 39.81215], [-121.69416, 39.80653], [-121.69368, 39.80652], [-121.68461, 39.80657], [-121.68726, 39.80502], [-121.70367, 39.80488]]]} | No Public Access 3 | 1651 | Little Chico Canyon | 32204 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Butte 42 | 170.568 | Little Chico Canyon | 0 | State Resource Management Area 55 | 3 | |
4180 | 4180 | 4179 | {"type": "Polygon", "coordinates": [[[-121.7562, 37.72355], [-121.75619, 37.73783], [-121.75386, 37.73785], [-121.7539, 37.7308], [-121.7516, 37.73078], [-121.75166, 37.72355], [-121.7562, 37.72355]]]} | No Public Access 3 | 1793 | Livermore Monitoring Station | 21382 | 217 | University of California 53 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 217 | University of California 51 | State 5 | State Agency 5 | Alameda 17 | 119.329 | Livermore Monitoring Station | None 362 |
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]);