Also, if the window pops up, you should select “create index” “YES”: Lets join the ETrF from METRIC to the NLCD table also. Repeat the same joining process for the NLCD table. However, this time you need to select the second column from the list. It “FID” will have an next to it in the table above. In the join list below, it will be the second FID ‘*’ entry. Change the column header to ETrF_METRIC. Repeat this joining process for the ‘Mean’ sampled_ETrF_METRIC and sampled_LST tables. Each time, select the in the ‘last’ “FID” drop down list for the common field, and each time, rename to a unique name. “Mean” When we are finished with the joining of the five tables, the final table for Sample_NLCD should look like the following: Step 2. Exporting the Table to Excel Now we can export the sampled_NLCD table to a dbf so that we can open it in Excel. From the open sampled_NLCD table, click in the upper lefthand corner and select and “export” specify a file type and name. Place the exported file into your project folder so that you ‘.dbf’ can find it. In the second menu that shows up, you will want to export ‘all records.’ I named my dbf file “Sampled_NLCD_NDVI_ETrF_LST.dbf”. Now, open Excel, and go to the folder where the dbf is stored: (make sure that the files “All is selected so that the file shows up (*.*)” ‘.dbf’ The table will be opened in Excel, and it will look like a mess: So, the first thing we should do is to format columns so that they are easier to look at (NLCD should have no decimals, NDVI and ETrF should have three decimals and LST one decimal).
Also, if the “create index” window pops up, you should select “YES”: Lets join the ETrF from METRIC to the NLCD table also. Repeat the same joining process for the NLCD table. However, this time you need to select the second “FID” column from the list. It will have an ‘*’ next to it in the table above. In the join list below, it will be the second FID entry. Change the column header ‘Mean’ to ETrF_METRIC. Repeat this joining process for the sampled_ETrF_METRIC and sampled_LST tables. Each time, select the ‘last’ “FID” in the drop down list for the common field, and each time, rename “Mean” to a unique name. When we are finished with the joining of the five tables, the final table for Sample_NLCD should look like the following: Step 2. Exporting the Table to Excel Now we can export the sampled_NLCD table to a dbf so that we can open it in Excel. From the open sampled_NLCD table, click in the upper lefthand corner and select “export” and specify a ‘.dbf’ file type and name. Place the exported file into your project folder so that you can find it. In the second menu that shows up, you will want to export ‘all records.’ I named my dbf file “Sampled_NLCD_NDVI_ETrF_LST.dbf”. Now, open Excel, and go to the folder where the dbf is stored: (make sure that the “All files (*.*)” is selected so that the ‘.dbf’ file shows up The table will be opened in Excel, and it will look like a mess: So, the first thing we should do is to format columns so that they are easier to look at (NLCD should have no decimals, NDVI and ETrF should have three decimals and LST one decimal).
Ex6_North%20Platte%20with%20NDVI%20based%20ET%20and%20EEFlux.docx