CT Data.org Webinars – July 2012

The Connecticut Data Collaborative is sponsoring webinars and training opportunities for data generators and users to learn how to use the new CTData.org portal.  

Bringing Data Alive! An Introduction to CTData.org

In this introductory webinar, CTData.org project coordinator Jim Farnam will explain the structure and organization of the site, how to access the data and metadata, data visualization options and customizations, and ways to share your data visualizations with others.

Release Your Inner Data Wonk: Using Advanced Weave Data Visualization Tools on CTData.org

In this webinar, CTData.org project coordinator Jim Farnam will explain the structure and organization of the site, how to access the data and metadata, and provide training in use of the advance Weave data visualization tools.


Older Populations to Exceed Children in Most World Regions by 2050, Census Bureau Reports

Older Populations to Exceed Children in Most World Regions by 2050, Census Bureau Reports

The world’s inhabitants in 2012 are an older mix of people than was the case a decade ago, driven by declining fertility and increasing life expectancy. According to new U.S. Census Bureau population projections, by midcentury most world regions will resemble Europe, which in 2005 became the first major world region where the population 65 and older outnumbered those younger than 15 (see Figure 1).

Figure 1: Europe Population Pyramid: 2005

Northern America, which includes Canada and the United States, will have joined Europe in this historic reversal of age group sizes by 2050 (see Figure 2), as will Asia (Figure 3), Latin America (see Figure 4) and Oceania (which includes Australia and New Zealand) (see Figure 5).

Figure 2: Northern America Population Pyramid 2050
Figure 3: Asia Population Pyramid 2050
Figure 4: Latin America and the Caribbean Population Pyramid 2050

Figure 5: Oceania (Includes Australia and New Zealand) Population Pyramid 2050
Moreover, China is projected to move from having nearly twice as many people in the younger age group than in the older one in 2012, to the opposite situation by midcentury (see Figure 6).
Figure 6: China Population Pyramid 2050

Each of these projections come from an update of the Census Bureau’s International Data Base, which includes estimates by age and sex to 100 years and older for countries and other areas with populations of 5,000 or more and provides information on population size and growth, mortality, fertility and net migration.

Since April 2012, users of the International Data Base have been able to obtain population in single years of age, allowing them to calculate country-specific populations in particular age groups (e.g., population at selected ages younger than 5, or adolescents).

Between now and the middle of the 21st century, global population will continue aging. The percentage of population 65 and older will more than double, from 8 percent today to nearly 17 percent in 2050, carrying with it well-established changes in the mix of communicable and noncommunicable disease patterns in populations, health care burden, pension systems, the composition and character of the labor force, and other economic variables, such as savings and consumption patterns.

One world region — Africa — will continue to have populations younger than 15 that are much larger than those 65 and older, but even there, the balance will have shifted toward the older group (see Figure 7).

Figure 7: Africa Population Pyramid 2050



View and Download Data
Want to explore additional population projections by country or region? View the data included in the charts above and more from the U.S. Census Bureau’s International Programs – International Data Base page at: http://www.census.gov/population/international/data/idb/informationGateway.php

This news release was provided by the U.S. Census Bureau with graphics added by the Connecticut State Data Center.

2010 Census of Population and Housing Units Counts – Connecticut

2010 Census of Population and Housing Unit Counts – Connecticut

The U.S. Census Bureau has just released a new report based on the 2010 Census for Population and Housing Unit Counts for Connecticut. This report includes housing units, population by urban and rural areas and more. Several of the tables also include historical census data at the state, county, county subdivision, place, and/or minor civil division levels for Connecticut.

This report provides easy to read tables of data which provides the same data available from the American FactFinder in a streamlined report. This report also includes population density, housing density and additional details which may be helpful to our readers.

Check out the full report at: http://www.census.gov/prod/cen2010/cph-2-8.pdf

GeoFocus Summer 2012 Now Available

The Connecticut GIS User to User Network and the Connecticut GIS Council Education and Outreach Working Group’s latest issue of GeoFocus, CT’s Quarterly Geospatial Newsletter is now available. Included below are just a few highlights from the Summer 2012 (June) issue:

  • Editorial: Data Sharing Law Passes!
  • Using Smartphones to Maintain Streetlights
  • Connecticut Orthophoto Update
  • Census Q&A
  • Measure Tree Canopy
  • New Population Projections for Connecticut
  • State POCD Map Changes
  • Letter from Thad Dymkowski – President of the Connecticut GIS User to User Network
  • And more!
Check out the latest issue today!
Interesting in contributing to CT GeoFocus?
If you are interested in submitting articles for the next issue of GeoFocus, details are provided on page 2 of the newsletter. Articles for the next issue are due by 8/30/2012.

Month in Review – CtSDC at MAGIC – June 2012

