This article and its child articles discuss and illustrate a possible workflow with SharpSpb.

Our goal for this exercise is to run the model on some real field data based input, then compare the model's predictions from this input set to the actual observed conditions in the field for a given number of days elapsed.  We only want a crude enough output to confirm the model is behaving correctly--a true statistical analysis of accuracy would involve many more Spots and Vists.  We just want to eyeball things.

Here's how we can achieve this.  The Spot-Growth Database Administration Application can read a great number of different file formats representing actual Visits to actual Spots.  A random selection from a big pool of data files is loaded.

That data is saved as SpotGrowth Xml (Xml data adhering to the rules defined in the SpotGrowth.xsd schema).

The data is also saved as Excel Workbook Xml, for browsing as a spreadsheet.

The SharpHog Southern Pine Beetle Infestation Model Administration Application can load SpotGrowth or SPBModel xml.

It loads the SpotGrowth xml saved previously by the SGDB Admin App.

The former field data is now formally structured input for the SharpHog model.  The same data is now saved by the SharpHog SPBIM Admin App in the SPBModel.xsd format.  This new file contains input for the model, but no output data has been calculated or added yet: the file is labeled to indicate that.

The SharpHog SPBIM Admin App runs the input data through the model

The SharpHog SPBIM Admin App saves the Output dataset as a differently named SharpHog xml file.  One sharphog xml file contains only input, in case we want to play with it.  The new xml file contains both the original input, and the resulting output as well.

We could read the SharpHog Model Output Xml in a text editor, but an easier method is to apply an Xsl transform to the Output SPBModel Xml that extracts and analyzes the numbers we are currently interested in.  A transform is created and applied which outputs the results as a table in Html, ready for display in a web-page.

  • Folder of Spot Visits

    Here's a typical collection of Southern Pine Beetle infestation field data.  Two different formats in this folder alone, a single visit is a single file, and there are hundreds to thousands of them.    

    Continued. . .
    Tuesday, July 14, 2009
  • SGDB Admin Loads Field Data

    Data--in formats described in The Old Way, such as the 'SPB' & 'DEN2' supplementals--was loaded from electronic files using the Spot Growth Database Administration Application.  The SGDB Admin App immediately converts the information from the various formats into SpotGrowth Schema Xml and Metric Units.   Note redundant references to the original data-source throughout the SpotGrowth data.  Spot Name & Visit Name come directly from the filename--which is included in the Visit Description.  The Fingerprint table stores the First Seen Data Format & if the Original Units [were in] Imperial

    Continued. . .
    Monday, July 13, 2009
  • Excel Examines the Tables

    Using this Xslt code, the Spot-Growth Database Administration Application can save SpotGroth xml as Excel Workbook Xml.   When an Xml file adheres to an Office Document schema, the icon changes in Explorer     The SGDB Admin App is one, very specialized, tool for working with SpotGrowth xml. If a user preferred another environment, not only could they transform SpotGrowth xml to Excel xml as demonstrated here, they could also transform from Excel xml to SpotGrowth xml. Any Generic Tool Can Be Used to Create SpotGrowth Data. If a user has a lot of data-entry by hand they have to do, they should enter it into the application they are most comfortable with, then transform it to

    Continued. . .
    Tuesday, July 14, 2009
  • SharpHog Input Set Sample

    The SharpHog Southern Pine Beetle Infestation Administration Application for the Windows Desktop reads the SpotGrowth field data in directly as input for the model.      

    Continued. . .
    Tuesday, July 14, 2009
  • SharpHog Output Summary Sample

    The SharpHog Southern Pine Beetle Infestation Administration Application for Windows Desktop Running the Model My computer is extraordinarily old & slow-- modern computers complete model runs in under a second.

    Continued. . .
    Tuesday, July 14, 2009
  • Web Page Tells Us What We Want to Know

    The SharpHog Output Xml is transformed with a rough xslt query, to output a table of results in Html for viewing in Web-Pages.

    Right-Click to Save the Entire Sample SharpHog SPBModel Output DataSet
    Continued. . .
    Tuesday, July 14, 2009
Check XHTML « spb.xanderlih.com Copyright © Xander Lih 2000-2012  » Check CSS