Space coordinates: Difference between revisions

From IMSMA Wiki
Jump to navigation Jump to search
← Older edit
No edit summary
No edit summary
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{note| This query is in 5.x format}}
This query finds invalid / space coordinates. The invalid coordinates need to be corrected.
This query finds invalid / space coordinates. The invalid coordinates need to be corrected.
<pre>
<pre>
Line 21: Line 20:
<pre>
<pre>
SELECT
SELECT
fieldreport.fieldreport_localid,
locationinfoversion.location_localid,
geopoint.longitude,
geopoint.longitude,
geopoint.latitude,
geopoint.latitude,
locationinfoversion.location_localid
geopoint.userenteredcoord
FROM
FROM
fieldreport
geopoint
Inner Join geopoint
INNER JOIN locationinfoversion_has_geospatialinfo ON locationinfoversion_has_geospatialinfo.geospatialinfo_guid = geopoint.geospatialinfo_guid
Inner Join locationinfoversion ON locationinfoversion.fieldreport_guid = fieldreport.fieldreport_guid
INNER JOIN locationinfoversion ON locationinfoversion_has_geospatialinfo.locationinfoversion_guid = locationinfoversion.locationinfoversion_guid
Inner Join locationinfoversion_has_geospatialinfo ON locationinfoversion_has_geospatialinfo.locationinfoversion_guid = locationinfoversion.locationinfoversion_guid AND locationinfoversion_has_geospatialinfo.geospatialinfo_guid = geopoint.geospatialinfo_guid
WHERE
WHERE
geopoint.longitude >  '180' OR
geopoint.longitude >  '180' OR
geopoint.latitude >  '90' OR
geopoint.latitude >  '90' OR
geopoint.longitude <  '-180' OR
geopoint.longitude <  '-180' OR
geopoint.latitude <  '-90'
geopoint.latitude <  '-90' OR
geopoint.latitude IS NULL OR
geopoint.longitude IS NULL OR
geopoint.userenteredcoord IS NULL
</pre>
</pre>


Line 40: Line 41:
<pre>
<pre>
SELECT
SELECT
fieldreport.fieldreport_localid,
hazardinfoversion.hazard_localid,
geopoint.longitude,
geopoint.longitude,
geopoint.latitude,
geopoint.latitude,
hazardinfoversion.hazard_localid
geopoint.userenteredcoord
FROM
FROM
fieldreport
geopoint
Inner Join geopoint
INNER JOIN hazardinfoversion_has_geospatialinfo ON hazardinfoversion_has_geospatialinfo.geospatialinfo_guid = geopoint.geospatialinfo_guid
Inner Join hazardinfoversion ON hazardinfoversion.fieldreport_guid = fieldreport.fieldreport_guid
INNER JOIN hazardinfoversion ON hazardinfoversion_has_geospatialinfo.hazardinfoversion_guid = hazardinfoversion.hazardinfoversion_guid
Inner Join hazardinfoversion_has_geospatialinfo ON hazardinfoversion_has_geospatialinfo.geospatialinfo_guid = geopoint.geospatialinfo_guid AND hazardinfoversion_has_geospatialinfo.hazardinfoversion_guid = hazardinfoversion.hazardinfoversion_guid
WHERE
WHERE
geopoint.longitude >  '80' OR
geopoint.longitude >  '80' OR
geopoint.latitude >  '90' OR
geopoint.latitude >  '90' OR
geopoint.longitude <  '-180' OR
geopoint.longitude <  '-180' OR
geopoint.latitude <  '-90'
geopoint.latitude <  '-90' OR
geopoint.latitude IS NULL OR
geopoint.longitude IS NULL OR
geopoint.userenteredcoord IS NULL
</pre>
</pre>


Line 59: Line 62:
<pre>
<pre>
SELECT
SELECT
fieldreport.fieldreport_localid,
hazreducinfoversion.hazreduc_localid,
geopoint.longitude,
geopoint.longitude,
geopoint.latitude,
geopoint.latitude,
hazreducinfoversion.hazreduc_localid
geopoint.userinputformat
FROM
FROM
fieldreport
geopoint
Inner Join geopoint
INNER JOIN hazreducinfoversion_has_geospatialinfo ON hazreducinfoversion_has_geospatialinfo.geospatialinfo_guid = geopoint.geospatialinfo_guid
Inner Join hazreducinfoversion ON hazreducinfoversion.fieldreport_guid = fieldreport.fieldreport_guid
INNER JOIN hazreducinfoversion ON hazreducinfoversion.hazreducinfoversion_guid = hazreducinfoversion_has_geospatialinfo.hazreducinfoversion_guid
Inner Join hazreducinfoversion_has_geospatialinfo ON hazreducinfoversion_has_geospatialinfo.hazreducinfoversion_guid = hazreducinfoversion.hazreducinfoversion_guid AND hazreducinfoversion_has_geospatialinfo.geospatialinfo_guid = geopoint.geospatialinfo_guid
WHERE
WHERE
geopoint.longitude >  '180' OR
geopoint.longitude >  '180' OR
geopoint.latitude >  '90' OR
geopoint.latitude >  '90' OR
geopoint.longitude <  '-180' OR
geopoint.longitude <  '-180' OR
geopoint.latitude <  '-90'
geopoint.latitude <  '-90' OR
geopoint.latitude IS NULL OR
geopoint.longitude IS NULL OR
geopoint.userenteredcoord IS NULL
</pre>
</pre>


