-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512

Hello All,
I am working on the PostBox App. Actual end user application is online
now [ http://openbangalore.org/postbox/ ]. It gets data from Instagram.
Instagram gives me lat, long which are stored as floats in an sqlite DB
[https://bitbucket.org/thejeshgn/postbox/src/tip/db]. Now I haven't used
SQLite for GIS things in the past. So here are my questions.

1. How easy is spatialite and can it work with PHP? I will try n avoid
using it as much as possible.
2. How to get center point given a set of points?
3. How to get nearest points give a point?

Q2 and 3 become difficult if I am not using spatialite. Are there simple
solutions using just sqlite and php?

Let me know.

Thej

- -- 
Thejesh GN
http://thejeshgn.com
GPG ID :  0xBFFC8DD3C06DD6B0
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)

iQIcBAEBCgAGBQJQlBe8AAoJEL/8jdPAbdawp20QAK2ZvAzaU3rAtbXYxf2KBVSq
eh3OZBChRk5fMyAMPmUkWEFIX66bEcw12QKM7gg+8+lhyQG9upVanjyLj7/KStdG
zgWERU5LJVpXShpwcaM6E4NqpcMRbdur9hxC/uZKFEXX+sdlxRre4auSWCKpEAKG
cRFBXgngX5Ibj+FhzSKXMfovZluNstDoZJ+lqBbU2u4iczcHo8Mq5VuEXy5kyjYb
3NcE0ni76M4avAU9yaNhj4i6xAK/wjZFH4/2AJgfNO/43B/6AagYGRc9r4OqtXdv
SZO4VjKHMZAVu01p2ROQbWZIo5d51oli4cpSALk2TK6q7sVMk4H8mpMgUeDGZOTo
Q+uYRIzWRtyedHT63doaOhefiY9D2xorcVknYAKazFs5R2rT2GacFpgRw3K4IF3a
FWjHQ7xmLUTrpc/Jhi8ZcTaWbkACjFwCyOQvyShD/Ec8Om5q7nmCX8PflwEAvrLA
gnicBhHz3GeSQcdrtpIbXP2FU7Et4jTDQff3r1Az63x/gg5pojQ6Pd8w66m0qzrR
HmciDioAteMDy466fB5w1Q0Ehv8IUhXWcsJC6l+pmi/WrdBoBKAj0kaA/FJzD59G
dDCbry0+C98+jvyFn68iljz42wGsusNebOzZG14nQ942tdUa9LRSxeTnA7veFPiW
srs0u/xVKnlxAhl4PA0t
=fqiL
-----END PGP SIGNATURE-----

-- 
For more details about this list
http://datameet.org/discussions/
--- 
You received this message because you are subscribed to the Google Groups 
"datameet" group.
To unsubscribe from this group, send email to 
[email protected].


Reply via email to