Question
How can I successfully show X and Y data from PostGIS as a DataLayer within MapThat?
Answer
If your X and Y dataset is stored in a PostGIS database, then you will need to ensure that the X and Y column types are either Double (double precision - 15 decimal digits precision) or float data types.
If the X and Y columns are stored as Varying Character then MapThat will not be able to display them and will return the following error message:
You can either update the column types using the Database Table Properties, or simply use the SQL statement below to update the columns:
alter table YOURTABLENAME
alter column X type double precision using X::double precision;
and then repeat to update the Y column as well.