MapThat – EXTMODEL for NULL Values

By David Crowther

Question:

When I view the Data Table in MapThat, some values are showing as EXTMODELXXX-1, what is causing this?

Answer:

This issue is likely being caused due to an INTEGER field in your source Database (likely PostGIS) having NULL values.

In addition, if the field in the source table is named ‘id’, and you expose that field name via the Information Bubble - Attr Caption as – id – then the EXTMODELXXX-1 values will be shown for records that have NULL values.

The value ‘id’ is a reserved value which we use in the MapThat Data Table for certain tasks…. So it shouldn’t be used as a field name alias.

The solution is in the Information Bubble settings, rename the Attr Caption (alias) value from ‘id’ to use a capital letter e.g., ‘Id’ or ‘ID’ –

Now when MapThat reads the data in from your database, it will be able to deal with NULL values and will simply show a blank value in the Data Table –