Skip to content
Minneapolis Real Estate Forum
Account Closed
33
Votes |
42
Posts

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

Account Closed
Posted Jan 29 2020, 14:01

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).

Loading replies...