• Blog posts

    Bio

     

    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.

     

     

Comments

0 comments

Please sign in to leave a comment.