New Address Parsing and Standardization Functions

Version: 1.10.2

Date: June 26, 2025

This update focuses on enhancing the address parsing and standardization capabilities of the Wherobots Cloud platform.

Customer-facing Changes¶

This release introduces two powerful Spatial SQL functions for address data processing, based on the libpostallibrary:

ExpandAddress: This new function normalizes and expands address strings into their canonical forms. It's useful for cleaning address data by converting common abbreviations into their full-text equivalents (e.g., "st" becomes "street," "apt" becomes "apartment"). This standardization makes addresses easier to process, compare, and geocode accurately.
ParseAddress: This new function breaks down a single address string into its individual components. It identifies and extracts elements like house number, street, city, state, and postcode, returning them in a structured format. This is ideal for when you need to analyze or query specific parts of an address.