Skip to content

Map view for spatial results #2532

Description

@datlechin

Problem

A query returning geometry shows WKB hex or WKT text. PostGIS, MySQL spatial, SQL Server geography and DuckDB spatial all produce data that only means something on a map, and there is nowhere to see it.

Proposed solution

  • A Map view beside the grid and the JSON view, shown only when the result holds a geometry column.
  • Points, lines and polygons drawn with MapKit, over Apple's own tiles, so nothing is sent to a third-party tile server.
  • Click a shape to select its row in the grid, and select a row to highlight its shape.
  • Fit to the result's extent, and say plainly when the SRID is not one that can be projected.

Alternatives considered

Paste WKT into a web viewer, which sends the data to someone else.

Related database type

PostgreSQL

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions