Tag Archives: CV XE GIS

City Population Characteristics & Trends: 2010-2016

.. the change in U.S. city population from 2010 to 2016 ranged from growth of 345,647 in New York City to a decline of -38,293 in Detroit, MI. New York City is actually five counties; the next largest city growth was Houston, TX with a 197,857 population gain.  Examine how the population is changing in cities of interest using the interactive table and other tools described in this post.  Use the interactive table to view a selected city, all cities in a state, cities in a county, cities in a metro or cities in a peer group size class.  See related Web section for more details.

Use the U.S. by cities shapefile with your GIS projects. See details. Thematic pattern maps illustrating use of these resources are shown below.

The July 1, 2016 Census Bureau model-based estimates (see about these data) for the U.S. 19,510 incorporated cities show a total population of 203,314,546 compared to 192,174,578 as of Census 2010. These areas are incorporated cities as recognized by their corresponding state governments and granted certain governmental rights and responsibilities.

Patterns of City Percent Change in Population 2010-16
— Cities 10,000 Population & Over
Use the CV XE GIS software with cities GIS project to examine characteristics of city/place population, 2010-2016. The following view shows patterns of population percent change, 2010-16 for cities with 2016 population of 10,000 or more. Use the interactive table below to see that among cities with 2016 population of 10,000 and over that Buda, TX had the largest percent change (98.8%) while Avenal, CA experienced the largest percent decrease (-18.4).

– View developed using the CV XE GIS software.
– Click graphic for larger view.

Fastest Growing Cities in the Dallas, TX Metro
— Cities 10,000 Population & Over; create views like this for any metro/county
It is easy to see which cities are growing the fastest using the thematic pattern view below. It is also easy to see how the cities relate to each other geographically and in context of county boundaries. The following view shows patterns of population percent change, 2010-16 for cities with 2016 population of 10,000 or more in the Dallas metro area.

– View developed using the CV XE GIS software.

Drill-down — Fastest Growing Cities in the Dallas, TX Metro
— Cities 10,000 Population & Over
Zoom into the north Dallas metro area and label the cities with name. The following view shows patterns of population percent change, 2010-16 for cities with 2016 population of 10,000 or more in the Dallas metro area.

– View developed using the CV XE GIS software. Click graphic for larger view; expand browser window for best quality view.

City/Place Demographics in Context
State & Regional Demographic-Economic Characteristics & Patterns
.. individual state sections with analytical tools & data access to block level
Metropolitan Area Situation & Outlook
.. continuously updated characteristics, patterns & trends for each/all metros
Related City/Place Demographic-Economic Interactive Tables
ACS 2015 5-year estimates
.. General DemographicsSocialEconomicHousing Characteristics

Using the Interactive Table
Use the full interactive table to examine U.S. national scope cities by annual population and change 2010-2016. The following graphic illustrates use of the table to view the largest cities ranked on 2016 population. Use the tools/buttons below the table to create custom views.

Click graphic for larger view.

Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

Relating ZIP Codes to City/Places

.. relating ZIP codes to cities .. 214 ZIP code areas intersect with New York city — what are these ZIP codes, their population and how many are completely within the city? What part of a ZIP code area of interest intersects with what city? Conversely, what ZIP code areas intersect with a city of interest? This section provides data and tools that can be used to answer these types of questions and gain insights into geospatial relationships. See more detailed information in the related full Web section.

The 2010 ZIP Code Tabulation Area (ZCTA) to City/Place relationship data provide a means to equivalence ZCTAs with Census 2010 cities/places. ZCTAs are geographic areas defined as sets of Census 2010 census blocks closely resembling USPS ZIP codes (lines, not areas). ZCTA boundaries are fixed for the intercensal period 2010 through 2020. Census 2010 vintage city/place areas are likewise defined as sets of Census 2010 census blocks. The ZCTA-City/place relationship data are developed through the use of the intersecting census block geography and associated Census 2010 Summary File 1 demographic data.

ZCTA-Place Relationships
The following graphic shows relationships between two selected ZCTAs (red boundaries) and related cities/places (blue fill pattern) in the Pima/Cochise County, AZ area. Relationships between these geographies are reviewed in examples shown below.

