SPECIATE Online Help

SPECIATE Online Help
The SPECIATE Data Browser is an easy-to-use dashboard that provides access to the data in
EPA's SPECIATE database through a web interface. The SPECIATE Data Browser allows you
to browse information, customize charts and tables, as well as select and download the data of
interest. The SPECIATE Data Browser is accessible on your device through your web browser
and was built using the Qlik Sense® platform. The SPECIATE Data Browser always contains
the most recent SPECIATE data publicly available.
The SPECIATE Data Browser enables you to search or sort on any field in the database. See web
links below for searching features. Right click to export your selection to Excel.
The browser provides 6 main features as briefly explained below
• Profile Info - contains the complete database of all profiles with weight percent by
species in SPECIATE
• Species Detail - provides species properties information
• Custom Table - allows you to select the fields of interest about the profiles
• Weight Bar - allows you to visualize one or more the profiles in a bar chart
• Weight Pie - allows you to graphically view one profile or more profiles in a hollow pie
chart
• Revisions - shows changes made to the data during SPECIATE development
Making Selections
Understanding How to Select Data
Color-Codin
Selected: green and checkmark
Alternative: light gray
Possible: white
Excluded: dark gray
Selected Excluded: dark gray and checkmark
By default, the dataset included in a Qlik Sense® application is the entire dataset. By making a
selection on the dataset, you can begin to focus in on a subset of the data and drill down to
insights and narratives that might not be as apparent when looking at the entire dataset. For
example, trends in analytical methods, test year, or normalization basis might not be visible until
you narrow down the selection of your dataset to a specific region or category level. Qlik Sense®
is based on an associative model, which means that any selections on the dataset will output the
subset of data that is possible based on the selections. Qlik Sense® uses green and red color-
coding to differentiate between different selection states and possible options for filtering the
data.
For example, "CATEGORY LEVEL 1 Generation Mechanism", selecting "Combustion" will
update to display only the rows where CATEGORY_LEVEL_l_Generation_Mechanism is
This document has been reviewed in accordance with U.S. Environmental Protection Agency policy and approved for publication.

-------
"Combustion" and all other generation mechanisms will be hidden. The row and profile code
counts will update to demonstrate the new values.
^speciate logo SPECIATE Data Browser 5.0
H Profile Info S Species Detail S Custom Table |,| \
jar) • Weight % (pie) © Re\.
Profile Information
All profiles | All species
PROFILE CODE CO... CATEGORY_LEVEL_l_Generation... Q. CATEGORY_LEVEL_2_Sector_Eq... Q, CATEGORY_LEVEL_3_ Fuel_Pr... Q, PROFILE.NAME Q.
1 Combustion
1 Combustion
1 Combustion
1 Combustion
1 Combustion
1 Combustion
- * a
a

Q, Search in listbox
| Confirm selection |

Ash

Atomization

Background-air

Chemical reaction

Combustion v

Dust
n

Microbial

Miscellaneous
i

External Combustion
Boiler-Residual Oil
External Combustion
Boiler - Residual Oil
External Combustion
Boiler - Residual Oil
External Combustion
Boiler-Residual Oil
External Combustion
Boiler-Residual Oil
External Combustion
Boiler-Distillate Oil
Users can select CATEGORY LEVEL 2 Sector Equipment "Boiler" by clicking the green
checkmark to confirm selection, it will display all combustion profiles that utilize boiler
equipment. Again, the row and profile code totals will update to demonstrate the diminished
number of observable data.
Each selection made will show in the overhead bar. To de-select a variable, either select that
variable in the table and press the red "X" to de-select, or click the grey "X" in the overhead bar
next to the variable you would like to deselect.
How to Filter Data
Using a Filter Pane
One of the objects used in Qlik Sense® applications is the filter pane. Filter panes can be used to
provide additional flexibility in how values are selected from a given field. As shown below,
filter panes can be used to search directly on all of the values using an open text field. The
Selection menu, shown in the far right, allows you to quickly select all values or change to other
selection states. In this example we typed "Dust" in the filter pane and selected the green
checkmark.
This document has been reviewed in accordance with U.S. Environmental Protection Agency policy and approved for publication.

-------
[o. ft]
^speciate logo SPECIATE Data Browser 5.0
| Custom Table |a| Weights (bar) # Weights (pie) © Revisions
Profile Information
All profiles | All species
ROW COUNT PROFILE CODE CO..

CATEGORY_LEVEL_l_Generation...
Q CATEGORY_LEVEL_2_Sector_Eq...
Q CATEGORY_LEVEL_3_ Fuel_Pr...
Q PROFILE.NAME
Q PROF
1
Dust
Windblown
~
Miscel
aneous
Roof Dust
3544
1
Dust
Windblown

Miscel
aneous
Roof Dust
3544
1
Dust
Windblown

