units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,421 rows where COUNTY = 4
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 245
- San Diego, County of 62
- Poway, City of 52
- Chula Vista, City of 50
- Encinitas, City of 34
- California Department of Fish and Wildlife 26
- San Marcos, City of 21
- Oceanside, City of 20
- The Environmental Trust 20
- California Department of Parks and Recreation 17
- Home Owners Association - Unknown Name 17
- Carlsbad, City of 14
- California Department of Transportation 13
- Escondido, City of 12
- Center for Natural Lands Management 11
- Endangered Habitats Conservancy 10
- El Cajon, City of 9
- Fallbrook Land Conservancy 9
- United States Fish and Wildlife Service 8
- San Diego Unified Port District 6
- Vista, City of 5
- United States Bureau of Land Management 4
- Santee, City of 4
- La Mesa, City of 4
- University of California 4
- Del Mar, City of 4
- Coronado, City of 4
- San Dieguito River Valley Land Conservancy 4
- Olivenhain Municipal Water District 4
- Ramona Municipal Water District 4
- …
DES_TP >30
- Local Park 264
- Local Recreation Area 181
- Local Other or Unknown 68
- Private Conservation 58
- Local Conservation Area 36
- State Conservation Area 30
- Private Recreation or Education 22
- State Park 14
- State Other or Unknown 12
- National Wildlife Refuge 7
- State Resource Management Area 4
- Conservation Area 2
- State Recreation Area 2
- National Public Lands 1
- National Forest 1
- Local Historic or Cultural Area 1
- Recreation Management Area 1
- National Monument or Landmark 1
- State Historic or Cultural Area 1
- Private Other or Unknown 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 19
- City Agency 485
- State Agency 64
- County Agency 62
- Non Profit - Land Trust 49
- Water District 18
- Home Owners Association 18
- Federal Agency 16
- Non Profit - Conservation 13
- Port/Harbor District 6
- Recreation/Parks District 4
- Transportation Agency 4
- Commercial 3
- Non Profit - Other 3
- Open Space District 2
- School District 1
- Special District - Other 1
- Other 1
- Mitigation Bank 1
- Fire District 1
ACCESS_TYP 4
- Open Access 587
- No Public Access 82
- Restricted Access 64
- Unknown Access 19
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6772 | 6772 | 6771 | {"type": "MultiPolygon", "coordinates": [[[[-116.85271, 32.89302], [-116.85016, 32.89317], [-116.85014, 32.89281], [-116.84423, 32.89275], [-116.84295, 32.89205], [-116.84351, 32.8922], [-116.84518, 32.89238], [-116.84573, 32.89242], [-116.84616, 32.89241], [-116.84661, 32.89238], [-116.84788, 32.89222], [-116.8482, 32.89215], [-116.84849, 32.89204], [-116.84878, 32.89189], [-116.84902, 32.89172], [-116.84923, 32.89151], [-116.84936, 32.89135], [-116.84947, 32.89115], [-116.84995, 32.89012], [-116.85271, 32.89302]]], [[[-116.85018, 32.88908], [-116.85003, 32.88947], [-116.84931, 32.89106], [-116.84921, 32.89122], [-116.84905, 32.89144], [-116.84886, 32.89162], [-116.84863, 32.89178], [-116.8484, 32.8919], [-116.84815, 32.89199], [-116.84785, 32.89205], [-116.8466, 32.89221], [-116.84599, 32.89225], [-116.84526, 32.89223], [-116.84343, 32.89201], [-116.84478, 32.88919], [-116.84558, 32.8872], [-116.84609, 32.88674], [-116.84638, 32.88601], [-116.84995, 32.88843], [-116.85002, 32.8885], [-116.85007, 32.88858], [-116.85018, 32.88908]]]]} | Open Access 1 | 5237 | El Monte Park | 18518 | 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 | http://www.sdparks.org/content/sdparks/en/park-pages/ElMonte.html | San Diego 4 | 87.505 | El Monte Park | 0 | Local Park 2 | 4 |
6782 | 6782 | 6781 | {"type": "MultiPolygon", "coordinates": [[[[-116.92828, 33.33989], [-116.92819, 33.34295], [-116.91087, 33.3428], [-116.91078, 33.34648], [-116.91508, 33.34654], [-116.91504, 33.35015], [-116.91483, 33.35742], [-116.91054, 33.35745], [-116.90625, 33.3575], [-116.90637, 33.35385], [-116.90369, 33.35384], [-116.90209, 33.35386], [-116.90215, 33.35019], [-116.89792, 33.35022], [-116.89802, 33.34068], [-116.89739, 33.33931], [-116.89658, 33.33931], [-116.89646, 33.33921], [-116.88936, 33.33929], [-116.88933, 33.33533], [-116.88935, 33.32868], [-116.88784, 33.32864], [-116.88506, 33.32861], [-116.88497, 33.32498], [-116.89331, 33.3251], [-116.89349, 33.32551], [-116.8937, 33.32574], [-116.89392, 33.32591], [-116.89486, 33.32637], [-116.89563, 33.32662], [-116.89575, 33.32668], [-116.89591, 33.32679], [-116.89625, 33.32717], [-116.89645, 33.32732], [-116.89661, 33.3274], [-116.89677, 33.32745], [-116.89713, 33.32751], [-116.89752, 33.32755], [-116.89819, 33.32771], [-116.89846, 33.32781], [-116.89896, 33.32802], [-116.8993, 33.32836], [-116.89951, 33.32864], [-116.89959, 33.32864], [-116.89974, 33.32881], [-116.90005, 33.329], [-116.90126, 33.32955], [-116.90135, 33.3296], [-116.9015, 33.32975], [-116.90159, 33.32994], [-116.90164, 33.33001], [-116.90204, 33.33042], [-116.90329, 33.33111], [-116.90356, 33.33131], [-116.90387, 33.33151], [-116.90414, 33.33162], [-116.90431, 33.33166], [-116.90476, 33.33172], [-116.90498, 33.33173], [-116.90511, 33.33174], [-116.90645, 33.33219], [-116.90657, 33.33225], [-116.90663, 33.3323], [-116.90671, 33.33241], [-116.90706, 33.33279], [-116.90725, 33.33291], [-116.90748, 33.33303], [-116.90787, 33.33311], [-116.90816, 33.33311], [-116.90851, 33.33304], [-116.90886, 33.33294], [-116.90888, 33.33311], [-116.90884, 33.33322], [-116.90878, 33.33332], [-116.90866, 33.33343], [-116.90848, 33.33355], [-116.90827, 33.33372], [-116.9078, 33.33415], [-116.90766, 33.33431], [-116.90753, 33.33454], [-116.90747, 33.33478], [-116.90746, 33.33494], [-116.90747, 33.33504], [-116.9075, 33.3351], [-116.90758, 33.33518], [-116.90806, 33.33546], [-116.9081, 33.33552], [-116.90815, 33.33562], [-116.90813, 33.33578], [-116.90779, 33.33669], [-116.9078, 33.3368], [-116.90786, 33.33693], [-116.90839, 33.33754], [-116.90846, 33.33759], [-116.90859, 33.33763], [-116.90908, 33.3376], [-116.90925, 33.33768], [-116.90929, 33.33775], [-116.90931, 33.33784], [-116.90924, 33.33809], [-116.90925, 33.33821], [-116.90936, 33.33832], [-116.90974, 33.33851], [-116.90982, 33.33858], [-116.90986, 33.33865], [-116.90989, 33.33872], [-116.90997, 33.3391], [-116.91012, 33.3393], [-116.91016, 33.33942], [-116.91033, 33.3401], [-116.91032, 33.34036], [-116.91026, 33.34054], [-116.91016, 33.3407], [-116.91006, 33.34082], [-116.90988, 33.34096], [-116.90982, 33.34107], [-116.90979, 33.34108], [-116.90919, 33.34095], [-116.90887, 33.34092], [-116.90856, 33.34095], [-116.908, 33.34107], [-116.9079, 33.34107], [-116.90782, 33.34103], [-116.90773, 33.34095], [-116.90765, 33.3409], [-116.90744, 33.34085], [-116.90727, 33.34077], [-116.90714, 33.34066], [-116.90704, 33.34061], [-116.90694, 33.3406], [-116.90616, 33.34066], [-116.90603, 33.34066], [-116.90593, 33.34063], [-116.9058, 33.34055], [-116.90556, 33.3402], [-116.90547, 33.34011], [-116.90532, 33.34002], [-116.90515, 33.33999], [-116.905, 33.33998], [-116.90483, 33.34], [-116.90453, 33.34009], [-116.90395, 33.34007], [-116.90374, 33.34008], [-116.90354, 33.34011], [-116.90338, 33.34018], [-116.90317, 33.34029], [-116.90296, 33.34048], [-116.90288, 33.34059], [-116.90243, 33.34134], [-116.9023, 33.34147], [-116.90194, 33.34176], [-116.90175, 33.34182], [-116.90162, 33.34189], [-116.90152, 33.34197], [-116.90148, 33.34203], [-116.90132, 33.34245], [-116.90128, 33.34263], [-116.90131, 33.34288], [-116.90144, 33.34314], [-116.90147, 33.34312], [-116.90151, 33.34309], [-116.90152, 33.34301], [-116.90146, 33.34292], [-116.90142, 33.34276], [-116.90141, 33.34257], [-116.90154, 33.34218], [-116.90158, 33.34209], [-116.90166, 33.342], [-116.90177, 33.34193], [-116.90196, 33.34187], [-116.90213, 33.34176], [-116.90225, 33.34168], [-116.90247, 33.34148], [-116.90262, 33.34129], [-116.90304, 33.34059], [-116.90317, 33.34045], [-116.90334, 33.34032], [-116.90354, 33.34023], [-116.90375, 33.34019], [-116.90394, 33.34018], [-116.90454, 33.34021], [-116.90485, 33.34011], [-116.90501, 33.34009], [-116.90521, 33.3401], [-116.90529, 33.34013], [-116.90538, 33.34019], [-116.90545, 33.34026], [-116.9057, 33.34063], [-116.90579, 33.34069], [-116.90597, 33.34075], [-116.90616, 33.34077], [-116.90696, 33.34071], [-116.90702, 33.34072], [-116.90707, 33.34074], [-116.90728, 33.34092], [-116.9076, 33.34101], [-116.90774, 33.34113], [-116.90789, 33.34118], [-116.90802, 33.34118], [-116.90861, 33.34105], [-116.90893, 33.34104], [-116.90912, 33.34104], [-116.9092, 33.34107], [-116.90923, 33.34106], [-116.90995, 33.34124], [-116.90994, 33.34115], [-116.90996, 33.34106], [-116.91016, 33.3409], [-116.91028, 33.34075], [-116.9104, 33.34055], [-116.91045, 33.34038], [-116.91046, 33.34011], [-116.91026, 33.3393], [-116.9102, 33.3392], [-116.9101, 33.33907], [-116.91, 33.33865], [-116.90992, 33.3385], [-116.90974, 33.33838], [-116.90944, 33.33823], [-116.90938, 33.33819], [-116.90937, 33.33811], [-116.90944, 33.33784], [-116.90942, 33.33771], [-116.90936, 33.33762], [-116.90924, 33.33754], [-116.90912, 33.3375], [-116.90902, 33.33749], [-116.90856, 33.33751], [-116.90852, 33.33749], [-116.90823, 33.33718], [-116.90796, 33.33685], [-116.90793, 33.33672], [-116.90794, 33.33663], [-116.90826, 33.33581], [-116.90827, 33.33561], [-116.90822, 33.33546], [-116.90814, 33.33537], [-116.90803, 33.33529], [-116.90765, 33.33508], [-116.90761, 33.33504], [-116.9076, 33.33499], [-116.9076, 33.33482], [-116.9077, 33.33449], [-116.9079, 33.33423], [-116.90827, 33.33387], [-116.90886, 33.33342], [-116.90893, 33.33331], [-116.90901, 33.33311], [-116.90901, 33.333], [-116.90898, 33.3329], [-116.90963, 33.33265], [-116.90979, 33.33255], [-116.90988, 33.33247], [-116.90998, 33.33254], [-116.91011, 33.33269], [-116.91022, 33.33277], [-116.91044, 33.33285], [-116.91061, 33.33295], [-116.91072, 33.33302], [-116.91089, 33.33317], [-116.91098, 33.33327], [-116.91103, 33.33337], [-116.91103, 33.33344], [-116.91097, 33.33362], [-116.91097, 33.33373], [-116.911, 33.33384], [-116.91107, 33.33399], [-116.91116, 33.33408], [-116.91152, 33.33435], [-116.91178, 33.33457], [-116.91203, 33.33482], [-116.91233, 33.33516], [-116.91244, 33.33527], [-116.9127, 33.33546], [-116.91288, 33.33555], [-116.9136, 33.33587], [-116.91408, 33.33613], [-116.91439, 33.33625], [-116.91455, 33.33629], [-116.91493, 33.33631], [-116.91524, 33.33629], [-116.9157, 33.33615], [-116.91611, 33.3361], [-116.91662, 33.3361], [-116.91674, 33.33612], [-116.91692, 33.33619], [-116.917, 33.33624], [-116.9171, 33.33633], [-116.91722, 33.33653], [-116.91727, 33.3367], [-116.91727, 33.33682], [-116.91725, 33.33693], [-116.91719, 33.33707], [-116.91688, 33.33753], [-116.91684, 33.33765], [-116.91686, 33.33788], [-116.91691, 33.338], [-116.9173, 33.33863], [-116.91746, 33.33879], [-116.91819, 33.33926], [-116.91832, 33.33927], [-116.91892, 33.33921], [-116.91909, 33.33921], [-116.91939, 33.33927], [-116.91957, 33.33934], [-116.91973, 33.33943], [-116.91992, 33.3396], [-116.92006, 33.33979], [-116.92019, 33.33992], [-116.92057, 33.34015], [-116.92167, 33.34051], [-116.92204, 33.34061], [-116.92228, 33.3407], [-116.92263, 33.34087], [-116.923, 33.34114], [-116.92322, 33.34123], [-116.92346, 33.34132], [-116.92382, 33.34139], [-116.92414, 33.34143], [-116.92446, 33.34143], [-116.92459, 33.3414], [-116.92466, 33.34136], [-116.92469, 33.34132], [-116.92473, 33.34117], [-116.92455, 33.34078], [-116.92446, 33.34063], [-116.9243, 33.34044], [-116.92398, 33.34018], [-116.92381, 33.33996], [-116.9238, 33.33992], [-116.92381, 33.33989], [-116.92386, 33.33983], [-116.9244, 33.33983], [-116.92488, 33.33996], [-116.92507, 33.33998], [-116.92513, 33.33997], [-116.92521, 33.33995], [-116.92529, 33.33988], [-116.92537, 33.33968], [-116.92542, 33.33961], [-116.92552, 33.33957], [-116.92571, 33.3395], [-116.92613, 33.33941], [-116.92668, 33.33939], [-116.92687, 33.33941], [-116.92704, 33.33945], [-116.92755, 33.33966], [-116.92795, 33.33985], [-116.92812, 33.33988], [-116.92828, 33.33989]]], [[[-116.89401, 33.32511], [-116.89396, 33.32546], [-116.89395, 33.32563], [-116.89392, 33.32562], [-116.89372, 33.3254], [-116.89367, 33.32533], [-116.8936, 33.32511], [-116.89401, 33.32511]]], [[[-116.92851, 33.33186], [-116.92834, 33.33726], [-116.92828, 33.33978], [-116.92813, 33.33978], [-116.92801, 33.33975], [-116.92761, 33.33956], [-116.92711, 33.33935], [-116.9267, 33.33928], [-116.92611, 33.3393], [-116.92553, 33.33944], [-116.92538, 33.3395], [-116.92529, 33.33957], [-116.92523, 33.33965], [-116.92521, 33.33977], [-116.92518, 33.33981], [-116.92514, 33.33986], [-116.92505, 33.33987], [-116.92474, 33.33981], [-116.92442, 33.33972], [-116.92385, 33.33971], [-116.92377, 33.33975], [-116.92367, 33.33987], [-116.92368, 33.33997], [-116.9237, 33.34002], [-116.92389, 33.34026], [-116.92418, 33.3405], [-116.92433, 33.34067], [-116.92442, 33.3408], [-116.9246, 33.34117], [-116.92458, 33.34125], [-116.92455, 33.34129], [-116.9245, 33.34132], [-116.92408, 33.34132], [-116.92385, 33.34129], [-116.92331, 33.34115], [-116.9231, 33.34106], [-116.92268, 33.34077], [-116.92233, 33.34059], [-116.92058, 33.34003], [-116.92039, 33.33992], [-116.92015, 33.33971], [-116.92001, 33.33952], [-116.91987, 33.33939], [-116.91972, 33.33929], [-116.91956, 33.33921], [-116.91922, 33.33911], [-116.91906, 33.3391], [-116.91892, 33.3391], [-116.91832, 33.33917], [-116.91819, 33.33913], [-116.91755, 33.33871], [-116.91737, 33.33853], [-116.91702, 33.33794], [-116.91698, 33.33783], [-116.91697, 33.33769], [-116.917, 33.33756], [-116.91729, 33.33715], [-116.91739, 33.33692], [-116.9174, 33.33682], [-116.91739, 33.33663], [-116.91733, 33.33648], [-116.91726, 33.33633], [-116.91706, 33.33614], [-116.91691, 33.33605], [-116.91677, 33.33601], [-116.91666, 33.33599], [-116.91633, 33.33598], [-116.91602, 33.336], [-116.91567, 33.33604], [-116.91516, 33.33619], [-116.91485, 33.33621], [-116.91457, 33.33618], [-116.91436, 33.33612], [-116.91415, 33.33604], [-116.91367, 33.33577], [-116.91298, 33.33547], [-116.91281, 33.33538], [-116.91252, 33.33518], [-116.91211, 33.33473], [-116.91185, 33.33448], [-116.91155, 33.33423], [-116.91122, 33.33398], [-116.91116, 33.3339], [-116.91111, 33.33378], [-116.9111, 33.33366], [-116.91116, 33.33349], [-116.91117, 33.3334], [-116.91109, 33.33321], [-116.91092, 33.33303], [-116.91076, 33.3329], [-116.91058, 33.33279], [-116.91034, 33.33268], [-116.90997, 33.33239], [-116.90983, 33.33236], [-116.90961, 33.33253], [-116.90921, 33.33269], [-116.90871, 33.33287], [-116.90847, 33.33294], [-116.90814, 33.333], [-116.90798, 33.333], [-116.90773, 33.33298], [-116.90752, 33.33292], [-116.90727, 33.33279], [-116.90718, 33.33273], [-116.90708, 33.33265], [-116.90673, 33.33223], [-116.90661, 33.33214], [-116.90648, 33.33208], [-116.90518, 33.33164], [-116.90499, 33.33161], [-116.90469, 33.33161], [-116.90446, 33.33158], [-116.90418, 33.33152], [-116.9039, 33.3314], [-116.9034, 33.33105], [-116.90212, 33.33034], [-116.90178, 33.32998], [-116.90171, 33.32987], [-116.9016, 33.32967], [-116.90151, 33.32958], [-116.90143, 33.32951], [-116.90132, 33.32945], [-116.90013, 33.3289], [-116.89984, 33.32872], [-116.89975, 33.32864], [-116.91115, 33.32847], [-116.92371, 33.32843], [-116.92368, 33.33192], [-116.92805, 33.33191], [-116.92851, 33.33186]]]]} | Open Access 1 | 5322 | Palomar Mountain State Park | 1670 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=637 | San Diego 4 | 1870.348 | Palomar Mtn. SP | 1932 | State Park 15 | 4 |
6785 | 6785 | 6784 | {"type": "Polygon", "coordinates": [[[-117.25752, 33.40873], [-117.25323, 33.40878], [-117.25324, 33.41265], [-117.24915, 33.41271], [-117.24922, 33.40887], [-117.24932, 33.40872], [-117.24939, 33.40856], [-117.24945, 33.40837], [-117.24947, 33.40824], [-117.24939, 33.40734], [-117.24924, 33.40619], [-117.24924, 33.4061], [-117.24935, 33.40529], [-117.24926, 33.40393], [-117.24924, 33.40289], [-117.24928, 33.40267], [-117.24932, 33.40252], [-117.24946, 33.40219], [-117.24965, 33.40189], [-117.25008, 33.4014], [-117.25014, 33.40129], [-117.2503, 33.40084], [-117.2503, 33.40072], [-117.25027, 33.40062], [-117.25028, 33.40061], [-117.25015, 33.40032], [-117.25013, 33.4002], [-117.25023, 33.3996], [-117.25023, 33.39948], [-117.25019, 33.39938], [-117.25013, 33.39929], [-117.24996, 33.39916], [-117.25256, 33.39932], [-117.25255, 33.39925], [-117.25239, 33.39903], [-117.25238, 33.39893], [-117.25242, 33.39881], [-117.25252, 33.3987], [-117.25256, 33.39862], [-117.25258, 33.39847], [-117.25682, 33.39851], [-117.25613, 33.40205], [-117.25582, 33.40206], [-117.25572, 33.40275], [-117.25524, 33.4065], [-117.2575, 33.40647], [-117.25752, 33.40873]]]} | Open Access 1 | 5282 | Santa Margarita Preserve | 25099 | 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 | http://www.sdparks.org/content/sdparks/en/park-pages/SantaMargarita.html | San Diego 4 | 211.224 | Santa Margarita Preserve | 0 | Local Conservation Area 4 | 2 |
6795 | 6795 | 6794 | {"type": "MultiPolygon", "coordinates": [[[[-117.23538, 33.37666], [-117.23537, 33.37797], [-117.23496, 33.37797], [-117.23496, 33.37696], [-117.23431, 33.37695], [-117.23431, 33.37662], [-117.2353, 33.37661], [-117.23535, 33.37663], [-117.23538, 33.37666]]], [[[-117.23748, 33.37662], [-117.23725, 33.37715], [-117.23745, 33.37724], [-117.23724, 33.37765], [-117.23639, 33.37765], [-117.23639, 33.37853], [-117.23556, 33.37853], [-117.23557, 33.37665], [-117.23562, 33.37661], [-117.23748, 33.37662]]]]} | Open Access 1 | 5294 | Fallbrook Park and Community Center | 18835 | 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 | http://www.sdparks.org/content/sdparks/en/park-pages/FallbrookCommunityCenter.html | San Diego 4 | 8.565 | Fallbrook Park and Community Ctr. | 0 | Local Recreation Area 3 | 4 |
6800 | 6800 | 6799 | {"type": "Polygon", "coordinates": [[[-116.32668, 33.22441], [-116.32666, 33.22675], [-116.32578, 33.22675], [-116.32579, 33.22442], [-116.32668, 33.22441]]]} | No Public Access 3 | 5312 | Mesquite Bosque | 28286 | 3004 | Anza-Borrego Foundation 836 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.theabf.org/ | Non Governmental Organization 10 | 3004 | Anza-Borrego Foundation 822 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 5.285 | Mesquite Bosque | 0 | Private Conservation 16 | 2 | |
6802 | 6802 | 6801 | {"type": "MultiPolygon", "coordinates": [[[[-116.91462, 33.22682], [-116.91453, 33.23359], [-116.91037, 33.23358], [-116.91038, 33.23708], [-116.90136, 33.23707], [-116.90139, 33.227], [-116.90169, 33.22659], [-116.91067, 33.22678], [-116.91462, 33.22682]]], [[[-116.92783, 33.19759], [-116.92778, 33.20078], [-116.92782, 33.2009], [-116.92779, 33.20311], [-116.9278, 33.20838], [-116.91504, 33.20852], [-116.91746, 33.20521], [-116.92314, 33.19761], [-116.92783, 33.19759]]], [[[-116.96695, 33.2241], [-116.96284, 33.22408], [-116.96285, 33.22763], [-116.96266, 33.23129], [-116.95379, 33.23114], [-116.95353, 33.23836], [-116.95793, 33.23848], [-116.95778, 33.2421], [-116.94485, 33.24154], [-116.92792, 33.2417], [-116.91891, 33.24172], [-116.91909, 33.2343], [-116.91916, 33.23058], [-116.92233, 33.23056], [-116.92215, 33.23127], [-116.92182, 33.2315], [-116.92221, 33.23241], [-116.92339, 33.23242], [-116.92344, 33.23055], [-116.92777, 33.23051], [-116.92787, 33.22694], [-116.93242, 33.22711], [-116.93206, 33.22005], [-116.93192, 33.2162], [-116.93202, 33.2162], [-116.93202, 33.21615], [-116.93604, 33.21632], [-116.93838, 33.21647], [-116.94032, 33.21654], [-116.94079, 33.22037], [-116.94526, 33.22053], [-116.9496, 33.22055], [-116.94957, 33.22402], [-116.95836, 33.22405], [-116.95837, 33.22057], [-116.96282, 33.22058], [-116.96695, 33.22052], [-116.96695, 33.2241]], [[-116.9453, 33.22652], [-116.94303, 33.22648], [-116.943, 33.22742], [-116.9453, 33.22745], [-116.9453, 33.22652]]]]} | Open Access 1 | 5317 | Hellhole Canyon Preserve | 29239 | 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 | http://www.sdparks.org/content/sdparks/en/park-pages/HellholeCanyon.html | San Diego 4 | 2451.423 | Hellhole Canyon Preserve | 0 | Local Conservation Area 4 | 2 |
6804 | 6804 | 6803 | {"type": "Polygon", "coordinates": [[[-116.86005, 33.31388], [-116.86006, 33.31401], [-116.86005, 33.31413], [-116.85991, 33.31447], [-116.85907, 33.31471], [-116.85906, 33.31388], [-116.85861, 33.31387], [-116.85861, 33.31286], [-116.85864, 33.31285], [-116.85865, 33.31273], [-116.85907, 33.31274], [-116.85908, 33.31311], [-116.85934, 33.31313], [-116.85934, 33.31387], [-116.86005, 33.31388]]]} | Open Access 1 | 5328 | Palomar County Park | 31534 | 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 | http://www.sdparks.org/content/sdparks/en/park-pages/Palomar.html | San Diego 4 | 3.548 | Palomar County Park | 0 | Local Park 2 | 4 |
6812 | 6812 | 6811 | {"type": "Polygon", "coordinates": [[[-117.08786, 33.07997], [-117.08663, 33.08481], [-117.0855, 33.08398], [-117.08509, 33.08399], [-117.08483, 33.08422], [-117.08478, 33.08422], [-117.08463, 33.08428], [-117.0845, 33.08425], [-117.08444, 33.08419], [-117.08339, 33.0828], [-117.08329, 33.08262], [-117.08314, 33.08231], [-117.083, 33.08184], [-117.08296, 33.08162], [-117.08294, 33.08128], [-117.08302, 33.08086], [-117.08394, 33.08103], [-117.084, 33.08091], [-117.08399, 33.0809], [-117.08305, 33.08074], [-117.0832, 33.08033], [-117.08426, 33.07827], [-117.08433, 33.07802], [-117.0844, 33.07797], [-117.08441, 33.07795], [-117.08443, 33.07795], [-117.08542, 33.07814], [-117.08571, 33.07944], [-117.08628, 33.07986], [-117.08671, 33.07998], [-117.08786, 33.07997]]]} | Open Access 1 | 5367 | Felicita Park | 18866 | 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 | http://www.sdparks.org/content/sdparks/en/park-pages/Felicita.html | San Diego 4 | 51.878 | Felicita Park | 0 | Local Park 2 | 4 |
6823 | 6823 | 6822 | {"type": "Polygon", "coordinates": [[[-116.60352, 33.07735], [-116.60296, 33.07789], [-116.60246, 33.07753], [-116.60288, 33.07712], [-116.60264, 33.07693], [-116.60277, 33.07681], [-116.60352, 33.07735]]]} | Open Access 1 | 5406 | Julian Museum and Pioneer Park | 29242 | 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 | http://www.sdparks.org/content/sdparks/en/park-pages/JulianMuseum.html | San Diego 4 | 1.352 | Julian Museum and Pioneer Park | 0 | Local Park 2 | 4 |
6825 | 6825 | 6824 | {"type": "Polygon", "coordinates": [[[-117.17513, 33.01315], [-117.17085, 33.01592], [-117.16887, 33.01455], [-117.16549, 33.01457], [-117.16225, 33.01456], [-117.16124, 33.01454], [-117.16134, 33.01093], [-117.15898, 33.01092], [-117.15897, 33.0073], [-117.16989, 33.00728], [-117.1699, 33.01127], [-117.17283, 33.01129], [-117.1732, 33.01127], [-117.17395, 33.01128], [-117.174, 33.01125], [-117.17441, 33.01238], [-117.17513, 33.01315]]]} | Open Access 1 | 5419 | Lusardi Creek Preserve | 29247 | 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 | http://www.sdparks.org/content/sdparks/en/park-pages/LusardiCreek.html | San Diego 4 | 225.646 | Lusardi Creek Preserve | 0 | Local Conservation Area 4 | 2 |
6830 | 6830 | 6829 | {"type": "Polygon", "coordinates": [[[-117.18338, 33.25274], [-117.18272, 33.25297], [-117.18189, 33.25323], [-117.18125, 33.25339], [-117.18097, 33.25343], [-117.18104, 33.24925], [-117.18302, 33.24925], [-117.18305, 33.2493], [-117.18316, 33.24949], [-117.18322, 33.24967], [-117.1836, 33.25208], [-117.18366, 33.2523], [-117.18378, 33.25255], [-117.18377, 33.25259], [-117.18374, 33.25261], [-117.18338, 33.25274]]]} | Open Access 1 | 5437 | Gopher Canyon Reserve | 19407 | 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 | 23.859 | Gopher Canyon Reserve | 0 | Local Conservation Area 4 | 2 | |
6841 | 6841 | 6840 | {"type": "MultiPolygon", "coordinates": [[[[-117.23974, 32.85472], [-117.23925, 32.85483], [-117.23933, 32.85519], [-117.23937, 32.8556], [-117.23871, 32.85528], [-117.23828, 32.85503], [-117.23808, 32.85442], [-117.23954, 32.85411], [-117.23974, 32.85472]]], [[[-117.24498, 32.85374], [-117.24398, 32.85378], [-117.24242, 32.85398], [-117.24244, 32.85667], [-117.24223, 32.85667], [-117.24151, 32.85488], [-117.24143, 32.85473], [-117.24131, 32.85481], [-117.24108, 32.85498], [-117.24072, 32.85534], [-117.24022, 32.8554], [-117.24012, 32.85499], [-117.23979, 32.85406], [-117.24494, 32.85295], [-117.24498, 32.85374]]]]} | Open Access 1 | 330 | Pottery Canyon Natural Open Space Park | 23928 | 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 | 18.176 | Pottery Canyon Natural OS Park | 0 | Local Recreation Area 3 | 4 | |
6865 | 6865 | 6864 | {"type": "Polygon", "coordinates": [[[-116.88206, 32.9016], [-116.87735, 32.90152], [-116.87743, 32.90675], [-116.87754, 32.91269], [-116.87364, 32.91266], [-116.87363, 32.91259], [-116.86927, 32.9126], [-116.86073, 32.91264], [-116.86073, 32.91536], [-116.85906, 32.91535], [-116.85857, 32.91537], [-116.84119, 32.9155], [-116.84121, 32.91914], [-116.84126, 32.92277], [-116.83271, 32.92285], [-116.83293, 32.93288], [-116.83278, 32.93287], [-116.83277, 32.93288], [-116.83424, 32.93483], [-116.82384, 32.93501], [-116.8236, 32.92202], [-116.82359, 32.91926], [-116.8236, 32.91642], [-116.83981, 32.91648], [-116.83994, 32.90146], [-116.83993, 32.90145], [-116.82362, 32.90223], [-116.82372, 32.8874], [-116.828, 32.8874], [-116.82799, 32.89121], [-116.83615, 32.89146], [-116.84492, 32.89538], [-116.84472, 32.89861], [-116.84891, 32.89856], [-116.84889, 32.90108], [-116.8525, 32.90092], [-116.85243, 32.90479], [-116.84825, 32.9049], [-116.84828, 32.9088], [-116.85647, 32.90867], [-116.85649, 32.90782], [-116.8565, 32.90482], [-116.86949, 32.9051], [-116.86958, 32.90132], [-116.86968, 32.8984], [-116.86146, 32.89843], [-116.86208, 32.89371], [-116.87781, 32.88967], [-116.87782, 32.89258], [-116.88195, 32.89201], [-116.88202, 32.89926], [-116.88206, 32.9016]]]} | Open Access 1 | 5516 | El Capitan Preserve | 30283 | 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 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/ElCapitan.html | San Diego 4 | 2603.63 | El Capitan Preserve | 0 | Local Conservation Area 4 | 2 |
6917 | 6917 | 6916 | {"type": "Polygon", "coordinates": [[[-117.22177, 32.80173], [-117.21992, 32.8021], [-117.21973, 32.80186], [-117.21885, 32.80041], [-117.22093, 32.79992], [-117.22106, 32.79999], [-117.22122, 32.80017], [-117.22177, 32.80173]]]} | Open Access 1 | 47691 | McEvoy Field - Mission Bay Athletic Area | 31530 | 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 | 10.355 | McEvoy Field - Mission Bay Athletic Area | 0 | Local Recreation Area 3 | 4 | |
6918 | 6918 | 6917 | {"type": "MultiPolygon", "coordinates": [[[[-117.23536, 33.03391], [-117.23513, 33.03422], [-117.2342, 33.03397], [-117.23474, 33.03348], [-117.23477, 33.03348], [-117.23517, 33.03379], [-117.23536, 33.03391]]], [[[-117.23609, 33.03514], [-117.23555, 33.03678], [-117.23459, 33.03653], [-117.23477, 33.03601], [-117.23609, 33.03514]]], [[[-117.23732, 33.03115], [-117.23555, 33.03272], [-117.23531, 33.03354], [-117.23553, 33.03368], [-117.23569, 33.03369], [-117.23557, 33.03381], [-117.23525, 33.0336], [-117.23497, 33.03337], [-117.23493, 33.03326], [-117.23496, 33.03324], [-117.2351, 33.03295], [-117.23513, 33.03282], [-117.23514, 33.0326], [-117.23511, 33.03241], [-117.23505, 33.03223], [-117.23496, 33.03209], [-117.23577, 33.03136], [-117.23603, 33.03158], [-117.23624, 33.0314], [-117.23625, 33.03135], [-117.23668, 33.03095], [-117.23612, 33.03046], [-117.23629, 33.0303], [-117.23732, 33.03115]]], [[[-117.24184, 33.03031], [-117.24168, 33.03057], [-117.24148, 33.03079], [-117.24127, 33.03094], [-117.24071, 33.03129], [-117.24106, 33.03011], [-117.24184, 33.03031]]], [[[-117.27719, 33.00739], [-117.27719, 33.00739], [-117.27717, 33.00818], [-117.27696, 33.00739], [-117.27719, 33.00739]]], [[[-117.27882, 33.01168], [-117.27819, 33.01179], [-117.27803, 33.01121], [-117.27846, 33.01114], [-117.2784, 33.01123], [-117.2784, 33.01129], [-117.27872, 33.01159], [-117.2788, 33.01158], [-117.27882, 33.01168]]]]} | Open Access 1 | 724 | San Elijo Lagoon Ecological Reserve | 24878 | 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 | http://www.sdparks.org/content/sdparks/en/park-pages/SanElijo.html | San Diego 4 | 12.338 | San Elijo Lagoon ER | 1983 | Local Conservation Area 4 | 2 |
7095 | 7095 | 7094 | {"type": "Polygon", "coordinates": [[[-117.267, 33.04596], [-117.26684, 33.046], [-117.2666, 33.04603], [-117.26623, 33.04604], [-117.26454, 33.04597], [-117.26402, 33.04593], [-117.26407, 33.04381], [-117.26554, 33.04382], [-117.26554, 33.04419], [-117.26595, 33.0442], [-117.267, 33.04596]]]} | Open Access 1 | 6161 | Oakcrest Park | 23021 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Parks | San Diego 4 | 12.712 | Oakcrest Park | 0 | Local Park 2 | 4 |
7109 | 7109 | 7108 | {"type": "MultiPolygon", "coordinates": [[[[-116.88462, 32.91635], [-116.88184, 32.91632], [-116.88177, 32.91164], [-116.88174, 32.91156], [-116.88176, 32.9108], [-116.88173, 32.90896], [-116.88411, 32.90898], [-116.88487, 32.91321], [-116.88487, 32.91346], [-116.88462, 32.91635]]], [[[-116.90743, 32.91287], [-116.90741, 32.91652], [-116.90314, 32.91651], [-116.90316, 32.92005], [-116.89739, 32.92002], [-116.89018, 32.92002], [-116.89019, 32.91943], [-116.88957, 32.91944], [-116.88966, 32.91642], [-116.88483, 32.91635], [-116.88507, 32.91354], [-116.88507, 32.91322], [-116.88501, 32.91285], [-116.88481, 32.91175], [-116.89029, 32.91174], [-116.89031, 32.90899], [-116.89462, 32.90904], [-116.8947, 32.91274], [-116.90743, 32.91287]]]]} | Open Access 1 | 6185 | Oakoasis Preserve | 29250 | 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 | http://www.sdparks.org/content/sdparks/en/park-pages/Oakoasis.html | San Diego 4 | 443.34 | Oakoasis Preserve | 0 | Local Conservation Area 4 | 2 |
7317 | 7317 | 7316 | {"type": "Polygon", "coordinates": [[[-117.16715, 33.33888], [-117.16588, 33.3392], [-117.16534, 33.33971], [-117.16475, 33.33998], [-117.16499, 33.33744], [-117.16645, 33.33732], [-117.16704, 33.33813], [-117.16715, 33.33888]]]} | Open Access 1 | 7212 | Engel Family Preserve | 18674 | 3022 | Fallbrook Land Conservancy 339 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.fallbrooklandconservancy.org/ | Non Governmental Organization 10 | 3022 | Fallbrook Land Conservancy 336 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.fallbrooklandconservancy.org/engel-preserve.html | San Diego 4 | 10.291 | Engel Family Preserve | 0 | Private Conservation 16 | 2 |
7319 | 7319 | 7318 | {"type": "MultiPolygon", "coordinates": [[[[-117.22972, 32.75044], [-117.22933, 32.75092], [-117.22933, 32.75147], [-117.22929, 32.75241], [-117.22709, 32.75259], [-117.22689, 32.7514], [-117.2268, 32.75068], [-117.22908, 32.74803], [-117.2293, 32.74816], [-117.22931, 32.7482], [-117.22952, 32.74831], [-117.22953, 32.74875], [-117.22969, 32.74886], [-117.22965, 32.74889], [-117.22954, 32.74882], [-117.22953, 32.74883], [-117.22955, 32.74986], [-117.22966, 32.74994], [-117.22963, 32.74997], [-117.22955, 32.74993], [-117.22954, 32.74994], [-117.22955, 32.75033], [-117.22972, 32.75044]]], [[[-117.22998, 32.75264], [-117.22997, 32.75307], [-117.22992, 32.75379], [-117.22997, 32.75424], [-117.22993, 32.75452], [-117.2298, 32.75482], [-117.22947, 32.75521], [-117.22925, 32.75543], [-117.22921, 32.75552], [-117.22922, 32.75562], [-117.22935, 32.75583], [-117.22945, 32.75616], [-117.227, 32.7566], [-117.2278, 32.75561], [-117.22787, 32.75564], [-117.22917, 32.7541], [-117.22904, 32.75271], [-117.22998, 32.75264]]]]} | Open Access 1 | 47586 | Famosa Slough Wildlife Reserve | 31313 | 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 | https://www.sandiego.gov/park-and-recreation/parks/regional/missionbay/mbtour1#Famosa | San Diego 4 | 33.351 | Famosa Slough Wildlife Reserve | 0 | Local Conservation Area 4 | 2 |
7361 | 7361 | 7360 | {"type": "Polygon", "coordinates": [[[-116.80495, 32.6658], [-116.7972, 32.66593], [-116.79691, 32.66573], [-116.79678, 32.66565], [-116.79554, 32.66464], [-116.7957, 32.65742], [-116.78827, 32.65749], [-116.78821, 32.65701], [-116.77957, 32.65689], [-116.77935, 32.64654], [-116.78382, 32.64644], [-116.78381, 32.64588], [-116.78409, 32.64598], [-116.78439, 32.64605], [-116.78463, 32.64607], [-116.78512, 32.64609], [-116.7853, 32.64611], [-116.78551, 32.64618], [-116.78574, 32.64629], [-116.78584, 32.64636], [-116.78591, 32.64644], [-116.78597, 32.64653], [-116.786, 32.64664], [-116.78603, 32.64794], [-116.78609, 32.64813], [-116.78635, 32.64851], [-116.78641, 32.64863], [-116.78641, 32.64876], [-116.78636, 32.64911], [-116.78634, 32.64918], [-116.78636, 32.64927], [-116.78685, 32.65008], [-116.78694, 32.65019], [-116.78706, 32.65029], [-116.78722, 32.65038], [-116.7874, 32.65043], [-116.78819, 32.65052], [-116.78833, 32.65059], [-116.78845, 32.65071], [-116.7885, 32.65082], [-116.78869, 32.65163], [-116.7887, 32.65178], [-116.78869, 32.65209], [-116.78872, 32.65231], [-116.78884, 32.65264], [-116.78898, 32.65285], [-116.78902, 32.65304], [-116.78907, 32.65314], [-116.78921, 32.65323], [-116.78954, 32.65329], [-116.78969, 32.65328], [-116.78976, 32.65325], [-116.78984, 32.6532], [-116.79019, 32.65284], [-116.79056, 32.65268], [-116.7907, 32.65263], [-116.79084, 32.65261], [-116.791, 32.65262], [-116.79115, 32.65265], [-116.79157, 32.6528], [-116.79173, 32.6529], [-116.79181, 32.65303], [-116.79189, 32.65332], [-116.79204, 32.65374], [-116.79201, 32.65377], [-116.79204, 32.65382], [-116.79217, 32.65396], [-116.79232, 32.65409], [-116.79251, 32.6542], [-116.7927, 32.65427], [-116.79413, 32.65454], [-116.79453, 32.65443], [-116.79454, 32.65439], [-116.79458, 32.65438], [-116.79479, 32.65439], [-116.79609, 32.65457], [-116.79742, 32.65446], [-116.79772, 32.65438], [-116.798, 32.65424], [-116.79813, 32.65414], [-116.7988, 32.65358], [-116.79906, 32.65342], [-116.79963, 32.65313], [-116.79982, 32.65306], [-116.80012, 32.65298], [-116.80041, 32.65296], [-116.80065, 32.65297], [-116.8009, 32.65301], [-116.80291, 32.6536], [-116.80322, 32.65367], [-116.80397, 32.6538], [-116.80484, 32.65407], [-116.80495, 32.6658]]]} | No Public Access 3 | 47588 | Lawrence and Barbara Daley Preserve | 31315 | 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 | 580.873 | Lawrence and Barbara Daley Preserve | 0 | Local Conservation Area 4 | 2 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);