Abstract

A crosswalk matching US ZIP codes to corresponding CBSA (core-based statistical area)

Documentation

The denominators used to calculate the address ratios are the ZIP code totals. When a ZIP is split by any of the other geographies, that ZIP code is duplicated in the crosswalk file.

**Example: **ZIP code 03870 is split by two different Census tracts, 33015066000 and 33015071000, which appear in the tract column. The ratio of residential addresses in the first ZIP-Tract record to the total number of residential addresses in the ZIP code is .0042 (.42%). The remaining residential addresses in that ZIP (99.58%) fall into the second ZIP-Tract record.

So, for example, if one wanted to allocate data from ZIP code 03870 to each Census tract located in that ZIP code, one would multiply the number of observations in the ZIP code by the residential ratio for each tract associated with that ZIP code.

https://redivis.com/fileUploads/4ecb405e-f533-4a5b-8286-11e56bb93368%3E" alt="">(Note that the sum of each ratio column for each distinct ZIP code may not always equal 1.00 (or 100%) due to rounding issues.)

CBSA definition

A core-based statistical area (CBSA) is a U.S. geographic area defined by the Office of Management and Budget (OMB) that consists of one or more counties (or equivalents) anchored by an urban center of at least 10,000 people plus adjacent counties that are socioeconomically tied to the urban center by commuting. Areas defined on the basis of these standards applied to Census 2000 data were announced by OMB in June 2003. These standards are used to replace the definitions of metropolitan areas that were defined in 1990. The OMB released new standards based on the 2010 Census on July 15, 2015.

Further reading

The following article demonstrates how to more effectively use the U.S. Department of Housing and Urban Development (HUD) United States Postal Service ZIP Code Crosswalk Files when working with disparate geographies.

Wilson, Ron and Din, Alexander, 2018. “Understanding and Enhancing the U.S. Department of Housing and Urban Development’s ZIP Code Crosswalk Files,” Cityscape: A Journal of Policy Development and Research, Volume 20 Number 2, 277 – 294. URL: https://www.huduser.gov/portal/periodicals/cityscpe/vol20num2/ch16.pdf

Contact authors

Questions regarding these crosswalk files can be directed to Alex Din with the subject line HUD-Crosswalks.

Acknowledgement

This dataset is taken from the U.S. Department of Housing and Urban Development (HUD) office: https://www.huduser.gov/portal/datasets/usps_crosswalk.html#codebook

The TIGER/Line shapefiles and related database files (.dbf) are an extract of selected geographic and cartographic information from the U.S. Census Bureau's Master Address File / Topologically Integrated Geographic Encoding and Referencing (MAF/TIGER) Database (MTDB). The MTDB represents a seamless national file with no overlaps or gaps between parts, however, each TIGER/Line shapefile is designed to stand alone as an independent data set, or they can be combined to cover the entire nation. Metropolitan and Micropolitan Statistical Areas are together termed Core Based Statistical Areas (CBSAs) and are defined by the Office of Management and Budget (OMB) and consist of the county or counties or equivalent entities associated with at least one urban core (urbanized area or urban cluster) of at least 10,000 population, plus adjacent counties having a high degree of social and economic integration with the core as measured through commuting ties with the counties containing the core. Categories of CBSAs are: Metropolitan Statistical Areas, based on urbanized areas of 50,000 or more population; and Micropolitan Statistical Areas, based on urban clusters of at least 10,000 population but less than 50,000 population. The CBSA boundaries are those defined by OMB based on the 2010 Census, published in 2013, and updated in 2018.

NAME: MSA2010tiger DESCRIPTION: Major Statistical Areas (derived from raw 2010 TIGER census tracts) FEATURE TYPE: Polygon EXTENT: San Diego region DATE OF DATA: 2010 NUMBER OF RECORDS: 7 MAPPING SOURCE: SANDAG; U.S. Department of Commerce, U.S. Census Bureau, Geography Division, TIGER/Line Shapefile Notes: The TIGER/Line Files are shapefiles and related database files (.dbf) that are an extract of selected geographic and cartographic information from the U.S. Census Bureau's Master Address File / Topologically Integrated Geographic Encoding and Referencing (MAF/TIGER) Database (MTDB). Census Tracts nest within Subregional Areas (SRAs) which nest within Major Statistical Areas (MSAs). There are only minor differences between the 1980, 1990, 2000, and 2010 SRA and MSA boundaries due to some census tract boundary realignments. Original TIGER Shapefiles can be obtained at http://www.census.gov/geo/www/tiger Code Documentation: Attribute Description MSA Major Statistical Area Code NAME Major Statistical Area Name MSA Name 0 Central 1 North City 2 South Suburban 3 East Suburban 4 North County West 5 North County East 6 East County Last revised: March 2011

