Re: [postgis-users] PostGIS and PostgreSQL books

2009-11-30 Thread Santosh Gaikwad
Hi Chetana, You can contact OSGEO-India regarding PostGIS. They have nice tutorial along with data which covers most of the topic in PostGIS. Write email to Dr Rajan at ra...@iiit.ac.in. Even OSGEO India will be starting course Open Source GIS software soon. Regards, Santosh Gaikwad

Re: [postgis-users] How do you use PostGIS Raster?

2011-06-09 Thread Santosh Gaikwad
HI, Look at the following application of Ecological Sensitive Area (ESA) of western ghats (one of the biodiversity hotspot) of India. We have used PGRaster in this case. http://www.wetlandsofindia.org/geoserver/www/esa/esa.html (It works well in Firefox) Thanks, Santosh Gaikwad On Thu, Jun 9

Re: [postgis-users] How do you use PostGIS Raster?

2011-06-10 Thread Santosh Gaikwad
> > boun...@postgis.refractions.net] On Behalf Of Santosh Gaikwad > > Sent: Thursday, June 09, 2011 4:54 AM > > To: PostGIS Users Discussion > > Subject: Re: [postgis-users] How do you use PostGIS Raster? > > > > HI, > > > > Look at the following applicat

FW: [postgis-users] Buffer Question

2007-07-03 Thread Santosh Gaikwad
Dear Jeff, I read your post with answer too. Well SRID 4269 refers to NAD83. Will you please tell me to which projection SRID 2163 refers? Using this will I have units in Meters? Thanks & regards, Santosh Gaikwad Senior Software Developer Saama Technologies (India) Pvt Ltd. 6th F

[postgis-users] Regarding SRID 2163

2007-07-03 Thread Santosh Gaikwad
Dear Jeff, I read your post with answer too. Well SRID 4269 refers to NAD83. Will you please tell me to which projection SRID 2163 refers? Using this will I have units in Meters? Thanks & regards, Santosh Gaikwad Senior Software Developer Saama Technologies (India) Pvt Ltd.

FW: [postgis-users] Regarding SRID 2163

2007-07-03 Thread Santosh Gaikwad
Dear Jeff, I read your post with answer too. Well SRID 4269 refers to NAD83. Will you please tell me to which projection SRID 2163 refers? Using this will I have units in Meters? Thanks & regards, Santosh Gaikwad Senior Software Developer Saama Technologies (India) Pvt Ltd.

[postgis-users] (no subject)

2007-07-03 Thread Santosh Gaikwad
Dear Jeff, I read your post with answer too. Well SRID 4269 refers to NAD83. Will you please tell me to which projection SRID 2163 refers? Using this will I have units in Meters? Thanks & regards, Santosh Gaikwad Senior Software Developer Saama Technologies (India) Pvt Ltd.

RE: [postgis-users] insert interactively asc or text files

