units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 5,695
- County Agency 670
- Recreation/Parks District 632
- State Agency 564
- Non Profit - Land Trust 342
- Open Space District 311
- Federal Agency 263
- Water District 186
- County Agency - Parks 123
- Non Profit - Conservation 107
- Home Owners Association 94
- Community Services District 93
- Flood District 44
- Irrigation District 33
- Cemetery District 29
- Non Profit - Other 29
- County Agency - Other 26
- School District 17
- Port/Harbor District 13
- Commercial 7
- Joint Powers Authority 7
- Special District - Other 7
- Sanitation District 5
- Non Profit - Cemetery District 4
- Conservation District 4
- Other 3
- Mitigation Bank 3
- Metropolitan Planning Organization 2
- Non Profit - Education 2
- Transportation Agency 2
- …
MNG_AGENCY >30
- San Diego, City of 309
- Los Angeles, City of 282
- Mountains Recreation and Conservation Authority 263
- California Department of Fish and Wildlife 224
- California Department of Parks and Recreation 192
- San Jose, City of 140
- Ventura, City of 129
- Sacramento, City of 121
- San Francisco, City and County of 112
- Los Angeles, County of 103
- Roseville, City of 90
- Santa Barbara, County of 87
- East Bay Regional Park District 80
- Long Beach, City of 77
- United States Forest Service 72
- Orange, County of 66
- San Diego, County of 63
- Oakland, City of 57
- Napa, City of 55
- Poway, City of 52
- Fresno, City of 51
- United States Fish and Wildlife Service 49
- Yuba County Water Agency 49
- Stockton, City of 48
- United States National Park Service 45
- Modesto, City of 45
- Santa Cruz, City of 44
- Davis, City of 42
- Rocklin, City of 42
- Chula Vista, City of 41
- …
DES_TP >30
- Local Park 4,912
- Local Recreation Area 1,050
- Local Other or Unknown 919
- Private Conservation 342
- Local Conservation Area 263
- State Conservation Area 193
- Private Recreation or Education 142
- State Park 114
- National Forest 68
- Local Historic or Cultural Area 66
- State Recreation Area 56
- State Other or Unknown 55
- Private Other or Unknown 51
- National Wildlife Refuge 49
- State Resource Management Area 46
- State Historic or Cultural Area 35
- Recreation Management Area 28
- National Recreation Area 25
- Federal Other or Unknown 22
- Local Resource Management Area 19
- National Monument or Landmark 17
- Resource Management Area 17
- National Park 12
- Private Agricultural 9
- Wilderness Area 6
- Conservation Area 5
- Private Historic or Cultural 3
- National Public Lands 2
- State Wilderness 2
- None 1
- …
ACCESS_TYP 4
- Open Access 7,814
- Restricted Access 617
- No Public Access 580
- Unknown Access 308
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
666 | 666 | 665 | {"type": "Polygon", "coordinates": [[[-117.75507, 33.51377], [-117.75504, 33.51379], [-117.75501, 33.51409], [-117.75486, 33.51417], [-117.75476, 33.51421], [-117.75457, 33.51422], [-117.75448, 33.5142], [-117.75436, 33.51412], [-117.75435, 33.51396], [-117.75424, 33.51382], [-117.75427, 33.51367], [-117.75369, 33.5132], [-117.75403, 33.51289], [-117.75433, 33.51289], [-117.75507, 33.51377]]]} | Open Access 1 | 3574 | Lang Park | 21008 | 1164 | Laguna Beach, City of 181 | City 2 | City Agency 2 | http://www.lagunabeachcity.net/cityhall/pw/parks.asp | City 2 | 1164 | Laguna Beach, City of 177 | City 2 | City Agency 2 | Orange 3 | 2.361 | Lang Park | 0 | Local Park 2 | 4 | |
2412 | 2412 | 2411 | {"type": "Polygon", "coordinates": [[[-118.78338, 34.19921], [-118.78174, 34.20842], [-118.76116, 34.21338], [-118.75992, 34.2125], [-118.76116, 34.21246], [-118.76119, 34.19892], [-118.76126, 34.19894], [-118.78338, 34.19921]]]} | Open Access 1 | 17245 | Lang Ranch - Jordan Ranch | 14242 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | Ventura 8 | 635.319 | Lang Ranch - Jordan Ranch | 0 | Recreation Management Area 49 | 4 | |
2086 | 2086 | 2085 | {"type": "Polygon", "coordinates": [[[-118.78174, 34.20842], [-118.7775, 34.21463], [-118.76633, 34.21444], [-118.75919, 34.21386], [-118.78174, 34.20842]]]} | Open Access 1 | 17267 | Lang Ranch - Montgomery Ranch Open Space | 21011 | 2118 | Rancho Simi Recreation and Park District 80 | Special District 4 | Recreation/Parks District 4 | http://www.rsrpd.org/ | Special District 4 | 2118 | Rancho Simi Recreation and Park District 78 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 154.362 | Lang Ranch - Montgomery Ranch OS | 0 | Local Recreation Area 3 | 4 | |
2416 | 2416 | 2415 | {"type": "Polygon", "coordinates": [[[-118.83948, 34.20599], [-118.83948, 34.20682], [-118.83946, 34.20772], [-118.83944, 34.20777], [-118.83935, 34.20779], [-118.83919, 34.20776], [-118.83904, 34.20779], [-118.83895, 34.20785], [-118.83892, 34.20791], [-118.83826, 34.20813], [-118.83783, 34.20815], [-118.83715, 34.20883], [-118.83715, 34.20884], [-118.83719, 34.20887], [-118.837, 34.2091], [-118.837, 34.20913], [-118.83692, 34.20916], [-118.83681, 34.20905], [-118.8365, 34.20905], [-118.83649, 34.20907], [-118.8363, 34.20905], [-118.83618, 34.20906], [-118.83616, 34.20922], [-118.83611, 34.20923], [-118.83605, 34.20906], [-118.83598, 34.20906], [-118.83576, 34.20912], [-118.83541, 34.20931], [-118.83532, 34.20926], [-118.8352, 34.20929], [-118.83513, 34.20922], [-118.83484, 34.20926], [-118.83484, 34.20929], [-118.83454, 34.20939], [-118.83452, 34.20947], [-118.83441, 34.20948], [-118.83433, 34.20937], [-118.83425, 34.20937], [-118.83411, 34.20942], [-118.83403, 34.20953], [-118.83408, 34.20965], [-118.8341, 34.20982], [-118.83405, 34.21035], [-118.83393, 34.21049], [-118.83394, 34.21053], [-118.83387, 34.21059], [-118.83377, 34.21054], [-118.83352, 34.21058], [-118.83351, 34.21073], [-118.83357, 34.21076], [-118.83357, 34.21111], [-118.83306, 34.21117], [-118.83226, 34.2113], [-118.83192, 34.21152], [-118.83164, 34.21175], [-118.8313, 34.21186], [-118.83136, 34.21217], [-118.83008, 34.21239], [-118.82957, 34.21252], [-118.82897, 34.21273], [-118.82828, 34.21305], [-118.82798, 34.21244], [-118.82821, 34.21158], [-118.82778, 34.2113], [-118.82724, 34.2113], [-118.82668, 34.21107], [-118.82644, 34.21126], [-118.82629, 34.21127], [-118.82599, 34.2109], [-118.82575, 34.21072], [-118.82539, 34.21073], [-118.82509, 34.21089], [-118.82457, 34.21098], [-118.8244, 34.21115], [-118.82434, 34.2114], [-118.82373, 34.21185], [-118.82358, 34.21194], [-118.82337, 34.21194], [-118.82354, 34.21143], [-118.82367, 34.21119], [-118.82386, 34.2109], [-118.82408, 34.21065], [-118.82438, 34.21036], [-118.82467, 34.21015], [-118.82509, 34.2099], [-118.82554, 34.20971], [-118.82688, 34.2093], [-118.82749, 34.20902], [-118.82803, 34.20866], [-118.82838, 34.20833], [-118.82868, 34.20798], [-118.82882, 34.20778], [-118.82892, 34.20759], [-118.82917, 34.20768], [-118.82945, 34.20731], [-118.82954, 34.20724], [-118.82978, 34.20723], [-118.83043, 34.20726], [-118.83066, 34.20721], [-118.83089, 34.2071], [-118.83106, 34.20706], [-118.83128, 34.20711], [-118.8316, 34.2073], [-118.8323, 34.20732], [-118.8327, 34.20726], [-118.83283, 34.20718], [-118.83311, 34.207], [-118.83323, 34.20654], [-118.8331, 34.2062], [-118.8331, 34.20592], [-118.83921, 34.20597], [-118.83948, 34.20599]]]} | Open Access 1 | 17272 | Lang Ranch Community Park | 21012 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 126.522 | Lang Ranch Community Park | 0 | Local Park 2 | 4 | |
10206 | 10206 | 10205 | {"type": "MultiPolygon", "coordinates": [[[[-118.8266, 34.20923], [-118.82566, 34.20953], [-118.82543, 34.20914], [-118.82516, 34.20905], [-118.8249, 34.20906], [-118.82453, 34.20889], [-118.82345, 34.20873], [-118.82322, 34.20892], [-118.82297, 34.2089], [-118.82208, 34.20911], [-118.82196, 34.20944], [-118.82327, 34.20973], [-118.82325, 34.20997], [-118.82304, 34.2101], [-118.82251, 34.21074], [-118.82202, 34.21113], [-118.82213, 34.21136], [-118.82169, 34.2117], [-118.82185, 34.21196], [-118.82124, 34.21231], [-118.82104, 34.2124], [-118.8208, 34.21246], [-118.82063, 34.21248], [-118.82032, 34.21247], [-118.81798, 34.21203], [-118.8177, 34.21203], [-118.81745, 34.21208], [-118.8174, 34.21197], [-118.81731, 34.21195], [-118.8173, 34.21193], [-118.81667, 34.21184], [-118.81729, 34.21139], [-118.81729, 34.21138], [-118.81364, 34.21039], [-118.81283, 34.20981], [-118.81357, 34.20866], [-118.81591, 34.20906], [-118.81788, 34.2075], [-118.81937, 34.20761], [-118.82135, 34.20873], [-118.82317, 34.20829], [-118.82572, 34.20861], [-118.82591, 34.20886], [-118.8266, 34.20923]]], [[[-118.82606, 34.22664], [-118.82473, 34.22654], [-118.82382, 34.22625], [-118.82336, 34.22619], [-118.82315, 34.22617], [-118.82289, 34.22617], [-118.82233, 34.22623], [-118.82016, 34.22677], [-118.81843, 34.2264], [-118.82133, 34.22553], [-118.82606, 34.22664]]]]} | Open Access 1 | 47125 | Lang Ranch Open Space | 30801 | 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 | http://www.conejo-openspace.org/open_space_areas_in_TO.htm#Lang Ranch | Ventura 8 | 89.538 | Lang Ranch OS | 0 | Local Recreation Area 3 | 4 |
14398 | 14398 | 14397 | {"type": "MultiPolygon", "coordinates": [[[[-118.83129, 34.21425], [-118.83113, 34.21452], [-118.83089, 34.21501], [-118.83048, 34.21489], [-118.83052, 34.21474], [-118.83033, 34.21459], [-118.83011, 34.21451], [-118.82992, 34.21447], [-118.82974, 34.21447], [-118.82958, 34.21449], [-118.82924, 34.2146], [-118.82925, 34.21474], [-118.82934, 34.2149], [-118.82983, 34.21515], [-118.83005, 34.21528], [-118.83022, 34.21534], [-118.83019, 34.21564], [-118.82996, 34.21577], [-118.82996, 34.2157], [-118.82988, 34.21569], [-118.82975, 34.21554], [-118.82956, 34.21547], [-118.82931, 34.21539], [-118.8293, 34.21537], [-118.829, 34.21526], [-118.82894, 34.21535], [-118.8285, 34.21565], [-118.82839, 34.21579], [-118.82845, 34.21612], [-118.82858, 34.21645], [-118.82875, 34.21653], [-118.82859, 34.21668], [-118.82861, 34.21675], [-118.82852, 34.21696], [-118.8289, 34.21703], [-118.82887, 34.21715], [-118.82888, 34.21805], [-118.82876, 34.21837], [-118.82869, 34.21848], [-118.82854, 34.21862], [-118.82836, 34.21873], [-118.8283, 34.2188], [-118.82827, 34.21889], [-118.82829, 34.21898], [-118.82838, 34.21909], [-118.82792, 34.21918], [-118.82801, 34.21944], [-118.82813, 34.21964], [-118.82791, 34.21988], [-118.82779, 34.22003], [-118.82761, 34.22049], [-118.82733, 34.22093], [-118.82742, 34.22154], [-118.82795, 34.22169], [-118.82799, 34.22167], [-118.82812, 34.22166], [-118.82828, 34.22174], [-118.82844, 34.22173], [-118.8285, 34.2217], [-118.82847, 34.22122], [-118.82849, 34.22121], [-118.82845, 34.221], [-118.82851, 34.22099], [-118.8285, 34.22082], [-118.82855, 34.2208], [-118.82856, 34.22063], [-118.82863, 34.22059], [-118.82865, 34.22042], [-118.8288, 34.22039], [-118.8288, 34.22026], [-118.82897, 34.22029], [-118.82897, 34.22015], [-118.8292, 34.22009], [-118.82919, 34.22004], [-118.82942, 34.21995], [-118.82942, 34.21992], [-118.82964, 34.21981], [-118.82968, 34.21985], [-118.82991, 34.21976], [-118.83012, 34.21971], [-118.83035, 34.21969], [-118.83062, 34.2198], [-118.83051, 34.22001], [-118.83017, 34.2199], [-118.82998, 34.21997], [-118.82974, 34.22052], [-118.82957, 34.22077], [-118.82946, 34.22118], [-118.82953, 34.22152], [-118.83022, 34.22173], [-118.82989, 34.22222], [-118.83004, 34.22227], [-118.83008, 34.22308], [-118.82662, 34.22409], [-118.82654, 34.22396], [-118.82543, 34.2238], [-118.82543, 34.2237], [-118.82552, 34.22359], [-118.82563, 34.22357], [-118.82572, 34.22338], [-118.82631, 34.22324], [-118.82688, 34.22294], [-118.82726, 34.22189], [-118.82695, 34.22142], [-118.82614, 34.22119], [-118.82485, 34.22138], [-118.82364, 34.22196], [-118.82263, 34.22211], [-118.82219, 34.22251], [-118.82185, 34.22269], [-118.82148, 34.22258], [-118.82119, 34.22262], [-118.82089, 34.22267], [-118.82046, 34.22276], [-118.8196, 34.22302], [-118.81879, 34.22288], [-118.81848, 34.22301], [-118.81847, 34.22319], [-118.818, 34.22315], [-118.81791, 34.22303], [-118.81766, 34.22281], [-118.81681, 34.22246], [-118.81635, 34.22218], [-118.81629, 34.22211], [-118.81611, 34.22174], [-118.81583, 34.22131], [-118.81548, 34.22152], [-118.81524, 34.22156], [-118.815, 34.22158], [-118.81505, 34.22201], [-118.81532, 34.2223], [-118.81569, 34.22253], [-118.81605, 34.22254], [-118.81715, 34.22278], [-118.81764, 34.22298], [-118.81783, 34.22321], [-118.818, 34.22347], [-118.81739, 34.22343], [-118.81677, 34.22356], [-118.81527, 34.22411], [-118.81526, 34.22397], [-118.81507, 34.22395], [-118.81486, 34.22292], [-118.8141, 34.22303], [-118.81428, 34.22401], [-118.81329, 34.22428], [-118.81317, 34.22439], [-118.81314, 34.22451], [-118.81316, 34.22463], [-118.81344, 34.22512], [-118.81377, 34.22541], [-118.81375, 34.22547], [-118.81382, 34.22556], [-118.81363, 34.22573], [-118.81375, 34.22615], [-118.81396, 34.22627], [-118.81423, 34.22632], [-118.81442, 34.22648], [-118.81499, 34.22649], [-118.81513, 34.22662], [-118.81531, 34.22665], [-118.81564, 34.22659], [-118.81777, 34.22609], [-118.81868, 34.22614], [-118.81921, 34.22599], [-118.81946, 34.22596], [-118.81952, 34.22607], [-118.8177, 34.22661], [-118.81736, 34.22651], [-118.81709, 34.22673], [-118.81678, 34.22673], [-118.81672, 34.22691], [-118.81607, 34.22709], [-118.81349, 34.22675], [-118.81313, 34.22547], [-118.812, 34.22511], [-118.81151, 34.22392], [-118.81045, 34.22448], [-118.80938, 34.22445], [-118.80885, 34.22462], [-118.80812, 34.22432], [-118.80733, 34.22336], [-118.80625, 34.2242], [-118.80479, 34.22333], [-118.80433, 34.22361], [-118.80258, 34.22254], [-118.80178, 34.22244], [-118.80045, 34.22301], [-118.79994, 34.22253], [-118.79886, 34.22263], [-118.79854, 34.22203], [-118.79264, 34.21029], [-118.7958, 34.21037], [-118.79647, 34.21011], [-118.7991, 34.21043], [-118.79926, 34.21206], [-118.7999, 34.21164], [-118.80046, 34.21158], [-118.80075, 34.21041], [-118.80566, 34.21057], [-118.80688, 34.21187], [-118.80927, 34.21239], [-118.80914, 34.21273], [-118.80914, 34.2128], [-118.80894, 34.21317], [-118.80881, 34.21354], [-118.80878, 34.21374], [-118.80865, 34.21394], [-118.80861, 34.21471], [-118.80853, 34.21512], [-118.81002, 34.21543], [-118.80994, 34.21569], [-118.81049, 34.21595], [-118.80994, 34.21607], [-118.80992, 34.21696], [-118.8105, 34.21707], [-118.81082, 34.21682], [-118.81118, 34.21702], [-118.81141, 34.2171], [-118.81238, 34.21724], [-118.81296, 34.21725], [-118.81316, 34.2173], [-118.81377, 34.21729], [-118.81395, 34.21732], [-118.81509, 34.21737], [-118.81532, 34.21731], [-118.81542, 34.21708], [-118.81554, 34.21706], [-118.81578, 34.21683], [-118.81589, 34.21669], [-118.81594, 34.21656], [-118.81615, 34.21637], [-118.81676, 34.21594], [-118.81686, 34.21546], [-118.81715, 34.21504], [-118.81724, 34.21483], [-118.81757, 34.2146], [-118.81764, 34.21458], [-118.81775, 34.21446], [-118.81781, 34.21433], [-118.8178, 34.21423], [-118.81772, 34.21408], [-118.81762, 34.214], [-118.81739, 34.2136], [-118.81649, 34.21343], [-118.81623, 34.21317], [-118.81601, 34.21312], [-118.81577, 34.21312], [-118.81585, 34.21265], [-118.81637, 34.21305], [-118.81664, 34.21319], [-118.81725, 34.21323], [-118.81817, 34.21344], [-118.81916, 34.21315], [-118.82024, 34.21277], [-118.82064, 34.2127], [-118.82091, 34.21283], [-118.82178, 34.21232], [-118.82319, 34.21197], [-118.82314, 34.21229], [-118.82238, 34.21251], [-118.82197, 34.21248], [-118.82152, 34.21265], [-118.82111, 34.21292], [-118.82084, 34.21302], [-118.82038, 34.21296], [-118.81972, 34.21312], [-118.8188, 34.21356], [-118.81815, 34.21362], [-118.81778, 34.21384], [-118.81801, 34.21422], [-118.81788, 34.21452], [-118.81746, 34.21493], [-118.81706, 34.21551], [-118.81698, 34.2159], [-118.81642, 34.21644], [-118.816, 34.21682], [-118.81594, 34.21703], [-118.81553, 34.21757], [-118.81556, 34.2178], [-118.81522, 34.21823], [-118.81542, 34.21882], [-118.81554, 34.21953], [-118.81529, 34.21956], [-118.81544, 34.22098], [-118.8228, 34.22024], [-118.82588, 34.22112], [-118.82588, 34.21944], [-118.82634, 34.21839], [-118.82736, 34.21551], [-118.82768, 34.21453], [-118.82778, 34.21367], [-118.82865, 34.21324], [-118.8287, 34.21343], [-118.82938, 34.21355], [-118.82984, 34.21358], [-118.82985, 34.21348], [-118.83, 34.21344], [-118.83029, 34.21347], [-118.83053, 34.21351], [-118.83085, 34.2136], [-118.83077, 34.2138], [-118.83095, 34.2139], [-118.83113, 34.21402], [-118.83119, 34.21422], [-118.83129, 34.21425]]], [[[-118.82174, 34.22563], [-118.82132, 34.22553], [-118.8209, 34.22566], [-118.82082, 34.22515], [-118.82083, 34.22495], [-118.82098, 34.22456], [-118.82156, 34.22446], [-118.82168, 34.22479], [-118.82174, 34.22563]]], [[[-118.8302, 34.22816], [-118.82606, 34.22664], [-118.82282, 34.22588], [-118.82471, 34.22598], [-118.82513, 34.22571], [-118.82521, 34.22478], [-118.82553, 34.22458], [-118.8264, 34.22436], [-118.8277, 34.22484], [-118.8286, 34.22469], [-118.82912, 34.22502], [-118.82969, 34.22479], [-118.83012, 34.22478], [-118.8302, 34.22816]]], [[[-118.83037, 34.21814], [-118.83035, 34.2183], [-118.83026, 34.21841], [-118.83016, 34.2185], [-118.82997, 34.21877], [-118.82987, 34.21886], [-118.82983, 34.21893], [-118.82953, 34.219], [-118.8297, 34.2193], [-118.82918, 34.21949], [-118.82907, 34.21925], [-118.82901, 34.21923], [-118.82908, 34.21886], [-118.82926, 34.21853], [-118.8293, 34.21854], [-118.82933, 34.21832], [-118.82939, 34.21833], [-118.82946, 34.21811], [-118.82954, 34.21808], [-118.82956, 34.21784], [-118.82944, 34.21764], [-118.82958, 34.21764], [-118.82942, 34.21743], [-118.82955, 34.21734], [-118.82956, 34.21732], [-118.82933, 34.21712], [-118.82905, 34.21708], [-118.82912, 34.21688], [-118.82922, 34.21671], [-118.82933, 34.21659], [-118.82955, 34.21681], [-118.82983, 34.21717], [-118.8301, 34.21712], [-118.83019, 34.21725], [-118.83014, 34.21735], [-118.83033, 34.21757], [-118.83028, 34.21779], [-118.83025, 34.21804], [-118.83037, 34.21814]]], [[[-118.83237, 34.21819], [-118.83191, 34.21872], [-118.83157, 34.21885], [-118.83127, 34.21912], [-118.83111, 34.21938], [-118.83086, 34.21928], [-118.83103, 34.21899], [-118.83148, 34.21854], [-118.83177, 34.21838], [-118.8319, 34.21817], [-118.83199, 34.21796], [-118.83221, 34.21802], [-118.83237, 34.21819]]], [[[-118.83555, 34.21195], [-118.83557, 34.21201], [-118.83557, 34.21224], [-118.83549, 34.21325], [-118.83541, 34.21367], [-118.83528, 34.21413], [-118.83525, 34.21435], [-118.83527, 34.21471], [-118.83497, 34.21472], [-118.83492, 34.21485], [-118.83476, 34.21509], [-118.83426, 34.21561], [-118.83397, 34.21579], [-118.83373, 34.21575], [-118.83354, 34.21593], [-118.83342, 34.21606], [-118.83334, 34.21607], [-118.83323, 34.21617], [-118.83296, 34.21635], [-118.833, 34.21644], [-118.83296, 34.21649], [-118.83272, 34.21652], [-118.83271, 34.21655], [-118.83245, 34.21652], [-118.83239, 34.2166], [-118.83229, 34.21659], [-118.83228, 34.21625], [-118.83219, 34.2162], [-118.83233, 34.21606], [-118.83232, 34.21599], [-118.83244, 34.21587], [-118.8327, 34.21541], [-118.83259, 34.21524], [-118.83235, 34.21503], [-118.8321, 34.21496], [-118.83175, 34.21495], [-118.83169, 34.21528], [-118.83168, 34.21557], [-118.83165, 34.2156], [-118.83158, 34.21577], [-118.83154, 34.21577], [-118.83149, 34.21572], [-118.83125, 34.21574], [-118.83124, 34.21564], [-118.83119, 34.21562], [-118.8313, 34.21517], [-118.83104, 34.21511], [-118.83117, 34.2148], [-118.83142, 34.21434], [-118.83161, 34.21442], [-118.83174, 34.21433], [-118.83205, 34.21423], [-118.8323, 34.21418], [-118.83278, 34.21413], [-118.83293, 34.21405], [-118.83303, 34.2139], [-118.83304, 34.21344], [-118.83315, 34.21308], [-118.83325, 34.21294], [-118.83395, 34.21241], [-118.83404, 34.21229], [-118.83399, 34.21209], [-118.83522, 34.21192], [-118.83546, 34.21192], [-118.83555, 34.21195]]], [[[-118.83794, 34.22443], [-118.8363, 34.22397], [-118.83646, 34.22355], [-118.83677, 34.22368], [-118.83724, 34.22392], [-118.83762, 34.22416], [-118.83794, 34.22443]]], [[[-118.8407, 34.22166], [-118.84057, 34.222], [-118.84031, 34.22223], [-118.83998, 34.22227], [-118.83996, 34.22199], [-118.84001, 34.22197], [-118.84007, 34.22192], [-118.84008, 34.22187], [-118.84007, 34.22181], [-118.8401, 34.22178], [-118.84003, 34.22147], [-118.83962, 34.2215], [-118.83918, 34.22144], [-118.8387, 34.22144], [-118.83808, 34.22161], [-118.83715, 34.22175], [-118.83681, 34.22201], [-118.8371, 34.22146], [-118.83704, 34.22113], [-118.8376, 34.22106], [-118.83756, 34.22092], [-118.83762, 34.22093], [-118.83768, 34.22091], [-118.83773, 34.22105], [-118.83832, 34.22097], [-118.8385, 34.22085], [-118.83899, 34.22083], [-118.83955, 34.22057], [-118.84004, 34.22077], [-118.84041, 34.22109], [-118.8406, 34.22134], [-118.8407, 34.22166]]], [[[-118.84097, 34.21797], [-118.8407, 34.21852], [-118.84062, 34.21872], [-118.84059, 34.21891], [-118.84031, 34.21896], [-118.84019, 34.21887], [-118.83967, 34.21867], [-118.83936, 34.21859], [-118.83926, 34.21882], [-118.83921, 34.21878], [-118.83918, 34.21877], [-118.83924, 34.21857], [-118.83896, 34.21833], [-118.83847, 34.21824], [-118.83819, 34.21815], [-118.83772, 34.21749], [-118.83852, 34.21722], [-118.83874, 34.21706], [-118.83914, 34.21718], [-118.83936, 34.21732], [-118.83952, 34.21748], [-118.8396, 34.21775], [-118.84097, 34.21797]]], [[[-118.84052, 34.22507], [-118.84037, 34.22537], [-118.8395, 34.22504], [-118.83905, 34.22483], [-118.83845, 34.2245], [-118.83794, 34.22417], [-118.83816, 34.22397], [-118.83803, 34.2236], [-118.83849, 34.22361], [-118.83858, 34.22388], [-118.83876, 34.22395], [-118.83907, 34.22386], [-118.83929, 34.22424], [-118.83944, 34.22441], [-118.83958, 34.22454], [-118.83974, 34.22467], [-118.84002, 34.22484], [-118.84042, 34.22504], [-118.84052, 34.22507]]], [[[-118.84085, 34.22439], [-118.84066, 34.22466], [-118.84055, 34.22462], [-118.84035, 34.22452], [-118.84004, 34.22433], [-118.83989, 34.22423], [-118.83978, 34.22412], [-118.83947, 34.22423], [-118.83933, 34.22404], [-118.83961, 34.22384], [-118.83982, 34.22382], [-118.83988, 34.22389], [-118.83996, 34.22391], [-118.83995, 34.22403], [-118.84025, 34.22418], [-118.84061, 34.22412], [-118.84085, 34.22439]]]]} | Open Access 1 | 47126 | Lang Ranch Open Space | 30802 | 1347 | Thousand Oaks, City of 428 | City 2 | City Agency 2 | http://www.ci.thousand-oaks.ca.us/ | City 2 | 1347 | Thousand Oaks, City of 422 | City 2 | City Agency 2 | http://www.conejo-openspace.org/open_space_areas_in_TO.htm#Lang Ranch | Ventura 8 | 746.197 | Lang Ranch OS | 0 | Local Recreation Area 3 | 4 |
13194 | 13194 | 13193 | {"type": "Polygon", "coordinates": [[[-121.53929, 36.84003], [-121.53858, 36.84054], [-121.5378, 36.8404], [-121.5373, 36.84034], [-121.53695, 36.84032], [-121.53817, 36.83949], [-121.53929, 36.84003]]]} | Open Access 1 | 35257 | Lang Street Park | 28553 | 1304 | San Juan Bautista, City of 856 | City 2 | City Agency 2 | http://www.san-juan-bautista.ca.us/ | City 2 | 1304 | San Juan Bautista, City of 834 | City 2 | City Agency 2 | San Benito 38 | 3.062 | Lang Street Park | 0 | Local Park 2 | 4 | |
2160 | 2160 | 2159 | {"type": "Polygon", "coordinates": [[[-122.49486, 37.86031], [-122.49473, 37.86047], [-122.49416, 37.86015], [-122.49437, 37.8599], [-122.49444, 37.86005], [-122.49457, 37.86019], [-122.49476, 37.86028], [-122.49486, 37.86031]]]} | Open Access 1 | 16176 | Langendorf Park | 21014 | 1327 | Sausalito, City of 445 | City 2 | City Agency 2 | http://www.ci.sausalito.ca.us/index.aspx?page=156 | City 2 | 1327 | Sausalito, City of 439 | City 2 | City Agency 2 | Marin 23 | 0.328 | Langendorf Park | 0 | Local Park 2 | 4 | |
1863 | 1863 | 1862 | {"type": "MultiPolygon", "coordinates": [[[[-122.58022, 37.98301], [-122.58014, 37.98311], [-122.57993, 37.98309], [-122.57917, 37.98294], [-122.57907, 37.98292], [-122.57872, 37.98261], [-122.57838, 37.98254], [-122.57833, 37.98259], [-122.57821, 37.98251], [-122.5781, 37.98251], [-122.57801, 37.9826], [-122.57779, 37.98246], [-122.57791, 37.98233], [-122.57834, 37.98228], [-122.57848, 37.98228], [-122.57864, 37.98235], [-122.57887, 37.98237], [-122.57877, 37.98255], [-122.57895, 37.98269], [-122.57906, 37.98272], [-122.57908, 37.98268], [-122.5792, 37.98277], [-122.57919, 37.98281], [-122.57933, 37.98285], [-122.57947, 37.98287], [-122.57953, 37.98292], [-122.58022, 37.98301]]], [[[-122.57817, 37.98218], [-122.57799, 37.9822], [-122.5779, 37.98195], [-122.57804, 37.98182], [-122.57817, 37.98218]]]]} | Open Access 1 | 14215 | Lansdale Park | 21015 | 1292 | San Anselmo, City of 437 | City 2 | City Agency 2 | http://www.townofsananselmo.org/index.aspx?nid=106 | City 2 | 1292 | San Anselmo, City of 431 | City 2 | City Agency 2 | Marin 23 | 1.158 | Lansdale Park | 0 | Local Park 2 | 4 | |
6570 | 6570 | 6569 | {"type": "MultiPolygon", "coordinates": [[[[-117.69044, 33.46418], [-117.69034, 33.46429], [-117.69023, 33.46447], [-117.69002, 33.46503], [-117.68829, 33.46459], [-117.68888, 33.46407], [-117.68896, 33.46406], [-117.68911, 33.46414], [-117.68937, 33.46441], [-117.68946, 33.46447], [-117.68962, 33.4645], [-117.68977, 33.46451], [-117.68996, 33.46447], [-117.69008, 33.46442], [-117.69044, 33.46418]]], [[[-117.69419, 33.46413], [-117.69416, 33.46417], [-117.69406, 33.46424], [-117.69374, 33.46433], [-117.69359, 33.4644], [-117.69355, 33.46427], [-117.69347, 33.46415], [-117.69334, 33.46406], [-117.69324, 33.46402], [-117.69313, 33.46401], [-117.69291, 33.46402], [-117.69269, 33.464], [-117.69209, 33.46393], [-117.69148, 33.46393], [-117.69151, 33.46387], [-117.69148, 33.4638], [-117.6914, 33.46375], [-117.69133, 33.46374], [-117.69118, 33.46379], [-117.69098, 33.4638], [-117.69085, 33.46382], [-117.69069, 33.46388], [-117.69039, 33.46403], [-117.69004, 33.46427], [-117.68981, 33.46437], [-117.68966, 33.46438], [-117.68956, 33.46436], [-117.68947, 33.46432], [-117.68911, 33.46392], [-117.68911, 33.46386], [-117.68941, 33.46363], [-117.68956, 33.46354], [-117.68997, 33.46325], [-117.69023, 33.4631], [-117.69063, 33.46296], [-117.69143, 33.46279], [-117.69352, 33.46272], [-117.69359, 33.46279], [-117.69359, 33.46298], [-117.69361, 33.46311], [-117.69368, 33.46339], [-117.69375, 33.46357], [-117.69395, 33.46387], [-117.69419, 33.46413]]]]} | Open Access 1 | 3587 | Lantern Bay Park | 21016 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 15.065 | Lantern Bay Park | 0 | Local Park 2 | 4 | |
12820 | 12820 | 12819 | {"type": "Polygon", "coordinates": [[[-117.70075, 33.46947], [-117.70035, 33.46948], [-117.70034, 33.46925], [-117.70036, 33.4692], [-117.7004, 33.46919], [-117.70074, 33.4692], [-117.70075, 33.46947]]]} | Open Access 1 | 30264 | Lantern Village Community Park | 21017 | 1079 | Dana Point, City of 134 | City 2 | City Agency 2 | http://www.danapoint.org/index.aspx?page=170 | City 2 | 1079 | Dana Point, City of 131 | City 2 | City Agency 2 | Orange 3 | 0.285 | Lantern Village Community Park | 0 | Local Park 2 | 4 | |
11599 | 11599 | 11598 | {"type": "Polygon", "coordinates": [[[-122.04626, 37.8944], [-122.04582, 37.8944], [-122.04509, 37.89456], [-122.04498, 37.89426], [-122.04452, 37.8938], [-122.04432, 37.89326], [-122.04391, 37.89342], [-122.0439, 37.89335], [-122.04464, 37.89304], [-122.04447, 37.89237], [-122.04619, 37.89209], [-122.04623, 37.89225], [-122.04635, 37.89256], [-122.04658, 37.89337], [-122.0466, 37.8935], [-122.04659, 37.89358], [-122.04656, 37.89374], [-122.04628, 37.89429], [-122.04626, 37.8944]]]} | Open Access 1 | 23704 | Lar Rieu Park | 21019 | 1371 | Walnut Creek, City of 178 | City 2 | City Agency 2 | http://www.ci.walnut-creek.ca.us/citygov/depts/ps/openspace/default.asp | City 2 | 1371 | Walnut Creek, City of 174 | City 2 | City Agency 2 | Contra Costa 12 | 9.991 | Lar Rieu Park | 0 | Local Park 2 | 4 | |
6355 | 6355 | 6354 | {"type": "Polygon", "coordinates": [[[-117.15188, 34.05979], [-117.15126, 34.05999], [-117.15094, 34.05988], [-117.15069, 34.05981], [-117.14873, 34.05948], [-117.14829, 34.05937], [-117.14779, 34.05923], [-117.14781, 34.05921], [-117.14787, 34.0592], [-117.14814, 34.05922], [-117.14831, 34.05926], [-117.14861, 34.0594], [-117.14883, 34.05946], [-117.15049, 34.05971], [-117.15073, 34.0597], [-117.15092, 34.05965], [-117.1511, 34.05958], [-117.15132, 34.05945], [-117.15148, 34.05939], [-117.15165, 34.05936], [-117.15185, 34.05936], [-117.15189, 34.05939], [-117.15188, 34.05979]]]} | Open Access 1 | 48364 | Laramie Park | 32929 | 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 | 1.645 | Laramie Park | 0 | Local Park 2 | 4 | |
8172 | 8172 | 8171 | {"type": "Polygon", "coordinates": [[[-117.53199, 33.98073], [-117.53199, 33.98121], [-117.53198, 33.98135], [-117.53184, 33.98166], [-117.53179, 33.9817], [-117.53155, 33.98164], [-117.53138, 33.98163], [-117.53008, 33.98163], [-117.52977, 33.98166], [-117.52952, 33.98093], [-117.52983, 33.98083], [-117.53023, 33.98075], [-117.53199, 33.98073]]]} | Open Access 1 | 12401 | Laramore Park | 21020 | 2051 | Jurupa Area Recreation and Park District 364 | Special District 4 | Recreation/Parks District 4 | http://www.jarpd.org/ | Special District 4 | 2051 | Jurupa Area Recreation and Park District 360 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 5.182 | Laramore Park | 0 | Local Park 2 | 4 | |
5470 | 5470 | 5469 | {"type": "Polygon", "coordinates": [[[-121.44381, 37.76634], [-121.44267, 37.76647], [-121.44266, 37.7651], [-121.4438, 37.7651], [-121.44381, 37.76634]]]} | Open Access 1 | 17337 | Larch Clover Park | 21021 | 322 | San Joaquin, County of 479 | County 3 | County Agency 3 | http://www.sjparks.com/ | County 3 | 322 | San Joaquin, County of 471 | County 3 | County Agency 3 | San Joaquin 39 | 3.616 | Larch Clover Park | 0 | Local Park 2 | 4 | |
11701 | 11701 | 11700 | {"type": "Polygon", "coordinates": [[[-121.36093, 38.5692], [-121.36015, 38.56933], [-121.35965, 38.56944], [-121.35916, 38.56957], [-121.35834, 38.56982], [-121.35794, 38.56992], [-121.35784, 38.56966], [-121.35782, 38.56964], [-121.35786, 38.56961], [-121.35791, 38.56965], [-121.35818, 38.56972], [-121.35829, 38.56947], [-121.35801, 38.56939], [-121.35801, 38.56936], [-121.35839, 38.56926], [-121.35755, 38.56692], [-121.35819, 38.56676], [-121.35839, 38.56669], [-121.35861, 38.56657], [-121.35882, 38.5664], [-121.35902, 38.56654], [-121.35909, 38.56657], [-121.35973, 38.56835], [-121.36055, 38.56815], [-121.36093, 38.5692]]]} | Open Access 1 | 23998 | Larchmont Community Park | 21023 | 2193 | Cordova Recreation and Park District 307 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.com/ | Special District 4 | 2193 | Cordova Recreation and Park District 304 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 14.052 | Larchmont Community Park | 0 | Local Park 2 | 4 | |
11623 | 11623 | 11622 | {"type": "Polygon", "coordinates": [[[-121.37962, 38.68643], [-121.37957, 38.68671], [-121.37957, 38.68692], [-121.3796, 38.68713], [-121.37957, 38.68716], [-121.37857, 38.68731], [-121.37852, 38.6873], [-121.37849, 38.68727], [-121.37842, 38.68704], [-121.37826, 38.68674], [-121.37826, 38.6867], [-121.37841, 38.68659], [-121.37856, 38.68647], [-121.37869, 38.68633], [-121.37876, 38.68623], [-121.37879, 38.68621], [-121.37886, 38.68621], [-121.37957, 38.68637], [-121.37961, 38.68639], [-121.37962, 38.68643]]]} | Open Access 1 | 23905 | Larchmont Park | 21024 | 2284 | North Highland Recreation and Park District 985 | Special District 4 | Recreation/Parks District 4 | http://www.nhrpd.org/Default.htm | Special District 4 | 2284 | North Highland Recreation and Park District 949 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 2.617 | Larchmont Park | 0 | Local Park 2 | 4 | |
11675 | 11675 | 11674 | {"type": "Polygon", "coordinates": [[[-121.29376, 38.61641], [-121.2926, 38.61697], [-121.29226, 38.61708], [-121.29206, 38.61712], [-121.29167, 38.61716], [-121.29062, 38.61718], [-121.29062, 38.61689], [-121.29072, 38.61685], [-121.29073, 38.61566], [-121.29074, 38.61549], [-121.29093, 38.61504], [-121.29109, 38.61476], [-121.29116, 38.61472], [-121.29167, 38.61484], [-121.29284, 38.61492], [-121.29299, 38.61537], [-121.29344, 38.61594], [-121.29363, 38.61625], [-121.29376, 38.61641]]]} | Open Access 1 | 23968 | Larchmont-Rossmoor Park | 21022 | 2193 | Cordova Recreation and Park District 307 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.com/ | Special District 4 | 2193 | Cordova Recreation and Park District 304 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 13.184 | Larchmont-Rossmoor Park | 0 | Local Park 2 | 4 | |
5246 | 5246 | 5245 | {"type": "Polygon", "coordinates": [[[-119.76314, 36.79821], [-119.76314, 36.79947], [-119.76112, 36.79948], [-119.76112, 36.79821], [-119.76314, 36.79821]]]} | Open Access 1 | 1342 | Large Park | 21025 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 6.238 | Large Park | 0 | Local Park 2 | 4 | |
7560 | 7560 | 7559 | {"type": "MultiPolygon", "coordinates": [[[[-117.94229, 34.13664], [-117.9421, 34.13679], [-117.94137, 34.1372], [-117.94117, 34.1373], [-117.94031, 34.13764], [-117.93932, 34.138], [-117.9386, 34.1383], [-117.93794, 34.13857], [-117.93747, 34.13882], [-117.93682, 34.13925], [-117.93592, 34.14006], [-117.93508, 34.1411], [-117.9344, 34.14184], [-117.93412, 34.14179], [-117.93422, 34.14139], [-117.93331, 34.14123], [-117.93347, 34.14106], [-117.93378, 34.14105], [-117.93408, 34.14099], [-117.93435, 34.14088], [-117.93459, 34.14074], [-117.93754, 34.13815], [-117.93754, 34.13814], [-117.93733, 34.13814], [-117.93445, 34.14066], [-117.93433, 34.14074], [-117.93407, 34.14085], [-117.93378, 34.14091], [-117.93358, 34.14092], [-117.93953, 34.13483], [-117.94229, 34.13664]]], [[[-117.93852, 34.14177], [-117.93791, 34.14249], [-117.93468, 34.14189], [-117.93496, 34.1416], [-117.93526, 34.14116], [-117.93852, 34.14177]]], [[[-117.93154, 34.14925], [-117.93138, 34.14956], [-117.93031, 34.15081], [-117.9302, 34.15095], [-117.9302, 34.15097], [-117.9297, 34.15096], [-117.92984, 34.15081], [-117.93154, 34.14925]]], [[[-117.93088, 34.14369], [-117.92715, 34.14751], [-117.92645, 34.15071], [-117.9232, 34.15069], [-117.91761, 34.15518], [-117.9208, 34.15208], [-117.92326, 34.14947], [-117.92813, 34.14533], [-117.93088, 34.14369]]], [[[-117.92495, 34.15451], [-117.92447, 34.15451], [-117.92446, 34.15494], [-117.92389, 34.15495], [-117.92388, 34.15529], [-117.92338, 34.1553], [-117.92337, 34.15562], [-117.92288, 34.15562], [-117.92287, 34.15569], [-117.92271, 34.1557], [-117.92274, 34.15444], [-117.92495, 34.15443], [-117.92495, 34.15451]]], [[[-117.92224, 34.15624], [-117.92053, 34.15798], [-117.92053, 34.15798], [-117.92058, 34.15624], [-117.92224, 34.15624]]], [[[-117.91608, 34.15641], [-117.9142, 34.15792], [-117.90997, 34.16133], [-117.91028, 34.15932], [-117.91033, 34.15929], [-117.91141, 34.15894], [-117.91249, 34.15851], [-117.91372, 34.15792], [-117.91397, 34.15779], [-117.91492, 34.15723], [-117.9156, 34.15678], [-117.91608, 34.15641]]]]} | Open Access 1 | 7258 | Lario Staging Area | 28955 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Lario_Staging_Area | Los Angeles 6 | 103.71 | Lario Staging Area | 0 | Recreation Management Area 49 | 4 |
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]);