[postgis-devel] Doubt - PostGis
Eriovaldo Andrietta
ecandrietta at gmail.com
Sun Nov 7 14:24:03 PST 2010
Andrea,
Thanks a lot for your help.
It worked fine. :)
Now my next step is to convert data from Oracle Spatial to Postgis.
I saw in the net the tool ora2pg.
Do you know any other tool that does data conversion from Oracle to Postgis
?
Need I write scripts in Oracle for extracting spatial data ?
I hava a lot of data to convert.
Best Regards
Eriovaldo
On Sun, Nov 7, 2010 at 6:03 PM, Andrea Peri 2007 <aperi2007 at gmail.com>wrote:
> BEGIN;
>> INSERT INTO tb_circularstring (ID,NAME,GEOM ) VALUES
>> (1,'1',GeomFromText('CIRCULARSTRING(8 8, 1 1, 1 0)',-1));
>> commit;
>> select * from tb_circularstring;
>>
>> I can see data in the database, but tools don“t show the geometry to me.
>>
>> Need I add data into any other table ?
>> I am using: Quantum GIS, Open Jump, Udig ...
>> Any tool shows the data
>>
>> What is wrong.
>>
>
> The tools GIS don't support the
> CIRCULARSTRING geometry,
> so you must trasform it in a LineString using the ST_CurveToLine(..)
>
> with QGIS you can use the RT_SQL_Layer plugin and put this query :
>
> select id,ST_CurveToLine(a.geom) as geom from tb_circularstring as a;
>
> or with other gis tools
> you can create a view for call always the same query:
> select id,ST_CurveToLine(a.geom) as geom from tb_circularstring as a;
>
>
> Regards,
>
> Andrea.
>
>
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20101107/0c69b3a8/attachment.html>
More information about the postgis-devel
mailing list