asterixdb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Preston Carman <prest...@apache.org>
Subject Re: ASTERIXDB-1371: Geo data type format question
Date Sun, 14 May 2017 18:08:41 GMT
Thanks for pointing out we have functions that provide a way to create
the data using numeric values. As a review, we have functions to
create points using numeric types and the serialized form (ADM) holds
the special string format.

function: create_point(47.44,80.65)
adm: point("47.44,80.65")

On Sun, May 14, 2017 at 10:58 AM, Wail Alkowaileet <wael.y.k@gmail.com> wrote:
> Sorry ! For some reason I missed a whole page.
>
> On Sun, May 14, 2017 at 8:54 PM, Yingyi Bu <buyingyi@gmail.com> wrote:
>
>> Hi Wail,
>>
>>     They're documented at:
>> https://ci.apache.org/projects/asterixdb/aql/
>> builtins.html#SpatialFunctions
>>     The prefixes in the documentation are "create_".
>>
>> Best,
>> Yingyi
>>
>> On Sun, May 14, 2017 at 10:51 AM, Wail Alkowaileet <wael.y.k@gmail.com>
>> wrote:
>>
>> > Previously, AsterixDB used to have such functions [1] prefixed with
>> > "create-*()". The functions are still in the master [2] .. but not
>> > documented.
>> > For the current spatial constructors, I think they're inspired by WKT. I
>> > cannot be helpful on explaining the reason why... sorry!
>> >
>> > [1]
>> > https://github.com/apache/asterixdb/blob/release-0.8.7/
>> > asterix-doc/src/site/markdown/aql/functions.md
>> > [2]
>> > https://github.com/apache/asterixdb/blob/master/
>> > asterixdb/asterix-om/src/main/java/org/apache/asterix/om/
>> > functions/BuiltinFunctions.java
>> >
>> > On Sun, May 14, 2017 at 8:00 PM, Preston Carman <prestonc@apache.org>
>> > wrote:
>> >
>> > > I have question about the format used by AsterixDB to store points,
>> > > lines, etc.[1]. As we are adding support for other formats [2], I
>> > > wanted to ask a question about our current format. In the current
>> > > format, we use a keyword to specify the type followed by parenthesis
>> > > around a specially formatted string. The uses spaces and commas to
>> > > separate numeric values for defining the given geo data type. Why use
>> > > a string with a special string format?
>> > >
>> > > Current Examples:
>> > > Point : point("80.10d, -10E5")
>> > > Line : line("10.1234,11.1e-1 +10.2E-2,-11.22")
>> > > Rectangle : rectangle("5.1,11.8 87.6,15.6548")
>> > > Circle : circle("10.1234,1.11 0.102")
>> > > Polygon : polygon("-1.2,+1.3e2 -2.14E+5,2.15 -3.5e+2,03.6
>> -4.6E-3,+4.81")
>> > >
>> > > Is there a reason you would not want to use numeric types instead of
>> > > specially defined string? Or even reused types to define new types
>> > > like using points to define a line. The following are some examples of
>> > > how we could reuse AsterixDB types to define points, lines, etc.:
>> > >
>> > > Type Based Example
>> > > Point : point(double, double)
>> > > Line : line(point(double,double), point(double,double))
>> > > Rectangle : rectangle(point(double,double), point(double,double))
>> > > Circle : circle(point(double,double),double)
>> > > Polygon : polygon(point(double,double), point(double,double),
>> > > point(double,double), point(double,double))
>> > >
>> > > It seems the other formats we are looking at reuse numeric type in
>> > > their type definitions. Thoughts?
>> > >
>> > > [1] http://asterixdb.apache.org/docs/0.9.1/datamodel.html#
>> > > PrimitiveTypesPoint
>> > > [2] https://issues.apache.org/jira/browse/ASTERIXDB-1371
>> > >
>> >
>> >
>> >
>> > --
>> >
>> > *Regards,*
>> > Wail Alkowaileet
>> >
>>
>
>
>
> --
>
> *Regards,*
> Wail Alkowaileet

Mime
View raw message