Re: [Qgis-user] Import German population data

2024-07-06 Per discussione Bernhard Ströbl via QGIS-User
Hallo Jonathan, you can import the data as points using the X and Y fields (see manual [1]) but I suspect you want to display them as raster data (Hektarraster). Therefore you need to get the Hektarraster 1km grid data (from here I guess [2]). Each grid cell has an identifier (Field id);

Re: [Qgis-user] Using Processing for nightly ETL jobs

2024-05-30 Per discussione Bernhard Ströbl via QGIS-User
> configure the DB access. Using this one in your model should do the > trick.. > > Cheers, > Björn > > On 30.05.2024 08:47, Bernhard Ströbl via QGIS-User wrote: > > Hello everybody, > > > > I did some experiments in the last couple days and your help

Re: [Qgis-user] Using Processing for nightly ETL jobs

2024-05-30 Per discussione Bernhard Ströbl via QGIS-User
Hello everybody, I did some experiments in the last couple days and your help was very valuable. I succeeded in creating two models that - when run within QGIS or from the console - download data of different types and write it into a PostgreSQL database. For automation purposes I want to run

Re: [Qgis-user] Using Processing for nightly ETL jobs

2024-05-22 Per discussione Bernhard Ströbl via QGIS-User
Hi Germán, thank you for your answer. That will definitely solve part of my needs. all the best Bernhard > Germán Carrillo hat am 22.05.2024 23:30 CEST > geschrieben: > > > Hi All, > > have a look at: > > https://github.com/gacarrillor/AppendFeaturesToLayer > > It has ready-to-use

Re: [Qgis-user] Using Processing for nightly ETL jobs

2024-05-22 Per discussione Bernhard Ströbl via QGIS-User
Hi Etienne, I did read the docs, but that particular chapter slipped my attention, so thank you for nudging me. Seems like exactly what I might need. Bernhard > Etienne Trimaille hat am 22.05.2024 19:19 CEST > geschrieben: > > > Hi, > >

Re: [Qgis-user] Removal of overlap geometries within the same layer - merge to largest neighbor polygon

2023-07-26 Per discussione Bernhard Ströbl via QGIS-User
ld be an option, but a native solution in QGIS would be > preferred > > So in summary: there are several options around for cleaning overlaps - but > it isn't as straight-forward and user friendly yet as it could/should be. > > I haven't looked at the gaps yet ... > > Thank

Re: [Qgis-user] Removal of overlap geometries within the same layer - merge to largest neighbor polygon

2023-07-25 Per discussione Bernhard Ströbl via QGIS-User
Hi Andreas, the Algorithm "Eliminate selected polygons" was originally created to address these questions. I usually imported the data into GRASS ran a clean there and reexported the results into a non topolgical dataset. Thus overlapping areas and gaps (only if closed) are identified and can

Re: [Qgis-user] Request for Guidance on Using 'Dissolve' Tool in QGIS with IUCN Data

2023-06-26 Per discussione Bernhard Ströbl via QGIS-User
Hi Marcello, you can choose which fields QGIS should use for the dissolve process. Only features that are homogeneous throughout the chosen fields will be dissolved into a new feature. Hope this helps Bernhard > Marcello Bilancioni via QGIS-User hat am > 26.06.2023 01:54 CEST geschrieben: >

Re: [Qgis-user] Shape file - Change "Polygon" to "Multipolygon"

2023-04-27 Per discussione Bernhard Ströbl via QGIS-User
If I remember it right there is no difference in the file itself. A shape file can digest single and multi geometries without changing its format. Are your polygons single or multi? If they are single it says single. Try adding some multi polygons and look what happens. Bernhard > Riccardo via

Re: [Qgis-user] [EXTERN] Re: Restrict User's access to extensions

2023-03-23 Per discussione Bernhard Ströbl via QGIS-User
Hi, if the plugins are considered a security risk (no matter by whom and no matter if this is justified or not) then probably you should block access to all urls holding plugins on the network level. Your proposed approach is "security by obscurity" IMHO. A more bureaucratic approach would be

Re: [Qgis-user] Incredibly slow attribute view/access from postgresv3.16

2021-10-06 Per discussione Bernhard Ströbl
Hi, just a few ideas: Do you have a spatial index on the table? I have no clue how QGIS handles the attribute table (loading all datasets in the first place and then select or else) maybe editing this many features is better done directly on the DB? Bernhard Am 05.10.2021 um 23:51 schrieb

Re: [Qgis-user] Multi User - QGIS

2021-09-13 Per discussione Bernhard Ströbl
Hi, i use a sequence for this and a trigger, that ensures that the sequence is used, no matter what user input comes from QGIS; trigger function: CREATE FUNCTION shema.table_ensure_sequence() RETURNS trigger AS $BODY$ DECLARE str_execute text; BEGIN IF (TG_OP = 'INSERT') THEN

Re: [Qgis-user] remove slivers

