Note:  The file structures provided are intended as an aid for users.  We cannot provide support in their application.

 

 

README File for /0File_Structure    

 

The structure of the three files provided for each state Redistricting Summary File product is documented in the file, 0README_PL, found under each state directory, for example:  http://www2.census.gov/census_2000/datasets/redistricting_file--pl_94-171/Alabama/0README_PL.doc .

 

Microsoft Access 97 and Microsoft Access 2000 files contain import specifications describing the fixed-field format of the geographic header and assign names to each of the data elements included in the three Redistricting Summary Files. These datasets were created to support testing of the FTP application. For Windows users, these files can reduce the burden of preparing an environment in which to work with these Redistricting Summary Files. The Access and xBASE files are stored in subdirectories of this directory named Access97/, Access2000/, xBase/, and SAS/ respectively.  These files are made available on an “as-is” basis. 

 

The following xBASE files are provided:

 

·         0HEADER.DBF

·         PL_GEOHD.DBF

·         PL_PART1.DBF

·         PL_PART2.DBF

·         TABLES.DBF

 

The Access databases, PL2000.mdb, contain the following tables:

 

·         Header              (corresponds to HEADER.DBF)

·         PL_Geo_Header         (corresponds to PL_GEOHD.DBF)

·         PL_Part1            (corresponds to PL_PART1.DBF)

·         PL_Part2            (corresponds to PL_PART2.DBF)

·         Tables             (corresponds to TABLES.DBF)

 

The following SAS files are provided:

 

·    pl_geohd.sas            (produces a GEO header data set)                       

·    pl_part1.sas             (produces a table 1 and 2 data set)

·    pl_part2.sas             (produces a table 3 and 4 data set)

·    pl_all_3.sas              (puts all 3 PL files together in 1 data set)

 

 

Users of these SAS files will have to modify the libname, data, and infile statements to confirm to their environments. The pl_all_3.sas file is merged by LOGRECNO. Users should check their SAS log for inconsistencies.  These programs have been tested using SAS version 8. 

 

For Access Users

 

The following are suggestions for loading the Redistricting Summary Data into an Access database:

 

Part 1

 

·         Download the compressed files from the FTP site.

·         Download the PL2000.mdb (Access97) or PL2000_Access2000.mdb   (Access2000) file from the FTP site.

·         Uncompress the PL files you wish to load into Access. For convenience, you may want to place these files in a clearly named subdirectory. (NOTE: The files downloaded from the FTP site were created in a UNIX environment. To work with these files in a Windows environment you must uncompress the data sets using compression software that can convert the format of these files to a DOS/Windows compatible format (ASCII line feed to carriage return with line feed conversion). See the 0README file accompanying the data sets.)

·         Make a copy of the downloaded .mdb file in the subdirectory where you want the new Access  database to reside. Rename the copy (for example, MyPLData.mdb).

·         Open Access.

·         Select and open the new database you created (for example, MyPLData).

 

 

 

Part 2

 

·         From the File menu, select Get External Data/Import.

·         In the Import window, (a) select Text Files for Files of Type, (b) enter *.* for File name, (c) select the subdirectory where the uncompressed files were placed to complete the "Look In" option, (d) select the file you want to import (for example, AKGEO) and (e) press the Import button.

·         In the Import Text Wizard window, click on the Advanced option. In the Import Specification window, click on Specs. Select the appropriate import specification. (There is an import specification for each of the three PL file types.) Click Open. Then click OK.

·         In the Import Text Wizard window, click Next twice. Select In a New Table. Click Next a third and fourth time. Select Choose My Own Primary Key. Select LOGRECNO. Click Next. Change the name of the Access table if you wish. Click Finish.

·         Repeat part 2 until all three files for a state have been added.

 

File Structure

 

The structure of the files is identical in each format. These three files provide file structure only. They contain no data. The structure of each is detailed below:

 

PL_GEOHD.DBF

 

Name

Type

Size

FILEID

