Geospatial Uncategorised: Difference between revisions

From IMSMA Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
{{Note | The table is called ''geospatialinfo'' and it cannot have CDFs. <br/>
{{Note | The table is called ''geospatialinfo'' and it cannot have CDFs. The maXML element is [[Geospatialinfo Element|GeospatialInfo]]. <br/>
In the Data Inventory Manager it looks like that there are several [[Add a Poly Property | Polygon property]] fields but all of them are stored in the same column. Polygon/polyline property is used for showing the polygon/polyline with different colours.}}
In the Data Inventory Manager it looks like that there are several [[Add a Poly Property | Polygon property]] fields but all of them are stored in the same column. Polygon/polyline property is used for showing the polygon/polyline with different colours.}}


Line 16: Line 16:
| Shape type || Single-select ||  shapeenum_guid || Shape Type || Shape
| Shape type || Single-select ||  shapeenum_guid || Shape Type || Shape
|}
|}
|}
{| class="wikitable sortable"
{| class="wikitable sortable"
!  Enumcategory || Item || Comment
!  Enumcategory || Item || Comment
Line 44: Line 42:
|-
|-
| Poly Property Victim || Victim || have no values from the installation
| Poly Property Victim || Victim || have no values from the installation
|}
|}
|}



Latest revision as of 21:04, 19 June 2017

The table is called geospatialinfo and it cannot have CDFs. The maXML element is GeospatialInfo.

In the Data Inventory Manager it looks like that there are several Polygon property fields but all of them are stored in the same column. Polygon/polyline property is used for showing the polygon/polyline with different colours.

Function Data type Database column name Enumcategory Pojo name
Poly Property String poly_prop_enum_guid Depends on item PolyProp
Shape ID String shape_id ShapeId
Shape type Single-select shapeenum_guid Shape Type Shape
Enumcategory Item Comment
Poly Property Accident Accident have no values from the installation
Poly Property Hazard Reduction Activity
Poly Property Assistance Assistance have no values from the installation
Poly Property Country Structure Country structure
Poly Property MRE Education
Poly Property Hazard Land
Poly Property Location Location
Poly Property Organisation Organisation
Poly Property Place Place
Poly Property QA QM
Poly Property Task Task
Poly Property Victim Victim have no values from the installation

The Poly property enumeration values should be customised by the NMAA to fit the requirements in the Mine Action programme.

{{#switch:|subgroup|child=|none=|#default=

}}{{#if:|<td class="navbox-image " style="width:0%;padding:0px 2px 0px 0px;" rowspan={{#expr:1{{#if: Overview DEF

Data Entry Form  · Attachments|+2}}{{#if:Point Types

Geospatial  · Geopoint|+2}}{{#if:Task  · Work item  · Task Child Tables|+2}}{{#if:Assistance Classification  · Cause Classification  · Country Structure  · Needs Classification  · Ordnance Classification  · Organisation  · Places|+2}}{{#if:Enumeration categories  · Other tables  · Table differences between migrated and non-migrated databases|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}}}>
{{{imageleft}}}
}}{{#if:Item Data|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|{{#if:|<td class="navbox-image " style="width:0%;padding:0px 0px 0px 2px;" rowspan={{#expr:1{{#if: Overview DEF

Data Entry Form  · Attachments|+2}}{{#if:Point Types

Geospatial  · Geopoint|+2}}{{#if:Task  · Work item  · Task Child Tables|+2}}{{#if:Assistance Classification  · Cause Classification  · Country Structure  · Needs Classification  · Ordnance Classification  · Organisation  · Places|+2}}{{#if:Enumeration categories  · Other tables  · Table differences between migrated and non-migrated databases|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}}}>
{{{image}}}
}}}}{{#if: Overview DEF
Data Entry Form  · Attachments|{{#if:Data Dictionary{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:geospatial uncategorised

|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}|}}{{#if: DEFs| DEFs<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Overview DEF

Data Entry Form  · Attachments

}}{{#if:Point Types
Geospatial  · Geopoint|{{#if:Data Dictionary{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:geospatial uncategorised

|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}} Overview DEF

Data Entry Form  · Attachments|}}{{#if: Geo data| Geo data<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Point Types

Geospatial  · Geopoint

}}{{#if:Task  · Work item  · Task Child Tables|{{#if: Task | Task <td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Task  · Work item  · Task Child Tables

}}{{#if:Assistance Classification  · Cause Classification  · Country Structure  · Needs Classification  · Ordnance Classification  · Organisation  · Places|{{#if:Auxiliary Data|Auxiliary Data<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Assistance Classification  · Cause Classification  · Country Structure  · Needs Classification  · Ordnance Classification  · Organisation  · Places

}}{{#if:Enumeration categories  · Other tables  · Table differences between migrated and non-migrated databases|{{#if:Other|Other<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Enumeration categories  · Other tables  · Table differences between migrated and non-migrated databases

}}{{#if:|{{#if:|{{{group7}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list7}}}

}}{{#if:|{{#if:|{{{group8}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list8}}}

}}{{#if:|{{#if:|{{{group9}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list9}}}

}}{{#if:|{{#if:|{{{group10}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list10}}}

}}{{#if:|{{#if:|{{{group11}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list11}}}

}}{{#if:|{{#if:|{{{group12}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list12}}}

}}{{#if:|{{#if:|{{{group13}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list13}}}

}}{{#if:|{{#if:|{{{group14}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list14}}}

}}{{#if:|{{#if:|{{{group15}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list15}}}

}}{{#if:|{{#if:|{{{group16}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list16}}}

}}{{#if:|{{#if:|{{{group17}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list17}}}

}}{{#if:|{{#if:|{{{group18}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list18}}}

}}{{#if:|{{#if:|{{{group19}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list19}}}

}}{{#if:|{{#if:|{{{group20}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list20}}}

}}{{#if:|{{#if:Data Dictionary{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:geospatial uncategorised

|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}} Overview DEF
Data Entry Form  · AttachmentsPoint Types

Geospatial  · Geopoint|}}

{{{below}}}

}}{{#switch:|subgroup|child=

|none=|#default=}}{{#ifeq:|Template|{{#ifeq:|child||{{#ifeq:|subgroup||{{#switch:geospatial uncategorised
|doc
|sandbox
|testcases =
|#default = {{#switch:hlist
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}