[Qgis-user] Add a shape within QGIS to a record already in a database layer/table (SQL SERVER)
Hi everyone, Is there a way to add a shape (eg polygon) to a record in a database table added to QGIS, where the record was originally created in a database form elsewhere. (probably makes more sense as an example). In my SQL Server database form I create a new record for a mine site in a table that has a geography field. I then go into QGIS, load the layer/table via the SQL Server connection. I now want to create a polygon shape associated with the new mine site record I created. Typically I would just edit the existing shape associated with the record, but since there is no shape associated with this record, it doesnt appear there is a way to create a shape to associate to an existing record. Is this possible (all of my attempts say no). Is there a better way for this workflow to happen. I could create a child table to house the geometry and then use a key relationship to associate it to the record but I want as few tables as possible as this adds tables increases complexity for novice users. Thoughts? C -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Add-a-shape-within-QGIS-to-a-record-already-in-a-database-layer-table-SQL-SERVER-tp5146218.html Sent from the Quantum GIS - User mailing list archive at Nabble.com. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Add a shape within QGIS to a record already in a database layer/table (SQL SERVER)
Hi, not sure about MySql (I use PostgreSQL). How if you define a default polygon that is used upon inserting a new dataset with null polygon (needs a trigger maybe). You can later change that polygon in QGIS. IMHO the better way would be to create the dataset from within QGIS by digitizing the new polygon, though. Bernhard Am 17.06.2014 08:54, schrieb Carlos da Ponte: Hi everyone, Is there a way to add a shape (eg polygon) to a record in a database table added to QGIS, where the record was originally created in a database form elsewhere. (probably makes more sense as an example). In my SQL Server database form I create a new record for a mine site in a table that has a geography field. I then go into QGIS, load the layer/table via the SQL Server connection. I now want to create a polygon shape associated with the new mine site record I created. Typically I would just edit the existing shape associated with the record, but since there is no shape associated with this record, it doesnt appear there is a way to create a shape to associate to an existing record. Is this possible (all of my attempts say no). Is there a better way for this workflow to happen. I could create a child table to house the geometry and then use a key relationship to associate it to the record but I want as few tables as possible as this adds tables increases complexity for novice users. Thoughts? C -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Add-a-shape-within-QGIS-to-a-record-already-in-a-database-layer-table-SQL-SERVER-tp5146218.html Sent from the Quantum GIS - User mailing list archive at Nabble.com. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user __ Information from ESET Mail Security, version of virus signature database 9956 (20140617) __ The message was checked by ESET Mail Security. http://www.eset.com __ Information from ESET Mail Security, version of virus signature database 9956 (20140617) __ The message was checked by ESET Mail Security. http://www.eset.com ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Add a shape within QGIS to a record already in a database layer/table (SQL SERVER)
You can create a SQLServer based insert trigger, that checks the new record. If the record doesn't contain a geometry object (geometry is null) it can create a dummy geometry before inserting the record in the database, for example a polygon square. The position of the square should be determined by some other information in the new record, so every dummy square has an unique position. Regards Bo Victor Thomsen Aestas-GIS Denmark Den 17-06-2014 09:09, Bernhard Ströbl skrev: Hi, not sure about MySql (I use PostgreSQL). How if you define a default polygon that is used upon inserting a new dataset with null polygon (needs a trigger maybe). You can later change that polygon in QGIS. IMHO the better way would be to create the dataset from within QGIS by digitizing the new polygon, though. Bernhard Am 17.06.2014 08:54, schrieb Carlos da Ponte: Hi everyone, Is there a way to add a shape (eg polygon) to a record in a database table added to QGIS, where the record was originally created in a database form elsewhere. (probably makes more sense as an example). In my SQL Server database form I create a new record for a mine site in a table that has a geography field. I then go into QGIS, load the layer/table via the SQL Server connection. I now want to create a polygon shape associated with the new mine site record I created. Typically I would just edit the existing shape associated with the record, but since there is no shape associated with this record, it doesnt appear there is a way to create a shape to associate to an existing record. Is this possible (all of my attempts say no). Is there a better way for this workflow to happen. I could create a child table to house the geometry and then use a key relationship to associate it to the record but I want as few tables as possible as this adds tables increases complexity for novice users. Thoughts? C -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Add-a-shape-within-QGIS-to-a-record-already-in-a-database-layer-table-SQL-SERVER-tp5146218.html Sent from the Quantum GIS - User mailing list archive at Nabble.com. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user __ Information from ESET Mail Security, version of virus signature database 9956 (20140617) __ The message was checked by ESET Mail Security. http://www.eset.com __ Information from ESET Mail Security, version of virus signature database 9956 (20140617) __ The message was checked by ESET Mail Security. http://www.eset.com ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Add a shape within QGIS to a record already in a database layer/table (SQL SERVER)
I have seen this case scenario before, and I think this can be a good Plugin Idea. something that would allow to: - Add a geometry to a record\feature without any geometry (must have a geometry column already); - Replace an existing geometry (having a dummy geom at some time you will want to give a proper one); - remove the geometry from the record\feature; Alexandre Neto On Tue, Jun 17, 2014 at 9:53 AM, Bo Victor Thomsen bo.victor.thom...@gmail.com wrote: You can create a SQLServer based insert trigger, that checks the new record. If the record doesn't contain a geometry object (geometry is null) it can create a dummy geometry before inserting the record in the database, for example a polygon square. The position of the square should be determined by some other information in the new record, so every dummy square has an unique position. Regards Bo Victor Thomsen Aestas-GIS Denmark Den 17-06-2014 09:09, Bernhard Ströbl skrev: Hi, not sure about MySql (I use PostgreSQL). How if you define a default polygon that is used upon inserting a new dataset with null polygon (needs a trigger maybe). You can later change that polygon in QGIS. IMHO the better way would be to create the dataset from within QGIS by digitizing the new polygon, though. Bernhard Am 17.06.2014 08:54, schrieb Carlos da Ponte: Hi everyone, Is there a way to add a shape (eg polygon) to a record in a database table added to QGIS, where the record was originally created in a database form elsewhere. (probably makes more sense as an example). In my SQL Server database form I create a new record for a mine site in a table that has a geography field. I then go into QGIS, load the layer/table via the SQL Server connection. I now want to create a polygon shape associated with the new mine site record I created. Typically I would just edit the existing shape associated with the record, but since there is no shape associated with this record, it doesnt appear there is a way to create a shape to associate to an existing record. Is this possible (all of my attempts say no). Is there a better way for this workflow to happen. I could create a child table to house the geometry and then use a key relationship to associate it to the record but I want as few tables as possible as this adds tables increases complexity for novice users. Thoughts? C -- View this message in context: http://osgeo-org.1560.x6. nabble.com/Add-a-shape-within-QGIS-to-a-record-already-in-a- database-layer-table-SQL-SERVER-tp5146218.html Sent from the Quantum GIS - User mailing list archive at Nabble.com. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user __ Information from ESET Mail Security, version of virus signature database 9956 (20140617) __ The message was checked by ESET Mail Security. http://www.eset.com __ Information from ESET Mail Security, version of virus signature database 9956 (20140617) __ The message was checked by ESET Mail Security. http://www.eset.com ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Clipping tool in v2.2 valmiera Mac version
How is it not working? are there any error messages? Was it working in a previous version for you? On Jun 16, 2014, at 7:12 AM, neumann t. (tn8g13) tn8...@soton.ac.uk wrote: Hi all, I was wondering if anyone else faced the problem with the clipping tool doesn't work on the latest version(valmiera 2.2 on Mac). And if someone has a solution he might share it? Cheers Tim ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user - William Kyngesburye kyngchaos*at*kyngchaos*dot*com http://www.kyngchaos.com/ Mon Dieu! but they are all alike. Cheating, murdering, lying, fighting, and all for things that the beasts of the jungle would not deign to possess - money to purchase the effeminate pleasures of weaklings. And yet withal bound down by silly customs that make them slaves to their unhappy lot while firm in the belief that they be the lords of creation enjoying the only real pleasures of existence - the wisdom of Tarzan ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Snnapping options
Hi!!! I want to make a polygon, which should be attached to another that is coterminous. When setting options Snnapping options, and try to draw the polygon, the program tells me the following error: The feature cannot be added because it's geometry collapsed due to intersection avoidance What can I do?? Thanks so much!!! Kiss, Mariana ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] QGIS-Merge or creat virtual raster files without losing definition?
I am new to QGIS and relatively new to GIS (so please be aware I am not that familiar with jargon). I am trying to merge several tiff files as either a virtual raster or a simple merge. Whichever way I try the resulting display appears to lose definition (even just a couple of the files). I have tried to set the options to no compression (merge rasters), and resolution set at highest for creating virtual raster, but street names and place names still become too pixillated to read properly. This does not happen if I load all the files I wish to merge individually, but obviously I would rather work with the merged or virtual files. I am using QGIS 2.2.0 on a 2.5 GHz Intel Core i5 Mac, OSX 10.9.3. Would appreciate some help, please. Mick ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Move Point with buffer
Hello, Is there a way to do the following: I have a point layer. I create a buffer layer around these points. Problem: How do I move the buffer together if I want to move the point? Thanks for any tips Joris HINTJENS ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Clipping tool in v2.2 valmiera Mac version
I don't think the CRS matters. Are you clipping a raster or vector? Clipping to another shapefile or just a box? I've only clipped rasters, and only to a box not a shapefile. Maybe others on the list will have insights. Does it give you any message when it fails? On Jun 17, 2014, at 9:34 AM, neumann t. (tn8g13) tn8...@soton.ac.uk wrote: Ok it worked on another shapefile, but I downloaded an european coastline from the EU Environmenr Agency which comes in EPSG:3035 - ETRS89 / ETRS-LAEA crs. And apparently clipping doesn't work in this system. Maybe that helps for improvement. Or is it supposed not to work in this system? Kind regards T. On Jun 17, 2014, at 9:29 AM, neumann t. (tn8g13) tn8...@soton.ac.uk wrote: I deleted and reinstalled it again, and now it's working! Must have done something wrong while the installation. Thank you anyways. On 17 Jun 2014, at 14:26, William Kyngesburye wokl...@kyngchaos.com wrote: How is it not working? are there any error messages? Was it working in a previous version for you? On Jun 16, 2014, at 7:12 AM, neumann t. (tn8g13) tn8...@soton.ac.uk wrote: Hi all, I was wondering if anyone else faced the problem with the clipping tool doesn't work on the latest version(valmiera 2.2 on Mac). And if someone has a solution he might share it? Cheers Tim ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user - William Kyngesburye kyngchaos*at*kyngchaos*dot*com http://www.kyngchaos.com/ Mon Dieu! but they are all alike. Cheating, murdering, lying, fighting, and all for things that the beasts of the jungle would not deign to possess - money to purchase the effeminate pleasures of weaklings. And yet withal bound down by silly customs that make them slaves to their unhappy lot while firm in the belief that they be the lords of creation enjoying the only real pleasures of existence - the wisdom of Tarzan - William Kyngesburye kyngchaos*at*kyngchaos*dot*com http://www.kyngchaos.com/ We are at war with them. Neither in hatred nor revenge and with no particular pleasure I shall kill every ___ I can until the war is over. That is my duty. Don't you even hate 'em? What good would it do if I did? If all the many millions of people of the allied nations devoted an entire year exclusively to hating the it wouldn't kill one ___ nor shorten the war one day. Ha, ha And it might give 'em all stomach ulcers. - Tarzan, on war ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Snnapping options
Hi Mariana, One of the polygons you are using for intersection has a bad geometry. Try to use Topolygychecker http://www.youtube.com/watch?v=huhkTZkoKC8 Then delete the bad polygon. Regards Lene Fischer Associate Professor Department of Geosciences and Natural Resource Management University of Copenhagen MOB +45 40115084 l...@ign.ku.dkmailto:l...@ign.ku.dk [SCIENCE_bomaerke_UK] Fra: qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] På vegne af Mariana Buzzi Sendt: 17. juni 2014 15:32 Til: qgis-user@lists.osgeo.org Emne: [Qgis-user] Snnapping options Hi!!! I want to make a polygon, which should be attached to another that is coterminous. When setting options Snnapping options, and try to draw the polygon, the program tells me the following error: The feature cannot be added because it's geometry collapsed due to intersection avoidance What can I do?? Thanks so much!!! Kiss, Mariana ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Unable to open OGR .vrt file
Am 17.06.2014 00:46, schrieb Andrea Acinelli: Operating System: OS X 10.9.3 QGIS 2.2.0-9 distributed by KyngChaos Postgres 9.3.4 PostGIS 2.1.2 distributed by Postgres.app Hi, When trying to open a .vrt file referencing a .csv with 'lat' and ‘ ong’ in two separate columns I get the following error message: ‘Invalid Data Source: /Users/Andrea/postgis_cookbook/Chapter 1/global_24h.vrt is not a valid or recognized data source’. take a close look at the line GeometryField encoding=PointFromColumns x=longitude y=latitude”/ The last quotation is not the same as the others. That's why it fails for me. HTH, André Joost ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] create polygon: underlying image is covered
I want to vectorize land forms from an ortho image, so I make a new polygon shape file and create new objects inside it. When I follow the outline of the land form, I have the problem that the new polygon covers the underlying layer (it is red and only slightly transparent), so I cant see the structures of the ortho image anymore. Is there a way to create new polygons, but only have the border of the polygon drawn while creating it? I couldnt find such an option in QGIS. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] SAGA toolbox
Greetings, I have SAGA installed and apparently enabled when I check ProcessingOptions and ConfigurationsProviders. However, I get the error msg Missing dependency.This algorithm cannot be run :-( This algorithm requires SAGA to be run.Unfortunately, it seems that SAGA is not installed in your system, or it is not correctly configured to be used from QGIS when I try to use the Terrain Analysis - Channels tool. Can someone tell me what I am doing wrong, please? John ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Leading and Kerning Options in Composer?
I can see that there are implementations of these functions (letter spacing and line spacing) in labelling through the properties of a layer in the upcoming QGIS, and I was wondering if the same functionality was being looked at for labels in composer? ___ Johanna Botman GIS / Assets Officer Griffith City Council Ph: 02 6962 8168 Please consider the environment before printing this email notice. This e-mail, together with any attachments, is for the exclusive and confidential use of the addressee(s. Confidentiality is not waived if you are not the intended recipient. Any other distribution, use of, or reproduction without prior written consent is strictly prohibited. Views expressed in this e-mail are those of the individual, except where specifically stated otherwise. If this e-mail has been sent to you in error, please delete the e-mail completely and immediately from your system. Although reasonable precautions are taken, Griffith City Council does not warrant or guarantee this message to be free of errors, interference,viruses or similar malicious code and does not accept liability for any consequences to the recipient opening or using this email or attachments. This email was scanned and cleared by NetIQ MailMarshal and Norman AV - ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] create polygon: underlying image is covered
Am 17.06.2014 23:19, schrieb Thomas Recknagel: I want to vectorize land forms from an ortho image, so I make a new polygon shape file and create new objects inside it. When I follow the outline of the land form, I have the problem that the new polygon covers the underlying layer (it is red and only slightly transparent), so I cant see the structures of the ortho image anymore. Is there a way to create new polygons, but only have the border of the polygon drawn while creating it? I couldnt find such an option in QGIS. Settings - Options - Digitizing You can change the colour of the rubber line. I have changed the alpha channel to 100. HTH, André Joost ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Move Point with buffer
On 18 June 2014 12:24, Stefan Sylla stefansy...@gmx.de wrote: Basically you can accomplish that by importing your point layer to a Postgis database (using th SPIT plugin in QGIS) Don't use the SPIT plugin - it's old and unmaintained. Use either dbManager or the Import into PostGIS algorithm in processing. Nyall ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user