The Row text area and Column text area boxes may be used to submit plot values for reporting purposes. These are used when each FIA plot can be assigned some meaningful value, usually based on plot location. Distinct meaningful values then become either the row or column headings in the report.
Suppose, for example, that the Chippewa National Forest planner wants to generate forest statistics by ranger district. Unfortunately, ranger district information is not available in the Forest Inventory and Analysis Database (FIADB). However, latitude and longitude information is available in the FIADB. So if the planner had a map of ranger district boundaries, and could overlay FIA plot locations on that map, the planner could then assign ranger district values to each FIA plot.
FIA plot locations can be obtained from either the FIA DataMart, or by using an API request to generate a list of plot Control Numbers (CNs) and their associated longitude and latitudes.
Here is an example API request that will return plot CNs and longitude and latitude for each plot inventoried in Minnesota from 2011 to 2015:
https://apps.fs.usda.gov/fiadb-api/refTable?colList=CN,LON,LAT&tableName=PLOT&whereStr= statecd=27%20and%20invyr%20in(2011,2012,2013,2014,2015)&outputFormat=CSV
The above request would return data in the following format:
The planner could then overlay these points on a shapefile containing the district boundaries to generate a list of plot CNs and their corresponding ranger district values. The planner would then copy this information into either the Row text area box or the Column text area box. The records should be in this format:
Copying the text from above and pasting it into the row text area will result in a table that would look similar to this:
| All live stocking | ||||||
|---|---|---|---|---|---|---|
| User defined function | Total | Overstocked | Fully stocked | Medium stocked | Poorly stocked | Nonstocked |
| Total | 19,684,285,477 | 2,174,288,490 | 10,566,655,780 | 5,843,133,449 | 1,082,929,415 | 17,278,343 |
| Deer River Ranger District | 8,988,429 | - | 8,988,429 | - | - | - |
| Not Specified | 19,663,951,927 | 2,170,942,667 | 10,549,668,053 | 5,843,133,449 | 1,082,929,415 | 17,278,343 |
| Walker Ranger District | 11,345,121 | 3,345,823 | 7,999,298 | - | - | - |
There must be a comma after each plot control number and after each value. If this data was placed in the Row text area box, then the resulting table will display the user defined ranger district labels for each row. Additionally, there is a limit (approximately 500,000 characters) to how much information can be placed inside a text area box. If you need to submit more than 500,000 characters you can use the "fullreport" POST function (see the FIADB-API & EVALIDator User Documentation for details).
The following Oracle SQL Script can be used to generate plot.cn/estimation unit pairs for the 2016 inventories of Delaware and Maryland. The resulting output can be copied into a text area box so that EVALIDator estimates can be reported by estimation unit.
select distinct
'"' ||
PLOT.CN ||
'","' ||
(RTRIM(SUBSTR(FS_FIADB.EVALIDATORFUNCTIONS.STATECDLABEL(PLOT.STATECD),10,64)
|| ' ' ||
(SELECT replace(coalesce(ESTN_UNIT_DESCR,'Not
available'),',',';')
FROM FS_FIADB.POP_ESTN_UNIT
WHERE
pop_estn_unit.CN = ESTN_UNIT_CN)))||
'",' DESCR
FROM FS_FIADB.POP_STRATUM POP_STRATUM
join
FS_FIADB.POP_PLOT_STRATUM_ASSGN
on
(POP_PLOT_STRATUM_ASSGN.STRATUM_CN = POP_STRATUM.CN)
join
FS_FIADB.PLOT
on (POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN)
JOIN FS_FIADB.COND
ON (COND.PLT_CN = PLOT.CN)
WHERE
COND.CONDPROP_UNADJ IS NOT NULL
AND ((pop_stratum.rscd = 24
and pop_stratum.evalid = 101601) or
(pop_stratum.rscd = 24 and
pop_stratum.evalid = 241601))