Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
HBase >> mail # user >> Spatial data posting in HBase


+
cto 2013-09-24, 11:15
+
Ted Yu 2013-09-24, 13:43
+
Adrien Mogenet 2013-10-04, 08:01
+
Michael Segel 2013-10-08, 00:20
Copy link to this message
-
Re: Spatial data posting in HBase
Actually just to follow up..

Geohash kinda has some issues at the global scale. Edge conditions on quadrant boundaries.

You're better off tiling the map, and then within each tile you can filter the list.
I think you'd also want to be a bit more OO than what's in the HBase book.

You will want to create a spatial point object that has x,y and z coordinates instead of storing the x, y, and z coordinates as separate columns.

Depending on the size of the tile the number of coordinates that you have to filter can become sparse, such that its actually faster to just have a single thread run through it.

Of course YMMV, however from experience... this works the best.

HTH

-Mike

On Oct 7, 2013, at 7:20 PM, Michael Segel <[EMAIL PROTECTED]> wrote:

> I don't think you really want to use geo hashes.
>
> Check out InfoQ and Search on Boris Lublinsky.
>
> On Oct 4, 2013, at 3:01 AM, Adrien Mogenet <[EMAIL PROTECTED]> wrote:
>
>> If you mean "insert and query" spatial data, look at algorithms that are
>> "distributed databases compliant" : geohash, z-index, voronoi diagram...
>>
>> Well, that makes me want to write a blog article about these topics :)
>>
>>
>> On Tue, Sep 24, 2013 at 3:43 PM, Ted Yu <[EMAIL PROTECTED]> wrote:
>>
>>> There're plenty of examples in unit tests.
>>> e.g. :
>>>
>>>     Put put = new Put(Bytes.toBytes("row" + String.format("%1$04d", i)));
>>>     put.add(family, null, value);
>>>     table.put(put);
>>>
>>> value can be obtained through Bytes.toBytes().
>>> table is an HTable.
>>>
>>> Cheers
>>>
>>>
>>> On Tue, Sep 24, 2013 at 4:15 AM, cto <[EMAIL PROTECTED]> wrote:
>>>
>>>> Hi ,
>>>>
>>>> I am very new in HBase. Could you please let me know , how to insert
>>>> spatial
>>>> data (Latitude / Longitude) in HBase using Java .
>>>>
>>>>
>>>>
>>>> --
>>>> View this message in context:
>>>>
>>> http://apache-hbase.679495.n3.nabble.com/Spatial-data-posting-in-HBase-tp4051123.html
>>>> Sent from the HBase User mailing list archive at Nabble.com.
>>>>
>>>
>>
>>
>>
>> --
>> Adrien Mogenet
>> http://www.borntosegfault.com
>
> The opinions expressed here are mine, while they may reflect a cognitive thought, that is purely accidental.
> Use at your own risk.
> Michael Segel
> michael_segel (AT) hotmail.com
>
>
>
>
>
>

The opinions expressed here are mine, while they may reflect a cognitive thought, that is purely accidental.
Use at your own risk.
Michael Segel
michael_segel (AT) hotmail.com
+
Enis Söztutar 2013-10-07, 23:12
+
Otis Gospodnetic 2013-10-09, 14:34
+
Michael Segel 2013-10-09, 15:14
+
Otis Gospodnetic 2013-10-09, 18:35
+
Michael Segel 2013-10-10, 17:51
+
Adrien Mogenet 2013-10-12, 07:34
+
Michael Segel 2013-10-12, 18:33
+
Nick Dimiduk 2013-10-12, 23:16
+
Adrien Mogenet 2013-10-13, 10:33
+
Michael Segel 2013-10-13, 13:04
+
Nick Dimiduk 2013-10-10, 17:40