| Number of Errors | Type | Reported Errors | Error Fields |
| 8 | error |
There is more than one relationship between records (Critical error)
| |
| 8 | error |
Too few or too many fields in this record
| 93 |
| 6 | error |
Cross record/field check (error preventing data import)
| R00, Condition |
| 3 | error |
Longitude outside valid range
| R91.LONGI |
| 2 | error |
Cross record/field check (condition not met)
| R10, Condition |
| 1 | error |
Cross field check (condition not met)
| R10, Condition |
| 1 | error |
Cross record/field check (condition not met)
| R91, Condition |
| 1 | Information |
Cross field check (Information - condition not met)
| R00, Condition |
| 1 | warning |
Deprecated code
| SHIPC |
| 1 | warning |
Sampling coordinates are not in the station dictionary defined area for this station
| sql is: FROM R00 INNER JOIN (
SELECT CODE.Code AS SD_MATCH, CODE.Code FROM RECO.dbo.tblCode AS CODE INNER JOIN
RECO.dbo.tblCodeType AS CODETYPE ON CODE.tblCodeTypeID = CODETYPE.tblCodeTypeID WHERE (CODETYPE.CodeType = 'CNTRY')
UNION ALL
SELECT C_1.Description AS SD_MATCH, C_1.Code AS CODE
FROM RECO.dbo.tblCode AS C_1 INNER JOIN RECO.dbo.tblCodeType AS CT_1 ON C_1.tblCodeTypeID = CT_1.tblCodeTypeID
WHERE (CT_1.CodeType = 'CNTRY')) AS CNTRY_MATCH
ON R00.CNTRY = CNTRY_MATCH.Code INNER JOIN
RECO_Publish.dbo.tblStation_RetroStyle AS SD ON CNTRY_MATCH.SD_MATCH = SD.Country INNER JOIN
R91 ON ISNULL(SD.StartYear, 0) <= CAST(LEFT(R91.SDATE, 4) AS INT) AND SD.Station_Name = REPLACE(LTRIM(RTRIM(R91.STATN)), '', '''') AND ISNULL(SD.EndYear, YEAR(GETDATE())) >= CAST(LEFT(R91.SDATE, 4) AS INT)
WHERE geometry::STGeomFromText(SD.[Geometry], 4326).MakeValid().STIntersects(geometry::Point( DBO.UF_32POS2DECPOS(R91.LONGI), DBO.UF_32POS2DECPOS(R91.LATIT),4326)) = 0 in the record:91 |
| 1 | warning |
Station position appears to be on land
| sql is: FROM R91 WHERE GDB.dbo.ufn_GEBCO_08_G_OnLand(datsu.[dbo].[UF_32Pos2DecPos](LATIT), datsu.[dbo].[UF_32Pos2DecPos](LONGI), 4) = 1 in the record:91 |
| 1 | error |
Entry must be unique (critical error)
| R03, Condition |
| 1 | error |
There should be at least one relationship between records (critical error)
| |
