Orientdb query geospatial bad result

25 views
Skip to first unread message

John

unread,
Jun 14, 2017, 6:10:53 AM6/14/17
to OrientDB

I use Orientdb 2.2 I create a class:TabzIndex with coordinate geospatial (Opoint)


create
class TabzIndex extends V

create property
TabzIndex.xy EMBEDDED Opoint


Create property [all other property]
+----+-------+---------+----+-----+-------+-----------------------+----+-------------------+--------+----+
|#   |@RID   |@CLASS   |id  |idTag|tagName|xy                     |z   |date               |type    |z2  |
+----+-------+---------+----+-----+-------+-----------------------+----+-------------------+--------+----+
|0   |#25:760|TabzIndex|3   |941  |tag941 |OPoint{coordinates:[2]}|16.0|2009-08-17 01:03:19|Personne|76.0|
I index xy to make the query faster
CREATE INDEX Ixy ON TabzIndex (xy) SPATIAL ENGINE LUCENE
I make a seconde class (Tabz) is the same TabzIndex with out Index on xy but the same data inside
When I make a polygone query like 
select count(*) as GeoReturn from TabzIndex where ST_WITHIN(xy,'POLYGON ((0 0, 0 40, 40 40,40 0, 0 0))') = true limit 1000000


+----+---------+
|#   |GeoReturn|
+----+---------+
|0   |11552    |
+----+---------+
And (the same query for Tabz)
select count(*) as GeoReturn from Tabz where ST_WITHIN(xy,'POLYGON ((0 0, 0 40, 40 40,40 0, 0 0))') = true limit 1000000
+----+---------+
|#   |GeoReturn|
+----+---------+
|0   |18410    |
+----+---------+
The result is different! Why do I loose some data when i use index? What I do wrong?

Enrico Risa

unread,
Jun 14, 2017, 6:19:44 AM6/14/17
to orient-...@googlegroups.com
Hi John 

do you have an example of records with coordinates that fails to return with the index?

Thanks

--

---
You received this message because you are subscribed to the Google Groups "OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email to orient-database+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

John

unread,
Jun 14, 2017, 6:36:18 AM6/14/17
to OrientDB, enric...@gmail.com

