DWOperations
 dbo.ZIPCodes (Table)
Home  Diagrams  Documents  Images  DWOperations  Storage  Users  Roles  Schemas  Tables  Views  Indexes  Triggers  Stored Procedures  Functions  Data Types  XML Schemas  Rules  Defaults  Fulltext Catalogs  Synonyms  Keys  Partitions  Assemblies 
Current Path:  DWOperations   Tables   dbo.ZIPCodes
  Properties
Property Value
Name ZIPCodes
Schema dbo
Row Count 80247
Data Size 13048 KB
Index Size 28216 KB
Create Date 1/28/2014 9:48 AM
Description U.S. Zip Code Database ? Standard (from www.zip-codes.com)
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
AreaCode
varchar(55)
True
False
False
 
The telephone area codes available in this ZIP Code.
CarrierRouteRateSortation
varchar(1)
True
False
False
 
City
varchar(35)
True
False
False
 
Name of the city as designated by the USPS.
CityAliasAbbreviation
varchar(13)
True
False
False
 
13 Character abbreviation for the city alias name.
CityAliasCode
varchar(5)
True
False
False
 
Code indicating the type of the city alias name for this record. Record can be Abbreviations, Universities, Government, and more.
CityAliasMixedCase
varchar(35)
True
False
False
 
The city alias name in mixed case (i.e. Not in all uppercase letters).
CityAliasName
varchar(35)
True
False
False
 
Alias name of the city if it exists.
CityDeliveryIndicator
varchar(1)
True
False
False
 
CityMixedCase
varchar(35)
True
False
False
 
The city name in mixed case (i.e. Not in all uppercase letters).
CityStateKey
char(6)
True
False
False
 
Links this record with other products ZIP-Codes.com offers such as the ZIP+4.
CityType
char(1)
True
False
False
 
Indicates the type of locale such as Post Office, Stations, or Branch.
ClassificationCode
char(1)
True
False
False
 
The classification type of this ZIP Code.
County
varchar(45)
True
False
False
 
Name of County or Parish this ZIP Code resides in.
CountyANSI
varchar(3)
True
False
False
 
CountyFIPS
char(5)
True
False
False
 
FIPS code for the County/Parish this ZIP Code resides in.
DayLightSaving
char(1)
True
False
False
 
Flag indicating whether this ZIP Code observes daylight savings.
Elevation
int(10, 0)
True
False
False
 
The average elevation of the county.
FacilityCode
varchar(1)
True
False
False
 
FinanceNumber
varchar(6)
True
False
False
 
Latitude
decimal(12, 6)
True
False
False
 
Geographic coordinate as a point measured in degrees north or south of the equator.
Longitude
decimal(12, 6)
True
False
False
 
Geographic coordinate as a point measured in degrees east or west of the Greenwich Meridian.
MultiCounty
char(1)
True
False
False
 
Flag indicating whether this ZIP Code crosses county lines.
PreferredLastLineKey
varchar(10)
True
False
False
 
Links this record with other products ZIP-Codes.com offers
PrimaryRecord
char(1)
True
False
False
 
Character ?P? denoting if this row is a Primary Record or not. Absence of character denotes a non-primary record.
State
char(2)
True
False
False
 
2 letter state name abbreviation.
StateANSI
varchar(2)
True
False
False
 
StateFIPS
char(2)
True
False
False
 
FIPS code for the State this ZIP Code resides in.
TimeZone
char(2)
True
False
False
 
Hours past Greenwich Time Zone this ZIP Code belongs to.
UniqueZIPName
varchar(1)
True
False
False
 
ZipCode
char(5)
False
False
False
 
00000-99999 Five digit numeric ZIP Code of the area.
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
AreaCode
False
City
False
CityAliasName
False
CityStateKey
False
County
False
Latitude
False
Longitude
False
PrimaryRecord
False
State
False
ZipCode
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ZIPCodes depends on)
Name Type
  Child Dependencies (objects that depend on dbo.ZIPCodes)
Name Type
  Extended Properties
