Service Efforts and Accomplishments (SEA) Reporting
====================================================

Files available to download that are named "sea...."
are files from the City of Portland, or Multnomah County,
Service Efforts and Accomplishments (SEA) annual performance
measurement reporting.  The file name indicates if the file
is from the City or from the County, and also indicates the
year.

Part of the SEA performance measurement process done by
both the City and the County involves a survey of citizens.
The data from these citizen surveys are the SEA data
available on my web site.  These are interesting data files
that can work excellently for student course projects.

The City has been doing SEA reporting since 1991. For the
SEA citizen survey the City uses a mail questionnaire and
sends out about 10,000 questionnaires, and gets about
5,000 returned.

For several years the City SEA survey uses a sample of
not just City residents, but also residents of unincorporated
areas and the City of Gresham.  For those years the SPSS
file includes a variable "city", which indicates if the
respondent is from the City of Portland, City of Gresham,
or unincorporated Multnomah County.  In SPSS look under
Utilities/Variables to see if there is a variable named
"city".  If so, and if in your analysis you only want to
use residents from Portland, then in SPSS use the
Data/Select_Cases command to set a condition to select
cases only if the condition is satisfied that "city=1".
Make sure you use the "city" variable for this purpose
and not the "part" variable.  The part variable indicates
which part of the county the respondent lives in, but
since it is based on a survey question it has some missing
data, unlike the "city" variable which was created based
on the respondent's address and has no missing data.

The County has been doing SEA reporting since 2000, and
has used both mail questionnaires and telephone interview
surveys for the citizen survey part of the SEA data collection.
The 2001 County survey data file (seaCounty2001.sav) is from a
telephone survey with a sample size of 1526 completed interviews.

The SPSS files have good variable and value labeling, so
should be easy to understand.  For more information about
the citizen surveys see the SEA reports, and also any other
documentation files I have on-line for downloading.

There are 5 types of files available for downloading:

***

1)Files for the SEA reports
(pdf files)

You can also get hard copies of the City
reports from the Audit Services Division,
City of Portland, and the County reports
from the County Auditor's Office

***

2)Data files for the citizen surveys
(sav files)

These are SPSS files.

***

3)Data files for the citizen surveys
in compressed format (zip files)

These are just the sav data files compressed into
zip format for faster downloading and smaller
file size.  The file "seaCity1999sav.zip", for example
is a compressed version of the file "seaCity1999.sav".

***

4)sea1991-98sav.zip file
This is a compressed (zip) file containing
the SPSS (sav) data files for the City citizen
surveys from 1991-1998.

***

5)Files giving additional information
These are word processing (DOC) or text (TXT) files.
Read them.  The file "seaCounty2001.doc", for example,
gives additional information about the data file
"seaCounty2001.sav".