Text

6

STUSAB

Text

2

SUMLEV

Text

3

GEOCOMP

Text

2

CHARITER

Text

3

CIFSN

Text

2

LOGRECNO

Text

7

REGION

Text

1

DIVISION

Text

1

STATECE

Text

2

STATE

Text

2

COUNTY

Text

3

COUNTYSC

Text

2

COUSUB

Text

5

COUSUBCC

Text

2

COUSUBSC

Text

2

PLACE

Text

5

PLACECC

Text

2

PLACEDC

Text

1

PLACESC

Text

2

TRACT

Text

6

BLKGRP

Text

1

BLOCK

Text

4

IUC

Text

2

CONCIT

Text

5

CONCITCC

Text

2

CONCITSC

Text

2

AIANHH

Text

4

AIANHHFP

Text

5

AIANHHCC

Text

2

AIHHTLI

Text

1

AITSCE

Text

3

AITS

Text

5

AITSCC

Text

2

ANRC

Text

5

ANRCCC

Text

2

MSACMSA

Text

4

MASC

Text

2

CMSA

Text

2

MACCI

Text

1

PMSA

Text

4

NECMA

Text

4

NECMACCI

Text

1

NECMASC

Text

2

EXI

Text

1

UA

Text

5

UASC

Text

2

UATYPE

Text

1

UR

Text

1

CD106

Text

2

CD108

Text

2

CD109

Text

2

CD110

Text

2

SLDU

Text

3

SLDL

Text

3

VTD

Text

6

VTDI

Text

1

ZCTA3

Text

3

ZCTA5

Text

5

SUBMCDCC

Text

2

AREALAND

Text

14

AREAWATR

Text

14

NAME

Text

90

FUNCSTAT

Text

1

GCUNI

Text

1

POP100

Text

9

RES

Text

9

INTPTLAT

Text

9

INTPTLON

Text

10

LSADC

Text

2

PARTFLAG

Text

1

SDELM

Text

5

SDSEC

Text

5

SDUNI

Text

5

TAZ

Text

6

UGA

Text

5

PUMA5

Text

5

PUMA1

Text

5

RESERVED

Text

32

 

 

PL_PART1.DBF

 

Name

Type

Size

FILEID

Text

6

STUSAB

Text

2

CHARITER

Text

3

CIFSN

Text

2

LOGRECNO

Text

7

P0010001

Number (Long)

4

P0010002

Number (Long)

4

P0010003

Number (Long)

4

P0010004

Number (Long)

4

P0010005

Number (Long)

4

P0010006

Number (Long)

4

P0010007

Number (Long)

4

P0010008

Number (Long)

4

P0010009

Number (Long)

4

P0010010

Number (Long)

4

P0010011

Number (Long)

4

P0010012

Number (Long)

4

P0010013

Number (Long)

4

P0010014

Number (Long)

4

P0010015

Number (Long)

4

P0010016

Number (Long)

4

P0010017

Number (Long)

4

P0010018

Number (Long)

4

P0010019

Number (Long)

4

P0010020

Number (Long)

4

P0010021

Number (Long)

4

P0010022

Number (Long)

4

P0010023

Number (Long)

4

P0010024

Number (Long)

4

P0010025

Number (Long)

4

P0010026

Number (Long)

4

P0010027

Number (Long)

4

P0010028

Number (Long)

4

P0010029

Number (Long)

4

P0010030

Number (Long)

4

P0010031

Number (Long)

4

P0010032

Number (Long)

4

P0010033

Number (Long)

4

P0010034

Number (Long)

4

P0010035

Number (Long)

4

P0010036

Number (Long)

4

P0010037

Number (Long)

4

P0010038

Number (Long)

4

P0010039

Number (Long)

4

P0010040

Number (Long)

4

P0010041

Number (Long)

4

P0010042

Number (Long)

4

P0010043

Number (Long)

4

P0010044

Number (Long)

4

P0010045

Number (Long)

4

