This tool generates national statistics data directly within SPSS. It works by capturing the latest population, lifestyle, market, job and spending data from Esri’s Geoenrichment Service after referencing location values (latitude and longitude values) provided in the stream. This specific version has full support for coorindates in the United States, however the tool code can be altered to support other countires.
Esri demographic data sources are documented here, Esri U.S. Data Fact Sheet (PDF).
- Read dependencies section
- Install NatSTAT
- Build a stream that includes a data source containing a Latitude and Longitude field
- Click on the NatSTAT node and connect the Latitude and Longitude fields with your data source
- Select a data collection, buffer distance and input your ArcGIS Online username and password
- Connect the NatSTAT tool with an output node
- Run the stream
Below are the data collections which you can use to enrich your data. The column titled total number of variables indicates the total number of fields that will get generated in your output. To learn more about the data collection variables, which will be included in your output, click on the hyperlinks in the below table to open up the National Statistic Variable Explorer.
| Data collection | Total # of National Statistic Variables | Available In NatSTAT |
|---|---|---|
| Disposable Income | 96 | Yes |
| Food Stamps / SNAP | 6 | Yes |
| Household Income | 92 | Yes |
| Income by Age | 396 | Yes |
| Net Worth | 82 | Yes |
| Wealth Facts | 58 | Yes |
| Category | Total # of National Statistic Variables | Available In NatSTAT |
|---|---|---|
| Age 1 Year Increments | 576 | Yes |
| Age 5 Year Increments | 187 | Yes |
| Age by Race by Sex | 1000 | Yes |
| Income by Age | 396 | Yes |
| Category | Total # of National Statistic Variables | Available In NatSTAT |
|---|---|---|
| Disability | 6 | Yes |
| Household Totals | 35 | Yes |
| Household Type | 35 | Yes |
| Households by Age of Householder | 16 | Yes |
| Households by Race of Householder | 44 | Yes |
| Households by Size | 13 | Yes |
| Presence of Children | 55 | Yes |
| Category | Total # of National Statistic Variables | Available In NatSTAT |
|---|---|---|
| Heating Fuel | 28 | Yes |
| Home Value | 110 | Yes |
| Housing Cost | 114 | Yes |
| Housing Unit Totals | 4 | Yes |
| Housing by Age of Householder | 16 | Yes |
| Housing by Race of Householder | 16 | Yes |
| Housing by Size | 14 | Yes |
| Owner and Renter | 8 | Yes |
| Units in Structure | 34 | Yes |
| Vacant | 10 | Yes |
| Vehicles Available | 39 | No |
| Year Built | 31 | No |
| Year Moved In | 36 | No |
| Category | Total # of National Statistic Variables | Available In NatSTAT |
|---|---|---|
| Health | 161 | No |
| Health Insurance Coverage | 123 | Yes |
| Category | Total # of National Statistic Variables | Available In NatSTAT |
|---|---|---|
| Educational Attainment | 54 | Yes |
| School Enrollment | 70 | Yes |
| Category | Total # of National Statistic Variables | Available In NatSTAT |
|---|---|---|
| Businesses | 73 | Yes |
| Employees | 72 | No |
| Industry by NAICS Code | 123 | Yes |
| Industry by SIC Code | 96 | Yes |
| Sales | 73 | Yes |
| Category | Total # of National Statistic Variables | Available In NatSTAT |
|---|---|---|
| Gender | 187 | Yes |
| Group Quarters | 12 | Yes |
| Key Global Facts | 5 | Yes |
| Language | 154 | Yes |
| Population Totals | 20 | Yes |
| Category | Total # of National Statistic Variables | Available In NatSTAT |
|---|---|---|
| Age by Race by Sex | 1000 | Yes |
| Hispanic Origin | 24 | Yes |
| Language | 154 | Yes |
| Race and Hispanic Origin | 68 | Yes |
| Category | Total # of National Statistic Variables | Available In NatSTAT |
|---|---|---|
| Clothing | 79 | Yes |
| Education | 12 | Yes |
| Entertainment | 72 | Yes |
| Financial | 57 | Yes |
| Food | 169 | Yes |
| Health Personal Care | 54 | Yes |
| Housing and Household | 197 | Yes |
| Life Insurance and Pension | 8 | Yes |
| Miscellaneous | 27 | Yes |
| Spending Total | 2 | Yes |
| Transportation | 63 | Yes |
| Travel | 26 | Yes |
| Category | Total # of National Statistic Variables | Available In NatSTAT |
|---|---|---|
| Automobiles & Automotive | 137 | Yes |
| Baby Products, Toys & Games | 57 | Yes |
| Civic Activities & Political Affiliation | 31 | Yes |
| Clothing, Shoes & Accessories | 68 | Yes |
| Electronics & Internet | 198 | Yes |
| Financial & Insurance | 184 | Yes |
| Grocery & Alcoholic Beverages | 301 | Yes |
| Health & Personal Care | 191 | Yes |
| Home Improvement, Garden & Lawn | 106 | Yes |
| Household Goods, Furniture & Appliances | 154 | Yes |
| Leisure Activities/Lifestyle | 132 | Yes |
| Media - Magazines & Newspapers | 51 | Yes |
| Media - Radio & Other Audio | 76 | Yes |
| Media - TV Viewing | 127 | Yes |
| Pets & Products | 41 | Yes |
| Phones & Yellow Pages | 108 | Yes |
| Psychographics & Advertising | 178 | Yes |
| Restaurant | 91 | Yes |
| Shopping | 148 | Yes |
| Sports | 99 | Yes |
| Travel | 85 | Yes |
| Category | Total # of National Statistic Variables | Available In NatSTAT |
|---|---|---|
| Commute | 97 | Yes |
| Industry | 25 | Yes |
| Occupation | 23 | Yes |
| Veterans | 73 | Yes |
| Women | 37 | Yes |
| Category | Total # of National Statistic Variables | Available In NatSTAT |
|---|---|---|
| Households | 37 | Yes |
| Population | 22 | Yes |
| Category | Total # of National Statistic Variables | Available In NatSTAT |
|---|---|---|
| Marital Status Totals | 18 | Yes |
| Category | Total # of National Statistic Variables | Available In NatSTAT |
|---|---|---|
| Lifemode Groups | 14 | Yes |
| Tapestry Adults | 69 | Yes |
| Tapestry Households | 92 | Yes |
| Tapestry Population | 89 | Yes |
| Urbanization Groups | 6 | Yes |
| Category | Total # of National Statistic Variables | Available In NatSTAT |
|---|---|---|
| At Risk | 65 | Yes |
| Category | Total # of National Statistic Variables | Available In NatSTAT |
|---|---|---|
| Key US Facts | 14 | Yes |
| Category | Total # of National Statistic Variables | Available In NatSTAT |
|---|---|---|
| Retail Marketplace | 184 | Yes |
| Category | Total # of National Statistic Variables | Available In NatSTAT |
|---|---|---|
| Policy Facts | 36 | Yes |
| Category | Total # of National Statistic Variables | Available In NatSTAT |
|---|---|---|
| Infrastructure | 7 | Yes |
| Landcover | 7 | Yes |
| Landscape Facts | 9 | Yes |
| Public Lands | 8 | Yes |
| Soils | 9 | Yes |
| Water and Wetlands | 6 | Yes |
NatSTAT for SPSS requires an ArcGIS Online subscription. If you do not have access to an ArcGIS Online subscription the good news is that you can register for a free evaluation here. The free evaluation gives you 200 credits which can be used to support SPSS analysis. This requires IBM SPSS Modeler 17.1 (it may work on newer SPSS versions if so please update this documentation).
The location values passed into NatSTAT are converted into geographic points. These points are then buffered according to the distance chosen. Demographic data that intersects with the area is summarized using Esri’s spatial data apportionment logic.
When running this tool it’s recommended to initially pass in a small number of records (3-5 records) containing location data before processing large datasets. This workflow helps ensure that ArcGIS Online credits consumed while processing large datasets will be meaningful. If the output of the small data stream is not meaningful do not process the large dataset.
For the full catalog of U.S. Esri Demographic and Business Data, download the 2015 Esri Demographic and Business Data List (XLS).
It would be pretty easy to modify this tool to generate national statistic data for countries outside the US by referencing the proper 2-digit country code and by changing the dropdown values. The dropdown values will need to be changed because not every country has the same data availability. To determine available for each country use this data browser tool.
Anyone and everyone is welcome to contribute.
Copyright 2016 Esri
Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.
A copy of the license is available in the repository's license.txt file.
[](Esri Tags: IBM SPSS) [](Esri Language: R)


