Re: [Qgis-user] Saving/Loading styles in Postgis

[Burghardt.Scholle]

Hi Andreas,

To save the layer styles in a PG table is a cool feature ☺. I have no problems 
to save the table with a connection based on host/database.

A hint from me: QGIS stores the style-information with the data type “xml”. For 
me this made problems when exporting / importing this data. By default, the 
XMLPARSER from postgresql works with the "CONTENT" option. When importing a 
dump file from the “layer styles”-table you get an error message: “ERROR: 
invalid XML content”. To prevent this, you need to edit the dump file. Before 
the insert / copy command to insert the layer styles records you must add the 
statement “SET xmloption TO DOCUMENT;”.

Regards
Burghardt

Von: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] Im Auftrag von 
Andreas Neumann
Gesendet: Donnerstag, 28. Juli 2016 18:14
An: DelazJ
Cc: QGIS User List
Betreff: Re: [Qgis-user] Saving/Loading styles in Postgis

Strange. I can see the empty layer_styles table in my public schema. But saving 
fails. Maybe it fails because my PG connection is based on a service definition 
and not on host/database?
On July 28, 2016 6:08:01 PM CEST, DelazJ 
> wrote:
Hi,
Andreas,  Styles are indeed saved in the public schema, in a table named 
"layer_styles". I had never created such a table so I assume it's created by 
QGIS.
Just made a test and rename my current "layer_styles" table. Then I 
successfully save a new layer style in PG from QGIS 2.16: a new table 
"layer_styles" has automatically been created in the public schema.
HTH,
Harrissou

2016-07-28 17:38 GMT+02:00 Neumann, Andreas 
>:

Hi,