TIGER road data for the MSA. When compared to high-resolution imagery and other transportation datasets positional inaccuracies were observed. As a result caution should be taken when using this dataset. TIGER, TIGER/Line, and Census TIGER are registered trademarks of the U.S. Census Bureau. ZCTA is a trademark of the U.S. Census Bureau. The Census 2000 TIGER/Line files are an extract of selected geographic and cartographic information from the Census TIGER data base. The geographic coverage for a single TIGER/Line file is a county or statistical equivalent entity, with the coverage area based on January 1, 2000 legal boundaries. A complete set of census 2000 TIGER/Line files includes all counties and statistically equivalent entities in the United States, Puerto Rico, and the Island Areas. The Census TIGER data base represents a seamless national file with no overlaps or gaps between parts. However, each county-based TIGER/Line file is designed to stand alone as an independent data set or the files can be combined to cover the whole Nation. The Census 2000 TIGER/Line files consist of line segments representing physical features and governmental and statistical boundaries. The boundary information in the TIGER/Line files are for statistical data collection and tabulation purposes only; their depiction and designation for statistical purposes does not constitute a determination of jurisdictional authority or rights of ownership or entitlement. The Census 2000 TIGER/Line files do NOT contain the Census 2000 urban areas which have not yet been delineated. The files contain information distributed over a series of record types for the spatial objects of a county. There are 17 record types, including the basic data record, the shape coordinate points, and geographic codes that can be used with appropriate software to prepare maps. Other geographic information contained in the files includes attributes such as feature identifiers/census feature class codes (CFCC) used to differentiate feature types, address ranges and ZIP Codes, codes for legal and statistical entities, latitude/longitude coordinates of linear and point features, landmark point features, area landmarks, key geographic features, and area boundaries. The Census 2000 TIGER/Line data dictionary contains a complete list of all the fields in the 17 record types. This is part of a collection of 221 Baltimore Ecosystem Study metadata records that point to a geodatabase. The geodatabase is available online and is considerably large. Upon request, and under certain arrangements, it can be shipped on media, such as a usb hard drive. The geodatabase is roughly 51.4 Gb in size, consisting of 4,914 files in 160 folders. Although this metadata record and the others like it are not rich with attributes, it is nonetheless made available because the data that it represents could be indeed useful. This is part of a collection of 221 Baltimore Ecosystem Study metadata records that point to a geodatabase. The geodatabase is available online and is considerably large. Upon request, and under certain arrangements, it can be shipped on media, such as a usb hard drive. The geodatabase is roughly 51.4 Gb in size, consisting of 4,914 files in 160 folders. Although this metadata record and the others like it are not rich with attributes, it is nonetheless made available because the data that it represents could be indeed useful.

The Bureau of the Census has released Census 2000 Summary File 1 (SF1) 100-Percent data. The file includes the following population items: sex, age, race, Hispanic or Latino origin, household relationship, and household and family characteristics. Housing items include occupancy status and tenure (whether the unit is owner or renter occupied). SF1 does not include information on incomes, poverty status, overcrowded housing or age of housing. These topics will be covered in Summary File 3. Data are available for states, counties, county subdivisions, places, census tracts, block groups, and, where applicable, American Indian and Alaskan Native Areas and Hawaiian Home Lands. The SF1 data are available on the Bureau's web site and may be retrieved from American FactFinder as tables, lists, or maps. Users may also download a set of compressed ASCII files for each state via the Bureau's FTP server. There are over 8000 data items available for each geographic area. The full listing of these data items is available here as a downloadable compressed data base file named TABLES.ZIP. The uncompressed is in FoxPro data base file (dbf) format and may be imported to ACCESS, EXCEL, and other software formats. While all of this information is useful, the Office of Community Planning and Development has downloaded selected information for all states and areas and is making this information available on the CPD web pages. The tables and data items selected are those items used in the CDBG and HOME allocation formulas plus topics most pertinent to the Comprehensive Housing Affordability Strategy (CHAS), the Consolidated Plan, and similar overall economic and community development plans. The information is contained in five compressed (zipped) dbf tables for each state. When uncompressed the tables are ready for use with FoxPro and they can be imported into ACCESS, EXCEL, and other spreadsheet, GIS and database software. The data are at the block group summary level. The first two characters of the file name are the state abbreviation. The next two letters are BG for block group. Each record is labeled with the code and name of the city and county in which it is located so that the data can be summarized to higher-level geography. The last part of the file name describes the contents . The GEO file contains standard Census Bureau geographic identifiers for each block group, such as the metropolitan area code and congressional district code. The only data included in this table is total population and total housing units. POP1 and POP2 contain selected population variables and selected housing items are in the HU file. The MA05 table data is only for use by State CDBG grantees for the reporting of the racial composition of beneficiaries of Area Benefit activities. The complete package for a state consists of the dictionary file named TABLES, and the five data files for the state. The logical record number (LOGRECNO) links the records across tables.