Month in Review – CtSDC & MAGIC – June 2012
To provide our readers with a summary of usage trends, the Connecticut State Data Center (CtSDC) and the University of Connecticut Libraries Map and Geographic Information Center (MAGIC) will be publishing a summary report for each month to this blog. This summary report provides our readers with an opportunity to view trends in usage of webpages, examine trends in keyword searches, and will feature a brief overview of projects in development. Included below are highlights from June 2012 which focuses on five main areas: User Inquiries, Web Content Views, Trends in Webpage Usage, Trends in Keywords, and Projects in Progress.
I. User Inquiries
Total User Inquiries
Included below are the statistics for user inquiries received by phone, email, and in-person during June 2012. As the data clearly visualizes, the number of inquiries continues to rise with the year to date totals representing a 109% increase when compared to the January 1- June 30 of the previous year.
Web Resource
Total Inquiries
Monthly Change
vs. 2011
YTD Inquiries
for 2012
YTD Change
vs. 2011
Connecticut State Data Center
161
35%
835
88%
MAGIC
128
83%
849
136%
Total
289
53%
1,684
109%



II. Web Content Views
Total Unique Content Views
Included below are the web content unique views statistics for June 2012 which include comparisons with June 2011, the year to date (YTD) unique views and the change in the total number of unique views when compared to the same time period (January 1 – June 30)  from the previous year.
Web Resource
Unique Views
Monthly Change
vs. 2011
YTD Unique Views
for 2012
YTD Change
vs. 2011
Connecticut State Data Center
1,951
21%
9,492
12%
MAGIC 2.0 Online Maps
410
-53%
3,284
-49%
MAGIC  Flickr Collections
35,066
77%
200,313
46%
MAGIC News Blog (Retired)
35
75%
221
16%
MAGIC Website
10,622
21%
75,130
10%
Outside the Neatline Blog
953
59%
5,251
49%

Total
49,038
55%
293,705
31%
Total Content Views
With more users viewing web content more than once from MAGIC and the Connecticut State Data Center, the total views of web content provides a more detailed view of the trends in usage. The following table includes the usage trends for the total number of views, monthly change when compared to same month in 2011, the year to date (YTD) total number of views and the change in total views when compared to the same time period (January 1 – June 30) from the previous year.
Web Resource
Total Views
Monthly Change
vs. 2011
YTD Total Views
for 2012
YTD Change
vs. 2011
Connecticut State Data Center
2, 716
9%
14,136
10%
MAGIC 2.0 Online Maps
3,044
-62%
28,738
-56%
MAGIC  Flickr Collections
35,066
77%
200,313
46%
MAGIC News Blog (Retired)
55
175%
310
36%
MAGIC Website
16,474
21%
118,827
12%
Outside the Neatline Blog
1,288
61%
7,129
45%
Total
58,644
31%
369,467
13%
III. Trends in Webpage Usage – June 2012
Ever wondered what the most popular pages are at MAGIC and the Connecticut State Data Center? Included below are the top 5 most popular pages for June 2012.
Most Popular pages – Connecticut State Data Center
Page
Total Views
916
579
397
132
124
Most Popular pages – MAGIC 
Page
Total Views
3,362
  2,865
1,105
911
773
Most Popular pages – Outside the Neatline Blog – June 2012
Page
Total Views
166
     71
65
61
43

IV. Trends in Keywords – June 2012
At the Connecticut State Data Center and MAGIC each month we analyze keyword searches conducted on our websites to determine areas to focus increasing accessing to maps, data, and resources. Keyword provide us with an opportunity to see trends, areas for improvement, and have been integral to providing guidance on website development and improvements. Included below are keyword trends for June 2012.

Most Frequent Keywords – Connecticut State Data Center
Keyword
Demographic Profile Senate
Family statistics
06050
1940 Census Data West Hartford
  
Most Frequent Keywords – MAGIC
Keyword
Campus map
parcels
Appalachian trail
Canaan
Elevation