Line 79: Line 84:
SELECT
SELECT
accidentinfoversion.accident_localid,
accidentinfoversion.accident_localid,
fieldreport.fieldreport_localid,
geopoint.longitude,
geopoint.longitude,
geopoint.latitude
geopoint.latitude
FROM
FROM
accidentinfoversion
accidentinfoversion
Inner Join accidentinfoversion_has_geospatialinfo ON accidentinfoversion.accidentinfoversion_guid = accidentinfoversion_has_geospatialinfo.accidentinfoversion_guid
INNER JOIN accidentinfoversion_has_geospatialinfo ON accidentinfoversion.accidentinfoversion_guid = accidentinfoversion_has_geospatialinfo.accidentinfoversion_guid
Inner Join fieldreport ON accidentinfoversion.fieldreport_guid = fieldreport.fieldreport_guid
INNER JOIN geopoint ON accidentinfoversion_has_geospatialinfo.geospatialinfo_guid = geopoint.geospatialinfo_guid
Inner Join geopoint ON accidentinfoversion_has_geospatialinfo.geospatialinfo_guid = geopoint.geospatialinfo_guid
WHERE
WHERE
geopoint.longitude >  '180' OR
geopoint.longitude >  '180' OR
geopoint.latitude >  '90' OR
geopoint.latitude >  '90' OR
geopoint.longitude <  '-180' OR
geopoint.longitude <  '-180' OR
geopoint.latitude <  '-90'
geopoint.latitude <  '-90' OR
geopoint.latitude IS NULL OR
geopoint.longitude IS NULL OR
geopoint.userenteredcoord IS NULL
</pre>
</pre>


Line 97: Line 103:
<pre>
<pre>
SELECT
SELECT
fieldreport.fieldreport_localid,
victiminfoversion.victim_localid,
geopoint.longitude,
geopoint.longitude,
geopoint.latitude,
geopoint.latitude,
victiminfoversion.victim_localid
geopoint.userenteredcoord
FROM
FROM
fieldreport
geopoint
Inner Join geopoint
INNER JOIN victiminfoversion_has_geospatialinfo ON victiminfoversion_has_geospatialinfo.geospatialinfo_guid = geopoint.geospatialinfo_guid
Inner Join victiminfoversion ON victiminfoversion.fieldreport_guid = fieldreport.fieldreport_guid
INNER JOIN victiminfoversion ON victiminfoversion.victiminfoversion_guid = victiminfoversion_has_geospatialinfo.victiminfoversion_guid
Inner Join victiminfoversion_has_geospatialinfo ON victiminfoversion_has_geospatialinfo.victiminfoversion_guid = victiminfoversion.victiminfoversion_guid AND victiminfoversion_has_geospatialinfo.geospatialinfo_guid = geopoint.geospatialinfo_guid
WHERE
WHERE
geopoint.longitude >  '180' OR
geopoint.longitude >  '180' OR
geopoint.latitude >  '90' OR
geopoint.latitude >  '90' OR
geopoint.longitude <  '-180' OR
geopoint.longitude <  '-180' OR
geopoint.latitude <  '-90'
geopoint.latitude <  '-90' OR
geopoint.latitude IS NULL OR
geopoint.longitude IS NULL OR
geopoint.userenteredcoord IS NULL
</pre>
</pre>
<pre>


'''MRE'''
'''MRE'''
</pre>
<pre>
SELECT
SELECT
fieldreport.fieldreport_localid,
mreinfoversion.mre_localid,
geopoint.longitude,
geopoint.longitude,
geopoint.latitude,
geopoint.latitude,
mreinfoversion.mre_localid
geopoint.userenteredcoord
FROM
FROM
fieldreport
geopoint
Inner Join geopoint
INNER JOIN mreinfoversion_has_geospatialinfo ON mreinfoversion_has_geospatialinfo.geospatialinfo_guid = geopoint.geospatialinfo_guid
Inner Join mreinfoversion ON mreinfoversion.fieldreport_guid = fieldreport.fieldreport_guid
INNER JOIN mreinfoversion ON mreinfoversion.mreinfoversion_guid = mreinfoversion_has_geospatialinfo.mreinfoversion_guid
Inner Join mreinfoversion_has_geospatialinfo ON mreinfoversion.mreinfoversion_guid = mreinfoversion_has_geospatialinfo.mreinfoversion_guid AND mreinfoversion_has_geospatialinfo.geospatialinfo_guid = geopoint.geospatialinfo_guid
WHERE
WHERE
geopoint.longitude >  '180' OR
geopoint.longitude >  '180' OR
geopoint.latitude >  '90' OR
geopoint.latitude >  '90' OR
geopoint.longitude <  '-180' OR
geopoint.longitude <  '-180' OR
geopoint.latitude <  '-90'
geopoint.latitude <  '-90' OR
geopoint.latitude IS NULL OR
geopoint.longitude IS NULL OR
geopoint.userenteredcoord IS NULL
</pre>


'''QM'''
'''QM'''
<pre>
<pre>
SELECT
SELECT
fieldreport.fieldreport_localid,
qainfoversion.qa_localid,
geopoint.longitude,
geopoint.longitude,
geopoint.latitude,
geopoint.latitude,
qainfoversion.qa_localid
geopoint.userenteredcoord
FROM
FROM
fieldreport
geopoint
Inner Join geopoint
INNER JOIN qainfoversion_has_geospatialinfo ON qainfoversion_has_geospatialinfo.geospatialinfo_guid = geopoint.geospatialinfo_guid
Inner Join qainfoversion ON fieldreport.fieldreport_guid = qainfoversion.fieldreport_guid
INNER JOIN qainfoversion ON qainfoversion.qainfoversion_guid = qainfoversion_has_geospatialinfo.qainfoversion_guid
Inner Join qainfoversion_has_geospatialinfo ON qainfoversion.qainfoversion_guid = qainfoversion_has_geospatialinfo.qainfoversion_guid AND qainfoversion_has_geospatialinfo.geospatialinfo_guid = geopoint.geospatialinfo_guid
WHERE
WHERE
geopoint.longitude >  '180' OR
geopoint.longitude >  '180' OR
geopoint.latitude >  '90' OR
geopoint.latitude >  '90' OR
geopoint.longitude <  '-180' OR
geopoint.longitude <  '-180' OR
geopoint.latitude <  '-90'
geopoint.latitude <  '-90' OR
geopoint.latitude IS NULL OR
geopoint.longitude IS NULL OR
geopoint.userenteredcoord IS NULL
</pre>
</pre>


