0 used as missing data placeholder about openmindat HOT 3 OPEN

This is a good point. The 0 values are rooted in the databases, and I have passed this issue on to the developing teams. Hopefully, we can eliminate these annoying 0s in future versions.

from openmindat.

For placeholders in the MySQL database, it is appropriate to replace 0 with the special datatype null or with an empty string ''. The choice depends on what is "meant" by the database

• If a value is not known and is sure not to exist, it is most accurate to have an empty string '' as a field value.
• If a value is not known but is presumed to exist, it is most accurate to have the NULL datatype as a field datatype.

Unknown lat/long values are most accurately NULL; while it is certain that localities have a spatial reference, it is not known for that record.

My understanding is Mindat's aim is to be a repository of mineral properties / attributes / etc first. Under "Open Geoscience Data", there are tools for "GeoCODES and "DataONE" for locality data.

Cleansing data is a key part of the data science and data handling; there are many memes regarding the subject. For now, users can script out solutions: "if lat = 0, assign NULL to lat".

Source:

MySQL Reference Manual, Section B.3.4.3 Problems with NULL Values
https://dev.mysql.com/doc/refman/8.3/en/problems-with-null.html

from openmindat.

For placeholders in the MySQL database, it is appropriate to replace 0 with the special datatype null or with an empty string ''. The choice depends on what is "meant" by the database

• If a value is not known and is sure not to exist, it is most accurate to have an empty string '' as a field value.
• If a value is not known but is presumed to exist, it is most accurate to have the NULL datatype as a field datatype.

Unknown lat/long values are most accurately NULL; while it is certain that localities have a spatial reference, it is not known for that record.

My understanding is Mindat's aim is to be a repository of mineral properties / attributes / etc first. Under "Open Geoscience Data", there are tools for "GeoCODES and "DataONE" for locality data.

Cleansing data is a key part of the data science and data handling; there are many memes regarding the subject. For now, users can script out solutions: "if lat = 0, assign NULL to lat".

Source:

MySQL Reference Manual, Section B.3.4.3 Problems with NULL Values https://dev.mysql.com/doc/refman/8.3/en/problems-with-null.html

Noted, thank you for the advice and reference. I will forward your message to the Mindat database administrators.

from openmindat.