Form Dr-700012 - Application For Certification Of Communications Services Database (Page 2 of 3) in pdf

DR-700012

Instructions for Preparing and Submitting Customer

R. 10/13

Address Files for Certification Testing

Page 2

Required Address Data File Layout

• Include a sequential counter (starting from 1) for each record.

The address data file must:

• Be a comma delimited (.csv) file.

• Contain commas as field separators.

• Contain only Florida service addresses as defined by

• Have only one record per row.

s. 202.11(14), F.S.

• Not exceed a maximum record length of 172 characters.

• Include all service address records for the entire geographic

area covered by the database being tested.

Sample Record Layout

• Be organized by individual customer address records (not by

Examples of the record layout are provided below:

address range).

1,ABC Phone Co,1801,,ROSE MALLOW,LN,,,,

Records within the address data file must:

ORANGE PARK,FL,32003,7067,12,019,000000000

• Be standardized using United States Postal Service addressing

3,,300,,BRAUGHTON,ST,SE,,,

standards.

BRANFORD,FL,32008,,12,121,002405314

• Provide mail city name (the name of the post office that

supports the mail delivery area covered by that customer

229,ABC Communications,1200,E,GILFORD DAVIS,RD,,,,

address).

GLEN ST MARY,FL,32040,4604,12,003,000000000

Record Header Information

FIELD NAME

MAXIMUM

REQUIREMENTS

REQUIRED

COMMENTS

CHARACTERS

FIELD

RECNUM

Numeric

Yes

Sequence counter (e.g., 1)

USERFIELD

Alpha/Numeric

For applicant’s use to identify address records

NUMBER

Numeric

Yes

House number

PREDIR

Alpha

Pre-directional

STNAME

Alpha/Numeric

Yes

Street name

STSUFFIX

Alpha

Street suffix

POSTDIR

Alpha

Post-directional

UNITTYPE

Alpha

Unit type

UNITNUM

Alpha/Numeric

Unit number

MAILCITY

Alpha

Yes

Mailing city name

STATE

Alpha

Yes

State name abbreviated; always FL for Florida

ZIP

Numeric

Yes

5 digit ZIP code

ZIP+4

Numeric

4 digit ( +4) part of ZIP code

STATEFIPS

Numeric

Yes

State FIPS code; always 12 for Florida

COUNTYID

Numeric

Yes

County FIPS code

FEATID

Numeric

Yes

GNIS place feature ID; Use zeros for unincorporated area

Use of FIPS 55 Codes and GNIS Feature ID Codes

Reasons for Rejection of Your File

Our certification system uses both the Federal Information

• Contains records for states other than Florida

Processing Standards (FIPS) 55 codes and the Geographic

• Does not contain record headers

Names Information System (GNIS) Feature Identifiers (ID). The

• Is an invalid file type

FIPS 55 data identifies the state and county codes. The 2-digit

• Records are not provided in the required layout

FIPS code for Florida is 12. Each county has a unique 3-digit

county FIPS code. Each jurisdiction has a unique 9-digit GNIS

Testing Accuracy Standard

Feature ID code. For unincorporated areas, zeros are used as the

To pass certification, your database must assign street addresses,

Feature ID code. Applicants must supply the Feature ID code for

or post office boxes to the proper jurisdiction with an overall

each jurisdiction.

accuracy rate of 95 percent at a 95 percent level of confidence, as

determined through a statistically reliable sample. The accuracy

Examples: An address in the unincorporated area of Volusia

must be measured based on the entire geographic area within the

County should be displayed as 12,127,000000000. An

state covered by the database.

address in the city of Daytona Beach should be displayed as

12,127,002404197.

Form Dr-700012 - Application For Certification Of Communications Services Database Page 2

Related Articles

Related forms

Related Categories