Last Update: August 03, 2015

Streetix_Ref

System-assigned unique ID for the street segment.

Street_Dir

Street direction from the Strdirl table.

Street_Name

Street name.

Street_Type

Street type from the Strtypl table.

Street_Dir_Suffix

Street direction suffix.

USPS_City

USPS city code from the table Mctycdel.

Beginning_House_No

Beginning house number of street segment.

Beginning_House_No_Suffix

Beginning house number suffix.

Ending_House_No

Ending house number of street segment.

Ending_House_No_Suffix

Ending house number suffix.

Odd_Even_Indicator

Odd/Even indicator for house numbering:

blank—both odd and even numbers

O—Odd numbers

E—Even numbers

Zip_Code

Five-digit zip code for street segment.

Precinct

Precinct split to which street segment is assigned.

City_Code

City district for precinct split to which this street segment is assigned.

City_Ward

City-ward district for precinct split to which this street segment is assigned.

Odd_Numbers_Side

Memo column denoting which side (e.g., North) is the odd-numbered side of the street segment.

RR_Street_Name

Name of the street for rural routes.

Apartment_Number_Req

Y indicates apartment numbers are required for addresses in this street segment.

No_Residence_Delivery

Y indicates street segment is not served by USPS and mailing address required for voters residing there.

Invalid_Address_Flag

Y indicates street segment is not in residential area so voters cannot register at an address there.

Date_Record_Added

Date street-segment record added to the system.

Date_Last_Record_Change

Date street-segment record last changed.

Operator_Number

User making last change to record.

St_IX_Registered_Voters

Number of registered voters in street segment.

St_IX_Reg_Dems

Number of voters of specified party residing in street segment.

Other is minor party 1; Spare is minor party 2.

St_IX_Reg_Reps

St_IX_Reg_NonP

St_IX_Reg_Other

St_IX_Reg_Spare

Beginning_Latitude

Unused.

Beginning_Longitude

Ending_Latitude

Ending_Longitude

Carrier_Route

Unused.

Proposed_New_Precinct

Unused.

Ref_Precinct

Unused.

Date_of_Precinct_Change

Timestamp of last change to Precinct column for this street-segment.

Mailing_City

Unused.

Number_Points_Rows

Number of entries in the StreetPoints table for this street-segment.

Sort_Street_Name

Restatement of Street Name column to improve report sorting.

Base_Street_Ptr

Value other than zero or NULL indicates the record is an alias for a street segment. The number in this column points to the Streetix_ref of the street segment for which this record is an alias.

Unused.

Unused.