[Spanish] Re: POSTGIS - SELECT de puntos de una linea

Gustavo Jarrín gusjarrin at hotmail.com
Wed Jul 13 12:03:45 EDT 2011


Mil gracias Gastón, 

perdona, y para sacar los puntos de una tabla tipo poligono?

Slds

gustavo

> Date: Wed, 13 Jul 2011 09:43:14 -0300
> From: gaston.lucero at sitrack.com
> To: spanish at lists.osgeo.org
> Subject: [Spanish] Re: POSTGIS - SELECT de puntos de una linea
> 
> Puedes utilizar
> select st_pointn(linea ,generate_series(1,st_numpoints(linea))) from tabla
> 
> o también
> 
> select st_dumppoints(geometry).geom from tabla
> 
> Saludos
> Disclaimer:
> 
> This email and any attachments thereof may contain confidential, privileged, proprietary, or otherwise private information. This email is intended solely for the use of the individual to whom it is addressed. If you are not the intended recipient of the email and its attachments please inform the sender immediately and do not disclose the contents to any other person, use it for any purpose or store or copy the information in any way and delete this e-mail and its attachments from your system. Any views or opinions expressed are solely those of the author.
> 
> _______________________________________________
> Spanish mailing list
> http://lists.osgeo.org/mailman/listinfo/spanish
> http://es.osgeo.org
> http://twitter.com/osgeoes
 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/spanish/attachments/20110713/5a2c27bf/attachment.html


More information about the Spanish mailing list