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

D_Con_Purpose > dConPurpose ... no match for Revitalization #5

Closed gerrykelly closed 6 years ago

gerrykelly commented 7 years ago

For now I'll use REST

leeensminger commented 6 years ago

This sounds reasonable, but I don't know the answer for sure. I need to confirm with the County.

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").

This pertains to selection set 1B (Restoration/Redevelopment) if you're following along in the original spreadsheet.

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]

gerrykelly commented 6 years ago

@leeensminger I made these changes. Probably not worth testing until I've done more on SW

leeensminger commented 6 years ago

Resolved