– View developed using CV XE GIS and related GIS project.

Using the ZCTA-Place Relationship Data
Two examples illustrating how to use the ZCTA-place relationship data are provided below. The examples are interconnected to the GIS project used to develop the map views, interactive table and data file described in this section. Example 1 describes how to use the data for a ZIP code area entirely located within one city/place. Example 2 describes how to use the data for a ZIP code area located in more than one city/place and area not located in any city/place.

ZCTA to Place Relationships: Example 1
In this example, ZCTA 85711, highlighted in red in the graphic shown below, falls wholly within place 77000, outlined in bold black below. As a result, there is only one corresponding record for ZCTA 85711 in the relationship file. The 2010 Census population for this relationship record is 41,251 (POPPT) which is equal to the 2010 Census population for ZCTA 85711 (ZPOP). See more details about this example.

ZCTA to Place Relationships: Example 2
In this example, ZCTA 85630, highlighted below in red in the graphic shown below, contains two places: all of place 62280 and part of place 05770, both are outlined in black below. As a result, there are two corresponding relationship records in the relationship file. For the first relationship record, the total 2010 Census population for ZCTA is 2,819 (ZPOP). See more details about this example.

Using the Interactive Table
Use the full interactive table to examine U.S. national scope ZCTA-city/place relationships. The following graphic illustrates how ZIP code can be displayed/examined for one city — Tucson, AZ. Each row summarizes characteristics of a ZIP code in Tucson. The last row in the graphic shows characteristics of ZIP code 85711 — the same ZIP code reviewed in Example 1 above.

Click graphic for larger view.

Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

Life Expectancy Change by County, 1980-2014

.. data and tools to examine changing life expectancy by county. Use the interactive table to examine life expectancy characteristics and related demographics for counties and regions of interest. Use the related GIS project and datasets to examine life expectancy contextually with other geography & subject matter. See details below. These data and tools are part of the ProximityOne health data analytics resources.

Life expectancy is rising overall in the United States, but in some areas, death rates are going in the other direction. These geographic disparities are widening.

Life Expectancy Change by County, 1980-2014
The following graphic shows patterns of the change in life expectancy change from 1980 to 2014. Click graphic for larger view. Expand browser window for best quality view.

– View developed using CV XE GIS and related GIS project.
– see below in this section about using this GIS project.

Life expectancy is greatest in the high country of central Colorado, but in many pockets of the U.S., life expectancy is more than 20 years lower. These data are based on research and analysis by the University of Washington Institute for Health Metrics and Evaluation.

Examining life expectancy by county allows for tracking geographic disparities over time and assessing factors related to these disparities. This information is potentially useful for policymakers, clinicians, and researchers seeking to reduce disparities and increase longevity.

Life Expectancy Change by County, 1980-2014 — drill-down view
— South Central Region
The following graphic shows patterns of the change in life expectancy change from 1980 to 2014. Click graphic for larger view. Expand browser window for best quality view. The larger graphic shows counties labeled with change in life expectancy from 1980-2014.

– View developed using CV XE GIS and related GIS project.
– see below in this section about using this GIS project.

Additional Views — use the GIS project to create your own views
.. click link to view
Alaska
Hawaii
Minneapolis metro

Using the Interactive Table
Use the interactive table to view, rank, compare life expectancy characteristics. This graphic shows California counties ranked on life expectancy change 1980-2014 in descending order. Select states or metros of interest. Click graphic for larger view.

Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

Creating & Using Location Shapefiles

.. GIS tools and methods to develop and update location shapefiles .. location shapefiles are essential to most GIS applications. Location shapefiles, or point shapefiles, enable viewing/analyzing locations on a map and attributes of these locations such store or customer ID, street address, city, date updated, value, ZIP code and wide-ranging attributes about the location. This section reviews tools and methods to develop and use location shapefiles. See more detail about topics covered in this section in the related Web page.

Viewing/Analyzing Store Locations in the Dallas, TX Area
The following graphic illustrates how store locations can be shown in context of other geography and associated demographic-economic attributes. This view shows store locations (red markers) in context of Dallas city (blue cross-hatch pattern) and broader metro area. Markers shown in this view are based on a location shapefile created using steps described below. The identify tool is used to click on a location and show attributes in a mini-profile.

