This is a lookup table carrying information about the destination on signposts.
Field Name | Data Type (Length) | Index | Description |
---|---|---|---|
SIGNPOSTID | CHAR (36) | No | Unique identifier |
STREETID | CHAR (36) | No | ID of the related street object |
DESTINATIONSET | INTEGER | No | Position of one functional unit of destination information on a signpost |
DESTINATIONSEQ | INTEGER | No | Destination set sequence number |
CONNECTION | INTEGER | No | Code indicating if the destination is a route name,
place/attraction, or an exit: 1 - Route name 2 - Place or attraction 3 - Exit |
STREETSEQ | INTEGER | No | Street set sequence number |
DESTINATIONNAME | CHAR (36) | No | Destination name |