[64] [66]
[239]| Test | CC | Errors | Result | Trend | TrendPD | Description | |
|---|---|---|---|---|---|---|---|
| 1 | chkPostalCodeFormat | 3 | Failure | = | = | postal code format with postal codes in alternate names | |
| 2 | chkPostalCodeFormatLength | 0 | Success | = | = | postal code format length for zip_code table | |
| 3 | chkPostalCodeSingleCountry | 0 | Success | = | = | single postal code country in zip_code table | |
| 4 | chkPostalCodeSingleCountryOnly | 0 | Success | = | = | single postal code country in zip_code table have single code | |
| 5 | chkPostalCodeFRObsolete | FR | 2971 | Failure | = | = | French postalcodes not in La Poste data |
| 6 | chkPostalCodeFRMissing | FR | 1024 | Failure | = | = | French postalcodes in La Poste data, but missing in geonames |
| 7 | chkPostalCodeGBOuterCode | GB | 0 | Success | = | = | outercode for UK shall have seperate row with isreduced. |
| 8 | chkPostalCodeTimeZoneCountry | 0 | Success | = | = | postal code timezoneids match with geoname country, except DE87491 | |
| 9 | chkPostalCodeTimeZoneMissing | 2 | Failure | = | = | postalcodes have timezone | |
| 10 | chkPostalCodeCoordsNotNull | 0 | Success | = | = | coordinates not null (except PT) | |
| 11 | chkPostalCodeCoordsValid | 0 | Success | = | = | coordinates valid | |
| 12 | chkPostalCodeAlternateNameDistance | 29 | Failure | = | = | distance between postal code centroid and alternatename centroid | |
| 13 | chkPostalCodePlaceName | 0 | Success | = | = | place names in postal code table no special chars like '*' or " | |
| 14 | chkPostalCodePlaceNameAscii | 0 | Success | = | = | place names in postal code table have ascii transliteration | |
| 15 | chkPostalCodeAdmNameSpecialChar | 0 | Success | = | = | adminname in postal code table no special chars like '*' | |
| 16 | chkPostalCodeGeoNameDistance | 57 | Failure | = | = | distance between postal code centroid and linked geoname centroid | |
| 17 | chkPostalCodeGeoNameADM1 | 0 | Success | = | = | admincode1 of postal code record different from admincode1 from linked geoname feature | |
| 18 | chkPostalCodeGeoNameADM1Code | 0 | Success | = | = | geonamesadmcode missing | |
| 19 | chkPostalCodeWPDistance_AU | AU | 4 | Failure | = | = | distance between postal code centroid and wikipedia article |
| 20 | chkPostalCodeWPDistance_ES | ES | 5 | Failure | = | = | distance between postal code centroid and wikipedia article |
| 21 | chkPostalCodeWPDistance_FR | FR | 3 | Failure | = | = | distance between postal code centroid and wikipedia article |
| 22 | chkPostalCodeWPDistance_IN | IN | 65 | Failure | = | = | distance between postal code centroid and wikipedia article |
| 23 | chkPostalCodeWPDistance_IT | IT | 3 | Failure | = | = | distance between postal code centroid and wikipedia article |
| 24 | chkPostalCodeWPDistance_MX | MX | 9 | Failure | = | = | distance between postal code centroid and wikipedia article |
| 25 | chkPostalCodeWPDistance_US | US | 3 | Failure | = | = | distance between postal code centroid and wikipedia article |
| 26 | chkPostalCodeWPDistance_ZA | ZA | 6 | Failure | = | = | distance between postal code centroid and wikipedia article |
| 27 | chkPostalCodeWPDistance | 35 | Failure | = | = | distance between postal code centroid and wikipedia article | |
| 28 | chkPostalCodeCoordWithinShapeAS | AS | 0 | Success | = | = | AS coordinates of postal code centroids are within postal code shapes |
| 29 | chkPostalCodeCoordWithinShapeAT | AT | 5 | Failure | = | = | AT coordinates of postal code centroids are within postal code shapes |
| 30 | chkPostalCodeCoordWithinShapeAX | AX | 3 | Failure | = | = | AX coordinates of postal code centroids are within postal code shapes |
| 31 | chkPostalCodeCoordWithinShapeCA | CA | 0 | Success | = | = | CA coordinates of postal code centroids are within postal code shapes |
| 32 | chkPostalCodeCoordWithinShapeCH | CH | 3509 | Failure | = | = | CH coordinates of postal code centroids are within postal code shapes |
| 33 | chkPostalCodeCoordWithinShapeDE | DE | 228 | Failure | = | = | DE coordinates of postal code centroids are within postal code shapes |
| 34 | chkPostalCodeCoordWithinShapeDK | DK | 55 | Failure | = | = | DK coordinates of postal code centroids are within postal code shapes |
| 35 | chkPostalCodeCoordWithinShapeEC | EC | 500 | Failure | = | = | EC coordinates of postal code centroids are within postal code shapes |
| 36 | chkPostalCodeCoordWithinShapeFI | FI | 222 | Failure | = | = | FI coordinates of postal code centroids are within postal code shapes |
| 37 | chkPostalCodeCoordWithinShapeFO | FO | 53 | Failure | = | = | FO coordinates of postal code centroids are within postal code shapes |
| 38 | chkPostalCodeCoordWithinShapeGU | GU | 0 | Success | = | = | GU coordinates of postal code centroids are within postal code shapes |
| 39 | chkPostalCodeCoordWithinShapeIS | IS | 49 | Failure | = | = | IS coordinates of postal code centroids are within postal code shapes |
| 40 | chkPostalCodeCoordWithinShapeLI | LI | 0 | Success | = | = | LI coordinates of postal code centroids are within postal code shapes |
| 41 | chkPostalCodeCoordWithinShapeLU | LU | 357 | Failure | = | = | LU coordinates of postal code centroids are within postal code shapes |
| 42 | chkPostalCodeCoordWithinShapeMP | MP | 0 | Success | = | = | MP coordinates of postal code centroids are within postal code shapes |
| 43 | chkPostalCodeCoordWithinShapeMX | MX | 48682 | Failure | = | = | MX coordinates of postal code centroids are within postal code shapes |
| 44 | chkPostalCodeCoordWithinShapeNL | NL | 106 | Failure | = | = | NL coordinates of postal code centroids are within postal code shapes |
| 45 | chkPostalCodeCoordWithinShapeNO | NO | 0 | Success | = | = | NO coordinates of postal code centroids are within postal code shapes |
| 46 | chkPostalCodeCoordWithinShapePR | PR | 42 | Failure | = | = | PR coordinates of postal code centroids are within postal code shapes |
| 47 | chkPostalCodeCoordWithinShapeSJ | SJ | 0 | Success | = | = | SJ coordinates of postal code centroids are within postal code shapes |
| 48 | chkPostalCodeCoordWithinShapeUS | US | 1174 | Failure | = | = | US coordinates of postal code centroids are within postal code shapes |
| 49 | chkPostalCodeCoordWithinShapeVI | VI | 0 | Success | = | = | VI coordinates of postal code centroids are within postal code shapes |
| 50 | chkPostalCodeLngLatGeography | 0 | Success | = | = | lnglat coordinate column must equal geography column | |
| 51 | chkPostalCodeValidAdminCode1_AD | AD | 0 | Success | = | = | valid admincode1 for AD |
| 52 | chkPostalCodeValidAdminCode1_AR | AR | 0 | Success | = | = | valid admincode1 for AR |
| 53 | chkPostalCodeValidAdminCode1_AT | AT | 0 | Success | = | = | valid admincode1 for AT |
| 54 | chkPostalCodeValidAdminCode1_AU | AU | 0 | Success | = | = | valid admincode1 for AU |
| 55 | chkPostalCodeValidAdminCode1_AX | AX | 0 | Success | = | = | valid admincode1 for AX |
| 56 | chkPostalCodeValidAdminCode1_AZ | AZ | 0 | Success | = | = | valid admincode1 for AZ |
| 57 | chkPostalCodeValidAdminCode1_BD | BD | 0 | Success | = | = | valid admincode1 for BD |
| 58 | chkPostalCodeValidAdminCode1_BE | BE | 0 | Success | = | = | valid admincode1 for BE |
| 59 | chkPostalCodeValidAdminCode1_BG | BG | 0 | Success | = | = | valid admincode1 for BG |
| 60 | chkPostalCodeValidAdminCode1_BM | BM | 0 | Success | = | = | valid admincode1 for BM |
| 61 | chkPostalCodeValidAdminCode1_BR | BR | 0 | Success | = | = | valid admincode1 for BR |
| 62 | chkPostalCodeValidAdminCode1_CA | CA | 0 | Success | = | = | valid admincode1 for CA |
| 63 | chkPostalCodeValidAdminCode1_CH | CH | 0 | Success | = | = | valid admincode1 for CH |
| 64 | chkPostalCodeValidAdminCode1_CL | CL | 0 | Success | = | = | valid admincode1 for CL |
| 65 | chkPostalCodeValidAdminCode1_CN | CN | 0 | Success | = | = | valid admincode1 for CN |
| 66 | chkPostalCodeValidAdminCode1_CO | CO | 0 | Success | = | = | valid admincode1 for CO |
| 67 | chkPostalCodeValidAdminCode1_CR | CR | 0 | Success | = | = | valid admincode1 for CR |
| 68 | chkPostalCodeValidAdminCode1_CY | CY | 0 | Success | = | = | valid admincode1 for CY |
| 69 | chkPostalCodeValidAdminCode1_CZ | CZ | 0 | Success | = | = | valid admincode1 for CZ |
| 70 | chkPostalCodeValidAdminCode1_DE | DE | 0 | Success | = | = | valid admincode1 for DE |
| 71 | chkPostalCodeValidAdminCode1_DK | DK | 0 | Success | = | = | valid admincode1 for DK |
| 72 | chkPostalCodeValidAdminCode1_DZ | DZ | 0 | Success | = | = | valid admincode1 for DZ |
| 73 | chkPostalCodeValidAdminCode1_EE | EE | 0 | Success | = | = | valid admincode1 for EE |
| 74 | chkPostalCodeValidAdminCode1_ES | ES | 0 | Success | = | = | valid admincode1 for ES |
| 75 | chkPostalCodeValidAdminCode1_FM | FM | 0 | Success | = | = | valid admincode1 for FM |
| 76 | chkPostalCodeValidAdminCode1_FR | FR | 0 | Success | = | = | valid admincode1 for FR |
| 77 | chkPostalCodeValidAdminCode1_GB | GB | 0 | Success | = | = | valid admincode1 for GB |
| 78 | chkPostalCodeValidAdminCode1_GF | GF | 0 | Success | = | = | valid admincode1 for GF |
| 79 | chkPostalCodeValidAdminCode1_GT | GT | 0 | Success | = | = | valid admincode1 for GT |
| 80 | chkPostalCodeValidAdminCode1_HR | HR | 0 | Success | = | = | valid admincode1 for HR |
| 81 | chkPostalCodeValidAdminCode1_HT | HT | 0 | Success | = | = | valid admincode1 for HT |
| 82 | chkPostalCodeValidAdminCode1_HU | HU | 0 | Success | = | = | valid admincode1 for HU |
| 83 | chkPostalCodeValidAdminCode1_IE | IE | 0 | Success | = | = | valid admincode1 for IE |
| 84 | chkPostalCodeValidAdminCode1_IN | IN | 0 | Success | = | = | valid admincode1 for IN |
| 85 | chkPostalCodeValidAdminCode1_IT | IT | 0 | Success | = | = | valid admincode1 for IT |
| 86 | chkPostalCodeValidAdminCode1_JP | JP | 0 | Success | = | = | valid admincode1 for JP |
| 87 | chkPostalCodeValidAdminCode1_KR | KR | 0 | Success | = | = | valid admincode1 for KR |
| 88 | chkPostalCodeValidAdminCode1_LI | LI | 0 | Success | = | = | valid admincode1 for LI |
| 89 | chkPostalCodeValidAdminCode1_LK | LK | 0 | Success | = | = | valid admincode1 for LK |
| 90 | chkPostalCodeValidAdminCode1_LT | LT | 0 | Success | = | = | valid admincode1 for LT |
| 91 | chkPostalCodeValidAdminCode1_LU | LU | 0 | Success | = | = | valid admincode1 for LU |
| 92 | chkPostalCodeValidAdminCode1_LV | LV | 0 | Success | = | = | valid admincode1 for LV |
| 93 | chkPostalCodeValidAdminCode1_MA | MA | 0 | Success | = | = | valid admincode1 for MA |
| 94 | chkPostalCodeValidAdminCode1_MP | MP | 0 | Success | = | = | valid admincode1 for MP |
| 95 | chkPostalCodeValidAdminCode1_MQ | MQ | 0 | Success | = | = | valid admincode1 for MQ |
| 96 | chkPostalCodeValidAdminCode1_MT | MT | 0 | Success | = | = | valid admincode1 for MT |
| 97 | chkPostalCodeValidAdminCode1_MW | MW | 0 | Success | = | = | valid admincode1 for MW |
| 98 | chkPostalCodeValidAdminCode1_MX | MX | 0 | Success | = | = | valid admincode1 for MX |
| 99 | chkPostalCodeValidAdminCode1_MY | MY | 0 | Success | = | = | valid admincode1 for MY |
| 100 | chkPostalCodeValidAdminCode1_NC | NC | 0 | Success | = | = | valid admincode1 for NC |
| 101 | chkPostalCodeValidAdminCode1_NL | NL | 0 | Success | = | = | valid admincode1 for NL |
| 102 | chkPostalCodeValidAdminCode1_NO | NO | 0 | Success | = | = | valid admincode1 for NO |
| 103 | chkPostalCodeValidAdminCode1_NZ | NZ | 0 | Success | = | = | valid admincode1 for NZ |
| 104 | chkPostalCodeValidAdminCode1_PE | PE | 0 | Success | = | = | valid admincode1 for PE |
| 105 | chkPostalCodeValidAdminCode1_PF | PF | 0 | Success | = | = | valid admincode1 for PF |
| 106 | chkPostalCodeValidAdminCode1_PK | PK | 0 | Success | = | = | valid admincode1 for PK |
| 107 | chkPostalCodeValidAdminCode1_PL | PL | 0 | Success | = | = | valid admincode1 for PL |
| 108 | chkPostalCodeValidAdminCode1_PM | PM | 0 | Success | = | = | valid admincode1 for PM |
| 109 | chkPostalCodeValidAdminCode1_PR | PR | 0 | Success | = | = | valid admincode1 for PR |
| 110 | chkPostalCodeValidAdminCode1_PT | PT | 0 | Success | = | = | valid admincode1 for PT |
| 111 | chkPostalCodeValidAdminCode1_RO | RO | 0 | Success | = | = | valid admincode1 for RO |
| 112 | chkPostalCodeValidAdminCode1_SE | SE | 0 | Success | = | = | valid admincode1 for SE |
| 113 | chkPostalCodeValidAdminCode1_SJ | SJ | 0 | Success | = | = | valid admincode1 for SJ |
| 114 | chkPostalCodeValidAdminCode1_SK | SK | 0 | Success | = | = | valid admincode1 for SK |
| 115 | chkPostalCodeValidAdminCode1_TH | TH | 0 | Success | = | = | valid admincode1 for TH |
| 116 | chkPostalCodeValidAdminCode1_TR | TR | 42 | Failure | = | = | valid admincode1 for TR |
| 117 | chkPostalCodeValidAdminCode1_UA | UA | 0 | Success | = | = | valid admincode1 for UA |
| 118 | chkPostalCodeValidAdminCode1_UY | UY | 0 | Success | = | = | valid admincode1 for UY |
| 119 | chkPostalCodeValidAdminCode1_US | US | 0 | Success | = | = | valid admincode1 for US |
| 120 | chkPostalCodeValidAdminCode1_WF | WF | 0 | Success | = | = | valid admincode1 for WF |
| 121 | chkPostalCodeValidAdminCode2_AT | AT | 0 | Success | = | = | valid admincode2 for AT |
| 122 | chkPostalCodeValidAdminCode2_AX | AX | 0 | Success | = | = | valid admincode2 for AX |
| 123 | chkPostalCodeValidAdminCode2_BD | BD | 39 | Failure | = | = | valid admincode2 for BD |
| 124 | chkPostalCodeValidAdminCode2_BE | BE | 0 | Success | = | = | valid admincode2 for BE |
| 125 | chkPostalCodeValidAdminCode2_BG | BG | 0 | Success | = | = | valid admincode2 for BG |
| 126 | chkPostalCodeValidAdminCode2_BY | BY | 0 | Success | = | = | valid admincode2 for BY |
| 127 | chkPostalCodeValidAdminCode2_CH | CH | 0 | Success | = | = | valid admincode2 for CH |
| 128 | chkPostalCodeValidAdminCode2_CO | CO | 0 | Success | = | = | valid admincode2 for CO |
| 129 | chkPostalCodeValidAdminCode2_CR | CR | 0 | Success | = | = | valid admincode2 for CR |
| 130 | chkPostalCodeValidAdminCode2_DE | DE | 0 | Success | = | = | valid admincode2 for DE |
| 131 | chkPostalCodeValidAdminCode2_DK | DK | 0 | Success | = | = | valid admincode2 for DK |
| 132 | chkPostalCodeValidAdminCode2_EC | EC | 0 | Success | = | = | valid admincode2 for EC |
| 133 | chkPostalCodeValidAdminCode2_EE | EE | 0 | Success | = | = | valid admincode2 for EE |
| 134 | chkPostalCodeValidAdminCode2_ES | ES | 0 | Success | = | = | valid admincode2 for ES |
| 135 | chkPostalCodeValidAdminCode2_FR | FR | 98 | Failure | = | = | valid admincode2 for FR |
| 136 | chkPostalCodeValidAdminCode2_GF | GF | 0 | Success | = | = | valid admincode2 for GF |
| 137 | chkPostalCodeValidAdminCode2_IT | IT | 0 | Success | = | = | valid admincode2 for IT |
| 138 | chkPostalCodeValidAdminCode2_JP | JP | 0 | Success | = | = | valid admincode2 for JP |
| 139 | chkPostalCodeValidAdminCode2_KR | KR | 0 | Success | = | = | valid admincode2 for KR |
| 140 | chkPostalCodeValidAdminCode2_LT | LT | 0 | Success | = | = | valid admincode2 for LT |
| 141 | chkPostalCodeValidAdminCode2_LU | LU | 0 | Success | = | = | valid admincode2 for LU |
| 142 | chkPostalCodeValidAdminCode2_MA | MA | 0 | Success | = | = | valid admincode2 for MA |
| 143 | chkPostalCodeValidAdminCode2_MQ | MQ | 0 | Success | = | = | valid admincode2 for MQ |
| 144 | chkPostalCodeValidAdminCode2_MW | MW | 0 | Success | = | = | valid admincode2 for MW |
| 145 | chkPostalCodeValidAdminCode2_MX | MX | 0 | Success | = | = | valid admincode2 for MX |
| 146 | chkPostalCodeValidAdminCode2_NC | NC | 0 | Success | = | = | valid admincode2 for NC |
| 147 | chkPostalCodeValidAdminCode2_NL | NL | 1569 | Failure | = | = | valid admincode2 for NL |
| 148 | chkPostalCodeValidAdminCode2_NO | NO | 0 | Success | = | = | valid admincode2 for NO |
| 149 | chkPostalCodeValidAdminCode2_PE | PE | 0 | Success | = | = | valid admincode2 for PE |
| 150 | chkPostalCodeValidAdminCode2_PF | PF | 0 | Success | = | = | valid admincode2 for PF |
| 151 | chkPostalCodeValidAdminCode2_PH | PH | 0 | Success | = | = | valid admincode2 for PH |
| 152 | chkPostalCodeValidAdminCode2_PL | PL | 0 | Success | = | = | valid admincode2 for PL |
| 153 | chkPostalCodeValidAdminCode2_PT | PT | 0 | Success | = | = | valid admincode2 for PT |
| 154 | chkPostalCodeValidAdminCode2_SJ | SJ | 0 | Success | = | = | valid admincode2 for SJ |
| 155 | chkPostalCodeValidAdminCode2_US | US | 269 | Failure | = | = | valid admincode2 for US |
| 156 | chkPostalCodeValidAdminCode3_AT | AT | 0 | Success | = | = | valid admincode3 for AT |
| 157 | chkPostalCodeValidAdminCode3_DE | DE | 0 | Success | = | = | valid admincode3 for DE |
| 158 | chkPostalCodeValidAdminCode3_PL | PL | 0 | Success | = | = | valid admincode3 for PL |
| 159 | chkPostalCodeValidAdminCode4_DE | DE | 0 | Success | = | = | valid admincode4 for DE |
| 160 | chkPostalCodeAdminName1_AD | AD | 0 | Success | = | = | unique admin name1 for AD |
| 161 | chkPostalCodeAdminName1_AT | AT | 0 | Success | = | = | unique admin name1 for AT |
| 162 | chkPostalCodeAdminName1_AX | AX | 0 | Success | = | = | unique admin name1 for AX |
| 163 | chkPostalCodeAdminName1_BD | BD | 0 | Success | = | = | unique admin name1 for BD |
| 164 | chkPostalCodeAdminName1_BE | BE | 0 | Success | = | = | unique admin name1 for BE |
| 165 | chkPostalCodeAdminName1_CA | CA | 0 | Success | = | = | unique admin name1 for CA |
| 166 | chkPostalCodeAdminName1_CH | CH | 0 | Success | = | = | unique admin name1 for CH |
| 167 | chkPostalCodeAdminName1_DE | DE | 0 | Success | = | = | unique admin name1 for DE |
| 168 | chkPostalCodeAdminName1_DK | DK | 0 | Success | = | = | unique admin name1 for DK |
| 169 | chkPostalCodeAdminName1_ES | ES | 0 | Success | = | = | unique admin name1 for ES |
| 170 | chkPostalCodeAdminName1_FI | FI | 0 | Success | = | = | unique admin name1 for FI |
| 171 | chkPostalCodeAdminName1_FR | FR | 0 | Success | = | = | unique admin name1 for FR |
| 172 | chkPostalCodeAdminName1_HR | HR | 0 | Success | = | = | unique admin name1 for HR |
| 173 | chkPostalCodeAdminName1_IN | IN | 0 | Success | = | = | unique admin name1 for IN |
| 174 | chkPostalCodeAdminName1_IT | IT | 0 | Success | = | = | unique admin name1 for IT |
| 175 | chkPostalCodeAdminName1_JP | JP | 0 | Success | = | = | unique admin name1 for JP |
| 176 | chkPostalCodeAdminName1_LI | LI | 0 | Success | = | = | unique admin name1 for LI |
| 177 | chkPostalCodeAdminName1_LU | LU | 0 | Success | = | = | unique admin name1 for LU |
| 178 | chkPostalCodeAdminName1_MX | MX | 0 | Success | = | = | unique admin name1 for MX |
| 179 | chkPostalCodeAdminName1_NL | NL | 0 | Success | = | = | unique admin name1 for NL |
| 180 | chkPostalCodeAdminName1_NO | NO | 0 | Success | = | = | unique admin name1 for NO |
| 181 | chkPostalCodeAdminName1_PL | PL | 0 | Success | = | = | unique admin name1 for PL |
| 182 | chkPostalCodeAdminName1_PR | PR | 0 | Success | = | = | unique admin name1 for PR |
| 183 | chkPostalCodeAdminName1_SE | SE | 0 | Success | = | = | unique admin name1 for SE |
| 184 | chkPostalCodeAdminName1_TR | TR | 0 | Success | = | = | unique admin name1 for TR |
| 185 | chkPostalCodeAdminName1_US | US | 0 | Success | = | = | unique admin name1 for US |
| 186 | chkPostalCodeAdminName2_AT | AT | 0 | Success | = | = | unique admin name2 for AT |
| 187 | chkPostalCodeAdminName2_AX | AX | 0 | Success | = | = | unique admin name2 for AX |
| 188 | chkPostalCodeAdminName2_BD | BD | 0 | Success | = | = | unique admin name2 for BD |
| 189 | chkPostalCodeAdminName2_BE | BE | 0 | Success | = | = | unique admin name2 for BE |
| 190 | chkPostalCodeAdminName2_CH | CH | 0 | Success | = | = | unique admin name2 for CH |
| 191 | chkPostalCodeAdminName2_DE | DE | 0 | Success | = | = | unique admin name2 for DE |
| 192 | chkPostalCodeAdminName2_DK | DK | 0 | Success | = | = | unique admin name2 for DK |
| 193 | chkPostalCodeAdminName2_ES | ES | 0 | Success | = | = | unique admin name2 for ES |
| 194 | chkPostalCodeAdminName2_FI | FI | 0 | Success | = | = | unique admin name2 for FI |
| 195 | chkPostalCodeAdminName2_FR | FR | 0 | Success | = | = | unique admin name2 for FR |
| 196 | chkPostalCodeAdminName2_IT | IT | 0 | Success | = | = | unique admin name2 for IT |
| 197 | chkPostalCodeAdminName2_JP | JP | 0 | Success | = | = | unique admin name2 for JP |
| 198 | chkPostalCodeAdminName2_LU | LU | 0 | Success | = | = | unique admin name2 for LU |
| 199 | chkPostalCodeAdminName2_MX | MX | 0 | Success | = | = | unique admin name2 for MX |
| 200 | chkPostalCodeAdminName2_NL | NL | 0 | Success | = | = | unique admin name2 for NL |
| 201 | chkPostalCodeAdminName2_NO | NO | 0 | Success | = | = | unique admin name2 for NO |
| 202 | chkPostalCodeAdminName2_PL | PL | 0 | Success | = | = | unique admin name2 for PL |
| 203 | chkPostalCodeAdminName2_US | US | 0 | Success | = | = | unique admin name2 for US |
| 204 | chkPostalCodeAdminName3_AT | AT | 0 | Success | = | = | unique admin name3 for AT |
| 205 | chkPostalCodeAdminName3_CH | CH | 0 | Success | = | = | unique admin name3 for CH |
| 206 | chkPostalCodeAdminName3_CR | CR | 0 | Success | = | = | unique admin name3 for CR |
| 207 | chkPostalCodeAdminName3_DE | DE | 0 | Success | = | = | unique admin name3 for DE |
| 208 | chkPostalCodeAdminName3_ES | ES | 0 | Success | = | = | unique admin name3 for ES |
| 209 | chkPostalCodeAdminName3_FI | FI | 0 | Success | = | = | unique admin name3 for FI |
| 210 | chkPostalCodeAdminName3_FR | FR | 0 | Success | = | = | unique admin name3 for FR |
| 211 | chkPostalCodeAdminName3_PL | PL | 0 | Success | = | = | unique admin name3 for PL |
| 212 | chkPostalCodeAdminName4_DE | DE | 0 | Success | = | = | unique admin name4 for DE |
| 213 | chkPostalCodeAdminName4_FR | FR | 0 | Success | = | = | unique admin name4 for FR |
| 214 | chkPostalCodeAdmin1 | 37 | Failure | = | = | zip_code admin1geonameid must not be null | |
| 215 | chkPostalCodeWithinAdm1 | 5470 | Failure | = | = | postal codes within their admin codes1 bbox | |
| 216 | chkPostalCodeWithinAdm2 | 17318 | Failure | = | = | postal codes within their admin codes2 bbox | |
| 217 | chkPostalCodeWithinAdm3 | 19584 | Failure | = | = | postal codes within their admin codes3 bbox | |
| 218 | chkPostalCodeWithinShapeAdm1 | 13 | Failure | = | = | postal codes within their admin codes1 shape | |
| 219 | chkPostalCodeAdmin1FeatureCode | 0 | Success | = | = | admin1geonameid linked to ADM1 | |
| 220 | chkPostalCodeAdmin2FeatureCode | 18477 | Failure | = | = | admin2geonameid linked to ADM2 | |
| 221 | chkPostalCodeAdmin3FeatureCode | 3529 | Failure | = | = | admin3geonameid linked to ADM3 | |
| 222 | chkPostalCodeAdmin4FeatureCode | 0 | Success | = | [64] | admin4geonameid linked to ADM4 | |
| 223 | chkPostalCodeAdmin1FeatureExists | 0 | Success | = | = | admin1geonameid feature exists | |
| 224 | chkPostalCodeAdmin2FeatureExists | 187 | Failure | = | = | admin2geonameid feature exists | |
| 225 | chkPostalCodeAdmin3FeatureExists | 4 | Failure | = | = | admin3geonameid feature exists | |
| 226 | chkPostalCodeAdmin4FeatureExists | 0 | Success | = | = | admin4geonameid feature exists | |
| 227 | chkPostalCodeAdmin4CodeEqGeoNameAdm4Code | 0 | Success | = | [66] | adm4code from zip_code same as adm4 code from geoname table | |
| 228 | chkPostalCodeCities1000_CH | CH | 52 | Failure | = | = | cities1000 have postal code in alternatenames CH |
| 229 | chkPostalCodeCities1000_FR | FR | 79 | Failure | = | = | cities1000 have postal code in alternatenames FR |
| 230 | chkPostalCodeNotMatched_DE | DE | 8249 | Failure | = | = | postal codes not matched to gazetteer DE |
| 231 | chkPostalCodeNotMatched_IT | IT | 2552 | Failure | = | = | postal codes not matched to gazetteer IT |
| 232 | chkPostalCodePlacehullMatch_AT | AT | 837 | Failure | = | = | convex hull from addresses has geonameid |
| 233 | chkPostalCodePlacehullMatch_AU | AU | 790 | Failure | = | = | convex hull from addresses has geonameid |
| 234 | chkPostalCodePlacehullMatch_AX | AX | 0 | Success | = | = | convex hull from addresses has geonameid |
| 235 | chkPostalCodePlacehullMatch_CC | CC | 0 | Success | = | = | convex hull from addresses has geonameid |
| 236 | chkPostalCodePlacehullMatch_CH | CH | 31 | Failure | = | = | convex hull from addresses has geonameid |
| 237 | chkPostalCodePlacehullMatch_CX | CX | 0 | Success | = | = | convex hull from addresses has geonameid |
| 238 | chkPostalCodePlacehullMatch_DK | DK | 4 | Failure | = | = | convex hull from addresses has geonameid |
| 239 | chkPostalCodePlacehullMatch_ES | ES | 8509 | Failure | = | = | convex hull from addresses has geonameid |
| 240 | chkPostalCodePlacehullMatch_FI | FI | 424 | Failure | = | = | convex hull from addresses has geonameid |
| 241 | chkPostalCodePlacehullMatch_FR | FR | 539 | Failure | = | = | convex hull from addresses has geonameid |
| 242 | chkPostalCodePlacehullMatch_GF | GF | 0 | Success | = | = | convex hull from addresses has geonameid |
| 243 | chkPostalCodePlacehullMatch_GP | GP | 0 | Success | = | = | convex hull from addresses has geonameid |
| 244 | chkPostalCodePlacehullMatch_IS | IS | 31 | Failure | = | = | convex hull from addresses has geonameid |
| 245 | chkPostalCodePlacehullMatch_LU | LU | 7 | Failure | = | = | convex hull from addresses has geonameid |
| 246 | chkPostalCodePlacehullMatch_MQ | MQ | 0 | Success | = | = | convex hull from addresses has geonameid |
| 247 | chkPostalCodePlacehullMatch_NF | NF | 0 | Success | = | = | convex hull from addresses has geonameid |
| 248 | chkPostalCodePlacehullMatch_NL | NL | 3 | Failure | = | = | convex hull from addresses has geonameid |
| 249 | chkPostalCodePlacehullMatch_NO | NO | 207 | Failure | = | = | convex hull from addresses has geonameid |
| 250 | chkPostalCodePlacehullMatch_PL | PL | 13322 | Failure | = | = | convex hull from addresses has geonameid |
| 251 | chkPostalCodePlacehullMatch_RE | RE | 0 | Success | = | = | convex hull from addresses has geonameid |
| 252 | chkPostalCodePlacehullMatch_SJ | SJ | 0 | Success | = | = | convex hull from addresses has geonameid |
| 253 | chkPostalCodePlacehullMatch_YT | YT | 0 | Success | = | = | convex hull from addresses has geonameid |
| 254 | chkPostalCodeEqualDist_AT | AT | 0 | Success | = | = | same postalcodes must not be far away AT |
| 255 | chkPostalCodeEqualDist_ES | ES | 34 | Failure | = | = | same postalcodes must not be far away ES |
| 256 | chkPostalCodeEqualDist_IT | IT | 5 | Failure | = | = | same postalcodes must not be far away IT |
| 257 | chkPostalCodeEqualDist_MX | MX | 2131 | Failure | = | = | same postalcodes must not be far away MX |
| 258 | chkPostalCodeEqualDist_PT | PT | 0 | Success | = | = | same postalcodes must not be far away PT |
| 259 | chkPostalCodeEqualDist_US | US | 0 | Success | = | = | same postalcodes must not be far away US |
| 260 | chkPostalCodeAlternateName | 242 (24w) | Failure | = | [239] | postal codes as alternatenames must also be present in postal code table | |
| 261 | chkPostalCodeAsAlternateName_LU | 313 | Failure | = | = | all postalcodes exist as alternatenames | |
| 262 | chkPostalCodeAsAlternateName_DK | 560 | Failure | = | = | all postalcodes exist as alternatenames | |
| 263 | chkPostalCodeAsAlternateName_NL | 28 | Failure | = | = | all postalcodes exist as alternatenames |
by unxos gmbh
GeoNames Home • Postal Codes • Download / Webservice • Forum • Blog • Sitemap