.. view developed with ProximityOne CV XE GIS and related GIS project.

View the locations contextually with thematic patterns by tract or other geography. Combine views of store, customer, agent, competitor and other location shapefiles.
The following view shows patterns of median household income by census tract.

.. view developed with ProximityOne CV XE GIS and related GIS project.

Development of location shapefiles often starts with a list of addresses. Locations are not always address-oriented; they might be geographically dispersed measurement or transaction locations — having no address assigned. In applications reviewed here, locations are organized as rows in a CSV file. Each CSV file contains like-structured attributes for each location. The example used in this section uses store locations located in the Dallas, TX area.

There are two basic methods used to create location shapefiles: 1) geocoding address-data contained in the source data file or 2) using the latitude-longitude of the location included in the source data file record. The focus here is on option 2 — using the latitude-longitude of the location already present in the source data file.

Creating a Location Shapefile
The process of creating a location shapefile uses the CV XE GIS Manage Location Shapefile feature. With CV running, the process is started with File>Tools>ManageLocationShapefile. The following form appears.

.. ManageLocationShapefile feature/operation in ProximityOne CV XE GIS.

CV XE GIS provides other ways to create location shapefiles:
• Tools>AddShapes>Points — click points on the map window canvas.
• Tools>FindAddress — creates a single point shapefile based on specified address.
• Tools>FindAddress (Batch) — creates a point shapefile based on specified file of address records.
See details in User Guide.

Steps to Create a Location Shapefile
The process of creating the shapefile “C:\cvxe\1\locations1pts.shp” can be viewed by clicking the Run button on the form (with CV running). Two input CSV structured files are required:
• data definition file
• source data file

There are two sets of illustration location input files included with the CV installer:
• locations1_dd.csv and locations1.csv (7 locations in Johnson County, KS)
• locations2_dd.csv and locations2.csv (252 locations in Dallas and Houston)
These files are located in the \1 (typically c:\cvxe\1) folder. The marker/location shapefile used in the map shown above was created using the lcoations2 input files.

Data Definition File
The Data Definition (DD) file is an ASCII/text file structured as a CSV file. It may created with any text editor. The DD file is specific to the source data file. But in the case of recurring source data files for different periods the same DD file might apply to many source data files. There are several rules and guidelines for development of the DD file:
• there is one line/record for each field in the source data file.
• each line/record must be structured in an exact form:
.. each line/record is comprised of exactly 4 elements separated by a comma:
.. 1 field name for subject matter item
– must consist of 1 to 10 characters and include no blanks or special characters
.. 2 field type: C for character, N for numeric
.. 3 field length: an integer specifying the maximum with of the field
.. 4 maximum number of decimals for field (value is 0 for character fields)
The DD File must include three final fields:
LATITUDE,n,12,6
LONGITUDE,n,12,6
GEOID,c,15,0
The structure of these three DD file records must be as shown above. The source data file, described below, must have the LATITUDE and LONGITUDE fields populated with accurate values. The GEOID field may populated with either an accurate value of placeholder value like 0.

Example. Data for each store for the default DD file name “C:\cvxe\1\locations1_dd.csv” include the following fields/attributes:
  NAME,C,45,0
STORE,c,15,0
ADDRESS,c,60,0
CITY,c,40,0
LATITUDE,n,12,6
LONGITUDE,n,12,6
GEOID,c,15,0

Optionally create a DD File using the Create DD File button on the form. Clicking this button will create a DD File containing attributes of the dBase file specified in the associated edit box. The DD File name is created from the dBase file name. If the dBase file name is “c:\cvxe\1\locations1pts.dbf”, the DD File will be named “c:\cvxe\1\locations1pts_dd.csv”.

About the GEOID
The GEOID is a 15 character code which defines the Census 2010 census block containing each location. The GEOID is generally assigned by the ManageLocationShapefile operation and is one of the important and distinctive features of this tool. The GEOID is used to uniquely determine, with the GIS application, any of the following: state, county, census tract, block group, or census block.

