Re: [Qgis-user] Selecting polygons on attribute

2012-07-24 Thread Andre Joost
Am 24.07.12 14:10, schrieb Zoltan Szecsei: The selects I have tried are: sq21code = C016* and also tried using IN Any ideas what I am doing wrong and what I should try next? The * used as a wildcard in the Windows world is not used in SQL statements. You should try the LIKE operator:

Re: [Qgis-user] Selecting polygons on attribute

2012-07-24 Thread Micha Silver
On 07/24/2012 03:10 PM, Zoltan Szecsei wrote: Hi, I have a SHP file of some 1.1m polygons, of which I need to select about half of them, and save them as a separate SHP file. The trouble is when I select either via a Query, or via the TABLE

Re: [Qgis-user] Selecting polygons on attribute - Trying OGR

2012-07-24 Thread Zoltan Szecsei
On 2012/07/24 16:41, Micha Silver wrote: On 07/24/2012 03:10 PM, Zoltan Szecsei wrote: Hi, I have a SHP file of some 1.1m polygons, of which I need to select about half of them, and save them as a separate SHP file. The trouble is when I select either via a Query, or via the TABLE using the

Re: [Qgis-user] Selecting polygons on attribute - Trying OGR

2012-07-24 Thread Micha Silver
On 07/24/2012 05:52 PM, Zoltan Szecsei wrote: On 2012/07/24 16:41, Micha Silver wrote: On 07/24/2012 03:10 PM, Zoltan Szecsei wrote: Hi, I have a SHP file of some 1.1m polygons, of which I need to

Re: [Qgis-user] Selecting polygons on attribute - Trying OGR

2012-07-24 Thread Zoltan Szecsei
On 2012/07/24 17:07, Micha Silver wrote: On 07/24/2012 05:52 PM, Zoltan Szecsei wrote: On 2012/07/24 16:41, Micha Silver wrote: On 07/24/2012 03:10 PM, Zoltan Szecsei wrote: Hi, I have a SHP file of some 1.1m polygons, of which I need to select about half of them, and save them as a separate

Re: [Qgis-user] Selecting polygons on attribute - Trying OGR

2012-07-24 Thread Andre Joost
Am 24.07.2012 17:07, schrieb Micha Silver: This worked for me (on a *very* small shapefile. Some of the Name attributes where rest 1, rest 2 etc): ogr2ogr -f ESRI Shapefile -where Name LIKE 'Rest%' waypoints3.shp waypoints.shp Using Windows 7 cmd box, the % will get misinterpreted. But

Re: [Qgis-user] Selecting polygons on attribute - Trying OGR

2012-07-24 Thread Micha Silver
On 07/24/2012 06:11 PM, Zoltan Szecsei wrote: On 2012/07/24 17:07, Micha Silver wrote: On 07/24/2012 05:52 PM, Zoltan Szecsei wrote: On 2012/07/24 16:41, Micha Silver wrote:

Re: [Qgis-user] Selecting polygons on attribute - Trying OGR

2012-07-24 Thread Andre Joost
Am 24.07.2012 17:21, schrieb Micha Silver: I think the problem is the attribute column name begins with a digit. Look what happens when I rename my column from above to 21Name: In the Qgis query form, no error is produced, but all elements are 'found' after renaming the field name to

Re: [Qgis-user] Selecting polygons on attribute - Trying OGR

2012-07-24 Thread Zoltan Szecsei
On 2012/07/24 17:29, Andre Joost wrote: Am 24.07.2012 17:21, schrieb Micha Silver: I think the problem is the attribute column name begins with a digit. Look what happens when I rename my column from above to 21Name: In the Qgis query form, no error is produced, but all elements are

Re: [Qgis-user] Selecting polygons on attribute - Trying OGR

2012-07-24 Thread Micha Silver
On 07/24/2012 06:34 PM, Zoltan Szecsei wrote: On 2012/07/24 17:29, Andre Joost wrote: Am 24.07.2012 17:21, schrieb Micha Silver: I think the problem is the attribute column name begins with a digit. Look

Re: [Qgis-user] Selecting polygons on attribute - Trying OGR

2012-07-24 Thread Zoltan Szecsei
On 2012/07/24 17:39, Micha Silver wrote: On 07/24/2012 06:34 PM, Zoltan Szecsei wrote: On 2012/07/24 17:29, Andre Joost wrote: Am 24.07.2012 17:21, schrieb Micha Silver: I think the problem is the attribute column name begins with a digit. Look what happens when I rename my column from

Re: [Qgis-user] Selecting polygons on attribute - Trying OGR

2012-07-24 Thread Zoltan Szecsei
On 2012/07/24 18:18, Andre Joost wrote: Am 24.07.2012 18:07, schrieb Zoltan Szecsei: Use the Table Manager plugin. (or just open the dbf in OpenOffice and change *only* the name of the column) Which is the Table Manager plugin? I'm just browsing QGIS plugins repository and cannot see

Re: [Qgis-user] Selecting polygons on attribute - Trying OGR

2012-07-24 Thread Micha Silver
On 07/24/2012 07:07 PM, Zoltan Szecsei wrote: On 2012/07/24 17:39, Micha Silver wrote: On 07/24/2012 06:34 PM, Zoltan Szecsei wrote: On 2012/07/24 17:29, Andre Joost wrote: Am 24.07.2012 17:21, schrieb Micha Silver: I think the problem is the attribute column name begins with a digit.