databend icon indicating copy to clipboard operation
databend copied to clipboard

Feature: Support geometry functions

Open b41sh opened this issue 9 months ago • 2 comments

Summary

Conversion, Input, Parsing

  • [x] ST_GEOGFROMGEOHASH
  • [x] ST_GEOGPOINTFROMGEOHASH
  • [x] ST_GEOMETRYFROMWKB
  • [x] ST_GEOMETRYFROMWKT
  • [x] ST_GEOMFROMGEOHASH
  • [x] ST_GEOMPOINTFROMGEOHASH
  • [x] TO_GEOMETRY
  • [x] TRY_TO_GEOMETRY

Conversion, Output, Formatting

  • [x] ST_ASGEOJSON
  • [x] ST_ASWKB
  • [x] ST_ASBINARY
  • [x] ST_ASEWKB
  • [x] ST_ASWKT
  • [x] ST_ASTEXT
  • [x] ST_ASEWKT
  • [x] ST_GEOHASH

Constructor

  • [x] ST_MAKELINE
  • [x] ST_MAKEGEOMPOINT
  • [x] ST_GEOMPOINT
  • [x] ST_MAKEPOLYGON
  • [x] ST_POLYGON

Accessor

  • [x] ST_DIMENSION
  • [x] ST_ENDPOINT
  • [x] ST_POINTN
  • [x] ST_SRID
  • [x] ST_STARTPOINT
  • [x] ST_X
  • [x] ST_XMAX
  • [x] ST_XMIN
  • [x] ST_Y
  • [x] ST_YMAX
  • [x] ST_YMIN

Relationship and Measurement

  • [x] HAVERSINE
  • [ ] ST_AREA
  • [ ] ST_AZIMUTH
  • [x] ST_CONTAINS
  • [ ] ST_COVEREDBY
  • [ ] ST_COVERS
  • [ ] ST_DISJOINT
  • [x] ST_DISTANCE
  • [ ] ST_DWITHIN
  • [ ] ST_HAUSDORFFDISTANCE
  • [ ] ST_INTERSECTS
  • [x] ST_LENGTH
  • [x] ST_NPOINTS
  • [ ] ST_NUMPOINTS
  • [ ] ST_PERIMETER
  • [ ] ST_WITHIN

Transformation

  • [ ] ST_BUFFER
  • [ ] ST_CENTROID
  • [ ] ST_COLLECT
  • [ ] ST_DIFFERENCE
  • [ ] ST_ENVELOPE
  • [ ] ST_INTERSECTION
  • [ ] ST_INTERSECTION_AGG
  • [x] ST_SETSRID
  • [ ] ST_SIMPLIFY
  • [ ] ST_SYMDIFFERENCE
  • [x] ST_TRANSFORM
  • [ ] ST_UNION
  • [ ] ST_UNION_AGG

Utility

  • [ ] ST_ISVALID

b41sh avatar May 07 '24 03:05 b41sh

Hi @kkk25641463 Thanks for your continue contribute to geometry functions, you can pick this issue so that we can better track the progress.

b41sh avatar May 07 '24 03:05 b41sh

Hi @kkk25641463 Thanks for your continue contribute to geometry functions, you can pick this issue so that we can better track the progress.

OK. Some of the functions above only apply to geography types and will be implemented after the geography type is implemented

kkk25641463 avatar May 07 '24 03:05 kkk25641463