1
74%
BABEL_5_X_DEV: 77%

Ran 05 Aug 2024 12:47PM UTC

Files 114

Run time 5s

Badge

Embed ▾

Committed 05 Aug 2024 12:00PM UTC coverage: 73.558% (+0.008%) from 73.55%

Job # 10248362694.1

Build Type

push

github

Committed by

web-flow

Commit Message

Supported STContains, STEquals, STArea PostGIS functions for Geospatial datatypes (#2831)

Implemented GeoSpatial sql functions STContains(), STEquals(), STArea() and STSrid().

DECLARE @point1 geography, @point2 geography;
SET @point1 = geography::STGeomFromText('POINT(-122.354657658684900 47.658678768678100)', 4326);
SET @point2 = geography::STGeomFromText('POINT(-122.354657658684900 47.658678768678100)', 4326);
SELECT @point1.STContains(@point2) AS isIN;
go

Output:
isIN
------
1

DECLARE @point1 geography, @point2 geography;
SET @point1 = geography::STGeomFromText('POINT(-122.354657658684900 47.658678768678100)', 4326);
SET @point2 = geography::STGeomFromText('POINT(-122.354657658684900 47.658678768678100)', 4326);
SELECT @point1.STEquals(@point2) AS Equals;
go

Output:
Equals
------
1

DECLARE @point1 geography;
SET @point1 = geography::STGeomFromText('POINT(-122.354657658684900 47.658678768678100)', 4326);
SELECT @point1.STArea() AS Area;
go

Output:
Area
------
0

Task: BABEL-5101

Signed-off-by: yashneet vinayak yashneet@amazon.com

Run Details

42488 of 57761 relevant lines covered (73.56%)

110775.25 hits per line

babelfish-for-postgresql / babelfish_extensions / 10248362694 / 1
74%
BABEL_5_X_DEV: 77%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Source Files on job 10248362694.1

babelfish-for-postgresql / babelfish_extensions / 10248362694 / 1 74% BABEL_5_X_DEV: 77%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Source Files on job 10248362694.1

babelfish-for-postgresql / babelfish_extensions / 10248362694 / 1
74%
BABEL_5_X_DEV: 77%

README BADGES
x