JetBrains / JetBrains/Exposed

Support for Geometry Column type

Open
#1,439 2 comments 10 reactions 0 assignees View on GitHub
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.