asterixdb-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Wail Alkowaileet (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (ASTERIXDB-1627) create-polygon() from array of double is giving wrong numbers
Date Fri, 02 Sep 2016 08:06:20 GMT

    [ https://issues.apache.org/jira/browse/ASTERIXDB-1627?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15457874#comment-15457874
] 

Wail Alkowaileet commented on ASTERIXDB-1627:
---------------------------------------------

I suspect this bug is related to:
https://issues.apache.org/jira/browse/ASTERIXDB-1616
and 
https://issues.apache.org/jira/browse/ASTERIXDB-1334

No sure though.

> create-polygon() from array of double is giving wrong numbers
> -------------------------------------------------------------
>
>                 Key: ASTERIXDB-1627
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1627
>             Project: Apache AsterixDB
>          Issue Type: Bug
>          Components: Data Formats, Data Model
>            Reporter: Wail Alkowaileet
>
> Hi,
> Data:
> https://www.dropbox.com/s/52c6uxufuldqzmm/statesJson.zip?dl=0
> DDL:
> {noformat}
> drop dataverse TwitterDataverse if exists
> create dataverse TwitterDataverse
> use dataverse TwitterDataverse
> create type StateType as {
> uid: uuid
> }
> create dataset States(StateType) 
> primary key uid autogenerated
> {noformat}
> DML:
> {noformat}
> use dataverse TwitterDataverse
> load dataset States using localfs
> (("path"="localhost:///path/to/statesJson"),
> ("format"="adm"))
> {noformat}
> Get the array of doubles from the GeoJSON:
> {noformat}
> use dataverse TwitterDataverse
> let $polygon := (for $x in dataset States
> where $x.features[0].geometry.'type' = "Polygon"
> limit 1
> let $list := (for $i in $x.features[0].geometry.coordinates[0]
> for $j in $i
> for $k in $j
> return $k
> )
> return $list
> )
> return $polygon
> {noformat}
> Output:
> {noformat}
> [ -87.359296, 35.00118, -85.606675, 34.984749, -85.431413, 34.124869, -85.184951, 32.859696,
-85.069935, 32.580372, -84.960397, 32.421541, -85.004212, 32.322956, -84.889196, 32.262709,
-85.058981, 32.13674, -85.053504, 32.01077, -85.141136, 31.840985, -85.042551, 31.539753,
-85.113751, 31.27686, -85.004212, 31.003013, -85.497137, 30.997536, -87.600282, 30.997536,
-87.633143, 30.86609, -87.408589, 30.674397, -87.446927, 30.510088, -87.37025, 30.427934,
-87.518128, 30.280057, -87.655051, 30.247195, -87.90699, 30.411504, -87.934375, 30.657966,
-88.011052, 30.685351, -88.10416, 30.499135, -88.137022, 30.318396, -88.394438, 30.367688,
-88.471115, 31.895754, -88.241084, 33.796253, -88.098683, 34.891641, -88.202745, 34.995703,
-87.359296, 35.00118 ]
> {noformat}
> applying create-polygon() on the resulting array:
> {noformat}
> use dataverse TwitterDataverse
> let $polygon := (for $x in dataset States
> where $x.features[0].geometry.'type' = "Polygon"
> limit 1
> let $list := (for $i in $x.features[0].geometry.coordinates[0]
> for $j in $i
> for $k in $j
> return $k
> )
> return $list
> )
> return create-polygon($polygon)
> {noformat}
> Output:
> {noformat}
> polygon("2.920390972995509E-247,1.1352293178511514E-249 2.920084986948524E-247,1.1352270767181132E-249
2.9200543883612843E-247,1.1351097919833495E-249 2.920011359130714E-247,1.1349372266489597E-249
2.919991278753279E-247,1.1348991277964998E-249 2.919972154767195E-247,1.1348774637832571E-249
2.919979804326711E-247,1.1348640171214245E-249 2.919959723949276E-247,1.1348557996336175E-249
2.919989366319753E-247,1.1348386178864513E-249 2.91998841010299E-247,1.1348214360028882E-249
2.9200037095711975E-247,1.1347765887907304E-249 2.919986497844052E-247,1.134694414731042E-249
2.9199989284873825E-247,1.1346226992921991E-249 2.919979804326711E-247,1.1345479956759716E-249
2.92006586296244E-247,1.1345465015872795E-249 2.920433046183905E-247,1.1345465015872795E-249
2.920438783309895E-247,1.1345106440042545E-249 2.920399578946376E-247,1.134458351445616E-249
2.920406272289129E-247,1.134413529057645E-249 2.9203928854290354E-247,1.134391118000056E-249
2.920418703107048E-247,1.1343507781509548E-249 2.9204426081769465E-247,1.134341813618802E-249
2.9204865936242805E-247,1.134386636006773E-249 2.920491374708095E-247,1.1344538691795396E-249
2.920504761568189E-247,1.1344613396230002E-249 2.920521017078572E-247,1.1344105411530538E-249
2.92052675437915E-247,1.1343612367717997E-249 2.9205716960432465E-247,1.1343746832972356E-249
2.92058508290334E-247,1.1347915294048584E-249 2.9205449223230584E-247,1.1350649698681716E-249
2.9205200608618086E-247,1.1352143771006265E-249 2.920538228805718E-247,1.1352285708068053E-249
2.920390972995509E-247,1.1352293178511514E-249")
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message