[postgis-users] Convert a non spatial table into a spatial table

[Richard White]

Hi,

 

I have a table which contains order areas as wkt. Is it possible to
convert this table into a spatial table so the order areas can be viewed
in QGIS.

 

Thanks.

 

Richard.


Infoterra Ltd. Is part of the Astrium GEO-Information Services Division and a 
wholly owned subsidiary of Astrium, Europe's leading space systems and services 
specialist.

Disclaimer. The information contained in this e-mail and its attachments are 
confidential and intended only for the use of the named addressee(s). If you 
are not the intended addressee, please do not read, copy, use or disclose this 
message or its attachments. If you have received this message in error, please 
notify the sender immediately and delete or destroy all copies of this message 
and attachments in all media. Any views or opinions expressed are solely those 
of the author and do not necessarily represent those of Infoterra Ltd and shall 
not form part of any binding agreement.

Infoterra Limited a company registered in England under number 2359955 and 
having its registered office at Atlas House, 41 Wembley Road, Leicester, LE3 
1UT. VAT number GB 476 0468 27. 

P Before printing, think about the environment 

___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] Convert a non spatial table into a spatial table

[Thomas Gratier]

Hello,

You can convert our wkt table to PostGIS. See PostGIS docs for this.
http://postgis.refractions.net/docs/ch04.html#OpenGISWKBWKT
You can in first convert your table to PostGIS with your wkt as a text,
after create a proper geometry column and apply functions from the docs to
get a result you can open in Qgis.

Regards

ThomasG
GIS specialist
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users