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 map
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- California Department of Fish and Wildlife 71
- University of California 43
- United States Fish and Wildlife Service 40
- Woodbridge Village Association 31
- Home Owners Association - Unknown Name 26
- 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
- Land Trust of Napa County 14
- Big Sur Land Trust 14
- The Nature Conservancy 12
- United States Bureau of Land Management 11
- California Department of Parks and Recreation 11
- San Francisco - Public Utilities Commission, City and County of 10
- Sonoma Land Trust 9
- Long Beach, City of 9
- San Diego, City 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 215
- Local Park 209
- Private Recreation or Education 193
- Private Conservation 150
- State Conservation Area 108
- Local Conservation Area 47
- National Wildlife Refuge 35
- Local Other or Unknown 30
- National Public Lands 9
- Recreation Management Area 9
- State Resource Management Area 6
- Federal Other or Unknown 6
- Private 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
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 24
- City Agency 357
- Home Owners Association 201
- State Agency 144
- Non Profit - Land Trust 134
- Federal Agency 79
- Recreation/Parks District 64
- County Agency 59
- School District 38
- Non Profit - Conservation 20
- Water District 14
- County Agency - Other 12
- County Agency - Parks 11
- 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
- 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7963 | 7963 | 7962 | {"type": "MultiPolygon", "coordinates": [[[[-116.96231, 32.5888], [-116.95891, 32.58979], [-116.96013, 32.59278], [-116.95959, 32.59293], [-116.95911, 32.5929], [-116.95864, 32.593], [-116.95789, 32.59309], [-116.95733, 32.59319], [-116.95703, 32.59325], [-116.95686, 32.59339], [-116.95657, 32.59347], [-116.95598, 32.59351], [-116.95514, 32.59365], [-116.95421, 32.59393], [-116.95377, 32.59419], [-116.95265, 32.59474], [-116.95221, 32.59489], [-116.95194, 32.59494], [-116.9508, 32.59216], [-116.95833, 32.58995], [-116.95639, 32.58888], [-116.95595, 32.58857], [-116.9523, 32.58586], [-116.95369, 32.58588], [-116.96222, 32.58619], [-116.96231, 32.5888]]], [[[-116.96197, 32.5973], [-116.96128, 32.5975], [-116.96123, 32.59737], [-116.96109, 32.59724], [-116.96094, 32.5972], [-116.96072, 32.59721], [-116.96053, 32.59726], [-116.96038, 32.59735], [-116.96029, 32.59743], [-116.96024, 32.59751], [-116.9602, 32.59766], [-116.96014, 32.59775], [-116.96003, 32.59785], [-116.95988, 32.59786], [-116.95969, 32.5978], [-116.95952, 32.59771], [-116.95914, 32.59765], [-116.95898, 32.59758], [-116.95875, 32.59759], [-116.95844, 32.59767], [-116.95811, 32.59787], [-116.95753, 32.5982], [-116.95669, 32.59855], [-116.95642, 32.59876], [-116.95623, 32.59892], [-116.95384, 32.59959], [-116.95285, 32.59719], [-116.95353, 32.59743], [-116.95424, 32.59722], [-116.95498, 32.59694], [-116.95604, 32.59641], [-116.95638, 32.5962], [-116.95675, 32.59608], [-116.95783, 32.59581], [-116.9586, 32.59566], [-116.95917, 32.59523], [-116.95938, 32.59502], [-116.96077, 32.59435], [-116.96197, 32.5973]]]]} | Restricted Access 2 | 47729 | Otay Ranch Preserve | 31529 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/openspace/Otay_Ranch.html | San Diego 4 | 179.037 | Otay Ranch Preserve | 0 | Local Conservation Area 4 | 2 |
4962 | 4962 | 4961 | {"type": "MultiPolygon", "coordinates": [[[[-116.98594, 32.6469], [-116.98591, 32.64692], [-116.98584, 32.64693], [-116.98545, 32.64674], [-116.98558, 32.64668], [-116.98578, 32.64682], [-116.98594, 32.6469]]], [[[-116.98664, 32.64925], [-116.98652, 32.64925], [-116.98693, 32.64859], [-116.98705, 32.64845], [-116.98707, 32.64834], [-116.98707, 32.64814], [-116.98696, 32.64797], [-116.98662, 32.64767], [-116.98618, 32.64741], [-116.98595, 32.64725], [-116.98675, 32.64765], [-116.98695, 32.64777], [-116.98717, 32.64793], [-116.98748, 32.64821], [-116.98747, 32.64827], [-116.98717, 32.64855], [-116.98694, 32.64882], [-116.98664, 32.64925]]]]} | Restricted Access 2 | 45162 | HOA Open Space | 31748 | 6074 | Home Owners Association - Unknown Name 640 | Private 7 | Home Owners Association 16 | Private 14 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | San Diego 4 | 1.099 | HOA OS | 0 | Private Recreation or Education 65 | 4 | ||
6086 | 6086 | 6085 | {"type": "MultiPolygon", "coordinates": [[[[-117.00116, 33.01884], [-116.99647, 33.01886], [-116.99635, 33.01507], [-117.00112, 33.01494], [-117.00116, 33.01884]]], [[[-117.01695, 33.01451], [-117.01452, 33.01459], [-117.00983, 33.01471], [-117.00983, 33.01458], [-117.01035, 33.01452], [-117.01054, 33.01217], [-117.01092, 33.01197], [-117.01481, 33.01197], [-117.01603, 33.01335], [-117.01695, 33.01451]]]]} | Restricted Access 2 | 891 | Blue Sky Ecological Reserve | 29220 | 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 | 83.938 | Blue Sky ER | 1991 | Local Conservation Area 4 | 2 | |
12231 | 12231 | 12230 | {"type": "MultiPolygon", "coordinates": [[[[-117.01207, 33.89306], [-117.00799, 33.89306], [-117.00392, 33.89308], [-117.0039, 33.88945], [-117.01204, 33.88947], [-117.01207, 33.89306]]], [[[-117.01712, 33.86029], [-117.01212, 33.86432], [-117.01211, 33.86385], [-117.00876, 33.86381], [-117.00888, 33.8632], [-117.00883, 33.86293], [-117.00883, 33.86274], [-117.00884, 33.86255], [-117.00889, 33.86234], [-117.00903, 33.86202], [-117.00962, 33.86102], [-117.00969, 33.8606], [-117.00985, 33.86032], [-117.01712, 33.86029]]], [[[-117.02922, 33.86478], [-117.01849, 33.87513], [-117.01632, 33.87516], [-117.01639, 33.86746], [-117.01212, 33.86747], [-117.01212, 33.86543], [-117.0185, 33.86028], [-117.0225, 33.86027], [-117.02922, 33.86478]]], [[[-117.04925, 33.8737], [-117.03855, 33.87392], [-117.0338, 33.86787], [-117.03376, 33.87467], [-117.02487, 33.87505], [-117.02495, 33.88948], [-117.01632, 33.88948], [-117.01639, 33.88239], [-117.01635, 33.87839], [-117.01978, 33.87511], [-117.02996, 33.86528], [-117.03062, 33.86572], [-117.03126, 33.86602], [-117.0333, 33.8668], [-117.03366, 33.86691], [-117.03409, 33.86698], [-117.03432, 33.86699], [-117.03472, 33.86697], [-117.03495, 33.86694], [-117.03521, 33.86689], [-117.03625, 33.86661], [-117.03763, 33.86615], [-117.03793, 33.86609], [-117.03815, 33.86607], [-117.03847, 33.86609], [-117.03878, 33.86616], [-117.03898, 33.86623], [-117.03927, 33.86639], [-117.04041, 33.86722], [-117.04227, 33.86874], [-117.0427, 33.86904], [-117.04318, 33.8693], [-117.04421, 33.86972], [-117.04453, 33.86988], [-117.04685, 33.87167], [-117.04741, 33.87209], [-117.04768, 33.8723], [-117.04925, 33.8737]]]]} | Restricted Access 2 | 25437 | Wolfskill-Driscoll Properties | 27673 | 2179 | Western Riverside County Regional Conservation Authority 957 | Special District 4 | Open Space District 6 | http://www.wrc-rca.org/ | Special District 4 | 2179 | Western Riverside County Regional Conservation Authority 927 | Special District 4 | Open Space District 6 | Riverside 10 | 1135.825 | Wolfskill-Driscoll Properties | 0 | Local Other or Unknown 14 | 4 | |
8005 | 8005 | 8004 | {"type": "MultiPolygon", "coordinates": [[[[-117.04813, 33.96332], [-117.04799, 33.96459], [-117.04296, 33.96421], [-117.04294, 33.96247], [-117.04813, 33.96332]]], [[[-117.11098, 33.97499], [-117.11056, 33.97488], [-117.11047, 33.97503], [-117.11042, 33.97501], [-117.1103, 33.97501], [-117.11025, 33.9748], [-117.10985, 33.97492], [-117.10991, 33.97466], [-117.10994, 33.97464], [-117.11008, 33.97458], [-117.11021, 33.97454], [-117.11027, 33.97454], [-117.11033, 33.97456], [-117.11041, 33.97462], [-117.11054, 33.97465], [-117.1108, 33.9747], [-117.11095, 33.9747], [-117.11098, 33.97499]]], [[[-117.10899, 33.97446], [-117.10892, 33.97454], [-117.10885, 33.9747], [-117.10883, 33.97481], [-117.10884, 33.975], [-117.1086, 33.97495], [-117.10849, 33.97519], [-117.10833, 33.97514], [-117.10821, 33.97513], [-117.10823, 33.97493], [-117.10842, 33.97491], [-117.10856, 33.97458], [-117.10879, 33.97435], [-117.10899, 33.97446]]], [[[-117.11021, 33.97445], [-117.11017, 33.9745], [-117.10992, 33.97458], [-117.10988, 33.97461], [-117.10985, 33.97465], [-117.10978, 33.9749], [-117.10976, 33.97492], [-117.10968, 33.97494], [-117.10963, 33.97499], [-117.10962, 33.97504], [-117.10964, 33.97507], [-117.1097, 33.9751], [-117.10977, 33.9751], [-117.10986, 33.97521], [-117.10958, 33.97522], [-117.10958, 33.97544], [-117.10936, 33.97544], [-117.10921, 33.97541], [-117.10921, 33.97518], [-117.10936, 33.97516], [-117.10936, 33.97506], [-117.10899, 33.97509], [-117.10897, 33.97492], [-117.10935, 33.97489], [-117.10935, 33.97473], [-117.10946, 33.9746], [-117.10956, 33.97455], [-117.10949, 33.97432], [-117.10977, 33.97426], [-117.11003, 33.97422], [-117.1102, 33.97441], [-117.11021, 33.97445]]]]} | Restricted Access 2 | 11290 | River Lands Conservancy | 24411 | 3059 | Rivers and Lands Conservancy 773 | Non Profit 6 | Non Profit - Land Trust 10 | https://riversandlands.org/ | Non Governmental Organization 10 | 3059 | Rivers and Lands Conservancy 754 | Non Profit 6 | Non Profit - Land Trust 10 | Riverside 10 | 22.618 | River Lands Conservancy | 0 | Private Conservation 16 | 2 | |
2799 | 2799 | 2798 | {"type": "MultiPolygon", "coordinates": [[[[-117.05969, 32.76384], [-117.05963, 32.76392], [-117.05829, 32.76395], [-117.05834, 32.7639], [-117.05835, 32.76382], [-117.05963, 32.76378], [-117.05966, 32.76379], [-117.05969, 32.76384]]], [[[-117.06115, 32.76232], [-117.06114, 32.76248], [-117.06111, 32.76257], [-117.06106, 32.76264], [-117.06009, 32.76351], [-117.06004, 32.76235], [-117.06115, 32.76232]]]]} | Restricted Access 2 | 18582 | Clay Neighborhood Park | 31592 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 2.413 | Clay Neighborhood Park | 0 | Local Park 2 | 4 | |
7884 | 7884 | 7883 | {"type": "MultiPolygon", "coordinates": [[[[-117.09041, 32.59194], [-117.08874, 32.59193], [-117.08862, 32.59124], [-117.09041, 32.59124], [-117.09041, 32.59194]]], [[[-117.09041, 32.59281], [-117.08888, 32.5928], [-117.08876, 32.5921], [-117.09041, 32.5921], [-117.09041, 32.59281]]], [[[-117.09247, 32.5929], [-117.09246, 32.59485], [-117.09092, 32.59489], [-117.09085, 32.59495], [-117.09086, 32.59468], [-117.09078, 32.59463], [-117.09068, 32.59391], [-117.08962, 32.59388], [-117.08903, 32.5938], [-117.08889, 32.59289], [-117.09247, 32.5929]]], [[[-117.0925, 32.59116], [-117.09057, 32.59116], [-117.09056, 32.59064], [-117.09054, 32.59036], [-117.09052, 32.58935], [-117.09248, 32.58934], [-117.0925, 32.59116]]], [[[-117.0925, 32.59125], [-117.09248, 32.59195], [-117.09057, 32.59194], [-117.09057, 32.59124], [-117.0925, 32.59125]]], [[[-117.09248, 32.59211], [-117.09247, 32.59281], [-117.09058, 32.59281], [-117.09058, 32.5921], [-117.09248, 32.59211]]], [[[-117.09712, 32.59353], [-117.0952, 32.59484], [-117.09266, 32.59476], [-117.09267, 32.59285], [-117.09269, 32.59124], [-117.09486, 32.59122], [-117.09486, 32.59116], [-117.09492, 32.59115], [-117.09491, 32.58932], [-117.09709, 32.58931], [-117.09712, 32.59353]]], [[[-117.09479, 32.59116], [-117.0927, 32.59118], [-117.09271, 32.58934], [-117.09478, 32.58932], [-117.09479, 32.59116]]], [[[-117.11856, 32.59129], [-117.11842, 32.59139], [-117.11778, 32.59134], [-117.11803, 32.59127], [-117.11807, 32.59124], [-117.11807, 32.59117], [-117.11854, 32.59117], [-117.11854, 32.59124], [-117.11821, 32.59124], [-117.1182, 32.59125], [-117.11856, 32.59129]]]]} | Restricted Access 2 | 12592 | San Diego Bay National Wildlife Refuge | 24851 | 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 | San Diego 4 | 93.78 | San Diego Bay NWR | 1988 | National Wildlife Refuge 105 | 2 | |
15654 | 15654 | 15653 | {"type": "MultiPolygon", "coordinates": [[[[-117.09268, 33.16118], [-117.09263, 33.16144], [-117.09239, 33.1623], [-117.09172, 33.16442], [-117.09132, 33.16557], [-117.09126, 33.16559], [-117.09122, 33.16558], [-117.09117, 33.16553], [-117.09112, 33.16552], [-117.09095, 33.1655], [-117.09109, 33.16538], [-117.09084, 33.16498], [-117.09075, 33.16478], [-117.09071, 33.16458], [-117.09071, 33.16438], [-117.09076, 33.16417], [-117.09092, 33.16373], [-117.09086, 33.16352], [-117.09003, 33.16299], [-117.08995, 33.16301], [-117.08984, 33.16316], [-117.0898, 33.16374], [-117.09023, 33.1638], [-117.09023, 33.16386], [-117.0898, 33.1638], [-117.08972, 33.1645], [-117.08977, 33.16477], [-117.08983, 33.16503], [-117.08993, 33.16525], [-117.09006, 33.1655], [-117.09025, 33.1657], [-117.09055, 33.16553], [-117.09067, 33.16561], [-117.09073, 33.16569], [-117.09088, 33.16575], [-117.09098, 33.16581], [-117.09117, 33.16582], [-117.0912, 33.16588], [-117.09069, 33.16732], [-117.09045, 33.16811], [-117.09031, 33.1682], [-117.08999, 33.16812], [-117.08956, 33.1681], [-117.08947, 33.16806], [-117.08938, 33.16805], [-117.08929, 33.16808], [-117.08918, 33.16816], [-117.08894, 33.16826], [-117.08883, 33.16821], [-117.08896, 33.16797], [-117.08906, 33.1677], [-117.08909, 33.16741], [-117.08905, 33.16713], [-117.08871, 33.16584], [-117.08859, 33.16494], [-117.0884, 33.16417], [-117.08837, 33.16359], [-117.08815, 33.16355], [-117.08817, 33.16349], [-117.08816, 33.16345], [-117.08821, 33.16335], [-117.08822, 33.16322], [-117.08826, 33.16313], [-117.08827, 33.16306], [-117.08823, 33.16297], [-117.08815, 33.1629], [-117.08795, 33.16256], [-117.08797, 33.16246], [-117.08897, 33.16188], [-117.0893, 33.16172], [-117.0897, 33.16157], [-117.08991, 33.1615], [-117.09033, 33.1614], [-117.09069, 33.16135], [-117.09263, 33.16112], [-117.09268, 33.16118]]], [[[-117.0949, 33.17091], [-117.09272, 33.17091], [-117.08993, 33.17091], [-117.09066, 33.1685], [-117.0928, 33.1691], [-117.09489, 33.16975], [-117.09493, 33.16981], [-117.09491, 33.16997], [-117.0949, 33.17091]]], [[[-117.09702, 33.17023], [-117.0954, 33.16973], [-117.0954, 33.16968], [-117.09404, 33.16924], [-117.09211, 33.16867], [-117.09084, 33.16831], [-117.09344, 33.16883], [-117.09504, 33.16905], [-117.09539, 33.16912], [-117.09576, 33.16927], [-117.09604, 33.16943], [-117.09629, 33.16963], [-117.09644, 33.16979], [-117.09662, 33.16997], [-117.09679, 33.1701], [-117.09702, 33.17023]]]]} | Restricted Access 2 | 644 | Reidy Creek Golf Course | 31473 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 7017 | JC Resorts 1102 | Private 7 | Commercial 18 | https://www.jcgolf.com/san-diego-golf-courses/reidy-creek/ | San Diego 4 | 70.314 | Reidy Creek GC | None 1366 | ||
15792 | 15792 | 15791 | {"type": "MultiPolygon", "coordinates": [[[[-117.1045, 32.63175], [-117.10458, 32.63181], [-117.10474, 32.63198], [-117.1048, 32.63218], [-117.10474, 32.63237], [-117.10446, 32.63282], [-117.10431, 32.6331], [-117.10422, 32.6335], [-117.10412, 32.63354], [-117.10421, 32.63374], [-117.1044, 32.6343], [-117.1041, 32.63436], [-117.10241, 32.63486], [-117.10143, 32.6324], [-117.10313, 32.63193], [-117.10352, 32.63184], [-117.10391, 32.63171], [-117.10413, 32.63178], [-117.1045, 32.63175]]], [[[-117.10568, 32.64977], [-117.10455, 32.65007], [-117.10452, 32.6498], [-117.10445, 32.64953], [-117.10411, 32.64862], [-117.10431, 32.64837], [-117.10387, 32.64749], [-117.10347, 32.64646], [-117.10308, 32.64503], [-117.10255, 32.64381], [-117.1022, 32.64331], [-117.10197, 32.64285], [-117.10242, 32.64272], [-117.10272, 32.64257], [-117.10289, 32.64252], [-117.10424, 32.64598], [-117.10568, 32.64977]]], [[[-117.11004, 32.65773], [-117.10909, 32.65801], [-117.10925, 32.65843], [-117.10912, 32.65845], [-117.1089, 32.65853], [-117.10814, 32.65873], [-117.1076, 32.65807], [-117.10651, 32.65554], [-117.10608, 32.65438], [-117.10592, 32.65387], [-117.10539, 32.65185], [-117.10523, 32.6518], [-117.10517, 32.65164], [-117.10506, 32.65144], [-117.10501, 32.65136], [-117.10616, 32.65101], [-117.10701, 32.6532], [-117.1071, 32.65338], [-117.1073, 32.65364], [-117.10746, 32.65377], [-117.10772, 32.65396], [-117.10821, 32.65426], [-117.10852, 32.65447], [-117.10881, 32.65474], [-117.10911, 32.65507], [-117.10925, 32.65527], [-117.10944, 32.6556], [-117.10954, 32.6558], [-117.10957, 32.65581], [-117.10969, 32.65617], [-117.11004, 32.65773]]]]} | Restricted Access 2 | 5087 | San Diego Bay National Wildlife Refuge | 24851 | 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 | San Diego 4 | 73.57 | San Diego Bay NWR | 1988 | National Wildlife Refuge 105 | 2 | |
15677 | 15677 | 15676 | {"type": "MultiPolygon", "coordinates": [[[[-117.10566, 32.79376], [-117.10471, 32.79491], [-117.10095, 32.79737], [-117.09926, 32.79946], [-117.09919, 32.80154], [-117.09938, 32.80248], [-117.10023, 32.80247], [-117.10057, 32.80525], [-117.09796, 32.8068], [-117.09627, 32.80827], [-117.09628, 32.80812], [-117.09632, 32.80799], [-117.0964, 32.80786], [-117.09665, 32.8076], [-117.09673, 32.80748], [-117.09679, 32.80731], [-117.09688, 32.80696], [-117.09698, 32.80677], [-117.09716, 32.80655], [-117.0972, 32.80644], [-117.09722, 32.80635], [-117.09721, 32.8062], [-117.09717, 32.80608], [-117.09689, 32.8056], [-117.09685, 32.80547], [-117.09686, 32.80531], [-117.09697, 32.8051], [-117.09705, 32.80484], [-117.097, 32.8045], [-117.097, 32.80439], [-117.09705, 32.80422], [-117.09705, 32.80407], [-117.097, 32.80394], [-117.09683, 32.80359], [-117.0968, 32.80341], [-117.09682, 32.80323], [-117.09692, 32.80297], [-117.09692, 32.80282], [-117.09688, 32.80262], [-117.09684, 32.8025], [-117.09599, 32.80251], [-117.09513, 32.8006], [-117.09522, 32.79697], [-117.09603, 32.7952], [-117.10024, 32.79307], [-117.10151, 32.79253], [-117.10383, 32.79159], [-117.10383, 32.7909], [-117.10444, 32.79089], [-117.10491, 32.79081], [-117.10498, 32.79113], [-117.10499, 32.79133], [-117.1049, 32.79146], [-117.10488, 32.79161], [-117.10515, 32.79234], [-117.10517, 32.79254], [-117.10517, 32.79275], [-117.10513, 32.79294], [-117.10508, 32.7931], [-117.105, 32.79328], [-117.10502, 32.79346], [-117.10508, 32.7935], [-117.10522, 32.79349], [-117.10566, 32.79376]]], [[[-117.09604, 32.80847], [-117.09592, 32.80858], [-117.09529, 32.80942], [-117.09358, 32.81096], [-117.09346, 32.8143], [-117.09266, 32.81502], [-117.09264, 32.81504], [-117.09251, 32.81505], [-117.0881, 32.8155], [-117.08204, 32.8097], [-117.08135, 32.80787], [-117.08322, 32.8068], [-117.0853, 32.80616], [-117.09164, 32.80733], [-117.09602, 32.80672], [-117.09604, 32.80847]]]]} | Restricted Access 2 | 12871 | Admiral Baker Golf Course | 31857 | 198 | United States Department of Defense 61 | Federal 1 | Federal Agency 1 | http://www.defense.gov/ | US Military/Defense 11 | 198 | United States Department of Defense 504 | Federal 1 | Federal Agency 1 | https://www.golfnow.com/courses/1027561-admiral-baker-golf-course-north-course-details | San Diego 4 | 409.719 | Admiral Baker GC | 0 | Recreation Management Area 49 | 4 |
10233 | 10233 | 10232 | {"type": "MultiPolygon", "coordinates": [[[[-117.11031, 32.77957], [-117.11031, 32.77985], [-117.11022, 32.77985], [-117.10974, 32.77983], [-117.1093, 32.77979], [-117.10739, 32.77953], [-117.10841, 32.77919], [-117.10972, 32.77926], [-117.11031, 32.77957]]], [[[-117.11031, 32.78139], [-117.10939, 32.78129], [-117.10874, 32.78124], [-117.1081, 32.78124], [-117.10775, 32.78126], [-117.10736, 32.78131], [-117.10694, 32.78141], [-117.10659, 32.78152], [-117.10623, 32.78166], [-117.1059, 32.78182], [-117.10555, 32.78203], [-117.10524, 32.78226], [-117.10493, 32.78253], [-117.10466, 32.78283], [-117.10441, 32.78318], [-117.10419, 32.78357], [-117.10401, 32.78361], [-117.10399, 32.78228], [-117.104, 32.78071], [-117.10652, 32.77982], [-117.10701, 32.77966], [-117.10938, 32.77999], [-117.10979, 32.78019], [-117.11029, 32.78049], [-117.11027, 32.78101], [-117.11031, 32.78139]]]]} | Restricted Access 2 | 12831 | San Diego River Ecological Reserve | 24863 | 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 | 30.386 | San Diego River ER | 0 | State Conservation Area 8 | 2 | |
15568 | 15568 | 15567 | {"type": "MultiPolygon", "coordinates": [[[[-117.15855, 33.46486], [-117.15421, 33.46507], [-117.14524, 33.46588], [-117.14538, 33.46928], [-117.14494, 33.46886], [-117.14213, 33.46585], [-117.13783, 33.46151], [-117.1408, 33.46153], [-117.14069, 33.45434], [-117.13656, 33.45432], [-117.13646, 33.45406], [-117.13637, 33.45348], [-117.1363, 33.45254], [-117.13632, 33.44932], [-117.13637, 33.4487], [-117.13646, 33.448], [-117.13653, 33.44776], [-117.13676, 33.44716], [-117.15344, 33.4472], [-117.15396, 33.4616], [-117.1584, 33.46141], [-117.15855, 33.46486]]], [[[-117.20649, 33.43578], [-117.20644, 33.44303], [-117.19756, 33.44297], [-117.1975, 33.44657], [-117.19305, 33.44653], [-117.19309, 33.44294], [-117.18865, 33.44291], [-117.18876, 33.43575], [-117.19321, 33.43576], [-117.19316, 33.43934], [-117.19759, 33.43937], [-117.19765, 33.43577], [-117.20649, 33.43578]]]]} | Restricted Access 2 | 5509 | Santa Margarita Ecological Reserve | 33342 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 221 | San Diego State University 378 | State 5 | State Agency 5 | https://fsp.sdsu.edu/about-us/ | Riverside 10 | 1078.683 | Santa Margarita ER | 1962 | State Conservation Area 8 | 2 |
10237 | 10237 | 10236 | {"type": "MultiPolygon", "coordinates": [[[[-117.16249, 32.94601], [-117.16193, 32.94655], [-117.16192, 32.94675], [-117.1617, 32.94675], [-117.16137, 32.94705], [-117.16098, 32.94731], [-117.16097, 32.94751], [-117.16067, 32.94766], [-117.15867, 32.94845], [-117.15687, 32.94843], [-117.15688, 32.94911], [-117.1564, 32.9493], [-117.15598, 32.9494], [-117.15555, 32.94946], [-117.15305, 32.94959], [-117.15308, 32.94837], [-117.16054, 32.94596], [-117.16236, 32.94606], [-117.16249, 32.94601]]], [[[-117.16302, 32.94555], [-117.16283, 32.94568], [-117.16267, 32.94582], [-117.16234, 32.94595], [-117.16052, 32.94585], [-117.15309, 32.94825], [-117.1531, 32.94812], [-117.15431, 32.94641], [-117.15674, 32.94598], [-117.15711, 32.94613], [-117.15848, 32.94538], [-117.16225, 32.94328], [-117.163, 32.94474], [-117.16302, 32.94555]]], [[[-117.16592, 32.94474], [-117.16478, 32.94513], [-117.16443, 32.94477], [-117.16477, 32.9446], [-117.16552, 32.94434], [-117.16592, 32.94474]]], [[[-117.16772, 32.94614], [-117.16715, 32.94642], [-117.16635, 32.94573], [-117.16514, 32.94549], [-117.16488, 32.94522], [-117.16604, 32.94483], [-117.16641, 32.94543], [-117.16748, 32.94568], [-117.16772, 32.94614]]], [[[-117.17456, 32.92332], [-117.17351, 32.92332], [-117.17166, 32.92388], [-117.17167, 32.92357], [-117.17186, 32.92346], [-117.17186, 32.92294], [-117.17158, 32.92262], [-117.17207, 32.92214], [-117.17286, 32.92209], [-117.1733, 32.92236], [-117.1735, 32.92254], [-117.17329, 32.92266], [-117.17329, 32.92268], [-117.17456, 32.92332]]]]} | Restricted Access 2 | 13076 | Del Mar Mesa -- Lopez Ridge Ecological Reserve | 18031 | 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 | 84.095 | Del Mar Mesa -- Lopez Ridge ER | 0 | State Conservation Area 8 | 2 | |
5847 | 5847 | 5846 | {"type": "MultiPolygon", "coordinates": [[[[-117.16733, 33.46176], [-117.16524, 33.46316], [-117.16477, 33.46349], [-117.16432, 33.46385], [-117.1639, 33.46423], [-117.16319, 33.46492], [-117.16317, 33.46482], [-117.16297, 33.46465], [-117.16293, 33.46136], [-117.1584, 33.46141], [-117.1583, 33.458], [-117.16286, 33.458], [-117.16294, 33.46135], [-117.16732, 33.46153], [-117.16733, 33.46176]]], [[[-117.17572, 33.43595], [-117.17572, 33.43673], [-117.17535, 33.43751], [-117.17514, 33.43806], [-117.17463, 33.43969], [-117.17358, 33.44319], [-117.1625, 33.4434], [-117.16239, 33.43974], [-117.17142, 33.43963], [-117.17137, 33.43602], [-117.17572, 33.43595]]], [[[-117.17577, 33.44315], [-117.17438, 33.44318], [-117.17551, 33.43984], [-117.17574, 33.43904], [-117.17577, 33.44315]]], [[[-117.1801, 33.45033], [-117.17584, 33.45044], [-117.1758, 33.44675], [-117.18006, 33.44666], [-117.1801, 33.45033]]], [[[-117.20651, 33.43216], [-117.20649, 33.43578], [-117.19766, 33.43577], [-117.1976, 33.43937], [-117.19315, 33.43935], [-117.1932, 33.43576], [-117.18876, 33.43575], [-117.18441, 33.43581], [-117.18444, 33.43223], [-117.18882, 33.43217], [-117.20651, 33.43216]]]]} | Restricted Access 2 | 21992 | Santa Margarita Ecological Reserve | 33342 | 3065 | San Diego State University Foundation 524 | Non Profit 6 | Non Profit - Other 22 | http://www.foundation.sdsu.edu/index.html | Non Governmental Organization 10 | 221 | San Diego State University 378 | State 5 | State Agency 5 | https://fsp.sdsu.edu/about-us/ | Riverside 10 | 493.628 | Santa Margarita ER | 1962 | State Conservation Area 8 | 2 |
16208 | 16208 | 16207 | {"type": "MultiPolygon", "coordinates": [[[[-117.18202, 34.09897], [-117.17363, 34.09895], [-117.17367, 34.10604], [-117.15671, 34.10581], [-117.1567, 34.10592], [-117.13909, 34.10642], [-117.13902, 34.10636], [-117.13901, 34.10642], [-117.12997, 34.1063], [-117.12728, 34.10623], [-117.12701, 34.10594], [-117.12678, 34.10571], [-117.12652, 34.1055], [-117.12624, 34.1053], [-117.1259, 34.10509], [-117.12558, 34.10494], [-117.12529, 34.10481], [-117.12496, 34.10469], [-117.12434, 34.10453], [-117.12369, 34.10445], [-117.12125, 34.10438], [-117.12127, 34.09896], [-117.12566, 34.09902], [-117.12565, 34.10075], [-117.13003, 34.10083], [-117.13004, 34.10082], [-117.13006, 34.09901], [-117.12566, 34.09894], [-117.12565, 34.09886], [-117.12127, 34.09879], [-117.12129, 34.09166], [-117.13014, 34.09176], [-117.13014, 34.09213], [-117.13217, 34.09216], [-117.13219, 34.09179], [-117.13252, 34.09179], [-117.13252, 34.0927], [-117.13455, 34.09272], [-117.13457, 34.09181], [-117.13861, 34.09186], [-117.13899, 34.09244], [-117.139, 34.09186], [-117.14332, 34.09182], [-117.14334, 34.09544], [-117.139, 34.09551], [-117.13901, 34.09914], [-117.15649, 34.0988], [-117.1563, 34.09169], [-117.16496, 34.09171], [-117.16503, 34.09529], [-117.16937, 34.09532], [-117.1694, 34.09712], [-117.17371, 34.09715], [-117.17371, 34.09536], [-117.18199, 34.09537], [-117.18202, 34.09897]], [[-117.12961, 34.10468], [-117.12962, 34.10454], [-117.12938, 34.10454], [-117.12938, 34.10467], [-117.12961, 34.10468]], [[-117.13014, 34.0923], [-117.13014, 34.09267], [-117.13218, 34.09268], [-117.13218, 34.09232], [-117.13014, 34.0923]]], [[[-117.15204, 34.09531], [-117.14768, 34.09537], [-117.14765, 34.09178], [-117.15197, 34.09173], [-117.15204, 34.09531]]]]} | Restricted Access 2 | 44334 | East Highlands Ranch Open Space | 18370 | 2131 | San Bernardino County Flood Control District 891 | Special District 4 | Flood District 8 | http://www.sbcounty.gov/dpw/floodcontrol/ | Special District 4 | 2131 | San Bernardino County Flood Control District 865 | Special District 4 | Flood District 9 | San Bernardino 22 | 1593.347 | East Highlands Ranch OS | 0 | Local Recreation Area 3 | 4 | |
2398 | 2398 | 2397 | {"type": "MultiPolygon", "coordinates": [[[[-117.21972, 33.42999], [-117.21971, 33.43008], [-117.21941, 33.43087], [-117.21888, 33.43101], [-117.21852, 33.43096], [-117.21805, 33.43108], [-117.21795, 33.43113], [-117.21774, 33.43153], [-117.21722, 33.43152], [-117.21407, 33.43154], [-117.21414, 33.42781], [-117.21857, 33.4278], [-117.21851, 33.42935], [-117.21925, 33.42978], [-117.21965, 33.42988], [-117.2197, 33.42993], [-117.21972, 33.42999]]], [[[-117.20291, 33.42795], [-117.20281, 33.43006], [-117.19914, 33.43009], [-117.199, 33.43159], [-117.19592, 33.4316], [-117.19604, 33.42917], [-117.19685, 33.429], [-117.19721, 33.42851], [-117.19932, 33.42801], [-117.20077, 33.42797], [-117.20291, 33.42795]]]]} | Restricted Access 2 | 7255 | Santa Margarita Ecological Reserve | 33342 | 3065 | San Diego State University Foundation 524 | Non Profit 6 | Non Profit - Other 22 | http://www.foundation.sdsu.edu/index.html | Non Governmental Organization 10 | 221 | San Diego State University 378 | State 5 | State Agency 5 | https://fsp.sdsu.edu/about-us/ | San Diego 4 | 88.83 | Santa Margarita ER | 1962 | State Conservation Area 8 | 2 |
4797 | 4797 | 4796 | {"type": "MultiPolygon", "coordinates": [[[[-117.23584, 34.05241], [-117.23549, 34.05282], [-117.23539, 34.05282], [-117.23539, 34.05228], [-117.23553, 34.05229], [-117.23564, 34.05231], [-117.23584, 34.05241]]], [[[-117.23799, 34.05321], [-117.23708, 34.05429], [-117.23702, 34.0543], [-117.23669, 34.0541], [-117.23668, 34.05405], [-117.23759, 34.05298], [-117.23765, 34.05297], [-117.23798, 34.05316], [-117.23799, 34.05321]]], [[[-117.23727, 34.04704], [-117.23727, 34.04741], [-117.23683, 34.04741], [-117.23684, 34.04703], [-117.23704, 34.04703], [-117.23706, 34.04698], [-117.23707, 34.04703], [-117.23727, 34.04704]]], [[[-117.23878, 34.0544], [-117.23852, 34.05439], [-117.23842, 34.05435], [-117.2383, 34.05429], [-117.23867, 34.05386], [-117.23878, 34.05386], [-117.23878, 34.0544]]]]} | Restricted Access 2 | 48470 | Unnamed Park - Mission Trails HOA | 33179 | 7032 | Mission Trails HOA 783 | Private 7 | Home Owners Association 16 | https://www.facebook.com/pg/missiontrailshoa/about/?ref=page_internal | Private 14 | 7032 | Mission Trails HOA 763 | Private 7 | Home Owners Association 15 | San Bernardino 22 | 2.938 | None 403 | ||||
7770 | 7770 | 7769 | {"type": "MultiPolygon", "coordinates": [[[[-117.23873, 32.9777], [-117.23873, 32.97825], [-117.23589, 32.97824], [-117.23589, 32.97769], [-117.23873, 32.9777]]], [[[-117.25998, 32.96757], [-117.25996, 32.96761], [-117.25982, 32.96761], [-117.25966, 32.96764], [-117.25895, 32.96787], [-117.25875, 32.96792], [-117.25836, 32.96797], [-117.25808, 32.96798], [-117.25597, 32.96796], [-117.25596, 32.96753], [-117.24944, 32.96745], [-117.24862, 32.96463], [-117.24826, 32.96383], [-117.25164, 32.96386], [-117.25164, 32.96252], [-117.25179, 32.96252], [-117.25257, 32.96267], [-117.2527, 32.96273], [-117.25298, 32.96294], [-117.25311, 32.96301], [-117.2535, 32.96312], [-117.25362, 32.96313], [-117.25382, 32.96311], [-117.25466, 32.96292], [-117.25492, 32.96291], [-117.25509, 32.96295], [-117.25578, 32.96322], [-117.25651, 32.96401], [-117.25644, 32.96406], [-117.25671, 32.96465], [-117.25696, 32.96493], [-117.2575, 32.96525], [-117.25778, 32.9656], [-117.25788, 32.9657], [-117.25801, 32.96577], [-117.25819, 32.96584], [-117.25856, 32.9661], [-117.25869, 32.96652], [-117.259, 32.96693], [-117.25942, 32.96726], [-117.25998, 32.96757]]]]} | Restricted Access 2 | 29610 | San Dieguito Lagoon Ecological Reserve | 24866 | 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 | 102.535 | San Dieguito Lagoon ER | 0 | State Conservation Area 8 | 2 | |
5503 | 5503 | 5502 | {"type": "MultiPolygon", "coordinates": [[[[-117.24645, 33.15192], [-117.24325, 33.15203], [-117.24295, 33.1512], [-117.24431, 33.15105], [-117.24644, 33.15036], [-117.24645, 33.15192]]], [[[-117.26182, 33.14925], [-117.26138, 33.14958], [-117.25936, 33.14941], [-117.25864, 33.14971], [-117.2584, 33.14977], [-117.25816, 33.14977], [-117.25744, 33.14967], [-117.25731, 33.14967], [-117.25716, 33.14971], [-117.25701, 33.14979], [-117.25667, 33.15004], [-117.25655, 33.15019], [-117.25648, 33.15037], [-117.25635, 33.1512], [-117.25631, 33.1513], [-117.25622, 33.15142], [-117.25586, 33.15176], [-117.25562, 33.15211], [-117.25053, 33.15267], [-117.25006, 33.1537], [-117.24851, 33.15389], [-117.24842, 33.1523], [-117.24819, 33.15211], [-117.24806, 33.15211], [-117.24804, 33.15188], [-117.24906, 33.14891], [-117.24789, 33.14895], [-117.24624, 33.14851], [-117.24658, 33.14758], [-117.24459, 33.14705], [-117.24455, 33.14478], [-117.24659, 33.1439], [-117.24672, 33.1458], [-117.26179, 33.1458], [-117.26182, 33.14925]]]]} | Restricted Access 2 | 12865 | Dawson Los Monos Canyon Reserve | 17958 | 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 | San Diego 4 | 231.903 | Dawson Los Monos Canyon Reserve | 0 | State Conservation Area 8 | 2 | |
6872 | 6872 | 6871 | {"type": "MultiPolygon", "coordinates": [[[[-117.24826, 33.80281], [-117.24825, 33.80455], [-117.24606, 33.80457], [-117.24603, 33.8029], [-117.24629, 33.80289], [-117.24664, 33.80296], [-117.2467, 33.80295], [-117.24675, 33.80291], [-117.24679, 33.80281], [-117.24826, 33.80281]]], [[[-117.26806, 33.81916], [-117.26585, 33.81919], [-117.26585, 33.81556], [-117.26579, 33.81188], [-117.26141, 33.81189], [-117.26146, 33.81559], [-117.25705, 33.81565], [-117.25704, 33.81374], [-117.25263, 33.81378], [-117.25261, 33.81197], [-117.24922, 33.81201], [-117.24922, 33.81118], [-117.24944, 33.81116], [-117.24944, 33.81101], [-117.24934, 33.811], [-117.24936, 33.80968], [-117.24914, 33.80927], [-117.24891, 33.80927], [-117.24891, 33.80833], [-117.24841, 33.80795], [-117.24847, 33.80788], [-117.24838, 33.80781], [-117.24813, 33.80745], [-117.24906, 33.8073], [-117.24907, 33.80729], [-117.2488, 33.80702], [-117.24874, 33.80676], [-117.24778, 33.80691], [-117.2474, 33.80529], [-117.24836, 33.80515], [-117.24825, 33.80463], [-117.24993, 33.80461], [-117.25255, 33.80464], [-117.25252, 33.80114], [-117.25412, 33.8011], [-117.25412, 33.79918], [-117.25422, 33.79917], [-117.25422, 33.79849], [-117.25412, 33.79848], [-117.25411, 33.79593], [-117.25253, 33.79592], [-117.25253, 33.79622], [-117.2504, 33.79625], [-117.25039, 33.79599], [-117.25053, 33.79578], [-117.25039, 33.79575], [-117.25038, 33.79556], [-117.24996, 33.79556], [-117.24931, 33.79527], [-117.24881, 33.79534], [-117.24862, 33.79556], [-117.24821, 33.79556], [-117.24808, 33.78924], [-117.25025, 33.78924], [-117.25029, 33.79101], [-117.25252, 33.79101], [-117.25253, 33.79438], [-117.26128, 33.79438], [-117.26134, 33.80817], [-117.26358, 33.80819], [-117.2636, 33.81004], [-117.26579, 33.81005], [-117.2658, 33.81188], [-117.26689, 33.81188], [-117.26694, 33.81554], [-117.26801, 33.81554], [-117.26806, 33.81916]], [[-117.25355, 33.79496], [-117.25355, 33.79482], [-117.25339, 33.79482], [-117.25339, 33.79496], [-117.25355, 33.79496]]]]} | Restricted Access 2 | 5523 | Motte Rimrock Reserve | 22519 | 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 | https://ucnrs.org/reserves/motte-rimrock-reserve/ | Riverside 10 | 639.088 | Motte Rimrock Reserve | 0 | State Conservation Area 8 | 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]);