Support for Geometry Column type
- Dominant language
- Kotlin
- Stars
- 9.3k
- Forks
- 798
- Avg merge
- 4d 2h
- Merged PRs (30d)
- 26
Description
Do Kotlin Exposed support Geometry column type?
I have a table defined as follows:
```
'CREATE TABLE `location` (
`ID` char(32) NOT NULL,
`Org` char(32) DEFAULT NULL,
`Location` char(32) DEFAULT NULL,
`coordinates` geometry NOT NULL,
PRIMARY KEY (`ID`),
SPATIAL KEY `coordinates` (`coordinates`)
)
```
I need to write a query to fetch the location based on coordinates, here is query:
```
SET @g = ST_GeomFromText('POINT(-73.95736819580677 40.67380811099114)');
SELECT id,org,location,ST_AsText(coordinates) AS coordinates,
ST_X(coordinates) AS longitude, ST_Y(coordinates) AS latitude
FROM sosdb.locationlatlong
WHERE
ST_Distance_Sphere(coordinates, @g) < '2800';
```
Contributor guide
Assessment
This issue has not been assessed yet.