2021-06-17 Per discussione Bernhard Ströbl
Hi Ursula, try "eliminate selected polygons" from the processing toolbox first step is to select, normally you would use the area-circumference ratio for the selection second step "eliminate selected polygons" Bernhard Am 17.06.2021 um 15:33 schrieb Ursula Heinze: Hi, I do have a problem with

Re: [Qgis-user] Best practice, database vs WFS

2021-01-06 Per discussione Bernhard Ströbl
Hi, I want to add my 2 cents (all AFAIK): WFS is a standard for data exchange as has been pointed out by Alessandro already. The data are in an XML format (GML) which is _slow_ compared to data from a database for several reasons. QGIS downloads the complete layer as GML which, depending on

Re: [Qgis-user] QGIS slows PC to a point it is unusable

2020-01-09 Per discussione Bernhard Ströbl
Hi Peter, to me this sounds like a problem with a badly coded plugin. Unload _all_ plugins and see if the permformance improves. If it does reload the plugins one by one to identify which is causing the trouble. Of course you can also improve performance by indexing your shape files or using

Re: [Qgis-user] Adding topological vertices

2019-08-14 Per discussione Bernhard Ströbl
Hi Jan, sorry I cannot reproduce the behaviour you describe in QGIS 3.4.10. Be sure to read about the new vertex tool (and its changed behaviour compared to 2.*) in the manual [1] Bernhard [1]

Re: [Qgis-user] Can't print large QGIS file

2019-07-18 Per discussione Bernhard Ströbl
Hi, could that be a RAM problem? I remember that (in times of QGIS2) running 32bit QGIS on Windows the RAM limit per application (I remember 4 GB) made it impossible to print larger maps (large in sense of large paper format with many features). What system are you running QGIS on? Bernhard

Re: [Qgis-user] Auxiliary storage: not editable if layer is not editable

2019-06-25 Per discussione Bernhard Ströbl
cally. If you want to manually create corresponding fields, you have to use the "Store Data in the project" button in data defined menu. Paul Le lun. 24 juin 2019 à 10:07, Bernhard Ströbl <mailto:bernhard.stro...@jena.de>> a écrit : Hi all, I have a PostGIS relat

[Qgis-user] Auxiliary storage: not editable if layer is not editable

2019-06-24 Per discussione Bernhard Ströbl
Hi all, I have a PostGIS relation that is not editable in QGIS (user has only SELECT rights). I created a field in the auxiliary storage to insert positioning information. I cannot edit this field because "toggle editing" is disabled. I was under the impression that the auxiliary storage was

Re: [Qgis-user] Moving nodes

2019-04-02 Per discussione Bernhard Ströbl
ent=webmail> Virus-free. www.avast.com <https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=webmail> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> On Tue, Apr 2, 2019 at 10:47 AM Bernhard Ströbl mailto:bernhard.stro...@jena.de>> wrote:

Re: [Qgis-user] Moving nodes

2019-04-02 Per discussione Bernhard Ströbl
Hi Amila, 1) Make layer editable (click on the "pencil")* 2) use the vertex tool to edit nodes, e.g. move 3) save edits (click on "pencil" again) see https://docs.qgis.org/3.4/en/docs/user_manual/working_with_vector/editing_geometry_attributes.html#digitizing-an-existing-layer * if the pencil

Re: [Qgis-user] leicht verschobene Geometrien ansnappen/entzerren

2019-03-06 Per discussione Bernhard Ströbl
Hallo, wenn Du einmal GRASS über den Datensatz "laufen" lässt, werden Dir überlappende Polygone und Löcher angezeigt. Hat der Datensatz keine gewollten Überlappungen und Löcher, kannst Du mit dem QGIS-Werkzeug "Splitterpolygone beseitigen" wieder eine saubere Topologie herstellen (dabei

Re: [Qgis-user] North arrow in QGIS

2019-02-13 Per discussione Bernhard Ströbl
Hi, Am 13.02.2019 um 09:49 schrieb Richard Duivenvoorde: On 2/13/19 9:30 AM, Werner Macho wrote: Hi, while I see that a lot of "other" GIS Software has its own button for north arrows I am against adding a north-arrow button. reasons: While this is one of the few points which is not

Re: [Qgis-user] [QGIS-Server] WFS-T

2019-02-04 Per discussione Bernhard Ströbl
this reply off the spec and your error) can comment. Cheers, Jonathan On 2019-02-01 09:57, Bernhard Ströbl wrote: Hi all, I try to make an INSERT to QGIS-Server using WFS-T. But every insert fails with the server returning "Please check the value of the REQUEST parameter" This i

[Qgis-user] [QGIS-Server] WFS-T

2019-02-01 Per discussione Bernhard Ströbl
Hi all, I try to make an INSERT to QGIS-Server using WFS-T. But every insert fails with the server returning "Please check the value of the REQUEST parameter" This is the QGIS-server log output (anonymised): 10:15:17 INFO Server[9148]: New request ***

Re: [Qgis-user] After deleting points, attribute rows persist

