SPBModel Input Sample

The SharpHog Southern Pine Beetle Infestation Model Administration Application for the Windows Desktop can load Xml formatted to the Spot-Growth Database project's SpotGrowth Xml schema, and convert it to a SharpHog dataset containing only input for the model, based on the Spot-Visits in the source data.

Right-Click to Save the Sample SharpHog Model Input DataSet

Data from the Spot and Visit tables (SharpSpb Xml has been designed to mimic traditional data-tables) of the Spot-Growth Database information have been transformed into data for the Batch and Frame tables of the SPBModel Schema. The third table in the SharpHog Model's SPBModel schema is the EngineOuput table. This example xml contains Input data for SharpHog only, so there is no data yet in the EngineOutput table (no EngineOutput elements in the Xml).

<?xml version="1.0" standalone="yes"?>

<SPBModel>

  <Batch>

    <!--  //    This text has been truncated for display.  Use one of the links to get the entire file -->

    <BatchId>b1a12422-AL-COOSA15</BatchId>

    <BatchName>COOSA15</BatchName>

    <BatchDescription>

      Created from Field Data

      COOSA15 in Alabama

    </BatchDescription>

    <BatchXslt>UseDefaultXslt</BatchXslt>

    <Frame>

      <BatchId>b1a12422-AL-COOSA15</BatchId>

      <FrameId>a85dd8a6-COOSA15V1-.SPB</FrameId>

      <IsModelInputFrame>true</IsModelInputFrame>

      <FrameName>AL-COOSA15V1</FrameName>

      <FrameDescription>

        Frame based on visit 1, COOSA15V1, to spot COOSA15 in Alabama.

        Visit 1 to spot COOSA15 From File: COOSA15V1.SPB

        Long-Name from the .SPB file:

        COOSA NAT'L FOREST, SPOT 15

      </FrameDescription>

      <FrameConfig>

        &lt;FrameConfig&gt;

        &lt;RunDuration&gt;92&lt;/RunDuration&gt;

        &lt;ReportHour&gt;2&lt;/ReportHour&gt;

        &lt;TemperatureOffset&gt;0.0&lt;/TemperatureOffset&gt;

        &lt;CohortCount&gt;

        &lt;Attacking&gt;50&lt;/Attacking&gt;

        &lt;Parent&gt;50&lt;/Parent&gt;

        &lt;Egg&gt;200&lt;/Egg&gt;

        &lt;Immature&gt;500&lt;/Immature&gt;

        &lt;Brood&gt;250&lt;/Brood&gt;

        &lt;Emerging&gt;1&lt;/Emerging&gt;

        &lt;/CohortCount&gt;

        &lt;/FrameConfig&gt;

      </FrameConfig>

      <StartDate>1980-08-29T02:00:00-07:00</StartDate>

      <Latitude>32.7</Latitude>

      <Longitude>-86.5</Longitude>

      <LoblollyRatio>1</LoblollyRatio>

      <ShortleafRatio>0</ShortleafRatio>

      <PineBasalArea>30.616477300000003</PineBasalArea>

      <HardwoodBasalArea>2.29681</HardwoodBasalArea>

      <DiameterBreastHeight>15.748000000000001</DiameterBreastHeight>

      <MeanPineAge>18</MeanPineAge>

      <FiveYearGrowth>12.324</FiveYearGrowth>

      <PreviouslyInfested>303</PreviouslyInfested>

      <CurrentlyInfested>24</CurrentlyInfested>

      <TreesAttacking>6</TreesAttacking>

      <TreesEgg>2</TreesEgg>

      <TreesImmature>14</TreesImmature>

      <TreesBrood>2</TreesBrood>

    </Frame>

    <!--  //    This text has been truncated for display.  Use one of the links to get the entire file -->

    <Frame>

      <BatchId>b1a12422-AL-COOSA15</BatchId>

      <FrameId>fd59bab1-COOSA15V7-.DEN</FrameId>

      <IsModelInputFrame>false</IsModelInputFrame>

      <FrameName>AL-COOSA15V7</FrameName>

      <FrameDescription>

        Frame based on visit 7, COOSA15V7, to spot COOSA15 in Alabama.

        Visit Created From DEN2 CSV Data

      </FrameDescription>

      <FrameConfig>

        &lt;FrameConfig&gt;

        &lt;RunDuration&gt;92&lt;/RunDuration&gt;

        &lt;ReportHour&gt;2&lt;/ReportHour&gt;

        &lt;TemperatureOffset&gt;0.0&lt;/TemperatureOffset&gt;

        &lt;CohortCount&gt;

        &lt;Attacking&gt;50&lt;/Attacking&gt;

        &lt;Parent&gt;50&lt;/Parent&gt;

        &lt;Egg&gt;200&lt;/Egg&gt;

        &lt;Immature&gt;500&lt;/Immature&gt;

        &lt;Brood&gt;250&lt;/Brood&gt;

        &lt;Emerging&gt;1&lt;/Emerging&gt;

        &lt;/CohortCount&gt;

        &lt;/FrameConfig&gt;

      </FrameConfig>

      <StartDate>1980-10-10T02:00:00-07:00</StartDate>

      <Latitude>32.7</Latitude>

      <Longitude>-86.5</Longitude>

      <LoblollyRatio>1</LoblollyRatio>

      <ShortleafRatio>0</ShortleafRatio>

      <PineBasalArea>30.616477300000003</PineBasalArea>

      <HardwoodBasalArea>2.29681</HardwoodBasalArea>

      <DiameterBreastHeight>15.748000000000001</DiameterBreastHeight>

      <MeanPineAge>18</MeanPineAge>

      <FiveYearGrowth>12.324</FiveYearGrowth>

      <PreviouslyInfested>327</PreviouslyInfested>

      <CurrentlyInfested>16</CurrentlyInfested>

      <TreesAttacking>0</TreesAttacking>

      <TreesEgg>0</TreesEgg>

      <TreesImmature>0</TreesImmature>

      <TreesBrood>0</TreesBrood>

    </Frame>

  </Batch>

</SPBModel>