[postgis-users] a long time calculate distance between point and polygon

[Francisco Salas]

Nicklas, I am  working in geometry data type with SRID 4326 , in other mail Sandro ask me what version of postgis I have using.
 It's possible that  using version 1.5 of Postgis?  
  
Thanks,   
  Francisco Salas

-----Mensaje original-----
De: Nicklas Avén [mailto:nicklas.aven at jordogskog.no] 
Enviado el: martes, 11 de diciembre de 2012 02:59 p.m.
Para: Francisco Salas
Asunto: RE: [postgis-users] a long time calculate distance between point and polygon

Ops, that sounds like something that shouldn't happen. It looks like a server crash. 

Could you please try to make your data set as small as possible, but still getting that server crash, and share that part of your data set.
Are you working in geometry or geography data type?

Regards

Nicklas



On Mon, 2012-12-10 at 09:46 -0500, Francisco Salas wrote:
> Hi, Nicklas , I used this
> select * from pozos p,suelos s where 
> ST_DWithin(p.the_geom,s.the_geom,1000)
> 
> but in the output panel Messages of the pgAdmin III , appear only this 
> around 22011 ms
> ********** Error **********
> 
> How  I can determinate what's is the problems ?
> 
> Regards,
> Francisco Salas
> 
> -----Mensaje original-----
> De: postgis-users-bounces at lists.osgeo.org
> [mailto:postgis-users-bounces at lists.osgeo.org] En nombre de Nicklas 
> Avén Enviado el: miércoles, 05 de diciembre de 2012 04:45 p.m.
> Para: PostGIS Users Discussion
> Asunto: Re: [postgis-users] a long time calculate distance between 
> point and polygon
> 
> Hallo
> 
> You should use ST_DWithin instead with gist index on your 
> gometry/geography
> column:
> 
> select * from pozos p,suelos s where
> ST_DWithin(p.the_geom,s.the_geom,1000)
> 
> 
> HTH
> 
> Nicklas
> 
> 
> 
> On Wed, 2012-12-05 at 16:32 -0500, Francisco Salas wrote:
> > Hi,
> > 
> > I have test in two database one with SRID 2085 an other 4326 use 
> > this sql
> > 
> > pozos : 2339 rows
> > 
> > suelos:1526 rows
> > 
> > for 2085 :   
> > 
> > select * from pozos p,suelos s where
> > st_distance(p.the_geom,s.the_geom)
> > 
> > <=1000
> > 
> > time of result : 3 minutes aprox    
> > 
> >  
> > 
> > for 4326 :   
> > 
> > select * from pozos p,suelos s where
> > st_distance(p.the_geom,s.the_geom,true)
> > 
> > <=1000
> > 
> > time of result : not determined   
> > 
> > Why happen this problem?  
> > 
> > How I can optimize this?  
> > 
> > I am using PostGis 1.5.2
> > 
> >  
> > 
> > Regards,
> > 
> >  
> > 
> > Francisco Salas
> > 
> >  
> > 
> > 
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at lists.osgeo.org
> > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
> 
>