This formula illustrates how you would calculate a “majority index” for a range of fields. For example, you may have a dataset that illustrates foreign born Asians, and would like to know which country has the most foreign born’s in each census tract.
To create an index, you can add a new column, and fill in the following forumla:
These are the header values that will go into the cell (ex: Japanese, Korean). This is specific to this dataset, so it will need to be adjusted accordingly.
These are the cells that hold the actual data you are caclulating (ex: 10, 134)
The results show the majority country in the field:
When you are ready to download your data from Social Explorer, follow these steps to add it to ArcMap:
- From the data download tab, download the csv format in the desired geographic level (ie: census tracts)
- Once downloaded, copy the downloaded file, and change the file format from csv to txt (you should now have a csv and txt version of the same file)
- Launch Excel, and open the text (txt) version of the downloaded file
- In the popup wizard, select “delimited”, and in the next step, “comma”
- In step 3, scroll the data preview until you see a header titled “FIPS” or “Geo_FIPS”
- Highlight the column, and select “Text” as its data format
- Click finish to exit the wizard. You should see your data imported, and the FIPS field should have leading zeroes (ex: 06037200001)
- Highlight the first row and delete it (this row has the long description for each data field, and keeping this row will make ArcMap very unhappy)
- Save the file as Excel 97-2003
- You should now have 3 versions of your downloaded data: csv, txt and xls
- Open ArcMap and add the XLS version of your data
- Make sure that the FIPS field appears with the leading zeroes in the attribute table.
Prior versions of ArcCatalog (9.3) allowed you to view a layer’s metadata in ArcCatalog by clicking on a “metadata” tab. Arc10 goes away with this (I have no idea why), and hides this feature in their advanced options. Here is how to access the good ‘ol metadata information using ArcCatalog v10:
- Open ArcCatalog
- Go to Customize, ArcCatalog Options
- Select the Metadata tab, choose ISO 19139 Metadata Implementation Specification