Open OpenOilUG opened 2 years ago
project_bc_210929.csv production_ca-bc-DBeaver_210929.csv As I understand new structure, adding new fields requires updating both project table and project_data. so i first added all project identifiers in project table - assigning them project IDs ascending up from 2811 which was highest project_id number i found in current table. i then matched these project_id values against the original project identifiers to create the update for BC project production - PLEASE NOTE if different project_ids are assigned, then project data would also need to be matched against those.
Australian oil and gas fields formatted here. Assumes BC data above has been processed so starts id series at 5356. PLEASE NOTE we need to rematch project_id to production data if the sequence does not start at 5356. project_au_oilgas.csv project_data_au_oilgas.csv
project_gom_210930.csv project_data_gom_210930.csv US Gulf of Mexico oil and gas fields formatted here. Assumes BC and Australia data above has been processed so starts id series at 5727. PLEASE NOTE we need to rematch project_id to production data if the sequence does not start at 5727.