SOCIAL SECURITY (OASDI) BENEFICIARIES IN THE STATE OF FLORIDA BY ZIP CODE - 2018

Metadata:


Identification_Information:
Citation:
Citation_Information:
Originator: University of Florida GeoPlan Center
Publication_Date: 20190701
Title:
SOCIAL SECURITY (OASDI) BENEFICIARIES IN THE STATE OF FLORIDA BY ZIP CODE - 2018
Edition: 2018
Geospatial_Data_Presentation_Form: vector digital data
Series_Information:
Publication_Information:
Publication_Place: Gainesville, FL
Publisher: University of Florida GeoPlan Center
Other_Citation_Details:
State of Florida
Online_Linkage: http://www.fgdl.org/
Description:
Abstract:
This dataset represents the Social Security beneficiary population at the ZIP Code level for the State of Florida. It presents basic program data on the number and type of beneficiaries and the amount of benefits paid in each ZIP Code. It also shows the number of beneficiaries aged 65 or older.  This dataset was created using the boundaries of the 2012 Florida ZIP Code Areas (Five-Digit) polygon layer and the boundaries of the 2018 Tiger/Line ZCTA dataset
Purpose:
Serve as base information for use in GIS systems for general planning, 
analytical, and research purposes.
Supplemental_Information:
Please Note: 
Of the 1384 total Social Security zip code records in the original fl.xlsx table 
only 975 are represented in the new OASDI_2018.shp layer.  This is because 409 of the 
zip code records in the fl.xlsx table are zip codes of P.O. Box locations which are not 
represented/mapped in the statewide ZIPBND_2012.shp layer.   Additionally please beware that 
there are 23 zip code records in the OASDI_2018.shp layer that have no data available.

--------------------------------------------------------------------------------

OASDI Beneficiaries by State and ZIP Code, 2018
NOTES
This annual publication focuses on the Social Security beneficiary population people
receiving Old-Age, Survivors, and Disability Insurance (OASDI) benefits at the ZIP
Code level. It presents basic program data on the number and type of beneficiaries and
the amount of benefits paid in each state, Social Security Administration field office, and
ZIP Code. It also shows the number of men and women aged 65 or older receiving benefits.
The data include only persons whose benefits are currently payable. Those whose
benefits were withheld are excluded.
The data in this report are derived from the Master Beneficiary Record, the principal
administrative file of Social Security beneficiaries. The Social Security Detailed Office
Organization Resource System (DOORS) file was used to associate the field office data
with the ZIP Codes. Data for field offices in each state include only beneficiaries in that
state. However, some Social Security field offices serve residents of more than one
state. To obtain field office totals in these situations, it is necessary to combine data for
each state served by the field office. The data include only persons whose benefits are
currently payable. Those whose benefits were withheld are excluded.
To avoid disclosing the reason for Social Security eligibility of small groups and the
amounts of benefits received, a controlled rounding procedure was used for field office
and ZIP Code data. Data are not shown for ZIP Codes with fewer than 15 beneficiaries.
Under the controlled rounding procedure, ZIP Code data on the number of beneficiaries
shown in the table are changed according to the following formula:
1. If the number is divisible by 5 (ends in 0 or 5), then the numbers are not changed.
2. Otherwise, the number is rounded either to the next higher number divisible by 5
or the next lower number divisible by 5, in such a way that the difference between
each rounded and unrounded cell value, each rounded and unrounded row total,
and each rounded and unrounded column total is less than 5.
The dollar amounts in the tables are rounded to the nearest thousand.
Cherice Jefferies in the Office of Statistical Analysis and Support programmed and
compiled the data for this report. Staff of the Office of Dissemination edited the report
and prepared it for web publication.

Source: https://www.ssa.gov/policy/docs/statcomps/oasdi_zip/2018/oasdi_zip18.pdf
--------------------------------------------------------------------------------

Largest scale when displaying the data: 1:250,000.  

U.S. ZIP Code Areas (Five-Digit) represents five-digit ZIP Code areas 
used by the U.S. Postal Service to deliver mail more effectively. 
The first digit of a five-digit ZIP Code divides the United States into 10 
large groups of states numbered from 0 in the Northeast to 9 in the far 
West. Within these areas, each state is divided into an average of 10 
smaller geographical areas, identified by the second and third digits. 
These digits, in conjunction with the first digit, represent a sectional 
center facility or a mail processing facility area. The fourth and fifth digits 
identify a post office, station, branch or local delivery area.

