Geographic types

GEO_POINT and GEO_SHAPE

geo_point — stores a single latitude/longitude pair. geo_shape — stores complex geographical shapes (polygons, lines).

Example:

CREATE TABLE locations (
    name TEXT,
    coord GEO_POINT
);

INSERT INTO locations (name, coord)
VALUES ('HQ', [52.5200, 13.4050]);