2019-01-08 Per discussione Bernhard Ströbl
l.org/files/?artifact_id=25354 page 24 On 1/8/19 9:02 AM, Havard Tveite wrote: I agree that disabling the vertex tool for point layers is a good idea.  It will improve consistency and avoid confusion. A separate tool for moving a part of a multi-geometry would be useful. Håvard On 08. jan. 201

Re: [Qgis-user] After deleting points, attribute rows persist

2019-01-07 Per discussione Bernhard Ströbl
there is another tool that does exactly the same. Bernhard Am 07.01.2019 um 16:59 schrieb Saber Razmjooei: Hi Bernhard, How about multi-point layer? All the features will move/delete with the other tools. Regards Saber On Mon, 7 Jan 2019 at 15:55, Bernhard Ströbl <mailto:bernhard.s

Re: [Qgis-user] After deleting points, attribute rows persist

2019-01-07 Per discussione Bernhard Ströbl
Maybe the node tool shouldn't be available when editing a point layer? Anything one may want to do with points can be done using the other tools (move, delete part). I was always wondering why it is there because AFAIU nodes are not individual features, they only exist as part of a line or

Re: [Qgis-user] Node Tool - proposing improvements

2018-11-26 Per discussione Bernhard Ströbl
a proposal later on, will that do? Bernhard Am 27.11.2018 um 01:23 schrieb Nyall Dawson: On Mon, 26 Nov 2018 at 21:39, Bernhard Ströbl wrote: Dear all, I want to apologize, this has become an extremely long mail... A lot of discussion has been going on about the recent reimplementation of the node

Re: [Qgis-user] Node Tool - proposing improvements

2018-11-26 Per discussione Bernhard Ströbl
really be in favour of trying these ideas before adding a click in all operations with the tool. regards Bernhard Cheers, Denis Le lun. 26 nov. 2018 à 07:33, Bernhard Ströbl a écrit : Dear all, I want to apologize, this has become an extremely long mail... A lot of discussion has

[Qgis-user] Node Tool - proposing improvements

2018-11-26 Per discussione Bernhard Ströbl
Dear all, I want to apologize, this has become an extremely long mail... A lot of discussion has been going on about the recent reimplementation of the node tool in QGIS 3. I see two reasons for this: 1) The way the tool works is very different from the way it used to work in QGIS 2: a) in

Re: [Qgis-user] trouble with WMS layer

2018-10-16 Per discussione Bernhard Ströbl
Hi, all that comes to my mind is that the layer is named Mass.1to250k. If this stands for Massachusetts scale 1 to 25 I would not wonder to have nothing displayed when requesting the whole world. You get an empty map not an error, do you? IMHO this is a configuration question of the server

Re: [Qgis-user] [Possible bug] Qgis treating uuid as text in db views

2018-09-19 Per discussione Bernhard Ströbl
Am 19.09.2018 um 11:26 schrieb Rémi Desgrange: Hi, I have some database view used in qgis. (from postgresql 10, postgis2.4). Since some time now (I posted a bug report 3 months ago here: https://issues.qgis.org/issues/19180) This was about errors in my DBs log about selection request that

[Qgis-user] QGIS-Server GetPrint file extension

2018-09-18 Per discussione Bernhard Ströbl
Hi all, when requesting a print layout from QGIS Server via GetPrint I can set the FORMAT parameter to e.g. pdf. If the requesting browser has a pdf plugin, the layout is opened and displayed, if not the file can be saved. The proposed file name is the QGIS project's name _without_

Re: [Qgis-user] "Otherwise rule" in rendering

2018-08-30 Per discussione Bernhard Ströbl
That's what I normally do, not sure if it is a must. Bernhard Am 30.08.2018 um 08:52 schrieb Andrea Peri: Hi. thx for help. An else rule is exactly what I need . I try it . The "else" rule should be the last in the list of rules ? A. Il giorno gio 30 ago 2018 alle ore 07:4

Re: [Qgis-user] "Otherwise rule" in rendering

2018-08-29 Per discussione Bernhard Ströbl
Hi, it's called "ELSE" in the rule-based renderer Bernhard Am 29.08.2018 um 21:37 schrieb Andrea Peri: Hi, In the rule-rendering or in the category rendering is available an option like "otherwise" to rendering all value not listed in the usual rendering list of value ? Thx,

Re: [Qgis-user] QGIS 2.18 freeze meanwhile editing

2018-06-28 Per discussione Bernhard Ströbl
I assume a plugin is causing your problem; try to deactivate all plugins and check if the problem persists. If not reactivate them one by one to identify the one that causes the problem. Bernhard Am 28.06.2018 um 08:32 schrieb Andrea Peri: Hi, I'm using qgis 2.18. Every time I goin ediiting

Re: [Qgis-user] Delete key does not remove item in composer

2018-06-27 Per discussione Bernhard Ströbl
176 611 26 9 2 6 www.frankbroniewski.com <http://www.frankbroniewski.com> -Ursprüngliche Nachricht- Von: Qgis-user mailto:qgis-user-boun...@lists.osgeo.org>> Im Auftrag von Bernhard Ströbl Gesendet: Mittwoch, 27. Juni 2018 10:2

Re: [Qgis-user] Delete key does not remove item in composer

2018-06-27 Per discussione Bernhard Ströbl
*Von:* DelazJ *Gesendet:* Mittwoch, 27. Juni 2018 11:02 *An:* Frank Broniewski *Cc:* Bernhard Ströbl ; Qgis-user@lists.osgeo.org *Betreff:* Re: [Qgis-user] Delete key does not remove item in composer Hi, Let's not be so categorical and please, indicate also the platform you are working on. I'v

[Qgis-user] Delete key does not remove item in composer

2018-06-27 Per discussione Bernhard Ströbl
Hi all, the documentation [1] states that for removing an item in composer one can either use Backspace or Delete. However Delete does not work for me :-( Is there anything I am missing? Tried: QGIS 2.18.20 on Win7 and Ubuntu 16.04, QGIS 3.2 on Ubuntu 16.04 [1]

[Qgis-user] [QGIS-Server 3] Labels show as squares

2018-06-01 Per discussione Bernhard Ströbl
Hi, I am facing the following issue with QGIS-Server 3: All my labels are shown as black squares (one square for each letter). First the reason seemed to be the path the application was looking for fonts as lots of messages "QFontDatabase: Cannot find font directory

Re: [Qgis-user] hide vector under raster?

2018-05-29 Per discussione Bernhard Ströbl
Hi Tobias, I did not really get what you want to achieve. Let me put it in my words (this is what I understand) 1) You have a vector layer with _many_ features 2) You do not want to have it rendered because it takes so long to render 3) You want to query this layer 4) When you zoom out QGIS