The polygons identify areas where mail is delivered 
(from a city block or two to a whole rural town) within United States.
Time_Period_of_Content:
Time_Period_Information:
Single_Date/Time:
Calendar_Date: 2018
Currentness_Reference:
publication date
Status:
Progress: Complete
Maintenance_and_Update_Frequency: As needed
Spatial_Domain:
Bounding_Coordinates:
West_Bounding_Coordinate: -87.429040
East_Bounding_Coordinate: -79.872251
North_Bounding_Coordinate: 30.983191
South_Bounding_Coordinate: 24.492815
Keywords:
Theme:
Theme_Keyword_Thesaurus: NONE
Theme_Keyword: zip codes
Theme_Keyword: five-digit zip codes
Theme_Keyword: population
Theme_Keyword: Social Security
Theme_Keyword: beneficiaries
Theme_Keyword: OASDI
Theme_Keyword: Social Security beneficiary
Theme_Keyword: S.S.
Theme:
Theme_Keyword_Thesaurus: NONE
Theme_Keyword: location
Theme_Keyword: society
Theme_Keyword: economy
Theme:
Theme_Keyword_Thesaurus: ISO 19115 Topic Category
Theme_Keyword: society
Place:
Place_Keyword_Thesaurus: None
Place_Keyword: Florida
Temporal:
Temporal_Keyword_Thesaurus: None
Temporal_Keyword: 2012
Access_Constraints: NONE
Use_Constraints:
NONE
Point_of_Contact:
Contact_Information:
Contact_Organization_Primary:
Contact_Organization: Office of Statistical Analysis and Support
Contact_Person: Cherice Jefferies
Contact_Address:
Address_Type: mailing address
Address:
500 E Street, SW, 8th Floor
City: Washington
State_or_Province: DC
Postal_Code: 20254
Country: USA
Contact_Voice_Telephone: 410-965-0090
Contact_Electronic_Mail_Address: statistics@ssa.gov
Contact_Electronic_Mail_Address: Technical Support: http://www.fgdl.org/fgdlfeed.html
Contact_Electronic_Mail_Address: For FGDL Software: http://www.fgdl.org/software.html
Contact_Electronic_Mail_Address: FGDL Frequently Asked Questions: http://www.fgdl.org/fgdlfaq.html
Contact_Electronic_Mail_Address: FGDL Mailing Lists: http://www.fgdl.org/fgdl-l.html
Data_Set_Credit:
United States Postal Service, and Social Security Administration: Office of Retirement and Disability Policy: Office of Research, Evaluation, and Statistics
Native_Data_Set_Environment:
Microsoft Windows Vista Version 6.1 (Build 7601) Service Pack 1; ESRI ArcCatalog 9.3.1.4000
Cross_Reference:
Citation_Information:
Other_Citation_Details:
OASDI Beneficiaries by State and ZIP Code, 2018 (released July 2019) http://www.ssa.gov/policy/docs/statcomps/oasdi_zip/2018/index.html OASDI Beneficiaries by State and ZIP Code, 2010 http://www.ssa.gov/policy/docs/statcomps/oasdi_zip/2010/oasdi_zip10.pdf TIGER/Line Shapefile, 2018, 2010 nation, U.S., 2010 Census 5-Digit ZIP Code Tabulation Area (ZCTA5) National https://catalog.data.gov/dataset/tiger-line-shapefile-2018-2010-nation-u-s-2010-census-5-digit-zip-code-tabulation-area-zcta5-na
Back to Top
Data_Quality_Information:
Attribute_Accuracy:
Attribute_Accuracy_Report:
GeoPlan relied on the integrity of the attribute information within
the original data.
Logical_Consistency_Report:
This data is provided 'as is'. GeoPlan relied on the integrity
of the original data layer's topology
Completeness_Report:
This data is provided 'as is' by GeoPlan and is complete to our
knowledge.
Positional_Accuracy:
Horizontal_Positional_Accuracy:
Horizontal_Positional_Accuracy_Report:
This data is provided 'as is' and its horizontal positional accuracy
has not been verified by GeoPlan
Vertical_Positional_Accuracy:
Vertical_Positional_Accuracy_Report:
This data is provided 'as is' and its vertical positional accuracy
has not been verified by GeoPlan
Lineage:
Source_Information:
Source_Citation:
Citation_Information:
Series_Information:
Publication_Information:
Source_Scale_Denominator: 100000
Type_of_Source_Media: online
Source_Time_Period_of_Content:
Time_Period_Information:
Single_Date/Time:
Source_Currentness_Reference:
publication date
Source_Citation_Abbreviation:
GeoPlan
Source_Contribution:
Spatial and Attribute Information
Process_Step:
Process_Description:
The GeoPlan Center performed the following steps in order to 
create the 2018 OASDI data layer.

