terns[1, 2][1] "PITTSBURG POWER PLANT"15 Indexing
NoteLearning Goals
After this lesson, you should be able to:
- Select the columns of a data frame
- Describe when to use
[versus[[ - Filter the rows of a data frame
- Negate or combine conditions with logic operators
ImportantRequired Packages
This chapter uses the following packages:
- dplyr
Chapter 14 explains how to install and load packages.
Indexing refers to getting and setting the elements of a data structure. Indexing is a fundamental operation in R, key to reasoning about how to solve problems with the language. For tabular data, two kinds of indexing—selecting columns and filtering rows—are the foundation upon which all analyses rest. This chapter is an introduction to R’s many operators and functions for indexing.
15.1 More Than One Dimension
Section 13.1.2 introduced the indexing (or square bracket) operator [ as a way to get and set the elements of a vector. You can also use the indexing operator with many other data structures, such as data frames, lists, matrices, and arrays.
Consider data frames. A data frame is two-dimensional: it has rows and columns. In order to describe the exact position of an element in a data frame, we need to specify both a row index and a column index. You can still use the indexing operator [ to get and set elements, but now it takes two arguments:
DATA[ROW_INDEXES, COLUMN_INDEXES]For example, to get the value at row 1 and column 2 in the California least terns data (Section 11.4), you can write:
If you swap the order of the indexes, you get the value at row 2 and column 1 instead:
terns[2, 1][1] 2000As with indexing vectors, when indexing a data frame you can also:
- Use a vector as an index to get multiple elements.
- Leave an index blank to get everything in that dimension.
- Use negative indexes to omit rows or columns.
- Combine indexing with assignment to set elements.
Let’s look at examples of the first two. Suppose we want to get elements from multiple rows and columns. Here’s the code to get elements from the first 3 rows in columns 2 and 7 of the least terns data:
terns[1:3, c(2, 7)] site_name region_4
1 PITTSBURG POWER PLANT S.F._BAY
2 ALBANY CENTRAL AVE S.F._BAY
3 ALAMEDA POINT S.F._BAYNow suppose we want to get the elements from rows 3, 5, and 7 in all columns. Then you can write:
terns[c(3, 5, 7), ] year site_name
3 2000 ALAMEDA POINT
5 2000 OCEANO DUNES STATE VEHICULAR RECREATION AREA
7 2000 VANDENBERG SFB
site_name_2013_2018 site_name_1988_2001
3 Alameda Point NA_2013_2018 POLYGON
5 Oceano Dunes State Vehicular Recreation Area NA_2013_2018 POLYGON
7 Vandenberg AFB NA_2013_2018 POLYGON
site_abbr region_3 region_4 event bp_min bp_max fl_min fl_max
3 ALAM_PT S.F._BAY S.F._BAY LA_NINA 282 301 200 230
5 OCEANO_DUNES CENTRAL CENTRAL LA_NINA 4 5 4 4
7 VAN_SFB CENTRAL CENTRAL LA_NINA 30 32 11 11
total_nests nonpred_eggs nonpred_chicks nonpred_fl nonpred_ad pred_control
3 312 124 81 2 1
5 5 2 0 0 0
7 32 NA 27 0 0
pred_eggs pred_chicks pred_fl pred_ad pred_pefa pred_coy_fox pred_meso
3 17 0 0 0 N N N
5 0 4 0 0 N N N
7 0 3 0 0 N N N
pred_owlspp pred_corvid pred_other_raptor pred_other_avian pred_misc
3 N N Y Y N
5 N N N Y N
7 N N Y N N
total_pefa total_coy_fox total_meso total_owlspp total_corvid
3 0 0 0 0 0
5 0 0 0 0 0
7 0 0 0 0 0
total_other_raptor total_other_avian total_misc first_observed last_observed
3 6 11 0 2000-05-01 2000-08-19
5 0 4 0 2000-05-04 2000-08-30
7 3 0 0 2000-05-07 2000-08-17
first_nest first_chick first_fledge
3 2000-05-16 2000-06-07 2000-06-30
5 2000-05-28 2000-06-20 2000-07-13
7 2000-05-28 2000-06-20 2000-07-15By leaving the column index blank, you’re telling R to select all of the columns. Likewise, you can leave the row index blank to select all of the rows.
Note
You can also use the indexing operator [ with data structures that have more than two dimensons. Maybe you can guess the syntax:
DATA[DIM1_INDEXES, DIM2_INDEXES, DIM3_INDEXES, ...]You won’t encounter any data structures with more than two dimensions in this course, but you might someday.
15.2 Selecting Columns
In order to work with tabular data, you need to know how to select (or get) columns. Most of the time, it’s best to select columns by name. Doing so makes code easier to understand, since the reader doesn’t have to memorize the positions of the columns. It can also make code more reliable, since the code will still work even if the positions of the columns change.
This section explains several different ways to select columns and how to choose which one to use in any given situation. Generally, the first thing to think about is whether you want to select just one column or multiple columns.
15.2.1 One Column
The dollar sign operator $, introduced in Section 12.9, is one way to select a single column from a data frame. For example, to select the total_nests column from the least terns dataset:
terns$total_nests [1] 15 20 312 3 5 9 32 22 73 252 308 565 107 56 481
[16] 68 1079 172 16 187 26 420 27 134 629 34 0 44 210 15
[31] 0 440 2 63 8 1 6 83 50 29 617 17 1071 206 229
[46] 323 5 89 1430 592 0 315 17 299 42 76 172 1035 1 111
[61] 66 49 520 4 550 8 1 59 4 44 0 9 27 608 90
[76] 1332 145 135 339 28 1664 596 1 6 0 281 118 157 134 1135
[91] 101 57 34 458 17 0 441 15 2 38 0 2 5 NA 53
[106] 469 384 907 186 222 521 36 1540 627 0 104 30 120 136 14
[121] 131 180 1425 100 15 82 371 2 32 7 394 35 6 2 66
[136] 1 18 6 77 1 52 431 546 710 166 226 485 9 42 1530
[151] 594 0 28 39 105 45 30 135 123 1162 130 46 97 291 1
[166] 18 35 1 336 62 2 1 56 0 18 1 97 24 81 506
[181] 928 529 206 242 454 10 25 1665 610 0 0 10 14 1 1
[196] 139 146 1525 148 33 102 201 1 52 27 0 346 80 1 1
[211] 26 3 31 0 85 4 44 628 295 435 177 317 434 16 10
[226] 1718 649 0 2 38 45 14 0 0 145 125 1741 132 48 78
[241] 294 3 1 47 17 0 320 53 0 1 23 1 34 0 36
[256] 1 48 708 164 216 265 446 433 8 13 1722 480 0 0 0
[271] 17 25 117 1 9 116 84 1115 119 40 65 223 1 38 15
[286] 0 355 77 0 0 35 0 32 1 26 0 60 717 28 10
[301] 177 167 712 14 6 1526 532 0 NA 0 21 1 145 12 13
[316] 78 83 1062 116 53 55 264 3 2 35 30 3 382 189 0
[331] 0 46 0 18 0 42 1 6 844 14 211 121 305 542 11
[346] 20 1245 563 0 0 0 49 1 142 17 12 130 10 1068 114
[361] 64 90 283 0 0 80 29 0 292 85 0 0 57 0 15
[376] 0 37 209 7 346 0 15 254 164 157 347 23 32 1243 558
[391] 0 0 3 156 0 37 41 0 114 7 1034 144 79 45 282
[406] 2 0 45 16 0 326 85 0 0 49 0 21 0 4 120
[421] 22 465 0 81 126 154 301 516 18 2 1337 478 0 0 0
[436] 8 13 119 2 0 100 57 1039 148 87 35 261 3 1 79
[451] 16 3 351 71 0 0 54 0 22 0 72 24 0 473 0
[466] 8 109 106 204 524 23 22 1384 415 0 0 0 20 24 181
[481] 1 0 18 33 826 123 79 29 208 1 1 79 6 1 403
[496] 88 0 0 49 0 27 0 62 0 18 361 0 2 141 80
[511] 142 348 4 10 20 897 451 0 0 0 50 25 127 15 5
[526] 37 34 859 118 76 26 184 0 1 142 9 NA 447 72 21
[541] 0 52 0 0 28 0 9 0 38 377 0 0 31 5 124
[556] 178 679 0 14 17 1405 692 0 NA 0 41 0 176 2 NA
[571] 24 22 889 127 96 40 225 0 28 18 375 32 141 35 83
[586] 24 0 84 291 0 5 6 133 117 133 688 16 22 334 684
[601] 0 12 1 178 11 19 16 827 109 83 33 191 3 15 345
[616] 56 121 34 17 47 NA 0 92 315 0 6 0 199 56 134
[631] 531 17 20 418 548 0 39 2 159 1 19 4 928 104 66
[646] 39 150 3 29 435 101 1 48 56 12 39 21 23 205 NA
[661] 46 0 182 11 91 429 14 18 375 139 0 37 1 158 0
[676] 6 6 1153 62 126 45 203 3 79 23 420 113 56 53 0
[691] 34 91 0 27 173 NA 37 0 198 51 168 563 20 10 628
[706] 297 0 75 1 133 0 11 2 1140 108 101 36 186 54 78
[721] 7 425 61 45 45 1 45 51 26 34 313 3 0 189 56
[736] 172 393 19 2 474 254 0 29 98 0 107 0 10 0 805
[751] 77 82 24 151 46 9 31 339 144 77 42 0 42 30 0
[766] 19 188 0 0 56 71 114 290 1 9 4 552 228 0 47
[781] 156 1 6 0 8 0 717 44 59 48 171The dollar sign operator always selects the column by name (not position).
Another way to select a single column is with the extraction operator [[ (also called the double square bracket operator). The column name must be quoted and goes inside the brackets. For instance:
terns[["total_nests"]] [1] 15 20 312 3 5 9 32 22 73 252 308 565 107 56 481
[16] 68 1079 172 16 187 26 420 27 134 629 34 0 44 210 15
[31] 0 440 2 63 8 1 6 83 50 29 617 17 1071 206 229
[46] 323 5 89 1430 592 0 315 17 299 42 76 172 1035 1 111
[61] 66 49 520 4 550 8 1 59 4 44 0 9 27 608 90
[76] 1332 145 135 339 28 1664 596 1 6 0 281 118 157 134 1135
[91] 101 57 34 458 17 0 441 15 2 38 0 2 5 NA 53
[106] 469 384 907 186 222 521 36 1540 627 0 104 30 120 136 14
[121] 131 180 1425 100 15 82 371 2 32 7 394 35 6 2 66
[136] 1 18 6 77 1 52 431 546 710 166 226 485 9 42 1530
[151] 594 0 28 39 105 45 30 135 123 1162 130 46 97 291 1
[166] 18 35 1 336 62 2 1 56 0 18 1 97 24 81 506
[181] 928 529 206 242 454 10 25 1665 610 0 0 10 14 1 1
[196] 139 146 1525 148 33 102 201 1 52 27 0 346 80 1 1
[211] 26 3 31 0 85 4 44 628 295 435 177 317 434 16 10
[226] 1718 649 0 2 38 45 14 0 0 145 125 1741 132 48 78
[241] 294 3 1 47 17 0 320 53 0 1 23 1 34 0 36
[256] 1 48 708 164 216 265 446 433 8 13 1722 480 0 0 0
[271] 17 25 117 1 9 116 84 1115 119 40 65 223 1 38 15
[286] 0 355 77 0 0 35 0 32 1 26 0 60 717 28 10
[301] 177 167 712 14 6 1526 532 0 NA 0 21 1 145 12 13
[316] 78 83 1062 116 53 55 264 3 2 35 30 3 382 189 0
[331] 0 46 0 18 0 42 1 6 844 14 211 121 305 542 11
[346] 20 1245 563 0 0 0 49 1 142 17 12 130 10 1068 114
[361] 64 90 283 0 0 80 29 0 292 85 0 0 57 0 15
[376] 0 37 209 7 346 0 15 254 164 157 347 23 32 1243 558
[391] 0 0 3 156 0 37 41 0 114 7 1034 144 79 45 282
[406] 2 0 45 16 0 326 85 0 0 49 0 21 0 4 120
[421] 22 465 0 81 126 154 301 516 18 2 1337 478 0 0 0
[436] 8 13 119 2 0 100 57 1039 148 87 35 261 3 1 79
[451] 16 3 351 71 0 0 54 0 22 0 72 24 0 473 0
[466] 8 109 106 204 524 23 22 1384 415 0 0 0 20 24 181
[481] 1 0 18 33 826 123 79 29 208 1 1 79 6 1 403
[496] 88 0 0 49 0 27 0 62 0 18 361 0 2 141 80
[511] 142 348 4 10 20 897 451 0 0 0 50 25 127 15 5
[526] 37 34 859 118 76 26 184 0 1 142 9 NA 447 72 21
[541] 0 52 0 0 28 0 9 0 38 377 0 0 31 5 124
[556] 178 679 0 14 17 1405 692 0 NA 0 41 0 176 2 NA
[571] 24 22 889 127 96 40 225 0 28 18 375 32 141 35 83
[586] 24 0 84 291 0 5 6 133 117 133 688 16 22 334 684
[601] 0 12 1 178 11 19 16 827 109 83 33 191 3 15 345
[616] 56 121 34 17 47 NA 0 92 315 0 6 0 199 56 134
[631] 531 17 20 418 548 0 39 2 159 1 19 4 928 104 66
[646] 39 150 3 29 435 101 1 48 56 12 39 21 23 205 NA
[661] 46 0 182 11 91 429 14 18 375 139 0 37 1 158 0
[676] 6 6 1153 62 126 45 203 3 79 23 420 113 56 53 0
[691] 34 91 0 27 173 NA 37 0 198 51 168 563 20 10 628
[706] 297 0 75 1 133 0 11 2 1140 108 101 36 186 54 78
[721] 7 425 61 45 45 1 45 51 26 34 313 3 0 189 56
[736] 172 393 19 2 474 254 0 29 98 0 107 0 10 0 805
[751] 77 82 24 151 46 9 31 339 144 77 42 0 42 30 0
[766] 19 188 0 0 56 71 114 290 1 9 4 552 228 0 47
[781] 156 1 6 0 8 0 717 44 59 48 171The double square bracket operator is helpful if you want to select a column with a name you’ve stored in a variable:
my_column = "site_name"
terns[[my_column]] [1] "PITTSBURG POWER PLANT"
[2] "ALBANY CENTRAL AVE"
[3] "ALAMEDA POINT"
[4] "KETTLEMAN CITY"
[5] "OCEANO DUNES STATE VEHICULAR RECREATION AREA"
[6] "RANCHO GUADALUPE DUNES PRESERVE"
[7] "VANDENBERG SFB"
[8] "SANTA CLARA RIVER MCGRATH STATE BEACH"
[9] "ORMOND BEACH"
[10] "NBVC POINT MUGU"
[11] "VENICE BEACH"
[12] "LA HARBOR"
[13] "SEAL BEACH NWR ANAHEIM BAY"
[14] "BOLSA CHICA ECOLOGICAL RESERVE"
[15] "HUNTINGTON STATE BEACH"
[16] "UPPER NEWPORT BAY ECOLOGICAL RESERVE"
[17] "MCB CAMP PENDLETON"
[18] "BATIQUITOS LAGOON ECOLOGICAL RESERVE"
[19] "SAN ELIJO LAGOON ECOLOGICAL RESERVE"
[20] "MISSION BAY FAA ISLAND"
[21] "MISSION BAY NORTH FIESTA ISLAND"
[22] "MISSION BAY MARINERS POINT"
[23] "SDIA LINDBERGH FIELD"
[24] "NAS NORTH ISLAND"
[25] "NAVAL AMPHIBIOUS BASE CORONADO"
[26] "DSTREET FILL SWEETWATER MARSH NWR"
[27] "CHULA VISTA WILDLIFE RESERVE"
[28] "SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS"
[29] "TIJUANA ESTUARY NERR"
[30] "PITTSBURG POWER PLANT"
[31] "ALBANY CENTRAL AVE"
[32] "ALAMEDA POINT"
[33] "KETTLEMAN CITY"
[34] "OCEANO DUNES STATE VEHICULAR RECREATION AREA"
[35] "RANCHO GUADALUPE DUNES PRESERVE"
[36] "VANDENBERG SFB"
[37] "COAL OIL POINT RESERVE"
[38] "SANTA CLARA RIVER MCGRATH STATE BEACH"
[39] "HOLLYWOOD BEACH"
[40] "ORMOND BEACH"
[41] "NBVC POINT MUGU"
[42] "VENICE BEACH"
[43] "LA HARBOR"
[44] "SEAL BEACH NWR ANAHEIM BAY"
[45] "BOLSA CHICA ECOLOGICAL RESERVE"
[46] "HUNTINGTON STATE BEACH"
[47] "BURRIS ISLAND"
[48] "UPPER NEWPORT BAY ECOLOGICAL RESERVE"
[49] "MCB CAMP PENDLETON"
[50] "BATIQUITOS LAGOON ECOLOGICAL RESERVE"
[51] "SAN ELIJO LAGOON ECOLOGICAL RESERVE"
[52] "MISSION BAY FAA ISLAND"
[53] "MISSION BAY NORTH FIESTA ISLAND"
[54] "MISSION BAY MARINERS POINT"
[55] "MISSION BAY SAN DIEGO RIVER MOUTH"
[56] "SDIA LINDBERGH FIELD"
[57] "NAS NORTH ISLAND"
[58] "NAVAL AMPHIBIOUS BASE CORONADO"
[59] "SILVER STRAND STATE BEACH"
[60] "DSTREET FILL SWEETWATER MARSH NWR"
[61] "CHULA VISTA WILDLIFE RESERVE"
[62] "SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS"
[63] "TIJUANA ESTUARY NERR"
[64] "PITTSBURG POWER PLANT"
[65] "ALAMEDA POINT"
[66] "HAYWARD REGIONAL SHORELINE"
[67] "KETTLEMAN CITY"
[68] "OCEANO DUNES STATE VEHICULAR RECREATION AREA"
[69] "RANCHO GUADALUPE DUNES PRESERVE"
[70] "VANDENBERG SFB"
[71] "COAL OIL POINT RESERVE"
[72] "SANTA CLARA RIVER MCGRATH STATE BEACH"
[73] "ORMOND BEACH"
[74] "NBVC POINT MUGU"
[75] "VENICE BEACH"
[76] "LA HARBOR"
[77] "SEAL BEACH NWR ANAHEIM BAY"
[78] "BOLSA CHICA ECOLOGICAL RESERVE"
[79] "HUNTINGTON STATE BEACH"
[80] "UPPER NEWPORT BAY ECOLOGICAL RESERVE"
[81] "MCB CAMP PENDLETON"
[82] "BATIQUITOS LAGOON ECOLOGICAL RESERVE"
[83] "SAN ELIJO LAGOON ECOLOGICAL RESERVE"
[84] "MISSION BAY FAA ISLAND"
[85] "MISSION BAY NORTH FIESTA ISLAND"
[86] "MISSION BAY MARINERS POINT"
[87] "MISSION BAY SAN DIEGO RIVER MOUTH"
[88] "SDIA LINDBERGH FIELD"
[89] "NAS NORTH ISLAND"
[90] "NAVAL AMPHIBIOUS BASE CORONADO"
[91] "DSTREET FILL SWEETWATER MARSH NWR"
[92] "CHULA VISTA WILDLIFE RESERVE"
[93] "SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS"
[94] "TIJUANA ESTUARY NERR"
[95] "MONTEZUMA WETLANDS"
[96] "PITTSBURG POWER PLANT"
[97] "ALAMEDA POINT"
[98] "HAYWARD REGIONAL SHORELINE"
[99] "KETTLEMAN CITY"
[100] "OCEANO DUNES STATE VEHICULAR RECREATION AREA"
[101] "RANCHO GUADALUPE DUNES PRESERVE"
[102] "VANDENBERG SFB"
[103] "COAL OIL POINT RESERVE"
[104] "SANTA CLARA RIVER MCGRATH STATE BEACH"
[105] "ORMOND BEACH"
[106] "NBVC POINT MUGU"
[107] "VENICE BEACH"
[108] "LA HARBOR"
[109] "SEAL BEACH NWR ANAHEIM BAY"
[110] "BOLSA CHICA ECOLOGICAL RESERVE"
[111] "HUNTINGTON STATE BEACH"
[112] "UPPER NEWPORT BAY ECOLOGICAL RESERVE"
[113] "MCB CAMP PENDLETON"
[114] "BATIQUITOS LAGOON ECOLOGICAL RESERVE"
[115] "SAN ELIJO LAGOON ECOLOGICAL RESERVE"
[116] "MISSION BAY FAA ISLAND"
[117] "MISSION BAY NORTH FIESTA ISLAND"
[118] "MISSION BAY MARINERS POINT"
[119] "MISSION BAY STONY POINT"
[120] "MISSION BAY SAN DIEGO RIVER MOUTH"
[121] "SDIA LINDBERGH FIELD"
[122] "NAS NORTH ISLAND"
[123] "NAVAL AMPHIBIOUS BASE CORONADO"
[124] "DSTREET FILL SWEETWATER MARSH NWR"
[125] "CHULA VISTA WILDLIFE RESERVE"
[126] "SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS"
[127] "TIJUANA ESTUARY NERR"
[128] "NAPA SONOMA MARSH WILDLIFE AREA"
[129] "MONTEZUMA WETLANDS"
[130] "PITTSBURG POWER PLANT"
[131] "ALAMEDA POINT"
[132] "HAYWARD REGIONAL SHORELINE"
[133] "EDEN LANDING ECOLOGICAL RESERVE"
[134] "KETTLEMAN CITY"
[135] "OCEANO DUNES STATE VEHICULAR RECREATION AREA"
[136] "RANCHO GUADALUPE DUNES PRESERVE"
[137] "VANDENBERG SFB"
[138] "COAL OIL POINT RESERVE"
[139] "SANTA CLARA RIVER MCGRATH STATE BEACH"
[140] "HOLLYWOOD BEACH"
[141] "ORMOND BEACH"
[142] "NBVC POINT MUGU"
[143] "VENICE BEACH"
[144] "LA HARBOR"
[145] "SEAL BEACH NWR ANAHEIM BAY"
[146] "BOLSA CHICA ECOLOGICAL RESERVE"
[147] "HUNTINGTON STATE BEACH"
[148] "BURRIS ISLAND"
[149] "UPPER NEWPORT BAY ECOLOGICAL RESERVE"
[150] "MCB CAMP PENDLETON"
[151] "BATIQUITOS LAGOON ECOLOGICAL RESERVE"
[152] "SAN ELIJO LAGOON ECOLOGICAL RESERVE"
[153] "MISSION BAY FAA ISLAND"
[154] "MISSION BAY NORTH FIESTA ISLAND"
[155] "MISSION BAY MARINERS POINT"
[156] "MISSION BAY STONY POINT"
[157] "MISSION BAY SAN DIEGO RIVER MOUTH"
[158] "SDIA LINDBERGH FIELD"
[159] "NAS NORTH ISLAND"
[160] "NAVAL AMPHIBIOUS BASE CORONADO"
[161] "DSTREET FILL SWEETWATER MARSH NWR"
[162] "CHULA VISTA WILDLIFE RESERVE"
[163] "SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS"
[164] "TIJUANA ESTUARY NERR"
[165] "SACRAMENTO BUFFERLANDS"
[166] "NAPA SONOMA MARSH WILDLIFE AREA"
[167] "MONTEZUMA WETLANDS"
[168] "PITTSBURG POWER PLANT"
[169] "ALAMEDA POINT"
[170] "HAYWARD REGIONAL SHORELINE"
[171] "EDEN LANDING ECOLOGICAL RESERVE"
[172] "KETTLEMAN CITY"
[173] "OCEANO DUNES STATE VEHICULAR RECREATION AREA"
[174] "RANCHO GUADALUPE DUNES PRESERVE"
[175] "VANDENBERG SFB"
[176] "COAL OIL POINT RESERVE"
[177] "SANTA CLARA RIVER MCGRATH STATE BEACH"
[178] "HOLLYWOOD BEACH"
[179] "ORMOND BEACH"
[180] "NBVC POINT MUGU"
[181] "VENICE BEACH"
[182] "LA HARBOR"
[183] "SEAL BEACH NWR ANAHEIM BAY"
[184] "BOLSA CHICA ECOLOGICAL RESERVE"
[185] "HUNTINGTON STATE BEACH"
[186] "BURRIS ISLAND"
[187] "UPPER NEWPORT BAY ECOLOGICAL RESERVE"
[188] "MCB CAMP PENDLETON"
[189] "BATIQUITOS LAGOON ECOLOGICAL RESERVE"
[190] "SAN ELIJO LAGOON ECOLOGICAL RESERVE"
[191] "MISSION BAY FAA ISLAND"
[192] "MISSION BAY NORTH FIESTA ISLAND"
[193] "MISSION BAY MARINERS POINT"
[194] "MISSION BAY STONY POINT"
[195] "MISSION BAY SAN DIEGO RIVER MOUTH"
[196] "SDIA LINDBERGH FIELD"
[197] "NAS NORTH ISLAND"
[198] "NAVAL AMPHIBIOUS BASE CORONADO"
[199] "DSTREET FILL SWEETWATER MARSH NWR"
[200] "CHULA VISTA WILDLIFE RESERVE"
[201] "SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS"
[202] "TIJUANA ESTUARY NERR"
[203] "SACRAMENTO BUFFERLANDS"
[204] "NAPA SONOMA MARSH WILDLIFE AREA"
[205] "MONTEZUMA WETLANDS"
[206] "PITTSBURG POWER PLANT"
[207] "ALAMEDA POINT"
[208] "HAYWARD REGIONAL SHORELINE"
[209] "EDEN LANDING ECOLOGICAL RESERVE"
[210] "KETTLEMAN CITY"
[211] "OCEANO DUNES STATE VEHICULAR RECREATION AREA"
[212] "RANCHO GUADALUPE DUNES PRESERVE"
[213] "VANDENBERG SFB"
[214] "COAL OIL POINT RESERVE"
[215] "SANTA CLARA RIVER MCGRATH STATE BEACH"
[216] "HOLLYWOOD BEACH"
[217] "ORMOND BEACH"
[218] "NBVC POINT MUGU"
[219] "VENICE BEACH"
[220] "LA HARBOR"
[221] "SEAL BEACH NWR ANAHEIM BAY"
[222] "BOLSA CHICA ECOLOGICAL RESERVE"
[223] "HUNTINGTON STATE BEACH"
[224] "BURRIS ISLAND"
[225] "UPPER NEWPORT BAY ECOLOGICAL RESERVE"
[226] "MCB CAMP PENDLETON"
[227] "BATIQUITOS LAGOON ECOLOGICAL RESERVE"
[228] "SAN ELIJO LAGOON ECOLOGICAL RESERVE"
[229] "FAIRBANKS RANCH"
[230] "MISSION BAY FAA ISLAND"
[231] "MISSION BAY NORTH FIESTA ISLAND"
[232] "MISSION BAY MARINERS POINT"
[233] "MISSION BAY STONY POINT"
[234] "MISSION BAY SAN DIEGO RIVER MOUTH"
[235] "SDIA LINDBERGH FIELD"
[236] "NAS NORTH ISLAND"
[237] "NAVAL AMPHIBIOUS BASE CORONADO"
[238] "DSTREET FILL SWEETWATER MARSH NWR"
[239] "CHULA VISTA WILDLIFE RESERVE"
[240] "SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS"
[241] "TIJUANA ESTUARY NERR"
[242] "ARIZONA GLENDALE"
[243] "SACRAMENTO BUFFERLANDS"
[244] "NAPA SONOMA MARSH WILDLIFE AREA"
[245] "MONTEZUMA WETLANDS"
[246] "PITTSBURG POWER PLANT"
[247] "ALAMEDA POINT"
[248] "HAYWARD REGIONAL SHORELINE"
[249] "EDEN LANDING ECOLOGICAL RESERVE"
[250] "KETTLEMAN CITY"
[251] "OCEANO DUNES STATE VEHICULAR RECREATION AREA"
[252] "RANCHO GUADALUPE DUNES PRESERVE"
[253] "VANDENBERG SFB"
[254] "COAL OIL POINT RESERVE"
[255] "SANTA CLARA RIVER MCGRATH STATE BEACH"
[256] "HOLLYWOOD BEACH"
[257] "ORMOND BEACH"
[258] "NBVC POINT MUGU"
[259] "VENICE BEACH"
[260] "LA HARBOR"
[261] "SEAL BEACH NWR ANAHEIM BAY"
[262] "BOLSA CHICA ECOLOGICAL RESERVE"
[263] "HUNTINGTON STATE BEACH"
[264] "BURRIS ISLAND"
[265] "UPPER NEWPORT BAY ECOLOGICAL RESERVE"
[266] "MCB CAMP PENDLETON"
[267] "BATIQUITOS LAGOON ECOLOGICAL RESERVE"
[268] "SAN ELIJO LAGOON ECOLOGICAL RESERVE"
[269] "FAIRBANKS RANCH"
[270] "SAN DIEGUITO LAGOON ECOLOGICAL RESERVE"
[271] "MISSION BAY FAA ISLAND"
[272] "MISSION BAY NORTH FIESTA ISLAND"
[273] "MISSION BAY MARINERS POINT"
[274] "MISSION BAY STONY POINT"
[275] "MISSION BAY SAN DIEGO RIVER MOUTH"
[276] "SDIA LINDBERGH FIELD"
[277] "NAS NORTH ISLAND"
[278] "NAVAL AMPHIBIOUS BASE CORONADO"
[279] "DSTREET FILL SWEETWATER MARSH NWR"
[280] "CHULA VISTA WILDLIFE RESERVE"
[281] "SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS"
[282] "TIJUANA ESTUARY NERR"
[283] "SACRAMENTO BUFFERLANDS"
[284] "NAPA SONOMA MARSH WILDLIFE AREA"
[285] "MONTEZUMA WETLANDS"
[286] "PITTSBURG POWER PLANT"
[287] "ALAMEDA POINT"
[288] "HAYWARD REGIONAL SHORELINE"
[289] "EDEN LANDING ECOLOGICAL RESERVE"
[290] "KETTLEMAN CITY"
[291] "OCEANO DUNES STATE VEHICULAR RECREATION AREA"
[292] "RANCHO GUADALUPE DUNES PRESERVE"
[293] "VANDENBERG SFB"
[294] "COAL OIL POINT RESERVE"
[295] "SANTA CLARA RIVER MCGRATH STATE BEACH"
[296] "HOLLYWOOD BEACH"
[297] "ORMOND BEACH"
[298] "NBVC POINT MUGU"
[299] "VENICE BEACH"
[300] "LA HARBOR"
[301] "SEAL BEACH NWR ANAHEIM BAY"
[302] "BOLSA CHICA ECOLOGICAL RESERVE"
[303] "HUNTINGTON STATE BEACH"
[304] "BURRIS ISLAND"
[305] "UPPER NEWPORT BAY ECOLOGICAL RESERVE"
[306] "MCB CAMP PENDLETON"
[307] "BATIQUITOS LAGOON ECOLOGICAL RESERVE"
[308] "SAN ELIJO LAGOON ECOLOGICAL RESERVE"
[309] "FAIRBANKS RANCH"
[310] "SAN DIEGUITO LAGOON ECOLOGICAL RESERVE"
[311] "MISSION BAY FAA ISLAND"
[312] "MISSION BAY NORTH FIESTA ISLAND"
[313] "MISSION BAY MARINERS POINT"
[314] "MISSION BAY STONY POINT"
[315] "MISSION BAY SAN DIEGO RIVER MOUTH"
[316] "SDIA LINDBERGH FIELD"
[317] "NAS NORTH ISLAND"
[318] "NAVAL AMPHIBIOUS BASE CORONADO"
[319] "DSTREET FILL SWEETWATER MARSH NWR"
[320] "CHULA VISTA WILDLIFE RESERVE"
[321] "SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS"
[322] "TIJUANA ESTUARY NERR"
[323] "SALTON SEA"
[324] "SACRAMENTO BUFFERLANDS"
[325] "NAPA SONOMA MARSH WILDLIFE AREA"
[326] "MONTEZUMA WETLANDS"
[327] "PITTSBURG POWER PLANT"
[328] "ALAMEDA POINT"
[329] "HAYWARD REGIONAL SHORELINE"
[330] "EDEN LANDING ECOLOGICAL RESERVE"
[331] "KETTLEMAN CITY"
[332] "OCEANO DUNES STATE VEHICULAR RECREATION AREA"
[333] "RANCHO GUADALUPE DUNES PRESERVE"
[334] "VANDENBERG SFB"
[335] "COAL OIL POINT RESERVE"
[336] "SANTA CLARA RIVER MCGRATH STATE BEACH"
[337] "HOLLYWOOD BEACH"
[338] "ORMOND BEACH"
[339] "NBVC POINT MUGU"
[340] "VENICE BEACH"
[341] "LA HARBOR"
[342] "SEAL BEACH NWR ANAHEIM BAY"
[343] "BOLSA CHICA ECOLOGICAL RESERVE"
[344] "HUNTINGTON STATE BEACH"
[345] "BURRIS ISLAND"
[346] "UPPER NEWPORT BAY ECOLOGICAL RESERVE"
[347] "MCB CAMP PENDLETON"
[348] "BATIQUITOS LAGOON ECOLOGICAL RESERVE"
[349] "SAN ELIJO LAGOON ECOLOGICAL RESERVE"
[350] "FAIRBANKS RANCH"
[351] "SAN DIEGUITO LAGOON ECOLOGICAL RESERVE"
[352] "MISSION BAY FAA ISLAND"
[353] "MISSION BAY NORTH FIESTA ISLAND"
[354] "MISSION BAY MARINERS POINT"
[355] "MISSION BAY STONY POINT"
[356] "MISSION BAY SAN DIEGO RIVER MOUTH"
[357] "SDIA LINDBERGH FIELD"
[358] "NAS NORTH ISLAND"
[359] "NAVAL AMPHIBIOUS BASE CORONADO"
[360] "DSTREET FILL SWEETWATER MARSH NWR"
[361] "CHULA VISTA WILDLIFE RESERVE"
[362] "SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS"
[363] "TIJUANA ESTUARY NERR"
[364] "SALTON SEA"
[365] "SACRAMENTO BUFFERLANDS"
[366] "NAPA SONOMA MARSH WILDLIFE AREA"
[367] "MONTEZUMA WETLANDS"
[368] "PITTSBURG POWER PLANT"
[369] "ALAMEDA POINT"
[370] "HAYWARD REGIONAL SHORELINE"
[371] "EDEN LANDING ECOLOGICAL RESERVE"
[372] "KETTLEMAN CITY"
[373] "OCEANO DUNES STATE VEHICULAR RECREATION AREA"
[374] "RANCHO GUADALUPE DUNES PRESERVE"
[375] "VANDENBERG SFB"
[376] "COAL OIL POINT RESERVE"
[377] "SANTA CLARA RIVER MCGRATH STATE BEACH"
[378] "HOLLYWOOD BEACH"
[379] "ORMOND BEACH"
[380] "NBVC POINT MUGU"
[381] "SATICOY UNITED WATER CONSERVATION DISTRICT"
[382] "VENICE BEACH"
[383] "LA HARBOR"
[384] "SEAL BEACH NWR ANAHEIM BAY"
[385] "BOLSA CHICA ECOLOGICAL RESERVE"
[386] "HUNTINGTON STATE BEACH"
[387] "BURRIS ISLAND"
[388] "UPPER NEWPORT BAY ECOLOGICAL RESERVE"
[389] "MCB CAMP PENDLETON"
[390] "BATIQUITOS LAGOON ECOLOGICAL RESERVE"
[391] "SAN ELIJO LAGOON ECOLOGICAL RESERVE"
[392] "FAIRBANKS RANCH"
[393] "SAN DIEGUITO LAGOON ECOLOGICAL RESERVE"
[394] "MISSION BAY FAA ISLAND"
[395] "MISSION BAY NORTH FIESTA ISLAND"
[396] "MISSION BAY MARINERS POINT"
[397] "MISSION BAY STONY POINT"
[398] "MISSION BAY SAN DIEGO RIVER MOUTH"
[399] "SDIA LINDBERGH FIELD"
[400] "NAS NORTH ISLAND"
[401] "NAVAL AMPHIBIOUS BASE CORONADO"
[402] "DSTREET FILL SWEETWATER MARSH NWR"
[403] "CHULA VISTA WILDLIFE RESERVE"
[404] "SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS"
[405] "TIJUANA ESTUARY NERR"
[406] "SALTON SEA"
[407] "SACRAMENTO BUFFERLANDS"
[408] "NAPA SONOMA MARSH WILDLIFE AREA"
[409] "MONTEZUMA WETLANDS"
[410] "PITTSBURG POWER PLANT"
[411] "ALAMEDA POINT"
[412] "HAYWARD REGIONAL SHORELINE"
[413] "EDEN LANDING ECOLOGICAL RESERVE"
[414] "KETTLEMAN CITY"
[415] "OCEANO DUNES STATE VEHICULAR RECREATION AREA"
[416] "RANCHO GUADALUPE DUNES PRESERVE"
[417] "VANDENBERG SFB"
[418] "COAL OIL POINT RESERVE"
[419] "SANTA CLARA RIVER MCGRATH STATE BEACH"
[420] "HOLLYWOOD BEACH"
[421] "ORMOND BEACH"
[422] "NBVC POINT MUGU"
[423] "SATICOY UNITED WATER CONSERVATION DISTRICT"
[424] "VENICE BEACH"
[425] "LA HARBOR"
[426] "SEAL BEACH NWR ANAHEIM BAY"
[427] "BOLSA CHICA ECOLOGICAL RESERVE"
[428] "HUNTINGTON STATE BEACH"
[429] "BURRIS ISLAND"
[430] "UPPER NEWPORT BAY ECOLOGICAL RESERVE"
[431] "MCB CAMP PENDLETON"
[432] "BATIQUITOS LAGOON ECOLOGICAL RESERVE"
[433] "SAN ELIJO LAGOON ECOLOGICAL RESERVE"
[434] "FAIRBANKS RANCH"
[435] "SAN DIEGUITO LAGOON ECOLOGICAL RESERVE"
[436] "MISSION BAY FAA ISLAND"
[437] "MISSION BAY NORTH FIESTA ISLAND"
[438] "MISSION BAY MARINERS POINT"
[439] "MISSION BAY STONY POINT"
[440] "MISSION BAY SAN DIEGO RIVER MOUTH"
[441] "SDIA LINDBERGH FIELD"
[442] "NAS NORTH ISLAND"
[443] "NAVAL AMPHIBIOUS BASE CORONADO"
[444] "DSTREET FILL SWEETWATER MARSH NWR"
[445] "CHULA VISTA WILDLIFE RESERVE"
[446] "SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS"
[447] "TIJUANA ESTUARY NERR"
[448] "SALTON SEA"
[449] "SACRAMENTO BUFFERLANDS"
[450] "NAPA SONOMA MARSH WILDLIFE AREA"
[451] "MONTEZUMA WETLANDS"
[452] "PITTSBURG POWER PLANT"
[453] "ALAMEDA POINT"
[454] "HAYWARD REGIONAL SHORELINE"
[455] "EDEN LANDING ECOLOGICAL RESERVE"
[456] "KETTLEMAN CITY"
[457] "OCEANO DUNES STATE VEHICULAR RECREATION AREA"
[458] "RANCHO GUADALUPE DUNES PRESERVE"
[459] "VANDENBERG SFB"
[460] "COAL OIL POINT RESERVE"
[461] "SANTA CLARA RIVER MCGRATH STATE BEACH"
[462] "HOLLYWOOD BEACH"
[463] "ORMOND BEACH"
[464] "NBVC POINT MUGU"
[465] "SATICOY UNITED WATER CONSERVATION DISTRICT"
[466] "VENICE BEACH"
[467] "LA HARBOR"
[468] "SEAL BEACH NWR ANAHEIM BAY"
[469] "BOLSA CHICA ECOLOGICAL RESERVE"
[470] "HUNTINGTON STATE BEACH"
[471] "BURRIS ISLAND"
[472] "UPPER NEWPORT BAY ECOLOGICAL RESERVE"
[473] "MCB CAMP PENDLETON"
[474] "BATIQUITOS LAGOON ECOLOGICAL RESERVE"
[475] "SAN ELIJO LAGOON ECOLOGICAL RESERVE"
[476] "FAIRBANKS RANCH"
[477] "SAN DIEGUITO LAGOON ECOLOGICAL RESERVE"
[478] "MISSION BAY FAA ISLAND"
[479] "MISSION BAY NORTH FIESTA ISLAND"
[480] "MISSION BAY MARINERS POINT"
[481] "MISSION BAY STONY POINT"
[482] "MISSION BAY SAN DIEGO RIVER MOUTH"
[483] "SDIA LINDBERGH FIELD"
[484] "NAS NORTH ISLAND"
[485] "NAVAL AMPHIBIOUS BASE CORONADO"
[486] "DSTREET FILL SWEETWATER MARSH NWR"
[487] "CHULA VISTA WILDLIFE RESERVE"
[488] "SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS"
[489] "TIJUANA ESTUARY NERR"
[490] "SALTON SEA"
[491] "SACRAMENTO BUFFERLANDS"
[492] "NAPA SONOMA MARSH WILDLIFE AREA"
[493] "MONTEZUMA WETLANDS"
[494] "PITTSBURG POWER PLANT"
[495] "ALAMEDA POINT"
[496] "HAYWARD REGIONAL SHORELINE"
[497] "EDEN LANDING ECOLOGICAL RESERVE"
[498] "KETTLEMAN CITY"
[499] "OCEANO DUNES STATE VEHICULAR RECREATION AREA"
[500] "RANCHO GUADALUPE DUNES PRESERVE"
[501] "VANDENBERG SFB"
[502] "COAL OIL POINT RESERVE"
[503] "SANTA CLARA RIVER MCGRATH STATE BEACH"
[504] "HOLLYWOOD BEACH"
[505] "ORMOND BEACH"
[506] "NBVC POINT MUGU"
[507] "SATICOY UNITED WATER CONSERVATION DISTRICT"
[508] "VENICE BEACH"
[509] "LA HARBOR"
[510] "SEAL BEACH NWR ANAHEIM BAY"
[511] "BOLSA CHICA ECOLOGICAL RESERVE"
[512] "HUNTINGTON STATE BEACH"
[513] "ANAHEIM LAKE"
[514] "BURRIS ISLAND"
[515] "UPPER NEWPORT BAY ECOLOGICAL RESERVE"
[516] "MCB CAMP PENDLETON"
[517] "BATIQUITOS LAGOON ECOLOGICAL RESERVE"
[518] "SAN ELIJO LAGOON ECOLOGICAL RESERVE"
[519] "FAIRBANKS RANCH"
[520] "SAN DIEGUITO LAGOON ECOLOGICAL RESERVE"
[521] "MISSION BAY FAA ISLAND"
[522] "MISSION BAY NORTH FIESTA ISLAND"
[523] "MISSION BAY MARINERS POINT"
[524] "MISSION BAY STONY POINT"
[525] "MISSION BAY SAN DIEGO RIVER MOUTH"
[526] "SDIA LINDBERGH FIELD"
[527] "NAS NORTH ISLAND"
[528] "NAVAL AMPHIBIOUS BASE CORONADO"
[529] "DSTREET FILL SWEETWATER MARSH NWR"
[530] "CHULA VISTA WILDLIFE RESERVE"
[531] "SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS"
[532] "TIJUANA ESTUARY NERR"
[533] "SALTON SEA"
[534] "SACRAMENTO BUFFERLANDS"
[535] "NAPA SONOMA MARSH WILDLIFE AREA"
[536] "MONTEZUMA WETLANDS"
[537] "PITTSBURG POWER PLANT"
[538] "ALAMEDA POINT"
[539] "HAYWARD REGIONAL SHORELINE"
[540] "EDEN LANDING ECOLOGICAL RESERVE"
[541] "KETTLEMAN CITY"
[542] "OCEANO DUNES STATE VEHICULAR RECREATION AREA"
[543] "RANCHO GUADALUPE DUNES PRESERVE"
[544] "GUADALUPE NIPOMO DUNES NWR"
[545] "VANDENBERG SFB"
[546] "COAL OIL POINT RESERVE"
[547] "SANTA CLARA RIVER MCGRATH STATE BEACH"
[548] "HOLLYWOOD BEACH"
[549] "ORMOND BEACH"
[550] "NBVC POINT MUGU"
[551] "SATICOY UNITED WATER CONSERVATION DISTRICT"
[552] "VENICE BEACH"
[553] "MALIBU LAGOON"
[554] "LA HARBOR"
[555] "SEAL BEACH NWR ANAHEIM BAY"
[556] "BOLSA CHICA ECOLOGICAL RESERVE"
[557] "HUNTINGTON STATE BEACH"
[558] "ANAHEIM LAKE"
[559] "BURRIS ISLAND"
[560] "UPPER NEWPORT BAY ECOLOGICAL RESERVE"
[561] "MCB CAMP PENDLETON"
[562] "BATIQUITOS LAGOON ECOLOGICAL RESERVE"
[563] "SAN ELIJO LAGOON ECOLOGICAL RESERVE"
[564] "FAIRBANKS RANCH"
[565] "SAN DIEGUITO LAGOON ECOLOGICAL RESERVE"
[566] "MISSION BAY FAA ISLAND"
[567] "MISSION BAY NORTH FIESTA ISLAND"
[568] "MISSION BAY MARINERS POINT"
[569] "MISSION BAY STONY POINT"
[570] "MISSION BAY SAN DIEGO RIVER MOUTH"
[571] "SDIA LINDBERGH FIELD"
[572] "NAS NORTH ISLAND"
[573] "NAVAL AMPHIBIOUS BASE CORONADO"
[574] "DSTREET FILL SWEETWATER MARSH NWR"
[575] "CHULA VISTA WILDLIFE RESERVE"
[576] "SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS"
[577] "TIJUANA ESTUARY NERR"
[578] "SALTON SEA"
[579] "NAPA SONOMA MARSH WILDLIFE AREA"
[580] "MONTEZUMA WETLANDS"
[581] "ALAMEDA POINT"
[582] "HAYWARD REGIONAL SHORELINE"
[583] "EDEN LANDING ECOLOGICAL RESERVE"
[584] "OCEANO DUNES STATE VEHICULAR RECREATION AREA"
[585] "VANDENBERG SFB"
[586] "SANTA CLARA RIVER MCGRATH STATE BEACH"
[587] "HOLLYWOOD BEACH"
[588] "ORMOND BEACH"
[589] "NBVC POINT MUGU"
[590] "SATICOY UNITED WATER CONSERVATION DISTRICT"
[591] "VENICE BEACH"
[592] "MALIBU LAGOON"
[593] "LA HARBOR"
[594] "SEAL BEACH NWR ANAHEIM BAY"
[595] "BOLSA CHICA ECOLOGICAL RESERVE"
[596] "HUNTINGTON STATE BEACH"
[597] "BURRIS ISLAND"
[598] "UPPER NEWPORT BAY ECOLOGICAL RESERVE"
[599] "MCB CAMP PENDLETON"
[600] "BATIQUITOS LAGOON ECOLOGICAL RESERVE"
[601] "SAN ELIJO LAGOON ECOLOGICAL RESERVE"
[602] "MISSION BAY FAA ISLAND"
[603] "MISSION BAY NORTH FIESTA ISLAND"
[604] "MISSION BAY MARINERS POINT"
[605] "MISSION BAY STONY POINT"
[606] "SDIA LINDBERGH FIELD"
[607] "NAS NORTH ISLAND"
[608] "NAVAL AMPHIBIOUS BASE CORONADO"
[609] "DSTREET FILL SWEETWATER MARSH NWR"
[610] "CHULA VISTA WILDLIFE RESERVE"
[611] "SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS"
[612] "TIJUANA ESTUARY NERR"
[613] "NAPA SONOMA MARSH WILDLIFE AREA"
[614] "MONTEZUMA WETLANDS"
[615] "ALAMEDA POINT"
[616] "HAYWARD REGIONAL SHORELINE"
[617] "EDEN LANDING ECOLOGICAL RESERVE"
[618] "OCEANO DUNES STATE VEHICULAR RECREATION AREA"
[619] "RANCHO GUADALUPE DUNES PRESERVE"
[620] "VANDENBERG SFB"
[621] "SANTA CLARA RIVER MCGRATH STATE BEACH"
[622] "HOLLYWOOD BEACH"
[623] "ORMOND BEACH"
[624] "NBVC POINT MUGU"
[625] "SATICOY UNITED WATER CONSERVATION DISTRICT"
[626] "VENICE BEACH"
[627] "MALIBU LAGOON"
[628] "LA HARBOR"
[629] "SEAL BEACH NWR ANAHEIM BAY"
[630] "BOLSA CHICA ECOLOGICAL RESERVE"
[631] "HUNTINGTON STATE BEACH"
[632] "BURRIS ISLAND"
[633] "UPPER NEWPORT BAY ECOLOGICAL RESERVE"
[634] "MCB CAMP PENDLETON"
[635] "BATIQUITOS LAGOON ECOLOGICAL RESERVE"
[636] "SAN ELIJO LAGOON ECOLOGICAL RESERVE"
[637] "MISSION BAY FAA ISLAND"
[638] "MISSION BAY NORTH FIESTA ISLAND"
[639] "MISSION BAY MARINERS POINT"
[640] "MISSION BAY STONY POINT"
[641] "SDIA LINDBERGH FIELD"
[642] "NAS NORTH ISLAND"
[643] "NAVAL AMPHIBIOUS BASE CORONADO"
[644] "DSTREET FILL SWEETWATER MARSH NWR"
[645] "CHULA VISTA WILDLIFE RESERVE"
[646] "SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS"
[647] "TIJUANA ESTUARY NERR"
[648] "NAPA SONOMA MARSH WILDLIFE AREA"
[649] "MONTEZUMA WETLANDS"
[650] "ALAMEDA POINT"
[651] "HAYWARD REGIONAL SHORELINE"
[652] "EDEN LANDING ECOLOGICAL RESERVE"
[653] "OCEANO DUNES STATE VEHICULAR RECREATION AREA"
[654] "RANCHO GUADALUPE DUNES PRESERVE"
[655] "VANDENBERG SFB"
[656] "SANTA CLARA RIVER MCGRATH STATE BEACH"
[657] "HOLLYWOOD BEACH"
[658] "ORMOND BEACH"
[659] "NBVC POINT MUGU"
[660] "SATICOY UNITED WATER CONSERVATION DISTRICT"
[661] "VENICE BEACH"
[662] "MALIBU LAGOON"
[663] "LA HARBOR"
[664] "SEAL BEACH NWR ANAHEIM BAY"
[665] "BOLSA CHICA ECOLOGICAL RESERVE"
[666] "HUNTINGTON STATE BEACH"
[667] "BURRIS ISLAND"
[668] "UPPER NEWPORT BAY ECOLOGICAL RESERVE"
[669] "MCB CAMP PENDLETON"
[670] "BATIQUITOS LAGOON ECOLOGICAL RESERVE"
[671] "SAN ELIJO LAGOON ECOLOGICAL RESERVE"
[672] "MISSION BAY FAA ISLAND"
[673] "MISSION BAY NORTH FIESTA ISLAND"
[674] "MISSION BAY MARINERS POINT"
[675] "MISSION BAY STONY POINT"
[676] "SDIA LINDBERGH FIELD"
[677] "NAS NORTH ISLAND"
[678] "NAVAL AMPHIBIOUS BASE CORONADO"
[679] "DSTREET FILL SWEETWATER MARSH NWR"
[680] "CHULA VISTA WILDLIFE RESERVE"
[681] "SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS"
[682] "TIJUANA ESTUARY NERR"
[683] "NAPA SONOMA MARSH WILDLIFE AREA"
[684] "SAN PABLO BAY NWR"
[685] "MONTEZUMA WETLANDS"
[686] "ALAMEDA POINT"
[687] "HAYWARD REGIONAL SHORELINE"
[688] "EDEN LANDING ECOLOGICAL RESERVE"
[689] "OCEANO DUNES STATE VEHICULAR RECREATION AREA"
[690] "RANCHO GUADALUPE DUNES PRESERVE"
[691] "VANDENBERG SFB"
[692] "SANTA CLARA RIVER MCGRATH STATE BEACH"
[693] "HOLLYWOOD BEACH"
[694] "ORMOND BEACH"
[695] "NBVC POINT MUGU"
[696] "SATICOY UNITED WATER CONSERVATION DISTRICT"
[697] "VENICE BEACH"
[698] "MALIBU LAGOON"
[699] "LA HARBOR"
[700] "SEAL BEACH NWR ANAHEIM BAY"
[701] "BOLSA CHICA ECOLOGICAL RESERVE"
[702] "HUNTINGTON STATE BEACH"
[703] "BURRIS ISLAND"
[704] "UPPER NEWPORT BAY ECOLOGICAL RESERVE"
[705] "MCB CAMP PENDLETON"
[706] "BATIQUITOS LAGOON ECOLOGICAL RESERVE"
[707] "SAN ELIJO LAGOON ECOLOGICAL RESERVE"
[708] "MISSION BAY FAA ISLAND"
[709] "MISSION BAY NORTH FIESTA ISLAND"
[710] "MISSION BAY MARINERS POINT"
[711] "MISSION BAY STONY POINT"
[712] "SDIA LINDBERGH FIELD"
[713] "NAS NORTH ISLAND"
[714] "NAVAL AMPHIBIOUS BASE CORONADO"
[715] "DSTREET FILL SWEETWATER MARSH NWR"
[716] "CHULA VISTA WILDLIFE RESERVE"
[717] "SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS"
[718] "TIJUANA ESTUARY NERR"
[719] "NAPA SONOMA MARSH WILDLIFE AREA"
[720] "SAN PABLO BAY NWR"
[721] "MONTEZUMA WETLANDS"
[722] "ALAMEDA POINT"
[723] "HAYWARD REGIONAL SHORELINE"
[724] "EDEN LANDING ECOLOGICAL RESERVE"
[725] "OCEANO DUNES STATE VEHICULAR RECREATION AREA"
[726] "RANCHO GUADALUPE DUNES PRESERVE"
[727] "VANDENBERG SFB"
[728] "SANTA CLARA RIVER MCGRATH STATE BEACH"
[729] "HOLLYWOOD BEACH"
[730] "ORMOND BEACH"
[731] "NBVC POINT MUGU"
[732] "VENICE BEACH"
[733] "MALIBU LAGOON"
[734] "LA HARBOR"
[735] "SEAL BEACH NWR ANAHEIM BAY"
[736] "BOLSA CHICA ECOLOGICAL RESERVE"
[737] "HUNTINGTON STATE BEACH"
[738] "BURRIS ISLAND"
[739] "UPPER NEWPORT BAY ECOLOGICAL RESERVE"
[740] "MCB CAMP PENDLETON"
[741] "BATIQUITOS LAGOON ECOLOGICAL RESERVE"
[742] "SAN ELIJO LAGOON ECOLOGICAL RESERVE"
[743] "SAN DIEGUITO LAGOON ECOLOGICAL RESERVE"
[744] "MISSION BAY FAA ISLAND"
[745] "MISSION BAY NORTH FIESTA ISLAND"
[746] "MISSION BAY MARINERS POINT"
[747] "MISSION BAY STONY POINT"
[748] "SDIA LINDBERGH FIELD"
[749] "NAS NORTH ISLAND"
[750] "NAVAL AMPHIBIOUS BASE CORONADO"
[751] "DSTREET FILL SWEETWATER MARSH NWR"
[752] "CHULA VISTA WILDLIFE RESERVE"
[753] "SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS"
[754] "TIJUANA ESTUARY NERR"
[755] "NAPA SONOMA MARSH WILDLIFE AREA"
[756] "SAN PABLO BAY NWR"
[757] "MONTEZUMA WETLANDS"
[758] "ALAMEDA POINT"
[759] "HAYWARD REGIONAL SHORELINE"
[760] "EDEN LANDING ECOLOGICAL RESERVE"
[761] "OCEANO DUNES STATE VEHICULAR RECREATION AREA"
[762] "RANCHO GUADALUPE DUNES PRESERVE"
[763] "VANDENBERG SFB"
[764] "SANTA CLARA RIVER MCGRATH STATE BEACH"
[765] "HOLLYWOOD BEACH"
[766] "ORMOND BEACH"
[767] "NBVC POINT MUGU"
[768] "VENICE BEACH"
[769] "MALIBU LAGOON"
[770] "LA HARBOR"
[771] "SEAL BEACH NWR ANAHEIM BAY"
[772] "BOLSA CHICA ECOLOGICAL RESERVE"
[773] "HUNTINGTON STATE BEACH"
[774] "ANAHEIM LAKE"
[775] "BURRIS ISLAND"
[776] "UPPER NEWPORT BAY ECOLOGICAL RESERVE"
[777] "MCB CAMP PENDLETON"
[778] "BATIQUITOS LAGOON ECOLOGICAL RESERVE"
[779] "SAN ELIJO LAGOON ECOLOGICAL RESERVE"
[780] "SAN DIEGUITO LAGOON ECOLOGICAL RESERVE"
[781] "MISSION BAY FAA ISLAND"
[782] "MISSION BAY NORTH FIESTA ISLAND"
[783] "MISSION BAY MARINERS POINT"
[784] "MISSION BAY STONY POINT"
[785] "SDIA LINDBERGH FIELD"
[786] "NAS NORTH ISLAND"
[787] "NAVAL AMPHIBIOUS BASE CORONADO"
[788] "DSTREET FILL SWEETWATER MARSH NWR"
[789] "CHULA VISTA WILDLIFE RESERVE"
[790] "SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS"
[791] "TIJUANA ESTUARY NERR" The double square bracket operator is also important for getting and setting elements of lists (Section 13.2.1). Unlike the dollar sign operator, it can also get columns by position:
terns[[1]] [1] 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000
[16] 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2004
[31] 2004 2004 2004 2004 2004 2004 2004 2004 2004 2004 2004 2004 2004 2004 2004
[46] 2004 2004 2004 2004 2004 2004 2004 2004 2004 2004 2004 2004 2004 2004 2004
[61] 2004 2004 2004 2005 2005 2005 2005 2005 2005 2005 2005 2005 2005 2005 2005
[76] 2005 2005 2005 2005 2005 2005 2005 2005 2005 2005 2005 2005 2005 2005 2005
[91] 2005 2005 2005 2005 2006 2006 2006 2006 2006 2006 2006 2006 2006 2006 2006
[106] 2006 2006 2006 2006 2006 2006 2006 2006 2006 2006 2006 2006 2006 2006 2006
[121] 2006 2006 2006 2006 2006 2006 2006 2007 2007 2007 2007 2007 2007 2007 2007
[136] 2007 2007 2007 2007 2007 2007 2007 2007 2007 2007 2007 2007 2007 2007 2007
[151] 2007 2007 2007 2007 2007 2007 2007 2007 2007 2007 2007 2007 2007 2007 2008
[166] 2008 2008 2008 2008 2008 2008 2008 2008 2008 2008 2008 2008 2008 2008 2008
[181] 2008 2008 2008 2008 2008 2008 2008 2008 2008 2008 2008 2008 2008 2008 2008
[196] 2008 2008 2008 2008 2008 2008 2008 2009 2009 2009 2009 2009 2009 2009 2009
[211] 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009
[226] 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009
[241] 2009 2009 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010
[256] 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010
[271] 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2011 2011 2011
[286] 2011 2011 2011 2011 2011 2011 2011 2011 2011 2011 2011 2011 2011 2011 2011
[301] 2011 2011 2011 2011 2011 2011 2011 2011 2011 2011 2011 2011 2011 2011 2011
[316] 2011 2011 2011 2011 2011 2011 2011 2011 2012 2012 2012 2012 2012 2012 2012
[331] 2012 2012 2012 2012 2012 2012 2012 2012 2012 2012 2012 2012 2012 2012 2012
[346] 2012 2012 2012 2012 2012 2012 2012 2012 2012 2012 2012 2012 2012 2012 2012
[361] 2012 2012 2012 2012 2013 2013 2013 2013 2013 2013 2013 2013 2013 2013 2013
[376] 2013 2013 2013 2013 2013 2013 2013 2013 2013 2013 2013 2013 2013 2013 2013
[391] 2013 2013 2013 2013 2013 2013 2013 2013 2013 2013 2013 2013 2013 2013 2013
[406] 2013 2014 2014 2014 2014 2014 2014 2014 2014 2014 2014 2014 2014 2014 2014
[421] 2014 2014 2014 2014 2014 2014 2014 2014 2014 2014 2014 2014 2014 2014 2014
[436] 2014 2014 2014 2014 2014 2014 2014 2014 2014 2014 2014 2014 2014 2015 2015
[451] 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015
[466] 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015
[481] 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2016 2016 2016 2016 2016
[496] 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016
[511] 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016
[526] 2016 2016 2016 2016 2016 2016 2016 2016 2017 2017 2017 2017 2017 2017 2017
[541] 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017
[556] 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017
[571] 2017 2017 2017 2017 2017 2017 2017 2017 2018 2018 2018 2018 2018 2018 2018
[586] 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018
[601] 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2019 2019 2019
[616] 2019 2019 2019 2019 2019 2019 2019 2019 2019 2019 2019 2019 2019 2019 2019
[631] 2019 2019 2019 2019 2019 2019 2019 2019 2019 2019 2019 2019 2019 2019 2019
[646] 2019 2019 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020
[661] 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020
[676] 2020 2020 2020 2020 2020 2020 2020 2021 2021 2021 2021 2021 2021 2021 2021
[691] 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021
[706] 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2022 2022
[721] 2022 2022 2022 2022 2022 2022 2022 2022 2022 2022 2022 2022 2022 2022 2022
[736] 2022 2022 2022 2022 2022 2022 2022 2022 2022 2022 2022 2022 2022 2022 2022
[751] 2022 2022 2022 2022 2023 2023 2023 2023 2023 2023 2023 2023 2023 2023 2023
[766] 2023 2023 2023 2023 2023 2023 2023 2023 2023 2023 2023 2023 2023 2023 2023
[781] 2023 2023 2023 2023 2023 2023 2023 2023 2023 2023 2023Most of the time, you should use the dollar sign operator when you want to get a single column.
Tip
Quotes are optional with the dollar sign operator. So another way to get the total_nests column is:
terns$"total_nests"Use quotes if you want to get a column whose name contains spaces or other special characters. For all other cases, quotes are not necessary.
15.2.2 Multiple Columns
The dollar sign operator $ and double square bracket operator [[ can only get one column of a data frame at a time, and they always return columns as vectors. This is useful when we want to compute on just one column, because most functions (especially math and statistics functions) require vector arguments.
Sometimes we’ll want to get multiple columns from a data frame. Imagine a data frame with 300 columns, but only 5 that are relevant to your research question. Getting rid of the extra columns makes the data easier to inspect and might make some computations faster. When you select multiple columns from a data frame, the result is also a data frame.
One way to select multiple columns is with the indexing operator [. If you use the indexing operator on a data frame and only provide one index, R will select columns. For example, to select the site_name and year columns from the least terns dataset:
terns[c("site_name", "year")] site_name year
1 PITTSBURG POWER PLANT 2000
2 ALBANY CENTRAL AVE 2000
3 ALAMEDA POINT 2000
4 KETTLEMAN CITY 2000
5 OCEANO DUNES STATE VEHICULAR RECREATION AREA 2000
6 RANCHO GUADALUPE DUNES PRESERVE 2000
7 VANDENBERG SFB 2000
8 SANTA CLARA RIVER MCGRATH STATE BEACH 2000
9 ORMOND BEACH 2000
10 NBVC POINT MUGU 2000
11 VENICE BEACH 2000
12 LA HARBOR 2000
13 SEAL BEACH NWR ANAHEIM BAY 2000
14 BOLSA CHICA ECOLOGICAL RESERVE 2000
15 HUNTINGTON STATE BEACH 2000
16 UPPER NEWPORT BAY ECOLOGICAL RESERVE 2000
17 MCB CAMP PENDLETON 2000
18 BATIQUITOS LAGOON ECOLOGICAL RESERVE 2000
19 SAN ELIJO LAGOON ECOLOGICAL RESERVE 2000
20 MISSION BAY FAA ISLAND 2000
21 MISSION BAY NORTH FIESTA ISLAND 2000
22 MISSION BAY MARINERS POINT 2000
23 SDIA LINDBERGH FIELD 2000
24 NAS NORTH ISLAND 2000
25 NAVAL AMPHIBIOUS BASE CORONADO 2000
26 DSTREET FILL SWEETWATER MARSH NWR 2000
27 CHULA VISTA WILDLIFE RESERVE 2000
28 SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS 2000
29 TIJUANA ESTUARY NERR 2000
30 PITTSBURG POWER PLANT 2004
31 ALBANY CENTRAL AVE 2004
32 ALAMEDA POINT 2004
33 KETTLEMAN CITY 2004
34 OCEANO DUNES STATE VEHICULAR RECREATION AREA 2004
35 RANCHO GUADALUPE DUNES PRESERVE 2004
36 VANDENBERG SFB 2004
37 COAL OIL POINT RESERVE 2004
38 SANTA CLARA RIVER MCGRATH STATE BEACH 2004
39 HOLLYWOOD BEACH 2004
40 ORMOND BEACH 2004
41 NBVC POINT MUGU 2004
42 VENICE BEACH 2004
43 LA HARBOR 2004
44 SEAL BEACH NWR ANAHEIM BAY 2004
45 BOLSA CHICA ECOLOGICAL RESERVE 2004
46 HUNTINGTON STATE BEACH 2004
47 BURRIS ISLAND 2004
48 UPPER NEWPORT BAY ECOLOGICAL RESERVE 2004
49 MCB CAMP PENDLETON 2004
50 BATIQUITOS LAGOON ECOLOGICAL RESERVE 2004
51 SAN ELIJO LAGOON ECOLOGICAL RESERVE 2004
52 MISSION BAY FAA ISLAND 2004
53 MISSION BAY NORTH FIESTA ISLAND 2004
54 MISSION BAY MARINERS POINT 2004
55 MISSION BAY SAN DIEGO RIVER MOUTH 2004
56 SDIA LINDBERGH FIELD 2004
57 NAS NORTH ISLAND 2004
58 NAVAL AMPHIBIOUS BASE CORONADO 2004
59 SILVER STRAND STATE BEACH 2004
60 DSTREET FILL SWEETWATER MARSH NWR 2004
61 CHULA VISTA WILDLIFE RESERVE 2004
62 SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS 2004
63 TIJUANA ESTUARY NERR 2004
64 PITTSBURG POWER PLANT 2005
65 ALAMEDA POINT 2005
66 HAYWARD REGIONAL SHORELINE 2005
67 KETTLEMAN CITY 2005
68 OCEANO DUNES STATE VEHICULAR RECREATION AREA 2005
69 RANCHO GUADALUPE DUNES PRESERVE 2005
70 VANDENBERG SFB 2005
71 COAL OIL POINT RESERVE 2005
72 SANTA CLARA RIVER MCGRATH STATE BEACH 2005
73 ORMOND BEACH 2005
74 NBVC POINT MUGU 2005
75 VENICE BEACH 2005
76 LA HARBOR 2005
77 SEAL BEACH NWR ANAHEIM BAY 2005
78 BOLSA CHICA ECOLOGICAL RESERVE 2005
79 HUNTINGTON STATE BEACH 2005
80 UPPER NEWPORT BAY ECOLOGICAL RESERVE 2005
81 MCB CAMP PENDLETON 2005
82 BATIQUITOS LAGOON ECOLOGICAL RESERVE 2005
83 SAN ELIJO LAGOON ECOLOGICAL RESERVE 2005
84 MISSION BAY FAA ISLAND 2005
85 MISSION BAY NORTH FIESTA ISLAND 2005
86 MISSION BAY MARINERS POINT 2005
87 MISSION BAY SAN DIEGO RIVER MOUTH 2005
88 SDIA LINDBERGH FIELD 2005
89 NAS NORTH ISLAND 2005
90 NAVAL AMPHIBIOUS BASE CORONADO 2005
91 DSTREET FILL SWEETWATER MARSH NWR 2005
92 CHULA VISTA WILDLIFE RESERVE 2005
93 SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS 2005
94 TIJUANA ESTUARY NERR 2005
95 MONTEZUMA WETLANDS 2006
96 PITTSBURG POWER PLANT 2006
97 ALAMEDA POINT 2006
98 HAYWARD REGIONAL SHORELINE 2006
99 KETTLEMAN CITY 2006
100 OCEANO DUNES STATE VEHICULAR RECREATION AREA 2006
101 RANCHO GUADALUPE DUNES PRESERVE 2006
102 VANDENBERG SFB 2006
103 COAL OIL POINT RESERVE 2006
104 SANTA CLARA RIVER MCGRATH STATE BEACH 2006
105 ORMOND BEACH 2006
106 NBVC POINT MUGU 2006
107 VENICE BEACH 2006
108 LA HARBOR 2006
109 SEAL BEACH NWR ANAHEIM BAY 2006
110 BOLSA CHICA ECOLOGICAL RESERVE 2006
111 HUNTINGTON STATE BEACH 2006
112 UPPER NEWPORT BAY ECOLOGICAL RESERVE 2006
113 MCB CAMP PENDLETON 2006
114 BATIQUITOS LAGOON ECOLOGICAL RESERVE 2006
115 SAN ELIJO LAGOON ECOLOGICAL RESERVE 2006
116 MISSION BAY FAA ISLAND 2006
117 MISSION BAY NORTH FIESTA ISLAND 2006
118 MISSION BAY MARINERS POINT 2006
119 MISSION BAY STONY POINT 2006
120 MISSION BAY SAN DIEGO RIVER MOUTH 2006
121 SDIA LINDBERGH FIELD 2006
122 NAS NORTH ISLAND 2006
123 NAVAL AMPHIBIOUS BASE CORONADO 2006
124 DSTREET FILL SWEETWATER MARSH NWR 2006
125 CHULA VISTA WILDLIFE RESERVE 2006
126 SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS 2006
127 TIJUANA ESTUARY NERR 2006
128 NAPA SONOMA MARSH WILDLIFE AREA 2007
129 MONTEZUMA WETLANDS 2007
130 PITTSBURG POWER PLANT 2007
131 ALAMEDA POINT 2007
132 HAYWARD REGIONAL SHORELINE 2007
133 EDEN LANDING ECOLOGICAL RESERVE 2007
134 KETTLEMAN CITY 2007
135 OCEANO DUNES STATE VEHICULAR RECREATION AREA 2007
136 RANCHO GUADALUPE DUNES PRESERVE 2007
137 VANDENBERG SFB 2007
138 COAL OIL POINT RESERVE 2007
139 SANTA CLARA RIVER MCGRATH STATE BEACH 2007
140 HOLLYWOOD BEACH 2007
141 ORMOND BEACH 2007
142 NBVC POINT MUGU 2007
143 VENICE BEACH 2007
144 LA HARBOR 2007
145 SEAL BEACH NWR ANAHEIM BAY 2007
146 BOLSA CHICA ECOLOGICAL RESERVE 2007
147 HUNTINGTON STATE BEACH 2007
148 BURRIS ISLAND 2007
149 UPPER NEWPORT BAY ECOLOGICAL RESERVE 2007
150 MCB CAMP PENDLETON 2007
151 BATIQUITOS LAGOON ECOLOGICAL RESERVE 2007
152 SAN ELIJO LAGOON ECOLOGICAL RESERVE 2007
153 MISSION BAY FAA ISLAND 2007
154 MISSION BAY NORTH FIESTA ISLAND 2007
155 MISSION BAY MARINERS POINT 2007
156 MISSION BAY STONY POINT 2007
157 MISSION BAY SAN DIEGO RIVER MOUTH 2007
158 SDIA LINDBERGH FIELD 2007
159 NAS NORTH ISLAND 2007
160 NAVAL AMPHIBIOUS BASE CORONADO 2007
161 DSTREET FILL SWEETWATER MARSH NWR 2007
162 CHULA VISTA WILDLIFE RESERVE 2007
163 SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS 2007
164 TIJUANA ESTUARY NERR 2007
165 SACRAMENTO BUFFERLANDS 2008
166 NAPA SONOMA MARSH WILDLIFE AREA 2008
167 MONTEZUMA WETLANDS 2008
168 PITTSBURG POWER PLANT 2008
169 ALAMEDA POINT 2008
170 HAYWARD REGIONAL SHORELINE 2008
171 EDEN LANDING ECOLOGICAL RESERVE 2008
172 KETTLEMAN CITY 2008
173 OCEANO DUNES STATE VEHICULAR RECREATION AREA 2008
174 RANCHO GUADALUPE DUNES PRESERVE 2008
175 VANDENBERG SFB 2008
176 COAL OIL POINT RESERVE 2008
177 SANTA CLARA RIVER MCGRATH STATE BEACH 2008
178 HOLLYWOOD BEACH 2008
179 ORMOND BEACH 2008
180 NBVC POINT MUGU 2008
181 VENICE BEACH 2008
182 LA HARBOR 2008
183 SEAL BEACH NWR ANAHEIM BAY 2008
184 BOLSA CHICA ECOLOGICAL RESERVE 2008
185 HUNTINGTON STATE BEACH 2008
186 BURRIS ISLAND 2008
187 UPPER NEWPORT BAY ECOLOGICAL RESERVE 2008
188 MCB CAMP PENDLETON 2008
189 BATIQUITOS LAGOON ECOLOGICAL RESERVE 2008
190 SAN ELIJO LAGOON ECOLOGICAL RESERVE 2008
191 MISSION BAY FAA ISLAND 2008
192 MISSION BAY NORTH FIESTA ISLAND 2008
193 MISSION BAY MARINERS POINT 2008
194 MISSION BAY STONY POINT 2008
195 MISSION BAY SAN DIEGO RIVER MOUTH 2008
196 SDIA LINDBERGH FIELD 2008
197 NAS NORTH ISLAND 2008
198 NAVAL AMPHIBIOUS BASE CORONADO 2008
199 DSTREET FILL SWEETWATER MARSH NWR 2008
200 CHULA VISTA WILDLIFE RESERVE 2008
201 SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS 2008
202 TIJUANA ESTUARY NERR 2008
203 SACRAMENTO BUFFERLANDS 2009
204 NAPA SONOMA MARSH WILDLIFE AREA 2009
205 MONTEZUMA WETLANDS 2009
206 PITTSBURG POWER PLANT 2009
207 ALAMEDA POINT 2009
208 HAYWARD REGIONAL SHORELINE 2009
209 EDEN LANDING ECOLOGICAL RESERVE 2009
210 KETTLEMAN CITY 2009
211 OCEANO DUNES STATE VEHICULAR RECREATION AREA 2009
212 RANCHO GUADALUPE DUNES PRESERVE 2009
213 VANDENBERG SFB 2009
214 COAL OIL POINT RESERVE 2009
215 SANTA CLARA RIVER MCGRATH STATE BEACH 2009
216 HOLLYWOOD BEACH 2009
217 ORMOND BEACH 2009
218 NBVC POINT MUGU 2009
219 VENICE BEACH 2009
220 LA HARBOR 2009
221 SEAL BEACH NWR ANAHEIM BAY 2009
222 BOLSA CHICA ECOLOGICAL RESERVE 2009
223 HUNTINGTON STATE BEACH 2009
224 BURRIS ISLAND 2009
225 UPPER NEWPORT BAY ECOLOGICAL RESERVE 2009
226 MCB CAMP PENDLETON 2009
227 BATIQUITOS LAGOON ECOLOGICAL RESERVE 2009
228 SAN ELIJO LAGOON ECOLOGICAL RESERVE 2009
229 FAIRBANKS RANCH 2009
230 MISSION BAY FAA ISLAND 2009
231 MISSION BAY NORTH FIESTA ISLAND 2009
232 MISSION BAY MARINERS POINT 2009
233 MISSION BAY STONY POINT 2009
234 MISSION BAY SAN DIEGO RIVER MOUTH 2009
235 SDIA LINDBERGH FIELD 2009
236 NAS NORTH ISLAND 2009
237 NAVAL AMPHIBIOUS BASE CORONADO 2009
238 DSTREET FILL SWEETWATER MARSH NWR 2009
239 CHULA VISTA WILDLIFE RESERVE 2009
240 SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS 2009
241 TIJUANA ESTUARY NERR 2009
242 ARIZONA GLENDALE 2009
243 SACRAMENTO BUFFERLANDS 2010
244 NAPA SONOMA MARSH WILDLIFE AREA 2010
245 MONTEZUMA WETLANDS 2010
246 PITTSBURG POWER PLANT 2010
247 ALAMEDA POINT 2010
248 HAYWARD REGIONAL SHORELINE 2010
249 EDEN LANDING ECOLOGICAL RESERVE 2010
250 KETTLEMAN CITY 2010
251 OCEANO DUNES STATE VEHICULAR RECREATION AREA 2010
252 RANCHO GUADALUPE DUNES PRESERVE 2010
253 VANDENBERG SFB 2010
254 COAL OIL POINT RESERVE 2010
255 SANTA CLARA RIVER MCGRATH STATE BEACH 2010
256 HOLLYWOOD BEACH 2010
257 ORMOND BEACH 2010
258 NBVC POINT MUGU 2010
259 VENICE BEACH 2010
260 LA HARBOR 2010
261 SEAL BEACH NWR ANAHEIM BAY 2010
262 BOLSA CHICA ECOLOGICAL RESERVE 2010
263 HUNTINGTON STATE BEACH 2010
264 BURRIS ISLAND 2010
265 UPPER NEWPORT BAY ECOLOGICAL RESERVE 2010
266 MCB CAMP PENDLETON 2010
267 BATIQUITOS LAGOON ECOLOGICAL RESERVE 2010
268 SAN ELIJO LAGOON ECOLOGICAL RESERVE 2010
269 FAIRBANKS RANCH 2010
270 SAN DIEGUITO LAGOON ECOLOGICAL RESERVE 2010
271 MISSION BAY FAA ISLAND 2010
272 MISSION BAY NORTH FIESTA ISLAND 2010
273 MISSION BAY MARINERS POINT 2010
274 MISSION BAY STONY POINT 2010
275 MISSION BAY SAN DIEGO RIVER MOUTH 2010
276 SDIA LINDBERGH FIELD 2010
277 NAS NORTH ISLAND 2010
278 NAVAL AMPHIBIOUS BASE CORONADO 2010
279 DSTREET FILL SWEETWATER MARSH NWR 2010
280 CHULA VISTA WILDLIFE RESERVE 2010
281 SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS 2010
282 TIJUANA ESTUARY NERR 2010
283 SACRAMENTO BUFFERLANDS 2011
284 NAPA SONOMA MARSH WILDLIFE AREA 2011
285 MONTEZUMA WETLANDS 2011
286 PITTSBURG POWER PLANT 2011
287 ALAMEDA POINT 2011
288 HAYWARD REGIONAL SHORELINE 2011
289 EDEN LANDING ECOLOGICAL RESERVE 2011
290 KETTLEMAN CITY 2011
291 OCEANO DUNES STATE VEHICULAR RECREATION AREA 2011
292 RANCHO GUADALUPE DUNES PRESERVE 2011
293 VANDENBERG SFB 2011
294 COAL OIL POINT RESERVE 2011
295 SANTA CLARA RIVER MCGRATH STATE BEACH 2011
296 HOLLYWOOD BEACH 2011
297 ORMOND BEACH 2011
298 NBVC POINT MUGU 2011
299 VENICE BEACH 2011
300 LA HARBOR 2011
301 SEAL BEACH NWR ANAHEIM BAY 2011
302 BOLSA CHICA ECOLOGICAL RESERVE 2011
303 HUNTINGTON STATE BEACH 2011
304 BURRIS ISLAND 2011
305 UPPER NEWPORT BAY ECOLOGICAL RESERVE 2011
306 MCB CAMP PENDLETON 2011
307 BATIQUITOS LAGOON ECOLOGICAL RESERVE 2011
308 SAN ELIJO LAGOON ECOLOGICAL RESERVE 2011
309 FAIRBANKS RANCH 2011
310 SAN DIEGUITO LAGOON ECOLOGICAL RESERVE 2011
311 MISSION BAY FAA ISLAND 2011
312 MISSION BAY NORTH FIESTA ISLAND 2011
313 MISSION BAY MARINERS POINT 2011
314 MISSION BAY STONY POINT 2011
315 MISSION BAY SAN DIEGO RIVER MOUTH 2011
316 SDIA LINDBERGH FIELD 2011
317 NAS NORTH ISLAND 2011
318 NAVAL AMPHIBIOUS BASE CORONADO 2011
319 DSTREET FILL SWEETWATER MARSH NWR 2011
320 CHULA VISTA WILDLIFE RESERVE 2011
321 SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS 2011
322 TIJUANA ESTUARY NERR 2011
323 SALTON SEA 2011
324 SACRAMENTO BUFFERLANDS 2012
325 NAPA SONOMA MARSH WILDLIFE AREA 2012
326 MONTEZUMA WETLANDS 2012
327 PITTSBURG POWER PLANT 2012
328 ALAMEDA POINT 2012
329 HAYWARD REGIONAL SHORELINE 2012
330 EDEN LANDING ECOLOGICAL RESERVE 2012
331 KETTLEMAN CITY 2012
332 OCEANO DUNES STATE VEHICULAR RECREATION AREA 2012
333 RANCHO GUADALUPE DUNES PRESERVE 2012
334 VANDENBERG SFB 2012
335 COAL OIL POINT RESERVE 2012
336 SANTA CLARA RIVER MCGRATH STATE BEACH 2012
337 HOLLYWOOD BEACH 2012
338 ORMOND BEACH 2012
339 NBVC POINT MUGU 2012
340 VENICE BEACH 2012
341 LA HARBOR 2012
342 SEAL BEACH NWR ANAHEIM BAY 2012
343 BOLSA CHICA ECOLOGICAL RESERVE 2012
344 HUNTINGTON STATE BEACH 2012
345 BURRIS ISLAND 2012
346 UPPER NEWPORT BAY ECOLOGICAL RESERVE 2012
347 MCB CAMP PENDLETON 2012
348 BATIQUITOS LAGOON ECOLOGICAL RESERVE 2012
349 SAN ELIJO LAGOON ECOLOGICAL RESERVE 2012
350 FAIRBANKS RANCH 2012
351 SAN DIEGUITO LAGOON ECOLOGICAL RESERVE 2012
352 MISSION BAY FAA ISLAND 2012
353 MISSION BAY NORTH FIESTA ISLAND 2012
354 MISSION BAY MARINERS POINT 2012
355 MISSION BAY STONY POINT 2012
356 MISSION BAY SAN DIEGO RIVER MOUTH 2012
357 SDIA LINDBERGH FIELD 2012
358 NAS NORTH ISLAND 2012
359 NAVAL AMPHIBIOUS BASE CORONADO 2012
360 DSTREET FILL SWEETWATER MARSH NWR 2012
361 CHULA VISTA WILDLIFE RESERVE 2012
362 SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS 2012
363 TIJUANA ESTUARY NERR 2012
364 SALTON SEA 2012
365 SACRAMENTO BUFFERLANDS 2013
366 NAPA SONOMA MARSH WILDLIFE AREA 2013
367 MONTEZUMA WETLANDS 2013
368 PITTSBURG POWER PLANT 2013
369 ALAMEDA POINT 2013
370 HAYWARD REGIONAL SHORELINE 2013
371 EDEN LANDING ECOLOGICAL RESERVE 2013
372 KETTLEMAN CITY 2013
373 OCEANO DUNES STATE VEHICULAR RECREATION AREA 2013
374 RANCHO GUADALUPE DUNES PRESERVE 2013
375 VANDENBERG SFB 2013
376 COAL OIL POINT RESERVE 2013
377 SANTA CLARA RIVER MCGRATH STATE BEACH 2013
378 HOLLYWOOD BEACH 2013
379 ORMOND BEACH 2013
380 NBVC POINT MUGU 2013
381 SATICOY UNITED WATER CONSERVATION DISTRICT 2013
382 VENICE BEACH 2013
383 LA HARBOR 2013
384 SEAL BEACH NWR ANAHEIM BAY 2013
385 BOLSA CHICA ECOLOGICAL RESERVE 2013
386 HUNTINGTON STATE BEACH 2013
387 BURRIS ISLAND 2013
388 UPPER NEWPORT BAY ECOLOGICAL RESERVE 2013
389 MCB CAMP PENDLETON 2013
390 BATIQUITOS LAGOON ECOLOGICAL RESERVE 2013
391 SAN ELIJO LAGOON ECOLOGICAL RESERVE 2013
392 FAIRBANKS RANCH 2013
393 SAN DIEGUITO LAGOON ECOLOGICAL RESERVE 2013
394 MISSION BAY FAA ISLAND 2013
395 MISSION BAY NORTH FIESTA ISLAND 2013
396 MISSION BAY MARINERS POINT 2013
397 MISSION BAY STONY POINT 2013
398 MISSION BAY SAN DIEGO RIVER MOUTH 2013
399 SDIA LINDBERGH FIELD 2013
400 NAS NORTH ISLAND 2013
401 NAVAL AMPHIBIOUS BASE CORONADO 2013
402 DSTREET FILL SWEETWATER MARSH NWR 2013
403 CHULA VISTA WILDLIFE RESERVE 2013
404 SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS 2013
405 TIJUANA ESTUARY NERR 2013
406 SALTON SEA 2013
407 SACRAMENTO BUFFERLANDS 2014
408 NAPA SONOMA MARSH WILDLIFE AREA 2014
409 MONTEZUMA WETLANDS 2014
410 PITTSBURG POWER PLANT 2014
411 ALAMEDA POINT 2014
412 HAYWARD REGIONAL SHORELINE 2014
413 EDEN LANDING ECOLOGICAL RESERVE 2014
414 KETTLEMAN CITY 2014
415 OCEANO DUNES STATE VEHICULAR RECREATION AREA 2014
416 RANCHO GUADALUPE DUNES PRESERVE 2014
417 VANDENBERG SFB 2014
418 COAL OIL POINT RESERVE 2014
419 SANTA CLARA RIVER MCGRATH STATE BEACH 2014
420 HOLLYWOOD BEACH 2014
421 ORMOND BEACH 2014
422 NBVC POINT MUGU 2014
423 SATICOY UNITED WATER CONSERVATION DISTRICT 2014
424 VENICE BEACH 2014
425 LA HARBOR 2014
426 SEAL BEACH NWR ANAHEIM BAY 2014
427 BOLSA CHICA ECOLOGICAL RESERVE 2014
428 HUNTINGTON STATE BEACH 2014
429 BURRIS ISLAND 2014
430 UPPER NEWPORT BAY ECOLOGICAL RESERVE 2014
431 MCB CAMP PENDLETON 2014
432 BATIQUITOS LAGOON ECOLOGICAL RESERVE 2014
433 SAN ELIJO LAGOON ECOLOGICAL RESERVE 2014
434 FAIRBANKS RANCH 2014
435 SAN DIEGUITO LAGOON ECOLOGICAL RESERVE 2014
436 MISSION BAY FAA ISLAND 2014
437 MISSION BAY NORTH FIESTA ISLAND 2014
438 MISSION BAY MARINERS POINT 2014
439 MISSION BAY STONY POINT 2014
440 MISSION BAY SAN DIEGO RIVER MOUTH 2014
441 SDIA LINDBERGH FIELD 2014
442 NAS NORTH ISLAND 2014
443 NAVAL AMPHIBIOUS BASE CORONADO 2014
444 DSTREET FILL SWEETWATER MARSH NWR 2014
445 CHULA VISTA WILDLIFE RESERVE 2014
446 SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS 2014
447 TIJUANA ESTUARY NERR 2014
448 SALTON SEA 2014
449 SACRAMENTO BUFFERLANDS 2015
450 NAPA SONOMA MARSH WILDLIFE AREA 2015
451 MONTEZUMA WETLANDS 2015
452 PITTSBURG POWER PLANT 2015
453 ALAMEDA POINT 2015
454 HAYWARD REGIONAL SHORELINE 2015
455 EDEN LANDING ECOLOGICAL RESERVE 2015
456 KETTLEMAN CITY 2015
457 OCEANO DUNES STATE VEHICULAR RECREATION AREA 2015
458 RANCHO GUADALUPE DUNES PRESERVE 2015
459 VANDENBERG SFB 2015
460 COAL OIL POINT RESERVE 2015
461 SANTA CLARA RIVER MCGRATH STATE BEACH 2015
462 HOLLYWOOD BEACH 2015
463 ORMOND BEACH 2015
464 NBVC POINT MUGU 2015
465 SATICOY UNITED WATER CONSERVATION DISTRICT 2015
466 VENICE BEACH 2015
467 LA HARBOR 2015
468 SEAL BEACH NWR ANAHEIM BAY 2015
469 BOLSA CHICA ECOLOGICAL RESERVE 2015
470 HUNTINGTON STATE BEACH 2015
471 BURRIS ISLAND 2015
472 UPPER NEWPORT BAY ECOLOGICAL RESERVE 2015
473 MCB CAMP PENDLETON 2015
474 BATIQUITOS LAGOON ECOLOGICAL RESERVE 2015
475 SAN ELIJO LAGOON ECOLOGICAL RESERVE 2015
476 FAIRBANKS RANCH 2015
477 SAN DIEGUITO LAGOON ECOLOGICAL RESERVE 2015
478 MISSION BAY FAA ISLAND 2015
479 MISSION BAY NORTH FIESTA ISLAND 2015
480 MISSION BAY MARINERS POINT 2015
481 MISSION BAY STONY POINT 2015
482 MISSION BAY SAN DIEGO RIVER MOUTH 2015
483 SDIA LINDBERGH FIELD 2015
484 NAS NORTH ISLAND 2015
485 NAVAL AMPHIBIOUS BASE CORONADO 2015
486 DSTREET FILL SWEETWATER MARSH NWR 2015
487 CHULA VISTA WILDLIFE RESERVE 2015
488 SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS 2015
489 TIJUANA ESTUARY NERR 2015
490 SALTON SEA 2015
491 SACRAMENTO BUFFERLANDS 2016
492 NAPA SONOMA MARSH WILDLIFE AREA 2016
493 MONTEZUMA WETLANDS 2016
494 PITTSBURG POWER PLANT 2016
495 ALAMEDA POINT 2016
496 HAYWARD REGIONAL SHORELINE 2016
497 EDEN LANDING ECOLOGICAL RESERVE 2016
498 KETTLEMAN CITY 2016
499 OCEANO DUNES STATE VEHICULAR RECREATION AREA 2016
500 RANCHO GUADALUPE DUNES PRESERVE 2016
501 VANDENBERG SFB 2016
502 COAL OIL POINT RESERVE 2016
503 SANTA CLARA RIVER MCGRATH STATE BEACH 2016
504 HOLLYWOOD BEACH 2016
505 ORMOND BEACH 2016
506 NBVC POINT MUGU 2016
507 SATICOY UNITED WATER CONSERVATION DISTRICT 2016
508 VENICE BEACH 2016
509 LA HARBOR 2016
510 SEAL BEACH NWR ANAHEIM BAY 2016
511 BOLSA CHICA ECOLOGICAL RESERVE 2016
512 HUNTINGTON STATE BEACH 2016
513 ANAHEIM LAKE 2016
514 BURRIS ISLAND 2016
515 UPPER NEWPORT BAY ECOLOGICAL RESERVE 2016
516 MCB CAMP PENDLETON 2016
517 BATIQUITOS LAGOON ECOLOGICAL RESERVE 2016
518 SAN ELIJO LAGOON ECOLOGICAL RESERVE 2016
519 FAIRBANKS RANCH 2016
520 SAN DIEGUITO LAGOON ECOLOGICAL RESERVE 2016
521 MISSION BAY FAA ISLAND 2016
522 MISSION BAY NORTH FIESTA ISLAND 2016
523 MISSION BAY MARINERS POINT 2016
524 MISSION BAY STONY POINT 2016
525 MISSION BAY SAN DIEGO RIVER MOUTH 2016
526 SDIA LINDBERGH FIELD 2016
527 NAS NORTH ISLAND 2016
528 NAVAL AMPHIBIOUS BASE CORONADO 2016
529 DSTREET FILL SWEETWATER MARSH NWR 2016
530 CHULA VISTA WILDLIFE RESERVE 2016
531 SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS 2016
532 TIJUANA ESTUARY NERR 2016
533 SALTON SEA 2016
534 SACRAMENTO BUFFERLANDS 2017
535 NAPA SONOMA MARSH WILDLIFE AREA 2017
536 MONTEZUMA WETLANDS 2017
537 PITTSBURG POWER PLANT 2017
538 ALAMEDA POINT 2017
539 HAYWARD REGIONAL SHORELINE 2017
540 EDEN LANDING ECOLOGICAL RESERVE 2017
541 KETTLEMAN CITY 2017
542 OCEANO DUNES STATE VEHICULAR RECREATION AREA 2017
543 RANCHO GUADALUPE DUNES PRESERVE 2017
544 GUADALUPE NIPOMO DUNES NWR 2017
545 VANDENBERG SFB 2017
546 COAL OIL POINT RESERVE 2017
547 SANTA CLARA RIVER MCGRATH STATE BEACH 2017
548 HOLLYWOOD BEACH 2017
549 ORMOND BEACH 2017
550 NBVC POINT MUGU 2017
551 SATICOY UNITED WATER CONSERVATION DISTRICT 2017
552 VENICE BEACH 2017
553 MALIBU LAGOON 2017
554 LA HARBOR 2017
555 SEAL BEACH NWR ANAHEIM BAY 2017
556 BOLSA CHICA ECOLOGICAL RESERVE 2017
557 HUNTINGTON STATE BEACH 2017
558 ANAHEIM LAKE 2017
559 BURRIS ISLAND 2017
560 UPPER NEWPORT BAY ECOLOGICAL RESERVE 2017
561 MCB CAMP PENDLETON 2017
562 BATIQUITOS LAGOON ECOLOGICAL RESERVE 2017
563 SAN ELIJO LAGOON ECOLOGICAL RESERVE 2017
564 FAIRBANKS RANCH 2017
565 SAN DIEGUITO LAGOON ECOLOGICAL RESERVE 2017
566 MISSION BAY FAA ISLAND 2017
567 MISSION BAY NORTH FIESTA ISLAND 2017
568 MISSION BAY MARINERS POINT 2017
569 MISSION BAY STONY POINT 2017
570 MISSION BAY SAN DIEGO RIVER MOUTH 2017
571 SDIA LINDBERGH FIELD 2017
572 NAS NORTH ISLAND 2017
573 NAVAL AMPHIBIOUS BASE CORONADO 2017
574 DSTREET FILL SWEETWATER MARSH NWR 2017
575 CHULA VISTA WILDLIFE RESERVE 2017
576 SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS 2017
577 TIJUANA ESTUARY NERR 2017
578 SALTON SEA 2017
579 NAPA SONOMA MARSH WILDLIFE AREA 2018
580 MONTEZUMA WETLANDS 2018
581 ALAMEDA POINT 2018
582 HAYWARD REGIONAL SHORELINE 2018
583 EDEN LANDING ECOLOGICAL RESERVE 2018
584 OCEANO DUNES STATE VEHICULAR RECREATION AREA 2018
585 VANDENBERG SFB 2018
586 SANTA CLARA RIVER MCGRATH STATE BEACH 2018
587 HOLLYWOOD BEACH 2018
588 ORMOND BEACH 2018
589 NBVC POINT MUGU 2018
590 SATICOY UNITED WATER CONSERVATION DISTRICT 2018
591 VENICE BEACH 2018
592 MALIBU LAGOON 2018
593 LA HARBOR 2018
594 SEAL BEACH NWR ANAHEIM BAY 2018
595 BOLSA CHICA ECOLOGICAL RESERVE 2018
596 HUNTINGTON STATE BEACH 2018
597 BURRIS ISLAND 2018
598 UPPER NEWPORT BAY ECOLOGICAL RESERVE 2018
599 MCB CAMP PENDLETON 2018
600 BATIQUITOS LAGOON ECOLOGICAL RESERVE 2018
601 SAN ELIJO LAGOON ECOLOGICAL RESERVE 2018
602 MISSION BAY FAA ISLAND 2018
603 MISSION BAY NORTH FIESTA ISLAND 2018
604 MISSION BAY MARINERS POINT 2018
605 MISSION BAY STONY POINT 2018
606 SDIA LINDBERGH FIELD 2018
607 NAS NORTH ISLAND 2018
608 NAVAL AMPHIBIOUS BASE CORONADO 2018
609 DSTREET FILL SWEETWATER MARSH NWR 2018
610 CHULA VISTA WILDLIFE RESERVE 2018
611 SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS 2018
612 TIJUANA ESTUARY NERR 2018
613 NAPA SONOMA MARSH WILDLIFE AREA 2019
614 MONTEZUMA WETLANDS 2019
615 ALAMEDA POINT 2019
616 HAYWARD REGIONAL SHORELINE 2019
617 EDEN LANDING ECOLOGICAL RESERVE 2019
618 OCEANO DUNES STATE VEHICULAR RECREATION AREA 2019
619 RANCHO GUADALUPE DUNES PRESERVE 2019
620 VANDENBERG SFB 2019
621 SANTA CLARA RIVER MCGRATH STATE BEACH 2019
622 HOLLYWOOD BEACH 2019
623 ORMOND BEACH 2019
624 NBVC POINT MUGU 2019
625 SATICOY UNITED WATER CONSERVATION DISTRICT 2019
626 VENICE BEACH 2019
627 MALIBU LAGOON 2019
628 LA HARBOR 2019
629 SEAL BEACH NWR ANAHEIM BAY 2019
630 BOLSA CHICA ECOLOGICAL RESERVE 2019
631 HUNTINGTON STATE BEACH 2019
632 BURRIS ISLAND 2019
633 UPPER NEWPORT BAY ECOLOGICAL RESERVE 2019
634 MCB CAMP PENDLETON 2019
635 BATIQUITOS LAGOON ECOLOGICAL RESERVE 2019
636 SAN ELIJO LAGOON ECOLOGICAL RESERVE 2019
637 MISSION BAY FAA ISLAND 2019
638 MISSION BAY NORTH FIESTA ISLAND 2019
639 MISSION BAY MARINERS POINT 2019
640 MISSION BAY STONY POINT 2019
641 SDIA LINDBERGH FIELD 2019
642 NAS NORTH ISLAND 2019
643 NAVAL AMPHIBIOUS BASE CORONADO 2019
644 DSTREET FILL SWEETWATER MARSH NWR 2019
645 CHULA VISTA WILDLIFE RESERVE 2019
646 SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS 2019
647 TIJUANA ESTUARY NERR 2019
648 NAPA SONOMA MARSH WILDLIFE AREA 2020
649 MONTEZUMA WETLANDS 2020
650 ALAMEDA POINT 2020
651 HAYWARD REGIONAL SHORELINE 2020
652 EDEN LANDING ECOLOGICAL RESERVE 2020
653 OCEANO DUNES STATE VEHICULAR RECREATION AREA 2020
654 RANCHO GUADALUPE DUNES PRESERVE 2020
655 VANDENBERG SFB 2020
656 SANTA CLARA RIVER MCGRATH STATE BEACH 2020
657 HOLLYWOOD BEACH 2020
658 ORMOND BEACH 2020
659 NBVC POINT MUGU 2020
660 SATICOY UNITED WATER CONSERVATION DISTRICT 2020
661 VENICE BEACH 2020
662 MALIBU LAGOON 2020
663 LA HARBOR 2020
664 SEAL BEACH NWR ANAHEIM BAY 2020
665 BOLSA CHICA ECOLOGICAL RESERVE 2020
666 HUNTINGTON STATE BEACH 2020
667 BURRIS ISLAND 2020
668 UPPER NEWPORT BAY ECOLOGICAL RESERVE 2020
669 MCB CAMP PENDLETON 2020
670 BATIQUITOS LAGOON ECOLOGICAL RESERVE 2020
671 SAN ELIJO LAGOON ECOLOGICAL RESERVE 2020
672 MISSION BAY FAA ISLAND 2020
673 MISSION BAY NORTH FIESTA ISLAND 2020
674 MISSION BAY MARINERS POINT 2020
675 MISSION BAY STONY POINT 2020
676 SDIA LINDBERGH FIELD 2020
677 NAS NORTH ISLAND 2020
678 NAVAL AMPHIBIOUS BASE CORONADO 2020
679 DSTREET FILL SWEETWATER MARSH NWR 2020
680 CHULA VISTA WILDLIFE RESERVE 2020
681 SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS 2020
682 TIJUANA ESTUARY NERR 2020
683 NAPA SONOMA MARSH WILDLIFE AREA 2021
684 SAN PABLO BAY NWR 2021
685 MONTEZUMA WETLANDS 2021
686 ALAMEDA POINT 2021
687 HAYWARD REGIONAL SHORELINE 2021
688 EDEN LANDING ECOLOGICAL RESERVE 2021
689 OCEANO DUNES STATE VEHICULAR RECREATION AREA 2021
690 RANCHO GUADALUPE DUNES PRESERVE 2021
691 VANDENBERG SFB 2021
692 SANTA CLARA RIVER MCGRATH STATE BEACH 2021
693 HOLLYWOOD BEACH 2021
694 ORMOND BEACH 2021
695 NBVC POINT MUGU 2021
696 SATICOY UNITED WATER CONSERVATION DISTRICT 2021
697 VENICE BEACH 2021
698 MALIBU LAGOON 2021
699 LA HARBOR 2021
700 SEAL BEACH NWR ANAHEIM BAY 2021
701 BOLSA CHICA ECOLOGICAL RESERVE 2021
702 HUNTINGTON STATE BEACH 2021
703 BURRIS ISLAND 2021
704 UPPER NEWPORT BAY ECOLOGICAL RESERVE 2021
705 MCB CAMP PENDLETON 2021
706 BATIQUITOS LAGOON ECOLOGICAL RESERVE 2021
707 SAN ELIJO LAGOON ECOLOGICAL RESERVE 2021
708 MISSION BAY FAA ISLAND 2021
709 MISSION BAY NORTH FIESTA ISLAND 2021
710 MISSION BAY MARINERS POINT 2021
711 MISSION BAY STONY POINT 2021
712 SDIA LINDBERGH FIELD 2021
713 NAS NORTH ISLAND 2021
714 NAVAL AMPHIBIOUS BASE CORONADO 2021
715 DSTREET FILL SWEETWATER MARSH NWR 2021
716 CHULA VISTA WILDLIFE RESERVE 2021
717 SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS 2021
718 TIJUANA ESTUARY NERR 2021
719 NAPA SONOMA MARSH WILDLIFE AREA 2022
720 SAN PABLO BAY NWR 2022
721 MONTEZUMA WETLANDS 2022
722 ALAMEDA POINT 2022
723 HAYWARD REGIONAL SHORELINE 2022
724 EDEN LANDING ECOLOGICAL RESERVE 2022
725 OCEANO DUNES STATE VEHICULAR RECREATION AREA 2022
726 RANCHO GUADALUPE DUNES PRESERVE 2022
727 VANDENBERG SFB 2022
728 SANTA CLARA RIVER MCGRATH STATE BEACH 2022
729 HOLLYWOOD BEACH 2022
730 ORMOND BEACH 2022
731 NBVC POINT MUGU 2022
732 VENICE BEACH 2022
733 MALIBU LAGOON 2022
734 LA HARBOR 2022
735 SEAL BEACH NWR ANAHEIM BAY 2022
736 BOLSA CHICA ECOLOGICAL RESERVE 2022
737 HUNTINGTON STATE BEACH 2022
738 BURRIS ISLAND 2022
739 UPPER NEWPORT BAY ECOLOGICAL RESERVE 2022
740 MCB CAMP PENDLETON 2022
741 BATIQUITOS LAGOON ECOLOGICAL RESERVE 2022
742 SAN ELIJO LAGOON ECOLOGICAL RESERVE 2022
743 SAN DIEGUITO LAGOON ECOLOGICAL RESERVE 2022
744 MISSION BAY FAA ISLAND 2022
745 MISSION BAY NORTH FIESTA ISLAND 2022
746 MISSION BAY MARINERS POINT 2022
747 MISSION BAY STONY POINT 2022
748 SDIA LINDBERGH FIELD 2022
749 NAS NORTH ISLAND 2022
750 NAVAL AMPHIBIOUS BASE CORONADO 2022
751 DSTREET FILL SWEETWATER MARSH NWR 2022
752 CHULA VISTA WILDLIFE RESERVE 2022
753 SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS 2022
754 TIJUANA ESTUARY NERR 2022
755 NAPA SONOMA MARSH WILDLIFE AREA 2023
756 SAN PABLO BAY NWR 2023
757 MONTEZUMA WETLANDS 2023
758 ALAMEDA POINT 2023
759 HAYWARD REGIONAL SHORELINE 2023
760 EDEN LANDING ECOLOGICAL RESERVE 2023
761 OCEANO DUNES STATE VEHICULAR RECREATION AREA 2023
762 RANCHO GUADALUPE DUNES PRESERVE 2023
763 VANDENBERG SFB 2023
764 SANTA CLARA RIVER MCGRATH STATE BEACH 2023
765 HOLLYWOOD BEACH 2023
766 ORMOND BEACH 2023
767 NBVC POINT MUGU 2023
768 VENICE BEACH 2023
769 MALIBU LAGOON 2023
770 LA HARBOR 2023
771 SEAL BEACH NWR ANAHEIM BAY 2023
772 BOLSA CHICA ECOLOGICAL RESERVE 2023
773 HUNTINGTON STATE BEACH 2023
774 ANAHEIM LAKE 2023
775 BURRIS ISLAND 2023
776 UPPER NEWPORT BAY ECOLOGICAL RESERVE 2023
777 MCB CAMP PENDLETON 2023
778 BATIQUITOS LAGOON ECOLOGICAL RESERVE 2023
779 SAN ELIJO LAGOON ECOLOGICAL RESERVE 2023
780 SAN DIEGUITO LAGOON ECOLOGICAL RESERVE 2023
781 MISSION BAY FAA ISLAND 2023
782 MISSION BAY NORTH FIESTA ISLAND 2023
783 MISSION BAY MARINERS POINT 2023
784 MISSION BAY STONY POINT 2023
785 SDIA LINDBERGH FIELD 2023
786 NAS NORTH ISLAND 2023
787 NAVAL AMPHIBIOUS BASE CORONADO 2023
788 DSTREET FILL SWEETWATER MARSH NWR 2023
789 CHULA VISTA WILDLIFE RESERVE 2023
790 SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS 2023
791 TIJUANA ESTUARY NERR 2023
Warning
In R, omitting an argument is different from leaving the argument blank. So these two expressions do different things despite looking similar:
terns[c("site_name", "year")]terns[c("site_name", "year"), ]The first selects the site_name and year columns. The second selects the site_name and year rows (which causes an error, since the least terns dataset doesn’t have row names).
There’s one more possibility:
terns[, c("site_name", "year")]Like the first expression, this selects the site_name and year columns. You can write the code either way. Some people prefer the first expression because it’s shorter, while others prefer this expression because it makes it clear that terns is two-dimensional.
You can select whatever combination of columns you want with the indexing operator, but it’s somewhat inconvenient if you need to select a lot of columns, because you typically have to type out all of their names. For example, suppose we want to select all of the columns in the least terns dataset whose name starts with nonpred_ (these are mortalities caused by something other than predation).
The dplyr package is a collection of functions that make working with data frames more convenient. Install and load the package if you want to follow along with this example:
# install.packages("dplyr")
library("dplyr")
Attaching package: 'dplyr'The following objects are masked from 'package:stats':
filter, lagThe following objects are masked from 'package:base':
intersect, setdiff, setequal, unionRemember that you only need to install each package once.
The dplyr package’s select function selects columns from a data frame. Unlike most of R’s built-in functions, the functions in dplyr don’t require quotes around column names. To select the site_name and year columns from the least terns dataset, you can write:
select(terns, site_name, year) site_name year
1 PITTSBURG POWER PLANT 2000
2 ALBANY CENTRAL AVE 2000
3 ALAMEDA POINT 2000
4 KETTLEMAN CITY 2000
5 OCEANO DUNES STATE VEHICULAR RECREATION AREA 2000
6 RANCHO GUADALUPE DUNES PRESERVE 2000
7 VANDENBERG SFB 2000
8 SANTA CLARA RIVER MCGRATH STATE BEACH 2000
9 ORMOND BEACH 2000
10 NBVC POINT MUGU 2000
11 VENICE BEACH 2000
12 LA HARBOR 2000
13 SEAL BEACH NWR ANAHEIM BAY 2000
14 BOLSA CHICA ECOLOGICAL RESERVE 2000
15 HUNTINGTON STATE BEACH 2000
16 UPPER NEWPORT BAY ECOLOGICAL RESERVE 2000
17 MCB CAMP PENDLETON 2000
18 BATIQUITOS LAGOON ECOLOGICAL RESERVE 2000
19 SAN ELIJO LAGOON ECOLOGICAL RESERVE 2000
20 MISSION BAY FAA ISLAND 2000
21 MISSION BAY NORTH FIESTA ISLAND 2000
22 MISSION BAY MARINERS POINT 2000
23 SDIA LINDBERGH FIELD 2000
24 NAS NORTH ISLAND 2000
25 NAVAL AMPHIBIOUS BASE CORONADO 2000
26 DSTREET FILL SWEETWATER MARSH NWR 2000
27 CHULA VISTA WILDLIFE RESERVE 2000
28 SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS 2000
29 TIJUANA ESTUARY NERR 2000
30 PITTSBURG POWER PLANT 2004
31 ALBANY CENTRAL AVE 2004
32 ALAMEDA POINT 2004
33 KETTLEMAN CITY 2004
34 OCEANO DUNES STATE VEHICULAR RECREATION AREA 2004
35 RANCHO GUADALUPE DUNES PRESERVE 2004
36 VANDENBERG SFB 2004
37 COAL OIL POINT RESERVE 2004
38 SANTA CLARA RIVER MCGRATH STATE BEACH 2004
39 HOLLYWOOD BEACH 2004
40 ORMOND BEACH 2004
41 NBVC POINT MUGU 2004
42 VENICE BEACH 2004
43 LA HARBOR 2004
44 SEAL BEACH NWR ANAHEIM BAY 2004
45 BOLSA CHICA ECOLOGICAL RESERVE 2004
46 HUNTINGTON STATE BEACH 2004
47 BURRIS ISLAND 2004
48 UPPER NEWPORT BAY ECOLOGICAL RESERVE 2004
49 MCB CAMP PENDLETON 2004
50 BATIQUITOS LAGOON ECOLOGICAL RESERVE 2004
51 SAN ELIJO LAGOON ECOLOGICAL RESERVE 2004
52 MISSION BAY FAA ISLAND 2004
53 MISSION BAY NORTH FIESTA ISLAND 2004
54 MISSION BAY MARINERS POINT 2004
55 MISSION BAY SAN DIEGO RIVER MOUTH 2004
56 SDIA LINDBERGH FIELD 2004
57 NAS NORTH ISLAND 2004
58 NAVAL AMPHIBIOUS BASE CORONADO 2004
59 SILVER STRAND STATE BEACH 2004
60 DSTREET FILL SWEETWATER MARSH NWR 2004
61 CHULA VISTA WILDLIFE RESERVE 2004
62 SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS 2004
63 TIJUANA ESTUARY NERR 2004
64 PITTSBURG POWER PLANT 2005
65 ALAMEDA POINT 2005
66 HAYWARD REGIONAL SHORELINE 2005
67 KETTLEMAN CITY 2005
68 OCEANO DUNES STATE VEHICULAR RECREATION AREA 2005
69 RANCHO GUADALUPE DUNES PRESERVE 2005
70 VANDENBERG SFB 2005
71 COAL OIL POINT RESERVE 2005
72 SANTA CLARA RIVER MCGRATH STATE BEACH 2005
73 ORMOND BEACH 2005
74 NBVC POINT MUGU 2005
75 VENICE BEACH 2005
76 LA HARBOR 2005
77 SEAL BEACH NWR ANAHEIM BAY 2005
78 BOLSA CHICA ECOLOGICAL RESERVE 2005
79 HUNTINGTON STATE BEACH 2005
80 UPPER NEWPORT BAY ECOLOGICAL RESERVE 2005
81 MCB CAMP PENDLETON 2005
82 BATIQUITOS LAGOON ECOLOGICAL RESERVE 2005
83 SAN ELIJO LAGOON ECOLOGICAL RESERVE 2005
84 MISSION BAY FAA ISLAND 2005
85 MISSION BAY NORTH FIESTA ISLAND 2005
86 MISSION BAY MARINERS POINT 2005
87 MISSION BAY SAN DIEGO RIVER MOUTH 2005
88 SDIA LINDBERGH FIELD 2005
89 NAS NORTH ISLAND 2005
90 NAVAL AMPHIBIOUS BASE CORONADO 2005
91 DSTREET FILL SWEETWATER MARSH NWR 2005
92 CHULA VISTA WILDLIFE RESERVE 2005
93 SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS 2005
94 TIJUANA ESTUARY NERR 2005
95 MONTEZUMA WETLANDS 2006
96 PITTSBURG POWER PLANT 2006
97 ALAMEDA POINT 2006
98 HAYWARD REGIONAL SHORELINE 2006
99 KETTLEMAN CITY 2006
100 OCEANO DUNES STATE VEHICULAR RECREATION AREA 2006
101 RANCHO GUADALUPE DUNES PRESERVE 2006
102 VANDENBERG SFB 2006
103 COAL OIL POINT RESERVE 2006
104 SANTA CLARA RIVER MCGRATH STATE BEACH 2006
105 ORMOND BEACH 2006
106 NBVC POINT MUGU 2006
107 VENICE BEACH 2006
108 LA HARBOR 2006
109 SEAL BEACH NWR ANAHEIM BAY 2006
110 BOLSA CHICA ECOLOGICAL RESERVE 2006
111 HUNTINGTON STATE BEACH 2006
112 UPPER NEWPORT BAY ECOLOGICAL RESERVE 2006
113 MCB CAMP PENDLETON 2006
114 BATIQUITOS LAGOON ECOLOGICAL RESERVE 2006
115 SAN ELIJO LAGOON ECOLOGICAL RESERVE 2006
116 MISSION BAY FAA ISLAND 2006
117 MISSION BAY NORTH FIESTA ISLAND 2006
118 MISSION BAY MARINERS POINT 2006
119 MISSION BAY STONY POINT 2006
120 MISSION BAY SAN DIEGO RIVER MOUTH 2006
121 SDIA LINDBERGH FIELD 2006
122 NAS NORTH ISLAND 2006
123 NAVAL AMPHIBIOUS BASE CORONADO 2006
124 DSTREET FILL SWEETWATER MARSH NWR 2006
125 CHULA VISTA WILDLIFE RESERVE 2006
126 SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS 2006
127 TIJUANA ESTUARY NERR 2006
128 NAPA SONOMA MARSH WILDLIFE AREA 2007
129 MONTEZUMA WETLANDS 2007
130 PITTSBURG POWER PLANT 2007
131 ALAMEDA POINT 2007
132 HAYWARD REGIONAL SHORELINE 2007
133 EDEN LANDING ECOLOGICAL RESERVE 2007
134 KETTLEMAN CITY 2007
135 OCEANO DUNES STATE VEHICULAR RECREATION AREA 2007
136 RANCHO GUADALUPE DUNES PRESERVE 2007
137 VANDENBERG SFB 2007
138 COAL OIL POINT RESERVE 2007
139 SANTA CLARA RIVER MCGRATH STATE BEACH 2007
140 HOLLYWOOD BEACH 2007
141 ORMOND BEACH 2007
142 NBVC POINT MUGU 2007
143 VENICE BEACH 2007
144 LA HARBOR 2007
145 SEAL BEACH NWR ANAHEIM BAY 2007
146 BOLSA CHICA ECOLOGICAL RESERVE 2007
147 HUNTINGTON STATE BEACH 2007
148 BURRIS ISLAND 2007
149 UPPER NEWPORT BAY ECOLOGICAL RESERVE 2007
150 MCB CAMP PENDLETON 2007
151 BATIQUITOS LAGOON ECOLOGICAL RESERVE 2007
152 SAN ELIJO LAGOON ECOLOGICAL RESERVE 2007
153 MISSION BAY FAA ISLAND 2007
154 MISSION BAY NORTH FIESTA ISLAND 2007
155 MISSION BAY MARINERS POINT 2007
156 MISSION BAY STONY POINT 2007
157 MISSION BAY SAN DIEGO RIVER MOUTH 2007
158 SDIA LINDBERGH FIELD 2007
159 NAS NORTH ISLAND 2007
160 NAVAL AMPHIBIOUS BASE CORONADO 2007
161 DSTREET FILL SWEETWATER MARSH NWR 2007
162 CHULA VISTA WILDLIFE RESERVE 2007
163 SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS 2007
164 TIJUANA ESTUARY NERR 2007
165 SACRAMENTO BUFFERLANDS 2008
166 NAPA SONOMA MARSH WILDLIFE AREA 2008
167 MONTEZUMA WETLANDS 2008
168 PITTSBURG POWER PLANT 2008
169 ALAMEDA POINT 2008
170 HAYWARD REGIONAL SHORELINE 2008
171 EDEN LANDING ECOLOGICAL RESERVE 2008
172 KETTLEMAN CITY 2008
173 OCEANO DUNES STATE VEHICULAR RECREATION AREA 2008
174 RANCHO GUADALUPE DUNES PRESERVE 2008
175 VANDENBERG SFB 2008
176 COAL OIL POINT RESERVE 2008
177 SANTA CLARA RIVER MCGRATH STATE BEACH 2008
178 HOLLYWOOD BEACH 2008
179 ORMOND BEACH 2008
180 NBVC POINT MUGU 2008
181 VENICE BEACH 2008
182 LA HARBOR 2008
183 SEAL BEACH NWR ANAHEIM BAY 2008
184 BOLSA CHICA ECOLOGICAL RESERVE 2008
185 HUNTINGTON STATE BEACH 2008
186 BURRIS ISLAND 2008
187 UPPER NEWPORT BAY ECOLOGICAL RESERVE 2008
188 MCB CAMP PENDLETON 2008
189 BATIQUITOS LAGOON ECOLOGICAL RESERVE 2008
190 SAN ELIJO LAGOON ECOLOGICAL RESERVE 2008
191 MISSION BAY FAA ISLAND 2008
192 MISSION BAY NORTH FIESTA ISLAND 2008
193 MISSION BAY MARINERS POINT 2008
194 MISSION BAY STONY POINT 2008
195 MISSION BAY SAN DIEGO RIVER MOUTH 2008
196 SDIA LINDBERGH FIELD 2008
197 NAS NORTH ISLAND 2008
198 NAVAL AMPHIBIOUS BASE CORONADO 2008
199 DSTREET FILL SWEETWATER MARSH NWR 2008
200 CHULA VISTA WILDLIFE RESERVE 2008
201 SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS 2008
202 TIJUANA ESTUARY NERR 2008
203 SACRAMENTO BUFFERLANDS 2009
204 NAPA SONOMA MARSH WILDLIFE AREA 2009
205 MONTEZUMA WETLANDS 2009
206 PITTSBURG POWER PLANT 2009
207 ALAMEDA POINT 2009
208 HAYWARD REGIONAL SHORELINE 2009
209 EDEN LANDING ECOLOGICAL RESERVE 2009
210 KETTLEMAN CITY 2009
211 OCEANO DUNES STATE VEHICULAR RECREATION AREA 2009
212 RANCHO GUADALUPE DUNES PRESERVE 2009
213 VANDENBERG SFB 2009
214 COAL OIL POINT RESERVE 2009
215 SANTA CLARA RIVER MCGRATH STATE BEACH 2009
216 HOLLYWOOD BEACH 2009
217 ORMOND BEACH 2009
218 NBVC POINT MUGU 2009
219 VENICE BEACH 2009
220 LA HARBOR 2009
221 SEAL BEACH NWR ANAHEIM BAY 2009
222 BOLSA CHICA ECOLOGICAL RESERVE 2009
223 HUNTINGTON STATE BEACH 2009
224 BURRIS ISLAND 2009
225 UPPER NEWPORT BAY ECOLOGICAL RESERVE 2009
226 MCB CAMP PENDLETON 2009
227 BATIQUITOS LAGOON ECOLOGICAL RESERVE 2009
228 SAN ELIJO LAGOON ECOLOGICAL RESERVE 2009
229 FAIRBANKS RANCH 2009
230 MISSION BAY FAA ISLAND 2009
231 MISSION BAY NORTH FIESTA ISLAND 2009
232 MISSION BAY MARINERS POINT 2009
233 MISSION BAY STONY POINT 2009
234 MISSION BAY SAN DIEGO RIVER MOUTH 2009
235 SDIA LINDBERGH FIELD 2009
236 NAS NORTH ISLAND 2009
237 NAVAL AMPHIBIOUS BASE CORONADO 2009
238 DSTREET FILL SWEETWATER MARSH NWR 2009
239 CHULA VISTA WILDLIFE RESERVE 2009
240 SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS 2009
241 TIJUANA ESTUARY NERR 2009
242 ARIZONA GLENDALE 2009
243 SACRAMENTO BUFFERLANDS 2010
244 NAPA SONOMA MARSH WILDLIFE AREA 2010
245 MONTEZUMA WETLANDS 2010
246 PITTSBURG POWER PLANT 2010
247 ALAMEDA POINT 2010
248 HAYWARD REGIONAL SHORELINE 2010
249 EDEN LANDING ECOLOGICAL RESERVE 2010
250 KETTLEMAN CITY 2010
251 OCEANO DUNES STATE VEHICULAR RECREATION AREA 2010
252 RANCHO GUADALUPE DUNES PRESERVE 2010
253 VANDENBERG SFB 2010
254 COAL OIL POINT RESERVE 2010
255 SANTA CLARA RIVER MCGRATH STATE BEACH 2010
256 HOLLYWOOD BEACH 2010
257 ORMOND BEACH 2010
258 NBVC POINT MUGU 2010
259 VENICE BEACH 2010
260 LA HARBOR 2010
261 SEAL BEACH NWR ANAHEIM BAY 2010
262 BOLSA CHICA ECOLOGICAL RESERVE 2010
263 HUNTINGTON STATE BEACH 2010
264 BURRIS ISLAND 2010
265 UPPER NEWPORT BAY ECOLOGICAL RESERVE 2010
266 MCB CAMP PENDLETON 2010
267 BATIQUITOS LAGOON ECOLOGICAL RESERVE 2010
268 SAN ELIJO LAGOON ECOLOGICAL RESERVE 2010
269 FAIRBANKS RANCH 2010
270 SAN DIEGUITO LAGOON ECOLOGICAL RESERVE 2010
271 MISSION BAY FAA ISLAND 2010
272 MISSION BAY NORTH FIESTA ISLAND 2010
273 MISSION BAY MARINERS POINT 2010
274 MISSION BAY STONY POINT 2010
275 MISSION BAY SAN DIEGO RIVER MOUTH 2010
276 SDIA LINDBERGH FIELD 2010
277 NAS NORTH ISLAND 2010
278 NAVAL AMPHIBIOUS BASE CORONADO 2010
279 DSTREET FILL SWEETWATER MARSH NWR 2010
280 CHULA VISTA WILDLIFE RESERVE 2010
281 SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS 2010
282 TIJUANA ESTUARY NERR 2010
283 SACRAMENTO BUFFERLANDS 2011
284 NAPA SONOMA MARSH WILDLIFE AREA 2011
285 MONTEZUMA WETLANDS 2011
286 PITTSBURG POWER PLANT 2011
287 ALAMEDA POINT 2011
288 HAYWARD REGIONAL SHORELINE 2011
289 EDEN LANDING ECOLOGICAL RESERVE 2011
290 KETTLEMAN CITY 2011
291 OCEANO DUNES STATE VEHICULAR RECREATION AREA 2011
292 RANCHO GUADALUPE DUNES PRESERVE 2011
293 VANDENBERG SFB 2011
294 COAL OIL POINT RESERVE 2011
295 SANTA CLARA RIVER MCGRATH STATE BEACH 2011
296 HOLLYWOOD BEACH 2011
297 ORMOND BEACH 2011
298 NBVC POINT MUGU 2011
299 VENICE BEACH 2011
300 LA HARBOR 2011
301 SEAL BEACH NWR ANAHEIM BAY 2011
302 BOLSA CHICA ECOLOGICAL RESERVE 2011
303 HUNTINGTON STATE BEACH 2011
304 BURRIS ISLAND 2011
305 UPPER NEWPORT BAY ECOLOGICAL RESERVE 2011
306 MCB CAMP PENDLETON 2011
307 BATIQUITOS LAGOON ECOLOGICAL RESERVE 2011
308 SAN ELIJO LAGOON ECOLOGICAL RESERVE 2011
309 FAIRBANKS RANCH 2011
310 SAN DIEGUITO LAGOON ECOLOGICAL RESERVE 2011
311 MISSION BAY FAA ISLAND 2011
312 MISSION BAY NORTH FIESTA ISLAND 2011
313 MISSION BAY MARINERS POINT 2011
314 MISSION BAY STONY POINT 2011
315 MISSION BAY SAN DIEGO RIVER MOUTH 2011
316 SDIA LINDBERGH FIELD 2011
317 NAS NORTH ISLAND 2011
318 NAVAL AMPHIBIOUS BASE CORONADO 2011
319 DSTREET FILL SWEETWATER MARSH NWR 2011
320 CHULA VISTA WILDLIFE RESERVE 2011
321 SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS 2011
322 TIJUANA ESTUARY NERR 2011
323 SALTON SEA 2011
324 SACRAMENTO BUFFERLANDS 2012
325 NAPA SONOMA MARSH WILDLIFE AREA 2012
326 MONTEZUMA WETLANDS 2012
327 PITTSBURG POWER PLANT 2012
328 ALAMEDA POINT 2012
329 HAYWARD REGIONAL SHORELINE 2012
330 EDEN LANDING ECOLOGICAL RESERVE 2012
331 KETTLEMAN CITY 2012
332 OCEANO DUNES STATE VEHICULAR RECREATION AREA 2012
333 RANCHO GUADALUPE DUNES PRESERVE 2012
334 VANDENBERG SFB 2012
335 COAL OIL POINT RESERVE 2012
336 SANTA CLARA RIVER MCGRATH STATE BEACH 2012
337 HOLLYWOOD BEACH 2012
338 ORMOND BEACH 2012
339 NBVC POINT MUGU 2012
340 VENICE BEACH 2012
341 LA HARBOR 2012
342 SEAL BEACH NWR ANAHEIM BAY 2012
343 BOLSA CHICA ECOLOGICAL RESERVE 2012
344 HUNTINGTON STATE BEACH 2012
345 BURRIS ISLAND 2012
346 UPPER NEWPORT BAY ECOLOGICAL RESERVE 2012
347 MCB CAMP PENDLETON 2012
348 BATIQUITOS LAGOON ECOLOGICAL RESERVE 2012
349 SAN ELIJO LAGOON ECOLOGICAL RESERVE 2012
350 FAIRBANKS RANCH 2012
351 SAN DIEGUITO LAGOON ECOLOGICAL RESERVE 2012
352 MISSION BAY FAA ISLAND 2012
353 MISSION BAY NORTH FIESTA ISLAND 2012
354 MISSION BAY MARINERS POINT 2012
355 MISSION BAY STONY POINT 2012
356 MISSION BAY SAN DIEGO RIVER MOUTH 2012
357 SDIA LINDBERGH FIELD 2012
358 NAS NORTH ISLAND 2012
359 NAVAL AMPHIBIOUS BASE CORONADO 2012
360 DSTREET FILL SWEETWATER MARSH NWR 2012
361 CHULA VISTA WILDLIFE RESERVE 2012
362 SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS 2012
363 TIJUANA ESTUARY NERR 2012
364 SALTON SEA 2012
365 SACRAMENTO BUFFERLANDS 2013
366 NAPA SONOMA MARSH WILDLIFE AREA 2013
367 MONTEZUMA WETLANDS 2013
368 PITTSBURG POWER PLANT 2013
369 ALAMEDA POINT 2013
370 HAYWARD REGIONAL SHORELINE 2013
371 EDEN LANDING ECOLOGICAL RESERVE 2013
372 KETTLEMAN CITY 2013
373 OCEANO DUNES STATE VEHICULAR RECREATION AREA 2013
374 RANCHO GUADALUPE DUNES PRESERVE 2013
375 VANDENBERG SFB 2013
376 COAL OIL POINT RESERVE 2013
377 SANTA CLARA RIVER MCGRATH STATE BEACH 2013
378 HOLLYWOOD BEACH 2013
379 ORMOND BEACH 2013
380 NBVC POINT MUGU 2013
381 SATICOY UNITED WATER CONSERVATION DISTRICT 2013
382 VENICE BEACH 2013
383 LA HARBOR 2013
384 SEAL BEACH NWR ANAHEIM BAY 2013
385 BOLSA CHICA ECOLOGICAL RESERVE 2013
386 HUNTINGTON STATE BEACH 2013
387 BURRIS ISLAND 2013
388 UPPER NEWPORT BAY ECOLOGICAL RESERVE 2013
389 MCB CAMP PENDLETON 2013
390 BATIQUITOS LAGOON ECOLOGICAL RESERVE 2013
391 SAN ELIJO LAGOON ECOLOGICAL RESERVE 2013
392 FAIRBANKS RANCH 2013
393 SAN DIEGUITO LAGOON ECOLOGICAL RESERVE 2013
394 MISSION BAY FAA ISLAND 2013
395 MISSION BAY NORTH FIESTA ISLAND 2013
396 MISSION BAY MARINERS POINT 2013
397 MISSION BAY STONY POINT 2013
398 MISSION BAY SAN DIEGO RIVER MOUTH 2013
399 SDIA LINDBERGH FIELD 2013
400 NAS NORTH ISLAND 2013
401 NAVAL AMPHIBIOUS BASE CORONADO 2013
402 DSTREET FILL SWEETWATER MARSH NWR 2013
403 CHULA VISTA WILDLIFE RESERVE 2013
404 SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS 2013
405 TIJUANA ESTUARY NERR 2013
406 SALTON SEA 2013
407 SACRAMENTO BUFFERLANDS 2014
408 NAPA SONOMA MARSH WILDLIFE AREA 2014
409 MONTEZUMA WETLANDS 2014
410 PITTSBURG POWER PLANT 2014
411 ALAMEDA POINT 2014
412 HAYWARD REGIONAL SHORELINE 2014
413 EDEN LANDING ECOLOGICAL RESERVE 2014
414 KETTLEMAN CITY 2014
415 OCEANO DUNES STATE VEHICULAR RECREATION AREA 2014
416 RANCHO GUADALUPE DUNES PRESERVE 2014
417 VANDENBERG SFB 2014
418 COAL OIL POINT RESERVE 2014
419 SANTA CLARA RIVER MCGRATH STATE BEACH 2014
420 HOLLYWOOD BEACH 2014
421 ORMOND BEACH 2014
422 NBVC POINT MUGU 2014
423 SATICOY UNITED WATER CONSERVATION DISTRICT 2014
424 VENICE BEACH 2014
425 LA HARBOR 2014
426 SEAL BEACH NWR ANAHEIM BAY 2014
427 BOLSA CHICA ECOLOGICAL RESERVE 2014
428 HUNTINGTON STATE BEACH 2014
429 BURRIS ISLAND 2014
430 UPPER NEWPORT BAY ECOLOGICAL RESERVE 2014
431 MCB CAMP PENDLETON 2014
432 BATIQUITOS LAGOON ECOLOGICAL RESERVE 2014
433 SAN ELIJO LAGOON ECOLOGICAL RESERVE 2014
434 FAIRBANKS RANCH 2014
435 SAN DIEGUITO LAGOON ECOLOGICAL RESERVE 2014
436 MISSION BAY FAA ISLAND 2014
437 MISSION BAY NORTH FIESTA ISLAND 2014
438 MISSION BAY MARINERS POINT 2014
439 MISSION BAY STONY POINT 2014
440 MISSION BAY SAN DIEGO RIVER MOUTH 2014
441 SDIA LINDBERGH FIELD 2014
442 NAS NORTH ISLAND 2014
443 NAVAL AMPHIBIOUS BASE CORONADO 2014
444 DSTREET FILL SWEETWATER MARSH NWR 2014
445 CHULA VISTA WILDLIFE RESERVE 2014
446 SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS 2014
447 TIJUANA ESTUARY NERR 2014
448 SALTON SEA 2014
449 SACRAMENTO BUFFERLANDS 2015
450 NAPA SONOMA MARSH WILDLIFE AREA 2015
451 MONTEZUMA WETLANDS 2015
452 PITTSBURG POWER PLANT 2015
453 ALAMEDA POINT 2015
454 HAYWARD REGIONAL SHORELINE 2015
455 EDEN LANDING ECOLOGICAL RESERVE 2015
456 KETTLEMAN CITY 2015
457 OCEANO DUNES STATE VEHICULAR RECREATION AREA 2015
458 RANCHO GUADALUPE DUNES PRESERVE 2015
459 VANDENBERG SFB 2015
460 COAL OIL POINT RESERVE 2015
461 SANTA CLARA RIVER MCGRATH STATE BEACH 2015
462 HOLLYWOOD BEACH 2015
463 ORMOND BEACH 2015
464 NBVC POINT MUGU 2015
465 SATICOY UNITED WATER CONSERVATION DISTRICT 2015
466 VENICE BEACH 2015
467 LA HARBOR 2015
468 SEAL BEACH NWR ANAHEIM BAY 2015
469 BOLSA CHICA ECOLOGICAL RESERVE 2015
470 HUNTINGTON STATE BEACH 2015
471 BURRIS ISLAND 2015
472 UPPER NEWPORT BAY ECOLOGICAL RESERVE 2015
473 MCB CAMP PENDLETON 2015
474 BATIQUITOS LAGOON ECOLOGICAL RESERVE 2015
475 SAN ELIJO LAGOON ECOLOGICAL RESERVE 2015
476 FAIRBANKS RANCH 2015
477 SAN DIEGUITO LAGOON ECOLOGICAL RESERVE 2015
478 MISSION BAY FAA ISLAND 2015
479 MISSION BAY NORTH FIESTA ISLAND 2015
480 MISSION BAY MARINERS POINT 2015
481 MISSION BAY STONY POINT 2015
482 MISSION BAY SAN DIEGO RIVER MOUTH 2015
483 SDIA LINDBERGH FIELD 2015
484 NAS NORTH ISLAND 2015
485 NAVAL AMPHIBIOUS BASE CORONADO 2015
486 DSTREET FILL SWEETWATER MARSH NWR 2015
487 CHULA VISTA WILDLIFE RESERVE 2015
488 SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS 2015
489 TIJUANA ESTUARY NERR 2015
490 SALTON SEA 2015
491 SACRAMENTO BUFFERLANDS 2016
492 NAPA SONOMA MARSH WILDLIFE AREA 2016
493 MONTEZUMA WETLANDS 2016
494 PITTSBURG POWER PLANT 2016
495 ALAMEDA POINT 2016
496 HAYWARD REGIONAL SHORELINE 2016
497 EDEN LANDING ECOLOGICAL RESERVE 2016
498 KETTLEMAN CITY 2016
499 OCEANO DUNES STATE VEHICULAR RECREATION AREA 2016
500 RANCHO GUADALUPE DUNES PRESERVE 2016
501 VANDENBERG SFB 2016
502 COAL OIL POINT RESERVE 2016
503 SANTA CLARA RIVER MCGRATH STATE BEACH 2016
504 HOLLYWOOD BEACH 2016
505 ORMOND BEACH 2016
506 NBVC POINT MUGU 2016
507 SATICOY UNITED WATER CONSERVATION DISTRICT 2016
508 VENICE BEACH 2016
509 LA HARBOR 2016
510 SEAL BEACH NWR ANAHEIM BAY 2016
511 BOLSA CHICA ECOLOGICAL RESERVE 2016
512 HUNTINGTON STATE BEACH 2016
513 ANAHEIM LAKE 2016
514 BURRIS ISLAND 2016
515 UPPER NEWPORT BAY ECOLOGICAL RESERVE 2016
516 MCB CAMP PENDLETON 2016
517 BATIQUITOS LAGOON ECOLOGICAL RESERVE 2016
518 SAN ELIJO LAGOON ECOLOGICAL RESERVE 2016
519 FAIRBANKS RANCH 2016
520 SAN DIEGUITO LAGOON ECOLOGICAL RESERVE 2016
521 MISSION BAY FAA ISLAND 2016
522 MISSION BAY NORTH FIESTA ISLAND 2016
523 MISSION BAY MARINERS POINT 2016
524 MISSION BAY STONY POINT 2016
525 MISSION BAY SAN DIEGO RIVER MOUTH 2016
526 SDIA LINDBERGH FIELD 2016
527 NAS NORTH ISLAND 2016
528 NAVAL AMPHIBIOUS BASE CORONADO 2016
529 DSTREET FILL SWEETWATER MARSH NWR 2016
530 CHULA VISTA WILDLIFE RESERVE 2016
531 SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS 2016
532 TIJUANA ESTUARY NERR 2016
533 SALTON SEA 2016
534 SACRAMENTO BUFFERLANDS 2017
535 NAPA SONOMA MARSH WILDLIFE AREA 2017
536 MONTEZUMA WETLANDS 2017
537 PITTSBURG POWER PLANT 2017
538 ALAMEDA POINT 2017
539 HAYWARD REGIONAL SHORELINE 2017
540 EDEN LANDING ECOLOGICAL RESERVE 2017
541 KETTLEMAN CITY 2017
542 OCEANO DUNES STATE VEHICULAR RECREATION AREA 2017
543 RANCHO GUADALUPE DUNES PRESERVE 2017
544 GUADALUPE NIPOMO DUNES NWR 2017
545 VANDENBERG SFB 2017
546 COAL OIL POINT RESERVE 2017
547 SANTA CLARA RIVER MCGRATH STATE BEACH 2017
548 HOLLYWOOD BEACH 2017
549 ORMOND BEACH 2017
550 NBVC POINT MUGU 2017
551 SATICOY UNITED WATER CONSERVATION DISTRICT 2017
552 VENICE BEACH 2017
553 MALIBU LAGOON 2017
554 LA HARBOR 2017
555 SEAL BEACH NWR ANAHEIM BAY 2017
556 BOLSA CHICA ECOLOGICAL RESERVE 2017
557 HUNTINGTON STATE BEACH 2017
558 ANAHEIM LAKE 2017
559 BURRIS ISLAND 2017
560 UPPER NEWPORT BAY ECOLOGICAL RESERVE 2017
561 MCB CAMP PENDLETON 2017
562 BATIQUITOS LAGOON ECOLOGICAL RESERVE 2017
563 SAN ELIJO LAGOON ECOLOGICAL RESERVE 2017
564 FAIRBANKS RANCH 2017
565 SAN DIEGUITO LAGOON ECOLOGICAL RESERVE 2017
566 MISSION BAY FAA ISLAND 2017
567 MISSION BAY NORTH FIESTA ISLAND 2017
568 MISSION BAY MARINERS POINT 2017
569 MISSION BAY STONY POINT 2017
570 MISSION BAY SAN DIEGO RIVER MOUTH 2017
571 SDIA LINDBERGH FIELD 2017
572 NAS NORTH ISLAND 2017
573 NAVAL AMPHIBIOUS BASE CORONADO 2017
574 DSTREET FILL SWEETWATER MARSH NWR 2017
575 CHULA VISTA WILDLIFE RESERVE 2017
576 SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS 2017
577 TIJUANA ESTUARY NERR 2017
578 SALTON SEA 2017
579 NAPA SONOMA MARSH WILDLIFE AREA 2018
580 MONTEZUMA WETLANDS 2018
581 ALAMEDA POINT 2018
582 HAYWARD REGIONAL SHORELINE 2018
583 EDEN LANDING ECOLOGICAL RESERVE 2018
584 OCEANO DUNES STATE VEHICULAR RECREATION AREA 2018
585 VANDENBERG SFB 2018
586 SANTA CLARA RIVER MCGRATH STATE BEACH 2018
587 HOLLYWOOD BEACH 2018
588 ORMOND BEACH 2018
589 NBVC POINT MUGU 2018
590 SATICOY UNITED WATER CONSERVATION DISTRICT 2018
591 VENICE BEACH 2018
592 MALIBU LAGOON 2018
593 LA HARBOR 2018
594 SEAL BEACH NWR ANAHEIM BAY 2018
595 BOLSA CHICA ECOLOGICAL RESERVE 2018
596 HUNTINGTON STATE BEACH 2018
597 BURRIS ISLAND 2018
598 UPPER NEWPORT BAY ECOLOGICAL RESERVE 2018
599 MCB CAMP PENDLETON 2018
600 BATIQUITOS LAGOON ECOLOGICAL RESERVE 2018
601 SAN ELIJO LAGOON ECOLOGICAL RESERVE 2018
602 MISSION BAY FAA ISLAND 2018
603 MISSION BAY NORTH FIESTA ISLAND 2018
604 MISSION BAY MARINERS POINT 2018
605 MISSION BAY STONY POINT 2018
606 SDIA LINDBERGH FIELD 2018
607 NAS NORTH ISLAND 2018
608 NAVAL AMPHIBIOUS BASE CORONADO 2018
609 DSTREET FILL SWEETWATER MARSH NWR 2018
610 CHULA VISTA WILDLIFE RESERVE 2018
611 SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS 2018
612 TIJUANA ESTUARY NERR 2018
613 NAPA SONOMA MARSH WILDLIFE AREA 2019
614 MONTEZUMA WETLANDS 2019
615 ALAMEDA POINT 2019
616 HAYWARD REGIONAL SHORELINE 2019
617 EDEN LANDING ECOLOGICAL RESERVE 2019
618 OCEANO DUNES STATE VEHICULAR RECREATION AREA 2019
619 RANCHO GUADALUPE DUNES PRESERVE 2019
620 VANDENBERG SFB 2019
621 SANTA CLARA RIVER MCGRATH STATE BEACH 2019
622 HOLLYWOOD BEACH 2019
623 ORMOND BEACH 2019
624 NBVC POINT MUGU 2019
625 SATICOY UNITED WATER CONSERVATION DISTRICT 2019
626 VENICE BEACH 2019
627 MALIBU LAGOON 2019
628 LA HARBOR 2019
629 SEAL BEACH NWR ANAHEIM BAY 2019
630 BOLSA CHICA ECOLOGICAL RESERVE 2019
631 HUNTINGTON STATE BEACH 2019
632 BURRIS ISLAND 2019
633 UPPER NEWPORT BAY ECOLOGICAL RESERVE 2019
634 MCB CAMP PENDLETON 2019
635 BATIQUITOS LAGOON ECOLOGICAL RESERVE 2019
636 SAN ELIJO LAGOON ECOLOGICAL RESERVE 2019
637 MISSION BAY FAA ISLAND 2019
638 MISSION BAY NORTH FIESTA ISLAND 2019
639 MISSION BAY MARINERS POINT 2019
640 MISSION BAY STONY POINT 2019
641 SDIA LINDBERGH FIELD 2019
642 NAS NORTH ISLAND 2019
643 NAVAL AMPHIBIOUS BASE CORONADO 2019
644 DSTREET FILL SWEETWATER MARSH NWR 2019
645 CHULA VISTA WILDLIFE RESERVE 2019
646 SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS 2019
647 TIJUANA ESTUARY NERR 2019
648 NAPA SONOMA MARSH WILDLIFE AREA 2020
649 MONTEZUMA WETLANDS 2020
650 ALAMEDA POINT 2020
651 HAYWARD REGIONAL SHORELINE 2020
652 EDEN LANDING ECOLOGICAL RESERVE 2020
653 OCEANO DUNES STATE VEHICULAR RECREATION AREA 2020
654 RANCHO GUADALUPE DUNES PRESERVE 2020
655 VANDENBERG SFB 2020
656 SANTA CLARA RIVER MCGRATH STATE BEACH 2020
657 HOLLYWOOD BEACH 2020
658 ORMOND BEACH 2020
659 NBVC POINT MUGU 2020
660 SATICOY UNITED WATER CONSERVATION DISTRICT 2020
661 VENICE BEACH 2020
662 MALIBU LAGOON 2020
663 LA HARBOR 2020
664 SEAL BEACH NWR ANAHEIM BAY 2020
665 BOLSA CHICA ECOLOGICAL RESERVE 2020
666 HUNTINGTON STATE BEACH 2020
667 BURRIS ISLAND 2020
668 UPPER NEWPORT BAY ECOLOGICAL RESERVE 2020
669 MCB CAMP PENDLETON 2020
670 BATIQUITOS LAGOON ECOLOGICAL RESERVE 2020
671 SAN ELIJO LAGOON ECOLOGICAL RESERVE 2020
672 MISSION BAY FAA ISLAND 2020
673 MISSION BAY NORTH FIESTA ISLAND 2020
674 MISSION BAY MARINERS POINT 2020
675 MISSION BAY STONY POINT 2020
676 SDIA LINDBERGH FIELD 2020
677 NAS NORTH ISLAND 2020
678 NAVAL AMPHIBIOUS BASE CORONADO 2020
679 DSTREET FILL SWEETWATER MARSH NWR 2020
680 CHULA VISTA WILDLIFE RESERVE 2020
681 SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS 2020
682 TIJUANA ESTUARY NERR 2020
683 NAPA SONOMA MARSH WILDLIFE AREA 2021
684 SAN PABLO BAY NWR 2021
685 MONTEZUMA WETLANDS 2021
686 ALAMEDA POINT 2021
687 HAYWARD REGIONAL SHORELINE 2021
688 EDEN LANDING ECOLOGICAL RESERVE 2021
689 OCEANO DUNES STATE VEHICULAR RECREATION AREA 2021
690 RANCHO GUADALUPE DUNES PRESERVE 2021
691 VANDENBERG SFB 2021
692 SANTA CLARA RIVER MCGRATH STATE BEACH 2021
693 HOLLYWOOD BEACH 2021
694 ORMOND BEACH 2021
695 NBVC POINT MUGU 2021
696 SATICOY UNITED WATER CONSERVATION DISTRICT 2021
697 VENICE BEACH 2021
698 MALIBU LAGOON 2021
699 LA HARBOR 2021
700 SEAL BEACH NWR ANAHEIM BAY 2021
701 BOLSA CHICA ECOLOGICAL RESERVE 2021
702 HUNTINGTON STATE BEACH 2021
703 BURRIS ISLAND 2021
704 UPPER NEWPORT BAY ECOLOGICAL RESERVE 2021
705 MCB CAMP PENDLETON 2021
706 BATIQUITOS LAGOON ECOLOGICAL RESERVE 2021
707 SAN ELIJO LAGOON ECOLOGICAL RESERVE 2021
708 MISSION BAY FAA ISLAND 2021
709 MISSION BAY NORTH FIESTA ISLAND 2021
710 MISSION BAY MARINERS POINT 2021
711 MISSION BAY STONY POINT 2021
712 SDIA LINDBERGH FIELD 2021
713 NAS NORTH ISLAND 2021
714 NAVAL AMPHIBIOUS BASE CORONADO 2021
715 DSTREET FILL SWEETWATER MARSH NWR 2021
716 CHULA VISTA WILDLIFE RESERVE 2021
717 SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS 2021
718 TIJUANA ESTUARY NERR 2021
719 NAPA SONOMA MARSH WILDLIFE AREA 2022
720 SAN PABLO BAY NWR 2022
721 MONTEZUMA WETLANDS 2022
722 ALAMEDA POINT 2022
723 HAYWARD REGIONAL SHORELINE 2022
724 EDEN LANDING ECOLOGICAL RESERVE 2022
725 OCEANO DUNES STATE VEHICULAR RECREATION AREA 2022
726 RANCHO GUADALUPE DUNES PRESERVE 2022
727 VANDENBERG SFB 2022
728 SANTA CLARA RIVER MCGRATH STATE BEACH 2022
729 HOLLYWOOD BEACH 2022
730 ORMOND BEACH 2022
731 NBVC POINT MUGU 2022
732 VENICE BEACH 2022
733 MALIBU LAGOON 2022
734 LA HARBOR 2022
735 SEAL BEACH NWR ANAHEIM BAY 2022
736 BOLSA CHICA ECOLOGICAL RESERVE 2022
737 HUNTINGTON STATE BEACH 2022
738 BURRIS ISLAND 2022
739 UPPER NEWPORT BAY ECOLOGICAL RESERVE 2022
740 MCB CAMP PENDLETON 2022
741 BATIQUITOS LAGOON ECOLOGICAL RESERVE 2022
742 SAN ELIJO LAGOON ECOLOGICAL RESERVE 2022
743 SAN DIEGUITO LAGOON ECOLOGICAL RESERVE 2022
744 MISSION BAY FAA ISLAND 2022
745 MISSION BAY NORTH FIESTA ISLAND 2022
746 MISSION BAY MARINERS POINT 2022
747 MISSION BAY STONY POINT 2022
748 SDIA LINDBERGH FIELD 2022
749 NAS NORTH ISLAND 2022
750 NAVAL AMPHIBIOUS BASE CORONADO 2022
751 DSTREET FILL SWEETWATER MARSH NWR 2022
752 CHULA VISTA WILDLIFE RESERVE 2022
753 SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS 2022
754 TIJUANA ESTUARY NERR 2022
755 NAPA SONOMA MARSH WILDLIFE AREA 2023
756 SAN PABLO BAY NWR 2023
757 MONTEZUMA WETLANDS 2023
758 ALAMEDA POINT 2023
759 HAYWARD REGIONAL SHORELINE 2023
760 EDEN LANDING ECOLOGICAL RESERVE 2023
761 OCEANO DUNES STATE VEHICULAR RECREATION AREA 2023
762 RANCHO GUADALUPE DUNES PRESERVE 2023
763 VANDENBERG SFB 2023
764 SANTA CLARA RIVER MCGRATH STATE BEACH 2023
765 HOLLYWOOD BEACH 2023
766 ORMOND BEACH 2023
767 NBVC POINT MUGU 2023
768 VENICE BEACH 2023
769 MALIBU LAGOON 2023
770 LA HARBOR 2023
771 SEAL BEACH NWR ANAHEIM BAY 2023
772 BOLSA CHICA ECOLOGICAL RESERVE 2023
773 HUNTINGTON STATE BEACH 2023
774 ANAHEIM LAKE 2023
775 BURRIS ISLAND 2023
776 UPPER NEWPORT BAY ECOLOGICAL RESERVE 2023
777 MCB CAMP PENDLETON 2023
778 BATIQUITOS LAGOON ECOLOGICAL RESERVE 2023
779 SAN ELIJO LAGOON ECOLOGICAL RESERVE 2023
780 SAN DIEGUITO LAGOON ECOLOGICAL RESERVE 2023
781 MISSION BAY FAA ISLAND 2023
782 MISSION BAY NORTH FIESTA ISLAND 2023
783 MISSION BAY MARINERS POINT 2023
784 MISSION BAY STONY POINT 2023
785 SDIA LINDBERGH FIELD 2023
786 NAS NORTH ISLAND 2023
787 NAVAL AMPHIBIOUS BASE CORONADO 2023
788 DSTREET FILL SWEETWATER MARSH NWR 2023
789 CHULA VISTA WILDLIFE RESERVE 2023
790 SOUTH SAN DIEGO BAY UNIT SDNWR SALTWORKS 2023
791 TIJUANA ESTUARY NERR 2023The advantage of select over the indexing operator [ is that it provides concise ways to a lot of columns. For instance, to select all of the columns whose names begin with nonpred_, you can write:
select(terns, starts_with("nonpred_")) nonpred_eggs nonpred_chicks nonpred_fl nonpred_ad
1 3 0 0 0
2 NA NA NA NA
3 124 81 2 1
4 NA 3 1 6
5 2 0 0 0
6 0 1 0 0
7 NA 27 0 0
8 4 3 NA NA
9 2 0 0 0
10 NA NA NA NA
11 26 NA NA NA
12 77 NA NA NA
13 10 3 NA NA
14 NA NA NA NA
15 74 4 0 0
16 NA NA NA NA
17 72 118 24 16
18 10 35 3 6
19 1 0 0 0
20 28 NA NA NA
21 8 0 0 1
22 32 11 1 0
23 7 1 0 0
24 20 3 1 0
25 67 19 2 0
26 8 2 0 1
27 NA NA NA NA
28 9 3 0 0
29 56 7 1 0
30 0 0 0 0
31 NA NA NA NA
32 142 156 1 2
33 NA NA NA NA
34 NA NA NA NA
35 2 0 NA 0
36 1 0 NA 0
37 NA 0 NA 2
38 6 1 0 0
39 7 2 1 NA
40 6 1 0 1
41 132 10 0 0
42 0 0 NA 0
43 179 453 31 12
44 69 85 2 2
45 0 5 0 1
46 24 NA NA NA
47 NA NA NA NA
48 5 0 0 0
49 521 1063 11 7
50 146 417 0 0
51 NA NA NA NA
52 0 NA NA NA
53 1 0 NA 0
54 144 2 NA 0
55 9 NA NA NA
56 24 17 0 0
57 120 14 0 0
58 306 48 0 2
59 NA NA NA NA
60 30 11 0 0
61 17 1 0 0
62 4 2 0 2
63 272 2 1 2
64 NA NA NA NA
65 186 286 0 0
66 NA NA NA NA
67 NA NA NA NA
68 25 9 0 0
69 NA NA NA NA
70 42 29 1 0
71 NA NA NA NA
72 1 0 0 0
73 24 1 0 0
74 156 22 2 9
75 0 0 0 1
76 217 868 13 3
77 NA 4 2 2
78 13 13 1 1
79 NA 80 0 7
80 NA 1 0 0
81 556 928 16 11
82 112 307 15 6
83 0 0 4 3
84 0 0 0 0
85 0 0 0 0
86 186 43 4 0
87 37 2 1 1
88 31 21 10 1
89 76 18 2 2
90 225 27 6 1
91 23 17 1 1
92 13 5 0 0
93 10 0 NA NA
94 99 NA NA NA
95 NA NA NA NA
96 NA NA NA NA
97 248 202 1 1
98 0 0 0 0
99 NA NA NA NA
100 12 1 2 2
101 NA NA NA NA
102 4 0 NA 0
103 NA NA NA NA
104 NA NA NA NA
105 5 2 0 0
106 85 19 0 0
107 60 57 0 1
108 434 253 7 7
109 27 15 0 0
110 40 14 0 1
111 NA NA NA NA
112 0 0 0 0
113 307 420 63 7
114 81 189 21 5
115 NA NA NA NA
116 4 0 0 2
117 3 2 0 0
118 1 NA NA NA
119 11 1 NA NA
120 NA NA NA NA
121 NA NA NA NA
122 65 15 0 0
123 230 23 1 7
124 NA NA NA NA
125 NA NA NA NA
126 24 2 0 0
127 98 9 2 0
128 NA NA NA NA
129 NA NA NA NA
130 NA NA NA NA
131 122 127 28 0
132 NA NA 0 0
133 NA NA NA NA
134 NA NA NA NA
135 20 4 4 0
136 0 0 0 0
137 8 2 0 0
138 0 0 NA 0
139 13 0 0 0
140 0 0 0 0
141 9 4 0 0
142 77 NA NA NA
143 89 125 NA 3
144 385 NA NA NA
145 20 6 0 0
146 18 2 0 0
147 82 8 3 1
148 NA NA NA NA
149 NA NA NA NA
150 430 236 35 11
151 181 109 6 3
152 NA NA NA NA
153 1 2 0 0
154 15 3 5 0
155 24 8 1 0
156 4 3 0 0
157 16 0 5 0
158 53 12 3 1
159 56 11 3 0
160 238 52 10 0
161 31 7 5 0
162 3 0 NA 0
163 28 4 0 0
164 139 8 2 0
165 NA NA NA NA
166 NA NA NA NA
167 NA NA NA NA
168 NA NA NA NA
169 54 22 0 0
170 15 3 0 0
171 NA NA NA NA
172 NA NA NA NA
173 9 7 1 1
174 NA NA NA NA
175 2 4 4 0
176 NA NA NA NA
177 5 2 NA NA
178 3 NA NA NA
179 10 2 NA NA
180 157 4 1 0
181 35 129 5 3
182 277 153 1 2
183 NA 29 2 3
184 17 18 1 1
185 167 24 7 10
186 NA NA NA NA
187 NA NA NA NA
188 600 680 207 4
189 131 167 70 3
190 NA NA NA NA
191 NA NA NA NA
192 0 0 NA 0
193 0 0 NA 0
194 NA NA NA NA
195 0 0 0 0
196 29 19 5 0
197 46 5 0 0
198 296 46 8 3
199 29 12 0 0
200 4 0 0 0
201 31 0 0 0
202 63 3 2 1
203 NA NA NA NA
204 NA NA NA NA
205 NA NA NA NA
206 NA NA NA 0
207 106 50 4 1
208 NA 1 0 0
209 0 0 NA 0
210 NA NA NA NA
211 8 0 1 0
212 0 0 0 0
213 6 2 5 0
214 NA NA NA NA
215 11 1 NA NA
216 1 NA NA NA
217 13 1 NA NA
218 214 25 8 0
219 0 0 NA 0
220 328 123 3 1
221 NA NA NA NA
222 NA 14 0 0
223 168 57 1 2
224 NA NA NA NA
225 NA NA NA NA
226 474 769 32 4
227 123 278 33 2
228 NA NA NA 0
229 NA NA NA NA
230 40 3 NA 0
231 14 3 NA NA
232 12 NA NA NA
233 NA NA NA NA
234 NA NA NA NA
235 58 46 2 0
236 NA NA 1 NA
237 NA NA 0 NA
238 22 12 0 0
239 8 2 0 0
240 7 2 0 0
241 90 0 3 0
242 NA NA NA NA
243 0 0 0 0
244 17 3 0 0
245 NA NA NA NA
246 0 0 0 0
247 94 68 5 0
248 9 2 2 0
249 NA NA NA NA
250 NA NA NA NA
251 6 1 1 0
252 0 0 0 0
253 9 5 0 0
254 NA NA NA NA
255 3 NA NA NA
256 0 0 0 0
257 12 2 NA 2
258 222 91 27 1
259 1 NA NA NA
260 158 6 0 0
261 NA 116 2 2
262 NA NA NA NA
263 120 17 3 1
264 0 0 0 0
265 NA NA NA NA
266 327 679 182 6
267 98 131 104 1
268 NA NA NA NA
269 NA NA NA NA
270 NA NA NA NA
271 3 2 0 0
272 5 0 0 0
273 68 27 14 1
274 0 0 0 0
275 6 2 6 1
276 33 36 5 2
277 32 27 5 0
278 221 365 168 4
279 13 28 11 0
280 2 1 1 0
281 14 1 1 1
282 83 9 12 2
283 NA NA NA NA
284 10 0 0 1
285 NA NA NA NA
286 NA NA NA NA
287 171 207 1 5
288 3 15 3 0
289 NA NA NA NA
290 NA NA NA NA
291 5 0 0 0
292 NA NA NA NA
293 10 3 1 0
294 NA NA NA NA
295 NA 1 NA NA
296 NA NA NA NA
297 7 2 0 0
298 316 41 4 0
299 0 0 0 0
300 11 5 0 0
301 91 9 NA 1
302 20 2 0 0
303 231 112 16 5
304 0 NA NA NA
305 NA NA NA NA
306 748 547 3 6
307 138 NA NA NA
308 NA NA NA NA
309 NA NA NA NA
310 NA NA NA NA
311 8 4 2 0
312 NA NA NA NA
313 40 36 1 1
314 7 NA 1 NA
315 5 3 NA NA
316 21 9 0 1
317 27 12 0 0
318 249 143 24 4
319 22 40 9 0
320 6 2 0 0
321 10 3 0 0
322 86 1 4 1
323 NA NA NA NA
324 NA NA NA NA
325 27 2 NA NA
326 NA NA NA NA
327 NA NA NA NA
328 184 37 0 0
329 83 14 2 1
330 NA NA NA NA
331 NA NA NA NA
332 12 1 0 0
333 NA NA NA NA
334 9 4 4 0
335 NA NA NA NA
336 19 2 NA NA
337 NA NA NA NA
338 5 0 0 0
339 709 110 10 0
340 0 0 0 1
341 77 84 1 1
342 30 42 3 1
343 21 7 0 1
344 127 150 0 0
345 4 0 0 0
346 1 NA NA NA
347 590 676 0 6
348 189 400 4 1
349 NA NA NA NA
350 NA NA NA NA
351 NA NA NA NA
352 48 10 0 1
353 2 NA NA NA
354 163 22 0 0
355 12 1 NA NA
356 2 NA NA NA
357 44 44 NA 1
358 0 0 0 0
359 607 52 0 0
360 56 16 NA 1
361 23 3 NA NA
362 21 NA NA NA
363 104 NA NA NA
364 NA NA NA NA
365 NA NA NA NA
366 58 6 0 0
367 0 1 2 0
368 NA NA NA NA
369 0 48 8 0
370 0 0 0 0
371 NA NA NA NA
372 NA NA NA NA
373 10 3 2 1
374 NA NA NA NA
375 4 2 0 0
376 NA NA NA NA
377 2 0 0 0
378 43 24 0 0
379 5 0 0 0
380 350 0 0 0
381 NA NA NA NA
382 0 0 0 0
383 116 107 0 0
384 46 8 0 0
385 65 0 0 0
386 121 18 0 0
387 0 0 0 0
388 2 2 0 0
389 536 291 1 2
390 168 294 8 1
391 NA NA NA NA
392 NA NA NA NA
393 2 0 0 0
394 127 53 0 1
395 NA NA NA NA
396 41 2 0 0
397 24 5 0 0
398 NA NA NA NA
399 42 12 3 2
400 2 0 0 0
401 403 211 23 1
402 33 57 10 0
403 21 29 3 0
404 14 3 0 1
405 139 38 2 1
406 0 0 0 0
407 NA NA NA NA
408 28 4 NA 1
409 0 NA NA NA
410 NA NA NA NA
411 84 13 NA NA
412 7 1 NA NA
413 NA NA NA NA
414 NA NA NA NA
415 6 NA 6 1
416 NA NA NA NA
417 2 NA NA NA
418 NA NA NA NA
419 2 NA NA NA
420 21 5 NA NA
421 11 1 NA NA
422 176 19 3 1
423 NA NA NA NA
424 NA 2 NA NA
425 59 12 NA NA
426 63 NA NA NA
427 49 15 NA NA
428 141 76 26 2
429 3 NA NA NA
430 0 NA NA NA
431 203 578 102 5
432 108 271 17 NA
433 NA NA NA NA
434 NA NA NA NA
435 NA NA NA NA
436 6 NA NA NA
437 3 5 NA NA
438 54 13 2 NA
439 2 1 NA NA
440 NA NA NA NA
441 42 21 2 NA
442 39 8 1 NA
443 269 428 13 6
444 31 65 7 NA
445 15 35 2 NA
446 9 5 NA NA
447 66 7 NA NA
448 0 NA NA NA
449 0 NA NA NA
450 18 2 0 0
451 6 1 0 0
452 0 NA NA NA
453 80 11 NA NA
454 15 NA NA NA
455 NA NA NA NA
456 NA NA NA NA
457 3 NA 2 NA
458 NA NA NA NA
459 1 1 NA NA
460 NA NA NA NA
461 3 NA NA NA
462 4 NA NA NA
463 0 NA NA NA
464 161 11 0 0
465 NA NA NA NA
466 0 NA NA NA
467 130 NA NA NA
468 68 NA NA NA
469 66 12 0 0
470 186 83 22 11
471 0 NA NA NA
472 2 4 NA NA
473 392 525 17 5
474 115 162 7 0
475 NA NA NA NA
476 NA NA NA NA
477 NA NA NA NA
478 4 10 NA NA
479 5 2 NA NA
480 52 30 2 1
481 0 NA NA NA
482 NA NA NA NA
483 7 NA 1 NA
484 18 NA 1 NA
485 182 306 16 4
486 29 22 2 NA
487 13 17 4 NA
488 5 6 2 NA
489 46 7 3 0
490 NA NA NA NA
491 0 0 0 0
492 35 0 0 0
493 1 0 0 0
494 NA NA NA NA
495 83 40 0 0
496 14 0 0 0
497 NA NA NA NA
498 NA NA NA NA
499 8 1 1 0
500 NA NA NA NA
501 3 0 0 0
502 NA NA NA NA
503 6 0 0 0
504 NA NA NA NA
505 3 NA 1 1
506 197 14 0 0
507 NA NA NA NA
508 1 0 0 0
509 87 10 0 0
510 30 17 1 2
511 55 16 0 0
512 133 89 0 1
513 1 0 0 0
514 2 0 0 0
515 11 0 0 0
516 342 423 16 2
517 107 310 25 3
518 NA NA NA NA
519 NA NA NA NA
520 NA NA NA NA
521 10 0 0 0
522 23 0 0 0
523 42 13 1 0
524 11 1 0 0
525 0 0 0 0
526 12 5 1 0
527 18 5 1 0
528 302 402 10 2
529 33 58 1 1
530 16 27 1 0
531 3 9 1 0
532 48 10 5 3
533 NA NA NA NA
534 0 3 0 0
535 NA NA NA NA
536 1 3 0 0
537 NA NA NA NA
538 180 130 1 5
539 9 17 0 0
540 3 0 0 0
541 0 0 0 0
542 12 0 0 0
543 0 0 0 0
544 0 0 0 0
545 10 3 0 0
546 0 0 0 0
547 5 0 0 1
548 0 0 0 0
549 10 2 0 0
550 162 5 0 0
551 0 0 0 0
552 0 0 0 0
553 NA NA NA NA
554 0 0 0 0
555 47 14 0 0
556 78 3 0 0
557 250 152 18 3
558 0 0 0 0
559 7 0 1 0
560 6 6 0 0
561 208 5 0 2
562 308 345 173 4
563 0 0 0 0
564 NA 0 0 0
565 0 0 0 0
566 20 3 0 0
567 0 0 0 0
568 96 52 9 1
569 2 0 0 0
570 NA NA NA NA
571 9 1 0 0
572 7 4 0 1
573 281 474 30 6
574 40 34 3 0
575 23 23 2 0
576 13 2 0 0
577 69 43 11 1
578 0 0 0 0
579 0 0 0 0
580 3 0 0 0
581 143 86 4 0
582 0 0 0 0
583 1 0 0 0
584 11 0 0 0
585 6 5 0 0
586 3 0 0 0
587 0 0 0 0
588 20 2 0 0
589 76 1 0 1
590 0 0 0 0
591 0 0 0 0
592 7 0 0 0
593 58 7 0 0
594 22 31 0 0
595 54 11 0 0
596 308 141 11 5
597 0 0 0 0
598 12 1 0 0
599 54 4 0 0
600 176 618 8 2
601 0 0 0 0
602 6 0 0 0
603 0 0 0 0
604 50 67 1 0
605 1 0 0 0
606 8 5 0 0
607 9 0 0 0
608 260 423 1 3
609 26 46 0 0
610 35 28 0 0
611 11 4 0 0
612 88 37 0 2
613 0 0 0 6
614 6 1 0 0
615 113 141 1 0
616 17 0 0 0
617 1 0 0 0
618 3 0 2 0
619 0 0 0 0
620 12 15 0 0
621 NA NA NA NA
622 0 0 0 0
623 20 0 0 0
624 69 4 1 0
625 0 0 0 0
626 2 0 0 0
627 0 0 0 0
628 71 28 0 0
629 2 0 0 0
630 71 2 0 0
631 184 309 3 4
632 2 3 0 1
633 0 0 0 0
634 258 40 0 0
635 138 208 1 3
636 0 0 0 0
637 4 2 0 0
638 0 0 0 0
639 83 48 1 0
640 0 0 0 0
641 6 0 0 3
642 0 2 0 0
643 361 192 4 1
644 54 16 0 0
645 43 4 0 0
646 23 2 0 0
647 72 6 1 0
648 0 0 0 0
649 5 0 0 0
650 116 0 0 0
651 0 2 1 0
652 0 0 0 0
653 13 0 0 0
654 1 0 0 0
655 9 0 0 0
656 5 3 0 1
657 1 2 0 0
658 9 0 0 0
659 134 2 0 2
660 NA NA NA NA
661 5 8 4 0
662 0 0 0 0
663 0 18 0 0
664 0 0 0 0
665 30 0 0 0
666 336 18 2 7
667 3 6 0 0
668 2 0 0 0
669 231 119 33 0
670 78 29 3 0
671 0 0 0 0
672 14 6 5 0
673 1 0 0 0
674 85 80 11 0
675 0 0 0 0
676 5 0 0 0
677 6 1 0 0
678 412 170 3 1
679 2 0 0 0
680 49 5 0 0
681 8 1 0 0
682 56 7 0 1
683 0 0 0 0
684 0 0 0 0
685 0 0 0 0
686 118 98 3 0
687 23 1 0 1
688 5 0 0 0
689 9 8 2 1
690 0 0 0 0
691 7 11 0 0
692 6 4 0 0
693 0 0 0 0
694 9 1 0 0
695 80 4 0 0
696 NA NA NA NA
697 16 8 0 0
698 0 0 0 0
699 112 48 0 0
700 1 0 0 0
701 11 0 0 1
702 157 101 50 13
703 6 3 0 0
704 4 0 0 0
705 330 178 7 3
706 133 171 2 3
707 0 0 0 0
708 43 20 1 1
709 0 0 0 0
710 70 31 1 0
711 0 0 0 0
712 4 0 0 1
713 0 0 0 0
714 351 0 0 0
715 45 8 0 0
716 39 11 0 0
717 32 2 0 1
718 137 20 1 1
719 8 0 0 0
720 10 2 0 0
721 0 0 0 0
722 127 124 1 1
723 12 0 0 0
724 4 1 0 1
725 12 4 1 0
726 1 0 0 0
727 5 6 0 0
728 6 0 0 0
729 14 0 0 0
730 7 0 0 3
731 94 4 0 0
732 0 0 0 0
733 0 0 0 0
734 146 9 0 0
735 1 4 0 0
736 59 9 0 0
737 249 141 17 9
738 0 0 0 0
739 0 0 0 0
740 247 83 5 2
741 100 70 12 0
742 0 0 0 0
743 10 0 0 0
744 38 16 1 0
745 0 0 0 0
746 53 47 2 1
747 0 0 0 0
748 2 1 0 0
749 0 0 0 0
750 338 66 3 0
751 32 3 0 0
752 40 4 0 0
753 9 0 0 0
754 106 4 0 0
755 2 1 0 0
756 1 0 0 0
757 0 0 0 1
758 112 56 5 0
759 17 1 0 0
760 1 1 0 0
761 8 2 0 0
762 0 0 0 0
763 3 28 0 0
764 13 0 0 0
765 0 0 0 0
766 1 1 0 0
767 40 3 0 1
768 0 0 0 0
769 0 0 0 0
770 37 0 0 0
771 31 7 2 0
772 29 0 0 0
773 176 90 3 22
774 0 0 0 0
775 4 0 0 0
776 4 0 0 0
777 317 169 15 1
778 67 94 7 0
779 0 0 0 0
780 0 0 0 0
781 50 36 4 0
782 1 0 0 0
783 2 0 0 0
784 0 0 0 0
785 1 2 0 0
786 0 0 0 0
787 329 185 6 6
788 25 2 0 0
789 32 1 0 0
790 11 2 0 0
791 65 44 1 1You can select the same columns with the indexing operator, but you’d either have to type out all of their names or use a more complicated expression.
Use the indexing operator when you only need to select a few columns. Use dplyr’s select function when you need to select lots of columns that follow some kind of pattern. The dplyr documentation provides more details about how to use the select function.
15.3 Filtering Rows
In addition to selecting columns, you also need to know how to filter rows in order to work with tabular data. In this context, to “filter” is to get a subset of rows that satisfy a condition. As a motivating example, suppose we want to get all of the rows in the least terns dataset that correspond to the Los Angeles Harbor (LA HARBOR) site.
The indexing operator [ is one way to filter the rows of a data frame. The first step is to translate the condition on the rows into code. To test whether rows correspond to Los Angeles Harbor, we can write:
terns$site_name == "LA HARBOR" [1] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE
[13] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[25] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[37] FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE
[49] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[61] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[73] FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[85] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[97] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE
[109] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[121] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[133] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE
[145] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[157] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[169] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[181] FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[193] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[205] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[217] FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[229] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[241] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[253] FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE
[265] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[277] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[289] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE
[301] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[313] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[325] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[337] FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[349] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[361] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[373] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE
[385] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[397] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[409] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[421] FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[433] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[445] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[457] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE
[469] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[481] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[493] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[505] FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[517] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[529] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[541] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[553] FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[565] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[577] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[589] FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[601] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[613] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[625] FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[637] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[649] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[661] FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[673] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[685] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[697] FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[709] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[721] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[733] FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[745] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[757] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[769] FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[781] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSEThis returns a vector of logical (TRUE and FALSE) values. Now that we have the code for the condition, we can use indexing to get rows where the condition is TRUE:
terns[terns$site_name == "LA HARBOR", ] year site_name site_name_2013_2018 site_name_1988_2001 site_abbr region_3
12 2000 LA HARBOR Port of LA NA_2013_2018 POLYGON LA_HARB SOUTHERN
43 2004 LA HARBOR Port of LA NA_2013_2018 POLYGON LA_HARB SOUTHERN
76 2005 LA HARBOR Port of LA NA_2013_2018 POLYGON LA_HARB SOUTHERN
108 2006 LA HARBOR Port of LA NA_2013_2018 POLYGON LA_HARB SOUTHERN
144 2007 LA HARBOR Port of LA NA_2013_2018 POLYGON LA_HARB SOUTHERN
182 2008 LA HARBOR Port of LA NA_2013_2018 POLYGON LA_HARB SOUTHERN
220 2009 LA HARBOR Port of LA NA_2013_2018 POLYGON LA_HARB SOUTHERN
260 2010 LA HARBOR Port of LA NA_2013_2018 POLYGON LA_HARB SOUTHERN
300 2011 LA HARBOR Port of LA NA_2013_2018 POLYGON LA_HARB SOUTHERN
341 2012 LA HARBOR Port of LA NA_2013_2018 POLYGON LA_HARB SOUTHERN
383 2013 LA HARBOR Port of LA NA_2013_2018 POLYGON LA_HARB SOUTHERN
425 2014 LA HARBOR Port of LA NA_2013_2018 POLYGON LA_HARB SOUTHERN
467 2015 LA HARBOR Port of LA NA_2013_2018 POLYGON LA_HARB SOUTHERN
509 2016 LA HARBOR Port of LA NA_2013_2018 POLYGON LA_HARB SOUTHERN
554 2017 LA HARBOR Port of LA NA_2013_2018 POLYGON LA_HARB SOUTHERN
593 2018 LA HARBOR Port of LA NA_2013_2018 POLYGON LA_HARB SOUTHERN
628 2019 LA HARBOR Port of LA NA_2013_2018 POLYGON LA_HARB SOUTHERN
663 2020 LA HARBOR Port of LA NA_2013_2018 POLYGON LA_HARB SOUTHERN
699 2021 LA HARBOR Port of LA NA_2013_2018 POLYGON LA_HARB SOUTHERN
734 2022 LA HARBOR Port of LA NA_2013_2018 POLYGON LA_HARB SOUTHERN
770 2023 LA HARBOR Port of LA NA_2013_2018 POLYGON LA_HARB SOUTHERN
region_4 event bp_min bp_max fl_min fl_max total_nests nonpred_eggs
12 SOUTHERN LA_NINA 437 437 570 570 565 77
43 SOUTHERN NEUTRAL 951 951 556 556 1071 179
76 SOUTHERN NEUTRAL 1254 1254 449 687 1332 217
108 SOUTHERN NEUTRAL 835 835 511 771 907 434
144 SOUTHERN EL_NINO 669 669 186 186 710 385
182 SOUTHERN LA_NINA 486 515 210 210 529 277
220 SOUTHERN NEUTRAL 371 385 75 75 435 328
260 SOUTHERN EL_NINO 149 195 4 4 216 158
300 SOUTHERN LA_NINA 7 8 0 0 10 11
341 SOUTHERN LA_NINA 144 207 35 35 211 77
383 SOUTHERN NEUTRAL 237 239 31 147 254 116
425 SOUTHERN NEUTRAL 110 112 16 112 126 59
467 SOUTHERN NEUTRAL 103 109 0 0 109 130
509 SOUTHERN EL_NINO 109 141 46 70 141 87
554 SOUTHERN NEUTRAL 0 5 0 0 5 0
593 SOUTHERN NEUTRAL 105 117 69 69 133 58
628 SOUTHERN NEUTRAL 161 184 97 97 199 71
663 SOUTHERN NEUTRAL 91 182 3 111 182 0
699 SOUTHERN LA_NINA 170 188 38 142 198 112
734 SOUTHERN LA_NINA 172 177 2 4 189 146
770 SOUTHERN LA_NINA 1 55 0 0 56 37
nonpred_chicks nonpred_fl nonpred_ad pred_control pred_eggs pred_chicks
12 NA NA NA 24 NA
43 453 31 12 NA NA
76 868 13 3 6 0
108 253 7 7 27 0
144 NA NA NA NA NA
182 153 1 2 NA NA
220 123 3 1 NA NA
260 6 0 0 NA NA
300 5 0 0 Y NA NA
341 84 1 1 Y NA NA
383 107 0 0 Y NA NA
425 12 NA NA Y NA NA
467 NA NA NA Y NA NA
509 10 0 0 Y NA NA
554 0 0 0 Y NA NA
593 7 0 0 Y NA NA
628 28 0 0 Y NA NA
663 18 0 0 Y NA NA
699 48 0 0 Y NA NA
734 9 0 0 Y NA NA
770 0 0 0 Y NA NA
pred_fl pred_ad pred_pefa pred_coy_fox pred_meso pred_owlspp pred_corvid
12 15 NA Y N N N N
43 NA NA Y N Y Y Y
76 0 0 N N N Y Y
108 0 7 Y N N Y Y
144 NA NA
182 NA NA Y N N Y Y
220 NA NA Y N N Y Y
260 NA NA N N N N Y
300 NA NA N N N N Y
341 NA NA N N N N N
383 NA NA Y N Y N N
425 NA NA N N Y N N
467 NA NA N N N N Y
509 NA NA Y N N Y Y
554 NA NA N N N N Y
593 NA NA N N N N
628 NA NA Y N N N Y
663 NA NA N N N N Y
699 NA NA N N Y N Y
734 NA NA N N N N Y
770 NA NA N N N N Y
pred_other_raptor pred_other_avian pred_misc total_pefa total_coy_fox
12 Y Y N 17 0
43 Y N Y NA NA
76 N N N 0 0
108 N Y N NA NA
144 NA NA
182 Y Y N NA NA
220 Y N N NA NA
260 N N N NA NA
300 N Y N NA NA
341 Y Y N NA NA
383 N N N NA NA
425 N N Y NA NA
467 N N N NA NA
509 N Y N NA NA
554 N N N NA NA
593 Y N NA NA
628 N N NA NA
663 N N N NA NA
699 Y N N NA NA
734 Y N Y NA NA
770 N N N NA NA
total_meso total_owlspp total_corvid total_other_raptor total_other_avian
12 0 0 0 4 24
43 NA NA NA NA NA
76 0 NA 6 0 0
108 NA NA NA NA NA
144 NA NA NA NA NA
182 NA NA NA NA NA
220 NA NA NA NA NA
260 NA NA NA NA NA
300 NA NA NA NA NA
341 NA NA NA NA NA
383 NA NA NA NA NA
425 NA NA NA NA NA
467 NA NA NA NA NA
509 NA NA NA NA NA
554 NA NA NA NA NA
593 NA NA NA NA NA
628 NA NA NA NA NA
663 NA NA NA NA NA
699 NA NA NA NA NA
734 NA NA NA NA NA
770 NA NA NA NA NA
total_misc first_observed last_observed first_nest first_chick first_fledge
12 0 2000-04-28 2000-08-20 2000-05-10 3000-06-02 2000-06-22
43 NA 2004-05-03 2004-08-19 2004-05-19 2004-06-09 2004-06-30
76 0 2005-06-01 2005-06-24
108 NA 2006-04-22 2006-08-17 2006-05-14 2006-06-11 2006-07-04
144 NA
182 NA 2008-05-01 2008-08-17 2008-05-21 2008-06-04 2008-06-29
220 NA 2009-04-26 2009-08-15 2009-05-21 2009-06-17 2009-07-05
260 NA 2010-05-13 2010-07-29 2010-05-22 2010-06-16 2010-07-09
300 NA 2011-04-27 2011-08-02 2011-06-08 2011-07-10
341 NA 2012-04-20 2012-07-25 2012-05-14 2012-06-06 2012-06-27
383 NA 2013-06-01 2013-07-21 2013-05-26 2013-06-13 2013-07-11
425 NA 2014-05-22 2014-07-27 2014-05-22 2014-06-09 2014-07-03
467 NA 2015-05-14 2015-06-22 2015-05-14 2015-06-08
509 NA 2016-04-20 2016-08-18 2016-05-16 2016-06-10 2016-06-27
554 NA 2017-05-10 2017-07-17 2017-05-19
593 NA 2018-04-20 2018-08-04 2018-05-14 2018-06-08 2018-06-27
628 NA 2019-04-26 2019-08-10 2019-05-10 2019-06-03 2019-06-28
663 NA 2020-04-26 2020-08-16 2020-07-03 2020-07-20 2020-08-13
699 NA 2021-04-21 2021-08-05 2021-05-17 2021-06-14
734 NA 2022-04-30 2022-07-22 2022-05-21 2022-06-19
770 NA 2023-04-28 2023-06-14 2023-05-24 Section 15.4 describes various operators and functions you can use to write more complicated conditions.
Notice that in the condition, we had to write terns$site_name rather than just the column name site_name. We have to specify that we mean a column in terns because the indexing operator doesn’t make any assumptions about what is or isn’t a column name. But most of the time, we filter rows by testing conditions on the columns. Typing the name of the data frame (for example, terns$) in front of every column name makes writing complicated conditions tedious.
The dplyr package’s filter function is another way to filter the rows of a data frame. By assuming that names refer to column names, filter makes writing conditions less tedious. The first argument to filter is the data frame to filter, while the second is the condition. Here’s how to get the Los Angeles Harbor rows from the least terns dataset:
filter(terns, site_name == "LA HARBOR") year site_name site_name_2013_2018 site_name_1988_2001 site_abbr region_3
1 2000 LA HARBOR Port of LA NA_2013_2018 POLYGON LA_HARB SOUTHERN
2 2004 LA HARBOR Port of LA NA_2013_2018 POLYGON LA_HARB SOUTHERN
3 2005 LA HARBOR Port of LA NA_2013_2018 POLYGON LA_HARB SOUTHERN
4 2006 LA HARBOR Port of LA NA_2013_2018 POLYGON LA_HARB SOUTHERN
5 2007 LA HARBOR Port of LA NA_2013_2018 POLYGON LA_HARB SOUTHERN
6 2008 LA HARBOR Port of LA NA_2013_2018 POLYGON LA_HARB SOUTHERN
7 2009 LA HARBOR Port of LA NA_2013_2018 POLYGON LA_HARB SOUTHERN
8 2010 LA HARBOR Port of LA NA_2013_2018 POLYGON LA_HARB SOUTHERN
9 2011 LA HARBOR Port of LA NA_2013_2018 POLYGON LA_HARB SOUTHERN
10 2012 LA HARBOR Port of LA NA_2013_2018 POLYGON LA_HARB SOUTHERN
11 2013 LA HARBOR Port of LA NA_2013_2018 POLYGON LA_HARB SOUTHERN
12 2014 LA HARBOR Port of LA NA_2013_2018 POLYGON LA_HARB SOUTHERN
13 2015 LA HARBOR Port of LA NA_2013_2018 POLYGON LA_HARB SOUTHERN
14 2016 LA HARBOR Port of LA NA_2013_2018 POLYGON LA_HARB SOUTHERN
15 2017 LA HARBOR Port of LA NA_2013_2018 POLYGON LA_HARB SOUTHERN
16 2018 LA HARBOR Port of LA NA_2013_2018 POLYGON LA_HARB SOUTHERN
17 2019 LA HARBOR Port of LA NA_2013_2018 POLYGON LA_HARB SOUTHERN
18 2020 LA HARBOR Port of LA NA_2013_2018 POLYGON LA_HARB SOUTHERN
19 2021 LA HARBOR Port of LA NA_2013_2018 POLYGON LA_HARB SOUTHERN
20 2022 LA HARBOR Port of LA NA_2013_2018 POLYGON LA_HARB SOUTHERN
21 2023 LA HARBOR Port of LA NA_2013_2018 POLYGON LA_HARB SOUTHERN
region_4 event bp_min bp_max fl_min fl_max total_nests nonpred_eggs
1 SOUTHERN LA_NINA 437 437 570 570 565 77
2 SOUTHERN NEUTRAL 951 951 556 556 1071 179
3 SOUTHERN NEUTRAL 1254 1254 449 687 1332 217
4 SOUTHERN NEUTRAL 835 835 511 771 907 434
5 SOUTHERN EL_NINO 669 669 186 186 710 385
6 SOUTHERN LA_NINA 486 515 210 210 529 277
7 SOUTHERN NEUTRAL 371 385 75 75 435 328
8 SOUTHERN EL_NINO 149 195 4 4 216 158
9 SOUTHERN LA_NINA 7 8 0 0 10 11
10 SOUTHERN LA_NINA 144 207 35 35 211 77
11 SOUTHERN NEUTRAL 237 239 31 147 254 116
12 SOUTHERN NEUTRAL 110 112 16 112 126 59
13 SOUTHERN NEUTRAL 103 109 0 0 109 130
14 SOUTHERN EL_NINO 109 141 46 70 141 87
15 SOUTHERN NEUTRAL 0 5 0 0 5 0
16 SOUTHERN NEUTRAL 105 117 69 69 133 58
17 SOUTHERN NEUTRAL 161 184 97 97 199 71
18 SOUTHERN NEUTRAL 91 182 3 111 182 0
19 SOUTHERN LA_NINA 170 188 38 142 198 112
20 SOUTHERN LA_NINA 172 177 2 4 189 146
21 SOUTHERN LA_NINA 1 55 0 0 56 37
nonpred_chicks nonpred_fl nonpred_ad pred_control pred_eggs pred_chicks
1 NA NA NA 24 NA
2 453 31 12 NA NA
3 868 13 3 6 0
4 253 7 7 27 0
5 NA NA NA NA NA
6 153 1 2 NA NA
7 123 3 1 NA NA
8 6 0 0 NA NA
9 5 0 0 Y NA NA
10 84 1 1 Y NA NA
11 107 0 0 Y NA NA
12 12 NA NA Y NA NA
13 NA NA NA Y NA NA
14 10 0 0 Y NA NA
15 0 0 0 Y NA NA
16 7 0 0 Y NA NA
17 28 0 0 Y NA NA
18 18 0 0 Y NA NA
19 48 0 0 Y NA NA
20 9 0 0 Y NA NA
21 0 0 0 Y NA NA
pred_fl pred_ad pred_pefa pred_coy_fox pred_meso pred_owlspp pred_corvid
1 15 NA Y N N N N
2 NA NA Y N Y Y Y
3 0 0 N N N Y Y
4 0 7 Y N N Y Y
5 NA NA
6 NA NA Y N N Y Y
7 NA NA Y N N Y Y
8 NA NA N N N N Y
9 NA NA N N N N Y
10 NA NA N N N N N
11 NA NA Y N Y N N
12 NA NA N N Y N N
13 NA NA N N N N Y
14 NA NA Y N N Y Y
15 NA NA N N N N Y
16 NA NA N N N N
17 NA NA Y N N N Y
18 NA NA N N N N Y
19 NA NA N N Y N Y
20 NA NA N N N N Y
21 NA NA N N N N Y
pred_other_raptor pred_other_avian pred_misc total_pefa total_coy_fox
1 Y Y N 17 0
2 Y N Y NA NA
3 N N N 0 0
4 N Y N NA NA
5 NA NA
6 Y Y N NA NA
7 Y N N NA NA
8 N N N NA NA
9 N Y N NA NA
10 Y Y N NA NA
11 N N N NA NA
12 N N Y NA NA
13 N N N NA NA
14 N Y N NA NA
15 N N N NA NA
16 Y N NA NA
17 N N NA NA
18 N N N NA NA
19 Y N N NA NA
20 Y N Y NA NA
21 N N N NA NA
total_meso total_owlspp total_corvid total_other_raptor total_other_avian
1 0 0 0 4 24
2 NA NA NA NA NA
3 0 NA 6 0 0
4 NA NA NA NA NA
5 NA NA NA NA NA
6 NA NA NA NA NA
7 NA NA NA NA NA
8 NA NA NA NA NA
9 NA NA NA NA NA
10 NA NA NA NA NA
11 NA NA NA NA NA
12 NA NA NA NA NA
13 NA NA NA NA NA
14 NA NA NA NA NA
15 NA NA NA NA NA
16 NA NA NA NA NA
17 NA NA NA NA NA
18 NA NA NA NA NA
19 NA NA NA NA NA
20 NA NA NA NA NA
21 NA NA NA NA NA
total_misc first_observed last_observed first_nest first_chick first_fledge
1 0 2000-04-28 2000-08-20 2000-05-10 3000-06-02 2000-06-22
2 NA 2004-05-03 2004-08-19 2004-05-19 2004-06-09 2004-06-30
3 0 2005-06-01 2005-06-24
4 NA 2006-04-22 2006-08-17 2006-05-14 2006-06-11 2006-07-04
5 NA
6 NA 2008-05-01 2008-08-17 2008-05-21 2008-06-04 2008-06-29
7 NA 2009-04-26 2009-08-15 2009-05-21 2009-06-17 2009-07-05
8 NA 2010-05-13 2010-07-29 2010-05-22 2010-06-16 2010-07-09
9 NA 2011-04-27 2011-08-02 2011-06-08 2011-07-10
10 NA 2012-04-20 2012-07-25 2012-05-14 2012-06-06 2012-06-27
11 NA 2013-06-01 2013-07-21 2013-05-26 2013-06-13 2013-07-11
12 NA 2014-05-22 2014-07-27 2014-05-22 2014-06-09 2014-07-03
13 NA 2015-05-14 2015-06-22 2015-05-14 2015-06-08
14 NA 2016-04-20 2016-08-18 2016-05-16 2016-06-10 2016-06-27
15 NA 2017-05-10 2017-07-17 2017-05-19
16 NA 2018-04-20 2018-08-04 2018-05-14 2018-06-08 2018-06-27
17 NA 2019-04-26 2019-08-10 2019-05-10 2019-06-03 2019-06-28
18 NA 2020-04-26 2020-08-16 2020-07-03 2020-07-20 2020-08-13
19 NA 2021-04-21 2021-08-05 2021-05-17 2021-06-14
20 NA 2022-04-30 2022-07-22 2022-05-21 2022-06-19
21 NA 2023-04-28 2023-06-14 2023-05-24 You can pass additional conditions to filter as additional arguments. All of them must be satisfied (TRUE) for a row to be kept.
Note
R’s built-in subset function is similar to and might have inspired dplyr’s filter function. Here’s how to use it to get all of the Los Angeles Harbor rows:
subset(terns, site_name == "LA HARBOR")The subset function is a good alternative if you prefer not to use dplyr.
Both the indexing operator and dplyr’s filter function are good ways to filter rows in a data frame. The indexing operator has the advantage that you can simultaneously use it to select columns by filling in the second argument. On the other hand, the filter function makes complicated conditions easier to type and read—this might seem like a small advantage, but code clarity is important.
15.4 Logic Operators
All of the conditions we’ve seen so far have been written in terms of a single test. If you want to use more sophisticated conditions, R provides operators to negate and combine logical vectors. These operators are useful for working with logical vectors even outside the context of indexing.
15.4.1 Negation
The NOT operator ! converts TRUE to FALSE and FALSE to TRUE:
x = c(TRUE, FALSE, TRUE, TRUE, NA)
x[1] TRUE FALSE TRUE TRUE NA!x[1] FALSE TRUE FALSE FALSE NAYou can use ! with a condition:
y = c("hi", "hello")
!(y == "hi")[1] FALSE TRUEThe NOT operator is vectorized.
15.4.2 Combinations
R also has operators for combining logical values.
The AND operator & returns TRUE only when both arguments are TRUE. Here are some examples:
FALSE & FALSE[1] FALSETRUE & FALSE[1] FALSEFALSE & TRUE[1] FALSETRUE & TRUE[1] TRUEc(TRUE, FALSE, TRUE) & c(TRUE, TRUE, FALSE)[1] TRUE FALSE FALSEThe OR operator | returns TRUE when at least one argument is TRUE. Let’s see some examples:
FALSE | FALSE[1] FALSETRUE | FALSE[1] TRUEFALSE | TRUE[1] TRUETRUE | TRUE[1] TRUEc(TRUE, FALSE) | c(TRUE, TRUE)[1] TRUE TRUEThe combination operators are vectorized.
Warning
Be careful: everyday English is less precise than logic. You might say:
I want all subjects with age over 50 and all subjects that like cats.
But in logic this means:
(subject age over 50) OR (subject likes cats)
So think carefully about whether you need both conditions to be true (AND) or at least one (OR).
NoteShort-circuit Operators
The second argument is irrelevant in some conditions:
FALSE &is alwaysFALSETRUE |is alwaysTRUE
Now imagine you have FALSE & long_computation(). You can save time by skipping long_computation(). A short-circuit operator does exactly that.
R has two short-circuit operators:
&&is a short-circuited&||is a short-circuited|
These operators only evaluate the second argument if it is necessary to determine the result. Here are some of these:
TRUE && FALSE[1] FALSETRUE && TRUE[1] TRUETRUE || TRUE[1] TRUEThe short-circuit operators are not vectorized—they only accept length-1 arguments:
c(TRUE, FALSE) && c(TRUE, TRUE)Error in c(TRUE, FALSE) && c(TRUE, TRUE): 'length = 2' in coercion to 'logical(1)'Because of this, you can’t use short-circuit operators for indexing. Their main use is in writing conditions for if-expressions, which we’ll learn about later on.
Prior to R 4.3.0, short-circuit operators didn’t raise an error for inputs with length greater than 1 (and thus were a common source of bugs).
NoteExclusive OR
Rarely, you might want exactly one condition to be true. The XOR (eXclusive OR) function xor() returns TRUE when exactly one argument is TRUE. For example:
xor(FALSE, FALSE)[1] FALSExor(TRUE, FALSE)[1] TRUExor(TRUE, TRUE)[1] FALSE