14.1 sp840_planner_map_text

This table holds text labels that are to be rendered onto map images. The data may be transitory, in which case ServicePlanner will take responsibility for tidy-up, or long-lived, in which case the text will remain in the database until tidied by a system administrator. The text data is grouped according to the pair of columns (user_id, group_index). ServicePlanner will map grouped text in the same style, remove them as a group and display either all the text in a group or not at all.

Table Definition

Field	Type	Default	Nullable
postcode	varchar2(30)
user_id	varchar2(50)
group_index	number(2,0)
longitude	float(126)
latitude	float(126)
text	varchar2(50)
time_stamp	date

Keys

primary key (postcode,user_id,group_index)

Column Descriptions

Field	Description
postcode	Reference that was used to look-up location in the map data - typically a postal code.
user_id	Identifies the user. This is either the session id for transient data or, for added user-data, the name of the user-data followed by # and the name of the geography to map against.
group_index	Index that groups text labels for the user_id.
longitude	Coordinate to draw text label at (coord system WSG84).
longitude	Coordinate to draw text label at (coord system WSG84).
text	Text to write onto the map.
time_stamp	Date and time that entry was made into the database.