P0010046

Number (Long)

4

P0010047

Number (Long)

4

P0010048

Number (Long)

4

P0010049

Number (Long)

4

P0010050

Number (Long)

4

P0010051

Number (Long)

4

P0010052

Number (Long)

4

P0010053

Number (Long)

4

P0010054

Number (Long)

4

P0010055

Number (Long)

4

P0010056

Number (Long)

4

P0010057

Number (Long)

4

P0010058

Number (Long)

4

P0010059

Number (Long)

4

P0010060

Number (Long)

4

P0010061

Number (Long)

4

P0010062

Number (Long)

4

P0010063

Number (Long)

4

P0010064

Number (Long)

4

P0010065

Number (Long)

4

P0010066

Number (Long)

4

P0010067

Number (Long)

4

P0010068

Number (Long)

4

P0010069

Number (Long)

4

P0010070

Number (Long)

4

P0010071

Number (Long)

4

P0020001

Number (Long)

4

P0020002

Number (Long)

4

P0020003

Number (Long)

4

P0020004

Number (Long)

4

P0020005

Number (Long)

4

P0020006

Number (Long)

4

P0020007

Number (Long)

4

P0020008

Number (Long)

4

P0020009

Number (Long)

4

P0020010

Number (Long)

4

P0020011

Number (Long)

4

P0020012

Number (Long)

4

P0020013

Number (Long)

4

P0020014

Number (Long)

4

P0020015

Number (Long)

4

P0020016

Number (Long)

4

P0020017

Number (Long)

4

P0020018

Number (Long)

4

P0020019

Number (Long)

4

P0020020

Number (Long)

4

P0020021

Number (Long)

4

P0020022

Number (Long)

4

P0020023

Number (Long)

4

P0020024

Number (Long)

4

P0020025

Number (Long)

4

P0020026

Number (Long)

4

P0020027

Number (Long)

4

P0020028

Number (Long)

4

P0020029

Number (Long)

4

P0020030

Number (Long)

4

P0020031

Number (Long)

4

P0020032

Number (Long)

4

P0020033

Number (Long)

4

P0020034

Number (Long)

4

P0020035

Number (Long)

4

P0020036

Number (Long)

4

P0020037

Number (Long)

4

P0020038

Number (Long)

4

P0020039

Number (Long)

4

P0020040

Number (Long)

4

P0020041

Number (Long)

4

P0020042

Number (Long)

4

P0020043

Number (Long)

4

P0020044

Number (Long)

4

P0020045

Number (Long)

4

P0020046

Number (Long)

4

P0020047

Number (Long)

4

P0020048

Number (Long)

4

P0020049

Number (Long)

4

P0020050

Number (Long)

4

P0020051

Number (Long)

4

P0020052

Number (Long)

4

P0020053

Number (Long)

4

P0020054

Number (Long)

4

P0020055

Number (Long)

4

P0020056

Number (Long)

4

P0020057

Number (Long)

4

P0020058

Number (Long)

4

P0020059

Number (Long)

4

P0020060

Number (Long)

4

P0020061

Number (Long)

4

P0020062

Number (Long)

4

P0020063

Number (Long)

4

P0020064

Number (Long)

4

P0020065

Number (Long)

4

P0020066

Number (Long)

4

P0020067

Number (Long)

4

P0020068

Number (Long)

4

P0020069

Number (Long)

4

P0020070

Number (Long)

4

P0020071

Number (Long)

4

P0020072

Number (Long)

4

P0020073

Number (Long)

4

 

 

PL_PART2.DBF

 

Name

Type

Size

FILEID

Text

6

STUSAB

Text

2

CHARITER

Text

3

CIFSN

Text

2

LOGRECNO

Text

7

P0030001

Number (Long)

4

P0030002

Number (Long)

4

P0030003

Number (Long)

4

P0030004

Number (Long)

4

P0030005

Number (Long)

4

P0030006

Number (Long)

4

P0030007

Number (Long)