Line 167: Line 179:
geopoint.longitude <  '-180' OR
geopoint.longitude <  '-180' OR
geopoint.latitude >  '90' OR
geopoint.latitude >  '90' OR
geopoint.latitude <  '-90'
geopoint.latitude <  '-90' OR
geopoint.latitude IS NULL OR
geopoint.longitude IS NULL OR
geopoint.userenteredcoord IS NULL
</pre>
</pre>


Line 186: Line 201:
geopoint.longitude <  '-180' OR
geopoint.longitude <  '-180' OR
geopoint.latitude >  '90' OR
geopoint.latitude >  '90' OR
geopoint.latitude <  '-90'
geopoint.latitude <  '-90' OR
geopoint.latitude IS NULL OR
geopoint.longitude IS NULL OR
geopoint.userenteredcoord IS NULL
</pre>
</pre>


Line 205: Line 223:
geopoint.longitude <  '-180' OR
geopoint.longitude <  '-180' OR
geopoint.latitude >  '90' OR
geopoint.latitude >  '90' OR
geopoint.latitude <  '-90'
geopoint.latitude <  '-90' OR
geopoint.latitude IS NULL OR
geopoint.longitude IS NULL OR
geopoint.userenteredcoord IS NULL
</pre>
</pre>


Line 224: Line 245:
geopoint.longitude <  '-180' OR
geopoint.longitude <  '-180' OR
geopoint.latitude >  '90' OR
geopoint.latitude >  '90' OR
geopoint.latitude <  '-90'
geopoint.latitude <  '-90' OR
geopoint.latitude IS NULL OR
geopoint.longitude IS NULL OR
geopoint.userenteredcoord IS NULL
</pre>
</pre>


Latest revision as of 19:54, 9 March 2016

This query finds invalid / space coordinates. The invalid coordinates need to be corrected. 

SELECT 
geopoint.pointlocal_id, geopoint.pointno, geopoint.longitude, geopoint.latitude, geopoint.userenteredcoord
FROM
geopoint
INNER JOIN geospatialinfo ON geospatialinfo.geospatialinfo_guid = geopoint.geospatialinfo_guid
WHERE geopoint.longitude >  '180' OR 
geopoint.longitude <  '-180' OR
geopoint.latitude >  '90' OR 
geopoint.latitude <  '-90' OR 
geopoint.latitude IS NULL OR 
geopoint.longitude IS NULL OR 
geopoint.userenteredcoord IS NULL
If you get a result set from the query above the following queries will help you to identify to which object they belong.

Location 

SELECT
locationinfoversion.location_localid,
geopoint.longitude,
geopoint.latitude,
geopoint.userenteredcoord
FROM
geopoint
INNER JOIN locationinfoversion_has_geospatialinfo ON locationinfoversion_has_geospatialinfo.geospatialinfo_guid = geopoint.geospatialinfo_guid
INNER JOIN locationinfoversion ON locationinfoversion_has_geospatialinfo.locationinfoversion_guid = locationinfoversion.locationinfoversion_guid
WHERE
geopoint.longitude >  '180' OR
geopoint.latitude >  '90' OR
geopoint.longitude <  '-180' OR
geopoint.latitude <  '-90' OR 
geopoint.latitude IS NULL OR 
geopoint.longitude IS NULL OR 
geopoint.userenteredcoord IS NULL

Hazard 

SELECT
hazardinfoversion.hazard_localid,
geopoint.longitude,
geopoint.latitude,
geopoint.userenteredcoord
FROM
geopoint
INNER JOIN hazardinfoversion_has_geospatialinfo ON hazardinfoversion_has_geospatialinfo.geospatialinfo_guid = geopoint.geospatialinfo_guid
INNER JOIN hazardinfoversion ON hazardinfoversion_has_geospatialinfo.hazardinfoversion_guid = hazardinfoversion.hazardinfoversion_guid
WHERE
geopoint.longitude >  '80' OR
geopoint.latitude >  '90' OR
geopoint.longitude <  '-180' OR
geopoint.latitude <  '-90' OR 
geopoint.latitude IS NULL OR 
geopoint.longitude IS NULL OR 
geopoint.userenteredcoord IS NULL

Hazard Reduction 

SELECT
hazreducinfoversion.hazreduc_localid,
geopoint.longitude,
geopoint.latitude,
geopoint.userinputformat
FROM
geopoint
INNER JOIN hazreducinfoversion_has_geospatialinfo ON hazreducinfoversion_has_geospatialinfo.geospatialinfo_guid = geopoint.geospatialinfo_guid
INNER JOIN hazreducinfoversion ON hazreducinfoversion.hazreducinfoversion_guid = hazreducinfoversion_has_geospatialinfo.hazreducinfoversion_guid
WHERE
geopoint.longitude >  '180' OR
geopoint.latitude >  '90' OR
geopoint.longitude <  '-180' OR
geopoint.latitude <  '-90' OR 
geopoint.latitude IS NULL OR 
geopoint.longitude IS NULL OR 
geopoint.userenteredcoord IS NULL

Accident 

SELECT
accidentinfoversion.accident_localid,
geopoint.longitude,
geopoint.latitude
FROM
accidentinfoversion
INNER JOIN accidentinfoversion_has_geospatialinfo ON accidentinfoversion.accidentinfoversion_guid = accidentinfoversion_has_geospatialinfo.accidentinfoversion_guid
INNER JOIN geopoint ON accidentinfoversion_has_geospatialinfo.geospatialinfo_guid = geopoint.geospatialinfo_guid
WHERE
geopoint.longitude >  '180' OR
geopoint.latitude >  '90' OR
geopoint.longitude <  '-180' OR
geopoint.latitude <  '-90' OR 
geopoint.latitude IS NULL OR 
geopoint.longitude IS NULL OR 
geopoint.userenteredcoord IS NULL