Re: [Qgis-user] Labels visible for invisible features - Solved

2018-02-15 Per discussione Bernhard Ströbl
ailto:qgis-user-boun...@lists.osgeo.org] Im Auftrag von Bernhard Ströbl Gesendet: Dienstag, 13. Februar 2018 15:33 An: Qgis-user@lists.osgeo.org Betreff: [Qgis-user] Labels visible for invisible features Hi all, I have a point layer with a rule-based style based on some of the layer's attributes. The

[Qgis-user] Labels visible for invisible features

2018-02-13 Per discussione Bernhard Ströbl
Hi all, I have a point layer with a rule-based style based on some of the layer's attributes. The points are labelled using a label field. Now, when unticking a rule in the layer panel (i.e. making the features falling under this rule invisible) their labels are still rendered. Using a

Re: [Qgis-user] Labels visible for invisible features

2018-02-13 Per discussione Bernhard Ströbl
Hi again, I forgot to mention I have rules and subrules (3 levels of rules), apparently when using only rules in the top level all is working as expected. Bernhard Am 13.02.2018 um 15:33 schrieb Bernhard Ströbl: Hi all, I have a point layer with a rule-based style based on some

Re: [Qgis-user] splitting line at vertex

2017-09-27 Per discussione Bernhard Ströbl
I tried with a memory layer and it worked Bernhard Am 27.09.2017 um 09:42 schrieb Reginald: Hi Bernard, I think the problem is that it concerns a temporary drawing layer. There is something about this temporary layer that is different from a normal shape layer so that splitting at a vertex is

Re: [Qgis-user] splitting line at vertex

2017-09-27 Per discussione Bernhard Ströbl
Hi, it should work as you describe it (tried with 2.14.19 on Win 7) Questions: Is the line to be split a closed ring? Are project and layer CRS identical? Is there a selection in the layer and if yes is the line to be split contained in the selection? You could also try to make an additional

Re: [Qgis-user] QGIS Input Form for PostGIS

2017-08-09 Per discussione Bernhard Ströbl
Hi Jakob, although a bit late: Have you tried the plugin DataDrivenInputMask [1]? By using it there is no need to fiddle with QGIS relations, the drawback is that there is no undo. You have to properly define foreign keys and not null columns for the plugin to work. And, as Andreas already

[Qgis-user] Selecting ticked-off features

2017-07-14 Per discussione Bernhard Ströbl
Hi all, I experienced a strange behaviour of the selection tool: My point layer has a rule-based style. If I tick off certain rules to not display their members, the corresponding features get selected nonetheless if selection is done by a mouse rectangle. Even worse if the rule has a scale

Re: [Qgis-user] Generate Text Labels for USA National Map?

