Wednesday, July 30, 2014
In developing our products we have created a number of important tools and weighting tables. We can therefore create many different custom-designed solutions for your demographic data and geographic data needs that go beyond the capabilities of our standard products. Sometimes we use these tools to manipulate the data extracted from our products to better suit your particular needs and sometimes it is to create something that cannot be done with our products alone.
Below is a list of the reports and services we provide. To get more details about any of these projects or if you have other data needs please call us at 800-577-6717 to discuss your requirements with us.
Custom Reports - We regularly run custom reports for individuals and agencies providing just the variables needed for the area specified. Sometimes it is a site selection radius around a potential location that a customer is thinking of developing and needs to know how many people there are within 3 miles and what their income levels are. Other times it is information about ethnic breakouts by tracts across a state or the country at large. These are generally run right out of our products and are usually purchased by groups that do not need the complete software for the target marketing. These customers generally only need one set of answers and a custom report is a quicker and simpler solution. Reports start at $150.
Area Segmentation - We can create a specific weighting file to determine which parts of an area qualify using your agency specifications. You tell us what your target audience has as its characteristics and we will rank order the entire area by how well it correlates with your target market research.
For example, we created a weighting file for a state government agency that needed to determine which Block Groups in their state met the mandated definition of "Distressed Block Groups". In their state to be "distressed" it had to meet at least 5 of 8 indicators (high unemployment, low high school graduation rates, high child poverty rates, high senior poverty rates, high single-mother with children in poverty rates, low per capita income, high percentage of minorities, high percentage of multiple people sharing living limited space). This file will then be used to determine which block groups are distressed and the level of distress. The government agency will then use this as the method for determining where to invest in programs, where to offer additional resources, and what areas qualify for different funding sources. We can custom tailor the variables used and the cut-offs to meet whatever your agency or state needs require. The pricing for this sort of project is about $2,500 depending upon the constraints.
Area-to-Area Correspondence File
Different groups will have different specific needs so we have built in flexibility with this program. There are two sets of selections so as to best meet your needs: Dominant area vs. All available and Weighting by Population vs. Land area.
Dominant area vs. All available
Weighting by Population vs. Land Area
Below is a map of Middlesex County NJ. The gray area is the county line, superimposed over it are the zip code boundaries. As you can see in the blown-up version on the right, zip code 08540 has a small corner that is within the county lines, but most of it is outside the county. Likewise, most of 08512 is within the county, but not all of. If you do this manually than the questions is "what proportion of the population in 08540 do you attribute to Middlesex County and what proportion of 08512 do you subtract?"
The layering of maps creates a weighting by land area. For example, in a downtown business area where there are very few residents, weighting by population may not be as desirable. If on the other hand you want to weigh areas that are populated, then the way to normalize it more precisely is to look at where the people are located as a way of determining how to allocate the percentage coverage.
We can create a correspondence between any two geographic areas in 2000. So for example we could tell you zip codes in an MSA or tracts in a Place, etc. These reports start at $350.
The methodology for creating these reports is available (click here for more information).
Banking/Realtor Tract Level Data and Maps
Geocoding Services -
Geocoding takes an entire database of addresses and assigns the appropriate latitude/longitude coordinate to each address. It then assigns the Census Block for that coordinate. Our GeocodeDVD goes one step further. We can now assign the 1970 Census Tract, the 1980 Census Tract and Block Group, and the 1990 Census Block Group. So if you need to append historic census data to your address list, we can run your list and append these older census year tract and block group coordinates for you. As a default we will append to each address up to 60+ demographic variables based on the 2000 Census Long Form. For an additional fee we can also append the latest current year demographic estimates and 5-year projections to each address.
Custom-built Databases / Full Product Development
Housing and Urban Development (HUD)
During this project it was necessary for GeoLytics to import, clean, validate and then process the original data. The data was then converted into a proprietary compressed format. The final product has a menu-driven interface that allows the user to form his/her own queries and thus create his/her own custom set of data from these tables. To make the reporting more powerful we also added a mapping component that displays the various geographic levels.
National Economic Research Associates (NERA)
NERA was working with a client's database file of nearly 300,000 records that contained data at the 1990 Block Group level. In order to do the required analysis they needed the 1990 Block Group data normalized to 2000 Block Group definitions. And then they needed 2000 Block Group data appended to each record in the database file. In just a few days we were able to give them the exact data set that they needed appended to the existing file so that they could continue their analysis.
For example, we have achieved the following compression results:
The compressed data is easy to access with built-in utilities and library functions. Our compression utility designed for dBase files can also be modified for any database format. Additionally, we have an ArcGIS shape file compression utility that can be modified for any spatial data where the format is available.
Our compression technology has been incorporated into ESRI's Arcview Business Analyst. We were employed by ESRI to compress several large sets of data (Population Estimates, Population Projections, Dun & Bradstreet's Business Reports database, along with a database of consumer expenditures for over 90 million households). All of these, and the boundaries, were compressed onto two disks (the requirements from ESRI). With compression, not only was it easier for the user to manage the datasets, but because of our technology the user was able to access the data much faster - without having to uncompress it.
The capacity and speed of this technology is also showcased in all of our CensusCD products. Pricing for data compression varies according to the size and type of data to be compressed. Please contact us for further information and pricing.
Normalizing Data - Weighing data from one time period to another
Our product Neighborhood Change Database uses tract level data and normalizes a subset of 1970-1980-1990 data to the 2000 boundaries. We also have created the CensusCD 1990 Long Form in 2000 Boundaries, which gives you access to all of the 1990 Long Form data in all of the 2000 Long Form boundaries.
We can supply you with normalized data from our data sets. If your methodology does not conform to either product listed above, we can custom tailor the variables you want to the geographic boundaries that meet your specific needs. In developing the weighting tables for these two products, we also developed the ability to weight a file in the opposite direction. Whereby you can take a file of 2000 data and geographies and weigh it back to the earlier boundaries. We can also weight data from 1970 or 1980 to the 2000 tract boundaries for variables that were not included in the NCDB. So for example, if you want age breakouts and they are not in the NCDB we can do that as a custom weighting report.
We can normalize your existing data. Sometimes you will already have a dataset that has either census boundary definitions or addresses that need to be updated to the 2000 definitions. We can take your dataset and normalize it using our weighting tables and return to you the new, normalized data based on the new geographic boundary definitions.
Weighting analysis projects begin at $1,000. It may cost more if multiple time periods are involved or if the geographic level is not one for which we have already generated the weighting table.
Methodology for Area Correspondence
This procedure can be done with the purchase of our CensusCD 2000 Short Form Blocks or Redistricting Blocks. As a warning, however, it is very time consuming and difficult to manipulate a data set of 8.2 million Blocks and should not be entered into lightly.