4

P0030008

Number (Long)

4

P0030009

Number (Long)

4

P0030010

Number (Long)

4

P0030011

Number (Long)

4

P0030012

Number (Long)

4

P0030013

Number (Long)

4

P0030014

Number (Long)

4

P0030015

Number (Long)

4

P0030016

Number (Long)

4

P0030017

Number (Long)

4

P0030018

Number (Long)

4

P0030019

Number (Long)

4

P0030020

Number (Long)

4

P0030021

Number (Long)

4

P0030022

Number (Long)

4

P0030023

Number (Long)

4

P0030024

Number (Long)

4

P0030025

Number (Long)

4

P0030026

Number (Long)

4

P0030027

Number (Long)

4

P0030028

Number (Long)

4

P0030029

Number (Long)

4

P0030030

Number (Long)

4

P0030031

Number (Long)

4

P0030032

Number (Long)

4

P0030033

Number (Long)

4

P0030034

Number (Long)

4

P0030035

Number (Long)

4

P0030036

Number (Long)

4

P0030037

Number (Long)

4

P0030038

Number (Long)

4

P0030039

Number (Long)

4

P0030040

Number (Long)

4

P0030041

Number (Long)

4

P0030042

Number (Long)

4

P0030043

Number (Long)

4

P0030044

Number (Long)

4

P0030045

Number (Long)

4

P0030046

Number (Long)

4

P0030047

Number (Long)

4

P0030048

Number (Long)

4

P0030049

Number (Long)

4

P0030050

Number (Long)

4

P0030051

Number (Long)

4

P0030052

Number (Long)

4

P0030053

Number (Long)

4

P0030054

Number (Long)

4

P0030055

Number (Long)

4

P0030056

Number (Long)

4

P0030057

Number (Long)

4

P0030058

Number (Long)

4

P0030059

Number (Long)

4

P0030060

Number (Long)

4

P0030061

Number (Long)

4

P0030062

Number (Long)

4

P0030063

Number (Long)

4

P0030064

Number (Long)

4

P0030065

Number (Long)

4

P0030066

Number (Long)

4

P0030067

Number (Long)

4

P0030068

Number (Long)

4

P0030069

Number (Long)

4

P0030070

Number (Long)

4

P0030071

Number (Long)

4

P0040001

Number (Long)

4

P0040002

Number (Long)

4

P0040003

Number (Long)

4

P0040004

Number (Long)

4

P0040005

Number (Long)

4

P0040006

Number (Long)

4

P0040007

Number (Long)

4

P0040008

Number (Long)

4

P0040009

Number (Long)

4

P0040010

Number (Long)

4

P0040011

Number (Long)

4

P0040012

Number (Long)

4

P0040013

Number (Long)

4

P0040014

Number (Long)

4

P0040015

Number (Long)

4

P0040016

Number (Long)

4

P0040017

Number (Long)

4

P0040018

Number (Long)

4

P0040019

Number (Long)

4

P0040020

Number (Long)

4

P0040021

Number (Long)

4

P0040022

Number (Long)

4

P0040023

Number (Long)

4

P0040024

Number (Long)

4

P0040025

Number (Long)

4

P0040026

Number (Long)

4

P0040027

Number (Long)

4

P0040028

Number (Long)

4

P0040029

Number (Long)

4

P0040030

Number (Long)

4

P0040031

Number (Long)

4

P0040032

Number (Long)

4

P0040033

Number (Long)

4

P0040034

Number (Long)

4

P0040035

Number (Long)

4

P0040036

Number (Long)

4

P0040037

Number (Long)

4

P0040038

Number (Long)

4

P0040039

Number (Long)

4

P0040040

Number (Long)

4

P0040041

Number (Long)

4

P0040042

Number (Long)

4

P0040043

Number (Long)

4

P0040044

Number (Long)

4

P0040045

Number (Long)

4

P0040046

Number (Long)

4

P0040047

Number (Long)

4

