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

ETL - MDE 'BUILT_DATE' should map from NCT 'ASB_DATE' not NCT 'INSTALL_DATE #79

Open dhenry-KCI opened 6 years ago

dhenry-KCI commented 6 years ago

MDE's description of the BMP.BUILT_DATE field is 'As-built completion date'. The NCT table NPDES.SW_TRACKING has fields INSTALL_DATE and ASB_DATE. ASB_DATE is as-built completion date. The Export to MDE tool is populating MDE.BMP.BUILT_DATE field from NPDES.SW_TRACKING.INSTALL_DATE, but should instead use NPDES.SW_TRACKING.ASB_DATE.

This same correction should be made for MDE's RestBMP.BUILT_DATE field, it should be populated from NPDES.SW_TRACKING.ASB_DATE

gerrykelly commented 6 years ago

@dhenry-KCI I made this change for all 4 of the selection sets that populate BMP/RestBMP. (Now the results all have append failures of course because so many ASB_DATEs are null at KCI ... so that's a data issue for the county now)

dhenry-KCI commented 6 years ago

Confirmed fixed in KCI Dev. Ready for County testing.