Title: How to discard null coordinate points automatically when we make Multipoint Geometry in Spatialite?
Tags: spatialite
Question: I have a Spatialite table that contains a series of 80 coordinates where each coordinate placed into one column in a table. Then, I want to add all those coordinates into one Multipoint Geometry Column. Unfortunately, some of those coordinates have NULL value randomly. This will make the Multipoint Geometry Column having NULL value as well.

I tried to catch the NULL value using CASE WHEN, but since the table has 80 columns, my CASE WHEN code becomes very long because I must check it column by column.

Is there any automatic way to discard/unconsidered NULL coordinate points when we make a Multipoint Geomatry Column?

Comment: I'd try to fix the data first. What does "NULL" represent in those columns?

Comment: Null represent no coordinates in that column, may be it similar to N/A.

Comment: OK.... Perhaps you can say what the columns represent?



{'source': 'StackExchangeDataset', 'subset': 'gis.stackexchange.com', 'metadata': {'AnswerCount': 0, 'CommentCount': 3, 'ContentLicense': 'CC BY-SA 3.0', 'CreationDate': '2014:00:02/04/14', 'FavoriteCount': None, 'PostTypeId': 1, 'Tags': '<spatialite>', 'Title': 'How to discard null coordinate points automatically when we make Multipoint Geometry in Spatialite?', 'ViewCount': 65, 'id': 85267, 'user_AboutMe': None, 'user_AccountId': 3864633.0, 'user_DisplayName': 'Gus', 'user_Reputation': 109.0, 'user_Views': 12.0, 'user_id': 25855.0}}