WQX User Call July 28, 2022

WQX User Call
July 28, 2022

There were approximately 28 participants on the call.

Agenda:

1. WQX Project Status Report (10 mins)

• WQX/WQXWeb performance/updates

• WQX Tip of the month - Attaching files.

• WQX questions/comments

2. WQP Status Report (10 mins)

• WQP General Status Report

• WQP download profiles status

• WQP questions/comments

3. Open Discussion

• Other topics/questions

From

Notes:

1. WQX Project Status Report (10 mins)

The Helpdesk support has been operating at normal status. Contact Us: weekday hours of 8am to
6pm EST. Email Cwax@epa.qov') Call 800-424-9067. Following an Operating System patch EPA's
www3 Archive web server continues to experiencing intermittent issue publishing files for public
access. The issue was identified as intermittent and resolved. Users may be impacted by a
delayed Portal refresh event (https://www.waterqualitydata.us/data/lastETL). Note - The WQP
Refresh status is located at the bottom of Water Quality Portal homepage's footer section.

WQX successfully completed a WQX Web Azure Cloud migration event on June 30, 2022. During
this event, the WQX Web application was deployed to a New cloud application server. SOME
user impact expected: Users may experience some impact as a reduction in processing
performance compared to the current "on-premise" server environment. Application will inherit
new network latency transferring data from Cloud application server to the database server
(separate location).

Note - WQX Web supports a new dataset import limit of less than 30,000 records (25k
recommended). XML uncompressed file sizes are limited to 350 MB. One-to-many records and
attached binary objects will contribute to the overall file size limit.

Upcoming event - On August 1, 2022, WQX will deploy a critical patch to the PRODUCTION
node's XML parse and load software to improve database session management. There are two
WQX Web Performance Tuning Issues: Fix bug with WQX Web export xml - very slow; Fix bug

WQX User Call Notes - July 28, 2022

-------
with WQX Web re-validate button (slow) - domain values are resolved online without re-
importing.

There are two planned maintenance events: The WQX Staging environment will perform a
database upgraded on Friday August 26th at 6 PM EST. This will require at least 3 hours
downtime for the applications. Once the upgrade is available in Staging, a period of testing the
system between August 29th and September 7th has been planned before updating WQX
Production. WQX Production environment will be upgraded on September 9th

2. WQX Tip of the month - Attaching files.

1) WQX supports the attachment of multiple files, pictures, or other attachments (objects) at all
levels of the WQX data structure, including Projects, Monitoring Locations, Activities, and
Results.

Files may include: QAPPs, documents, photos, images, geospatial coverages, sound files, etc.

More and more of these types of ancillary data are starting to show up in services such as How's
My Waterway. Soon individual station pages will be added where site photos uploaded to WQX
would be visible and available in the application.

PROJ Binary Object

02.01.00 Header

ProjectAttachedBinaryObject

Header;

This section allows for the
association of References and
electronic attachments to the
project, including formal
Project Plan and any other
documents, images, maps,
photos, laboratory materials,
geospatial coverages, and
other objects associated with
the Project..

PROJ Binary
Object

02.01.00
Header

PROJ Binary Object

02.01.01

BinaryObjectFileName

The text describing the
descriptive name used to
represent the file, including
file extension.

PROJ Binary
Object

02.01.01

PROJ Binary Object

02.01.02

BinaryObjectFileTypeCode

The text or acronym
describing the binary content
type of a file.

PROJ Binary
Object

02.01.02

Monitoring Location
Binary Object

03.03.00 Header

Attached BinaryObject

Header;

This section allows for the
association of References and
electronic attachments to the
Monitoring Location
description including any
other documents, images,
maps, photos, laboratory
materials, geospatial
coverages, and other objects
associated with the Project.

Optional;
may have 0
to many for
each

instance of
Monitoring
Location

WQX User Call Notes - July 28, 2022

-------
Monitoring Location
Binary Object

03.03.01

BinaryObjectFileName



The text describing the
descriptive name used to
represent the file, including
file extension.

Conditional
(see

business
rule)

string
min 1
string
max 255

Monitoring Location
Binary Object

03.03.02

BinaryObjectFileTypeCode



The text or acronym
describing the binary content
type of a file.

Conditional
(see

business
rule)

string
min 1
string
max 6

Activity Binary Object

05.05.00 Header

Activity Attached BinaryObject



Header;

This section allows for the
association of References and
electronic attachments to the
Activity description including
any other documents, images,
maps, photos, laboratory
materials, geospatial
coverages, and other objects
associated with the Project..

Optional;
may have 0
can have
many per
instance of
Activity.



Activity Binary Object

05.05.01

BinaryObjectFileName



The text describing the
descriptive name used to
represent the file, including
file extension.

Conditional
(see

business
rule)

string
min 1
string
max 255

Activity Binary Object

05.05.02

BinaryObjectFileTypeCode



The text or acronym
describing the binary content
type of a file.

Conditional
(see

business
rule)

string
min 1
string
max 6

Result Binary Object

06.02.00 Header

Attached BinaryObject



Header;

This section allows for the
association of References and
electronic attachments to a
Result description including
any other documents, images,
maps, photos, laboratory
materials, geospatial
coverages, and other objects
associated with the Project..

Optional;
may have 0
can have
many per
instance of
Result



Result Binary Object

06.02.01

BinaryObjectFileName



The text describing the
descriptive name used to
represent the file, including
file extension.

Conditional
(see

business
rule)

string
min 1
string
max 255

Result Binary Object

06.02.02

BinaryObjectFileTypeCode



The text or acronym
describing the binary content
type of a file.

Conditional
(see

business
rule)

string
min 1
string
max 6

2. Files should be described by providing the file name of the appropriate object for that record and a
short text description or abbreviation of the file.

Monitoring
Location
Attachment File
Name

Monitoring
Location
Attachment Type

Monitoring
Location
Attachment File
Name

Monitoring
Location
Attachment Type

SitelPhotol.jpg

Photo

SitelPhoto2.jpg

Photo

3

WQX User Call Notes - July 28, 2022

-------
Site2Photol.jpg

Photo

Site2Map.jpg

Drawing

3. Fiies are uploaded with each respective import configuration and dataset and should be combined
into a single zipped folder, "files.zip"

Import an Excel Spreadsheet or Text File into WQX Web

Import Data

Import Configuration and Type of File
Type of Data:	Projects

Import Configuration:	| Adam Griggs - Test-Template Project - 8027

Type of Frle.	| Microsoft Excel (xfex)

Worksheets) to Import | 3rd	y | (note: the "1st" worksheet 
-------