Geospatial Uncategorised: Difference between revisions

From IMSMA Wiki
Jump to navigation Jump to search
Created page with "{{Note | The table is called ''geospatialinfo'' and it cannot have CDFs. }} {| |- valign="top" | 100px | {| class="wikitable sortable" ! DIM Label..."
 
No edit summary
Line 1: Line 1:
{{Note | The table is called ''geospatialinfo'' and it cannot have CDFs. }}
{{Note | The table is called ''geospatialinfo'' and it cannot have CDFs. <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.}}


{|
{|
Line 7: Line 8:
|
|
{| class="wikitable sortable"
{| class="wikitable sortable"
  ! DIM Label !! Data type !! Database column name !! Enumcategory !! Pojo name
  ! Funtion !! Data type !! Database column name !! Enumcategory !! Pojo name
|-
| Poly Property || String ||  poly_prop_enum_guid || Depending on Item || PolyProp
|-
| Shape ID || String ||  shape_id ||  || ShapeId
|-
| Shape type || Single-select ||  ShapeEnum_GUID || Shape Type || Shape
|}
|}
|}
There are the following enumeration value lists:
* Poly Property Accident (have no values from the installation)
* Poly Property Activity
* Poly Property Assistance (have no values from the installation)
* Poly Property Country Structure
* Poly Property Education
* Poly Property Land
* Poly Property Location
* Poly Property Organization
* Poly Property Place
* Poly Property Task
* Poly Property Victim (have no values from the installation)
* Poly Propery QM
The value lists should be customised by the NMAA.
{{NavBox Data Dictionary}}
{{NavBox Data Dictionary}}
[[Category:NAA]]
[[Category:NAA]]

Revision as of 18:25, 16 March 2016

The table is called geospatialinfo and it cannot have CDFs.

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.

Funtion Data type Database column name Enumcategory Pojo name
Poly Property String poly_prop_enum_guid Depending on Item PolyProp
Shape ID String shape_id ShapeId
Shape type Single-select ShapeEnum_GUID Shape Type Shape

There are the following enumeration value lists:

  • Poly Property Accident (have no values from the installation)
  • Poly Property Activity
  • Poly Property Assistance (have no values from the installation)
  • Poly Property Country Structure
  • Poly Property Education
  • Poly Property Land
  • Poly Property Location
  • Poly Property Organization
  • Poly Property Place
  • Poly Property Task
  • Poly Property Victim (have no values from the installation)
  • Poly Propery QM

The value lists should be customised by the NMAA.

{{#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 = 
 }}
}}

}}}}}}