Home : NetDMR-EZ
Q14599 - INFO: NetDMR-EZ

Used to design the electronic report for submission (upload) to National NetDMR.

The NetDMR-EZ method allows you to download a Copy of Record (COR) from the NetDMR site and uses the that file (XML) as a specification/template for the report. 

The locate tool is used to design a spread report that will produce a CSV file that meets the NetDMR Import File Specifications. Users will then be able to login to a NetDMR system and use the NetDMR's Import DMRs function to submit the data.   

 Note: This is an alternative (typically easier) method to building the NetDMR to the Locate>National NetDMR method.

Steps to build the report.

1. Download a Copy of Record (COR) by viewing a recently submitted DMR from your NetDMR site.  See  Downloading NetDMR COR.

2. Open Spread Design and go to Locate>eDMR/Electronic Report Link>NetDMR-EZ

3. Click the Load... button and browse to the file XML file downloaded in step 1.  The XML file will be displayed.  You will be prompted to identify the WIMS locations for each unique monitoring site in the XML file.  Providing the locations allows WIMS to guess the variable for each Parameter and statistic by searching the locations specified and the variable's StoretCode/Units.  Example, parameter 1 specifies StoretCode (ParameterCode) 00610 for 1-Effluent Gross in lb/d and mg/L.  WIMS searches the Effluent location for StoretCode 00610 with units of Lbs, Lbs/day, or lb/d.  It then searches for 00610 with units of mg/L or ppm.  In this manner WIMS is able to automatically build a majority of the report. 

4. Click Build Template and report will be built.

5. Review all yellow cells (yellow means WIMS auto built the formula) and orange cells (orange means WIMS found no variable).  Use Locate>Group Summary and Locate>Number of Violations to finish out the report.

6. Save the report.  You can create the NetDMR CSV using Report Pac>Spread Reports and output as an eReport or in Design use File>Export>eReport.

FIELDS:

Field NetDMR Field Column Excel Column Notes
Permit Number permit_id 1 A Permit Number in all upper case, NM0057493. 
Permitted Feature ID permitted_feature_id 2 B 001
Limit Set limit_set_txt 3 C A
Monitoring period end date mped_txt 4 D End date of the report in yyyy-mm-dd
Form NODI Code form_nodi_cd 5 E NODI code for entire DMR form.  Typically blank.
Parameter Code parameter_cd 6 F Storet Code for the parameter, 00400
Monitoring Location Code monitoring_location_cd 7 G

1 digit for the location, if the cell contains a dash the value to the left of the dash is reported.  Examples:

1-Effluent (Reported as a 1 in the CSV)
G-Raw Sewage (Reported as G)
K-Percent Removal (Reported as K) 

Season season_num 8 H Identifies the limits to use with seasonal limits (number 0-12).  Typically, is a value of 0 (zero) if the limit does not change (i.e. you do not have seasonal limits).  If you have seasonal limits, this number will need to change depending on the month you are reporting.  You may want to request a Limit Summary report from the state (or regulatory agency) in order to see your limits and associated season.
Quantity 1 NODI Code quant_1_nodi_cd 9 I A NODI code to indicate that there is no data for the reporting period.  Typically blank.
Quantity 1 Qualifer

quant_1_qualifier_txt

10 J The qualifier of the result.  WIMS will report the symbol of the value displayed (ie if <2 is displayed in the cell, this field will be reported in the CSV as <) It specifies whether the condition is greater than, less than, and/or equal to the NumericConditionValue. This field may also indicate if the value is estimated (E) or too numerous to count (T) when applicable.  If no qualifer exists, should be set to "=".  Valid values =,>=,=>,<,>,T,E.  Note, if qualifer = T the value must be populated.
Quantity 1 Sample value quant_1_sample_num 11 K The numeric result with no commas.  Example, the average flow is 3.75.
Quantity 1 Effluent value quant_1_effluent_num 12 L Typically left blank.  This field may be used to specify the limit value in the future (not verified).
Quantity 2 NODI Code quant_2_nodi_cd 13 M
Quantity 2 Qualifer quant_2_qualifier_txt 14 N
Quantity 2 Sample value               quant_2_sample_num 15 O
Quantity 2 Effluent value quant_2_effluent_num 16 P
Quantity units of measure quant_uom_cd 17 Q Unit of measure code.  The value to the left of the dash is reported in the CSV. (19 for mg/L, 26 for lb/d etc...). 
Concentration 1 NODI code conc_1_nodi_cd 18 R
Concentration 1 Qualifier conc_1_qualifier_txt 19 S
Concentration 1 Sample value conc_1_sample_num 20 T
Concentration 1 Effluent value conc_1_effluent_num 21 U
Concentration 2 NODI code conc_2_nodi_cd 22 V
Concentration 2 Qualifer conc_2_qualifier_txt 23 W
Concentration 2 Sample Value conc_2_sample_num 24 X
Concentration 2 Effluent Value conc_2_effluent_num 25 Y
Concentration 3 NODI code conc_3_nodi_cd 26 Z
Concentration 3 Qualifer conc_3_qualifier_txt 27 AA
Concentration 3 Sample Value conc_3_sample_num 28 AB
Concentration 3 Effluent Value conc_3_effluent_num 29 AC
Concentration units of measure conc_uom_cd 30 AD Unit of measure code.  The value to the left of the dash is reported in the CSV. (19 for mg/L, 26 for lb/d etc...). 
Number of Excursions excursions_num 31 AE Count of number of violations (exceedances) for the parameter.  See VIOL for counting the number of exceedances. 
Frequency of Analysis freq_analysis_cd 32 AF The code that indicates the frequency with which the permittee must analyze the sampled data. The general format is XX/YY where XX= number of times sampled and YY = period of time sampled.  The value to the left of the dash is reported in the CSV.  See GFOA for reporting of the Frequency of Analysis.  Note:  typically this field can be hard coded.
Sample Type sample_type_cd 33 AG The code that is the sampling method required by the permit to be used to provide measurement values on the DMR. The value to the left of the dash is reported in the CSV
Parameter NODI Code param_nodi_cd 34 AH The NODI code for this particular parameter. 
Comment Text comment_txt 35 AI

This is for any comments that need to be added to the DMR, enter comment on the first line of the DMR only.

 

 

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 9/23/2020 10:16 AM.
Last Modified on 10/6/2020 12:11 PM.
Last Modified by Scott Dorner.
Article has been viewed 454 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article