Miscel
aneous
Roof Dust
3544
Types of Selection Methods
You can interact with any Qlik visualization (chart, map, table, etc.) to make selections.
• Click: Click on at least one value or data point to include them in the current selection.
For example, you can click on a pie chart slice to select the dimension associated with
that slice.
• Range: Click on a range of values in either the x- or y-axis of a chart to select those
values.
Searching for Data
Qlik Sense® provides many search options to help you find specific subsets of the data included
in a dashboard.
To search, type a search string into the search bar that opens by clicking on the magnifying glass
in the top left corner above the SPECIATE table or by clicking "Selections" in the top right
corner and search dimensions and fields of the data. After typing in the search string, select the
green checkmark (or enter on your keyboard) to make the selection.
Types of Searches
Qlik Sense ® allows for several different search methods, described below.
Text search
Text search allows for searching by string(s). Additional options include using quotation marks
to combine strings and search for only the entire string rather than individually, or using plus or
minus signs to include or exclude certain strings. Wildcards may also be used. For example,
This document has been reviewed in accordance with U.S. Environmental Protection Agency policy and approved for publication.

-------
can be a placeholder for any number of characters, whereas "?" is a placeholder for a single
character.
CATEGORY.LEV... A
L£ ^ LP Road °
Q "road dust" |
Add to your selections
REF.DOCUMENTS
Rutter, Andrew P, David C Snyder, James J Schauer, Rebecca J Sheesley, Michael R Olson, and Jeff DeMinter. 2011. Contributions of Resuspended Soil and Road Dust to Organic Carbon in Rne Particu
514-18. DOI: 10.1016/j.atmosenv.2010.10.014
TEST_METHOD
Fine particle road dust sample was generated by separately resuspending a road dust sample and then introducing the road dust/air mixture into the residence time chamber of the dilution source sampl
remove coarse particles larger than 1.8 micro meter in diameter and were collected on quartz fiber filters and Teflon filters and then analyzed chemically as described in Schauer, James J., Kleeman, Mike
Emitted from Air Pollution Sources, Final Report, Contract 93-329, Road dust was sampled using a vacuum cleaner during dry weather. Prior to use, the collection nozzle of the vacuum cleaner was was
MilliQ water. All other soil samples were collected by scraping the soil directly into a glass, prebafced sample jar (475oC, 15 hours). The jar itself was used as the collection implement, sealed with Teflon
20 m sections of roadway during dry weather, and sweeping dust from the gutter over similar section lengths after rainfall. Other soil types were collected from two or more sampling locations in a 1-10
Changes
PM profile #3712 was named 'Unpaved road dust'. It was renamed as 'Local Soil'., PM profile #3713 was named 'Unpaved road dust'. It was renames as 'paved road dust'.. PM profiles #3514-3516 wer
The PM_Profile.Notes field for profile #s 4066-4067 were updated as "Composite of paved road dust samples collected from:l. Congreso de la Union Avenue., La Merced (9/26/97), 2. Central Avenue.,)
PM_Profile.Notes field for profile #s 4068-4069 were updated as "Composite of unpaved road dust samples collected from 1. Nameless street by the side of Avenue Central in Xalostoc, Xalostoc" 2 m
KEYWORD
road dust fine particles, Paved Road Dust; PM Composite, Unpaved Road Dust; PM Composite, Unpaved Road Dust; Inventory speciation, Paved Road Dust; Inventory speciation 14 more
REF.DESCRIPTION
Composite, 4 samples. Visalia paved road dust., Crows Landing paved road dust, Unpaved road dust. Kern Wildlife Refuge., Paved road dust, vacuum dust sample collected from downtown Santa Bart
49 more
Show me more
Fuzzy search
Placing a character at the beginning of search string allows for fuzzy matching, which
displays results that are similar to the search string(s) but not necessarily exact matches.
Numeric search
Numeric values can be searched using relational operators to find values greater than, less than,
and/or equal to the search string value. This is very similar to text search. The only difference is
that the search string must begin with one of the following relational operators: ">",
or "<="
This document has been reviewed in accordance with U.S. Environmental Protection Agency policy and approved for publication.

-------
Q. >24|
SAMPLES
>24
Using Custom Table, Weight % (Bar), and Weight % (Pie)
Custom Table:
The selections you make will always carry over unless you de-select them in the overhead bar or
by clicking and deselecting the value in the table. In Custom Table, these values are displayed on
a new overhead bar and on the left-side panel. You may add and remove dimensions and
measures as desired from the left-side panel, as well as make selections within broader categories
within the table.
Weight % (Bar):
The Weight % (Bar) is a profile comparison by weight percent. Again, previous selections will
be demonstrated here, or alternatively, you can choose from listed species names on the right-
hand panel. To make multiple selections, click all desired species names before clicking the
green check mark to confirm your selection.
Weight % (Pie):
Weight % (Pie) is a weight percent profile comparison displayed in a pie chart. Again, previous
selections will be displayed in the chart and in the overhead bar. You may make alternative
selections by de-selecting previous parameters, and/or make additional selections by selecting
species names from the right-hand panel. To make multiple selections, click all desired species
names before clicking the green check mark to confirm your selection.
Additional Information
In addition to the full quick start guide EXIT. Qlik provides documentation for many of the
features included in Qlik Sense® in a searchable webpage format. EXIT
This document has been reviewed in accordance with U.S. Environmental Protection Agency policy and approved for publication.

-------