The GEOID, as used in this section, is the 15 character Census 2010 geocode for the census block. The GEOID value 481130002011012 (see in location profile in map at top of section) is structured as:
state FIPS code: 48 (2 chars)
county FIPS code: 113 (3 chars)
census tract code 000201 (6 chars)
census block code: 1012 (4 chars) (block group code: 1 — first of 4 characters)

About the Source Data File
The Source Data File is an ASCII/text file structured as a CSV file. It is typically developed by exporting/saving an Excel or dBase file in CSV structure. There are several rules and guidelines for development of the source data file:
• fields must be structured and arranged as defined in the DD File.
• character fields must not contain embedded commas.
• final items in record sequence must be:
.. LATITUDE – must have accurate decimal degree value; 6 digit precision suggested.
.. LONGITUDE- must have accurate decimal degree value; 6 digit precision suggested.
.. GEOID – this may be 0, not assigned or the accurately assigned GEOID value.
– optionally create/rewrite the GEOID used in the new shapefile.

Updates; Combining Vintages of Location Attributes
Location based data might update frequently, even daily. The recommended method to add, update and extend the scope of location-based data is to create new address shapefiles corresponding to different vintages or dates covered. The structure of the files must be the same so that they files can be used together or separately. Suppose there is one set of data covering year to date and a second set of data covering the following month. The ManagePointShapefile operation would be run once for each time period. Two shapefiles would be created. These shapefiles may be added to a GIS project and used separately or in combination to view/analyze patterns.

Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

Examining Houston Metro Demographic-Economic Characteristics

.. tools & data to examine metro demographic-economic characteristics .. this Houston, TX metro focused section is one of several similar metro sections that will be covered in weeks ahead.  Each metro-focused section provides a summary of tools and data that can be used to view, rank, compare, analyze conditions and trends within the metro and this metro relative to other metros, regions and the Nation.  The ready-to-use GIS project/datasets provide the basis for extended data/geographic views and analysis immediately.  See more detail about topics covered in this related Web section.

Relating your data to demographic-economic characteristics and trends in a region involves more than information provided by a report or set of statistical tables. It is important to use your data to be able to identify areas of missed opportunity and competitive position. It is important to have a “10,000 foot” view as well as understanding individual neighborhoods and market/service areas. Geographic Information System (GIS) tools, with the right set of geographic, demographic and economic data can facilitate decision-making through the use of visual and tabular data analytics.

This section provides information on installing and using the Houston Metro Demographic-Economic GIS software and project/datasets. This same scope of data, tools and operation is available for any metro, state or combination.

10,000 Foot View
The following graphic shows patterns of median household income by census tract for the Houston metro area. This is the start-up view when using the GIS tools and data described below. The color patterns/intervals are shown in the highlighted layer in legend at left of map window. Use the GIS tools described below to develop thematic pattern maps for a range of data and criteria.

.. view developed using the CVGIS software.

See more about census tracts; see tracts main page.

Several additional views follow, developed using this same GIS project. These views illustrate different levels of geographic granularity and patterns of different subject matter.

Median Household Value by Block Group
See more about block groups; see block groups main page.

.. view developed using the CVGIS software.

Population/Housing Unit by Block
See more about census blocks; see census block main page.

.. view developed using the CVGIS software.

Zoom-in to Sugarland/Fort Bend County
See more about cities/places; see cities/places main page.
Access data for any city using interactive table.

.. view developed using the CVGIS software.

Further Zoom-in Showing Street/Road Detail
See more about streets.

.. view developed using the CVGIS software.

Additional Information
See the related Houston metro Situation & Outlook Report.

Using the GIS Software and Project/Datasets
(requires Windows computer with Internet connection)
1. Install the ProximityOne CV XE GIS
… run the CV XE GIS installer
… requires UserID; take all defaults during installation
2. Download the Houston Metro GIS project fileset
… requires UserID; unzip Houston Metro GIS project files to local new folder c:\p1data
3. Open the c:\p1data\us1_metros_houston.gis project
… after completing the above steps, click File>Open>Dialog
… open the file named c:\p1data\us1_metros_houston.gis
4. Done. The start-up view is shown above.

Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

