MapThat Admin – PostGIS Layer returns LineString error message

Question

How do I resolve the ‘LineString input is not valid because it does not have enough distinct points’ message?

Answer

This MapThat message occurs when MapThat is trying to load a layer from PostGIS that contains Multiline geometry and there are invalid records or records with no geometry in that database table.

To check if your PostGIS table has valid geometry, you can use PGAdmin to View the records in the Table and check for a valid geometry in the ‘geom’ column. Notice that as per the below, there is a record that does not have geometry.

You will either need to correct that record, remove the record, or use a SQL Select statement in the MapThat Admin forms to only select the correct records when defining your layer e.g.