Places Uncategorised: Difference between revisions

From IMSMA Wiki
Jump to navigation Jump to search
Created page with "{{Note | The Place table is called ''place'' and the entity is called ''Place''.}} {| |- valign="top" | 100px | {| class="wikitable sortable" ! D..."
 
No edit summary
Line 9: Line 9:
  ! DIM Label !! Data type !! Database column name !! Enumcategory !! Pojo name
  ! DIM Label !! Data type !! Database column name !! Enumcategory !! Pojo name
|-
|-
| -||String|| Place_GUID||||Guid
| -||String|| place_guid||||Guid
|-
|-
| Address||Text|| PlaceAddress||||Address
| Address||Text|| placeaddress||||Address
|-
|-
| Country Structure||Country Structure|| Gazetteer_GUID||||Gazetteer
| Country Structure||Country Structure|| gazetteer_guid||||Gazetteer
|-
|-
| Description||Text|| PlaceDescription||||Description
| Description||Text|| placedescription||||Description
|-
|-
| Name||Text|| PlaceName||||Name
| Name||Text|| placename||||Name
|-
|-
| Place ID||String|| Place_LocalID||||LocalId
| Place ID||String|| place_localid||||LocalId
|-
|-
| Type||Single-select|| PlaceTypeEnum_GUID||Place Type||Type
| Type||Single-select|| placetypeenum_guid||Place Type||Type


|}
|}

Revision as of 12:40, 15 October 2016

The Place table is called place and the entity is called Place.

DIM Label Data type Database column name Enumcategory Pojo name
- String place_guid Guid
Address Text placeaddress Address
Country Structure Country Structure gazetteer_guid Gazetteer
Description Text placedescription Description
Name Text placename Name
Place ID String place_localid LocalId
Type Single-select placetypeenum_guid Place Type Type

{{#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:places 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:places 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:places 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:places uncategorised
|doc
|sandbox
|testcases =
|#default = {{#switch:hlist
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}