-
Notifications
You must be signed in to change notification settings - Fork 2.8k
Closed
Labels
c/serverRelated to serverRelated to serverk/enhancementNew feature or improve an existing featureNew feature or improve an existing featurep/highcandidate for being included in the upcoming sprintcandidate for being included in the upcoming sprint
Description
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.
friend0
Metadata
Metadata
Assignees
Labels
c/serverRelated to serverRelated to serverk/enhancementNew feature or improve an existing featureNew feature or improve an existing featurep/highcandidate for being included in the upcoming sprintcandidate for being included in the upcoming sprint