The Stack Overflow podcast is back! Listen to an interview with our new CEO.

Questions tagged [h2gis]

H2GIS is a spatial extension to the H2 database, in the same way that PostGIS is an extension to PostgreSQL.

Filter by
Sorted by
Tagged with
0
votes
1answer
50 views

Improve Performance of ST_DWithin - H2GIS

I have a table seg_point, that I create like this: CREATE TABLE seg_point (id INT AUTO_INCREMENT PRIMARY KEY, segmentid TEXT, geom GEOMETRY); And I'm trying to improve the performance of this query ...
0
votes
0answers
47 views

Some strange location in H2 DB for GIS Detail?

I see this result from GIS Program using H2 DB: {"l":"2329645\/6611=)4201794+716600","d":1529} How we can interpret this to Long, Lat? this is general or specific parser is need to meaning this?
2
votes
0answers
278 views

H2 connection error using Geotools

I am using geotools (v 17.0) to connect to a H2 database (v 1.4.193) table. My h2 maven dependencies: <dependency> <groupId>org.geotools.jdbc</groupId> <artifactId>gt-...
1
vote
0answers
383 views

Getting H2GIS functions to work in Spherical Space?

I've been playing around with H2GIS (http://www.h2gis.org/) for a project at work and am struggling to get the H2 functions to operate in spherical space (lat/ lon), rather than cartesian space. The ...
0
votes
1answer
368 views

Convert geography to geometry in H2GIS?

In H2GIS, geometry can be converted to geography with function "ST_Transform" For example: SELECT ST_Transform(ST_GeomFromText( 'POINT(584173 2594514)', 27572), 4326); -- Answer: POINT(2....