Examples of the types of Animal Tissue Output Formats:

The first, third and fourth formats are all a wide flat file with 1 row per sample with each parameters' values and remark across the row (also called a Crosstab or Pivot).

"Counts by Site" Format:

Wide flat file with 1 row per sample with parameters across the row (also called a Crosstab or Pivot).

Notice---Adding parameters to a retrieval will place additional columns to the right indicating individual counts per parameter, per method.

                  Parameter Code 49238 49239 49240 49241
                  Parameter Short Name BARIUM BIO TISS BORON BIO TISS   D. CHROMIUM BIO TISS COPPER BIO TISS
                  Units ug/g ug/g ug/g ug/g
                    Value COUNT Value COUNT Value COUNT Value COUNT
State Postal Code State County Suid Staid Place Name Land Use Group Land Use Code Sample Medium Description Scientific Name Common Name Biological Part          
AR ARKANSAS NEWTON OZRK 07055646 Buffalo River ... OTHER rf ANIMAL TISSUE Lepomis megalotis LONGEAR SUNFISH WHOLE ORGANSIM   1 1 1 1
AR ARKANSAS STONE OZRK 07060716 North Sylamore Creek ... OTHER rf ANIMAL TISSUE Lepomis megalotis LONGEAR SUNFISH WHOLE ORGANSIM   1 1 1 1
Sum                     4 4 2 4

"Serial (Narrow)" Format:

Narrow flat file - 1 row per result (parameter) with each parameter on a different row.

State Postal Code State County Suid Staid Place Name Land Use Group Land Use Code Sample Medium Description Total Area Scientific Name Common Name Biological Part Result Datetime Parameter Code Parameter Short Name Units Remrk Value
AR ARKANSAS NEWTON OZRK 07055646 Buffalo River ... OTHER rf ANIMAL TISSUE 57.4 Lepomis megalotis LONGEAR SUNFISH WHOLE ORGANSIM 11/4/93 11:00 49238 BARIUM BIO TISS
ug/g
 - 0.4
AR ARKANSAS NEWTON OZRK 07055646 Buffalo River ... OTHER rf ANIMAL TISSUE 57.4 Lepomis megalotis LONGEAR SUNFISH WHOLE ORGANSIM 11/4/93 11:00 49239 BORON BIO TISS
ug/g
 - 0.7

"Crosstab - basic" Format:

Wide flat file with 1 row per sample with parameters across the row (also called a Crosstab or Pivot)

                        Parameter Code 49238 49238 49239 49239
                        Parameter Short Name BARIUM BIO TISS BARIUM BIO TISS BORON BIO TISS BORON BIO TISS
                        Units ug/g ug/g ug/g ug/g
                          Remrk Value Remrk Value
State Postal Code State County Suid Staid Place Name Land Use Group Land Use Code Sample Medium Description Total Area Scientific Name Common Name Biological Part Result Datetime          
AR ARKANSAS NEWTON OZRK 07055646 Buffalo River ... OTHER rf ANIMAL TISSUE 57.4 Lepomis megalotis LONGEAR SUNFISH WHOLE ORGANSIM 11/4/93 11:00   - 0.4 - 0.7
AR ARKANSAS STONE OZRK 07060716 North Sylamore Creek ... OTHER rf ANIMAL TISSUE 58.1 Lepomis megalotis LONGEAR SUNFISH WHOLE ORGANSIM 12/14/93 16:30   - 0.1 - 0.6

"Crosstab - expanded" Format:

Wide flat file with 1 row per sample with parameters across the row (also called a Crosstab or Pivot)

                            Parameter Code 49238 49238 49239 49239
                            Parameter Short Name BARIUM BIO TISS BARIUM BIO TISS BORON BIO TISS BORON BIO TISS
                            Units ug/g ug/g ug/g ug/g
                              Remrk Value Remrk Value
State Postal Code State County Suid Staid Place Name Sample Type Land Use Group Land Use Code Land use Sample Medium Description Total Area Scientific Name Common Name Biological Part Result Datetime Columns not shown: HUC, Latitude, Longitude, NAD Indicator, NODC          
AR ARKANSAS NEWTON OZRK 07055646 Buffalo River ... REGULAR OTHER rf REFERENCE ANIMAL TISSUE 57.4 Lepomis megalotis LONGEAR SUNFISH WHOLE ORGANSIM 04-Nov-93 11:0 AM     - 0.4 - 0.7
AR ARKANSAS STONE OZRK 07060710 North Sylamore Creek ... REGULAR OTHER rf REFERENCE ANIMAL TISSUE 58.1 Lepomis megalotis LONGEAR SUNFISH WHOLE ORGANSIM 14-Dec-93 04:30 PM     - 0.1 - 0.6