Skip to content

Street Number

Type Registry

Street Number

geography.address.street_number

House or building number on a street (e.g., 123, 456B). May include letters for sub-addresses or designations.

Domain geography›address
Casts to VARCHAR
Scope Universal

Try it

CLI 
$ finetype infer -i "123"
→ geography.address.street_number

DuckDB

Detect 
SELECT finetype('123');
-- → 'geography.address.street_number'
Cast expression 
CAST({col} AS VARCHAR)
Safe cast pipeline 
-- Normalise and cast in one step
SELECT TRY_CAST(finetype_cast(my_column) AS VARCHAR) AS clean_value
FROM my_table
WHERE finetype(my_column) = 'geography.address.street_number';

Struct Expansion

numeric_part: REGEXP_EXTRACT({col}, '^([0-9]+)')
suffix: REGEXP_EXTRACT({col}, '[0-9]+([A-Z]*)$')

JSON Schema

finetype schema geography.address.street_number 
{
  "$id": "https://noon.sh/schemas/geography.address.street_number",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "House or building number on a street (e.g., 123, 456B). May include letters for sub-addresses or designations.",
  "examples": [
    "123",
    "456B",
    "100-102",
    "12 1/2",
    "45A/B"
  ],
  "pattern": "^[0-9]+[A-Z]?(/[A-Z])?(-[0-9]+[A-Z]?)?( 1/2)?$",
  "title": "Street Number",
  "type": "string"
}

Examples

123456B100-10212 1/245A/B

Also known as

house_number

Types in geography