MeridianMERIDIAN

geography

Locations, addresses, coordinates, and regional identifiers

Type Registry

geography

Locations, addresses, coordinates, and regional identifiers

25 types

address

4
Full Addressfull_address
VARCHAR123 Main Street, New York, N…
Postal Codepostal_code
VARCHAR10001
Street Namestreet_name
VARCHARMain Street
Street Suffixstreet_suffix
VARCHARStreet

contact

1
International Calling Codecalling_code
VARCHAR+1

coordinate

7
Coordinate Pair (Lat, Lon)coordinates
POINT40.7128,-74.0060
Degrees Minutes Secondsdms
VARCHAR40°26'46"N 79°58'56"W
Geohashgeohash
VARCHAR9q8yyk8yuv
Latitudelatitude
DOUBLE40.7128
Longitudelongitude
DOUBLE-74.0060
Military Grid Reference Systemmgrs
VARCHAR18SUJ2348306479
Plus Code (Open Location Code)plus_code
VARCHAR849VCWC8+R9

format

2
GeoJSON Geometrygeojson
VARCHAR{"type": "Point", "coordinat…
Well-Known Text Geometrywkt
VARCHARPOINT (30 10)

index

1
H3 Hex Indexh3
VARCHAR8928308280fffff

location

5
City Namecity
VARCHARNew York
Continent Namecontinent
VARCHARNorth America
Country Namecountry
VARCHARUnited States
Country Codecountry_code
VARCHARUS
Region / Stateregion
VARCHARCalifornia

transportation

5
HS Tariff Codehs_code
VARCHAR8471.30
IATA Airport Codeiata_code
VARCHARJFK
ICAO Airport Codeicao_code
VARCHARKJFK
Shipping Container Code (ISO 6346)iso6346
VARCHARMSCU1234567
UN/LOCODEunlocode
VARCHARUSLAX

Type Registry