2017-07-06 Per discussione Bernhard Ströbl
Hi Jeshua, I cannot advice you in how you can achieve your goal :-( but would like to give some more answers and explanations Am 05.07.2017 um 23:41 schrieb Jeshua Lacock: On Jul 5, 2017, at 2:32 AM, Bernhard Ströbl <bernhard.stro...@jena.de> wrote: - I assume you want to have QGIS

Re: [Qgis-user] Loading Postgis FDW tables

2017-07-05 Per discussione Bernhard Ströbl
Hi Andreas, I have not used fdw for postgres, but use views based on dblink instead, which works perfectly in QGIS (2.14) My fdw tables from MySql and ORACLE are not shown either in QGIS when trying to load a layer. Bernhard Am 05.07.2017 um 14:35 schrieb Neumann, Andreas: Hi, I have

Re: [Qgis-user] Generate Text Labels for USA National Map?

2017-07-05 Per discussione Bernhard Ströbl
Hi, just some thoughts: - I assume you want to have QGIS create label texts for all your data in one go. If that is the case this is a misunderstanding of what labels are (in QGIS): QGIS creates (and places) the labels at run-time for the map extract currently on display. Labels thus are no

Re: [Qgis-user] relation_aggregate issue with virtual fields

2017-06-26 Per discussione Bernhard Ströbl
Hi Andreas, just a wild guess: Could it be related with the Umlaut "ä" Bernhard Am 26.06.2017 um 16:26 schrieb Neumann, Andreas: Hi, I use a relation_aggregate expression with the following syntax: relation_aggregate( relation:='Erdwärmesonden', aggregate:='sum',expression:="anzahl_sonden")

Re: [Qgis-user] Split features tool behavior

2017-06-20 Per discussione Bernhard Ströbl
Andreas Wicht: Hi Bernhard, perfect! Both works for me. A nice-to-have for the future would also be the utilization of the tracing function in case tracing is enabled. I can not assess how much work that would mean. cheers On 19 June 2017 at 18:05, Bernhard Ströbl <bernhard.stro...@jena.de>

Re: [Qgis-user] Split features tool behavior

2017-06-19 Per discussione Bernhard Ströbl
for causes on my end? On 19 June 2017 at 08:28, Bernhard Ströbl <bernhard.stro...@jena.de> wrote: Hi Andreas, the color is currently defined in the code. I did not find any setting to apply. AFAIK only selection color can be defined by the user, but it might be misleading if you have a selected f

Re: [Qgis-user] Split features tool behavior

2017-06-19 Per discussione Bernhard Ströbl
quot; part (when you choose which part should form the new feature) defined in the code or does it use a color, which is set in the QGIS settings? cheers Andreas On 15 June 2017 at 14:33, Bernhard Ströbl <bernhard.stro...@jena.de> wrote: FYI I implemented a new "Split features" to

Re: [Qgis-user] Split features tool behavior

2017-06-15 Per discussione Bernhard Ströbl
Am 02.06.2017 um 10:48 schrieb Bernhard Ströbl: Hi Andreas, --snip--- Chaining those 2 tools manually produces exactly the output I would expect. - I use "Split Parts" and receive the halves which form the invalid geometry - then I use "Split off one part and add it as a new

Re: [Qgis-user] Split features tool behavior

2017-06-02 Per discussione Bernhard Ströbl
Hi Andreas, --snip--- Chaining those 2 tools manually produces exactly the output I would expect. - I use "Split Parts" and receive the halves which form the invalid geometry - then I use "Split off one part and add it as a new feature" on the part which I want to separate - make sure the

Re: [Qgis-user] Split features tool behavior

2017-06-01 Per discussione Bernhard Ströbl
Hi Andreas, Am 31.05.2017 um 18:02 schrieb Andreas Wicht: Hi Bernhard, I dug deeper and it seems that I can always split the part once. Any further splitting of any part results in the invalid geometry error. https://issues.qgis.org/issues/12799 describes why. Exactly. So when you split

Re: [Qgis-user] Split features tool behavior

2017-05-31 Per discussione Bernhard Ströbl
Hi Andreas, my comments below Am 31.05.2017 um 13:04 schrieb Andreas Wicht: On 31 May 2017 at 12:23, Bernhard Ströbl <bernhard.stro...@jena.de> wrote: Hi Andreas, I dug deeper and it seems that I can always split the part once. Any further splitting of any part results in the invalid ge

Re: [Qgis-user] Split features tool behavior

2017-05-31 Per discussione Bernhard Ströbl
n and which is to become a new feature? You can merge any of the new halves with the original multipart feature in the next step. I use QGIS 2.14.15 on Ubuntu Bernhard Am 31.05.2017 um 11:15 schrieb Andreas Wicht: Hi Bernhard On 31 May 2017 at 10:53, Bernhard Ströbl <bernhard.stro...@jena.de>

Re: [Qgis-user] Split features tool behavior

2017-05-31 Per discussione Bernhard Ströbl
Andreas, when loading your shape file into a new project the project is set to EPSG:4326 because your data are in EPSG:4326 Your screenshots indicate that you are working in another projection. In EPSG:4326 split parts works flawlessly, when I use a projection I get the invalid geometries

Re: [Qgis-user] Split features tool behavior

2017-05-30 Per discussione Bernhard Ströbl
Hi Andreas, I have no problem with invalid geometries in my PostGIS test layers with split parts using QGIS 2.14.15 on Linux. Without having your data I cannot tell why yours are invalid. Anyway you might try DigitizingTools plugin which has a tool that deletes a part of a multi feature and

Re: [Qgis-user] Join multiple Linestrings to single Linestring

2017-04-20 Per discussione Bernhard Ströbl
Hi, just to clarify things (all info is AFAIK): 1) Processing: a) processing always creates a new layer as output b) Dissolve always creates multi features c) running multi-to-single afterwards creates single features for any connecting parts d) b) and c) can be put into a model to run them in

