Puget Sound Regional Council Employment Database SANDAG COG MPO

Puget Sound Regional Council Employment Database SANDAG COG/MPO Conference August 11, 2006 Kevin Murphy: kmurphy@psrc.org Kristen Koch: kkoch@psrc.org Presentation Overview About PSRC History of employment data Mandates and Interagency Agreement Methodology Supplements to the data set Uses and Products produced About PSRC Who we are An association of cities, towns, counties, ports, and state agencies Serves as a forum for developing policies and making decisions about regional growth and transportation issues Central Puget Sound Region In the Region: - 4 Counties - 82 Cities and Towns - Hundreds of Special Districts Regional Population and Employment Key Responsibilities Long range growth, economic and transportation planning Transportation funding Economic development coordination Regional data Forum for regional issues Decision Making Employment Data History, Mandates and Interagency Agreement History Pre-1988: Mix and match information 1988: Started working with ES-202 data - Printed out summary report Estimates by Tract and City (suppressed) Only use was for refining trip tables 1990-1994: More specific levels of geography Could obtain some records for more in-depth analysis 1995 to Present: Current arrangement business location level database for geocoding Since 1997, database processed annually History cont. 2002: Re-geocoded 1995 data to make consistent 1995-2000: Standard Industrial Classification Coding (SIC) 2001-2002: Dual coding, SIC and North American Industry Classification System (NAICS) 2003 forward: NAICS only In 2004: 1995, 2000 and 2001 databases updated with NAICS coding Mandates MPO Federal Requirements RTPO State Requirements PSRC enabling Interagency Agreement Agency Goals: -Deliver high quality data, analysis, reports and other products to meet regional and member needs. -Meet our state and federal mandates. Interagency Agreement: ESD and PSRC Relationship between ESD and PSRC vastly improved since 1995 Cooperative workflow -ESD geocodes and provides revised data -Final PSRC back to ESD Safeguard confidential data Limited data dissemination -Member Jurisdictions -Certain fields only -Confidentiality and suppression issues Interagency Agreement: Restrictions on use Confidentiality – Require reviewers and users of database to sign agreement – – – – Geocoding accuracy Travel demand modeling Growth Management Act (GMA) analysis Economic analysis Suppression – Publication rules to prevent individual employers from being identified Interagency Agreement: Suppression Rules To prevent revealing individual employer’s information, total is hidden when: – – – One employer accounts for 80% or more of total employment There are less than 3 employers If showing totals, suppression of one value means one other must be suppressed ESD Confidentiality Agreements WASHINGTON STATE EMPLOYMENT SECURITY DEPARTMENT NOTICE OF NONDISCLOSURE As a non-Employment Security Department (ESD) employee, you may be given access to records or information that is deemed private and confidential by statute. You may not make any unauthorized disclosure of private or confidential information about employers, clients/claimants or employees to any person or entity. Confidential information includes but is not limited to employee’s wages or hours, unemployment insurance benefit records, and standard industrial classification (SIC) codes or North American Industry Coding System (NAICS) of individual employers. The unauthorized disclosure or abuse of information deemed private and confidential may subject you to a civil penalty of Five Thousand dollars ($5,000) and other applicable sanctions under state and federal law. (RCW 50.13) I have read and understand the above Notice of Nondisclosure. ____________________________________________ Printed Name _____________________________________________ Signature Date The above individual has been informed of the obligations of the above referenced agreement and Statement of Work including any limitations, use or publishing of Confidential Data. _____________________________________________ Printed Name ____________________________________________ Signature Date Puget Sound Regional Council Agreement to Release Information 1) The undersigned Requesting Entity has requested information or records that are deemed private and confidential by the Washington State Employment Security Department (ESD). 2) In order to receive such information, Requesting Entity agrees that certain safeguards must be followed in order to maintain the confidentiality of the data. Access to the information must be restricted to only those authorized personnel or agents. By signing this document, you, the Requesting Entity, agree that you shall take precautions to ensure that only authorized personnel or agents are given access to the data set provided. The information must be stored in an area that is safe from access by unauthorized persons during duty hours as well as non-duty hours, or when not in use and has to be protected in a manner, which prevents unauthorized persons from retrieving the information by computer, remote terminal or other means. 3) The Requesting Entity agrees to only use the data for authorized purposes. These purposes include verification of the point level data and activities required under mandated growth management requirements, including economic impact analysis and transportation impacts on employment trends. 4) The information provided will remain the property of ESD and will not be duplicated or disclosed without the written authority of ESD. The Requesting Entity shall protect the confidentiality of the information. 5) The Requesting Entity agrees to and shall indemnify, hold harmless and defend PSRC, its members, officers, agents and employees from and against all claims, losses or liability of whatever nature related to any unauthorized disclosure or abuse of information by Requesting Entity under this agreement. 6) The Requesting Entity agrees to notify the PSRC in writing within five(5) working days of becoming aware of any unauthorized access, use, or disclosure of the information. ESD Data Sharing Notice We may share the information you provide on your tax and wage reports for the purpose of labor market information and economic analysis. Labor market information is used in studies for the legislature and by state programs. The information may be used to make decisions about growth management, community development, export assistance, energy, transportation, agriculture, employment, social services and the environment. Unemployment information is also used for fraud detection, criminal investigations, compliance and licensing requirements. When sharing information with other organizations, we summarize all confidential information to ensure that no individual information can be identified. The aggregate information we share may include your: Business name Business address Number of employees Employee hours and wages ES-202 Database Overview Also called Quarterly Census of Employment and Wages (QCEW) Derived from quarterly unemployment insurance forms businesses must file with ESD Generally represents 85 to 90% of total employment Represents the number of covered workers who worked during, or received pay for, the pay period including the 12th of the month Excludes: Enlisted Military, Self-Employed, Proprietors, Domestic workers, unpaid Family workers, and Railroad workers covered by railroad unemployment insurance system 1 year lag on receiving data Size of 2005 Database Area Tot # of Records 73,155 6,058 18,889 15,780 113,882 After Processing Geocoded King Kitsap Pierce Snoh. TOT 65,090 5,492 17,488 15,302 103,372 54,491 5,059 16,264 14,572 90,386 Methodology Database processing Geocoding method Supplements to the database Quality control Creating factors for estimates Limitations of the data set Database Processing 1 Access Database Receive single file from ESD Includes information on: -Unique 10 digit account/serial number -Name of employer -Address -Number of employees (March used) -Wages paid during quarter -6 Digit NAICS Database Processing 2 Split out private records from public Records removed before geocoding – – – – – Not in the region Temporary agencies (private) Multiple locations (private) Boeing (private) Records with zero jobs Factoring process for records with jobs in Jan and Feb Zero jobs records – Standardize addresses Split records into appropriate counties by FIPS code Database Processing 3 Pull x,y coordinate parcel matches from previous year Records with incomplete or no address Remaining records are run through geocoding process Export data by city for geocoding Geocoding 1 Match automatically to: -Parcel -Street Centerline Remaining records: -Manual matching County assessor files Yahoo yellow pages Superpages Geocoding 2 ArcGIS Geocoding Services Geocoding 3 Supplements to the Database Business and address research Boeing records – By building locations By school locations Every 2 to 3 years Office of Superintendent data – Government Survey – Government Survey Area Records from ESD 401 104 179 204 888 Geocoded King Kitsap Pierce Snoh. TOTAL 1,503 259 601 561 2924 Major limitation: Employers reporting all jobs to one location 2006 survey conducted in-house with interns Collect information on additional locations and jobs Used to allocate ESD reported jobs Improvements & Quality Control Supplements Research businesses to find missing addresses Parcel database of known matches Check records of major employers Send out for Jurisdiction review Creating Factors Geocoded Covered Control to match what ESD officially reports Subdivided by county/NAICS sector totals ESD Reported Jobs Const/Res 59,186 FIRE 73,855 Manufacturing 104,025 Retail 109,197 Services 491,132 WTU 103,438 Education 69,364 Government 82,888 PSRC Geocoded Jobs Const/Res 54,718 FIRE 70,898 Manufacturing 67,196 Retail 105,794 Services 448,493 WTU 95,274 Education 68,747 Government 82,789 Factors Const/Res 1.082 FIRE 1.042 Manufacturing 1.026 Retail 1.032 Services 1.095 WTU 1.086 Education 1.009 Government 1.001 92.5% 96.0% 97.4% 96.9% 91.3% 92.1% 99.1% 99.9% NAICS Sectors Major Industrial Sector Groupings: – – – – – – – – Construction Resources: 11, 21, 23 Finance, Insurance and Real Estate: 52, 53 Manufacturing: 31-33 Retail: 44, 45 Services: 51, 54-56, 61, 62, 71, 72, 81 Wholesale Trade, Transportation and Utilities: 22, 42, 48, 49 Education Government Calculating Estimates Add geographies based on where record is geocoded Run the sum of jobs, count of employers and max # of jobs by geography/sector Test for suppression than 3 employers –Employer accounts for 80% or more of jobs =IF(count=0,0,IF(count<3,”*”,IF(Max>=0.8*jobs, “*”, jobs))) –Less Example of Suppression Sum of Jobs FIRE Manuf. Retail Jur. 1 1,065 75 45 Jur. 2 335 450 451 Tot 1,400 525 496 Total 1,185 1,236 2,421 Count of Employers FIRE Manuf. Retail Total 120 5 2 127 32 11 55 98 152 16 57 225 Suppressed Results FIRE Manuf. Retail Total 1,065 75 * 1,185 335 * 451 1,236 1,400 525 496 2,421 Max of jobs FIRE Manuf. Retail Max Jur. 1 210 22 23 210 Jur. 2 125 390 87 390 Tot 210 390 87 390 Example of Suppression: Final FIRE Jur. 1 1,065 Jur. 2 335 Tot 1,400 Sum of Jobs Manuf. Retail 75 45 450 451 525 496 Total 1,185 1,236 2,421 Count of Employers FIRE Manuf. Retail Total 120 5 2 127 32 11 55 98 152 16 57 225 Suppressed Results FIRE Manuf. Retail Total 1,065 * * 1,185 335 * * 1,236 1,400 525 496 2,421 FIRE Jur. 1 210 Jur. 2 125 Tot 210 Max of jobs Manuf. Retail Max 22 23 210 390 87 390 390 87 390 Final Estimates Example Limitations of the Data Set Missing, invalid or incomplete addresses Businesses reporting all jobs to one location ES-202 may include off-site employment Geocoding accuracy, especially for small geographies Potential missing employers ESD’s Official Estimates Main Uses of the Data Base year data for travel demand modeling Incorporated into Small Area Forecasts Input for UrbanSim Growth monitoring Planning Studies Centers Analysis Corridor Planning Industry-specific economic analysis Website Data: www.psrc.org Different Employment Databases Geocoded ES-202 Records Point Level Wage & Salary Employment – Input to Total Employment Sampling of ES202 records, producing more current data Covered Employment City, County, Tracts, Zones – Sum to County Level Total Employment Estimates of Non-Covered jobs added to Covered “UrbanSim” Employment Doesn’t add up exactly with Modeling Employment “Modeling” Employment Adjustments for land use / travel models, ie PSNS, Res/Con, UW… Questions? Contact information: Kevin Murphy, Director, Data Systems and Analysis 206-464-6411 kmurphy@psrc.org Kristen Koch, Senior Planner 206-587-5667 kkoch@psrc.org