| align="center" colspan="3" | '''Where to find which data in the IMSMA staging area'''
|-
| width="150pt" | '''Type of attribute'''
===Database model===__NOEDITSECTION__
A simplified IMSMA staging area database model for the Land (Hazard) object is depicted below. For all the other main objects, the model looks very similar.
For more on column names in the Staging area, see [[Name Rules Staging Area]], and for post-processing, see [[Post Processing SQL Scripts]].
The {{IMSMANG}} database is described '''[[Data Dictionary | here]]'''. The columns names are not always identical in the Staging area database but very similar.
Some of the main item changed names in 6.0 but table names did not change:
* Land = hazard
* Activity = hazreduc
* Education = mre
* QM = qa
===Special table===__NOEDITSECTION__
{| class="wikitable" width="1000'"
|-
|}
==Geographical data in the IMSMA staging area==__NOEDITSECTION__
{{Under construction| This section is under construction}}
When polygon/polyline is linked with the main object the properties from the main object applies to the entire object. This also applies to calculated area and length e.g. if Land-35 has three polygons with (total) calculated area 200 m2 then 200 is repeated on the three polygon rows.
===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)
A series of database views are pre-defined on the staging area, three for each object: <OBJECT>_POINT_VIEW, <OBJECT>_POLYGON_VIEW and <OBJECT>_POLYLINE_VIEW - where <OBJECT> is HAZARD, GAZETTEER, MRE, etc. - each object that potentially has associated geodata. Each view is defined as an '''INNER JOIN''' between the <OBJECT> table, e.g. HAZARD, and each of the three geodata tables. The inner join means that data from e.g. the HAZARD table that has '''no''' polygon associated will not be found in the HAZARD_POLYGON_VIEW. Depending on the use case, either the tables or the views can be accessed.
==Geographical data in the staging area==__NOEDITSECTION__{{Under construction| This section is under construction}} When polygon/polyline is linked with the main object the properties from the main object applies to the entire object. This also applies to calculated area and length e.g. if Land-35 has three polygons with (total) calculated area 200 m2 then 200 is repeated on the three polygon rows.