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

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

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