Which are the coordinates for example for this tag973 ?
2017-06-14 12:36 GMT+02:00 John <[email protected]>:
>
> +----+-------+------+----+-----+-------+--------------------
> ---+----+-------------------+--------+----+
> |# |@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]>:
>>
>>>
>>> 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].
>>> 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.
>
--
---
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.
