=== modified file 'dhis-2/dhis-web/dhis-web-dashboard-integration/src/main/webapp/dhis-web-dashboard-integration/style/dashboard.css'
--- dhis-2/dhis-web/dhis-web-dashboard-integration/src/main/webapp/dhis-web-dashboard-integration/style/dashboard.css	2012-11-15 17:28:14 +0000
+++ dhis-2/dhis-web/dhis-web-dashboard-integration/src/main/webapp/dhis-web-dashboard-integration/style/dashboard.css	2012-11-20 21:04:24 +0000
@@ -63,7 +63,6 @@
 
 .labelText
 {
-  position: relative;
   color: #999;
   font-size: 16px;
   padding: 40px 0 0 30px;

=== modified file 'resources/sql/div.sql'
--- resources/sql/div.sql	2012-11-16 14:01:45 +0000
+++ resources/sql/div.sql	2012-11-20 21:04:24 +0000
@@ -103,6 +103,21 @@
 (select count(*) from reporttable_periods where reporttableid=rt.reporttableid) as pe
 from reporttable rt;
 
+-- Turn longitude/latitude around for organisationunit coordinates (adjust the like clause)
+
+update organisationunit set coordinates=regexp_replace(coordinates,'\[(.+?\..+?),(.+?\..+?)\]','[\2,\1]')
+where coordinates like '[0%'
+and featuretype='Point';
+
+-- Nullify coordinates with longitude outside range (adjust where clause values)
+
+update organisationunit set coordinates=null
+where featuretype='Point'
+and (
+  cast(substring(coordinates from '\[(.+?\..+?),.+?\..+?\]') as double precision) < 32
+  or cast(substring(coordinates from '\[(.+?\..+?),.+?\..+?\]') as double precision) > 43
+);
+
 -- Insert random org unit codes
 
 create function setrandomcode() returns integer AS $$