I have never used the Saving/Loading of styles in Postgis (see 
http://docs.qgis.org/2.14/en/docs/user_manual/working_with_vector/vector_properties.html#storing-style-in-a-file-or-a-database)

Do I have to create a special styling table for it to enable this?

Because when I try to save it (QGIS 2.16) I get an error message along the 
lines that my user may not have permissions to save the style. However, I am 
trying to save the style with a user that has full administrator rights in 
Postgis.

In what schema and table are the styles stored? I assume in the public schema. 
Will QGIS automatically create a styling table or do I have to create one 
myself?

Thank you for any hints!

Andreas




___
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


--
Diese Nachricht wurde von meinem Android-Mobiltelefon mit K-9 Mail gesendet.
___
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

[Qgis-user] Mssql offline table with sync

[damos]

Hi. was wondering if there is any currently available method to have a
similar functionality to the way that mapinfo works with MSSql tables.
in a nutshell you have the option of a linked table or a live table.
I would like the linked option, where once the connection is made a local
copy of the table is created. this local copy can then be refreshed with the
push of a button.
This is great for field work where you dont have a reliable internet
connection. I know that I can get a live connection, save the live table as
a layer definition file then save as a shape or spatiallite table, then copy
and paste the styles across or set the default qml file, then close and
reopen the LDF and resave but that is a lot of messing around.
any assistance gratefully accepted.

thanks
Damien



--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/Mssql-offline-table-with-sync-tp5278634.html
Sent from the Quantum GIS - User mailing list archive at Nabble.com.
___
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

Re: [Qgis-user] Saving/Loading styles in Postgis

[DelazJ]

Hi,
Andreas,  Styles are indeed saved in the public schema, in a table named
"layer_styles". I had never created such a table so I assume it's created
by QGIS.

Just made a test and rename my current "layer_styles" table. Then I
successfully save a new layer style in PG from QGIS 2.16: a new table
"layer_styles" has automatically been created in the public schema.

HTH,
Harrissou

2016-07-28 17:38 GMT+02:00 Neumann, Andreas :

> Hi,
>
> I have never used the Saving/Loading of styles in Postgis (see
> http://docs.qgis.org/2.14/en/docs/user_manual/working_with_vector/vector_properties.html#storing-style-in-a-file-or-a-database
> )
>
> Do I have to create a special styling table for it to enable this?
>
> Because when I try to save it (QGIS 2.16) I get an error message along the
> lines that my user may not have permissions to save the style. However, I
> am trying to save the style with a user that has full administrator rights
> in Postgis.
>
> In what schema and table are the styles stored? I assume in the public
> schema. Will QGIS automatically create a styling table or do I have to
> create one myself?
>
> Thank you for any hints!
>
> Andreas
>
>
>
>
> ___
> 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
>
___
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

Re: [Qgis-user] Saving/Loading styles in Postgis

[Andreas Neumann]

Strange. I can see the empty layer_styles table in my public schema. But saving 
fails. Maybe it fails because my PG connection is based on a service definition 
and not on host/database?

On July 28, 2016 6:08:01 PM CEST, DelazJ  wrote:
>Hi,
>Andreas,  Styles are indeed saved in the public schema, in a table
>named
>"layer_styles". I had never created such a table so I assume it's
>created
>by QGIS.
>
>Just made a test and rename my current "layer_styles" table. Then I
>successfully save a new layer style in PG from QGIS 2.16: a new table
>"layer_styles" has automatically been created in the public schema.
>
>HTH,
>Harrissou
>
>2016-07-28 17:38 GMT+02:00 Neumann, Andreas :
>
>> Hi,
>>
>> I have never used the Saving/Loading of styles in Postgis (see
>>
>http://docs.qgis.org/2.14/en/docs/user_manual/working_with_vector/vector_properties.html#storing-style-in-a-file-or-a-database
>> )
>>
>> Do I have to create a special styling table for it to enable this?
>>
>> Because when I try to save it (QGIS 2.16) I get an error message
>along the
>> lines that my user may not have permissions to save the style.
>However, I
>> am trying to save the style with a user that has full administrator
>rights
>> in Postgis.
>>
>> In what schema and table are the styles stored? I assume in the
>public
>> schema. Will QGIS automatically create a styling table or do I have
>to
>> create one myself?
>>
>> Thank you for any hints!
>>
>> Andreas
>>
>>
>>
>>
>> ___
>> 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
>>

-- 
Diese Nachricht wurde von meinem Android-Mobiltelefon mit K-9 Mail gesendet.___
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

[Qgis-user] Saving/Loading styles in Postgis

[Neumann, Andreas]

Hi, 

I have never used the Saving/Loading of styles in Postgis (see
http://docs.qgis.org/2.14/en/docs/user_manual/working_with_vector/vector_properties.html#storing-style-in-a-file-or-a-database)


Do I have to create a special styling table for it to enable this? 

Because when I try to save it (QGIS 2.16) I get an error message along
the lines that my user may not have permissions to save the style.
However, I am trying to save the style with a user that has full
administrator rights in Postgis. 

In what schema and table are the styles stored? I assume in the public
schema. Will QGIS automatically create a styling table or do I have to
create one myself? 

Thank you for any hints! 

Andreas 

  ___
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

[Qgis-user] qgis/remote sensing/OTB : needs & expectations ?

[image93]

Good morning, 

As part of a mission project, I talk currently with a significant
contributor to the development of qgis. We wonder about needs & expectations
of the users and developers regarding remote sensing qgis interface (in
particular, orfeo toolbox, wellknowed as OTB. 


So could you tell me, dear qgis and/or remote sensing software users and/or
developpers your needs and expectations please? 

In advance, thank you to throw light for us and to give your opinion. This
is a first and really important step in order to define and guide our
possible contribution to the software. 

Kind regards. 



--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/qgis-remote-sensing-OTB-needs-expectations-tp5278567.html
Sent from the Quantum GIS - User mailing list archive at Nabble.com.
___
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

Re: [Qgis-user] Handling of PostGIS TopoGeometry layers

[Sandro Santilli]

On Wed, Jul 27, 2016 at 02:47:39AM -0400, AW wrote:
> 100% agreed, Sandro.
> 
> I did a quick search in the QGIS hub for the mentioned issue, but couldn't 
> find it for now.

I found this one, for allowing the specification of a "bbox" column
to use for filtering:
http://hub.qgis.org/issues/9516

And this, to allow keyword substitution:
http://hub.qgis.org/issues/4374

I guess the latter would deprecate the former.
Your comments on the ticket(s) would be welcome.

> Is there anybody who can comment on the complexity of such a change?
> Would such a change in the PostGIS provider - despite the positive effects on 
> the handling of topologies - be even wanted?

Well, I would want it :)

> I am not experienced with creating QGIS Plugins... could that be a feasible 
> quick option in case a change of the provider is not a thing which would be 
> quickly implemented?

I guess a plugin could effectively change the query associated with
a layer so to filter by current bbox against an arbitrary column,
but I'm not sure what would be "quicker"...

--strk;
___
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

Re: [Qgis-user] Profiles in QGIS

[Tyler Veinot]

All;
Thanks for the info and presentations I will look into them this evening.
If there are projects related specifically to water and sewer I might be
able to squeeze some coin out of management to help support the project.

Saber;
Not looking at temporal datasets at this time, just looking to see the
profiles of our pipes (Water and Sewer) and manholes and where they are in
relation to other buried infrastructure; not to say we wouldn't like to get
into more robust capabilities in the future. Crayfish sounds pretty capable
I will certainly take a look.
Tyler

On Thu, Jul 28, 2016 at 6:41 AM, Saber Razmjooei <
saber.razmjo...@lutraconsulting.co.uk> wrote:

> Hi Tyler,
>
>
>
> What type of 3D datasets are you working with? You mentioned sewer
> network, is it related to the, for example, water depth/level in pipe or on
> the ground with time element? If it is a temporal dataset of surface water
> you can probably look into Crayfish plugin. It has its own profile tool,
> where the profile gets updated as you browser through time.
>
>
>
> Cheers
>
> Saber
>
>
>
>
>
> *From:* Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] *On Behalf
> Of *Tyler Veinot
> *Sent:* 27 July 2016 16:54
> *To:* qgis-user@lists.osgeo.org
> *Subject:* [Qgis-user] Profiles in QGIS
>
>
>
> Hi all;
>
> Anyone here use QGIS for a water and sewer utility that can suggest some
> good plugins for; structuring, processing, and/or cleaning data? Any plugin
> repositories that might be of interest to me?
>
> Also:
>
> Has anyone worked with profile views in QGIS? I tried a few plugins for
> viewing 3D datasets but I am interested to see what else is out there
> and/or is being worked on.
>
>
>
> Currently tried GHydraulics, mmqgis, networks, qgis_epanet, Qgis2threejs
>
> Thanks
>
> Tyler
>
>
> --
>
> This email and any files transmitted with it are confidential and intended
> solely for the use of the individual or entity to whom they are addressed.
> If you have received this email in error please notify the system manager.
> This message contains confidential information and is intended only for the
> individual named. If you are not the named addressee you should not
> disseminate, distribute or copy this e-mail. Please notify the sender
> immediately by e-mail if you have received this e-mail by mistake and
> delete this e-mail from your system. If you are not the intended recipient
> you are notified that disclosing, copying, distributing or taking any
> action in reliance on the contents of this information is strictly
> prohibited.
>
> Whilst reasonable care has been taken to avoid virus transmission, no
> responsibility for viruses is taken and it is your responsibility to carry
> out such checks as you feel appropriate.
>
> If this email contains a quote or offer to sell products, carry out work
> or perform services then our standard terms and conditions
> 
> shall apply unless explicitly stated otherwise.
>
> Saber Razmjooei and Peter Wells trading as Lutra Consulting.
>
>
>
___
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

Re: [Qgis-user] Profiles in QGIS

[Saber Razmjooei]

Hi Tyler,

 

What type of 3D datasets are you working with? You mentioned sewer network, is 
it related to the, for example, water depth/level in pipe or on the ground with 
time element? If it is a temporal dataset of surface water you can probably 
look into Crayfish plugin. It has its own profile tool, where the profile gets 
updated as you browser through time.

 

Cheers

Saber

 

 

From: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of Tyler 
Veinot
Sent: 27 July 2016 16:54
To: qgis-user@lists.osgeo.org
Subject: [Qgis-user] Profiles in QGIS

 

Hi all;

Anyone here use QGIS for a water and sewer utility that can suggest some good 
plugins for; structuring, processing, and/or cleaning data? Any plugin 
repositories that might be of interest to me?

Also:

Has anyone worked with profile views in QGIS? I tried a few plugins for viewing 
3D datasets but I am interested to see what else is out there and/or is being 
worked on.

 

Currently tried GHydraulics, mmqgis, networks, qgis_epanet, Qgis2threejs

Thanks

Tyler



--
This email and any files transmitted with it are confidential and intended 
solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager. This 
message contains confidential information and is intended only for the
individual named. If you are not the named addressee you should not 
disseminate, distribute or copy this e-mail. Please notify the sender 
immediately
by e-mail if you have received this e-mail by mistake and delete this e-mail 
from your system. If you are not the intended recipient you are notified
that disclosing, copying, distributing or taking any action in reliance on the 
contents of this information is strictly prohibited.

Whilst reasonable care has been taken to avoid virus transmission, no 
responsibility for viruses is taken and it is your responsibility to carry out
such checks as you feel appropriate.

If this email contains a quote or offer to sell pro
 ducts, carry out work or perform services then our standard terms and 
conditions (which can be found at 
http://www.lutraconsulting.co.uk/downloads/Lutra%20Consulting%20Standard%20Terms%20and%20Conditions.pdf
 shall apply unless explicitly stated otherwise.

Saber Razmjooei and Peter Wells trading as Lutra Consulting.

___
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

Re: [Qgis-user] Geosoft Grid Files

[Benoit de Cabissole]

Hi, 

Although the .grd format used by Geosoft nowadays is proprietary, you
can use the free viewer, as said below, to export the file into .gxf
(the Geosoft grid exchange format) and open it in many, many
applications, including QGIS. 

A word of caution: you must be sure that the orientation of the Geosoft
grid is set to 1, otherwise the GDAL GXF importer will not work
correctly (at least, as at the last time I've used it, long time ago!). 

cheers,
Benoit 

On 28/07/2016 04:44, Szilard Albert wrote:

> Hi, indeed, Oasis Montaj free viewer is able to convert .grd to .ers, from 
> under Grids menu. I successfully exported a .grd file as .ers, and while my 
> Qgis is busy processing, I was able to open the exported .ers in Global 
> Mapper.
> Tried to attach a screenshot of the output format choices, but it gets 
> blocked due to message size. regards, Szilard 
> 
> On 28 July 2016 at 11:45, Nicolas Cadieux  
> wrote:
> 
> Hi,
> According to this the geosoft free viewer has some export capabilities. 
> 
> https://pubs.usgs.gov/of/2004/1258/Data/grid_facts.txt 
> 
> Good luck
> Nicolas
> 
> On Jul 27, 2016 21:24, "Grant Boxer [via OSGeo.org]" <[hidden email] [1]> 
> wrote:
> 
> QGIS does not seem to be able to read the Geosoft grid format (*.grd) grids. 
> 
> Can anyone suggest how I may be able to convert these files to a format (for 
> example to ERMapper (*.ers) files) suitable for QGIS? 
> 
> Grant Boxer 
> 
> Perth, Western Australia 
> ___ 
> Qgis-user mailing list 
>  href="/user/SendEmail.jtp?typenodenode5278481i0">[hidden
>  email] 
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user 
> 
> -
> 
> If you reply to this email, your message will be added to the discussion 
> below: http://osgeo-org.1560.x6.nabble.com/Geosoft-Grid-Files-tp5278481.html 
> To start a new topic under Quantum GIS - User, email 
> ml-node+s1560n4125267...@n6.nabble.com 
> To unsubscribe from Quantum GIS - User,  href="http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macrounsubscribe_by_codenode4125267codebmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYXw0MTI1MjY3fDYzNDQ4MjQxNg
>  [2];">click here.
>  href="http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macromacro_vieweridinstant_html%21nabble%3Aemail.namlbasenabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespacebreadcrumbsnotify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml
>  [3]" style="font:9px serif">NAML 
> 
> -
> View this message in context: Re: Geosoft Grid Files [4]
> Sent from the Quantum GIS - User mailing list archive [5] at Nabble.com.
> 
> ___
> 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

___
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 

Links:
--
[1] http:///user/SendEmail.jtp?type=nodenode=5278482i=0
[2]
http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro#61;unsubscribe_by_codeamp;node%2361;4125267amp;code%2361;bmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYXw0MTI1MjY3fDYzNDQ4MjQxNg%2361;%2361
[3]
http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro#61;macro_vieweramp;id%2361;instant_html%21nabble%3Aemail.namlamp;base%2361;nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespaceamp;breadcrumbs%2361;notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml
[4]
http://osgeo-org.1560.x6.nabble.com/Geosoft-Grid-Files-tp5278481p5278482.html
[5] http://osgeo-org.1560.x6.nabble.com/Quantum-GIS-User-f4125267.html
___
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