这是indexloc提供的服务,不要输入任何密码
Skip to content

Using both: geography and geometry types #1983

@asindl

Description

@asindl

This is not an issues, but a question:
We have dozens of geospatial tables in our database. The geospatial columns are of geometry type. We would like to use Hasura geospatial "metric" operators like _st_d_within and therefore would need geography types.
Is there yet another way then
a) double the size of our tables by adding a geography column next to the geometry column (pretty much holding exactly the same information as the geometry column)
b) create a view for each table casting to geography in an additional column?

Preferred would be something like casting the geometry column to geography in the Hasura query, but I am not aware if that is possible at all.

Metadata

Metadata

Assignees

Labels

c/serverRelated to serverk/enhancementNew feature or improve an existing featurep/highcandidate for being included in the upcoming sprint

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions