Distribution Formats with Custom Schemas

EarthSoft provides the option for clients to purchase an unlimited distribution EDP license. This allows the client to distribute and license their format to labs and data providers with Standalone EDP. Using this method, the agency or client can ensure data are being checked against a single set of reference values as well as different field and data constraints.

The client-specific format files are distributed for use in Standalone EDP; however, a data provider or lab might also want to store these data in their own database. If the format file contains mapping for a custom schema or EQuIS module, opening these format files in Professional EDP will result in an error if the data provider’s database does not also have these additional modules/schema changes.

Typically, when opening one of these format files with additional mapping, an error will occur with the following formatting:

Unable to read Format File: [Format File Location]

[DT_TABLE].[TABLE_FIELD] is referenced by the format and does not exist in the database.

If a data provider wishes to use an EDD format with their EQuIS database, additional information about the custom schemas and modules can be requested by contacting the EarthSoft Help Desk at support@earthsoft.com.

Current examples of formats supporting additional modules/schemas include but may not be limited to:

•EPAR4 format (Custom Schema)

•MTDEQ format (WQX)

•NYSDEC format (Vapor Intrusion Schema and several WQX Schema fields)

•SNWA (LakeWatch)

•SEDD

•TCEQ (Custom)

•WQX (WQX)

Office Hour Video

The Office Hour video WQX Schema can be viewed from the EarthSoft Office Hours Videos webpage or on Screencast.