NoPublic, bureaucrat, administrator
1,068
edits
Changes
no edit summary
|-
| align="left" | '''Place data'''
| align="left" | The guid, localid and name of the place linked to an object are directly stored in the main object table.| align="left" | TODOThe HAZARD table in the staging are has the columns ammunition_storage_localid and ammunition_storage_name that refer to a place object.
|-
| align="left" | '''Classification data (Country structure, Assistance Classification, Cause Classification and Needs Assessment Classification)'''
** '''coordinate_format:''' e.g. "Decimal Degrees"
** '''shape:''' PostGIS-representation of the shape that can be accessed with a PostGIS query
* '''<OBJECT>_POLYLINE:'''contains all the data related to polylines defined on the object. The individual points making up the polyline are stored in the <OBJECT>_POINT table, but the polyline object is additionally stored in the <OBJECT>_POLYLINE table. The main column is '''shape''', a PostGIS-representation of the shape that can be accessed with a PostGIS query.* '''<OBJECT>_POLYGON:'''similar to <OBJECT>_POLYLINE, but for polygon objects.
===Views===__NOEDITSECTION__