MapThat Admin – Ignore Missing Geometry Records

Question:

How can I load a layer into MapThat and ignore any database records that do not have any geometry?

Answer:

By default MapThat uses logic to ensure that any database records that have no geometry are not loaded into MapThat. However, you can also use the following SQL command as part of your Layer SQL to force MapThat to only read in records that have geometry:

select * from table where geomfield is not NULL