Object Property Value
ZIPCodes
MS_Description
U.S. Zip Code Database ? Standard (from www.zip-codes.com)
AreaCode
MS_Description
The telephone area codes available in this ZIP Code.
City
MS_Description
Name of the city as designated by the USPS.
CityAliasAbbreviation
MS_Description
13 Character abbreviation for the city alias name.
CityAliasCode
MS_Description
Code indicating the type of the city alias name for this record. Record can be Abbreviations, Universities, Government, and more.
CityAliasMixedCase
MS_Description
The city alias name in mixed case (i.e. Not in all uppercase letters).
CityAliasName
MS_Description
Alias name of the city if it exists.
CityMixedCase
MS_Description
The city name in mixed case (i.e. Not in all uppercase letters).
CityStateKey
MS_Description
Links this record with other products ZIP-Codes.com offers such as the ZIP+4.
CityType
MS_Description
Indicates the type of locale such as Post Office, Stations, or Branch.
ClassificationCode
MS_Description
The classification type of this ZIP Code.
County
MS_Description
Name of County or Parish this ZIP Code resides in.
CountyFIPS
MS_Description
FIPS code for the County/Parish this ZIP Code resides in.
DayLightSaving
MS_Description
Flag indicating whether this ZIP Code observes daylight savings.
Elevation
MS_Description
The average elevation of the county.
Latitude
MS_Description
Geographic coordinate as a point measured in degrees north or south of the equator.
Longitude
MS_Description
Geographic coordinate as a point measured in degrees east or west of the Greenwich Meridian.
MultiCounty
MS_Description
Flag indicating whether this ZIP Code crosses county lines.
PreferredLastLineKey
MS_Description
Links this record with other products ZIP-Codes.com offers
PrimaryRecord
MS_Description
Character ?P? denoting if this row is a Primary Record or not. Absence of character denotes a non-primary record.
State
MS_Description
2 letter state name abbreviation.
StateFIPS
MS_Description
FIPS code for the State this ZIP Code resides in.
TimeZone
MS_Description
Hours past Greenwich Time Zone this ZIP Code belongs to.
ZipCode
MS_Description
00000-99999 Five digit numeric ZIP Code of the area.
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ZIPCodes] Script Date: 03/09/2017 17:21:49 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ZIPCodes](
    [ZipCode] [char](5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [City] [varchar](35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [State] [char](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [County] [varchar](45) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [AreaCode] [varchar](55) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CityType] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CityAliasAbbreviation] [varchar](13) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CityAliasName] [varchar](35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [Latitude] [decimal](12, 6) NULL,
    [Longitude] [decimal](12, 6) NULL,
    [TimeZone] [char](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [Elevation] [int] NULL,
    [CountyFIPS] [char](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DayLightSaving] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PreferredLastLineKey] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ClassificationCode] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MultiCounty] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [StateFIPS] [char](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CityStateKey] [char](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CityAliasCode] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PrimaryRecord] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CityMixedCase] [varchar](35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CityAliasMixedCase] [varchar](35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [StateANSI] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CountyANSI] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FacilityCode] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CityDeliveryIndicator] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CarrierRouteRateSortation] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FinanceNumber] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [UniqueZIPName] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'U.S. Zip Code Database ? Standard (from www.zip-codes.com)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZIPCodes'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The telephone area codes available in this ZIP Code.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZIPCodes', @level2type=N'COLUMN',@level2name=N'AreaCode'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Name of the city as designated by the USPS.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZIPCodes', @level2type=N'COLUMN',@level2name=N'City'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'13 Character abbreviation for the city alias name.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZIPCodes', @level2type=N'COLUMN',@level2name=N'CityAliasAbbreviation'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code indicating the type of the city alias name for this record. Record can be Abbreviations, Universities, Government, and more.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZIPCodes', @level2type=N'COLUMN',@level2name=N'CityAliasCode'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The city alias name in mixed case (i.e. Not in all uppercase letters).' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZIPCodes', @level2type=N'COLUMN',@level2name=N'CityAliasMixedCase'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Alias name of the city if it exists.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZIPCodes', @level2type=N'COLUMN',@level2name=N'CityAliasName'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The city name in mixed case (i.e. Not in all uppercase letters).' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZIPCodes', @level2type=N'COLUMN',@level2name=N'CityMixedCase'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Links this record with other products ZIP-Codes.com offers such as the ZIP+4.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZIPCodes', @level2type=N'COLUMN',@level2name=N'CityStateKey'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indicates the type of locale such as Post Office, Stations, or Branch.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZIPCodes', @level2type=N'COLUMN',@level2name=N'CityType'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The classification type of this ZIP Code.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZIPCodes', @level2type=N'COLUMN',@level2name=N'ClassificationCode'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Name of County or Parish this ZIP Code resides in.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZIPCodes', @level2type=N'COLUMN',@level2name=N'County'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'FIPS code for the County/Parish this ZIP Code resides in.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZIPCodes', @level2type=N'COLUMN',@level2name=N'CountyFIPS'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Flag indicating whether this ZIP Code observes daylight savings.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZIPCodes', @level2type=N'COLUMN',@level2name=N'DayLightSaving'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The average elevation of the county.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZIPCodes', @level2type=N'COLUMN',@level2name=N'Elevation'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Geographic coordinate as a point measured in degrees north or south of the equator.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZIPCodes', @level2type=N'COLUMN',@level2name=N'Latitude'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Geographic coordinate as a point measured in degrees east or west of the Greenwich Meridian.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZIPCodes', @level2type=N'COLUMN',@level2name=N'Longitude'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Flag indicating whether this ZIP Code crosses county lines.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZIPCodes', @level2type=N'COLUMN',@level2name=N'MultiCounty'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Links this record with other products ZIP-Codes.com offers' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZIPCodes', @level2type=N'COLUMN',@level2name=N'PreferredLastLineKey'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Character ?P? denoting if this row is a Primary Record or not. Absence of character denotes a non-primary record.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZIPCodes', @level2type=N'COLUMN',@level2name=N'PrimaryRecord'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'2 letter state name abbreviation.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZIPCodes', @level2type=N'COLUMN',@level2name=N'State'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'FIPS code for the State this ZIP Code resides in.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZIPCodes', @level2type=N'COLUMN',@level2name=N'StateFIPS'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Hours past Greenwich Time Zone this ZIP Code belongs to.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZIPCodes', @level2type=N'COLUMN',@level2name=N'TimeZone'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'00000-99999 Five digit numeric ZIP Code of the area.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZIPCodes', @level2type=N'COLUMN',@level2name=N'ZipCode'
  Sample Data
