Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

LCFS - Add missing fuel code fields #1602

Closed
4 tasks
airinggov opened this issue Jan 3, 2025 · 0 comments · Fixed by #1713
Closed
4 tasks

LCFS - Add missing fuel code fields #1602

airinggov opened this issue Jan 3, 2025 · 0 comments · Fixed by #1713
Assignees
Labels
Fuel Codes High High priority ticket but not critical at this time Task Work that does not directly impact the user Tested :) Testing passed

Comments

@airinggov
Copy link
Collaborator

airinggov commented Jan 3, 2025

Describe the task
Add missing fields to the fuel code ETL script.

Purpose
Ensure the ETL process contains all necessary fields to correctly and comprehensively process fuel code data. This enhances data accuracy and integrity in the system.

Acceptance Criteria

  • Add TFRS "Fuel Production Facility Location" (comma-delimited text) field, split into:
    • LCFS "Fuel production facility city"
    • LCFS "Fuel production facility province/state"
    • LCFS "Fuel production facility country"
  • Add 2 pills labeled "Truck" and "Marine" to the LCFS fields: "Feedstock transport mode", "Finished fuel transport mode"
  • Add TFRS "Feedstock Transport Mode" (comma-delimited) field to LCFS "Feedstock transport mode" (pill format)
  • Add TFRS "Finished Fuel Transport Mode" (comma-delimited) field to LCFS "Finished fuel transport mode" (pill format)

Additional context

  • Verify that all fields are correctly mapped in the ETL pipeline.
  • Ensure that the data types and formats (e.g., text, pills, comma-delimited) align with the requirements.
  • Test the updated ETL process with sample data to confirm the successful inclusion and processing of these fields.

Note

  • Fuel Production Facility Location will not split into the 3 new fields consistently. Most TFRS data is (city, province) so use that as default, (city, province, country) will map properly, anything (city, country) can be corrected by data fix later.
@airinggov airinggov added Fuel Codes High High priority ticket but not critical at this time Task Work that does not directly impact the user labels Jan 3, 2025
@prv-proton prv-proton assigned prv-proton and unassigned prv-proton Jan 9, 2025
@kevin-hashimoto kevin-hashimoto self-assigned this Jan 13, 2025
@airinggov airinggov added the Tested :) Testing passed label Jan 21, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Fuel Codes High High priority ticket but not critical at this time Task Work that does not directly impact the user Tested :) Testing passed
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants