Stormwater - BMPPOI - Update source of target.BMPPOI.BMPPOI_ID to apply "POI"

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

Stormwater - BMPPOI - Update source of target.BMPPOI.BMPPOI_ID to apply "POI" #52

Closed leeensminger closed 6 years ago

leeensminger commented 6 years ago

When a source BMPS feature is related to a source BMP_POIS, the system should populate target.BMPPOI.BMPPOI_ID with the source.SW_TRACKING.SW_TRACKING_NUM.

During this process, the following translation has to be made: Strip the "BMP" prefix Apply the "POI" prefix

This will work because the number trigger Ehsan setup ensures unique 6-digit characters for both the BMP_POIS.BMP_POI_NUM and SW_TRACKING_NUM. See #27

leeensminger commented 6 years ago

self assigning until BMPPOIs can get populated to the target table successfully via ETL

gerrykelly commented 6 years ago

@leeensminger This should be resolved with fixing #66

leeensminger commented 6 years ago

Resolved