-Downloaded 1384 records as an xlsx from https://www.ssa.gov/policy/docs/statcomps/oasdi_zip/2018/index.html 
 and converted to csv after formatting in excel.
-Brought csv into arcmap, exported it as an DBF and joined it to FGDL layer: zipbnd_2012. 
 Of the 1384 records in the DBF, only 959 correctly joined based on ZIP. 
-This is because 425 records had zipcodes that were not standard, meaning they were PO boxes or another unique 
 form of mail storage
-To recover some of the lost data in the OASDI dbf, we were able to extract PO box zipcodes for the state of FL from 
 https://www.zip-codes.com/state/fl.asp
-Copy and pasted page with all 1472 zipcodes for FL to a excel sheet, and then deleted all "Standard" zipcodes from 
 the pile.
 This was because we already caught those using the FGDL layer: zipbnd_2012. 
-This excel sheet was then converted to a csv and exported as a DBF in arcmap, with 542 total PO box/ unique zipcodes
-We then joined these 542 records with the 2018 tiger ZCTA dataset based on the ZIP field, of the 542, 64 records 
 joined successfully based on zip. 
 This successfully gave these PO box zipcodes representative polygons.
-These 64 records were then extracted as a new polygon shapefile, which we then joined to the original OASDI 
 DBF based on ZIP. Of the 64 PO box records, 55 successfully joined to the OASDI dataset.
-Last, we merged these 55 with the 959 records that were successfully joined to the FGDL layer: zipbnd_2012, 
 making 1014 total records. 
-Added new zip field as text instead of long 
-Used .zfil() within the field calculator to add back leading zeros within the ZIP field lost in the merge

-added FGDLAQDATE based on the date the data was obtained by the GeoPlan Center
-added DESCRIPT field based on the field PO_NAME
-added UPDATE_DAY field based on the publication date of the data that was used to update the field

PLEASE NOTE:
-Upon checking the data and summarizing some fields, 16 duplicates were found. These duplicates were fixed by using 
 the merge editing tool to remove them, by merging the duplicates together, using the polygons that contained data as the 
 master. Each duplicate contained one record with data, one without. The ones without were merged into the ones with data. 
-998 total records after clean-up
-Records with no OASDI data contained values of "-99", these were all recalculated to have values of "0" instead to match 
 the format of the previous FGDL OASDI layer from 2010.