The tables and interactive maps below allow users to explore the ratio of debt to income by state, metropolitan statistical area, and county for each year since 1999. Household debt is calculated from Federal Reserve Bank of New York (FRBNY) Consumer Credit Panel/Equifax Data, and household income is reported by the Bureau of Labor Statistics.

Vehicle population is updated annually, each April, to reflect the number of vehicles “on the road” during the previous calendar year. Vehicle population counts vehicles whose registration is either current or less than 35 days expired. Sales are higher than population because of vehicle retirements, accidents, owners moving out of state, or other reasons.

Data as of: December 31, 2022

Regional Data Categories Map Filter. Data can be reflected at the county, metropolitan statistical area (MSA), or ZIP code level. Individual registrations were assigned to a region based on mailing address, with the following exceptions:

Out of State: vehicles registered in California with a mailing address in a different state

ZIP Code “99999”: indicates that the ZIP code in the Vehicle Registration database was invalid

Unassigned: remote areas not associated with an MSA

Unknown: Invalid ZIP codes categorized under MSA

This Data contains information from 2010 to 2022.

Please note, that columns 'Manufacturer' and 'Model' include Null values since it was less data in 2010-2012 and more data from 2013.

Examples of Questions you may answer with this Data:

• What is the trend in the number of Battery Electric Vehicles (BEVs) in California from 2010 to 2022?
• How has the adoption of Gasoline vehicles changed over the years in California, specifically for Flex Fuel?
• Which county in California had the highest number of Diesel vehicles in 2010?
• What is the distribution of Gasoline Hybrid vehicles across California counties in 2020?
• How many Natural Gas vehicles were registered in California in 2010, and did this number change significantly by 2020?
• Which car manufacturer produced the most Battery Electric Vehicles (BEVs) in California in 2015?
• What is the overall trend in the number of Zero Emission Vehicles (ZEVs) in California over the past decade?
• What is the average number of vehicles per make and model for all Fuel Types in 2019 in California?
• How has the market share of Battery Electric Vehicles (BEVs) compared to Gasoline vehicles evolved over the years in California?

Columns: Data Year
County
Dashboard Fuel Type Group
Fuel Type
Manufacturer
Model
Number of Vehicles

Schema: Patent No (x) Inventor Name (y) Inventor Last Name (before the semicolon) Inventor First Name + Middle Name (after the semicolon) Original Sequence of (y) in (x) Disambiguated Inventor ID X,XXX,XXX-Y, where X,XXX,XXX is the very first patent of that inventor and Y is the order of appearance of that inventor in X,XXX,XXX City State Country County name IF IN USA FIPS 5-digit (state + city combined) IF IN USA FIPS 2-digit (state code) IF IN USA FIPS 3-digit (city code) IF IN USA Latitude disambiguated Longitude disambiguated Zipcode IF IN USA Metropolitan statistical area (MSA) IF IN USA Assignee PDPASS Data source: Latitude, longitude: Google MAP API County and FIPS code: US Census Zipcode and ZCTA translation: USPS MSA: US Department of Labor Assignee PDPASS: based on NBER 1976-2006, expanded by way of KNN

Each county or statistically equivalent entity is assigned a 3-character FIPS code that is unique within a state, as well as an 8-character National Standard (GNIS) code.The 2018 TIGER/Line Shapefiles reflect available governmental unit boundaries of the counties and equivalent entities as of January 1, 2018.Core-based Statistical Area (CBSA) Codes – The 2018 county and equivalent entity shapefiles also contain fields with codes for combined statistical area, metropolitan or micropolitan statistical area, and metropolitan division. Counties form the building blocks for CBSAs, and a user can merge county records to form these areas without having to acquire the individual CBSA shapefiles.