2007-07-04 Thread Santosh Gaikwad
Hi, You can try out Pentaho Kettle software. Santosh Gaikwad Senior Software Developer Saama Technologies (India) Pvt Ltd. 6th Floor West Wing, Marisoft III, Marigold Premises, Kalayani Nagar, Pune - 411014. India Phone : +91 20 66071319 Extn: 397 Mobile: +91-9422005927 E-mail :[EMAIL PROTECTED

[postgis-users] (no subject)

2007-07-04 Thread Santosh Gaikwad
When I am using openjump by bringing postgis data into it, I can not see the distance in meters on map. Why it is so? Thus this means SRID 2163 has been used only to transform the projection. Next I want to work on whole USA data. Please kindly let me know whether I am following the correct st

[postgis-users] Lat/Long,geometry and buffer

2007-07-04 Thread Santosh Gaikwad
When I am using openjump by bringing postgis data into it, I can not see the distance in meters on map. Why it is so? Thus this means SRID 2163 has been used only to transform the projection. Next I want to work on whole USA data. Please kindly let me know whether I am following the correct st

RE: [postgis-users] Lat/Long,geometry and buffer

2007-07-06 Thread Santosh Gaikwad
make distance_spheroid() faster? I am looking forward for the help. Thanks & regards, Santosh Gaikwad Senior Software Developer Saama Technologies (India) Pvt Ltd. 6th Floor West Wing, Marisoft III, Marigold Premises, Kalayani Nagar, Pune - 411014. India Phone : +91 20 66071319 Extn: 397 Mo

[postgis-users] How to use tiger_geocoder

2007-07-11 Thread Santosh Gaikwad
Hi, Does anybody know how to use tiger_geocoder? Please also explain me how to load TIGER/line data into postgis. There are many files when you unzip the tiger/line data folder. Which files to be loaded into the database? Thanks & regards, Santosh Gaikwad Senior Software Devel

[postgis-users] st_dwithin()

2007-08-07 Thread Santosh Gaikwad
Hi All, I have installed PostGIS 1.2.1 version but I could not able to find out st_dwithin() in it. In which version this function will be available? Thanks & Regards, Santosh Gaikwad Senior Software Developer Saama Technologies (India) Pvt Ltd. 6th Floor West Wing, Marisoft

RE: [postgis-users] st_dwithin()

2007-08-07 Thread Santosh Gaikwad
Hi, Is PostGIS 1.2.2 version available for download? If so, please provide the link for it. Santosh Gaikwad Senior Software Developer Saama Technologies (India) Pvt Ltd. 6th Floor West Wing, Marisoft III, Marigold Premises, Kalayani Nagar, Pune - 411014. India Phone : +91 20 66071397

[postgis-users] PostGIS 1.2.2 version

2007-08-07 Thread Santosh Gaikwad
Hi, Is PostGIS 1.2.2 version available for download? If so, please provide the link for it Thanks & Regards, Santosh Gaikwad Senior Software Developer Saama Technologies (India) Pvt Ltd. 6th Floor West Wing, Marisoft III, Marigold Premises, Kalayani Nagar, Pune - 411014. India P

[postgis-users] PostGIS 1.3.0

2007-08-09 Thread Santosh Gaikwad
Hi All, When PostGIS 1.3.0 version for windows will be available? Thanks & Regards, Santosh Gaikwad Senior Software Developer Saama Technologies (India) Pvt Ltd. 6th Floor West Wing, Marisoft III, Marigold Premises, Kalayani Nagar, Pune - 411014. India Phone : +91 20 6607

[postgis-users] TIGER geocoder

2007-08-20 Thread Santosh Gaikwad
loading TIGER data, I would like to TIGER geocoder installation steps. Thanks & Regrads, Santosh Gaikwad Senior Software Developer Saama Technologies (India) Pvt Ltd. 6th Floor West Wing, Marisoft III, Marigold Premises, Kalayani Nagar, Pune - 411014. India Phone : +91 20 66071397 Mo

RE: [postgis-users] Help finding information on creating a "Heat Map"

2007-08-24 Thread Santosh Gaikwad
Hi, You can try out http://www.heatmapapi.com Thanks & Regards Santosh Gaikwad Senior Software Developer Saama Technologies (India) Pvt Ltd. 6th Floor West Wing, Marisoft III, Marigold Premises, Kalayani Nagar, Pune - 411014. India Phone : +91 20 66071397 Mobile: +91-9422005927 E-mail :[E

RE: [postgis-users] Write out KML for each database record?

2007-11-11 Thread Santosh Gaikwad
Hi Dane, Can you send me the full script? Were you the intern of Pacific Biodiversity Institute, Winthrop, WA in 2004? Thanks & Regards, Santosh Gaikwad Senior Software Developer Saama Technologies (India) Pvt. Ltd., Unit No.101-102, First floor, Weikfield IT CITI INFO

[postgis-users] Query performanace against huge point table

2007-11-20 Thread Santosh Gaikwad
.0527 37.323)',4326),2163), 1000 ); But it takes long time to get the result. I am seeking help. Thanks & Regards, Santosh Gaikwad Senior Software Developer Saama Technologies (India) Pvt. Ltd., Unit No.101-102, First floor, Weikfield IT CITI INFO PARK, Weikfield

RE: [postgis-users] Query performanace against huge point table

2007-11-20 Thread Santosh Gaikwad
Hi Kevin, Thank you very much for your help. I created now the functional index of "transform(the_geom,2163)" on my geometry column. It is faster now. I would like to know whether clustering of indices helps in speeding up the query. Thanks & Regards, Santosh Gaikwad Senior Soft

RE: [postgis-users] Query performanace against huge point table

2007-11-22 Thread Santosh Gaikwad
increasing the performance. I would appreciate your help on this issue. Thanks & Regards, Santosh Gaikwad Senior Software Developer Saama Technologies (India) Pvt. Ltd., Unit No.101-102, First floor, Weikfield IT CITI INFO PARK, Weikfield estates, Pune Nagar Road, Pune - 411 014. India

[postgis-users] Spatial index in stored function

2007-12-18 Thread Santosh Gaikwad
index. I would like to know whether spatial indexes are getting used in stored function or not. My stored function is result is bit slower. Thanks & Regards, Santosh Gaikwad Senior Software Developer Saama Technologies (India) Pvt. Ltd., Unit No.101-102, First floor, Weikfield IT

RE: [postgis-users] Finding a PostGIS guru (in Australia)

2008-01-02 Thread Santosh Gaikwad
Dear Craig, I am interested in your job offer. Let me know your email id so that I will write to you in detail. Thanks & Regards, Santosh Gaikwad Senior Software Developer Saama Technologies (India) Pvt. Ltd., Unit No.101-102, First floor, Weikfield IT CITI INFO PARK, Weikf