Accomplishments - Completed

• Continuing coordination with the SDC team to perform transition from the legacy CVPEP environment to the SDC environment
  • Setting up access credentials
  • Setting up development and test environment

In the legacy CVPEP environment:

• Supported WYDOT:
  • Loaded controllers.csv data into the Data Warehouse
    • Table: wydot_speed_controllers
    • For location correlation with speed data
  • Updated speed data tables to include “meaningful” data types
    • “int” and “float” data types to replace “string”
    • TIMESTAMP data type for the date and time fields to replace “string”
  • Helped with the cleanup of VSL data
    
    
• Supported Volpe WYDOT
  • Created “flat” tables to store BSM and TIM data for ease of querying
    • List of tables for BSM:
      • wydot_bsm_core
      • wydot_bsm_partii
      • wydot_bsm_partii-crumbdata
    • List of tables for TIM:
      • wydot_tim_core
      • wydot_tim_advisory (empty)
      • wydot_tim_path_offset_ll (empty)
      • wydot_tim_path_offset_xy (empty)

Items to Complete before the Sprint End

• Loading of all legacy CVPEP Data Warehouse tables into the SDC Data Warehouse
• Testing of data ingest
  • Through the Kinesis Firehose
  • Through the S3 ingest buckets

Items to Demonstrate

• “Relational” tables (WYDOT BSM and TIM)

Sprint Work-Items:

Demo Overview:

• Defects: 
  • (1) TIMs with ITIS custom text not supported  (In QA)
  • (2) Trailer Mass is calculated incorrectly 
    
    
• Green Hills:   ODE Security Service using Green Hills for Production Environment   (In QA)
  
  
• Security Module work (quick recap on previous work)
  
  
• Documentation:   Update ODE documentation to reflect actual implementation of the ODE output interface schema

In-Progress work-items: