[Qgis-user] QGIS and Shellshock

2014-09-25 Thread Steven Campbell
Hi all Does anyone know if QGIS is affected at all by the bash bug? Thanks Steve Steve Campbell | GIS Manager Corporate Strategy and Communications Borough of Poole | Civic Centre | Poole BH15 2RU Tel: 01202 633 362 Email: s.campb...@poole.gov.ukmailto:s.campb...@poole.gov.uk

Re: [Qgis-user] QGIS and Shellshock

2014-09-25 Thread Steven Campbell
Hi Saber It returns the following two lines of text. Vulnerable This is a test Then returns to C:\ Steve From: Saber Razmjooei [mailto:saber.razmjo...@lutraconsulting.co.uk] Sent: 25 September 2014 15:40 To: Steven Campbell; qgis-user@lists.osgeo.org Subject: RE: [Qgis-user] QGIS

[Qgis-user] displaying a layer from SQL

2014-06-02 Thread Steven Campbell
Hi Does anyone know if it is possible to a layer in QGIS, coming from a SQL database, that contains both point and polygon data? At the minute it brings in all the data, but only displays the polygon data, not the point data. Any help would be greatly appreciated. Thanks Steve Steve

[Qgis-user] Citrix and QGIS

2014-01-31 Thread Steven Campbell
Hi I was wondering if anyone had successfully deployed QGIS via a Citrix (Thin Client) environment and could answer the following questions: 1)Is it possible to compile an installer package that not only installs qgis, but installs the required plugins too? 2)Can you get QGIS to

[Qgis-user] Counting the sum of points in a polygon

2013-11-27 Thread Steven Campbell
Hi all Can anyone tell me how it is possible to count up the total number of points, or sum up a value against each point within a boundary? For example I have seven points, in a polygon, each point has an attribute of differing numbers and I want to assign the sum value of this attribute

Re: [Qgis-user] Counting the sum of points in a polygon

2013-11-27 Thread Steven Campbell
Hi Andreas Is this the same as the basic statistics tool that you can find in the Vector tools? I can see the plugin is already loaded but cannot see any Zonal Stats button/option anywhere. I'm using the latest weekly build at the minute. Thanks Steve

[Qgis-user] QGIS on Thin Client?

2013-10-10 Thread Steven Campbell
Hi Has anyone had any success of getting QGIS to work on Thin Client? I've been asked to investigate this with my ICT department as they are wanting to minimise the number of FAT client install of software. We have Citrix running windows 7, does anyone have any success or horror stories of

[Qgis-user] Selecting individual polygons from multiple duplicates

2013-09-10 Thread Steven Campbell
Hi I have a layer that has nine polygons that are identical, I need to delete eight of them, but I can't seem to see a way of easily identifying the one polygon I need to keep (i.e. QGIS only allows me to click on the top polygon, not scroll through the underlying polygons). Any suggestions

Re: [Qgis-user] Raster in to PostGIS

2013-08-09 Thread Steven Campbell
Loader and TIleMill to create my own styled cached mapping of the Ordnance Survey Vector/GML Products) Steve From: Jonathan Moules [mailto:jonathanmou...@warwickshire.gov.uk] Sent: 09 August 2013 13:36 To: Steven Campbell Cc: qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] Raster in to PostGIS

[Qgis-user] Raster in to PostGIS

2013-08-08 Thread Steven Campbell
Hi I was wondering if anyone knew of a useful guide that shows me how to add Raster files in to postGIS. I'd ideally like to load a significant number in one go (so a directory of files rather than one at a time). Thanks Steve ___ Qgis-user mailing

[Qgis-user] Print Composer Projects

2013-08-05 Thread Steven Campbell
Hi, Can anyone tell me where the Print Composer projects are being stored? I'm probably being stupid but I can't seem to identify where QGIS is storing them (or at least I can't seem to find a way to specify where I want to store a Print Composer Project!) Thanks Steve Steve

[Qgis-user] Identifying day of week question

2013-07-30 Thread Steven Campbell
Hi I have a dataset that has the date column within it, does anyone know of a way to identify the day of the week that the date relates to so if 01-01-2013 is a Tuesday I want to create an extra column to display the day name. Any help would be greatly appreciated Thanks! Steve

[Qgis-user] Points on line query

2013-07-30 Thread Steven Campbell
Hello Is there a way to calculate the total sum of points that intersect/overlap a particular line - so I can add a column to my line dataset that tells me x number of points intersect/overlap this particular line. Thanks Steve Steve Campbell GIS Manager Corporate Strategy and

Re: [Qgis-user] Points on line query

2013-07-30 Thread Steven Campbell
That is something I did not know! Thanks for the SQL I will give it a try Thanks again Steve From: Nathan Woodrow [mailto:madman...@gmail.com] Sent: 30 July 2013 13:07 To: Steven Campbell Cc: qgis-user Subject: Re: [Qgis-user] Points on line query SpatialLite is built into QGIS

[Qgis-user] QGIS Spatial Query

2013-07-25 Thread Steven Campbell
I was wondering if I could do the following within QGIS: I want to update a column in my point layer with the attribute information from a specific column in a polygon layer - so I have a layer of postcodes and I want to give create a column, call it School Catchment and I want to populate

Re: [Qgis-user] QGIS Spatial Query - Solution Found

2013-07-25 Thread Steven Campbell
Hi Thanks for answer, however I have discovered the Point sampling Tool within QGIS that does exactly what I need it to do, It lets me pick specific columns from multiple tables in one process!!! Perfect to create a postcode to boundary lookup file. Thanks again Steve Steve

Re: [Qgis-user] OS Mastermap, SQL Server and QGIS

2013-07-12 Thread Steven Campbell
again Steve From: Jonathan Moules [mailto:jonathanmou...@warwickshire.gov.uk] Sent: 12 July 2013 11:27 To: Steven Campbell Cc: Nathan Woodrow; qgis-user Subject: Re: [Qgis-user] OS Mastermap, SQL Server and QGIS Hi Steve, As an aside, do you know if the Oracle connector uses

Re: [Qgis-user] OS Mastermap, SQL Server and QGIS

2013-07-11 Thread Steven Campbell
very slow. As an aside, do you know if the Oracle connector uses the user_sdo_geom_metadata table to identify the SRID and extents of the tables? Thanks again! Steve From: Nathan Woodrow [mailto:madman...@gmail.com] Sent: 02 July 2013 04:02 To: Steven Campbell Cc: qgis-user Subject: Re

Re: [Qgis-user] OS Mastermap, SQL Server and QGIS

2013-07-05 Thread Steven Campbell
checking up to see how you got on with the speed ups I added for MS SQL layers? - Nathan On Wed, Jul 3, 2013 at 8:42 AM, Nathan Woodrow madman...@gmail.com wrote: Hey Steven, Yes it will. Regards, Nathan On Wed, Jul 3, 2013 at 12:45 AM, Steven Campbell s.campb...@poole.gov.ukwrote: Hi

Re: [Qgis-user] OS Mastermap, SQL Server and QGIS

2013-07-02 Thread Steven Campbell
Hi Nathan Many Thanks Will this be available in the nightly builds of QGIS? Thanks Steve From: Nathan Woodrow [mailto:madman...@gmail.com] Sent: 02 July 2013 04:02 To: Steven Campbell Cc: qgis-user Subject: Re: [Qgis-user] OS Mastermap, SQL Server and QGIS Hey Steven

Re: [Qgis-user] OS Mastermap, SQL Server and QGIS

2013-07-01 Thread Steven Campbell
Hi Nathan Thanks for this, I've added the table and will see how I get on. Thanks again Steve. From: Nathan Woodrow [mailto:madman...@gmail.com] Sent: 01 July 2013 11:23 To: Steven Campbell Cc: qgis-user Subject: Re: [Qgis-user] OS Mastermap, SQL Server and QGIS Hey Steven

[Qgis-user] OS Mastermap, SQL Server and QGIS

2013-06-28 Thread Steven Campbell
Hi Does anyone else have significant time delays when trying to open large datasets from a SQL database in QGIS? I have uploaded my Ordnance survey MasterMap data (coverage is the size of an average English County) and although the initial connection to identify the table is very quick, the

Re: [Qgis-user] Displaying Text from OS Mastermap

2013-05-14 Thread Steven Campbell
part of my SQL database (i.e. - I haven't had to split out points, lines and polygons from my database). Steve From: Jonathan Moules [mailto:jonathanmou...@warwickshire.gov.uk] Sent: 10 May 2013 11:13 To: Steven Campbell Cc: qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] Displaying

[Qgis-user] Address Database connection/Search

2013-05-14 Thread Steven Campbell
Hi I am wondering if anyone can help me with the following. We have our address database in a SQL server. I would like to access it in two ways: 1)As a Vector dataset - I have no geometry column, but each address has an Easting and Northing 2)As a layer to search against - is

[Qgis-user] Displaying Text from OS Mastermap

2013-05-09 Thread Steven Campbell
Hi I was wondering if anyone could help. I have my OS Mastermap data stored in a SQL database and whilst I can style the polygons and lines, I am struggling with the text. For some reason, when I use the label option within QGIS, it is displaying the text twice, even though there is only one

[Qgis-user] QGIS and SQL Server 2008

2013-04-10 Thread Steven Campbell
Hi I hope someone can help, I have a layer in a sql database that contains both polygons and multi-polygons. I am trying to bring this in to QGIS. I can connect without a problem but only a few of the polygons are appearing, can anyone help explain where I might be going wrong? I'm pretty new