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!
Log in to your Simple account and go to your dashboard. In the right hand column, change the view to "All Time".
The view will update to show all your transactions. Then, click the "Export" button and choose "CSV".
Save that file to your computer somewhere.
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.
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!
Now you'll see all your transactions on the map!
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.
Now. when you look at the map, your transactions will be colored darker for larger transactions!
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!
Here's what Esri will be doing at SXSW this year!
Catch the Esri trolley to the Lavahouse! The trolley runs Friday, Saturday and Sunday from 9:45am to 5pm! (No badge required!) Look for the trolley with the giant globe on the side!
The Lavahouse is open to the public! (no badge needed) Stop by at any point during the day to hang out with other like-minded geo people and check out the cool demos!
1614 Lavaca Street
(Entrance is around the back)