142 reputation
5
bio website
location
age
visits member for 2 years
seen Sep 15 '13 at 21:08

Free-Thinker, Individualist, INTP


Aug
8
comment Android GPS: average location resolution time
@julien I have read that question before. does not have what I am looking for. Thanks for the linkk.
Aug
7
asked Android GPS: average location resolution time
Mar
7
revised Error creating a spatial database. ERROR : could not load library “/usr/pgsql-9.1/lib/rtpostgis-2.0.so”
deleted 6 characters in body
Aug
9
accepted Error creating a spatial database. ERROR : could not load library “/usr/pgsql-9.1/lib/rtpostgis-2.0.so”
Aug
9
comment Error creating a spatial database. ERROR : could not load library “/usr/pgsql-9.1/lib/rtpostgis-2.0.so”
/etc/ld.so.conf had include ld.so.conf.d/*.conf one of the file was /etc/ld.so.conf.d/atlas-x8664.conf which contained /usr/lib64/atlas. A ldconfig -p | grep libhdf5 did not return anything. So I created a file gdal.conf and added the path /usr/lib64/mpich2/lib. Ran ldconfig. Now, ldconfig -p | grep libhdf5 had the paths to llibhdf5 files. After doing this, postgis raster suppot installation went smoothly. Thanks you for the input.
Aug
9
asked Error creating a spatial database. ERROR : could not load library “/usr/pgsql-9.1/lib/rtpostgis-2.0.so”
Jul
30
awarded  Editor
Jul
20
comment Implementing custom (Vincenty/Haversine formula) functions for MySQL vs Using PostGIS?
@Micha Thanks for the empirical evidence. I am thinking of implementing the functions and testing them for time taken. Will post the results here as soon as I am done.
Jul
19
comment Implementing custom (Vincenty/Haversine formula) functions for MySQL vs Using PostGIS?
@whuber Thanks for the link. Regarding CPU, that is what I had anticipated.
Jul
19
comment Implementing custom (Vincenty/Haversine formula) functions for MySQL vs Using PostGIS?
@LR1234567 Went through the features of PostgreSQL and I agree that it offers equal amount of features. But at the stage my project is in, I would not like to switch to another DB, learn to use it/tools associated with it etc.But, what's making me rethink this is the geodetic spatial indexing which is not yet available for InnoDb.I do have a database abstraction layer and as you say, the application logic rewriting part is not much of a problem. I still have to give this some thought.
Jul
19
asked Implementing custom (Vincenty/Haversine formula) functions for MySQL vs Using PostGIS?
Jul
19
awarded  Scholar
Jul
19
accepted MySQL GeoSpatial function for ST_Distance_Spheroid? Metric used in return Type of GLength?
Jul
17
comment MySQL GeoSpatial function for ST_Distance_Spheroid? Metric used in return Type of GLength?
Pardon for the delayed reply. Thanks for the clarification on Projected Units. I have already read that MySQL presentation thanks for the link to the question though. I am already using the geography type, on MySQL. Currently it supports only Cartesian coordinate calculations. I think I am better off implementing the Haversine function myself. Thanks again for all the help. I will leave this question open for another 2 days before accepting it. :)
Jul
16
awarded  Student
Jul
16
awarded  Supporter
Jul
16
comment MySQL GeoSpatial function for ST_Distance_Spheroid? Metric used in return Type of GLength?
Thanks for the information. I have already read the Movable Type Scripts article.. And was planning on implementing the function. My mapping area is not small. In fact I am considering the whole world. So I will have to store the data in lat/long. What do you mean by projected units?
Jul
16
awarded  Tag Editor
Jul
16
revised mysql wiki excerpt
added 116 characters in body
Jul
15
suggested suggested edit on mysql tag wiki excerpt