Search Knowledgebase

Follow

Download XMLs From ICISDA Dataflow to Correct ICIS Data.

Retrieve ICIS data from the 45 ICISDA (ICIS Data Access) services at EPA's Exchange Network Services Center: https://enservices.epa.gov/login.aspx (or through your own node software, OpenNode2, etc.). You could then use the data for your agency's system (performing quality assurance, seeding Exchange Network plugins with data, populating your NPDES or CAA systems, deriving anticipated DMRs for eDMR systems) or resubmit XMLs back into ICIS using the EDT batch process (ICIS-NPDES dataflows) after performing find/replace and other edits on any incorrect data.  You could also save retrieved XMLs for testing / training purposes and submit them to the ICIS Test or Stage environments after a data refresh to restore your data (remember to replace the default Id tag with your ICIS user Id).

To download from the ICISDA dataflow, you will need to register for a CDX account, if you don't have one already, through the link on the above ENSC homepage or at https://enservices.epa.gov/Register.aspx and choose ICISDA for the question "What DataFlow will you primarily be submitting to?". 

You may also register for the Exchange Network Test site: https://enservicestest.epacdxnode.net, where the Test ICISDA services connect to the ICIS Stage database instead of ICISCOPY (ICISDA Production connects to ICISCOPY), which is refreshed with ICIS Production data nightly.  ICIS Stage on the other hand is usually refreshed with Production ICIS data about every quarter.  Test ICISDA can be used to retrieve test or training records that you want to save before a refresh to ICIS Stage, which can then be submitted to ICIS Stage using the ICIS-NPDES dataflow on NGNTest2.0 after the refresh. 

NOTE: ICIS Nightly Processing begins around 11PM EST when Prod ICIS data is replicated to ICISCOPY, among other processes.  Therefore, please do not query or schedule jobs from 11PM to 7AM EST, when the jobs are usually completed.

The Flow Configuration Document has technical details of the ICISDA dataflow.  This can be found at http://www.exchangenetwork.net/data-exchange/icis-data-access/ .

For more information about the ICIS-NPDES dataflows (EDT Batch), visit: https://icis.zendesk.com/hc/en-us/articles/207065186-Guide-to-submitting-dataflows-to-ICIS .

For guidelines on retrieving NetDMR training/test data from ICIS Stage (before a database refresh), visit: https://netdmr.zendesk.com/hc/en-us/articles/209616306-ICIS-Data-Access .

Here is the list of the 38 ICIS data families (XML results conform to the ICIS-NPDES XML Schema format) and 7 reference tables XMLs.  ICISDA will include ICIS-Air XMLs in the future.

38 ICIS-NPDES data families

7 ICIS reference tables

GetICISBasicPermitData
GetICISBiosolidPermitData
GetICISBiosolidProgramReportData
GetICISCAFOAnnualReportData
GetICISCAFOPermitData
GetICISComplianceMonitoringData
GetICISComplianceScheduleData
GetICISCSOEventReportData
GetICISCSOPermitData
GetICISDischargeMonitoringReportData
GetICISDMRViolationData
GetICISEnforcementActionMilestoneData
GetICISFederalComplianceMonitoringData
GetICISFormalEnforcementActionData
GetICISGeneralPermitData
GetICISInformalEnforcementActionData
GetICISLimitSetData
GetICISLocalLimitsReportData
GetICISMasterGeneralPermitData
GetICISNarrativeConditionScheduleData
GetICISParameterLimitsData
GetICISPermitTrackingEventData
GetICISPermittedFeatureData
GetICISPOTWPermitData
GetICISPretreatmentPerformanceSummaryData
GetICISPretreatmentPermitData
GetICISScheduleEventViolationData
GetICISSingleEventViolationData
GetICISSSOAnnualReportData
GetICISSSOEventReportData
GetICISSSOMonthlyEventReportData
GetICISStormWaterConstructionPermitData
GetICISStormWaterEventReportData
GetICISStormWaterIndustrialPermitData
GetICISStormWaterMS4LargePermitData
GetICISStormWaterProgramReportData
GetICISStormWaterMS4SmallPermitData
GetICISUnpermittedFacilityData

GetICISAffiliationModuleCrossReferences
GetICISParameters
GetICISPollutants
GetICISUnits 
GetICISUnitConversions
GetICISUnitGroups
GetICISUnitGroupCrossReferences

 

Attached below is a presentation from January 2016 with some instructions for sample service requests.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request