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

Free-Thinker, Individualist, INTP


Sep
24
awarded  Autobiographer
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