I have PostGIS table with some points and various attributes. Yesterday I added some more points to the table and now weird things are happening when I try and display layers built from these points.
If I construct a set of layers with a queries that select one 'classification' only the new data is displayed (these all have the same new classification) the other layer points do not appear on the map although they are in the attribute table.
If I load all the data into one layer then the new points don't appear (again they are in the attribute table).
The new data had a different origin -- I imported it from a csv file, all the other data came of GPS.
I have discovered that 'the_geom' for the two groups looks different:
'new':
POINT(1768983 5947119) POINT(1769033 5947085)
original:
POINT(1768982.09596461 5948263.32822992) POINT(1768558.70815704 5947816.48845243)
The difference is now obvious but what I would like to know is why this causes problems and how it came about so I can avoid this issue in future.
Is one is an integer representation and the other float?
For the record the original data was loaded off a GPS using into QGIS and saved as shapefile in CSR 2193 and then loaded into PostGIS using SPIT. The new data was imported from a CSV file using layer->"add delimited text layer" (the coordinates were already in 2193) and then imported into PostGIS using the database manager.
QGIS version 2.0.1-Dufour QGIS code revision f738351 Compiled against Qt 4.8.5 Running against Qt 4.8.5 Compiled against GDAL/OGR 1.10.1 Running against GDAL/OGR 1.10.1 Compiled against GEOS 3.4.2-CAPI-1.8.2 Running against GEOS 3.4.2-CAPI-1.8.2 r3921 PostgreSQL Client Version 9.2.4 SpatiaLite Version 4.1.1 QWT Version 6.0.2 PROJ.4 Version 480 QScintilla2 Version 2.7.2