Hi Andreas Ah yes brilliant, thank you so much!
Chris From: Neumann, Andreas [mailto:a.neum...@carto.net] Sent: 08 February 2016 14:48 To: Chris Buckmaster Cc: qgis-user@lists.osgeo.org Subject: RE: [Qgis-user] QGIS DB Manager geometry columns issue with PostGIS 2.0 Hi Chris, This option does not appear on already existing feature types. Please add a new writer (independent from the ones you already have in your workspace) and make sure you uncheck the Option "Create Generic Spatial Columns". Then, in the next dialogue - the Feature Type Properties Dialogue have a look in the "General" tab - not the "Format Parameters" tab. Have a look at the two attached screenshots. I am also in the 2015 edition. Hope this helps, Andreas On 2016-02-08 15:38, Chris Buckmaster wrote: Hi Andreas This doesn't seem to be an option for me – perhaps this is on a different version? I am using FME Professional Edition 2015.1.3.1. Below is what I see... [X] Chris From: Neumann, Andreas [mailto:a.neum...@carto.net] Sent: 08 February 2016 14:32 To: Chris Buckmaster Subject: RE: [Qgis-user] QGIS DB Manager geometry columns issue with PostGIS 2.0 Hi Chris, Ah yes - sorry. Forgot about that. Here are the instructions: In FME, if you add a writer for a Postgis database have a look into the "Parameters" dialogue. In there you find a checkbox labeled "Create Generic Spatial Columns". --> make sure you uncheck this checkbox. Then if you add a new Feature type you will find a drop-down box in the "General" tab labeled with "Geometry". There you can select the geometry type, such as "postgis_point" or "postgis_linestring". Can you please let me know if this works for you? Andreas On 2016-02-08 15:24, Chris Buckmaster wrote: Hi Andreas I have tried to find where I can do this in FME but still seem unable to – if it isn't too much work are you able to point me in the right direction please? Thank you, Chris From: Andreas Neumann [mailto:a.neum...@carto.net] Sent: 05 February 2016 16:21 To: Chris Buckmaster; qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] QGIS DB Manager geometry columns issue with PostGIS 2.0 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-boun...@lists.osgeo.org] On Behalf Of Andreas Neumann Sent: 05 February 2016 12:43 To: qgis-user@lists.osgeo.org<mailto:qgis-user@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@lists.osgeo.org<mailto:Qgis-user@lists.osgeo.org> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
