Aquabase keeps two sets of coordinates in the Basic Information (basicinf) table. This enables the user to use either coordinate sets in e.g. GIS or other software.
While the X_COORD and Y_COORD fields store the coordinates in the format chosen during workspace setup the LONGITUDE and LATITUDE fields store the coordinates in WGS84 Longitude/Latitude (SRID=4326). The latter get updated automatically when the other coordinate set is updated and the GEOMETRY field gets updated with the actual point, which is available to GIS system.