         transamAs.purchased_new AS 'transam_asset_purchased_new',
         transamAs.quantity AS 'transam_asset_quantity',
         transamAs.quantity_unit AS 'transam_asset_quantity_unit',
+
         transamAs.salvage_value AS 'transam_asset_salvage_value',
         transamAs.scheduled_disposition_year AS 'transam_asset_scheduled_disposition_year',
         transamAs.scheduled_rehabilitation_year AS 'transam_asset_scheduled_rehabilitation_year',

        i.from_segment AS 'infrastructure_from_segment',
        i.gauge AS 'infrastructure_gauge',
        i.gauge_unit AS 'infrastructure_gauge_unit',
        i.horizontal_alignment AS 'infrastructure_horizontal_alignment',
        i.horizontal_alignment_unit AS 'infrastructure_horizontal_alignment_unit',
        i.infrastructure_chain_type_id AS 'infrastructure_infrastructure_chain_type_id',
        i.infrastructure_division_id AS 'infrastructure_infrastructure_division_id',
        i.infrastructure_gauge_type_id AS 'infrastructure_infrastructure_gauge_type_id',
        i.infrastructure_reference_rail_id AS 'infrastructure_infrastructure_reference_rail_id',
        i.infrastructure_segment_type_id AS 'infrastructure_infrastructure_segment_type_id',
        i.infrastructure_subdivision_id AS 'infrastructure_infrastructure_subdivision_id',
        i.infrastructure_track_id AS 'infrastructure_infrastructure_track_id',
        i.land_ownership_organization_id AS 'infrastructure_land_ownership_organization_id',
        i.other_land_ownership_organization AS 'infrastructure_other_land_ownership_organization',
        i.relative_location AS 'infrastructure_relative_location',
        i.relative_location_direction AS 'infrastructure_relative_location_direction',

          transamAs.purchased_new AS 'transam_asset_purchased_new',
          transamAs.quantity AS 'transam_asset_quantity',
          transamAs.quantity_unit AS 'transam_asset_quantity_unit',

          transamAs.salvage_value AS 'transam_asset_salvage_value',
          transamAs.scheduled_disposition_year AS 'transam_asset_scheduled_disposition_year',
          transamAs.scheduled_rehabilitation_year AS 'transam_asset_scheduled_rehabilitation_year',
