databend
databend copied to clipboard
Feature: Support geometry functions
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
Hi @kkk25641463 Thanks for your continue contribute to geometry functions, you can pick this issue so that we can better track the progress.
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