hasura/graphql-engine

Support for ST_Transform of PostGIS

Open

#3,229 opened on Oct 24, 2019

View on GitHub
 (4 comments) (0 reactions) (1 assignee)TypeScript (31,371 stars) (2,787 forks)batch import
a/data/postgresc/servere/easygood first issuek/enhancementp/medium

Description

How can I use ST_Transform postgis function to transform ESPG from one to another projection? From this official document, the query looks like

ST_Transform(geometry g1, integer srid) example - ST_Transform(way, 4326)

Contributor guide

Tech stack
typescriptsqlpostgresqlgraphql
Domain
backenddatabase
Issue type
feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
4
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
3-5 days
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
stale
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
needs investigation
Prerequisites
Basic knowledge of PostGISUnderstanding of Hasura GraphQL Engine
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
30
Research direction
First, investigate if Hasura already supports ST Transform via custom SQL functions or if there is a configuration to enable PostGIS functions. Check the official Hasura documentation and GitHub issues for similar requests. Look at the Hasura source code in the repository, particularly in the server side handling of Postgres functions, to understand how to expose PostGIS functions through GraphQL. Comment on the issue to ask for clarification on expected usage and whether it should be a built in or custom function.