Mailing-List: contact user-help@hbase.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hbase.apache.org
Received-SPF: pass (nike.apache.org: domain of msegel_hadoop@hotmail.com
 designates 65.55.111.104 as permitted sender)
Message-ID: <BLU0-SMTP2003EC00303D0B652741DB5981E0@phx.gbl>
From: Michael Segel <msegel_hadoop@hotmail.com>
Content-Type: multipart/signed;
	boundary="Apple-Mail=_A3D0A04A-F42C-4E96-AEEE-C621D64FEF50";
	protocol="application/pkcs7-signature"; micalg=sha1
MIME-Version: 1.0 (Mac OS X Mail 6.6 \(1510\))
Subject: Re: Spatial data posting in HBase
Date: Thu, 10 Oct 2013 12:51:04 -0500
References: <1380021342486-4051123.post@n3.nabble.com>
 <CANNBgPLHobsthUvxPgeoLiD+GwMTwi21tchf_Som7CBs9ng0gg@mail.gmail.com>
 <BLU0-SMTP4441D74C5F9A6B874DB6791981D0@phx.gbl>
 <CANNBgPJ3nwnUoeMMDD2b6bnqOMAh7fnKE57Njdda5drtuPCKVw@mail.gmail.com>
To: user@hbase.apache.org
In-Reply-To: 
 <CANNBgPJ3nwnUoeMMDD2b6bnqOMAh7fnKE57Njdda5drtuPCKVw@mail.gmail.com>

--Apple-Mail=_A3D0A04A-F42C-4E96-AEEE-C621D64FEF50
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=windows-1252

HBase in Action goes through great depth of showing you how you could =
implement GIS information in HBase.=20

Unfortunately there are issues with Geohash and edge conditions which =
make it difficult to use when you're dealing with data on an edge of a =
quadrant.=20

A better way would be to create a point (geospatial point object) and =
store it in a single column.=20
(This goes beyond the example of what's in the book. ) And then index =
the data by tiles.=20


The downside is that you end up creating a lot more data=85=20

Take a look at some of the stuff Boris Lublinsky published on InfoQ. =
There are also other articles on the net=85.

On Oct 9, 2013, at 1:35 PM, Otis Gospodnetic =
<otis.gospodnetic@gmail.com> wrote:

> The point is that there are options (multiple different hammers) if
> HBase support for geospatial is not there or doesn't meet OP's needs.
>=20
> Otis
> --
> Solr & ElasticSearch Support -- http://sematext.com/
> Performance Monitoring -- http://sematext.com/spm
>=20
>=20
>=20
> On Wed, Oct 9, 2013 at 11:14 AM, Michael Segel
> <msegel_hadoop@hotmail.com> wrote:
>> And Solr has what to do with storing data in HBase?
>>=20
>> I guess its true=85 if all you have is a hammer=85
>>=20
>> The point I was raising was that geohash isn't the most efficient way =
to go when you look at the problem at a global level=85
>>=20
>> On Oct 9, 2013, at 9:34 AM, Otis Gospodnetic =
<otis.gospodnetic@gmail.com> wrote:
>>=20
>>> Consider using Solr, which provides a lot of geospatial search =
support.
>>>=20
>>> Otis
>>> Solr & ElasticSearch Support
>>> http://sematext.com/
>>> On Sep 24, 2013 8:29 AM, "cto" <ankur5.c@tcs.com> wrote:
>>>=20
>>>> Hi ,
>>>>=20
>>>> I am very new in HBase. Could you please let me know , how to =
insert
>>>> spatial
>>>> data (Latitude / Longitude) in HBase using Java .
>>>>=20
>>>>=20
>>>>=20
>>>> --
>>>> View this message in context:
>>>> =
http://apache-hbase.679495.n3.nabble.com/Spatial-data-posting-in-HBase-tp4=
051123.html
>>>> Sent from the HBase User mailing list archive at Nabble.com.
>>>>=20
>>=20
>=20


--Apple-Mail=_A3D0A04A-F42C-4E96-AEEE-C621D64FEF50
Content-Disposition: attachment; filename="smime.p7s"
Content-Type: application/pkcs7-signature; name="smime.p7s"
Content-Transfer-Encoding: base64

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIICujCCArYw
ggIfoAMCAQICCQCqTy7yM7wDDTANBgkqhkiG9w0BAQUFADB0MQswCQYDVQQGEwJVUzERMA8GA1UE
CAwISWxsaW5vaXMxEDAOBgNVBAcMB0NoaWNhZ28xDTALBgNVBAoMBE1TQ0MxEDAOBgNVBAMMB3Nl
Z2VsMDIxHzAdBgkqhkiG9w0BCQEWEG1zZWdlbEBzZWdlbC5jb20wHhcNMTMwOTA4MDYxMzA2WhcN
MjMwOTA2MDYxMzA2WjB0MQswCQYDVQQGEwJVUzERMA8GA1UECAwISWxsaW5vaXMxEDAOBgNVBAcM
B0NoaWNhZ28xDTALBgNVBAoMBE1TQ0MxEDAOBgNVBAMMB3NlZ2VsMDIxHzAdBgkqhkiG9w0BCQEW
EG1zZWdlbEBzZWdlbC5jb20wgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBANbFWB63Zy/IoPTu
4yvE2CU3ePSWb0jvSWlJRWeVRZtXDlIooFY9f1gtDPhtSW/2b67lKOfTfP0o72keQQbZSqU0S1OE
Aw3NpTzvG2rRLF8Fex7bcRtdeW2ZCys8dQJIopB/nr15RAzcEM6aNFs8nUPDw1lKNRoqZTIe9ZW3
VHpBAgMBAAGjUDBOMB0GA1UdDgQWBBTpEjxThxqqZHnWTRn+xfboLLlaIzAfBgNVHSMEGDAWgBTp
EjxThxqqZHnWTRn+xfboLLlaIzAMBgNVHRMEBTADAQH/MA0GCSqGSIb3DQEBBQUAA4GBAGWVijpU
r12w+g5q/HlXUQjoCMoHphyWgbGK0PvucVBfyi3GnC7PqxFNQVfMOn9dBTYvK6FcFTZd77RTvniY
K3F7YdzM2fObId90X1xTm9M7RsYWqY4r8v5ObmAyQl9WkcKgs7KFAPgsroKR3ghlayyZy3EyAVpk
zL1QsPKCEA5AMYICtTCCArECAQEwgYEwdDELMAkGA1UEBhMCVVMxETAPBgNVBAgMCElsbGlub2lz
MRAwDgYDVQQHDAdDaGljYWdvMQ0wCwYDVQQKDARNU0NDMRAwDgYDVQQDDAdzZWdlbDAyMR8wHQYJ
KoZIhvcNAQkBFhBtc2VnZWxAc2VnZWwuY29tAgkAqk8u8jO8Aw0wCQYFKw4DAhoFAKCCAYkwGAYJ
KoZIhvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMTMxMDEwMTc1MTA0WjAjBgkq
hkiG9w0BCQQxFgQUMto3iy9mNrWGB6plJvGdZFdDn7AwgZIGCSsGAQQBgjcQBDGBhDCBgTB0MQsw
CQYDVQQGEwJVUzERMA8GA1UECAwISWxsaW5vaXMxEDAOBgNVBAcMB0NoaWNhZ28xDTALBgNVBAoM
BE1TQ0MxEDAOBgNVBAMMB3NlZ2VsMDIxHzAdBgkqhkiG9w0BCQEWEG1zZWdlbEBzZWdlbC5jb20C
CQCqTy7yM7wDDTCBlAYLKoZIhvcNAQkQAgsxgYSggYEwdDELMAkGA1UEBhMCVVMxETAPBgNVBAgM
CElsbGlub2lzMRAwDgYDVQQHDAdDaGljYWdvMQ0wCwYDVQQKDARNU0NDMRAwDgYDVQQDDAdzZWdl
bDAyMR8wHQYJKoZIhvcNAQkBFhBtc2VnZWxAc2VnZWwuY29tAgkAqk8u8jO8Aw0wDQYJKoZIhvcN
AQEBBQAEgYDNN6uL6ayLG9UY2AkbA/+sUjmp2y/fYt2hrwncljSLG/pcceiOhyyPiPQi8i4XurOL
H94ajyG9nT52pIqT8YuMee9bfCk1Q+pQLKb7B6uKSCxv94mP8ZBOLzyGNzxS5Kbe4VfjF/fPVYn/
gDzjnW+Osk5ddJDy1fRDkG5MIzD6kgAAAAAAAA==

--Apple-Mail=_A3D0A04A-F42C-4E96-AEEE-C621D64FEF50--