Geopoint Uncategorised: Difference between revisions

Latest revision as of 10:20, 1 November 2018

	The table is called geopoint, the entity type is called GEOPOINT, the target is called Geopoint and the maXML element is GeospatialInfo. More information about geodata may be found here.

DIM Label	Data type	Database column name	Enumcategory	Pojo name	Comment
Bearing	Double	bearing		Bearing	Relative from the previous point
Coordinate Format	String	coordformat		CoordFormat
Coordinate System	String	coordrefsys		CoordRefSys
Distance (m)	Double	distance		Distance	Relative from the previous point
-	Double	elevation		Elevation
-	Single-select	fixedby_guid		FixedByGuid
-	Parent	frompoint_guid		FromPointGUID	Only used for relative points
-	String	geopoint_guid		Guid
-	Parent	geospatialinfo_guid		GeospatialInfoGuid
Y / Latitude	Double	latitude		Latitude	Storage format
X / Longitude	Double	longitude		Longitude
Point Description	Text	pointdescription		Description
Point ID	String	pointlocal_id		LocalId
Point Number	Integer	pointno		Number
Point Type	Single-select	pointtypeenum_guid	Point Type	Type
-	String	user_entered_mgrs		UserEnteredMGRS	What the user typed and used as input for the calculation of latitude/longitude
-	String	user_entered_x		UserEnteredX	What the user typed and used as input for the calculation of latitude/longitude
-	String	user_entered_y		UserEnteredY	What the user typed and used as input for the calculation of latitude/longitude
-	String	userinputformat		UserInputFormat	Controls how the coordinates will be shown in the DEF and Summary window

{{#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:geopoint 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:geopoint 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:geopoint uncategorised

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

}}}}}} Overview DEF
Data Entry Form · Attachments Point Types

Geospatial · Geopoint|}}

{{{below}}}

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

|none=|#default=}}{{#ifeq:|Template|{{#ifeq:|child||{{#ifeq:|subgroup||{{#switch:geopoint uncategorised

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

}}}}}}

@@ Line 1: / Line 1: @@
-{{Note | The table is called ''geopoint'' and the entity type is called ''???''. }}
+{{Note | The table is called ''geopoint'', the entity type is called ''GEOPOINT'', the target is called ''Geopoint'' and the maXML element is [[Geospatialinfo Element|GeospatialInfo]].<br>  More information about geodata may be found [[Summary Window#Data area - Geospatial tab | '''here''']].}}
 {|
 |- valign="top"
 |
-[[Image:Uncategorised.png|100px]]
+[[Image:Geo category.png|100px]]
 |
 {| class="wikitable sortable"
-  ! DIM Label !! Data type !! Database column name !! Enumcategory !! Pojo name
+  ! DIM Label !! Data type !! Database column name !! Enumcategory !! Pojo name !! Comment
 |-
-| Bearing || Double ||  Bearing ||  || Bearing
+| Bearing || Double ||  bearing ||  || Bearing || Relative from the previous point
 |-
-| Coordinate Format || String ||  coordformat ||  || CoordFormat
+| Coordinate Format || String ||  coordformat ||  || CoordFormat ||
 |-
-| Coordinate System || String ||  CoordRefSys ||  || CoordRefSys
+| Coordinate System || String ||  coordrefsys ||  || CoordRefSys ||
 |-
-| Distance (m) || Double ||  Distance ||  || Distance
+| Distance (m) || Double ||  distance ||  || Distance || Relative from the previous point
 |-
-| - || Double ||  Elevation ||  || Elevation
+| - || Double ||  elevation ||  || Elevation ||
 |-
-| - || Single-select ||  fixedby_guid ||  || FixedByGuid
+| - || Single-select ||  fixedby_guid ||  || FixedByGuid ||
 |-
-| - || Parent ||  FromPoint_GUID ||  || FromPointGUID
+| - || Parent ||  frompoint_guid ||  || FromPointGUID || Only used for relative points
 |-
-| - || String ||  GeoPoint_GUID ||  || Guid
+| - || String ||  geopoint_guid ||  || Guid ||
 |-
-| - || Parent ||  GeoSpatialInfo_GUID ||  || GeospatialInfoGuid
+| - || Parent ||  geospatialinfo_guid ||  || GeospatialInfoGuid ||
 |-
-| Y / Latitude || Double ||  Latitude ||  || Latitude
+| Y / Latitude || Double ||  latitude ||  || Latitude || Storage format
 |-
-| X / Longitude || Double ||  Longitude ||  || Longitude
+| X / Longitude || Double ||  longitude ||  || Longitude ||
 |-
-| Point Description || Text ||  PointDescription ||  || Description
+| Point Description || Text ||  pointdescription ||  || Description ||
 |-
-| Point ID || String ||  PointLocal_ID ||  || LocalId
+| Point ID || String ||  pointlocal_id ||  || LocalId ||
 |-
-| Point Number || Integer ||  PointNo ||  || Number
+| Point Number || Integer ||  pointno ||  || Number ||
 |-
-| Point Type || Single-select ||  PointTypeEnum_GUID ||  || Type
+| Point Type || Single-select ||  pointtypeenum_guid || Point Type || Type ||
 |-
-| - || String ||  user_entered_mgrs ||  || UserEnteredMGRS
+| - || String ||  user_entered_mgrs ||  || UserEnteredMGRS || What the user typed and used as input for the calculation of latitude/longitude
 |-
-| - || String ||  user_entered_x ||  || UserEnteredX
+| - || String ||  user_entered_x ||  || UserEnteredX || What the user typed and used as input for the calculation of latitude/longitude
 |-
-| - || String ||  user_entered_y ||  || UserEnteredY
+| - || String ||  user_entered_y ||  || UserEnteredY || What the user typed and used as input for the calculation of latitude/longitude
 |-
-| - || String ||  userinputformat ||  || UserInputFormat
+| - || String ||  userinputformat ||  || UserInputFormat || Controls how the coordinates will be shown in the DEF and Summary window
 |}
 |}
 {{NavBox Data Dictionary}}
 [[Category:NAA]]

Geopoint Uncategorised: Difference between revisions

Latest revision as of 10:20, 1 November 2018

Navigation menu

Search