This metadata information is subject to our disclaimer.
Infrastructure - Traffic Signals, File name: ti_trfsg
Field Name Description Field Type Domain Enumerated
valuesCnstplnNum NVARCHAR CnstplnPg SMALLINT CnstplnPha SMALLINT CnstplnQua SMALLINT created_date DATETIME2 created_user NVARCHAR DevPlanNum NVARCHAR DevPrmtNum NVARCHAR DocLink NVARCHAR EventId NVARCHAR FieldNote NVARCHAR FromDate DATETIME2 FromMeasure NUMERIC GlobalID UNIQUEIDENTIFIER ImpDistNum NVARCHAR ImpplnNum NVARCHAR ImpplnPg SMALLINT ImpplnQual NVARCHAR Inspected DATETIME2 Installed DATETIME2 Intrsctn NVARCHAR last_edited_date DATETIME2 last_edited_user NVARCHAR LAT NUMERIC LON NUMERIC MXASSEMBLYTYPE NVARCHAR MXASSETNUM NVARCHAR MXCREATIONSTATE SMALLINT MXDESCRIPTION NVARCHAR MXDIRECTION NVARCHAR MXFULLDESCRIPTION NVARCHAR MXGLACCOUNT NVARCHAR MXISLINEAR SMALLINT MXLABELTEXT NVARCHAR MXLATITUDEY NUMERIC MXLOCATION NVARCHAR MXLONGITUDEX NUMERIC MXPARENT NVARCHAR MXROTATING SMALLINT MXSITEID NVARCHAR MXSTATUS NVARCHAR OBJECTID INT Offset NUMERIC ORDINANCE NVARCHAR ORDINANCE_LINK NVARCHAR PoleNum SMALLINT RouteId NVARCHAR ROWSTAMP INT SI_Count SMALLINT SignalType NVARCHAR StinterId INT StreetLamp NVARCHAR StructId INT ToDate DATETIME2 ToMeasure NUMERIC There are 55 attribute fields.