h2gis Geography type support

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

Nov 22 '17 16:11 cpoissonnier

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

Nov 22 '17 20:11 ebocher

Ok, thanks. Kenavo !

Nov 23 '17 11:11 cpoissonnier

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

Feb 14 '19 20:02 blaze515

hi can I write Geography type ?

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

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.

Dec 04 '20 14:12 katzyn