Victim 

SELECT
victiminfoversion.victim_localid,
geopoint.longitude,
geopoint.latitude,
geopoint.userenteredcoord
FROM
geopoint
INNER JOIN victiminfoversion_has_geospatialinfo ON victiminfoversion_has_geospatialinfo.geospatialinfo_guid = geopoint.geospatialinfo_guid
INNER JOIN victiminfoversion ON victiminfoversion.victiminfoversion_guid = victiminfoversion_has_geospatialinfo.victiminfoversion_guid
WHERE
geopoint.longitude >  '180' OR
geopoint.latitude >  '90' OR
geopoint.longitude <  '-180' OR
geopoint.latitude <  '-90' OR 
geopoint.latitude IS NULL OR 
geopoint.longitude IS NULL OR 
geopoint.userenteredcoord IS NULL

MRE 

SELECT
mreinfoversion.mre_localid,
geopoint.longitude,
geopoint.latitude,
geopoint.userenteredcoord
FROM
geopoint
INNER JOIN mreinfoversion_has_geospatialinfo ON mreinfoversion_has_geospatialinfo.geospatialinfo_guid = geopoint.geospatialinfo_guid
INNER JOIN mreinfoversion ON mreinfoversion.mreinfoversion_guid = mreinfoversion_has_geospatialinfo.mreinfoversion_guid
WHERE
geopoint.longitude >  '180' OR
geopoint.latitude >  '90' OR
geopoint.longitude <  '-180' OR
geopoint.latitude <  '-90' OR 
geopoint.latitude IS NULL OR 
geopoint.longitude IS NULL OR 
geopoint.userenteredcoord IS NULL

QM 

SELECT
qainfoversion.qa_localid,
geopoint.longitude,
geopoint.latitude,
geopoint.userenteredcoord
FROM
geopoint
INNER JOIN qainfoversion_has_geospatialinfo ON qainfoversion_has_geospatialinfo.geospatialinfo_guid = geopoint.geospatialinfo_guid
INNER JOIN qainfoversion ON qainfoversion.qainfoversion_guid = qainfoversion_has_geospatialinfo.qainfoversion_guid
WHERE
geopoint.longitude >  '180' OR
geopoint.latitude >  '90' OR
geopoint.longitude <  '-180' OR
geopoint.latitude <  '-90' OR 
geopoint.latitude IS NULL OR 
geopoint.longitude IS NULL OR 
geopoint.userenteredcoord IS NULL

Country Structure 

SELECT
gazetteer.gazetteername,
geopoint.pointno,
geopoint.longitude,
geopoint.latitude
FROM
geopoint
Inner Join geospatialinfo ON geospatialinfo.geospatialinfo_guid = geopoint.geospatialinfo_guid
Inner Join gazetteer_has_geospatialinfo ON geospatialinfo.geospatialinfo_guid = gazetteer_has_geospatialinfo.geospatialinfo_guid
Inner Join gazetteer ON gazetteer.gazetteer_guid = gazetteer_has_geospatialinfo.gazetteer_guid
WHERE
geopoint.longitude >  '180' OR
geopoint.longitude <  '-180' OR
geopoint.latitude >  '90' OR
geopoint.latitude <  '-90' OR 
geopoint.latitude IS NULL OR 
geopoint.longitude IS NULL OR 
geopoint.userenteredcoord IS NULL

Organisation 

SELECT
organisation.orgname,
geopoint.pointno,
geopoint.longitude,
geopoint.latitude
FROM
geopoint
Inner Join geospatialinfo ON geospatialinfo.geospatialinfo_guid = geopoint.geospatialinfo_guid
Inner Join organisation_has_geospatialinfo ON organisation_has_geospatialinfo.geospatialinfo_guid = geospatialinfo.geospatialinfo_guid
Inner Join organisation ON organisation.org_guid = organisation_has_geospatialinfo.org_guid
WHERE
geopoint.longitude >  '180' OR
geopoint.longitude <  '-180' OR
geopoint.latitude >  '90' OR
geopoint.latitude <  '-90' OR 
geopoint.latitude IS NULL OR 
geopoint.longitude IS NULL OR 
geopoint.userenteredcoord IS NULL

Place 

SELECT
place.placename,
geopoint.pointno,
geopoint.longitude,
geopoint.latitude
FROM
geopoint
Inner Join geospatialinfo ON geospatialinfo.geospatialinfo_guid = geopoint.geospatialinfo_guid
Inner Join place_has_geospatialinfo ON place_has_geospatialinfo.geospatialinfo_guid = geospatialinfo.geospatialinfo_guid
Inner Join place ON place.place_guid = place_has_geospatialinfo.place_guid
WHERE
geopoint.longitude >  '180' OR
geopoint.longitude <  '-180' OR
geopoint.latitude >  '90' OR
geopoint.latitude <  '-90' OR 
geopoint.latitude IS NULL OR 
geopoint.longitude IS NULL OR 
geopoint.userenteredcoord IS NULL

Task 

