NoPublic, bureaucrat, administrator
1,068
edits
Changes
no edit summary
===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.):
* '''<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)
** '''lat:''' latitude
** '''coordinate_format:''' e.g. "Decimal Degrees"
** '''shape:''' PostGIS-representation of the shape that can be accessed with a PostGIS query
* '''<OBJECT>_POLYLINE:'''* '''<OBJECT>_POLYGON:'''
===Views===__NOEDITSECTION__NOEDITSECTION__
==Geographical data in the staging area==__NOEDITSECTION__
