coordinate
A position on the earth: latitude and longitude in decimal degrees, alone or as a pair, or in degrees, minutes and seconds, or as a geohash, a plus code or a military grid reference.
7 coordinate types: 1 a sibling also accepts and reads alike, 2 that decompose into parts.
The 7 coordinate types
Each type's first registry sample, against every sibling's rule
| Type | Sample | Also accepted by |
|---|---|---|
Longitude longitude · DOUBLE | -74.0060 | latitude |
Coordinate Pair (Lat, Lon) coordinates · POINT | 40.7128,-74.0060 | — |
Degrees Minutes Seconds dms · VARCHAR | 40°26'46"N 79°58'56"W | — |
Geohash geohash · VARCHAR | 9q8yyk8yuv | — |
Latitude latitude · DOUBLE | 40.7128 | — |
Military Grid Reference System mgrs · VARCHAR | 18SUJ2348306479 | — |
Plus Code (Open Location Code) plus_code · VARCHAR | 849VCWC8+R9 | — |
Which coordinate type is it?
1 of 7 coordinate types accepts it.
Longitude carries no pattern or format, so it has no rule to ask.
| Type | Reads it as |
|---|---|
Latitude latitude | -74.006 |
How the engine tells them apart
- Longitude — Column-mode: if any |value| > 90 → longitude (latitude max is 90).
Use it
Shell
printf '%s\n' '-74.0060' '151.2093' > column.txt
finetype infer -f column.txt --mode columnDuckDB
SELECT ft_profile(v) FROM (VALUES ('-74.0060'), ('151.2093')) t(v);No coordinate type's rule accepts 151.2093.