|
|
||
The S&O Server is a Windows-based client program providing API access to wide-ranging geographic-demographic economic data. Data resources accessible include:
•ProximityOne Demographic-Economic Estimates and Projections
•American Community Survey 2011
•American Community Survey 2010
•Census 2010
•Census 2000
•1990 Census
•Location-based data and linkage
Data resources are progressively expanded and updated. See more about datasets accessible.
Retrieve/display national scope data via API queries applied to server-based datasets.
02.28.13. S&O Server 2.1 Datasets Added
•Many new datasets are now accessible.
•Among these are 1990 Census, 2000 Census and ACS 2011 113th Congressional District data
•More about these dataset expansions .. Datasets
2.19.13. S&O Server 2.1 Geocoder API Added
•Convert/translate latitude-longitude coordinates to census block geocodes
•Higher level geocode assignment also available: census tract, county, metro, state, others
•More about this feature .. Geocoder API
02.11.13. S&O Server 2.1 Custom Spreadsheet Feature Added
•Build custom spreadsheets mixing data from any S&O Server data source
•More about this feature .. Custom Spreadsheet
02.04.13. S&O Server 2.1 Now Available
•Many new features
•New extract/display/analysis operations
•Support for ACS 2011 (http://proximityone.com/acs0711.htm)
•Data for new geographic levels including school districts and ZIP Code areas
•Registration is required.
•Register here -- http://proximityone.com/contact.htm and mention S&O Server 2.1.
S&O Server is one of several primary S&O components.
S&O Server (this section)
Join in ... optionally register to receive updates (mention S&O Server in text section). You will receive updates regarding revisions and new developments. Your information is not shared with anyone.
Please send us your feedback. No comment is too detailed or general.
Use the S&O Server to access most subject matter items in the Census Bureau Census 2010 Summary File 1 and American Community Survey 2010 and American Community Survey 2011 data without loading any of the underlying subject matter data on your computer. The S&O Server client, installed on your computer, requires approximately 20MB of disk space. Data access requires Internet and data are downloaded using API queries.
In this section ...
•Accessing American Community Survey 2010 data -- view
... illustration of accessing/displaying ACS 2010 5 year median household income
•Accessing Census 2010 Summary File 1 data -- view
... illustration of accessing/displaying Census 2010 SF1 Table P3. Population by Race
•Saving grid display to Excel/CSV -- view
... structured for easy merging with shapefiles for GIS applications
•Examining Linguistic Isolation -- Texas by County -- view
... illustrating ability to pull all items for selected tables; or omitting unwanted items
•Using S&O Server to Examine Block Group Demographics -- view
•Pulling national scope U.S. by county ... place ... congressional district data -- view
Accessing American Community Survey 2010 data
Illustration of accessing/displaying ACS 2010 5 year median household income
All places in Hawaii

Changing dataset selection to Census 2010 Summary File 1

Accessing Census 2010 Summary File 1 data
Illustration of accessing/displaying Census 2010 SF1 Table P3. Population by Race
All places in Hawaii -- click Go after switching to Census 2010 SF1 (previous graphic)
By default, items P0030001 through P0030008 are selected in the subject matter listbox at left shown in graphic below.

Expanding on previous view, next view shows "dragging" item descriptive section (above grid) to reveal variable name descriptions.
See pointer in grid. East Honolulu CDP had total population (P0030001) of 49,914 based on Census 2010.


Partial view of saved grid in Excel.

Select Alternative Geography
Hawaii by County; same ACS 2010 median household income item.
County data display when Go button clicked.

Examining Linguistic Isolation -- Texas by County

Using S&O Server to Examine Block Group Demographics
Census 2010 Summary File 1 block group demographics
The following view illustrates accessing Census 2010 SF1 Table P3 items (population by race) by block group for the 3 block groups comprising Honolulu County (15003) census tract 000107. As of Census 2010, the total population in BG 15-003-000107-1 was 1,525 and the White alone population was 367.

When using block group geography, the user is prompted for the county:

and then the census tract

American Community Survey 2010 5-year block group estimates
The following view illustrates accessing ACS 2010 Table B02001 items (population by race) by block group for the 3 block groups comprising Honolulu County (15003) census tract 000107. As of mid-2008 (estimates are centric to mid-2008), the total population estimate for BG 15-003-000107-1 was 1,280 and the White alone population estimate was 352.

All Counties
The following view shows the grid loaded with the ACS 2010 5 year total population estimate by county for all counties in the U.S.
For summary levels 040 (states), 050 (counties), 160 (cities/places), 500 (congressional districts) this is achieved simply by checking the "All U.S." checkbox in the left panel above the state listbox. This action overrides individual state selection. Use File>SaveGrid As to save the data in Excel or CSV structure.

All Congressional Districts
The next view shows the grid loaded with the ACS 2010 5 year race-related estimates by congressional district for all congressional districts in the U.S. This is achieved simply by checking the "All U.S." checkbox in the left panel above the state listbox. This action overrides individual state selection. Use File>SaveGrid As to save the data in Excel or CSV structure.
