Thank you, I discovered that when i'm only using srid:4326 layers there are no problems at all and its working perfect. When i add a srid:28992 layer as first layer my 4326 layers are 1 at 30 times not displayed. When i use my srid:28992 layers as last layer it works 9 at 10 times but that one time when it doesen't work one of my 4326 layer is gone or all the 4326 layers are gone. Also the h2gis i get when i use orbisgis maven h2gis-dist seems a little bit more stable then the zip from h2gis.org. I will keep experimenting and give updates.
Op dinsdag 15 maart 2016 17:46:38 UTC+1 schreef Nicolas Fortin (OrbisGIS): > > Hi, > > The intersection is done using the stored coordinate. Your problem may be > a projection issue. The && operator is a *bounding box* intersection. > ST_Intersects will take the geometry, but it is much slower. The solution > is to merge the two methods as you have already done. > > There is a lot of unit testing on intersection and index operation in h2. > We are open to add more unit test if you can provide a data and query > sample in order to simulate the issue on our side. > > Regards, > > Nicolas FORTIN > > H2GIS team member > > Développeur d’applications - AI > Laboratoire d’Acoustique Environnementale (LAE) > Ifsttar Nantes, Route de Bouaye, CS 4, 44344 Bouguenais Cedex > Tél. +33 (0)2 40 84 57 91 > > Activités du Laboratoire d’Acoustique Environnementale : > www.lae.ifsttar.fr > Un logiciel open-source pour l’acoustique des salles : I-Simpa ( > i-simpa.ifsttar.fr) > Un logiciel open-source pour des études d’impact en milieu extérieur : > NoiseM@p (noisemap.orbisgis.org) > > Le mercredi 9 mars 2016 13:18:57 UTC+1, Bernd Lauert a écrit : >> >> Hello, >> >> I am experiencing some problems with requesting geometries from inside a >> bounding box using spatial indexing inside my gis application. The problem >> is that sometimes a query gives 0 results and when i'm changing my map >> position a very small bit i get lots of results. Sometimes when i get >> results in my application and when i do the same query in de h2 webserver >> the query in the h2 console does not give any results. Another thing is >> that when i only use the intersects command i get more results then when i >> use the ST_Intersects command provided by h2gis. Thats why i do the >> ST_Intersects command as last. >> This is an example from my code: >> https://github.com/ffk27/h2gisviewer/blob/master/src/com/example/JDBCHandler.java >> Could someone help me with this or can i better contact the h2gis team? >> Sorry for my bad english. >> >> >> -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