V. Projects in Progress – June 2012
Each month the students and staff at MAGIC and the Connecticut State Data Center are working on a series of projects, tasks, data sets, and resources which users typically don’t know about until we add the resource to our website. Included below is a list of projects that are currently underway which will be completed in the coming months and made available in their final forms via our websites.

  • Connecticut Population Projections 2015-2025 – This project involves developing updated population projections based on the 2010 Census, Birth and Mortality data from the Connecticut Department of Public Health, and developing derived migration based on these data for multiple levels of geography. This project is still underway and the public is able to view a preliminary version (population estimates are subject to change as we refine the methods over the next month). View the preliminary projections and the interactive data interface at: http://ctsdc.uconn.edu/projections.html
  • Air Navigation Maps 1923-1935 Index – This project, developed by Trevor Rzucidlo during his internship and independent study at MAGIC during Fall 2011-Spring 2012, provides an interactive index to a series of over 150 historical air navigation maps from 1923-1935 for the United States. The index is currently available and additional georeferenced maps are being added in the coming weeks. The interface provides users with quick access to individual maps and is based on Google Fusion Tables. Check out this index at: http://magic.lib.uconn.edu/mash_up/air_navigation_index.html
  • Aerial Photography TIFFs and PDFs Project – In the coming months users will be able to access full-quality TIFF, GeoTIFF, and PDF images for aerial photography from 2004, 2006, 2008, 2009, and 2010 via a series of interactive indexes based on Google Fusion Tables. Once completed, users will be able to download TIFF, GeoTIFF, and PDF images for a location directly from the interactive aerial photography index.
Have an idea for a project or suggestions for improvements to MAGIC and the Connecticut State Data Center’s website and web offerings? Leave us a comment or contact us at magic@uconn.edu.  



Each month we will be posting a “Month in Review” article so check back in a month to see the latest information on usage trends at MAGIC and the Connecticut State Data Center.

Visualizing the pay gap: educational attainment & income data from the American Community Survey

Each year the Census Bureau’s American Community Survey provides dozens of tables of interesting data related to education – tracking enrollment in public and private schools, the number of individuals holding bachelor’s degrees in various fields, and cross-tabulating educational levels with characteristics as diverse as place of birth, mobility and race. Data on the relationship between educational attainment and income are available in table S1501 of the ACS. Based on the data in that table, the thematic map and chart below illustrate the relationship between education and income, as well as the gap in income between men and women with equivalent levels of educational attainment – from those with less than a high school diploma to those with a graduate or professional degree.

<a href=”undefined”><img alt=”Dashboard 1 ” src=”http://public.tableausoftware.com/static/images/Ea/EarningsbyEducationalAttainment2010/Dashboard1/1_rss.png” style=”border: none” /></a>

U.S. Fastest Growing Cities between 2010 and 2011

The U.S. Census Bureau has just released a listing of the fastest growing cities between the 2010 Census (April 1, 2010) and the Population Estimates for July 2011. Based on the 2011 Population Estimates from the U.S. Census Bureau the largest percent increase in population from 2010 to 2011 was in New Orleans, Louisiana with a 4.9% increase. When we examine the total number of people rather than percentage, New York, New York added just over 69,777 people, the largest numeric increase in population in cities from 2010 to 2011. Check out the top 15 fastest growing, largest numeric increases, and largest populations cities in the U.S. based on the 2011 Population Estimates below:

Table 1. The 15 Fastest-Growing Large Cities from April 1, 2010, to July 1, 2011

Percent
Increase
2011 Total
Population
1.
New Orleans, LA
4.9 360,740
2.
Round Rock, TX
4.8 104,664
3.
Austin, TX
3.8 820,611
4.
Plano, TX
3.8 269,776
5.
McKinney, TX
3.8 136,067
6.
Frisco, TX
3.8 121,387
7.
Denton, TX
3.4 117,187
8.
Denver, CO
3.3 619,968
9.
Cary, NC
3.2 139,633
10.
Raleigh, NC
3.1 416,468
11.
Alexandria, VA
3.1 144,301
12.
Tampa, FL
3.1 346,037
13.
McAllen, TX
3.0 133,742
14.
Carrollton, TX
3.0 122,640
15.
Atlanta, GA
3.0 432,427

Table 2. The 15 Cities with the Largest Numeric Increase from April 1, 2010, to July 1, 2011

Numeric
Increase
2011 Total
Population
1.
New York, NY
69,777 8,244,910
2.
Houston, TX
45,716 2,145,146
3.
San Antonio, TX
32,152 1,359,758
4.
Austin, TX
30,221 820,611
5.
Los Angeles, CA
27,077 3,819,702
6.
Dallas, TX
25,413 1,223,229
7.
Phoenix, AZ
23,815 1,469,471
8.
Denver, CO
19,960 619,968
9.
Charlotte, NC
19,663 751,087
10.
San Diego, CA
18,773 1,326,179
11.
New Orleans, LA
16,911 360,740
12.
Fort Worth, TX
16,708 758,738
13.
El Paso, TX
16,416 665,568
14.
Washington
16,273 617,996
15.
San Jose, CA
14,875 967,487

Table 3. The 15 Most Populous Cities: July 1, 2011