AreaCode CarrierRouteRateSortation City CityAliasAbbreviation CityAliasCode CityAliasMixedCase CityAliasName CityDeliveryIndicator CityMixedCase CityStateKey CityType ClassificationCode County CountyANSI CountyFIPS DayLightSaving Elevation FacilityCode FinanceNumber Latitude Longitude MultiCounty PreferredLastLineKey PrimaryRecord State StateANSI StateFIPS TimeZone UniqueZIPName ZipCode
580 C ENID Enid ENID Y Enid W22044 Z P GARFIELD 047 047 Y 1246 P 392827 36.395700 -97.878400 W22044 P OK 40 40 6 73706
575 D LAS CRUCES Las Cruces LAS CRUCES Y Las Cruces Z13856 P DONA ANA 013 013 Y 3883 P 344788 32.302486 -106.641604 Z13856 P NM 35 35 7 88011
509 D PESHASTIN Peshastin PESHASTIN N Peshastin Z17283 P CHELAN 007 007 Y 645 P 546580 47.456872 -120.674601 Z17283 P WA 53 53 8 98847
910 D JACKSONVILLE Jacksonville JACKSONVILLE Y Jacksonville Y15633 Z P ONSLOW 133 133 Y 15 P 363928 34.753800 -77.430900 Y15633 P NC 37 37 5 28541
601 D BRANDON Brandon BRANDON Y Brandon Y13303 P RANKIN 121 121 Y 486 P 270897 32.451325 -89.948680 Y13303 P MS 28 28 6 39047
361 C SHINER Glaze City GLAZE CITY N Shiner W23898 N LAVACA 285 285 Y 228 N 488325 29.420880 -97.147198 Y W25630 TX 48 48 6 77984
716 C MODEL CITY Model City MODEL CITY N Model City V14712 Z P NIAGARA 063 063 Y 492 P 355380 43.185000 -78.983800 V14712 P NY 36 36 5 14107
618 C LOUISVILLE Bible Grove BIBLE GROVE N Louisville W12065 N CLAY 025 025 Y 492 N 164614 38.825178 -88.528768 W13761 IL 17 17 6 62858
502 C LOUISVILLE Louisville LOUISVILLE N Louisville X15639 Z P JEFFERSON 111 111 Y 449 P 204788 38.254500 -85.759500 X15639 P KY 21 21 5 40232
918 C PAWNEE Pawnee PAWNEE Y Pawnee W22379 P PAWNEE 117 117 Y 866 P 396402 36.332950 -96.775394 W22379 P OK 40 40 6 74058
Powered by BI Documenter