+----+-------+------+----+-----+-------+-----------------------+----+-------------------+--------+----+
|#   |@RID   |@CLASS|id  |idTag|tagName|xy                     |z   |date               |type    |z2  |
+----+-------+------+----+-----+-------+-----------------------+----+-------------------+--------+----+
|0   |#22:503|Tabz  |11  |973  |tag973 |OPoint{coordinates:[2]}|33.0|2008-02-18 12:17:33|Personne|28.0|
|1   |#23:503|Tabz  |12  |595  |tag595 |OPoint{coordinates:[2]}|36.0|2009-12-23 10:38:06|Autre   |34.0|
|2   |#22:505|Tabz  |19  |673  |tag673 |OPoint{coordinates:[2]}|26.0|2016-05-13 14:51:34|Personne|25.0|
|3   |#23:505|Tabz  |20  |437  |tag437 |OPoint{coordinates:[2]}|34.0|2007-08-02 12:56:03|Autre   |21.0|
|4   |#24:508|Tabz  |33  |413  |tag413 |OPoint{coordinates:[2]}|24.0|2003-11-28 20:14:00|Autre   |7.0 |
|5   |#24:509|Tabz  |37  |9    |tag9   |OPoint{coordinates:[2]}|23.0|2011-05-02 22:22:42|Outils  |24.0|
|6   |#23:510|Tabz  |40  |540  |tag540 |OPoint{coordinates:[2]}|4.0 |2013-08-05 23:07:38|Autre   |8.0 |
|7   |#21:511|Tabz  |42  |490  |tag490 |OPoint{coordinates:[2]}|39.0|2005-04-26 08:59:12|Autre   |35.0|
|8   |#21:514|Tabz  |54  |833  |tag833 |OPoint{coordinates:[2]}|21.0|2002-06-22 00:29:28|Personne|30.0|
|9   |#22:514|Tabz  |55  |429  |tag429 |OPoint{coordinates:[2]}|4.0 |2014-01-23 19:51:19|Autre   |37.0|
|10  |#23:517|Tabz  |68  |871  |tag871 |OPoint{coordinates:[2]}|30.0|2000-11-22 09:11:13|Personne|17.0|
|11  |#22:518|Tabz  |71  |514  |tag514 |OPoint{coordinates:[2]}|17.0|2008-06-27 18:12:20|Autre   |20.0|
|12  |#23:518|Tabz  |72  |171  |tag171 |OPoint{coordinates:[2]}|27.0|2001-09-19 21:11:34|Outils  |21.0|
|13  |#21:519|Tabz  |74  |259  |tag259 |OPoint{coordinates:[2]}|21.0|2014-11-26 07:35:53|Outils  |1.0 |
|14  |#23:521|Tabz  |84  |769  |tag769 |OPoint{coordinates:[2]}|17.0|2001-02-19 20:21:24|Personne|35.0|
|15  |#24:523|Tabz  |93  |609  |tag609 |OPoint{coordinates:[2]}|32.0|2010-06-09 06:30:20|Autre   |26.0|
|16  |#21:526|Tabz  |102 |342  |tag342 |OPoint{coordinates:[2]}|16.0|2012-04-12 14:33:39|Autre   |27.0|
|17  |#24:526|Tabz  |105 |223  |tag223 |OPoint{coordinates:[2]}|27.0|2014-04-08 18:30:27|Outils  |29.0|
|18  |#24:528|Tabz  |113 |96   |tag96  |OPoint{coordinates:[2]}|6.0 |2014-03-09 07:27:25|Outils  |18.0|
|19  |#22:529|Tabz  |115 |326  |tag326 |OPoint{coordinates:[2]}|28.0|2003-08-06 10:12:33|Outils  |4.0 |
|20  |#24:529|Tabz  |117 |627  |tag627 |OPoint{coordinates:[2]}|28.0|2012-09-05 10:14:00|Autre   |34.0|
|21  |#21:531|Tabz  |122 |383  |tag383 |OPoint{coordinates:[2]}|20.0|2010-12-14 18:38:23|Autre   |34.0|
|22  |#23:531|Tabz  |124 |149  |tag149 |OPoint{coordinates:[2]}|0.0 |2014-09-12 06:11:37|Outils  |1.0 |
|23  |#23:534|Tabz  |136 |569  |tag569 |OPoint{coordinates:[2]}|28.0|2000-06-15 22:12:40|Autre   |35.0|
|24  |#21:535|Tabz  |138 |566  |tag566 |OPoint{coordinates:[2]}|11.0|2008-12-17 20:20:26|Autre   |33.0|
|25  |#21:536|Tabz  |142 |973  |tag973 |OPoint{coordinates:[2]}|32.0|2005-02-12 09:56:22|Personne|22.0|
|26  |#21:538|Tabz  |150 |718  |tag718 |OPoint{coordinates:[2]}|6.0 |2004-08-27 12:04:36|Personne|35.0|
|27  |#22:538|Tabz  |151 |572  |tag572 |OPoint{coordinates:[2]}|23.0|2007-06-18 23:34:47|Autre   |30.0|
|28  |#22:541|Tabz  |163 |833  |tag833 |OPoint{coordinates:[2]}|33.0|2006-01-14 05:38:01|Personne|29.0|
|29  |#23:544|Tabz  |176 |832  |tag832 |OPoint{coordinates:[2]}|6.0 |2003-02-18 18:43:57|Personne|17.0|
+----+-------+------+----+-----+-------+-----------------------+----+-------------------+--------+----+

the orange is the lanes I don't see on my TabzIndex 
To unsubscribe from this group and stop receiving emails from it, send an email to orient-databa...@googlegroups.com.

Enrico Risa

unread,
Jun 14, 2017, 6:39:27 AM6/14/17
to orient-...@googlegroups.com
Which are the coordinates for example for this tag973 ?

To unsubscribe from this group and stop receiving emails from it, send an email to orient-database+unsubscribe@googlegroups.com.

John

unread,
Jun 14, 2017, 8:22:33 AM6/14/17
to OrientDB, enric...@gmail.com

METADATAPROPERTIES
@rid
@version
@class
id
idTag
tagName
xy
z
date
type
z2
1
142
973
tag973
{"@type":"d","@version":0,"@class":"OPoint","coordinates":[32,22]}
32
Reply all
Reply to author
Forward
0 new messages