61°F

Aaron Parecki

  • Articles
  • Notes
  • Photos
  • See all your Simple bank transactions on a map

    March 10, 2013

    Have you ever wondered where in your city you spend the most money? This post will show you how to plot all your Simple transactions on a map! No code required!

    Simple Transaction History

    Export your data as a CSV file

    Log in to your Simple account and go to your dashboard. In the right hand column, change the view to "All Time".

    Export All Time

    The view will update to show all your transactions. Then, click the "Export" button and choose "CSV".

    Export Simple Transaction History

    Save that file to your computer somewhere.

    Creating a map

    For this part, you'll need an ArcGIS Online account. You can get a 30-day free trial to try this out quickly.

    Once you log in, click the "Map" button at the top and you'll create a new blank map. You can choose one of the basemaps if you don't like the way the default one looks. In this example I chose the "Light Gray Canvas" map.

    Choose a basemap

    Now for the magic part. Find your CSV file, and drag it on to the map. Yes, really. ArcGIS will automatically figure out where the latitude/longitude columns are in the file!

    Drag CSV file to the map

    Now you'll see all your transactions on the map!

    Imported Transactions

    Customizing the Display

    You'll notice that every transaction is using the default round orange marker. That's not terribly interesting. One of the really cool things we can do is change the markers depending on some variables in the dataset.

    Using the "Change Symbols" option, you can select a column to use as the variable. In this case I chose "Amount". If you then choose "Natural Breaks", it will find five ranges based on your data and assign different colors to each.

    Change map symbols

    Now. when you look at the map, your transactions will be colored darker for larger transactions!

    Simple Transaction History

    Feel free to try this on your own, or if you're interested, send me your CSV file (remove everything except the lat/lng and amount if you want to anonymize it a bit) and I can generate some images for you!

    Austin, TX
    Sun, Mar 10, 2013 1:10pm -05:00 #sxsw #sxsw2013 #esri #arcgis #simple #banksimple #maps
Posted in /articles

Hi, I'm Aaron Parecki, Director of Identity Standards at Okta, and co-founder of IndieWebCamp. I maintain oauth.net, write and consult about OAuth, and participate in the OAuth Working Group at the IETF. I also help people learn about video production and livestreaming. (detailed bio)

I've been tracking my location since 2008 and I wrote 100 songs in 100 days. I've spoken at conferences around the world about owning your data, OAuth, quantified self, and explained why R is a vowel. Read more.

  • Director of Identity Standards at Okta
  • IndieWebCamp Founder
  • OAuth WG Editor
  • OpenID Board Member

  • 🎥 YouTube Tutorials and Reviews
  • 🏠 We're building a triplex!
  • ⭐️ Life Stack
  • ⚙️ Home Automation
  • All
  • Articles
  • Bookmarks
  • Notes
  • Photos
  • Replies
  • Reviews
  • Trips
  • Videos
  • Contact
© 1999-2025 by Aaron Parecki. Powered by p3k. This site supports Webmention.
Except where otherwise noted, text content on this site is licensed under a Creative Commons Attribution 3.0 License.
IndieWebCamp Microformats Webmention W3C HTML5 Creative Commons
WeChat ID
aaronpk_tv