+----+-------+------+----+-----+-------+-----------------------+----+-------------------+--------+----+
|# |@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
Le mercredi 14 juin 2017 12:19:44 UTC+2, Enrico Risa a écrit :
>
> Hi John
>
> do you have an example of records with coordinates that fails to return
> with the index?
>
> Thanks
>
> 2017-06-14 12:10 GMT+02:00 John <[email protected] <javascript:>>:
>
>>
>> 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?
>>
>> --
>>
>> ---
>> 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 [email protected] <javascript:>.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
--
---
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