115th Congressional Districts: Analysis and Insights

.. interpretative data analytics; tools, data & methods ..  this section is focused on 115th Congressional District geographic, demographic and economic patterns and characteristics. Use tools and data reviewed here to examine/analyze characteristics of one congressional district (CD) or a group of CDs based on state, party or other attribute. Use the GIS resources described here for general CD reference/pattern/analytical views, to examine current demographics and demographic change and for redistricting applications. See this related Web section for more details.

Examining the 115th Congressional Districts
• the 115th Congress runs from January 2017 through December 2018.
• FL, MN, NC, VA have redistricted since the 114th CD vintage;
  .. some 115th CDs have new boundaries compared the 114th CDs.
• view, rank, compare CDs using the interactive table.
  .. table uses ACS 2015 data for 115th CDs & include incumbent attributes.
  .. examine districts by party affiliation.
• use these more detailed 114th CD interactive tables
  .. data based on 2015 American Community Survey – ACS 2015.
  .. corresponding data for the 115th CDs from ACS 2016 available Sept 2017.
• use the new GIS project including 114th & 115th CDs described below.
  .. create CD thematic and reference maps;
  .. examine CDs in context of other geography & subject matter.
• join us in the April 25 Data Analytics Lab session

Visual Analysis of Congressional Districts
The following views 1) provide insights into patterns among the 115th CDs and 2) illustrate how 114th to 115th geographic change can be examined. Use CV XE GIS software with the GIS project to create and examine alternative views.

Patterns of Household Income by 115th Congressional District
The following graphic shows the patterns of the median household income by 115th Congressional District based on the American Community Survey 2015 1-year estimates (ACS2015). The legend in the lower left shows data intervals and color/pattern assignment

.. view developed with ProximityOne CV XE GIS and related GIS project.

Charlotte NC-SC Metro Area
  – with 114th/115th Congressional District 12

The following graphic shows North Carolina CD 12 with 114th boundary (blue) and 115th boundary (pale yellow) and Charlotte metro bold brown boundary. Click graphic for larger view with more detail. Expand browser window for best view.

.. view developed using the CVGIS software.

• View zoom-in to Charlotte city & Mecklenburg County.

115th Congressional District Interactive Table
Use the interactive table to examine characteristics of one congressional district (CD) or a group of CDs. The following graphic illustrates use of the interactive table. First, the party type was selected, Democratic incumbents in this example. Next, the income and educational attainment columns were selected. Third, the set of districts were sorted on median household income. It is quick and easy to determine that CA18 has the highest median household income and that the MHI is $1,139,900. Try using the table to examine districts of interest.

Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

Creating Custom School District Maps

…tools & data to map & geospatially analyze school districts. Ready-to-use state-by-state GIS projects may be downloaded enabling you to view and create custom maps almost instantly. Benefit from the power of using GIS software to perform tasks not available on Web-based mapping options. Use the latest school district and related shapefiles. See more information about using these resources in this related Web section.

Federal Revenue per Student by School District
Create views similar to the one shown below. Optionally combine layers as illstrated here by showing four Texas metros.

.. view developed with CV XE GIS and related GIS project.

Extending Reference and Analytical Possibilities

Texas by School District
Examine reference maps at the state, regional or local level. Optionally combine with roads/streets and other layers.

Patterns of Economic Prosperity by School District
Select from many ready-to-use demographic-economic subject matter items to create custom pattern views.

Drill-down — Houston Metro Area by School District
Zoom-in to a school district of interest. Set attributes of district as shown here.

County/School District
Visually examine the boundaries or school districts and counties. This view shows Harris County, TX area; select a county of interest.

Drill-down to Street Level
Add road/street and other layers. Drill-down within Fort Bend ISD, Houston metro, showing general earth surface features with streets layers. Mouse used to click on street (see pointer) and display mini-profile of street segment attributes.

Use for Analysis, Reference or in the Classroom
Schools and teachers: consider using these resources for classroom use. Familiarize students about how GIS resources can be used with a minimum of learning time and no cost. Enable students to use their own geography and adapt that learning to more general geography. See related Mapping Statistical Data ready-to-use GIS projects.

Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.