MapThat Admin Forms – PostGIS DataLayers not displaying

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.