2011 Total
Population
1.
New York, NY
8,244,910
2.
Los Angeles, CA
3,819,702
3.
Chicago, IL
2,707,120
4.
Houston, TX
2,145,146
5.
Philadelphia, PA
1,536,471
6.
Phoenix, AZ
1,469,471
7.
San Antonio, TX
1,359,758
8.
San Diego, CA
1,326,179
9.
Dallas, TX
1,223,229
10.
San Jose, CA
967,487
11.
Jacksonville, FL
827,908
12.
Indianapolis, IN
827,609
13.
Austin, TX
820,611
14.
San Francisco, CA
812,826
15.
Columbus, OH
797,434

Read additional details at: http://www.census.gov/newsroom/releases/archives/population/cb12-117.html

Connecticut History Website from Connecticut Humanities Council now available!

The Connecticut Humanities Council has released a new website dedicated to Connecticut History at connecticuthistory.org. This website includes stories about people, traditions, innovations, and events that make up the rich history of the state of Connecticut. Each week new content, connections are added to the site.

The site includes the ability to view content by topics, people, and towns. With a combination of photographs, illustrations, documents, web resources, and more you will want to spend some time exploring the site in greater detail. With an easy to navigate interface, users will enjoy viewing the Connecticut History Towns Page which features images from each of Connecticut’s 169 towns plus links to information pertaining to each town. With the entire website continuing to expand with new stories weekly we encourage readers to view the site weekly and you can following the site from Twitter, Facebook, and even subscribe to the RSS feed for the website.

This website was developed in partnership with the Roy Rosenzweig Center for History and New Media at George Mason University and features content from Connecticut ExploredConnecticut History Online, and  The Connecticut Council for Social Studies.

Connecticut GIS User to User Network Meeting – Friday June 29, 2012

The Connecticut GIS User to User Network Quarterly meeting will be held on Friday June 29, 2012 from 8:00am-12:00pm at the South Central Regional Water Authority in New Haven, Connecticut. The focus of this meeting will be “GIS Planning, Preparation, and Mitigation for Natural Disasters” and will feature three presentations plus include time for networking. 
Date: June 29, 2012
Time: 8:30am – 12:00pm
Location: SouthCentral Connecticut Water Authority 90 Sargent Drive New Haven, CT
Cost: FREE!

The agenda for this meeting is included below:

8:00 – 8:45            Networking
8:45 – 9:45           Jeffery Bolton, Dept of Construction Services presenting on the Storm Response and Recovery Assessment Group Report
9:45 – 10:00         Break
10:00 – 10:45       Meghan McGaffin, GIS Analyst City of Milford presenting on Mapping for Citizen Outreach – FEMA Flood Map Changes Affect 5,000 Parcels
10:45 – 11:00       Break
11:00 – 11:45       Scott Roberts IT Director and Dawn Mulholland GIS Analyst of South Windsor presenting on Citizen Service Request Dashboard, winner of an ESRI 2012 Special Achievement in GIS Award
11:45 – noon       Wrap up






Workshop on GIS Mobility and Field Data Collection 


Shortly after this meeting a GIS Mobility Workshop Information is being offered at the nearby La Quinta Inn and Suites starting at 12:15pm with pizza provided for participants. For more information, contact Brad Tatham at the Connecticut GIS User to User Network Meeting or call 520-971-7624 or email brad@GISServices.net 


Date: June 29, 2012

Time: 12:15pm
Location: La Quinta Inn and Suites – 400 Sargent Drive New Haven, CT
Cost: FREE!


Food: Pizza lunch is provided for participants




Hurricane Visualizations – 1851 to Present

With hurricane season upon us, the New Scientist has developed a visualization of the path of hurricanes for the past 20 years. Explore year by year the path of each hurricane, view the total number of storms for each year, and each visualization includes the maximum wind speed for each storm.

As you explore this article further you will discover that 2005, the same year that Katrina and Rita caused so much damage to the gulf coast, there were a total of 28 storms. These 28 storms in 2005  resulted in just over 1,000 casualties, representing the highest number of hurricane related deaths over this 20 year period.

Review this article and view 1990-2010 Hurricane Visualizations at:
http://www.newscientist.com/blogs/shortsharpscience/2011/05/prepare-for-hurricane-season.html

Want To Explore More Hurricane Data?
The National Oceanic and Atmospheric Administration (NOAA) has developed an interactive interface to enable users to explore Historical Hurricane Tracks which can be explore by location, storm name, and ocean basin. This interface allows users to view storms from the late 1800s to present and includes barometric pressure readings, wind speeds, storm category, and more details plus the ability to download the data. This visualization can be viewed at: http://csc.noaa.gov/hurricanes/

The NOAA Historical Hurricane Tracks also allows users to refine their search by storm category, time frame, and even barometric pressure. This interface provides great visualizations of the life cycle of a hurricane and provides an interactive display of the path of the hurricane.

More Resources to Explore
Want to explore more details about hurricanes and historical hurricane visualizations? The following links include some additional resources related to hurricanes: