NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
When data has been migrated or imported it is possible that the column userinputformat in the table ''geopoint'', which controls coordinate display, has not been set correctly. When the display field is set correctly the columns are high-lighted with yellow. If the user tries to edit a row which does not have one of the rules set, the coordinates will not be populated in the Point window. This issue only affects the edit of Auxiliary data coordinates and Data Entry Forms in the Workbench [[Coordinate display rules|(query)]].
{| class="wikitable"| align="center" style="background:#f0f0f0;"|'''coordrefsys'''| align="center" style="background:#f0f0f0;"|'''coordformat'''| align="center" style="background:#f0f0f0;"|'''userinputformat'''| align="center" style="background:#f0f0f0;"|'''userenteredcoord'''|-| MGRS||MGRS||MGRS||<nowiki> 18NXL0251208301|en|GB|</nowiki>|-| MGRS||MGRS||Bearing and distance||<nowiki> 18NXL0251208301|en|GB|</nowiki>|-| UTM||X/Y||X and Y||<nowiki> 508301|602512|en|GB|</nowiki>|-| UTM||X/Y||Bearing and distance||<nowiki> 508301|602512|en|GB|</nowiki>|-| WGS 1984||Decimal Degrees||X and Y||<nowiki> -74.07584|4.59806|en|GB|</nowiki>|-| WGS 1984||Decimal Degrees||Bearing and distance||<nowiki> -74.07584|4.59806|en|GB|</nowiki>|-| WGS 1984||Degrees:Decimal Minutes||X and Y||<nowiki> -74:04.55040|004:35.88360|en|GB|</nowiki>|-| WGS 1984||Degrees:Decimal Minutes||Bearing and distance||<nowiki> -74:04.55040|004:35.88360|en|GB|</nowiki>|-| WGS 1984||Degrees:Minutes:Seconds||X and Y||<nowiki> -74:4:33.0234|4:35:53.016|en|GB|</nowiki>|-| WGS 1984||Degrees:Minutes:Seconds||Bearing and distance||<nowiki>-74:4:33.0234|4:35:53.016|en|GB|</nowiki>|}{{Note | * The real values of Distance and Bearing are stored in other columns then the ones above and what is stored in ''userenteredcoord'' is in the same format as the '''first''' point* In V6.0 ''userenteredcoord'' is replaced by three different columns (user_entered_x, user_entered_y and user_entered_mgrs) without the locale part}} The three fields ''coordrefsys'', ''coordformat '' and ''userinputformat '' '''must ''' be in a valid combination AND '''andmust''' must be consistent with the value of userenteredcoord e.g. (WGS 84, Degrees:Minutes:Seconds, X and Y) with 17.2345|25.5678|en|UK is '''not ''' a valid combination. If these records invalid combinations are not corrected the area/length recalculation and the upgrade will not work [[Coordinate display rules|(query)]].
===Length of Point ID===__NOEDITSECTION__