NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
For more on column names in the Staging area, see [[Name Rules Staging Area]], and for post-processing, see [[Post Processing SQL Scripts]].
===Special table===__NOEDITSECTION__
{| class="wikitable" width="1000'"
===Point, Polyline and Polygon tables===__NOEDITSECTION__
If the option of generating geodata has been chosen on the [[Staging Area Generator]] interface, then three related tables with geodata are generated for every main object/table (ACCIDENT, VICTIM, QM, HAZARD (Land), etc.)that has geographical information:* xx_point* xx_polygon* xx_polyline The tables contain special geographical columns:
* '''<OBJECT>_POINT:''' contains all the data related to points defined on the object, with the following main information:
** '''point_type:''' e.g. Benchmark, Landmark, Turning Point (all points making up a polygon are also recorded in this table)
{{NavBox Business Intelligence}}
[[Category:VIENAA]]
