TIMEZONE Columns

Print this page
Learn more about Verizon Connect GeoBase.
Get information about the latest release

TIMEZONE Columns

These columns are used when importing custom GIS timezone and daylight savings (DST) data from a shapefile (for example, IMPORT REGIONS).

Syntax

Alchemy

Copy

TIMEZONE = { gmt_offset : %time_zone,                 
        dst: %dst_exist == "Y", 
        dst_type : DayOfWeek, 
        dst_start_day : %start_day, 
        dst_start_week : %start_week,
        dst_start_month : %start_month,
        dst_start_time : %start_time,
        dst_end_day : %end_day,
        dst_end_week : %end_week,
        dst_end_month : %end_month,
        dst_end_time : %end_time
    }

Column Names

Column	Description	Type	Length	Values
gmt_offset	The difference between this timezone and GMT, in hours.	Numeric	Variable	-12 - 12
dst_exist	True if this timezone has daylight savings.	Boolean	1	Y (1), N (0)
dst_type	The daylight savings type.	Text	Variable	DayOfWeek DayOfMonth
dst_start_day	The day of the week that daylight savings begins. 1 - 7 (Sunday-Saturday) or 1-31 for DayOfMonth.	Numeric	Variable	DayOfWeek: 1 - 7 DayOfMonth: 1 - 31
dst_start_week	The week of the month in which daylight savings starts for this timezone. 1 - 6 (1 - 5 => 1st-5th weeks, 6 => last week). Only used for DayOfWeek.	Numeric	1	1 - 6
dst_start_month	The month in which daylight savings starts for this timezone. 1 - 12 (January-December).	Numeric	Variable	1 - 12
dst_start_time	Sets the time of day at which daylight savings starts for this timezone. 24-hour time (e.g. 0200 if DST starts at 2am).	Numeric	4	0000 - 2359
dst_end_day	The day of the week that daylight savings ends for this timezone. 1 - 7 (Sunday-Saturday).	Numeric	Variable	dayofweek: 1 - 7 dayofmonth: 1 - 31
dst_end_week	The week of the month in which daylight savings ends for this timezone. 1 - 6 (1 - 5 => 1st-5th weeks, 6 => last week). Only used for DayOfWeek.	Numeric	1	1 - 6
dst_end_month	The month in which daylight savings ends for this timezone. 1 - 12 (January-December).	Numeric	Variable	1 - 12
dst_end_time	The time of day at which daylight savings ends for this timezone. 24-hour time (e.g. 0200 if DST ends at 2am).	Numeric	4	0000 - 2359

DST Type	Description
DayOfWeek	Daylight savings begins on a specified day of the week in this timezone.
DayOfMonth	Daylight savings begins on a specified day of the month in this timezone.