Mailing-List: contact dev-help@hbase.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hbase.apache.org
Received-SPF: pass (athena.apache.org: domain of vrodionov@carrieriq.com
 designates 204.235.122.16 as permitted sender)
From: Vladimir Rodionov <vrodionov@carrieriq.com>
To: "dev@hbase.apache.org" <dev@hbase.apache.org>
Date: Thu, 3 Apr 2014 09:10:54 -0700
Subject: RE: how Store and retrieve time series Gio Spacialdata in Hbase
Thread-Topic: how Store and retrieve time series Gio Spacialdata in Hbase
Thread-Index: Ac9PEXNq1bBN0TCPSuaLiLD1GgLuiAARQ9Bo
Message-ID: 
 <DC5EBE7F3610EB4CA5C7E92D76873E1518629B5932@exchange2007.carrieriq.com>
References: 
 <CAKrbzS2WSWQBavweSUv8nFLzCwpUN1aZf=JNtrzx1AQ6EXKjpw@mail.gmail.com>
In-Reply-To: 
 <CAKrbzS2WSWQBavweSUv8nFLzCwpUN1aZf=JNtrzx1AQ6EXKjpw@mail.gmail.com>
Accept-Language: en-US
Content-Language: en-US
acceptlanguage: en-US
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0

>> suggest me the table design for this

Have you ever tried to google? You are asking people to do your own job, bt=
w.
Have you ever heard about geohashing, space filling curves http://en.wikipe=
dia.org/wiki/Hilbert_curve
or spatial indexes: http://en.wikipedia.org/wiki/R-tree


Best regards,
Vladimir Rodionov
Principal Platform Engineer
Carrier IQ, www.carrieriq.com
e-mail: vrodionov@carrieriq.com

________________________________________
From: Prabhakar [o.prabhakar@gmail.com]
Sent: Thursday, April 03, 2014 12:50 AM
To: dev@hbase.apache.org
Subject: how Store and retrieve time series Gio Spacialdata in Hbase

HI,

i have some data which got generated by vehicle GPS information. like
customer-id, vehicle-id,Latitude, longitude, address,time.. etc. I need to
store this data in Hbase for real time reads( writes can be batch, only
 concentrate on reads ). so while reading we are passing the parameters
like customerId,  time, address Point (Lat,Long) details with polygon( like
circle, rectangle,Square..etc) search. so the expected out put set of
vehicle address point within the polygon.
input is : one customer can search like find all his vehicles some
time-stamp with some address point within 1 KM or 2 KM Radius.
output is: retrieve all vehicle details within the given radius and given
address point on tha given time-stamp range.

please suggest me the proper GIO spacial API for this requirement and
suggest me the table design for this.

Thanks,
Prabhakar

Confidentiality Notice:  The information contained in this message, includi=
ng any attachments hereto, may be confidential and is intended to be read o=
nly by the individual or entity to whom this message is addressed. If the r=
eader of this message is not the intended recipient or an agent or designee=
 of the intended recipient, please note that any review, use, disclosure or=
 distribution of this message or its attachments, in any form, is strictly =
prohibited.  If you have received this message in error, please immediately=
 notify the sender and/or Notifications@carrieriq.com and delete or destroy=
 any copy of this message and its attachments.