SELECT
task.name,
geopoint.pointno,
geopoint.longitude,
geopoint.latitude
FROM
geopoint
Inner Join geospatialinfo ON geospatialinfo.geospatialinfo_guid = geopoint.geospatialinfo_guid
Inner Join task_has_geospatialinfo ON geospatialinfo.geospatialinfo_guid = task_has_geospatialinfo.geospatialinfo_guid
Inner Join task ON task_has_geospatialinfo.task_guid = task.guid
WHERE
geopoint.longitude >  '180' OR
geopoint.longitude <  '-180' OR
geopoint.latitude >  '90' OR
geopoint.latitude <  '-90' OR 
geopoint.latitude IS NULL OR 
geopoint.longitude IS NULL OR 
geopoint.userenteredcoord IS NULL

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

}}{{#if:|}}{{#if:Upgrade Process|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|{{#if:|}}}}{{#if:|{{#if:IMSMA Hub{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=
}}{{#if:IMSMA Hub|{{#if:|<th scope="col" style="border-left:2px solid #fdfdfd;width:100%;|}}{{#if:|{{#if:IMSMA Hub|}}}}{{#if:{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=
{{{above}}}
}}{{#if:|{{#if:|<th scope="col" style="border-left:2px solid #fdfdfd;width:100%;|}}{{#if:|{{#if:|}}}}{{#if:IMSMA3 script changes 6.0|{{#if:|}}{{#if:|}}{{#if:{{#if:Implementation plan|}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|{{#if:|}}}}{{#if:Space coordinates · MGRS coordinates · Coordinate display rules · Point ID Length · Location point · Missing approval information · Missing Date of Information · Missing Local ID · SQL Templates · DIM Categories · Enum categories and values · Duplicate Enumvalue SQL · Translations · CDF display format · CDF missing in field · Duplicate CDF · Multi-select CDFs · CDF not used · Empty CDF · Duplicate allow value · Link invalid date · Attachment SQL · Country structure orphans · Country structure duplicates · Unknown device Accident · Update isactive · Data QA - Duplicates · Data QA - No geo data · Data QA - No links · Data QA - Different Locations · Data QA - Task · Data QA - MA Process|{{#if:IMSMA3 script changes 6.0|}}{{#if:{{#if:Data quality checks before upgrading to V6.0|}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:Locale Pre-check SQL · Used DEF template SQL · Imsmaenum Duplicate fix · Imsmaenum Duplicate fix Part 2 · Inactive enumvalue fix · Translation Duplicate fix · Check Detection Sample Sector VegetationRemoval · Check coordinates distance and bearing  · Upgrade Category Error · Upgrade iReports to 6.0|{{#if:IMSMA3 script changes 6.0Space coordinates · MGRS coordinates · Coordinate display rules · Point ID Length · Location point · Missing approval information · Missing Date of Information · Missing Local ID · SQL Templates · DIM Categories · Enum categories and values · Duplicate Enumvalue SQL · Translations · CDF display format · CDF missing in field · Duplicate CDF · Multi-select CDFs · CDF not used · Empty CDF · Duplicate allow value · Link invalid date · Attachment SQL · Country structure orphans · Country structure duplicates · Unknown device Accident · Update isactive · Data QA - Duplicates · Data QA - No geo data · Data QA - No links · Data QA - Different Locations · Data QA - Task · Data QA - MA Process|}}{{#if:{{#if:Upgrade from 5.08.04 to 6.0 process|}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group4}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group5}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group6}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group7}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group8}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group9}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group10}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group11}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group12}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group13}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group14}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group15}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group16}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group17}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group18}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group19}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group20}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:IMSMA3 script changes 6.0Space coordinates · MGRS coordinates · Coordinate display rules · Point ID Length · Location point · Missing approval information · Missing Date of Information · Missing Local ID · SQL Templates · DIM Categories · Enum categories and values · Duplicate Enumvalue SQL · Translations · CDF display format · CDF missing in field · Duplicate CDF · Multi-select CDFs · CDF not used · Empty CDF · Duplicate allow value · Link invalid date · Attachment SQL · Country structure orphans · Country structure duplicates · Unknown device Accident · Update isactive · Data QA - Duplicates · Data QA - No geo data · Data QA - No links · Data QA - Different Locations · Data QA - Task · Data QA - MA ProcessLocale Pre-check SQL · Used DEF template SQL · Imsmaenum Duplicate fix · Imsmaenum Duplicate fix Part 2 · Inactive enumvalue fix · Translation Duplicate fix · Check Detection Sample Sector VegetationRemoval · Check coordinates distance and bearing  · Upgrade Category Error · Upgrade iReports to 6.0|}}}}
{{#if:Implementation plan|}}
{{#if:Data quality checks before upgrading to V6.0|}}
{{#if:Upgrade from 5.08.04 to 6.0 process|}}
{{#if:|
{{{group4}}}
}}
{{#if:|
{{{group5}}}
}}
{{#if:|
{{{group6}}}
}}
{{#if:|
{{{group7}}}
}}
{{#if:|
{{{group8}}}
}}
{{#if:|
{{{group9}}}
}}
{{#if:|
{{{group10}}}
}}
{{#if:|
{{{group11}}}
}}
{{#if:|
{{{group12}}}
}}
{{#if:|
{{{group13}}}
}}
{{#if:|
{{{group14}}}
}}
{{#if:|
{{{group15}}}
}}
{{#if:|
{{{group16}}}
}}
{{#if:|
{{{group17}}}
}}
{{#if:|
{{{group18}}}
}}
{{#if:|
{{{group19}}}
}}
{{#if:|
{{{group20}}}
}}
{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=
|none=|#default=
}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:space coordinates 
|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}
}}}}}}|{{#if:IMSMA Hub|
{{{imageleft}}}
Upgrade Process
{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=
|none=|#default=
}}{{#if:|{{#if:|<th scope="col" style="border-left:2px solid #fdfdfd;width:100%;|}}{{#if:|{{#if:|}}}}{{#if:IMSMA3 script changes 6.0|{{#if:|}}{{#if:|}}{{#if:{{#if:Implementation plan|}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|{{#if:|}}}}{{#if:Space coordinates · MGRS coordinates · Coordinate display rules · Point ID Length · Location point · Missing approval information · Missing Date of Information · Missing Local ID · SQL Templates · DIM Categories · Enum categories and values · Duplicate Enumvalue SQL · Translations · CDF display format · CDF missing in field · Duplicate CDF · Multi-select CDFs · CDF not used · Empty CDF · Duplicate allow value · Link invalid date · Attachment SQL · Country structure orphans · Country structure duplicates · Unknown device Accident · Update isactive · Data QA - Duplicates · Data QA - No geo data · Data QA - No links · Data QA - Different Locations · Data QA - Task · Data QA - MA Process|{{#if:IMSMA3 script changes 6.0|}}{{#if:{{#if:Data quality checks before upgrading to V6.0|}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:Locale Pre-check SQL · Used DEF template SQL · Imsmaenum Duplicate fix · Imsmaenum Duplicate fix Part 2 · Inactive enumvalue fix · Translation Duplicate fix · Check Detection Sample Sector VegetationRemoval · Check coordinates distance and bearing  · Upgrade Category Error · Upgrade iReports to 6.0|{{#if:IMSMA3 script changes 6.0Space coordinates · MGRS coordinates · Coordinate display rules · Point ID Length · Location point · Missing approval information · Missing Date of Information · Missing Local ID · SQL Templates · DIM Categories · Enum categories and values · Duplicate Enumvalue SQL · Translations · CDF display format · CDF missing in field · Duplicate CDF · Multi-select CDFs · CDF not used · Empty CDF · Duplicate allow value · Link invalid date · Attachment SQL · Country structure orphans · Country structure duplicates · Unknown device Accident · Update isactive · Data QA - Duplicates · Data QA - No geo data · Data QA - No links · Data QA - Different Locations · Data QA - Task · Data QA - MA Process|}}{{#if:{{#if:Upgrade from 5.08.04 to 6.0 process|}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group4}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group5}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group6}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group7}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group8}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group9}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group10}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group11}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group12}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group13}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group14}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group15}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group16}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group17}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group18}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group19}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group20}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:IMSMA3 script changes 6.0Space coordinates · MGRS coordinates · Coordinate display rules · Point ID Length · Location point · Missing approval information · Missing Date of Information · Missing Local ID · SQL Templates · DIM Categories · Enum categories and values · Duplicate Enumvalue SQL · Translations · CDF display format · CDF missing in field · Duplicate CDF · Multi-select CDFs · CDF not used · Empty CDF · Duplicate allow value · Link invalid date · Attachment SQL · Country structure orphans · Country structure duplicates · Unknown device Accident · Update isactive · Data QA - Duplicates · Data QA - No geo data · Data QA - No links · Data QA - Different Locations · Data QA - Task · Data QA - MA ProcessLocale Pre-check SQL · Used DEF template SQL · Imsmaenum Duplicate fix · Imsmaenum Duplicate fix Part 2 · Inactive enumvalue fix · Translation Duplicate fix · Check Detection Sample Sector VegetationRemoval · Check coordinates distance and bearing  · Upgrade Category Error · Upgrade iReports to 6.0|}}}}
{{#if:Implementation plan|}}
{{#if:Data quality checks before upgrading to V6.0|}}
{{#if:Upgrade from 5.08.04 to 6.0 process|}}
{{#if:|
{{{group4}}}
}}
{{#if:|
{{{group5}}}
}}
{{#if:|
{{{group6}}}
}}
{{#if:|
{{{group7}}}
}}
{{#if:|
{{{group8}}}
}}
{{#if:|
{{{group9}}}
}}
{{#if:|
{{{group10}}}
}}
{{#if:|
{{{group11}}}
}}
{{#if:|
{{{group12}}}
}}
{{#if:|
{{{group13}}}
}}
{{#if:|
{{{group14}}}
}}
{{#if:|
{{{group15}}}
}}
{{#if:|
{{{group16}}}
}}
{{#if:|
{{{group17}}}
}}
{{#if:|
{{{group18}}}
}}
{{#if:|
{{{group19}}}
}}
{{#if:|
{{{group20}}}
}}
{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=
|none=|#default=
}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:space coordinates 
|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}
}}}}}}
{{{image}}}
}}{{#if:|{{#if:|<th scope="col" style="border-left:2px solid #fdfdfd;width:100%;|}}{{#if:|{{#if:|}}}}{{#if:IMSMA3 script changes 6.0|{{#if:|}}{{#if:|}}{{#if:{{#if:Implementation plan|}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|{{#if:|}}}}{{#if:Space coordinates · MGRS coordinates · Coordinate display rules · Point ID Length · Location point · Missing approval information · Missing Date of Information · Missing Local ID · SQL Templates · DIM Categories · Enum categories and values · Duplicate Enumvalue SQL · Translations · CDF display format · CDF missing in field · Duplicate CDF · Multi-select CDFs · CDF not used · Empty CDF · Duplicate allow value · Link invalid date · Attachment SQL · Country structure orphans · Country structure duplicates · Unknown device Accident · Update isactive · Data QA - Duplicates · Data QA - No geo data · Data QA - No links · Data QA - Different Locations · Data QA - Task · Data QA - MA Process|{{#if:IMSMA3 script changes 6.0|}}{{#if:{{#if:Data quality checks before upgrading to V6.0|}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:Locale Pre-check SQL · Used DEF template SQL · Imsmaenum Duplicate fix · Imsmaenum Duplicate fix Part 2 · Inactive enumvalue fix · Translation Duplicate fix · Check Detection Sample Sector VegetationRemoval · Check coordinates distance and bearing  · Upgrade Category Error · Upgrade iReports to 6.0|{{#if:IMSMA3 script changes 6.0Space coordinates · MGRS coordinates · Coordinate display rules · Point ID Length · Location point · Missing approval information · Missing Date of Information · Missing Local ID · SQL Templates · DIM Categories · Enum categories and values · Duplicate Enumvalue SQL · Translations · CDF display format · CDF missing in field · Duplicate CDF · Multi-select CDFs · CDF not used · Empty CDF · Duplicate allow value · Link invalid date · Attachment SQL · Country structure orphans · Country structure duplicates · Unknown device Accident · Update isactive · Data QA - Duplicates · Data QA - No geo data · Data QA - No links · Data QA - Different Locations · Data QA - Task · Data QA - MA Process|}}{{#if:{{#if:Upgrade from 5.08.04 to 6.0 process|}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group4}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group5}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group6}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group7}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group8}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group9}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group10}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group11}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group12}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group13}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group14}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group15}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group16}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group17}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group18}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group19}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group20}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:IMSMA3 script changes 6.0Space coordinates · MGRS coordinates · Coordinate display rules · Point ID Length · Location point · Missing approval information · Missing Date of Information · Missing Local ID · SQL Templates · DIM Categories · Enum categories and values · Duplicate Enumvalue SQL · Translations · CDF display format · CDF missing in field · Duplicate CDF · Multi-select CDFs · CDF not used · Empty CDF · Duplicate allow value · Link invalid date · Attachment SQL · Country structure orphans · Country structure duplicates · Unknown device Accident · Update isactive · Data QA - Duplicates · Data QA - No geo data · Data QA - No links · Data QA - Different Locations · Data QA - Task · Data QA - MA ProcessLocale Pre-check SQL · Used DEF template SQL · Imsmaenum Duplicate fix · Imsmaenum Duplicate fix Part 2 · Inactive enumvalue fix · Translation Duplicate fix · Check Detection Sample Sector VegetationRemoval · Check coordinates distance and bearing  · Upgrade Category Error · Upgrade iReports to 6.0|}}}}
{{#if:Implementation plan|}}
{{#if:Data quality checks before upgrading to V6.0|}}
{{#if:Upgrade from 5.08.04 to 6.0 process|}}
{{#if:|
{{{group4}}}
}}
{{#if:|
{{{group5}}}
}}
{{#if:|
{{{group6}}}
}}
{{#if:|
{{{group7}}}
}}
{{#if:|
{{{group8}}}
}}
{{#if:|
{{{group9}}}
}}
{{#if:|
{{{group10}}}
}}
{{#if:|
{{{group11}}}
}}
{{#if:|
{{{group12}}}
}}
{{#if:|
{{{group13}}}
}}
{{#if:|
{{{group14}}}
}}
{{#if:|
{{{group15}}}
}}
{{#if:|
{{{group16}}}
}}
{{#if:|
{{{group17}}}
}}
{{#if:|
{{{group18}}}
}}
{{#if:|
{{{group19}}}
}}
{{#if:|
{{{group20}}}
}}
{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=
|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:space coordinates 

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

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

{{{list2}}}

}}{{#if:|{{#if:IMSMA Hub{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#if:|{{#if:|<th scope="col" style="border-left:2px solid #fdfdfd;width:100%;|}}{{#if:|{{#if:|}}}}{{#if:IMSMA3 script changes 6.0|{{#if:|}}{{#if:|}}{{#if:{{#if:Implementation plan|}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|{{#if:|}}}}{{#if:Space coordinates · MGRS coordinates · Coordinate display rules · Point ID Length · Location point · Missing approval information · Missing Date of Information · Missing Local ID · SQL Templates · DIM Categories · Enum categories and values · Duplicate Enumvalue SQL · Translations · CDF display format · CDF missing in field · Duplicate CDF · Multi-select CDFs · CDF not used · Empty CDF · Duplicate allow value · Link invalid date · Attachment SQL · Country structure orphans · Country structure duplicates · Unknown device Accident · Update isactive · Data QA - Duplicates · Data QA - No geo data · Data QA - No links · Data QA - Different Locations · Data QA - Task · Data QA - MA Process|{{#if:IMSMA3 script changes 6.0|}}{{#if:{{#if:Data quality checks before upgrading to V6.0|}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:Locale Pre-check SQL · Used DEF template SQL · Imsmaenum Duplicate fix · Imsmaenum Duplicate fix Part 2 · Inactive enumvalue fix · Translation Duplicate fix · Check Detection Sample Sector VegetationRemoval · Check coordinates distance and bearing  · Upgrade Category Error · Upgrade iReports to 6.0|{{#if:IMSMA3 script changes 6.0Space coordinates · MGRS coordinates · Coordinate display rules · Point ID Length · Location point · Missing approval information · Missing Date of Information · Missing Local ID · SQL Templates · DIM Categories · Enum categories and values · Duplicate Enumvalue SQL · Translations · CDF display format · CDF missing in field · Duplicate CDF · Multi-select CDFs · CDF not used · Empty CDF · Duplicate allow value · Link invalid date · Attachment SQL · Country structure orphans · Country structure duplicates · Unknown device Accident · Update isactive · Data QA - Duplicates · Data QA - No geo data · Data QA - No links · Data QA - Different Locations · Data QA - Task · Data QA - MA Process|}}{{#if:{{#if:Upgrade from 5.08.04 to 6.0 process|}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group4}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group5}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group6}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group7}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group8}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group9}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group10}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group11}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group12}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group13}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group14}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group15}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group16}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group17}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group18}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group19}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group20}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:IMSMA3 script changes 6.0Space coordinates · MGRS coordinates · Coordinate display rules · Point ID Length · Location point · Missing approval information · Missing Date of Information · Missing Local ID · SQL Templates · DIM Categories · Enum categories and values · Duplicate Enumvalue SQL · Translations · CDF display format · CDF missing in field · Duplicate CDF · Multi-select CDFs · CDF not used · Empty CDF · Duplicate allow value · Link invalid date · Attachment SQL · Country structure orphans · Country structure duplicates · Unknown device Accident · Update isactive · Data QA - Duplicates · Data QA - No geo data · Data QA - No links · Data QA - Different Locations · Data QA - Task · Data QA - MA ProcessLocale Pre-check SQL · Used DEF template SQL · Imsmaenum Duplicate fix · Imsmaenum Duplicate fix Part 2 · Inactive enumvalue fix · Translation Duplicate fix · Check Detection Sample Sector VegetationRemoval · Check coordinates distance and bearing  · Upgrade Category Error · Upgrade iReports to 6.0|}}}}
{{#if:Implementation plan|}}
{{#if:Data quality checks before upgrading to V6.0|}}
{{#if:Upgrade from 5.08.04 to 6.0 process|}}
{{#if:|
{{{group4}}}
}}
{{#if:|
{{{group5}}}
}}
{{#if:|
{{{group6}}}
}}
{{#if:|
{{{group7}}}
}}
{{#if:|
{{{group8}}}
}}
{{#if:|
{{{group9}}}
}}
{{#if:|
{{{group10}}}
}}
{{#if:|
{{{group11}}}
}}
{{#if:|
{{{group12}}}
}}
{{#if:|
{{{group13}}}
}}
{{#if:|
{{{group14}}}
}}
{{#if:|
{{{group15}}}
}}
{{#if:|
{{{group16}}}
}}
{{#if:|
{{{group17}}}
}}
{{#if:|
{{{group18}}}
}}
{{#if:|
{{{group19}}}
}}
{{#if:|
{{{group20}}}
}}
{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=
|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:space coordinates 

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

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

{{{list3}}}

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

{{{list4}}}

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

{{{list5}}}

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

{{{list6}}}

}}{{#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:IMSMA Hub{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#if:|{{#if:|<th scope="col" style="border-left:2px solid #fdfdfd;width:100%;|}}{{#if:|{{#if:|}}}}{{#if:IMSMA3 script changes 6.0|{{#if:|}}{{#if:|}}{{#if:{{#if:Implementation plan|}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|{{#if:|}}}}{{#if:Space coordinates · MGRS coordinates · Coordinate display rules · Point ID Length · Location point · Missing approval information · Missing Date of Information · Missing Local ID · SQL Templates · DIM Categories · Enum categories and values · Duplicate Enumvalue SQL · Translations · CDF display format · CDF missing in field · Duplicate CDF · Multi-select CDFs · CDF not used · Empty CDF · Duplicate allow value · Link invalid date · Attachment SQL · Country structure orphans · Country structure duplicates · Unknown device Accident · Update isactive · Data QA - Duplicates · Data QA - No geo data · Data QA - No links · Data QA - Different Locations · Data QA - Task · Data QA - MA Process|{{#if:IMSMA3 script changes 6.0|}}{{#if:{{#if:Data quality checks before upgrading to V6.0|}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:Locale Pre-check SQL · Used DEF template SQL · Imsmaenum Duplicate fix · Imsmaenum Duplicate fix Part 2 · Inactive enumvalue fix · Translation Duplicate fix · Check Detection Sample Sector VegetationRemoval · Check coordinates distance and bearing  · Upgrade Category Error · Upgrade iReports to 6.0|{{#if:IMSMA3 script changes 6.0Space coordinates · MGRS coordinates · Coordinate display rules · Point ID Length · Location point · Missing approval information · Missing Date of Information · Missing Local ID · SQL Templates · DIM Categories · Enum categories and values · Duplicate Enumvalue SQL · Translations · CDF display format · CDF missing in field · Duplicate CDF · Multi-select CDFs · CDF not used · Empty CDF · Duplicate allow value · Link invalid date · Attachment SQL · Country structure orphans · Country structure duplicates · Unknown device Accident · Update isactive · Data QA - Duplicates · Data QA - No geo data · Data QA - No links · Data QA - Different Locations · Data QA - Task · Data QA - MA Process|}}{{#if:{{#if:Upgrade from 5.08.04 to 6.0 process|}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group4}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group5}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group6}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group7}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group8}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group9}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group10}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group11}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group12}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group13}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group14}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group15}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group16}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group17}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group18}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group19}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group20}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:IMSMA3 script changes 6.0Space coordinates · MGRS coordinates · Coordinate display rules · Point ID Length · Location point · Missing approval information · Missing Date of Information · Missing Local ID · SQL Templates · DIM Categories · Enum categories and values · Duplicate Enumvalue SQL · Translations · CDF display format · CDF missing in field · Duplicate CDF · Multi-select CDFs · CDF not used · Empty CDF · Duplicate allow value · Link invalid date · Attachment SQL · Country structure orphans · Country structure duplicates · Unknown device Accident · Update isactive · Data QA - Duplicates · Data QA - No geo data · Data QA - No links · Data QA - Different Locations · Data QA - Task · Data QA - MA ProcessLocale Pre-check SQL · Used DEF template SQL · Imsmaenum Duplicate fix · Imsmaenum Duplicate fix Part 2 · Inactive enumvalue fix · Translation Duplicate fix · Check Detection Sample Sector VegetationRemoval · Check coordinates distance and bearing  · Upgrade Category Error · Upgrade iReports to 6.0|}}}}
{{#if:Implementation plan|}}
{{#if:Data quality checks before upgrading to V6.0|}}
{{#if:Upgrade from 5.08.04 to 6.0 process|}}
{{#if:|
{{{group4}}}
}}
{{#if:|
{{{group5}}}
}}
{{#if:|
{{{group6}}}
}}
{{#if:|
{{{group7}}}
}}
{{#if:|
{{{group8}}}
}}
{{#if:|
{{{group9}}}
}}
{{#if:|
{{{group10}}}
}}
{{#if:|
{{{group11}}}
}}
{{#if:|
{{{group12}}}
}}
{{#if:|
{{{group13}}}
}}
{{#if:|
{{{group14}}}
}}
{{#if:|
{{{group15}}}
}}
{{#if:|
{{{group16}}}
}}
{{#if:|
{{{group17}}}
}}
{{#if:|
{{{group18}}}
}}
{{#if:|
{{{group19}}}
}}
{{#if:|
{{{group20}}}
}}
{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=
|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:space coordinates 

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

}}}}}}|}}

{{{below}}}

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

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

}}}}}}

Retrieved from "http://mwiki.gichd.org/IM/index.php?title=Space_coordinates&oldid=21036"