Examples of Common Address and Personal Data
RiskClasses
- Description
-
Masks address data while preserving similar hazard zone or risk class classifications. This method requires the lookup table RiskByAddresses to be installed and populated with address and risk class data.
- Input type
-
COLUMN
- Parameters
| Display name | Description | Variable name | Data type | Default value | Possible values |
|---|---|---|---|---|---|
City |
Address component: City |
city |
STRING |
- |
- |
Zip |
Address component: ZipCode |
zip |
STRING |
- |
- |
Street |
Address component: Street |
street |
STRING |
- |
- |
House number |
Address component: House number |
housenumber |
STRING |
- |
- |
GK |
Flood Hazard Classes (1 -4) |
gk |
STRING |
- |
- |
SGK |
Heavy rain class (1 - 3) |
sgk |
STRING |
- |
- |
Zone |
Zone of stream (B), coastal (K), island (I) |
zone |
STRING |
- |
- |
EMS |
Seismic hazard estimation (1 - 12). |
ems |
STRING |
- |
- |
SLZ |
Snow load zones (1, 1a, 2, 2a, 3, 3a). |
slz |
STRING |
- |
- |
LDV |
Lightning density (0 - 4). |
ldv |
STRING |
- |
- |
State
- Description
-
Generates an administrative country subdivision name based on the specified seed value. The country parameter specifies the country/region of origin ('US', 'DE', 'FR', 'IT', 'NL', 'AT', 'BE', 'CA', 'CH', 'UK'). Only a single country value can be specified (e.g. 'DE'). This method requires the lookup tables to be installed.
- Input type
-
COLUMN
- Parameters
| Display name | Description | Variable name | Data type | Default value | Possible values |
|---|---|---|---|---|---|
Seed |
Column that is used to calculate the hash. |
seed |
STRING |
- |
- |
Country |
Specifies the origin of the state name. |
country |
STRING |
- |
- |
City
- Description
-
Generates a city name based on the specified seed value. The country parameter specifies the country/region of origin ('US', 'DE', 'FR', 'IT', 'NL', 'AT', 'BE', 'CA', 'CH', 'UK'). Only a single country value can be specified (e.g. 'DE'). This method requires the lookup tables to be installed.
- Input type
-
COLUMN
- Parameters
| Display name | Description | Variable name | Data type | Default value | Possible values |
|---|---|---|---|---|---|
Seed |
Column that is used to calculate the hash. |
seed |
STRING |
- |
- |
Country |
Specifies the origin of the city. |
country |
STRING |
- |
- |
E Mail
- Description
-
Generates an email address based on the specified seed value. The country parameter specifies the country/region of origin for the first name ('EN', 'DE', 'FR', 'IT', 'NL'). The sex parameter specifies the sex ('M' for male, 'F' for female). For both parameters, only a single value can be specified (e.g. 'DE' and 'F'). The domain parameter specifies the domain name of the email address. If the domain parameter is omitted, it defaults to 'example.com'. This method requires the lookup tables to be installed.
- Input type
-
COLUMN
- Parameters
| Display name | Description | Variable name | Data type | Default value | Possible values |
|---|---|---|---|---|---|
Seed |
Specifies the value that is used to calculate the hash. |
seed |
STRING |
- |
- |
Country |
Specifies the origin of the email. |
country |
STRING |
- |
- |
Sex |
Specifies the gender of the first name. |
sex |
STRING |
- |
- |
Domain |
Domain that is used to generate e-mail addresses. |
domain |
STRING |
example.com |
- |
First name
- Description
-
Generates a first name based on the specified seed value. The country parameter specifies the country/region of origin for the first name ('EN', 'DE', 'FR', 'IT', 'NL'). The sex parameter specifies the sex ('M' for male, 'F' for female). For both parameters, only a single value can be specified (e.g. 'DE' and 'F'). This method requires the lookup tables to be installed.
- Input type
-
COLUMN
- Parameters
| Display name | Description | Variable name | Data type | Default value | Possible values |
|---|---|---|---|---|---|
Seed |
Specifies the value that is used to calculate the hash. |
seed |
STRING |
- |
- |
Country |
Specifies the origin of the first name. |
country |
STRING |
- |
- |
Sex |
Specifies the gender of the first name. |
sex |
STRING |
- |
- |
Last name
- Description
-
Generates a last name based on the specified seed value. The country parameter specifies the country/region of origin for the last name ('EN', 'DE', 'FR', 'IT', 'NL'). Only a single country value can be specified (e.g. 'DE'). This method requires the lookup tables to be installed.
- Input type
-
COLUMN
- Parameters
| Display name | Description | Variable name | Data type | Default value | Possible values |
|---|---|---|---|---|---|
Seed |
Specifies the value that is used to calculate the hash. |
seed |
STRING |
- |
- |
Country |
Specifies the origin of the last name. |
country |
STRING |
- |
- |
Latitude
- Description
-
Generates a latitude component of geographical coordinates based on the specified seed value. The country parameter specifies the country/region of origin ('US', 'DE', 'FR', 'IT', 'NL', 'AT', 'BE', 'CA', 'CH', 'UK'). Only a single country value can be specified (e.g. 'DE'). This method requires the lookup tables to be installed.
- Input type
-
COLUMN
- Parameters
| Display name | Description | Variable name | Data type | Default value | Possible values |
|---|---|---|---|---|---|
Seed |
Column that is used to calculate the hash. |
seed |
STRING |
- |
- |
Country |
Specifies the origin of the latitude. |
country |
STRING |
- |
- |
Longitude
- Description
-
Generates the longitude component of geographical coordinates based on the specified seed value. The country parameter specifies the country/region of origin ('US', 'DE', 'FR', 'IT', 'NL', 'AT', 'BE', 'CA', 'CH', 'UK'). Only a single country value can be specified (e.g. 'DE'). This method requires the lookup tables to be installed.
- Input type
-
COLUMN
- Parameters
| Display name | Description | Variable name | Data type | Default value | Possible values |
|---|---|---|---|---|---|
Seed |
Column that is used to calculate the hash. |
seed |
STRING |
- |
- |
Country |
Specifies the origin of the longitude. |
country |
STRING |
- |
- |
Postal Code
- Description
-
Generates a postal code based on the specified seed value. The country parameter specifies the country/region of origin ('US', 'DE', 'FR', 'IT', 'NL', 'AT', 'BE', 'CA', 'CH', 'UK'). Only a single country value can be specified (e.g. 'DE'). This method requires the lookup tables to be installed.
- Input type
-
COLUMN
- Parameters
| Display name | Description | Variable name | Data type | Default value | Possible values |
|---|---|---|---|---|---|
Seed |
Column that is used to calculate the hash. |
seed |
STRING |
- |
- |
Country |
Specifies the origin of the postal code. |
country |
STRING |
- |
- |
Street
- Description
-
Generates a street name based on the specified seed value. The country parameter specifies the country/region of origin ('US', 'DE', 'FR', 'IT', 'NL', 'AT', 'BE', 'CA', 'CH', 'UK'). Only a single country value can be specified (e.g. 'DE'). This method requires the lookup tables to be installed.
- Input type
-
COLUMN
- Parameters
| Display name | Description | Variable name | Data type | Default value | Possible values |
|---|---|---|---|---|---|
Seed |
Column that is used to calculate the hash. |
seed |
STRING |
- |
- |
Country |
Specifies the origin of the street name. |
country |
STRING |
- |
- |