units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,203 rows where ACCESS_TYP = 2 sorted by PARK_URL
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- California Department of Fish and Wildlife 69
- University of California 46
- United States Fish and Wildlife Service 41
- Woodbridge Village Association 31
- Home Owners Association - Unknown Name 27
- Sacramento, County of 23
- Los Angeles, City of 20
- Whittier, City of 20
- East Bay Regional Park District 19
- Rancho Santa Margarita Landscape and Recreation Corporation 18
- Sempervirens Fund 16
- Los Angeles Unified School District 16
- San Ramon, City of 15
- Los Angeles, County of 14
- The Nature Conservancy 13
- Land Trust of Napa County 13
- Big Sur Land Trust 13
- United States Bureau of Land Management 12
- California Department of Parks and Recreation 11
- San Diego, City of 10
- Sonoma Land Trust 9
- Long Beach, City of 9
- San Francisco - Public Utilities Commission, City and County of 8
- United States National Park Service 8
- Arcadia, City of 8
- Sonoma County Agricultural Preservation and Open Space District 8
- Manhattan Beach, City of 8
- Santa Cruz, City of 7
- Hayward Area Recreation and Park District 7
- Amerige Heights Community Association 7
- …
DES_TP >30
- Local Recreation Area 218
- Local Park 209
- Private Recreation or Education 194
- Private Conservation 147
- State Conservation Area 107
- Local Conservation Area 45
- National Wildlife Refuge 36
- Local Other or Unknown 31
- National Public Lands 9
- Recreation Management Area 9
- State Resource Management Area 7
- Private Other or Unknown 7
- Federal Other or Unknown 6
- Conservation Area 5
- State Park 4
- National Park 4
- State Recreation Area 4
- Local Resource Management Area 4
- Private Agricultural 4
- Local Historic or Cultural Area 3
- National Recreation Area 2
- Resource Management Area 2
- None 1
- Wilderness Area 1
- None 1
- National Monument or Landmark 1
- State Other or Unknown 1
- State Historic or Cultural Area 1
- None 1
- None 1
- …
MNG_AG_TYP 25
- City Agency 358
- Home Owners Association 202
- State Agency 146
- Non Profit - Land Trust 132
- Federal Agency 80
- Recreation/Parks District 64
- County Agency 58
- School District 38
- Non Profit - Conservation 20
- Water District 13
- County Agency - Parks 11
- County Agency - Other 10
- Commercial 9
- Non Profit - Other 8
- Open Space District 7
- Joint Powers Authority 6
- Community Services District 4
- Flood District 3
- Irrigation District 3
- Other 3
- Conservation District 3
- Sanitation District 2
- Metropolitan Planning Organization 1
- Home Owners Associatin 1
- Non Profit - Education 1
ACCESS_TYP 1
- Restricted Access · 1,183 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
488 | 488 | 487 | {"type": "Polygon", "coordinates": [[[-119.21476, 35.98254], [-119.21472, 35.98615], [-119.21039, 35.98615], [-119.21036, 35.98257], [-119.21476, 35.98254]]]} | Restricted Access 2 | 1685 | Pixley Preserve | 23759 | 3014 | Center for Natural Lands Management 91 | Non Profit 6 | Non Profit - Land Trust 10 | http://cnlm.org/ | Non Governmental Organization 10 | 3014 | Center for Natural Lands Management 89 | Non Profit 6 | Non Profit - Land Trust 10 | Tulare 29 | 38.802 | Pixley Preserve | 0 | Private Conservation 16 | 2 | |
631 | 631 | 630 | {"type": "Polygon", "coordinates": [[[-122.25462, 39.99416], [-122.2544, 40.00129], [-122.25096, 40.00128], [-122.24748, 40.00133], [-122.24757, 39.99403], [-122.24456, 39.99402], [-122.23507, 39.99405], [-122.23535, 39.98688], [-122.23987, 39.98679], [-122.2466, 39.98672], [-122.25062, 39.98668], [-122.25422, 39.9867], [-122.25416, 39.99039], [-122.25416, 39.99414], [-122.25462, 39.99416]]]} | Restricted Access 2 | 4792 | Thomes Creek Ecological Reserve | 26310 | 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 | Tehama 18 | 442.371 | Thomes Creek ER | 0 | State Conservation Area 8 | 2 | |
655 | 655 | 654 | {"type": "Polygon", "coordinates": [[[-122.60188, 38.34223], [-122.60099, 38.34219], [-122.59824, 38.34219], [-122.59784, 38.34221], [-122.59674, 38.34238], [-122.59579, 38.34284], [-122.59514, 38.34423], [-122.59427, 38.34493], [-122.59333, 38.34522], [-122.59334, 38.34582], [-122.59113, 38.34633], [-122.5913, 38.34768], [-122.59135, 38.34828], [-122.5912, 38.3487], [-122.59122, 38.34925], [-122.59128, 38.34926], [-122.5913, 38.34965], [-122.59261, 38.35027], [-122.59275, 38.35752], [-122.58592, 38.35768], [-122.58582, 38.35554], [-122.5836, 38.35559], [-122.58354, 38.34758], [-122.58768, 38.34758], [-122.58754, 38.34322], [-122.5927, 38.34315], [-122.59271, 38.33808], [-122.59176, 38.33786], [-122.59079, 38.33744], [-122.58972, 38.33705], [-122.58885, 38.33685], [-122.588, 38.3368], [-122.58729, 38.33644], [-122.5869, 38.33609], [-122.58626, 38.33575], [-122.58571, 38.33561], [-122.58518, 38.33551], [-122.58545, 38.33521], [-122.58614, 38.33528], [-122.58697, 38.33561], [-122.58767, 38.33622], [-122.58824, 38.33643], [-122.58911, 38.33648], [-122.58974, 38.33662], [-122.5905, 38.33687], [-122.59169, 38.33743], [-122.5927, 38.33768], [-122.59271, 38.33767], [-122.59272, 38.33589], [-122.60179, 38.33588], [-122.60186, 38.34013], [-122.60188, 38.34223]], [[-122.5906, 38.3493], [-122.59059, 38.34928], [-122.59046, 38.34931], [-122.59053, 38.34931], [-122.5906, 38.3493]]]} | Restricted Access 2 | 3269 | Fairfield Osborn Preserve | 18798 | 211 | California State University Sonoma 232 | State 5 | State Agency 5 | http://www.sonoma.edu/ | Other State 5 | 211 | California State University Sonoma 228 | State 5 | State Agency 5 | Sonoma 16 | 414.364 | Fairfield Osborn Preserve | 2004 | State Conservation Area 8 | 2 | |
672 | 672 | 671 | {"type": "Polygon", "coordinates": [[[-122.10311, 37.87618], [-122.10304, 37.87629], [-122.10157, 37.87704], [-122.10079, 37.87704], [-122.10071, 37.87693], [-122.10056, 37.87677], [-122.09956, 37.8759], [-122.09896, 37.87548], [-122.09889, 37.87537], [-122.09866, 37.87468], [-122.09864, 37.87453], [-122.10311, 37.87618]]]} | Restricted Access 2 | 5104 | 711 St. Mary's Road Park | 15210 | 1163 | Lafayette, City of 236 | City 2 | City Agency 2 | http://www.ci.lafayette.ca.us/index.aspx?page=87 | City 2 | 1163 | Lafayette, City of 232 | City 2 | City Agency 2 | Contra Costa 12 | 11.502 | 711 St. Mary's Road Park | 1983 | Local Park 2 | 4 | |
705 | 705 | 704 | {"type": "Polygon", "coordinates": [[[-117.79528, 33.68552], [-117.79478, 33.68601], [-117.79345, 33.68511], [-117.79387, 33.68468], [-117.79439, 33.68492], [-117.79528, 33.68552]]]} | Restricted Access 2 | 3955 | Lemongrass Park | 21155 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 2.759 | Lemongrass Park | 0 | Private Recreation or Education 65 | 4 | |
770 | 770 | 769 | {"type": "MultiPolygon", "coordinates": [[[[-119.5289, 34.39581], [-119.52824, 34.3972], [-119.52811, 34.3971], [-119.52714, 34.39789], [-119.52649, 34.39736], [-119.52855, 34.39567], [-119.5289, 34.39581]]], [[[-119.52817, 34.39735], [-119.52805, 34.39762], [-119.52771, 34.39836], [-119.52732, 34.39804], [-119.52817, 34.39735]]]]} | Restricted Access 2 | 4493 | Carpinteria Salt Marsh Reserve | 16899 | 1047 | Carpinteria, City of 72 | City 2 | City Agency 2 | http://www.carpinteria.ca.us/parks_rec/index.shtml | City 2 | 1047 | Carpinteria, City of 70 | City 2 | City Agency 2 | Santa Barbara 7 | 5.768 | Carpinteria Salt Marsh Reserve | 0 | Local Conservation Area 4 | 2 | |
779 | 779 | 778 | {"type": "Polygon", "coordinates": [[[-117.80378, 33.68325], [-117.80318, 33.68385], [-117.8024, 33.68332], [-117.80299, 33.68272], [-117.80378, 33.68325]]]} | Restricted Access 2 | 5060 | Birdsong Park | 16124 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 1.997 | Birdsong Park | 0 | Private Recreation or Education 65 | 4 | |
781 | 781 | 780 | {"type": "Polygon", "coordinates": [[[-121.83892, 37.69284], [-121.83892, 37.69497], [-121.83838, 37.69541], [-121.83777, 37.69567], [-121.83724, 37.69614], [-121.83653, 37.69638], [-121.83615, 37.6966], [-121.8359, 37.6971], [-121.83545, 37.69735], [-121.83435, 37.69759], [-121.83308, 37.69793], [-121.83316, 37.69844], [-121.83289, 37.69879], [-121.83205, 37.69921], [-121.83202, 37.6983], [-121.82998, 37.69835], [-121.82998, 37.70055], [-121.82094, 37.70062], [-121.81888, 37.69912], [-121.81883, 37.69713], [-121.82405, 37.69676], [-121.8243, 37.69635], [-121.82403, 37.6952], [-121.82983, 37.6953], [-121.83021, 37.69279], [-121.83892, 37.69284]]]} | Restricted Access 2 | 5062 | Las Positas Golf Course | 33002 | 1178 | Livermore, City of 256 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | Alameda 17 | 216.12 | Las Positas GC | 0 | Local Recreation Area 3 | 4 | |
801 | 801 | 800 | {"type": "Polygon", "coordinates": [[[-117.96358, 33.88243], [-117.96358, 33.8825], [-117.96344, 33.88286], [-117.96216, 33.88253], [-117.96201, 33.8825], [-117.96195, 33.88252], [-117.96179, 33.88286], [-117.96169, 33.88291], [-117.96154, 33.8829], [-117.96146, 33.88298], [-117.9612, 33.8838], [-117.96112, 33.88384], [-117.9608, 33.88378], [-117.96076, 33.88375], [-117.96074, 33.8837], [-117.96106, 33.88283], [-117.96104, 33.8828], [-117.96086, 33.88272], [-117.96083, 33.88261], [-117.96097, 33.88214], [-117.96093, 33.88209], [-117.96088, 33.88205], [-117.95971, 33.88173], [-117.95964, 33.88171], [-117.95962, 33.88168], [-117.95968, 33.88149], [-117.95974, 33.88142], [-117.95979, 33.8814], [-117.96346, 33.88234], [-117.96354, 33.88238], [-117.96358, 33.88243]]]} | Restricted Access 2 | 5203 | McDermont Park | 22019 | 6062 | Amerige Heights Community Association 263 | Private 7 | Home Owners Association 16 | http://www.amerigeheights.org/ | Private 14 | 6062 | Amerige Heights Community Association 259 | Private 7 | Home Owners Association 15 | Orange 3 | 7.049 | McDermont Park | 0 | Private Recreation or Education 65 | 4 | |
806 | 806 | 805 | {"type": "Polygon", "coordinates": [[[-118.36891, 33.73931], [-118.36872, 33.73989], [-118.36801, 33.74037], [-118.3676, 33.74059], [-118.36705, 33.7408], [-118.36659, 33.74091], [-118.36593, 33.741], [-118.36518, 33.74102], [-118.36184, 33.74064], [-118.36135, 33.74054], [-118.36085, 33.74039], [-118.36043, 33.74023], [-118.35991, 33.74], [-118.36013, 33.7397], [-118.36194, 33.73906], [-118.36225, 33.73793], [-118.36307, 33.73841], [-118.36421, 33.7389], [-118.36458, 33.73893], [-118.36486, 33.73874], [-118.36576, 33.73874], [-118.36599, 33.73867], [-118.36603, 33.73842], [-118.36669, 33.73848], [-118.36759, 33.73837], [-118.36825, 33.73811], [-118.3684, 33.7379], [-118.36858, 33.73667], [-118.36844, 33.73652], [-118.36862, 33.73606], [-118.36885, 33.7361], [-118.36869, 33.73753], [-118.36863, 33.73839], [-118.36868, 33.73907], [-118.36891, 33.73931]]]} | Restricted Access 2 | 5870 | Abalone Cove Shoreline Archery Range | 29497 | 1265 | Rancho Palos Verdes, City of 265 | City 2 | City Agency 2 | http://palosverdes.com/rpv/recreationparks/index.cfm | City 2 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 45.317 | Abalone Cove Shoreline Archery Range | None 73 | |||
821 | 821 | 820 | {"type": "Polygon", "coordinates": [[[-119.53705, 34.39762], [-119.53691, 34.39788], [-119.53683, 34.39811], [-119.53663, 34.39814], [-119.5363, 34.39809], [-119.53573, 34.39815], [-119.53545, 34.39819], [-119.53521, 34.39816], [-119.53497, 34.39818], [-119.53464, 34.39818], [-119.53427, 34.39808], [-119.53403, 34.39803], [-119.5335, 34.39773], [-119.53323, 34.39755], [-119.53281, 34.39735], [-119.53248, 34.3973], [-119.53128, 34.39727], [-119.53107, 34.39724], [-119.53026, 34.3983], [-119.53009, 34.39857], [-119.53001, 34.39873], [-119.52919, 34.40081], [-119.52741, 34.39995], [-119.52766, 34.39928], [-119.52762, 34.39924], [-119.52846, 34.39735], [-119.52924, 34.39568], [-119.52955, 34.39577], [-119.52973, 34.39585], [-119.5299, 34.39596], [-119.53022, 34.39624], [-119.53043, 34.39636], [-119.53067, 34.39646], [-119.53093, 34.39652], [-119.5317, 34.39665], [-119.53235, 34.39667], [-119.53247, 34.39671], [-119.5329, 34.39689], [-119.53313, 34.39694], [-119.53377, 34.397], [-119.53389, 34.39704], [-119.53404, 34.39712], [-119.53454, 34.39751], [-119.53475, 34.3976], [-119.53497, 34.39763], [-119.53705, 34.39762]], [[-119.53089, 34.3966], [-119.53067, 34.39687], [-119.53068, 34.39688], [-119.53112, 34.39696], [-119.53132, 34.39671], [-119.5313, 34.39667], [-119.53089, 34.3966]]]} | Restricted Access 2 | 4583 | Carpinteria Salt Marsh Reserve | 16901 | 3033 | Land Trust for Santa Barbara County 269 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sblandtrust.org | Non Governmental Organization 10 | 3033 | Land Trust for Santa Barbara County 264 | Non Profit 6 | Non Profit - Land Trust 10 | Santa Barbara 7 | 32.897 | Carpinteria Salt Marsh Reserve | 0 | Private Conservation 16 | 2 | |
840 | 840 | 839 | {"type": "Polygon", "coordinates": [[[-117.95755, 33.88747], [-117.95754, 33.88755], [-117.95748, 33.88761], [-117.95743, 33.88762], [-117.9565, 33.88761], [-117.95641, 33.88756], [-117.95633, 33.88746], [-117.95631, 33.88741], [-117.95629, 33.88728], [-117.9563, 33.88721], [-117.95632, 33.88719], [-117.9564, 33.88717], [-117.95751, 33.88743], [-117.95755, 33.88747]]]} | Restricted Access 2 | 4941 | Mackey Neighborhood Park | 21637 | 6062 | Amerige Heights Community Association 263 | Private 7 | Home Owners Association 16 | http://www.amerigeheights.org/ | Private 14 | 6062 | Amerige Heights Community Association 259 | Private 7 | Home Owners Association 15 | Orange 3 | 0.97 | Mackey Neighborhood Park | 0 | Private Recreation or Education 65 | 4 | |
947 | 947 | 946 | {"type": "MultiPolygon", "coordinates": [[[[-118.30927, 33.77858], [-118.30758, 33.77901], [-118.3066, 33.7792], [-118.30555, 33.77935], [-118.30359, 33.77951], [-118.30379, 33.77922], [-118.30356, 33.7791], [-118.30373, 33.77882], [-118.30371, 33.77863], [-118.30258, 33.77836], [-118.30228, 33.77858], [-118.30213, 33.77866], [-118.30196, 33.77871], [-118.30179, 33.77874], [-118.30145, 33.77873], [-118.30114, 33.77863], [-118.30124, 33.77834], [-118.3011, 33.7783], [-118.30143, 33.77756], [-118.3013, 33.77738], [-118.30092, 33.7772], [-118.30093, 33.77658], [-118.30075, 33.77653], [-118.30073, 33.77656], [-118.3002, 33.77642], [-118.30015, 33.77669], [-118.30004, 33.7768], [-118.29989, 33.77685], [-118.29945, 33.77691], [-118.29942, 33.77696], [-118.29941, 33.77494], [-118.296, 33.77494], [-118.2959, 33.77466], [-118.29444, 33.77083], [-118.29424, 33.77018], [-118.29413, 33.76975], [-118.29404, 33.76934], [-118.29402, 33.76908], [-118.29401, 33.76865], [-118.29405, 33.76753], [-118.29404, 33.76724], [-118.294, 33.76667], [-118.29394, 33.76629], [-118.29718, 33.76629], [-118.29719, 33.76641], [-118.29801, 33.76687], [-118.29825, 33.76705], [-118.29891, 33.76743], [-118.29912, 33.76759], [-118.29932, 33.7677], [-118.30005, 33.76787], [-118.30059, 33.76797], [-118.30179, 33.76827], [-118.30185, 33.76825], [-118.30188, 33.76819], [-118.30407, 33.76881], [-118.30522, 33.76959], [-118.30699, 33.77065], [-118.30701, 33.77105], [-118.30741, 33.77167], [-118.30772, 33.77175], [-118.30895, 33.77159], [-118.30875, 33.77225], [-118.30863, 33.77282], [-118.30859, 33.77321], [-118.3086, 33.77377], [-118.30863, 33.77407], [-118.30927, 33.77858]]], [[[-118.30012, 33.77981], [-118.29971, 33.77989], [-118.29931, 33.78001], [-118.29894, 33.78016], [-118.29858, 33.78034], [-118.29825, 33.78056], [-118.29796, 33.78081], [-118.29759, 33.78122], [-118.2974, 33.78122], [-118.29726, 33.78129], [-118.29689, 33.78086], [-118.29719, 33.7805], [-118.29739, 33.7803], [-118.2976, 33.78013], [-118.2979, 33.77991], [-118.29838, 33.77962], [-118.29904, 33.77935], [-118.29933, 33.77926], [-118.29938, 33.77939], [-118.29967, 33.77967], [-118.29978, 33.77974], [-118.3001, 33.77979], [-118.30012, 33.77981]]]]} | Restricted Access 2 | 5975 | Defense Fuel Supply Point (DFSP) - Hab. Restoration | 18013 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 326.646 | Defense Fuel Supply Point (DFSP) - Hab. Restoration | 0 | Federal Other or Unknown 87 | 4 | ||
968 | 968 | 967 | {"type": "Polygon", "coordinates": [[[-118.10763, 33.83029], [-118.10763, 33.83204], [-118.10759, 33.8321], [-118.09924, 33.83206], [-118.09919, 33.83205], [-118.09916, 33.83201], [-118.09956, 33.8307], [-118.09974, 33.83027], [-118.10362, 33.83028], [-118.10363, 33.83055], [-118.10507, 33.83056], [-118.10508, 33.83028], [-118.10763, 33.83029]]]} | Restricted Access 2 | 6607 | Heartwell Golf Course | 33019 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 36.514 | Heartwell GC | 0 | Local Recreation Area 3 | 4 | |
1030 | 1030 | 1029 | {"type": "Polygon", "coordinates": [[[-118.04152, 33.87135], [-118.04149, 33.87145], [-118.04152, 33.87159], [-118.04153, 33.87191], [-118.04149, 33.87195], [-118.04002, 33.87196], [-118.03998, 33.87195], [-118.03997, 33.87192], [-118.04, 33.87181], [-118.03999, 33.87176], [-118.03996, 33.87172], [-118.0399, 33.87171], [-118.03989, 33.87119], [-118.04023, 33.87119], [-118.04045, 33.87115], [-118.04068, 33.87106], [-118.04094, 33.87089], [-118.04112, 33.87082], [-118.04125, 33.8708], [-118.04146, 33.8708], [-118.0415, 33.87082], [-118.04152, 33.87135]]]} | Restricted Access 2 | 5646 | Friendship Park | 19120 | 1051 | Cerritos, City of 225 | City 2 | City Agency 2 | http://www.ci.cerritos.ca.us/ | City 2 | 1051 | Cerritos, City of 221 | City 2 | City Agency 2 | Los Angeles 6 | 3.848 | Friendship Park | 0 | Local Park 2 | 4 | |
1070 | 1070 | 1069 | {"type": "Polygon", "coordinates": [[[-118.12169, 34.18412], [-118.12169, 34.18484], [-118.12109, 34.18492], [-118.12098, 34.18506], [-118.12057, 34.18506], [-118.12058, 34.18579], [-118.11862, 34.1858], [-118.11862, 34.18574], [-118.11762, 34.1841], [-118.11755, 34.18393], [-118.1175, 34.18371], [-118.11747, 34.18334], [-118.11742, 34.18334], [-118.11734, 34.18092], [-118.11782, 34.18092], [-118.11781, 34.18075], [-118.11767, 34.18048], [-118.11767, 34.18009], [-118.11806, 34.18009], [-118.1181, 34.1796], [-118.12141, 34.17957], [-118.12144, 34.18233], [-118.12147, 34.18248], [-118.12158, 34.18276], [-118.12162, 34.18294], [-118.12162, 34.18319], [-118.12154, 34.18358], [-118.12153, 34.18373], [-118.12155, 34.18386], [-118.12159, 34.18403], [-118.12162, 34.18407], [-118.12169, 34.18412]]]} | Restricted Access 2 | 6971 | Altadena Golf Course | 33022 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 57.739 | Altadena GC | 0 | Local Recreation Area 3 | 4 | |
1140 | 1140 | 1139 | {"type": "Polygon", "coordinates": [[[-118.1547, 33.95388], [-118.15452, 33.95422], [-118.15424, 33.9546], [-118.15397, 33.95488], [-118.15371, 33.95511], [-118.15347, 33.95528], [-118.14778, 33.95833], [-118.14294, 33.95579], [-118.14293, 33.95577], [-118.14293, 33.95574], [-118.14549, 33.95228], [-118.14787, 33.95356], [-118.14876, 33.95237], [-118.15149, 33.95385], [-118.15239, 33.95264], [-118.1547, 33.95388]]]} | Restricted Access 2 | 6710 | Rio Hondo Golf Club | 33020 | 1088 | Downey, City of 82 | City 2 | City Agency 2 | http://www.downeyca.org/services/cs/default.asp | City 2 | 1088 | Downey, City of 80 | City 2 | City Agency 2 | Los Angeles 6 | 101.146 | Rio Hondo Golf Club | 0 | Local Recreation Area 3 | 4 | |
1149 | 1149 | 1148 | {"type": "Polygon", "coordinates": [[[-122.46654, 37.70822], [-122.46654, 37.70827], [-122.46585, 37.70826], [-122.46585, 37.70822], [-122.46654, 37.70822]]]} | Restricted Access 2 | 6734 | Hillcrest And Ocean View Lots | 19962 | 321 | San Francisco - Public Utilities Commission, City and County of 31 | County 3 | County Agency - Other 9 | http://sfwater.org/ | County 3 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | San Mateo 15 | 0.08 | Hillcrest And Ocean View Lots | 0 | Local Other or Unknown 14 | 4 | |
1183 | 1183 | 1182 | {"type": "Polygon", "coordinates": [[[-121.91238, 36.53285], [-121.91178, 36.53344], [-121.91174, 36.5336], [-121.90785, 36.53358], [-121.90718, 36.53361], [-121.90652, 36.53368], [-121.90586, 36.53377], [-121.90514, 36.53391], [-121.90169, 36.53471], [-121.90144, 36.53402], [-121.90197, 36.53366], [-121.90319, 36.53217], [-121.9039, 36.53149], [-121.90504, 36.53109], [-121.90542, 36.53107], [-121.90577, 36.5311], [-121.90609, 36.53133], [-121.90641, 36.53152], [-121.90692, 36.53164], [-121.9072, 36.53167], [-121.90743, 36.53162], [-121.90823, 36.53118], [-121.90861, 36.53115], [-121.91058, 36.5322], [-121.91194, 36.53282], [-121.91238, 36.53285]]]} | Restricted Access 2 | 7782 | Coast Ranch | 17463 | 3008 | Big Sur Land Trust 173 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | Monterey 14 | 51.109 | Coast Ranch | 0 | Private Conservation 16 | 2 | |
1247 | 1247 | 1246 | {"type": "MultiPolygon", "coordinates": [[[[-122.08908, 39.91071], [-122.08556, 39.91225], [-122.08403, 39.91269], [-122.08195, 39.91167], [-122.08149, 39.91155], [-122.08063, 39.91106], [-122.08036, 39.91087], [-122.07988, 39.91046], [-122.07953, 39.9102], [-122.07664, 39.91123], [-122.07574, 39.90995], [-122.07509, 39.90948], [-122.07484, 39.90963], [-122.07326, 39.90869], [-122.07223, 39.90797], [-122.07205, 39.9071], [-122.0716, 39.90656], [-122.07157, 39.90644], [-122.07508, 39.90518], [-122.07387, 39.90391], [-122.07352, 39.9037], [-122.07305, 39.90349], [-122.06541, 39.90631], [-122.06449, 39.90454], [-122.06447, 39.90454], [-122.06441, 39.90512], [-122.06438, 39.90558], [-122.06428, 39.90582], [-122.06414, 39.90602], [-122.06403, 39.90604], [-122.06287, 39.9057], [-122.06019, 39.90431], [-122.05671, 39.90364], [-122.05568, 39.90329], [-122.055, 39.90288], [-122.05473, 39.90261], [-122.05462, 39.90247], [-122.05458, 39.90219], [-122.05448, 39.90201], [-122.054, 39.90137], [-122.05371, 39.90068], [-122.05361, 39.90016], [-122.0535, 39.89977], [-122.05349, 39.89962], [-122.05348, 39.89929], [-122.05357, 39.89718], [-122.05267, 39.89727], [-122.05246, 39.89732], [-122.05212, 39.89751], [-122.04918, 39.89628], [-122.04897, 39.89616], [-122.04801, 39.89547], [-122.04718, 39.89493], [-122.04664, 39.89454], [-122.04627, 39.8941], [-122.04615, 39.894], [-122.04627, 39.89395], [-122.04493, 39.89121], [-122.04445, 39.89136], [-122.04432, 39.89134], [-122.0426, 39.89066], [-122.04203, 39.89011], [-122.04044, 39.88711], [-122.03946, 39.88556], [-122.03906, 39.88483], [-122.03886, 39.88432], [-122.03883, 39.8839], [-122.04293, 39.88391], [-122.04541, 39.8844], [-122.04689, 39.88484], [-122.04852, 39.88517], [-122.04899, 39.8844], [-122.05009, 39.88437], [-122.05166, 39.88393], [-122.05605, 39.88395], [-122.05712, 39.88328], [-122.05752, 39.88287], [-122.05807, 39.88263], [-122.0606, 39.88192], [-122.06076, 39.88185], [-122.06292, 39.88152], [-122.06334, 39.88165], [-122.06355, 39.88199], [-122.06328, 39.88251], [-122.06307, 39.88268], [-122.06304, 39.88277], [-122.06271, 39.88315], [-122.06251, 39.88374], [-122.0625, 39.88398], [-122.06289, 39.88399], [-122.06264, 39.8847], [-122.06248, 39.88503], [-122.06201, 39.88649], [-122.06167, 39.88899], [-122.06177, 39.88967], [-122.06208, 39.89087], [-122.06279, 39.89245], [-122.06333, 39.89346], [-122.06369, 39.89408], [-122.06393, 39.89408], [-122.06459, 39.89489], [-122.06596, 39.89627], [-122.06688, 39.89722], [-122.06749, 39.89768], [-122.0678, 39.89795], [-122.06803, 39.89808], [-122.06817, 39.89826], [-122.06927, 39.89922], [-122.06935, 39.89933], [-122.07004, 39.89991], [-122.07045, 39.90019], [-122.07069, 39.90025], [-122.07085, 39.90044], [-122.07126, 39.9007], [-122.07139, 39.90071], [-122.07148, 39.90084], [-122.07181, 39.90107], [-122.07186, 39.90096], [-122.07189, 39.90112], [-122.07202, 39.90114], [-122.07316, 39.90176], [-122.07411, 39.90221], [-122.07505, 39.90258], [-122.0755, 39.90268], [-122.07588, 39.90286], [-122.07653, 39.90304], [-122.07677, 39.90324], [-122.07821, 39.90375], [-122.07865, 39.90386], [-122.07879, 39.90395], [-122.07889, 39.90397], [-122.07905, 39.90395], [-122.07922, 39.90398], [-122.07938, 39.90406], [-122.07992, 39.90424], [-122.0816, 39.90471], [-122.0824, 39.905], [-122.08343, 39.90545], [-122.08418, 39.90574], [-122.08381, 39.90638], [-122.0845, 39.90673], [-122.08563, 39.90709], [-122.08661, 39.90785], [-122.08908, 39.91071]]], [[[-122.1146, 40.01465], [-122.10736, 40.01485], [-122.10589, 40.01447], [-122.10456, 40.01363], [-122.10354, 40.01213], [-122.10275, 40.0105], [-122.10242, 40.00871], [-122.10249, 40.00821], [-122.10295, 40.00733], [-122.10359, 40.00691], [-122.10616, 40.00615], [-122.10616, 40.00622], [-122.10656, 40.00744], [-122.10735, 40.00845], [-122.10946, 40.01037], [-122.11057, 40.01134], [-122.1117, 40.01225], [-122.11316, 40.01328], [-122.1146, 40.01465]]], [[[-122.13041, 40.06973], [-122.13034, 40.07392], [-122.12955, 40.07392], [-122.12877, 40.07397], [-122.12733, 40.0734], [-122.12699, 40.07356], [-122.12613, 40.07334], [-122.12457, 40.07351], [-122.12442, 40.07288], [-122.12422, 40.0725], [-122.12376, 40.07227], [-122.12356, 40.0722], [-122.12354, 40.07206], [-122.12348, 40.07198], [-122.12323, 40.07183], [-122.12313, 40.07158], [-122.12296, 40.07145], [-122.12289, 40.07119], [-122.1227, 40.07065], [-122.12255, 40.07066], [-122.12216, 40.06992], [-122.12146, 40.06882], [-122.12115, 40.06847], [-122.12057, 40.06751], [-122.12008, 40.06621], [-122.11939, 40.06501], [-122.11914, 40.06473], [-122.11873, 40.06467], [-122.11846, 40.06482], [-122.11738, 40.06483], [-122.11699, 40.0647], [-122.1168, 40.06453], [-122.11642, 40.06453], [-122.11613, 40.06432], [-122.116, 40.0641], [-122.11461, 40.06383], [-122.11257, 40.06298], [-122.11176, 40.06238], [-122.11133, 40.06165], [-122.11142, 40.06137], [-122.11145, 40.06045], [-122.11117, 40.05819], [-122.11135, 40.05687], [-122.11303, 40.05462], [-122.1147, 40.05357], [-122.11485, 40.05315], [-122.11464, 40.05215], [-122.1142, 40.05124], [-122.11409, 40.04964], [-122.11358, 40.04787], [-122.11371, 40.04699], [-122.11454, 40.04504], [-122.11555, 40.0428], [-122.11583, 40.0432], [-122.11642, 40.04367], [-122.11718, 40.04408], [-122.11785, 40.04423], [-122.1198, 40.04409], [-122.12012, 40.04417], [-122.12036, 40.04441], [-122.12036, 40.04478], [-122.11954, 40.04634], [-122.11911, 40.04757], [-122.11898, 40.04835], [-122.11888, 40.0494], [-122.11899, 40.05006], [-122.11959, 40.05065], [-122.12057, 40.05138], [-122.12097, 40.05183], [-122.1214, 40.05263], [-122.12171, 40.05297], [-122.12202, 40.0532], [-122.12241, 40.05336], [-122.12287, 40.05338], [-122.12331, 40.05335], [-122.12388, 40.05335], [-122.12409, 40.05338], [-122.12393, 40.05372], [-122.12403, 40.05391], [-122.12437, 40.05791], [-122.12473, 40.05815], [-122.12539, 40.05907], [-122.12611, 40.06054], [-122.1263, 40.06077], [-122.12672, 40.06121], [-122.127, 40.06168], [-122.12713, 40.06207], [-122.12731, 40.06355], [-122.12617, 40.0636], [-122.12637, 40.06539], [-122.1269, 40.06549], [-122.12771, 40.06598], [-122.12915, 40.0672], [-122.1294, 40.06758], [-122.12957, 40.06905], [-122.1295, 40.06958], [-122.13041, 40.06973]]], [[[-122.16522, 40.13912], [-122.16108, 40.14465], [-122.16063, 40.14471], [-122.15993, 40.14493], [-122.15861, 40.1455], [-122.15713, 40.14592], [-122.15654, 40.14605], [-122.15514, 40.14611], [-122.1546, 40.14602], [-122.15303, 40.14548], [-122.15173, 40.14467], [-122.14994, 40.14376], [-122.14817, 40.14263], [-122.14731, 40.14254], [-122.14662, 40.14137], [-122.1464, 40.1408], [-122.14803, 40.14169], [-122.14815, 40.14151], [-122.14639, 40.14025], [-122.14469, 40.13892], [-122.14233, 40.13662], [-122.14182, 40.13594], [-122.14132, 40.13505], [-122.14104, 40.1335], [-122.14121, 40.13327], [-122.1412, 40.12927], [-122.14028, 40.12733], [-122.13931, 40.12578], [-122.13759, 40.12435], [-122.13594, 40.12254], [-122.13667, 40.12114], [-122.13785, 40.12034], [-122.13789, 40.11986], [-122.13985, 40.11916], [-122.14146, 40.11819], [-122.14302, 40.11707], [-122.14401, 40.11612], [-122.14407, 40.11615], [-122.14451, 40.11573], [-122.1448, 40.11523], [-122.14496, 40.11436], [-122.1449, 40.11366], [-122.14463, 40.11295], [-122.14407, 40.1122], [-122.14332, 40.11151], [-122.14259, 40.11109], [-122.14251, 40.1109], [-122.14228, 40.11052], [-122.14203, 40.11021], [-122.14156, 40.10974], [-122.13904, 40.10827], [-122.1386, 40.10871], [-122.13806, 40.10803], [-122.13856, 40.10792], [-122.13857, 40.10791], [-122.13666, 40.10513], [-122.13491, 40.10332], [-122.13427, 40.10276], [-122.13363, 40.10232], [-122.13345, 40.1025], [-122.1334, 40.10272], [-122.13406, 40.10342], [-122.13444, 40.1039], [-122.13451, 40.10433], [-122.13405, 40.1047], [-122.13022, 40.10264], [-122.12966, 40.10181], [-122.1296, 40.10076], [-122.12992, 40.09981], [-122.1301, 40.09918], [-122.13021, 40.09907], [-122.13043, 40.09936], [-122.13078, 40.09955], [-122.13079, 40.09953], [-122.13062, 40.09932], [-122.13099, 40.09915], [-122.13069, 40.09861], [-122.13056, 40.09821], [-122.13066, 40.09547], [-122.13082, 40.09453], [-122.13078, 40.09453], [-122.13075, 40.09372], [-122.13156, 40.0928], [-122.131, 40.0916], [-122.13063, 40.09127], [-122.12853, 40.09048], [-122.12709, 40.08945], [-122.1259, 40.08883], [-122.12435, 40.08823], [-122.12338, 40.08796], [-122.12259, 40.08802], [-122.12192, 40.09086], [-122.12201, 40.09123], [-122.12167, 40.09242], [-122.12131, 40.09337], [-122.12051, 40.09409], [-122.11934, 40.09485], [-122.11822, 40.09505], [-122.11653, 40.0947], [-122.11518, 40.09312], [-122.11392, 40.09102], [-122.11339, 40.08924], [-122.11278, 40.08897], [-122.11234, 40.08817], [-122.11228, 40.08709], [-122.11255, 40.08641], [-122.11318, 40.08576], [-122.11426, 40.08532], [-122.11931, 40.08107], [-122.12003, 40.08018], [-122.12041, 40.07981], [-122.12085, 40.07946], [-122.1212, 40.0793], [-122.12124, 40.07934], [-122.12113, 40.07961], [-122.1209, 40.07994], [-122.1207, 40.08025], [-122.12071, 40.08026], [-122.12077, 40.08022], [-122.12113, 40.07986], [-122.12152, 40.07943], [-122.12189, 40.07897], [-122.12222, 40.07852], [-122.12256, 40.07801], [-122.12294, 40.0775], [-122.12339, 40.07669], [-122.12401, 40.07537], [-122.12411, 40.07502], [-122.12406, 40.07435], [-122.12413, 40.07426], [-122.12454, 40.07401], [-122.12493, 40.07399], [-122.12568, 40.07384], [-122.12576, 40.07384], [-122.12609, 40.07393], [-122.12669, 40.07399], [-122.12689, 40.074], [-122.12717, 40.07396], [-122.12734, 40.07398], [-122.12785, 40.07411], [-122.12817, 40.0743], [-122.12829, 40.07435], [-122.12866, 40.07443], [-122.12957, 40.07439], [-122.13026, 40.07443], [-122.13043, 40.0744], [-122.13076, 40.07432], [-122.13088, 40.07432], [-122.13109, 40.07438], [-122.13134, 40.0744], [-122.13161, 40.07449], [-122.13181, 40.0745], [-122.13189, 40.07452], [-122.13204, 40.07467], [-122.13271, 40.07517], [-122.1328, 40.07522], [-122.13295, 40.07529], [-122.13375, 40.07544], [-122.13421, 40.07567], [-122.13442, 40.07574], [-122.13566, 40.07592], [-122.13631, 40.07822], [-122.13624, 40.07838], [-122.13609, 40.07878], [-122.13591, 40.07907], [-122.13581, 40.07917], [-122.13541, 40.07946], [-122.13535, 40.07952], [-122.13531, 40.0796], [-122.13529, 40.0797], [-122.13531, 40.07981], [-122.13535, 40.07989], [-122.13548, 40.08001], [-122.13551, 40.08009], [-122.1355, 40.08029], [-122.13557, 40.08084], [-122.13553, 40.08144], [-122.13547, 40.08153], [-122.135, 40.08177], [-122.13493, 40.08182], [-122.13485, 40.08192], [-122.13482, 40.082], [-122.13482, 40.0821], [-122.13495, 40.0825], [-122.13495, 40.08264], [-122.1343, 40.08353], [-122.1342, 40.08387], [-122.13675, 40.08432], [-122.13616, 40.09027], [-122.13651, 40.09038], [-122.13839, 40.09174], [-122.13561, 40.09277], [-122.13628, 40.0927], [-122.1393, 40.09383], [-122.13943, 40.09438], [-122.13956, 40.0965], [-122.14118, 40.09753], [-122.14109, 40.09809], [-122.14131, 40.09894], [-122.14185, 40.09978], [-122.14257, 40.10057], [-122.14258, 40.10077], [-122.14328, 40.10141], [-122.14393, 40.10178], [-122.14427, 40.10184], [-122.14516, 40.10276], [-122.14559, 40.10303], [-122.14608, 40.10401], [-122.14586, 40.10451], [-122.14578, 40.10576], [-122.14554, 40.10639], [-122.14733, 40.106], [-122.1474, 40.10726], [-122.14684, 40.10812], [-122.14656, 40.10845], [-122.14639, 40.10887], [-122.14595, 40.10944], [-122.14577, 40.10999], [-122.14577, 40.11041], [-122.14618, 40.11111], [-122.14646, 40.11149], [-122.14698, 40.11162], [-122.14715, 40.1117], [-122.1473, 40.11192], [-122.14749, 40.11246], [-122.14698, 40.11351], [-122.147, 40.11363], [-122.14709, 40.11368], [-122.14722, 40.11373], [-122.14784, 40.11386], [-122.14829, 40.11392], [-122.14881, 40.11416], [-122.15018, 40.1151], [-122.15072, 40.11539], [-122.1511, 40.11566], [-122.15148, 40.116], [-122.15197, 40.11647], [-122.15239, 40.11701], [-122.15284, 40.11762], [-122.15298, 40.11791], [-122.15307, 40.11859], [-122.15302, 40.11913], [-122.15301, 40.11942], [-122.15288, 40.1197], [-122.15245, 40.1203], [-122.1522, 40.12049], [-122.15185, 40.12087], [-122.1516, 40.12109], [-122.15079, 40.12162], [-122.15047, 40.12186], [-122.14978, 40.12231], [-122.14955, 40.12252], [-122.14921, 40.12266], [-122.1489, 40.1229], [-122.15668, 40.13317], [-122.15546, 40.13482], [-122.16522, 40.13912]]], [[[-122.14912, 40.14499], [-122.14894, 40.14498], [-122.14816, 40.14489], [-122.14703, 40.14485], [-122.14559, 40.14505], [-122.14499, 40.1451], [-122.14447, 40.14497], [-122.14333, 40.14438], [-122.14288, 40.14401], [-122.142, 40.14335], [-122.14174, 40.14301], [-122.1416, 40.14271], [-122.14135, 40.14248], [-122.14093, 40.1422], [-122.14084, 40.14204], [-122.14093, 40.1418], [-122.14061, 40.14162], [-122.14056, 40.14143], [-122.14053, 40.14117], [-122.14032, 40.1411], [-122.14014, 40.14097], [-122.14021, 40.14075], [-122.14031, 40.14068], [-122.14055, 40.14067], [-122.14063, 40.14062], [-122.14065, 40.14051], [-122.14073, 40.14038], [-122.1407, 40.14026], [-122.14085, 40.14011], [-122.14085, 40.13999], [-122.14098, 40.13974], [-122.14097, 40.13957], [-122.14102, 40.13907], [-122.14111, 40.13883], [-122.14122, 40.13866], [-122.14144, 40.13856], [-122.14143, 40.13815], [-122.14126, 40.13789], [-122.14113, 40.13759], [-122.14103, 40.13719], [-122.14103, 40.13696], [-122.14137, 40.13683], [-122.14146, 40.13673], [-122.14176, 40.13671], [-122.14194, 40.13693], [-122.14237, 40.1376], [-122.14261, 40.13811], [-122.14263, 40.13828], [-122.14277, 40.13839], [-122.14282, 40.13865], [-122.14281, 40.13879], [-122.14288, 40.13895], [-122.14288, 40.13906], [-122.14283, 40.13911], [-122.14282, 40.13922], [-122.14283, 40.13935], [-122.14288, 40.13942], [-122.14292, 40.13957], [-122.14302, 40.13966], [-122.143, 40.13982], [-122.1431, 40.14003], [-122.14335, 40.14045], [-122.14338, 40.14058], [-122.14352, 40.14072], [-122.14355, 40.14089], [-122.14381, 40.14131], [-122.1446, 40.14219], [-122.14515, 40.14274], [-122.14599, 40.1435], [-122.14648, 40.14386], [-122.14718, 40.1442], [-122.14732, 40.14433], [-122.14774, 40.14447], [-122.14824, 40.14467], [-122.14841, 40.14468], [-122.14912, 40.14499]]]]} | Restricted Access 2 | 9160 | Sacramento River National Wildlife Refuge | 24771 | 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 | Tehama 18 | 4115.342 | Sacramento River NWR | 1989 | National Wildlife Refuge 105 | 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]);