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

[Nicolas Ribot]

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/8b04f4b4/attachment.html>