EVALIDator Version 1.5.00

USFS Logo

EVALIDator Version 1.5.00 Revision date: Sept. 14,2011

Step 1 of 3

Retrieval Type

You may choose the way in which the FIA Retrieval System selects data from the database. The options are State or Circle (to run a polygon retrieval choose State and then add Oracle spatial command to the textbox in step 3). If you choose a circle option you must enter the latitude and longitude of point center in decimal degrees (the latitude and longitude of Duluth, for example, are 46.78 decimal degrees north and 92.12 decimal degrees west) and enter the circle radius in miles. You may obtain the latitude and longitude of a particular city or town through the U.S. Census Bureau Gazetteer. Note: Longitude should be a negative number for the western hemisphere.
State retrieval Circle Retrieval
Latitude:
Longitude:
Radius(miles):
Polygon retrievals can be run by adding a SQL filtering clause via the textbox in step 3. Filtering clauses using Oracle Spatial
Example 1 Polygon with 5 vertices in Minnesota (note: first and last coordinate pairs must be the same - run time approximately 1 second): and plot.cn in ( SELECT /*+ ordered */ CN FROM fs_fia_spatial.fiadb3_plot_geom c WHERE sdo_relate(c.geom, sdo_geometry(2003, 8265, null, sdo_elem_info_array(1, 1003, 1), sdo_ordinate_array(-93,45, -94,45, -94.5,44.5, -94,44, -93,44, -93,45)), 'mask=ANYINTERACT querytype=WINDOW') = 'TRUE')
Example 2 50km buffer around Interstate 94 and limit to Stearns County, MN (note: run time approximately 2 minutes) and plot.cn in (SELECT /*+ ordered */ CN FROM FS_FIA_SPATIAL.US_INTERSTATES_8265 B, fs_fia_spatial.fiadb3_plot_geom c WHERE (sdo_relate(C.geom,sdo_geom.sdo_buffer (b.geomETRY,50,0.5,'ARC_TOLERANCE=0.05 UNIT=KM'), 'mask=ANYINTERACT querytype=WINDOW') = 'TRUE') and c.statecd=27 and c.countycd=145 and b.interstate='I94')


Attribute order in drop-down list.
Area
Numbers of trees (forestland then timberland)
Volume (forestland then timberland)
Biomass (forestland then timberland)
Growth (forestland then timberland)
Mortality (forestland then timberland)
Removals (forestland then timberland)
Forest carbon (forestland then timberland)
Number of seedlings (forestland then timberland)

Please choose an attribute from the dropdown list below.

There are 101 types of population attributes.


sessionid=3D8514EA49E475454C70EC0192154751 remoteaddress=165.221.108.17