Minneapolis has made it easier to get the violation's data now

[Account Closed]

Minneapolis came up with a pretty cool Tableau dashboard back in September of last year. https://tableau.minneapolismn.... . It's a little slow loading, but it will load.

It lets you 'dial' in all of the violations, in really granular detail per property. Easy peasy to dial in things, and the download gives you a clean address list to import into your own Tableau install, and just 'list stack' against any other list(s) you might be collecting that has 'at least' an address. Video 10. Data Preparation – Joins and Unions https://public.tableau.com/en-... , makes this stupid simple. Hence, you can use the drop-down for rental license 'tiers' from the city Tableau dashboard, dial in the pain, and just load one of the sheets I posted a few days ago to match everything up against. It really is 'click the address column in the violations sheet, and click the column with the address in the landlord file' aaaand ♪presto♪: matched.

I dunno, I still think this is easier with PostgreSQL. Just load the list that you downloaded as a table into PostgreSQL, and just run a 'join' against the Assessor or landlord table that you would want to load in as well. Tableau is a bit of a resource hog on the CPU/RAM running joins... but it does make it just 'click-click=done' for stacking basically any list(s).

[Kim Feldkamp]

@Account Closed  This is great stuff - I was still geeking out over your last post.  Thanks for sharing.