<pre>
SELECT
fieldreportlocationinfoversion.fieldreport_localidlocation_localid,
geopoint.longitude,
geopoint.latitude,
locationinfoversiongeopoint.location_localiduserenteredcoord
FROM
fieldreportInner Join geopointInner Join locationinfoversion INNER JOIN locationinfoversion_has_geospatialinfo ON locationinfoversionlocationinfoversion_has_geospatialinfo.fieldreport_guid geospatialinfo_guid = fieldreportgeopoint.fieldreport_guidgeospatialinfo_guidInner Join locationinfoversion_has_geospatialinfo INNER JOIN locationinfoversion ON locationinfoversion_has_geospatialinfo.locationinfoversion_guid = locationinfoversion.locationinfoversion_guid AND locationinfoversion_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
</pre>
<pre>
SELECT
fieldreporthazardinfoversion.fieldreport_localidhazard_localid,
geopoint.longitude,
geopoint.latitude,
hazardinfoversiongeopoint.hazard_localiduserenteredcoord
FROM
fieldreportInner Join geopointInner Join hazardinfoversion ON hazardinfoversion.fieldreport_guid = fieldreport.fieldreport_guidInner Join INNER JOIN hazardinfoversion_has_geospatialinfo ON hazardinfoversion_has_geospatialinfo.geospatialinfo_guid = geopoint.geospatialinfo_guid AND 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
</pre>
<pre>
SELECT
fieldreporthazreducinfoversion.fieldreport_localidhazreduc_localid,
geopoint.longitude,
geopoint.latitude,
hazreducinfoversiongeopoint.hazreduc_localiduserinputformat
FROM
fieldreportInner Join geopointInner Join hazreducinfoversion INNER JOIN hazreducinfoversion_has_geospatialinfo ON hazreducinfoversionhazreducinfoversion_has_geospatialinfo.fieldreport_guid geospatialinfo_guid = fieldreportgeopoint.fieldreport_guidgeospatialinfo_guidInner Join hazreducinfoversion_has_geospatialinfo INNER JOIN hazreducinfoversion ON hazreducinfoversion_has_geospatialinfohazreducinfoversion.hazreducinfoversion_guid = hazreducinfoversionhazreducinfoversion_has_geospatialinfo.hazreducinfoversion_guid AND hazreducinfoversion_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
</pre>
SELECT
accidentinfoversion.accident_localid,
fieldreport.fieldreport_localid,
geopoint.longitude,
geopoint.latitude
FROM
accidentinfoversion
Inner Join INNER JOIN accidentinfoversion_has_geospatialinfo ON accidentinfoversion.accidentinfoversion_guid = accidentinfoversion_has_geospatialinfo.accidentinfoversion_guidInner Join fieldreport ON accidentinfoversion.fieldreport_guid = fieldreport.fieldreport_guidInner Join 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
</pre>
<pre>
SELECT
fieldreportvictiminfoversion.fieldreport_localidvictim_localid,
geopoint.longitude,
geopoint.latitude,
victiminfoversiongeopoint.victim_localiduserenteredcoord
FROM
fieldreportInner Join geopointInner Join victiminfoversion INNER JOIN victiminfoversion_has_geospatialinfo ON victiminfoversionvictiminfoversion_has_geospatialinfo.fieldreport_guid geospatialinfo_guid = fieldreportgeopoint.fieldreport_guidgeospatialinfo_guidInner Join victiminfoversion_has_geospatialinfo INNER JOIN victiminfoversion ON victiminfoversion_has_geospatialinfovictiminfoversion.victiminfoversion_guid = victiminfoversionvictiminfoversion_has_geospatialinfo.victiminfoversion_guid AND victiminfoversion_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
</pre>
<pre>
SELECT
fieldreportmreinfoversion.fieldreport_localidmre_localid,
geopoint.longitude,
geopoint.latitude,
mreinfoversiongeopoint.mre_localiduserenteredcoord
FROM
fieldreportInner Join geopointInner Join mreinfoversion INNER JOIN mreinfoversion_has_geospatialinfo ON mreinfoversionmreinfoversion_has_geospatialinfo.fieldreport_guid geospatialinfo_guid = fieldreportgeopoint.fieldreport_guidgeospatialinfo_guidInner Join mreinfoversion_has_geospatialinfo INNER JOIN mreinfoversion ON mreinfoversion.mreinfoversion_guid = mreinfoversion_has_geospatialinfo.mreinfoversion_guid AND mreinfoversion_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
</pre>
<pre>
SELECT
fieldreportqainfoversion.fieldreport_localidqa_localid,
geopoint.longitude,
geopoint.latitude,
qainfoversiongeopoint.qa_localiduserenteredcoord
FROM
fieldreportInner Join geopointInner Join qainfoversion INNER JOIN qainfoversion_has_geospatialinfo ON fieldreportqainfoversion_has_geospatialinfo.fieldreport_guid geospatialinfo_guid = qainfoversiongeopoint.fieldreport_guidgeospatialinfo_guidInner Join qainfoversion_has_geospatialinfo INNER JOIN qainfoversion ON qainfoversion.qainfoversion_guid = qainfoversion_has_geospatialinfo.qainfoversion_guid AND qainfoversion_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
</pre>
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
</pre>
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
</pre>
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
</pre>
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
</pre>