{"id":76431,"date":"2017-04-12T21:59:04","date_gmt":"2017-04-12T21:59:04","guid":{"rendered":"http:\/\/www.esri.com\/arcgis-blog\/products\/product\/uncategorized\/table-to-app-part-1-create-data\/"},"modified":"2018-03-26T21:12:42","modified_gmt":"2018-03-26T21:12:42","slug":"table-to-app-part-1-create-data","status":"publish","type":"blog","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/analytics\/analytics\/table-to-app-part-1-create-data","title":{"rendered":"Table to App – Part 1: Create Data"},"author":5631,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"_searchwp_excluded":""},"categories":[23341,23851,37511],"tags":[24311,23241,28621,23391,32081],"industry":[],"product":[36821,36551],"class_list":["post-76431","blog","type-blog","status-publish","format-standard","hentry","category-analytics","category-data-management","category-sharing-collaboration","tag-analysis","tag-best-practices","tag-feature-layers","tag-spatial-analytics","tag-zip-code","product-configurable-apps","product-arcgis-online"],"acf":{"short_description":"Have you ever found a table of data with some basic spatial fields like ZIP Codes or states and thought, this would be really interesting...","flexible_content":[{"acf_fc_layout":"content","content":"

Have you ever found a table of data with some basic spatial fields like ZIP Codes or states and thought, this would be really interesting data to map? After assigning geospatial locations, have you wondered about the best way to highlight the most compelling locations in your dataset? Whether it\u2019s the highest or lowest values or the most recent dates, there are characteristics within datasets that show the significance of your data to your audience. This two-part blog will outline best-practice workflows to turn tabular data into a geographical listicle using the Geo List configurable app.<\/p>\n

As U.S. Tax Day quickly approaches, I thought it would be interesting to look at some specific tax return statistics<\/a> about 2014 income tax returns published by the IRS. I decided to pick a small subset of the available data, the State of California ZIP Codes, and highlight some specific variables to better understand where residents received tax credits or needed to make payments. There is data available for every state on the website, so feel free to give this project a try in your state.<\/p>\n

Part 1: Create spatial data<\/span>
\"\"<\/p>\n

The dataset needs to be formatted so that there is one ZIP Code per field and only one field per column. To do this, I created a formatted CSV file<\/a> that contains with some selected variables about refunds and tax credits<\/a>per ZIP Code. I then used the Join Features<\/a>< tool, which was introduced in the ArcGIS Online December 2016 update<\/a>, to create a new polygon ZIP Code dataset from the CSV. Below are the steps I used and some best practice tips for creating polygon ZIP Code data from a CSV.<\/p>\n

    \n
  1. Publish the CSV file as a table:<\/strong>\n