search

kcigeospatial / balt_co_ETL

This will provide a place to track internal issues around the Baltimore County NPDES NCT application ETL.
0 stars 0 forks source link

QuarterlyGradingPermitInfo - 8DGT Watershed Not Translating Properly #15

Closed JuanitaMiles closed 6 years ago

JuanitaMiles commented 6 years ago

Steps to Reproduce: Reporting Year = 2017 On Failure = Continue On Errors Current User = KCI\Juanita.Miles

Upon running the Export to MDE the QuarterlyGradingPermitInfo table results in an Append_Failure. I feel like this may be due to the 8-digit watershed (WATERSHED8DGT) values not translating correctly.

Source Data Watershed Values: image

MDE Export Watershed Values: image

All values appear to translate correctly with the exception of 02130904-Jones Falls. This value should appear as "Jones Falls" when exported. I've tried manually selecting the 02130904-Jones Falls value from the domain pick-list in the source data and running the export again, but the problem still occurs.

gerrykelly commented 6 years ago

This turned out to be a glitch in the code the processes the domains' values. I think it is fixed.

I had thought the problem was going to be with the values mapping county domain codes to MDE's. I think you will run into that case at some point (unless Lee gets some time to fix a couple things and I can followup). There is a simple table in the database -- domains_baltco_mde_equivalency -- that supports the domains' codes conversion. It should make sense when you look at it. If you see a problem in the ETL where it looks like valid county codes are not being converted to the MDE value please check this table to see if it looks like it should work (and if you see an error for a county and/or MDE domain code-value when checking, feel free to edit the table to fix it)