Geometric Indices?

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view

Geometric Indices?

I'm trying to compare Spatialite to H2GIS. With the existing Spatialite DB, there is a linestring, and a index composed of the linestring's min/max x and min/max y and id. In order to do a performance comparison, I need to know if there is a way to do something similar in H2GIS.

Let me know and best regards,

Steve Thompson
Reply | Threaded
Open this post in threaded view

Re: Geometric Indices?


If you are talking about spatial index (query performance should be based on that) :

You have a sample here

If you are looking for spatial functions that read the geometry properties :

I don't know what is Id, but you can create an auto increment primary key using the h2 database serial column type :

Best regards,

Nicolas FORTIN

Développeur d’applications - AI
Laboratoire d’Acoustique Environnementale (LAE)
Ifsttar Nantes, Route de Bouaye, CS 4, 44344 Bouguenais Cedex

Activités du Laboratoire d’Acoustique Environnementale :
Un logiciel open-source pour l’acoustique des salles : I-Simpa (
Un logiciel open-source pour des études d’impact en milieu extérieur : NoiseM@p (
Un logiciel open-source android pour la mesure collaborative du bruit : NoiseCapture (