Re: [Qgis-user] PostGIS Query - DB Manager Not Recognizing Geom Column

2017-03-27 Per discussione Bernhard Ströbl
Hi, you need to explicitly state the geometry type and SRS in you view definition like this: CREATE OR REPLACE VIEW test.testbuff as SELECT gid, area_id, st_buffer(testshape.geom, 100)::geometry(Polygon,your_srs_code) as geom2 FROM test.testshape where testshape.area_id=100; could be Polygon

Re: [Qgis-user] Value relations in QGIS

2017-03-20 Per discussione Bernhard Ströbl
Hi Randal, copying projects is even simpler with the authentication. Just make sure that all users have the same id set for their PostgreSQL-connection. Another way to achieve what (I assume) you intend is to use my Plugin DataDrivenInputMask [1] that automatically creates combos for relations,

Re: [Qgis-user] FW: Simple methodology for user / data / map interactivity?

2017-02-27 Per discussione Bernhard Ströbl
Hi Graeme, as I wrote in my last mail you can set a filter for a layer. This does exacly what you describe. Changing the filter according to a changed selection in another layer and zooming to the new set sounds like a plugin, though. An non-plugin approach would be to create a view on the db

Re: [Qgis-user] Simple methodology for user / data / map interactivity?

2017-02-24 Per discussione Bernhard Ströbl
Hi Graeme, QGIS can do what you describe in your example out of the box. Workflow: 0) copy layer 1) select polygon in layer 2) use the spatial query plugin - select source from layer_copy - Where the feature intersects - reference features of layer (tick 1 selected polygon) - apply 3) zoom

Re: [Qgis-user] How to 'difference' in existing layer

2017-02-13 Per discussione Bernhard Ströbl
Hi Lene, try the DigitizingTools plugin [1]. The function that does just what you want is "Cut with polygon from another layer". Be aware that this tool is intended for use during digitizing: you can decide which features of layer A to cut and which features of layer B to use for cutting by

Re: [Qgis-user] How to force exact/korrekt editing polygon layer, (topological)

2017-01-11 Per discussione Bernhard Ströbl
Hi Bernd, QGIS can prevent gaps/intersections between polygons of the same layer, you only have to switch on the options. IMHO QGIS should not always prevent this because e.g. users may deliberately leave gaps. So how can you solve your problem? 1) You could teach your users what the options

Re: [Qgis-user] Joining polygons

2016-11-29 Per discussione Bernhard Ströbl
Hi, try using "Multipart to singleparts" afterwards Bernhard Am 29.11.2016 um 12:31 schrieb Joris Hintjens: Thanks for you input, but this does not work. It makes 1 multi polygon, not multiple polygons. It asks an attribute to separate the polygons, but I have no useful attributes that

Re: [Qgis-user] Using non ascii characters in PostgreSQL passwords

2016-11-24 Per discussione Bernhard Ströbl
Hi, I have some 150 users here connecting to PostGIS and did never have any such problems (Umlaute are allowed), I suspect an encoding problem (different encodings in QGIS and PostGIS) Bernhard Am 24.11.2016 um 08:44 schrieb timosiegward.alteme...@stadt.wolfsburg.de: Hi all, I getting

Re: [Qgis-user] Struggling with datum transformations and grid shift files

2016-10-04 Per discussione Bernhard Ströbl
Hi Andreas, I always put a 0 (zero) as destination datum. I cannot explain it but it works when transforming with a grid. If I leave the destination datum empty the new record is not saved. Bernhard Am 04.10.2016 um 12:58 schrieb Neumann, Andreas: Hi, I am struggling in QGIS 2x with datum

Re: [Qgis-user] Linear referencing in QGIS