-23 records in total have no OASDI data
Source_Used_Citation_Abbreviation:
GeoPlan
Process_Date: 20190717
Process_Step:
Process_Description:
Dataset copied.
Source_Used_Citation_Abbreviation:
Server=wopr.fla-etat.org; Service=5151; User=etat; Version=SDE.DEFAULT
Process_Date: 20190728
Process_Time: 13001700
Back to Top
Spatial_Data_Organization_Information:
Direct_Spatial_Reference_Method: Vector
Point_and_Vector_Object_Information:
SDTS_Terms_Description:
SDTS_Point_and_Vector_Object_Type: G-polygon
Point_and_Vector_Object_Count: 998
Back to Top
Spatial_Reference_Information:
Horizontal_Coordinate_System_Definition:
Planar:
Map_Projection:
Map_Projection_Name: Albers Conical Equal Area
Albers_Conical_Equal_Area:
Standard_Parallel: 24.000000
Standard_Parallel: 31.500000
Longitude_of_Central_Meridian: -84.000000
Latitude_of_Projection_Origin: 24.000000
False_Easting: 400000.000000
False_Northing: 0.000000
Planar_Coordinate_Information:
Planar_Coordinate_Encoding_Method: coordinate pair
Coordinate_Representation:
Abscissa_Resolution: 0.002048
Ordinate_Resolution: 0.002048
Planar_Distance_Units: meters
Geodetic_Model:
Horizontal_Datum_Name: D_North_American_1983_HARN
Ellipsoid_Name: Geodetic Reference System 80
Semi-major_Axis: 6378137.000000
Denominator_of_Flattening_Ratio: 298.257222
Vertical_Coordinate_System_Definition:
Altitude_System_Definition:
Altitude_Resolution: 1.000000
Altitude_Encoding_Method: Explicit elevation coordinate included with horizontal coordinates
Back to Top
Entity_and_Attribute_Information:
Detailed_Description:
Entity_Type:
Entity_Type_Label: OASDI_2018
Entity_Type_Definition:
OASDI_2018.DBF
Entity_Type_Definition_Source:
GeoPlan
Attribute:
Attribute_Label: OBJECTID
Attribute_Definition:
Internal feature number.
Attribute_Definition_Source:
ESRI
Attribute_Domain_Values:
Unrepresentable_Domain:
Sequential unique whole numbers that are automatically generated.
Attribute:
Attribute_Label: Shape
Attribute_Definition:
Feature geometry.
Attribute_Definition_Source:
ESRI
Attribute_Domain_Values:
Unrepresentable_Domain:
Coordinates defining the features.
Attribute:
Attribute_Label: PO_NAME
Attribute_Definition:
The post office name.
Attribute_Definition_Source:
ESRI
Attribute:
Attribute_Label: ZIP
Attribute_Definition:
The five-digit number used by the postal service to identify an area where mail is delivered.
Attribute_Definition_Source:
ESRI
Attribute:
Attribute_Label: CA_NAME
Attribute_Definition:
The post office city alias name.
Attribute_Definition_Source:
GeoPlan
Attribute:
Attribute_Label: TOTAL
Attribute_Definition:
Total number of beneficiaries with benefits in current-payment status.  0 = Data not available.
Attribute_Definition_Source:
OASDI
Attribute:
Attribute_Label: RETIRED
Attribute_Definition:
Number of beneficiaries with benefits in current-payment status who are retired workers.  0 = Data not available.
Attribute_Definition_Source:
OASDI
Attribute:
Attribute_Label: DISABLED
Attribute_Definition:
Number of beneficiaries with benefits in current-payment status who are disabled workers.  0 = Data not available.
Attribute_Definition_Source:
OASDI
Attribute:
Attribute_Label: WPARENTS
Attribute_Definition:
Number of beneficiaries with benefits in current-payment status who are widows or widowers and parents.  0 = Data not available.
Attribute_Definition_Source:
OASDI
Attribute:
Attribute_Label: SPOUSES
Attribute_Definition:
Number of beneficiaries with benefits in current-payment status who are spouses.  0 = Data not available.
Attribute_Definition_Source:
OASDI
Attribute:
Attribute_Label: CHILDREN
Attribute_Definition:
Number of beneficiaries with benefits in current-payment status who are children.  0 = Data not available.
Attribute_Definition_Source:
OASDI
Attribute:
Attribute_Label: ALLBENSM
Attribute_Definition:
Total monthly benefits (thousands of dollars) for all beneficiaries.  0 = Data not available.
Attribute_Definition_Source:
OASDI
Attribute:
Attribute_Label: RETIREDM
Attribute_Definition:
Total monthly benefits (thousands of dollars) for retired workers.  0 = Data not available.
Attribute_Definition_Source:
OASDI
Attribute:
Attribute_Label: WPARENTSM
Attribute_Definition:
Total monthly benefits (thousands of dollars) for widows or widowers and parents.  0 = Data not available.
Attribute_Definition_Source:
OASDI
Attribute:
Attribute_Label: OVER65
Attribute_Definition:
Number of OASDI beneficiaries aged 65 or older.  0 = Data not available.
Attribute_Definition_Source:
OASDI
Attribute:
Attribute_Label: POP2010
Attribute_Definition:
The 2010 estimated population of the ZIP Code area. 0 = Data not available.
Attribute_Definition_Source:
ESRI
Attribute:
Attribute_Label: POP10_SQMI
Attribute_Definition:
The 2010 estimated population of the ZIP Code area per square mile. 0 = Data not available.
Attribute_Definition_Source:
ESRI
Attribute:
Attribute_Label: SQMI
Attribute_Definition:
The area of the ZIP Code polygon in square miles using Albers Equal Area Projection.
Attribute_Definition_Source:
ESRI
Attribute:
Attribute_Label: DESCRIPT
Attribute_Definition:
Based on PO_NAME.
Attribute_Definition_Source:
GeoPlan
Attribute:
Attribute_Label: UPDATE_DAY
Attribute_Definition:
The date the data was last updated by the Source
Attribute_Definition_Source:
GeoPlan
Attribute:
Attribute_Label: FGDLAQDATE
Attribute_Definition:
The date FGDL acquired the data from the Source.
Attribute_Definition_Source:
GeoPlan
Attribute:
Attribute_Label: AUTOID
Attribute:
Attribute_Label: SHAPE.AREA
Attribute:
Attribute_Label: SHAPE.LEN
Back to Top
Distribution_Information:
Distributor:
Contact_Information:
Contact_Organization_Primary:
Contact_Organization: Florida Geographic Data Library (FGDL)
Contact_Address:
Address_Type: mailing address
Address:
431 Architecture PO Box 115706
City: Gainesville
State_or_Province: Florida
Postal_Code: 32611-5706
Country: United States
Contact_Electronic_Mail_Address: Web site: http://www.fgdl.org
Contact_Electronic_Mail_Address: Technical Support: http://www.fgdl.org/fgdlfeed.html
Contact_Electronic_Mail_Address: For FGDL Software: http://www.fgdl.org/software.html
Contact_Electronic_Mail_Address: FGDL Frequently Asked Questions: http://www.fgdl.org/fgdlfaq.html
Contact_Electronic_Mail_Address: Mailing list for FGDL: http://www.fgdl.org/fgdl-l.html
Resource_Description: DOWNLOADABLE DATA
Distribution_Liability:
The Florida Geographic Data Library is a collection of Geospatial Data
compiled by the University of Florida GeoPlan Center with support from
the Florida Department of Transportation. GIS data available in FGDL is
collected from various state, federal, and other agencies (data sources)
who are data stewards, producers, or publishers. The data available in
FGDL may not be the most current version of the data offered by the
data source. University of Florida GeoPlan Center makes no guarantees
about the currentness of the data and suggests that data users check
with the data source to see if more recent versions of the data exist.