P0040048

Number (Long)

4

P0040049

Number (Long)

4

P0040050

Number (Long)

4

P0040051

Number (Long)

4

P0040052

Number (Long)

4

P0040053

Number (Long)

4

P0040054

Number (Long)

4

P0040055

Number (Long)

4

P0040056

Number (Long)

4

P0040057

Number (Long)

4

P0040058

Number (Long)

4

P0040059

Number (Long)

4

P0040060

Number (Long)

4

P0040061

Number (Long)

4

P0040062

Number (Long)

4

P0040063

Number (Long)

4

P0040064

Number (Long)

4

P0040065

Number (Long)

4

P0040066

Number (Long)

4

P0040067

Number (Long)

4

P0040068

Number (Long)

4

P0040069

Number (Long)

4

P0040070

Number (Long)

4

P0040071

Number (Long)

4

P0040072

Number (Long)

4

P0040073

Number (Long)

4

 

 

The remaining files, HEADER and TABLES, contain additional metadata that can be used to understand the content of the Redistricting Summary Files. The content of those two files is as follows:

 

HEADERS.DBF

 

DESC

NAME

LEN

File Identification

FILEID

6

State/US-Abbreviation (USPS)

STUSAB

2

Summary Level

SUMLEV

3

Geographic Component

GEOCOMP

2

Characteristic Iteration

CHARITER

3

Characteristic Iteration File Sequence Number

CIFSN

2

Logical Record Number

LOGRECNO

7

Region

REGION

1

Division

DIVISION

1

State (Census)

STATECE

2

State (FIPS)

STATE

2

County

COUNTY

3

County Size Code

COUNTYSC

2

County Subdivision (FIPS)

COUSUB

5

FIPS County Subdivision Class Code

COUSUBCC

2

County Subdivision Size Code

COUSUBSC

2

Place (FIPS)

PLACE

5

FIPS Place Class Code

PLACECC

2

Place Description Code

PLACEDC

1

Place Size Code

PLACESC

2

Census Tract

TRACT

6

Block Group

BLKGRP

1

Block

BLOCK

4

Internal Use Code

IUC

2

Consolidated City (FIPS)

CONCIT

5

FIPS Consolidated City Class Code

CONCITCC

2

Consolidated City Size Code

CONCITSC

2

American Indian Area/Alaska Native Area/Hawaiian Home Land (Census)

AIANHH

4

American Indian Area/Alaska Native Area/Hawaiian Home Land (FIPS)

AIANHHFP

5

FIPS American Indian Area/Alaska Native Area/Hawaiian Home Land Class Code

AIANHHCC

2

American Indian Trust Land/Hawaiian Home Land Indicator

AIHHTLI

1

American Indian Tribal Subdivision (Census)

AITSCE

3

American Indian Tribal Subdivision (FIPS)

AITS

5

FIPS American Indian Tribal Subdivision Class Code

AITSCC

2

Alaska Native Regional Corporation (FIPS)

ANRC

5

FIPS Alaska Native Regional Corporation Class Code

ANRCCC

2

Metropolitan Statistical Area/Consolidated Metropolitan Statistical Area

MSACMSA

4

MSA/CMSA Size Code

MASC

2

Consolidated Metropolitan Statistical Area

CMSA

2

Metropolitan Area Central City Indicator

MACCI

1

Primary Metropolitan Statistical Area

PMSA

4

New England County Metropolitan Area

NECMA

4

New England County Metropolitan Area Central City Indicator

NECMACCI

1

New England County Metropolitan Area Size Code

NECMASC

2

Extended Place Indicator

EXI

1

Urban Area

UA

5

Urban Area Size Code

UASC

2

Urban Area Type

UATYPE

1

Urban/Rural

UR

1

Congressional District (106th)

CD106

2

Congressional District (108th)

CD108

2

Congressional District (109th)

CD109

2

Congressional District (110th)

CD110

2

State Legislative District (Upper Chamber)

SLDU