2016-09-08 Per discussione Bernhard Ströbl
Bernhard, Il 08/09/2016 08:00, Bernhard Ströbl ha scritto: however I have some Python code here in operation that returns a "station" on a line by clicking on the line (or near it, as you won't hit the line without snapping to segment). A "station" is a position on the line,

Re: [Qgis-user] Linear referencing in QGIS

2016-09-08 Per discussione Bernhard Ströbl
Hi Régis, I do not quite understand what you mean with the m or z picker tool, however I have some Python code here in operation that returns a "station" on a line by clicking on the line (or near it, as you won't hit the line without snapping to segment). A "station" is a position on the

Re: [Qgis-user] QGIS Server error when printing to PDF

2016-08-25 Per discussione Bernhard Ströbl
Hi Dimitri, could you post the error that the server returns to the client? What happens when you hit the print button in the WebClient? What happens if you paste the print-URL directly into your browser? Do you have a program connected with pdf on your client computer? Bernhard Am

Re: [Qgis-user] Digitizing Tools Symbols lost

2016-06-28 Per discussione Bernhard Ströbl
check http://hub.qgis.org/issues/14825 Bernhard Am 28.06.2016 um 08:50 schrieb Juerg Lindauer: Hi After updating QGIS from 2.8.4 to 2.8.9 the symbols of Digitizing Tools are lost in the tool bar. You can use the functions, but the symbols are not showing. To reinstall the Digitizing Tools

Re: [Qgis-user] PlanZV für QGIS

2016-06-24 Per discussione Bernhard Ströbl
http://qgis.de/doku.php?id=site:darstellung Bernhard Am 24.06.2016 um 10:19 schrieb Elstermann, Mike: Hallo zusammen, weil wohl eher in Deutschland von Bedeutung, diese Anfrage auch auf deutsch. Kennt jemand eine Quelle für die Umsetzung der PlanZV im FNP-Bereich. Gesucht sind Linie-, Punkt-

Re: [Qgis-user] (poor) performance loading postgis layers in qgis-server 2.8 ltr + postgis 2.1 + lizmap web-client

2016-06-24 Per discussione Bernhard Ströbl
I am just wondering: Why is the "big" table only twenty rows? Is this a multi(polygon?) table? If yes and the parts of each multipolygon are all over the place then this is your problem. QGIS has to load all parts although only a couple of them are visible at the moment. And if it happens that

Re: [Qgis-user] FW: Cannot split feature in a multipolygon PostGIS feature type in QGIS

2016-06-23 Per discussione Bernhard Ströbl
Hi Chris, I assume you use the interactive scissor tool? If I use this to split a part of a two-part multipolygon feature (one part has a hole in it) I end up with three data sets: 1) northern half of part 1, 2) southern half of part 1 3) part 2 This is QGIS 2.14.3, PostGIS 2.2 Be sure that

Re: [Qgis-user] Splitting Polygons

2016-06-22 Per discussione Bernhard Ströbl
Hi, AFAIK processing output is always a new layer. If you want to split certain features within the layer check DigitizingTools plugin. Bernhard Am 22.06.2016 um 09:38 schrieb Springfield Harrison: Hello List, Is there a geo-processing tool to split polygon features in one layer using

Re: [Qgis-user] Very long sql in postgres layer definition

2016-05-26 Per discussione Bernhard Ströbl
as the user requires. Filtering needs to happen on the sql server, the dataset is far too large to filter directly within qgis (roughly 100mil rows). Sam. On Thu, May 26, 2016 at 4:20 PM, Bernhard Ströbl <bernhard.stro...@jena.de> wrote: Maybe it's easier to create a view on the DB an

Re: [Qgis-user] Very long sql in postgres layer definition

2016-05-26 Per discussione Bernhard Ströbl
Maybe it's easier to create a view on the DB and load that? Bernhard Am 26.05.2016 um 09:52 schrieb Samuel Ingarfield: Hi Bernhard; I can load the layer using an identical query in the DB manager sql window. Yes, r.id is a unique key. Sam. On Thu, May 26, 2016 at 3:37 PM, Bernhard Ströbl

Re: [Qgis-user] Very long sql in postgres layer definition

2016-05-26 Per discussione Bernhard Ströbl
Can you load it via the "add PostGIS layer" button? Is r.id a suitable key (unique)? Bernhard Am 26.05.2016 um 09:33 schrieb Samuel Ingarfield: Hi All, I'm trying to load a postigs layer via python which is defined by a very long sql query. It seems that Qgis is truncating the query (which

Re: [Qgis-user] Performance rendering PostGIS-Data

2016-05-24 Per discussione Bernhard Ströbl
Hi Benjamin, just a note about indices: if you index e.g. "road class" which only has 5 classes the index may be counterproductive, because Postgres reads the index and then uses itx to decide which datasets to read and has to read most of them anyways. It might be faster to read all datasets

Re: [Qgis-user] QGIS in production environment

2016-05-23 Per discussione Bernhard Ströbl
Hi, we have been running QGIS together with PostGIS in a municipal GIS (city, some 10 inhabitants) since at least 7 years. We run QGIS server on the intranet and, together with QGIS WebClient, on the internet [1]. We use LTS QGIS 64bit on Win7, servers are on Ubuntu. We started with

Re: [Qgis-user] QGIS Server - Export to PDF graphics

2016-04-29 Per discussione Bernhard Ströbl
just an idea: Do not load the images from the file system but from a web server via URL (can be the same server QGIS server is running on) Bernhard Am 29.04.2016 um 09:49 schrieb burghardt.scho...@stadt.wolfsburg.de: Hi all, my System: Ubuntu 14.04, qgis-server 2.14.1 I've created a print

