GeoPoint (v1)
A geo located point (delivery address, customer, registration miss or driver track position) as used by the geo tools
| # | Field | Type | Description |
|---|---|---|---|
| 0 | pos | int | 1-based sequence number of the point within its tour / selection |
| 1 | label | string | human readable marker label (legacy geo/data.jsp format, e.g. '1: K123 Name,Street, Zip City (Tour)') |
| 2 | lat | double | latitude (0 if not geocoded) |
| 3 | lng | double | longitude (0 if not geocoded) |
| 4 | color | int | color group index: all points of the same tour (or calendar week for misses) share the same index, starting at 0 |
| 5 | openorder | bool | true if the customer has an outstanding open order on a future delivery date (tour selection only) |
| 6 | kind | string | source of the point: address, customer, miss or track |
| 7 | cid | int | customer id, 0 if not applicable |
| 8 | aid | int | delivery address id, 0 if not applicable |
| 9 | name | string | name on the address / customer |
| 10 | street | string | street and number |
| 11 | zip | string | zip code |
| 12 | city | string | city / locality |
| 13 | tour | string | tour identifier (tours.id) or the artificial set name (T0, T1.. / TX) for address id lists; empty if none |
| 14 | depot | int | number of addresses delivered via this depot address; 0 if this is not a depot |
| 15 | llq | int | geocoding quality (0..9, values >= 5 are considered good) |
| 16 | dt | datetime | timestamp of the point (registration misses and driver track positions only) |