Geography

Type Registry

geography

Locations, addresses, coordinates, and regional identifiers

16 types

address

5

Full Address full_address

VARCHAR 123 Main Street, New Yor…

Postal Code postal_code

VARCHAR 10001

Street Name street_name

VARCHAR Main Street

Street Number street_number

VARCHAR 123

Street Suffix street_suffix

VARCHAR Street

contact

1

International Calling Code calling_code

VARCHAR +1

coordinate

3

Coordinate Pair (Lat, Lon) coordinates

POINT 40.7128,-74.0060

Latitude latitude

DOUBLE 40.7128

Longitude longitude

DOUBLE -74.0060

location

5

City Name city

VARCHAR New York

Continent Name continent

VARCHAR North America

Country Code country_code

VARCHAR US

Country Name country

VARCHAR United States

Region / State region

VARCHAR California

transportation

2

IATA Airport Code iata_code

VARCHAR JFK

ICAO Airport Code icao_code

VARCHAR KJFK