We would like to use midblock_id column name instead of centreline_id for the centreline2_midblocks table which is being replicated from MOVE.

• we could consider renaming other traffic schema columns such as centreline_id (which is actually intersection_id in some cases)

Options:

1. Use simple views for inserting

• insert into a view first, then use trigger to insert into table. Would allow changing column names.
• truncate would not work, but delete from would be an easy fix
• comment on table would not work... could add a separate option for commenting on a second table.

2. Revoke select on tables and rename columns using new views

• could be confusing since views are not the first place people would look
• comment on table would mean comments on views would not be up to date... could add a separate option for commenting on a second table.