h2gis icon indicating copy to clipboard operation
h2gis copied to clipboard

Published 20 hours ago • verified publisher icon orbisgis

Geography type support

Open cpoissonnier opened this issue 7 years ago • 6 comments

Hi,

It would be great to support Geography type.

I would like to use H2GIS as test database, but when I create my table, I have this error :

Caused by: org.h2.jdbc.JdbcSQLException: Unknown data type: "GEOGRAPHY"; SQL statement:

Thanks

cpoissonnier avatar Nov 22 '17 16:11 cpoissonnier

Not planed yet. Maybe It could be possible in the future thanks to JTS 2.0.

ebocher avatar Nov 22 '17 20:11 ebocher

Ok, thanks. Kenavo !

cpoissonnier avatar Nov 23 '17 11:11 cpoissonnier

Hello! Is there any chance this feature is in the works?

blaze515 avatar Feb 14 '19 20:02 blaze515

hi can I write Geography type ?

seidlmatus avatar Nov 30 '20 14:11 seidlmatus

Hi @seidlmatus If you mean "can I code / develop the geography type ?" the answer is "your help is welcome!". But if I'm not wrong, it seems that this geography type has to be written in the @h2database side.

@ebocher @katzyn

gpetit avatar Dec 04 '20 14:12 gpetit

What is a difference between GEOMETRY and GEOGRAPHY? X and Y coordinates need to be limited to -180…180 and -90…90. What else? Fixed predefined SRID? But there are multiple coordinate systems in use, such as WGS84 and SGS85. Can it have geometry type and dimension system constraints such as POINT Z, GEOMETRY M etc.?

What are the real benefits of separate data type? CREATE DOMAIN GEOGRAPHY AS GEOMETRY(4326) CHECK (ST_XMax(VALUE) <= 180 AND …) isn't good enough?

If you really need such data type it should be carefully designed first.

katzyn avatar Dec 04 '20 14:12 katzyn