Re: [Qgis-user] Project file data loss

2016-04-26 Per discussione Bernhard Ströbl
Hi Pierre-Marie, what do you mean by "update virtual layers"? On the other hand I definitely did not modify the data structure (e.g. add or rename fields) of the layers involved in the virtual layers. Bernhard Am 26.04.2016 um 22:48 schrieb Pierre-Marie Le Dantec: Hi, I encoutered the same

Re: [Qgis-user] Project file data loss

2016-04-26 Per discussione Bernhard Ströbl
/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user -- Bernhard Ströbl Anwendungsbetreuer GIS Kommunale Immobilien Jena Am Anger 26 07743 Jena Tel.: 03641 49- 5190 E-Mail: bernhard.stro...@jena.de Internet: www.kij.de Kommunale Immobilien Jena Eigenbetrieb der

Re: [Qgis-user] Project file data loss

2016-04-26 Per discussione Bernhard Ströbl
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 -- Bernhard Ströbl Anwendungsbetreuer GIS Kommunale Immobilien Jena Am Ange

Re: [Qgis-user] Preserving joined fields in Processing outputs

2016-04-11 Per discussione Bernhard Ströbl
Just my two cents: +1 to leave it as it is reasoning: I would always expect the current behaviour; a virtual field is - well - virtual, I can redo it after processing (BTW it would be good if it was savable in a qml file) and I can join to the result, too. No need to carry unnecessary fields

Re: [Qgis-user] Reading CAD documents in QGIS

2016-03-15 Per discussione Bernhard Ströbl
Hi, just for your information: Bentley and AutoCAD exchanged their libs a couple of years ago, so Bentley products read dwg/dxf with the native AutoCAD lib (all AFAIK). Therefore there should be no need for dgn (V8) support. AFAIK there exists only proprietary libs (Bentley) for

Re: [Qgis-user] An issue splitting a shape

2016-03-03 Per discussione Bernhard Ströbl
Andrea Peri: Hi, I say there are duplicate node because say me the validate geometry of qgis. I try to splite using the commando of qgis named "split" available in the toolbar. Thx, A. Il 03 mar 2016 1:24 PM, "Bernhard Ströbl" <bernhard.stro...@jena.de> ha scritto: Hi And

Re: [Qgis-user] An issue splitting a shape

2016-03-03 Per discussione Bernhard Ströbl
Hi Andrea, IMHO duplicate nodes are a geometry error and I would generally not expect any tool to flawlessly work with such geometries. However I do not see any duplicate nodes in the attached shape. Where are they supposed to be and which split tool are you using, the scissors? Bernhard

Re: [Qgis-user] Relations capabilities

2016-02-23 Per discussione Bernhard Ströbl
Hi Brent, not sure if I uttered that before, so (if I did) my apologies for repeating myself. If you are entirely on PostgreSQL you may try my Plugin DataDrivenInputMask [1]. If you have properly defined foreign keys you can 1) see the species caught in one station in a list [2] 2) search

Re: [Qgis-user] Repairing Topology Errors

2016-02-08 Per discussione Bernhard Ströbl
Hi, when looking at topology errors I can imagine three types 1) borders are not identical, i.e. you missed one vertex during digitizing 2) overlaps 3) gaps ad 1) in my experience it is easy to miss a vertex when digitizing along an existing edge, the auto-trace plugin may help in this respect

Re: [Qgis-user] [QGis 2.10]Error while saving shape file

2016-02-08 Per discussione Bernhard Ströbl
hi Pierre, if modifying a vertex takes that long I suggest you unload all(!) plugins, some are known to slow down QGIS. Try if that enhances speed. If yes reload you plugins one after another and see if you can identify the one causing the trouble. Bernhard Am 08.02.2016 um 14:34 schrieb

Re: [Qgis-user] Including Images in Print Composer Templates

2016-01-28 Per discussione Bernhard Ströbl
Hi, this is not an answer to your question but what I do is to load images with an URL pointing to one of our internal web servers. This works perfectly in templates being loaded on different machines with different OS, too. Bernhard Am 27.01.2016 um 00:25 schrieb David A. Riggs: Hi all,

Re: [Qgis-user] Swap atributes

2016-01-14 Per discussione Bernhard Ströbl
Hi Christoph, the latest version of the DigitizingTools extension [1] contains a function to exchange the geometry between two selected features in the active edit layer. Bernhard [1] http://plugins.qgis.org/plugins/DigitizingTools/ Am 14.01.2016 um 11:00 schrieb Christoph Schumacher

Re: [Qgis-user] Styles and PostgreSQL

2016-01-14 Per discussione Bernhard Ströbl
Hi, the relation is public.layer_styles. The problem is the xml fields. I once noted for myself to SET XML OPTION DOCUMENT; prior to importing the dump. Didn't do it for a while so I am not sure if it works. Another option is to dump layer_styles as plain SQL and then import it into the

  1   2   3   4   >