issues
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
issues
Newest
Newest
Most commented
Recently updated
Oldest
Least commented
Least recently updated
Selection set 1C - address information is not being populated to RestBMP output
#94
leeensminger
opened
6 years ago
1
Stormwater selection set 1D - MDE.BMP.BMP_DRAIN_ID is orphan, but should be valid MDE DA ID
#93
leeensminger
opened
6 years ago
1
Update translation for 8 digit watershed values
#92
leeensminger
closed
6 years ago
1
ETL - Update ETL Translation - NPDES.IMPERVIOUS_REM.STRU_NO_EPS often has nulls but is source for non-nullable MDE.AltBMPPoly.PROJECT_NAME
#91
dhenry-KCI
opened
6 years ago
3
ETL - IDDE.CB_SEG_SHED is not populated
#90
dhenry-KCI
opened
6 years ago
7
ETL - Update ETL Translation - MDE.Outfall.OUT_YEAR should not be populated by OUTFALLS.REPORTING_YEAR
#89
dhenry-KCI
opened
6 years ago
3
ETL - Update ETL Translation - ETL does not report PID points or IDDE Inspections that occurred at PID Points
#88
dhenry-KCI
opened
6 years ago
2
ETL - Output does not contain table IDDE
#87
dhenry-KCI
opened
6 years ago
10
Selection Set 1C - add BMPPOI to existing selection set
#86
leeensminger
closed
6 years ago
3
ETL - Update ETL Translation - ETL does not report PID points or IDDE Inspections that occurred at PID Points
#85
dhenry-KCI
opened
6 years ago
0
ETL - NPDES.SW_INSP_REPORT contains valid data from DEPS Master where INSP_STATUS is null, but ETL tries to write null to non-nullable field with domain dPassFail
#84
dhenry-KCI
opened
6 years ago
4
ETL - value(s?) in D_Watershed8dgt in NPDES sde instance has(have?) no translation in ETL
#83
dhenry-KCI
opened
6 years ago
5
ETL - MDE.AltBMPLine.BMP_DRAIN_AREA is non-nullable but should be nullable, and the ETL has no source assigned so successful append is impossible
#82
dhenry-KCI
opened
6 years ago
6
ETL - AltBMPPoly.PROJECTED_IMPL_YEAR populated by TREE_INFO.IMPL_YEAR
#81
dhenry-KCI
opened
6 years ago
2
ETL - Update ETL translation - BMP.BMP_NAME and BMP.LOCAL_BMP_ID should use STRU_NO not STRU_NO_EPS
#80
dhenry-KCI
opened
6 years ago
2
ETL - MDE 'BUILT_DATE' should map from NCT 'ASB_DATE' not NCT 'INSTALL_DATE
#79
dhenry-KCI
opened
6 years ago
2
Selection Set 1B - add BMPPOI to existing selection set
#78
leeensminger
closed
6 years ago
7
Inspections for RestBMPs are not outputted to target gdb
#77
leeensminger
closed
6 years ago
4
Remove special insert of source text for BMPDrainageAreas
#76
leeensminger
closed
6 years ago
1
Assign D_State_All to STATE in TREE_INFO
#75
gerrykelly
opened
6 years ago
1
AltBMPPoly - Reforestation - Planting Type domain translations are not correct
#74
leeensminger
closed
6 years ago
2
AltBMPPoly - Reforestation - Update selection set for Implementation Status
#73
leeensminger
closed
6 years ago
2
AltBMPPoly - Annual Practice Areas - no output to target?
#72
leeensminger
closed
6 years ago
2
Selection set 1C - some records have "orphan" output BMP.BMPPOI values
#71
leeensminger
closed
6 years ago
2
Selection Set 1C - target BMP.BMPPOI values do not include "POI" value
#70
leeensminger
closed
6 years ago
2
Stormwater - BMP DA - Selection Set 1C ghosted BMP DAs are being migrated
#69
leeensminger
closed
6 years ago
3
Stormwater - BMP Inspections - Selection Set 1C ghosted BMP inspections are being migrated
#68
leeensminger
closed
6 years ago
4
Selection Set 1A - TRACKING_STATUS filter is not correct
#67
leeensminger
closed
6 years ago
4
Selection Set C - Parts 1 and 2 - BMPPOI.BMPPOI_ID values are not replaced with "POI"
#66
leeensminger
closed
6 years ago
4
Selection Set 1A - target BMP.BMPPOI_ID does not include county code + yr
#65
leeensminger
closed
6 years ago
2
Selection set 1D - POIS - Selection set should not include Redevelopment Projects
#64
leeensminger
closed
6 years ago
1
Selection set 1D - POIS - target.BMPPOI.IMP_ACRES is not populating correctly
#63
leeensminger
closed
6 years ago
2
Selection set 1c - Conversions - new development and restoration features are not loaded to the proper target table
#62
leeensminger
closed
6 years ago
8
Stormwater - Selection Set 1B - source.BMP_POIS are not excluded from selection set
#61
leeensminger
closed
6 years ago
1
Stormwater - Selection Set 1A - migrated records also show up in append_failure
#60
leeensminger
closed
6 years ago
3
Stormwater - Selection Set 1A - selection set is incorrect
#59
leeensminger
closed
6 years ago
9
Updating BMPPOI causes ETL to fail
#58
gerrykelly
closed
6 years ago
1
Removed land_use subtype from BMPPOI Template FGDBs > needs update at county
#57
gerrykelly
closed
6 years ago
1
Need insert trigger for tree_info
#56
gerrykelly
closed
6 years ago
0
new view ETL_BMP_LAND_USE_SPATIAL_VW
#55
gerrykelly
closed
6 years ago
0
ETL_BMP_DAS_ID_AND_ACRES_VW update at County
#54
gerrykelly
closed
6 years ago
0
Stormwater - Redevelopment/Restoration - Update selection set to include Revitalization
#53
leeensminger
closed
6 years ago
1
Stormwater - BMPPOI - Update source of target.BMPPOI.BMPPOI_ID to apply "POI"
#52
leeensminger
closed
6 years ago
3
Stormwater - BMPPOI - Update source of asttributes when the feature is a POI
#51
leeensminger
closed
6 years ago
3
Stormwater - BMPPOI - Update source of geometry when the feature is a POI
#50
leeensminger
closed
6 years ago
2
Stormwater - BMPPOI - LAST_CHANGE is not calculated for target database
#49
leeensminger
closed
6 years ago
2
Stormwater - RestBMP - RESTBMP_DRAIN_AREA does not calculate
#48
leeensminger
closed
6 years ago
2
Stormwater - RestBMP - LAST_CHANGE is not calculated for target database
#47
leeensminger
closed
6 years ago
2
Stormwater - RestBMP - target RestBMP.BMP_DRAIN_ID does not populate
#46
leeensminger
closed
6 years ago
2
Stormwater - Drainage Areas - ETL returns more records than expected
#45
leeensminger
closed
6 years ago
2
Next