Situation & Outlook

S&O Server

Hide Navigation Pane

S&O Server

Previous topic Next topic No directory for this topic No expanding text in this topic  

S&O Server

Previous topic Next topic Topic directory requires JavaScript JavaScript is required for expanding text JavaScript is required for the print function Mail us feedback on this topic!  

Comments (...)

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 Desktop

S&O Server (this section)

S&O Data Resources

S&O Profiles

 

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.

 

Save grid display to Excel

 

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.

 

 

Pulling National Scope Data

 

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.

Comments (...)