User contributions
10 February 2014
Enum categories and values
no edit summary
+35
Enum categories and values
Created page with "SELECT imsmaenum.enumcategory FROM imsmaenum WHERE imsmaenum.enumcategory NOT LIKE 'cbo%' GROUP BY imsmaenum.enumcategory"
Data quality checks before upgrading to V6.0
no edit summary
+618
Data quality checks before upgrading to V6.0
no edit summary
+629
Data quality checks before upgrading to V6.0
no edit summary
+221
Data quality checks before upgrading to V6.0
no edit summary
+430
Data quality checks before upgrading to V6.0
no edit summary
+477
Data quality checks before upgrading to V6.0
no edit summary
+230
6 February 2014
Data quality checks before upgrading to V6.0
no edit summary
+619
Data quality checks before upgrading to V6.0
no edit summary
+119
Data quality checks before upgrading to V6.0
no edit summary
+340
DIM Categories
Created page with "SELECT Count(category.category_guid) FROM Category ----------------------------------------------------- SELECT category.pojo_parent, category.name_translation_key FROM cat..."
Data quality checks before upgrading to V6.0
no edit summary
+1
Data quality checks before upgrading to V6.0
no edit summary
+479
Data quality checks before upgrading to V6.0
no edit summary
+4
Data quality checks before upgrading to V6.0
no edit summary
+477
Missing approval information
no edit summary
+5
Missing approval information
no edit summary
+430
Missing Date of Information
Created page with "SELECT fieldreport.fieldreport_localid, fieldreport.dateofreport, fieldreport.reportreceiveddate, fieldreport.reportverifieddate, fieldreport.reportcompleteddate, fieldreport...."
Data quality checks before upgrading to V6.0
no edit summary
-17
Data quality checks before upgrading to V6.0
no edit summary
+590
Missing approval information
no edit summary
+8
Missing approval information
Created page with "SELECT fieldreport.fieldreport_localid, fieldreport.dateofreport AS `Date of Information`, fieldreport.reportreceiveddate AS `Data Entry Date`, fieldreport.reportcompleteddate..."
Data quality checks before upgrading to V6.0
no edit summary
+7
Point ID Length
Created page with "SELECT Count(geopoint_guid), length(pointlocal_id) FROM geopoint GROUP BY length(pointlocal_id) ORDER by length(pointlocal_id) Category:NoPublic"
Data quality checks before upgrading to V6.0
no edit summary
+773
Coordinate display rules
Created page with "SELECT geopoint.userinputformat, Count(geopoint.geopoint_guid) FROM geopoint GROUP BY geopoint.userinputformat HAVING (geopoint.userinputformat <> 'X and Y' AND geopoint.u..."
Data quality checks before upgrading to V6.0
no edit summary
+659
MGRS coordinates
no edit summary
+52
MGRS coordinates
no edit summary
+135
Data quality checks before upgrading to V6.0
no edit summary
+75
Data quality checks before upgrading to V6.0
no edit summary
+54
MGRS coordinates
Created page with "SELECT geopoint.userenteredcoord, concat( upper(left(geopoint.userenteredcoord, locate('|', geopoint.userenteredcoord) -1)),right(geopoint.userenteredcoord,7)) FROM geopoint ..."
Data quality checks before upgrading to V6.0
no edit summary
+59
Space coordinates
no edit summary
+5
Space coordinates
no edit summary
+23
Data quality checks before upgrading to V6.0
no edit summary
+23
Space coordinates
Created page with "SELECT geopoint.pointlocal_id, geopoint.pointno, geopoint.longitude, geopoint.latitude, geopoint.userenteredcoord FROM geopoint INNER JOIN geospatialinfo ON geospatialinfo..."
Data quality checks before upgrading to V6.0
Created page with "===Invalid / space coordinates===__NOEDITSECTION__ __FORCETOC__ {{TOC right}} {{HowTo's |Space coordinates |MGRS coordinates |Coordinate display rules }} It was ..."
Upgrade Process
Created page with "Data quality checks before upgrading to V6.0"
Portal:Technical Notes/Hub
no edit summary
+2
3 February 2014
Portal:IMSMA NG Administration/Installation
no edit summary
+4
Upgrading to IMSMANG Version 6
Created page with "To upgrade from earlier versions to V6.0 consists of several steps: * quality check of database * upgrade of database * uninstallation of earlier version * installation of V6...."
Portal:IMSMA NG Administration/Installation
no edit summary
+1
Portal:IMSMA NG Administration/Installation
no edit summary
+1
Portal:IMSMA NG Administration/Installation
no edit summary
+169
Backup and Restore
no edit summary
-2