station metadata (coordinates) are checked!
Some stations have already been inserted with apparently wrong coordinates; f. ex.:
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+----------------------------------------------------+---------
{50-007-0009,50-007-0008,37-183-0009,25-013-3005,25-013-3004,25-013-2006,35-003-0001,25-005-0036,23-019-0014,47-165-0004,47-119-2002,47-119-2001,37-013-0002,26-029-0901,12-017-0003,18-175-0001,18-127-0903} | | POINT Z (0 0 0) | 239
{openaq_8497} | IT2168A | POINT Z (0.00006871258524 0.000404465917681 -999) | -1
{openaq_8162} | CY0004A | POINT Z (0.000299568186688 0.000315775285609 -999) | -1
The above table can be obtained via the command
SELECT codes, name, ST_AsText(coordinates), country FROM stationmeta_core WHERE ST_CONTAINS(ST_GeomFromEWKT('SRID=4326;POLYGON((1 1, 1 -1, -1 -1, -1 1, 1 1))'), coordinates);
All altitudes of OpenAQ stations have been set to -999!