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

AltBMPPoly (Impervious Removal) - Verify Translation of PROJECT_NAME is Acceptable #16

Closed JuanitaMiles closed 6 years ago

JuanitaMiles commented 6 years ago

For Impervious Removal the AltBMPPoly.PROJECT_NAME field is sourced from IMPERVIOUS_REM.STRU_NO_EPS.

IMPERVIOUS_REM.STRU_NO_EPS has a Double data type that is translated into a String field. Therefore, the Project Name is given a ".0" at the end. Example below:

Source Data (IMPERVIOUS_REM.STRU_NO_EPS): image

MDE Export (AltBMPPoly.PROJECT_NAME): image

Please confirm if this translation is okay. Or if it should export without the ".0" appended to the end.

leeensminger commented 6 years ago

@JuanitaMiles the ".0" suffix should be not be present. @gerrykelly should strip the ".0" before inserting the string into the target field.

Just to expand - there are some STRU_NO_EPS values that include a decimal value - so it's important we strip this so we are consistent and accurate.

gerrykelly commented 6 years ago

Should be fixed (and I made one of the values 10.1 to make sure we do get decimal numbers when valid)