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

Stormwater - Redevelopment/Restoration - Update selection set to include Revitalization #53

Closed leeensminger closed 6 years ago

leeensminger commented 6 years ago

Per Rob Hirsch 20171212:

Stormwater features with a ConPurpose = Revitalization should be outputted to RestBMP, with a target Con Purpose = New Development ("NEWD").

The existing selection set for the target RestBMP feature class is:

Find where: -SW_TRACKING.REPORTING_YEAR <= user selected reporting year, and -SW_TRACKING.TRACKING_STATUS = Current, and -SW_TRACKING.CON_PURPOSE = Restoration OR Redevelopment

So the updated selection set for the target RestBMP feature class is:

Find where: -SW_TRACKING.REPORTING_YEAR <= user selected reporting year, and -SW_TRACKING.TRACKING_STATUS = Current, and -SW_TRACKING.CON_PURPOSE = Restoration OR Redevelopment OR Revitalization

Translate source.CON_PURPOSE of "Revitalization" ==> target.CON_PURPOSE = "NEWD" [New Development]

leeensminger commented 6 years ago

This is a duplicate issue, see #5