Furthermore, the GIS data available in the FGDL are provided 'as is'.
The University of Florida GeoPlan Center makes no warranties, guaranties
or representations as to the truth, accuracy or completeness of the data
provided by the data sources. The University of Florida GeoPlan Center
makes no representations or warranties about the quality or suitability
of the materials, either expressly or implied, including but not limited
to any implied warranties of merchantability, fitness for a particular
purpose, or non-infringement. The University of Florida GeoPlan Center
shall not be liable for any damages suffered as a result of using,
modifying, contributing or distributing the materials.

A note about data scale: 

Scale is an important factor in data usage.  Certain scale datasets
are not suitable for some project, analysis, or modeling purposes.
Please be sure you are using the best available data. 

1:24000 scale datasets are recommended for projects that are at the
county level.
1:24000 data should NOT be used for high accuracy base mapping such
as property parcel boundaries.
1:100000 scale datasets are recommended for projects that are at the
multi-county or regional level.
1:125000 scale datasets are recommended for projects that are at the
regional or state level or larger.

Vector datasets with no defined scale or accuracy should be
considered suspect. Make sure you are familiar with your data
before using it for projects or analysis. Every effort has been
made to supply the user with data documentation. For additional
information, see the References section and the Data Source Contact
section of this documentation. For more information regarding
scale and accuracy, see our webpage at:
http://geoplan.ufl.edu/education.html
Standard_Order_Process:
Digital_Form:
Digital_Transfer_Information:
Transfer_Size: 4.896
Technical_Prerequisites:
This data is intended for use with a Geographic Information Systems or Remote Sensing software package.
Back to Top
Metadata_Reference_Information:
Metadata_Date: 20190728
Metadata_Contact:
Contact_Information:
Contact_Organization_Primary:
Contact_Organization: University of Florida GeoPlan Center
Contact_Address:
Address_Type: mailing address
Address:
431 Architecture PO Box 115706
City: Gainesville
State_or_Province: FL
Postal_Code: 32611-5706
Country: USA
Contact_Electronic_Mail_Address: data@fgdl.org
Contact Instructions:
website: www.fgdl.org
Metadata_Standard_Name: FGDC Content Standards for Digital Geospatial Metadata
Metadata_Standard_Version: FGDC-STD-001-1998
Metadata_Time_Convention: local time
Metadata_Extensions:
Online_Linkage: http://www.esri.com/metadata/esriprof80.html
Profile_Name: ESRI Metadata Profile
Back to Top