Bikes in Crosswalks are being added to the TMC data

[radumas]

MOVE are adding bikes in crosswalks to the TMC data, but in an opaque way.

• back up traffic.tmc_study_legacy to something like traffic.tmc_study_legacy_no_xwalk_bikes with a comment on the range of data for which it applies
• update the documentation on TMCs to include the diagram explaining how the crosswalk bikes are being included
• anything else?

[gabrielwol]

CREATE TABLE traffic.tmc_study_legacy_no_xwalk_bikes AS
SELECT * FROM traffic.tmc_study_legacy;

COMMENT ON TABLE traffic.tmc_study_legacy_no_xwalk_bikes IS
'A backup of `traffic.tmc_study_legacy` created on 2024-11-06 before bikes in x-walk were added to bicycle volumes.';

ALTER TABLE traffic.tmc_study_legacy_no_xwalk_bikes OWNER TO traffic_admins;
GRANT SELECT ON TABLE traffic.tmc_study_legacy_no_xwalk_bikes TO bdit_humans;

[radumas]

For Turning Movement Counts conducted September 2023 and on, we are updating bicycle counts to include bicycles on road, plus cyclists riding in the crosswalk.

Note: These cyclists are riding their bikes in the crosswalk area, usually before or after riding on the sidewalk. People walking their bikes are counted as pedestrians.

Here’s an example of how that will work for northbound traffic, or the South Approach of an intersection.

What will be updated?
Only Turning Movement Counts conducted September 2023 and on will be updated. Only the bicycle counts will change.

[gabrielwol]

Related to #1068.

[radumas]

I guess these are one of the things we probably don't want to purge, just in case...