[Qgis-user] QGIS DB Manager geometry columns issue with PostGIS 2.0
Andreas Neumann
a.neumann at carto.net
Fri Feb 5 08:21:13 PST 2016
Hi Chris,
This explains it.
You need to define as "geometry(WKBTYPE,srid)", e.g.
"geometry(POLYGON,21781)" for QGIS. FME has an option to do that. I just
don't have at hand. I could send you instructions on Monday, if you want.
Andreas
On 05.02.2016 17:11, Chris Buckmaster wrote:
>
> Hi Andreas
>
> Yes it does exist in the geometry column view but the type is listed
> as GEOMETRY.
>
> This table is being created from a non-spatial SQL Server table, and
> we use a vertex creator transformer in FME to create the spatial table
> – we cannot seem to explicitly specify the geometry that the spatial
> table should be as it is not a spatial layer when imported?
>
> Chris
>
> *From:*Qgis-user [mailto:qgis-user-bounces at lists.osgeo.org] *On Behalf
> Of *Andreas Neumann
> *Sent:* 05 February 2016 12:43
> *To:* qgis-user at lists.osgeo.org
> *Subject:* Re: [Qgis-user] QGIS DB Manager geometry columns issue with
> PostGIS 2.0
>
> Hi Chris,
>
> That's true - starting from Postgis 2.0, geometry_columns is a view in
> the public schema.
>
> Did you check if that view exists and if the view contains an entry
> for your spatial table?
>
> Also make sure, when importing from FME, that you restrict your
> geometry type to either POINT, POLYGON, LINESTRING, COMPOUNDCURVE or
> the MULTI versions. QGIS likes a single geometry type per table, while
> Postgis would permit to store mixed geometry types in the same
> geometry column.
>
> Maybe you did not specify this geometry type restriction when
> importing your data with FME.
>
> Andreas
>
> On 05.02.2016 13:33, Chris Buckmaster wrote:
>
> Hi
>
> I have been using FME to load some data into PostGIS and view it
> in QGIS 2.12.3.
>
> I am finding that when accessing the data in DB Manager, I get a
> warning that says ‘There is no entry in geometry_columns!’.
>
> On asking another user they mentioned that the geometry columns
> table was removed in PostGIS 2.0, so my question is, is this a
> known issue / bug within QGIS, or is it the way in which I am
> storing my data? Just wondering if this will be looked at in
> future QGIS versions.
>
> Thanks, Chris
>
>
>
>
> _______________________________________________
>
> Qgis-user mailing list
>
> Qgis-user at lists.osgeo.org <mailto:Qgis-user at lists.osgeo.org>
>
> List info:http://lists.osgeo.org/mailman/listinfo/qgis-user
>
> Unsubscribe:http://lists.osgeo.org/mailman/listinfo/qgis-user
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20160205/fe079965/attachment.html>
More information about the Qgis-user
mailing list