[postgis-users] ogr2ogr oracle to postgis - emtpy geom column

[Nicolas Ribot]

(concerning QGIS, its a DB driver option that allows to resolve tables with
GEOMETRY column)

[image: Inline images 1]

Nicolas

On 9 January 2018 at 18:46, Nicolas Ribot <nicolas.ribot at gmail.com> wrote:

> Hi,
> Long texts are not displayed in pgAdmin.
> No entry for geometry columns usually means your geometric type is
> GEOMETRY. You can cast it to POLYGON or MULTIPOLYGON.
>
> You can test your geo column:
> select st_summary(shape_poly), st_npoints(shape_poly)
> from au_alkis_unit;
>
> Nicolas
>
> On 9 January 2018 at 18:38, <ofoerster at posteo.de> wrote:
>
>>
>>
>> Am 09.01.2018 15:31 schrieb ofoerster at posteo.de:
>>
>>> Hello community,
>>>
>>> I have the problem that when I migrate from Oracle to PostGIS I get an
>>> empty geometry column.
>>> All other data was taken over normally. My PostGIS extension is
>>> activated.
>>> My command is:
>>>
>>> ogr2ogr -a_srs EPSG:25833 -overwrite -f "PostgreSQL" -nln
>>> public.au_alkis_unit PG:"host=localhost port=5432 user=postgres
>>> password=postgres dbname=hale_export"
>>> OCI:"inspire/inspire@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS =
>>> (PROTOCOL = TCP)(HOST = fb20)(PORT = 1521)))(CONNECT_DATA = (SID
>>> =fbr))):AU_ALKIS_UNIT"
>>>
>>> Can someone help me?
>>>
>>> For the sake of traceability I have done the Oracle table as SQL dump
>>> in the attachment.
>>>
>>> best regards, Oli
>>>
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at lists.osgeo.org
>>> https://lists.osgeo.org/mailman/listinfo/postgis-users
>>>
>>
>>
>> ------------------------------------------------------------
>> ------------------------------------------------------------
>> ----------------------------------------------------------------------
>>
>> It is very strange. In the PG Admin, the geometry column is empty. In
>> QGIS I can embed the table and the correct geometries are displayed.
>> However, the DB Manager of QGIS says that the geometry column has no
>> entries.
>>
>> Please Help.
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20180109/e5b99951/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screen Shot 2018-01-09 at 18.49.08.png
Type: image/png
Size: 62444 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20180109/e5b99951/attachment.png>