The Marker table provides information about the locations for which markers are defined.
This topic contains the following sections:
Markers require location to be specified through one of these column sets:
Lat and Lon
EnvelopeAddress that includes the country specified in the string, like "20 Enterprise, Aliso Viejo, CA 92656 -- USA"
EnvelopeAddress and Country
If you specify the country both within the EnvelopeAddress string and with the Country column, then the value set for the Country column is used.
StreetName and Country plus one of the following:
When you write templates that access this table, follow these requirements:
Specify the Symbolic Name for the table version to use:
TableID = Marker-1.0
Specify an Intent that this table supports:
Input templates: In your [Output] section, be sure to map an input value to every table column that is flagged as being a primary key or required.
[Filter] Id(ExtId) = Equals(Id1) # You can filter on literals or on variables from the [User] or [Calculated] sections.
[Filter] Id(ExtId) = In(["Id1","Id2","Id3"])
[Filter] Tag = Equals("MarkerName") # You can filter on literals or on variables from the [User] or [Calculated] sections
This fetcher filters by whether the marker contains a location, identified by latitude and longitude. For polygon markers, the fetcher checks for the location within the boundaries of the polygon Shape. For point markers, the fetcher checks for the location within the Radius of the marker. If you filter on literals (Example 1), then you must define a default unit of measure for the Angle data type in the [Defaults] section. If you filter on input from the [User] section, then you can either define the unit of measure in the [Defaults] section or for each line in the [User] section as shown in Example 2.
[Defaults] Angle=Degree # Sets the default unit of measure for the Latitude and Longitude literals in the [Filter] section [Filter] Shape = ContainsPoint(30.39761,-97.72958) # Filters markers by literal values
[User] # Sets the Latitude and Longitude by query string, for example: &Latitude=30.39761&Longitude=-97.72958 Latitude(Angle,Degree) = “latitude” # Sets the data type and unit of measure for Latitude Longitude(Angle,Degree) = “longitude” # Sets the data type and unit of measure for Longitude [Filter] Shape = ContainsPoint(Latitude,Longitude) # Filters markers by input from the [User] section
[Filter] UserId(ExternalIdName) = Equals("ABC123") # or use Telogis Id: UserId = Equals("123456...")
[Filter] UpdateTime = GreaterThan(TimeStart) # Timestamp variable from User or Calculated section
[Filter] UpdateTime = Between(TimeStart,TimeEnd) # Timestamp variable from User or Calculated section
[Filter] PrimaryCategoryId(Telogis, Name) = Equals("HQ") # or use an External key or Telogis Id
[Filter] # Tests whether external key value matches any in the set PrimaryCategoryId(Telogis, Name) = In(["HQ", "Customers", "Fuel Station", "Prohibited"])
This list includes each column's name, which you use in expressions to retrieve or create data, and data type, which defines how the data is retrieved and set.
|If a column of data type Id is a primary key OR if it refers to other tables (Id <OtherTable>), then you can map it to an external key or, in some cases, a Telogis key.|
|Id||Id||(primary key) The Id of the marker.|
|UserId||Id||(read-only) The Id of the user who created the marker.|
|DriverId||Id<Driver>||The ID of the driver associated with this marker (e.g. the driver with a job assigned at this marker).|
|PrimaryCategoryId||Id<Category>||The ID of the marker's primary category.|
|CategoryIds||Set<Id<Category>>||Set of IDs of the categories to which this marker belongs. Updates must include the full set of desired IDs.|
|Tag||Text||The name of the marker.|
|TerritoryId||Id<Territory>||The ID of the territory to which the marker belongs. To clear the territory, set the TerritoryId to 0.|
|TerritoryName||Text||(read-only) The name of the territory to which the marker belongs.|
|MarkerType||Number||Indicates whether the marker is a point marker (0) or a polygon marker (5).|
|Radius||Distance||The radius of the marker (for point markers).|
|Shape||Polygon||The points defining a polygon marker's boundary, in Lat Lon pairs. Must be a WKT (Well Known Text) definition string not greater than 10 MB. Example: "POLYGON((-120.06252 36.08499, -115.07387 35.8306, -117.65138 33.74055, -120.06252 36.08499))".|
|Lat||Angle||The latitude where marker is located. Must be between -90 and 90 degrees. If this value is 0, then the value of Lon must be non-zero.|
|Lon||Angle||The longitude where the marker is located. Must be between -180 and 180 degrees. If this value is 0, then the value of Lat must be non-zero.|
|StreetNumber||StreetNumber||The street number portion of the marker's address.|
|StreetName||Text||The street name portion of the marker's address.|
|City||Text||The city where the marker is located.|
|Region||Text||The state or region where the marker is located.|
|PostalCode||Text||The zip code or postal code of the marker's address.|
|Country||Text||The Country where the marker is located.|
|EnvelopeAddress||Text||The mailing address for the marker. On create, TDE geocodes this address if Lat/Lon are undefined.|
|IsZone||BoolType||Indicates whether the marker is a zone marker. Zone markers report the vehicles actual location rather than "snapping" vehicle locations to the marker location. In addition, zone markers can have assigned speed limits.|
|Contact1||Text||Contact details, such as name or phone number.|
|Contact2||Text||Additional contact details.|
|Phone1||Text||Primary phone number.|
|Phone2||Text||Secondary phone number, such as for a pager.|
|Notes||Text||Free-form notes about the marker.|
|SpeedLimit||Number||Maximum speed (in default units) for vehicles driving within the boundaries of the marker. This value is only used for zone markers.|
|UpdateTime||Timestamp||(read-only) Date and time when this marker was last updated.|
|Custom.name||Text||Specifies a user-defined custom column name to store additional information in the table. If the column name contains non-alphanumeric characters, enclose the value in brackets, for example Custom.[Special column].|