Challenge #152: Finding Vehicle Counts

[DataG8]

The hint made it too easy.

Spoiler

[viveknshah]

Spoiler

For A Summarise addict, this was a good exercise to pause and think 

[LordNeilLord]

19

Spoiler

[TonyA]

Here's my solution.

Spoiler

I used a crosstab tool to aggregate. I cheated a bit by taking advantage of the fact that the AW100 field was always 1. If it wasn't I would have added a field that was all 1's.

[Tom_Pilgrem]

Interesting challenge - first time using a Calgary DB

Spoiler

[cmadumer]

Spoiler

[shnbrb]

My solution is attached

Spoiler

Calgary Cross Count to Count and Filter for Blue Chevy
Calgary Input to bring in region code to name mapping
Use join as filter for desired dataset.

Probably could have all been done in the Calgary Cross Count Append tool if the db were indexed.