3
votes
0answers
11 views

Using QGIS to create a table of correspondence between two area layers

I have two area layers over a map of Australia, and I want to know if it's possible to use QGIS to create a table of correspondences between them. The Australian Bureau of Statistics provides ...
0
votes
1answer
38 views

How to add new columns with attributes in existing Qgis layer?

How to add new columns with attributes in existing Qgis layer? Doing the "same thing" here described
3
votes
0answers
85 views
+100

Startup python script to re-join layers

In QGIS 2.2, there is a bug which involves using the JOINS properties on a vector layer (that is already being joined with several other vector layers) whereby the attributes are not fully loaded. ...
3
votes
0answers
32 views

Can you use wildcards for column headers in Field Calculator?

I know you can use wildcards for fields like so (in the Field Calculator): case when "column" ILIKE '%example%' then 1 else 0 end Can you do something similar for the column headers themselves? I ...
2
votes
1answer
52 views

Why don't all the attributes in the SQL query appear in table?

I have an SQL query that works fine in the DB Manager but when I load the table as a layer one column does not get loaded. The different thing about this column is that it is static -- text generated ...
2
votes
2answers
55 views

How to change precision on a column in the attribute table without losing data?

I have data in an Excel-file that I want to join with a shapefile in my project. The Excel-file contains values like volumes. The Excel-file and the shapefile I want to join it with both contain the ...
1
vote
0answers
54 views

Copy parts from several attribute tables in shapefiles?

I have several shapefiles from which I wish to take parts from their attributes tables to make a new attributes table. Is this possible without destroying the original attributes table? I have ...
3
votes
0answers
33 views

How to export data from sql server into shapefile in the decimal format in QGIS 2.4?

The last couple of days, I have been working on exporting data from SQL to a shapefile in QGIS 2.4. While converting into a shapefile, the data type changes automatically from Float to Integer in the ...
0
votes
0answers
36 views

How to convert data type from float to integer in QGIS?

Currently I am working on importing data from MSSQL to Qgis 2.4. In imported database table attributes are shown in the format of integer ( in attribute table it showing like 48.23 and 16.20 in ...
2
votes
1answer
63 views

How to do a “fuzzy” intersection?

I have two layers that look like this: I want the intersection (or whatever the correct term may be) to look like this where the output polygons are the same as the original base layer, just with ...
1
vote
1answer
47 views

How to batch-process attribute tables in QGIS (or GRASS)?

I'm using GRASS 6.4.3 in Linuxmint 16. I have a bash script for GRASS which I use to process almost 300 raster files. The script first imports some raster files (r.in.gdal), then does some ...
1
vote
0answers
27 views

How to sort a column in attribute table programmatically

Is there any way to sort ( alphabetically ) a column in the attribute table programmatically (without clicking on the column header) in QGIS ?
1
vote
0answers
34 views

Modifying properties of Attributes Table in QGIS?

In my QGIS project I'm using vector layers that require a lot of data inputting/editing. The problem is that some of the data I'm inputting varies greatly in matter of length and structure (various ...
4
votes
1answer
180 views

Extract one GPS fix per day from data?

I am in the fortunate position of having 2 years worth of animal movement data. With such a large amount of data I would like to extract only one fix per day to make it easier to work with. Data = 14 ...
2
votes
1answer
76 views

Creating New Layer After Sorting Attribute Table using QGIS?

I have been self-teaching myself some open source GIS. I downloaded QGIS and have been following this four part tutorial - ...
2
votes
1answer
47 views

QGIS 2.4 : How to search an Attribute Table?

I am learning how to use QGIS on v.2.4. When opening an attibute table, it does not have any clear "look for" search bar as seen in older versions in screenshots and videos. There is now a (SQL?) ...
2
votes
0answers
44 views

Editing the QGIS Attribute Table

Is there a way to edit the name, type and length given to each column on the attribute table once the information has been imported from Excel?
0
votes
0answers
41 views

How to aggregate data which meet certain conditions using QGIS?

I have a point shapefile with meteorological stations which contains three columns, which are: Date: The date on which the measurement has take place (it covers a range of ten years) Id: The ...
3
votes
1answer
70 views

Not able to save edits to vector layer in QGIS

I have a vector layer with about 200 features. So far I have been able to add polygons to this layer just fine, now it is giving me trouble. When I draw the polygon and try to save edits, the polygon ...
0
votes
0answers
28 views

How to set QGIS action to open and search for features on Google Maps?

At the moment, I have an action that takes each term in an address field and conducts a search on EACH term in Google (ie. multiple tabs are opened for each term). The action code I have is the ...
3
votes
1answer
44 views

Can QGIS table editor achieve similar results to Pivot tables in Excel?

Is it possible to achieve similar results to Pivot Tables in QGIS table editor so as to use just QGIS instead of several software solutions? Or are there maybe some plugins capable of achieving those ...
1
vote
1answer
48 views

How to join two tables and convert joined table to a vector layer containing points in QGIS? [duplicate]

I have one table that contains 450 locations and a table that has 10'000 rows containing data and no spatial information. I have a column that allows me to join them. The issue is that I want to have ...
1
vote
1answer
46 views

How to perform a spatio-temporal query in attribute table? [duplicate]

I am not good at programming, so I would ask for your understanding concerning my question. I have an attribute table that contains five columns which are: (Date, ID, Latitude, Longitude, Rainfall). ...
0
votes
2answers
66 views

Using the Rule-based style to calculate each grid cell from overlaps

I am using the Rule-based styling properties (QGIS 2.2) to determine the colour of grid cells for a merged shapefile. Each grid cell defined by its ID may be overlapped by several layers as defined by ...
0
votes
0answers
63 views

How to keep all the unique columns of the shapefiles after merge?

Writing a script where the user is asked to select a directory which contains Folder_1 and Folder_2, both containing shapefiles and run various algorithms. The basic logical process of the script is: ...
0
votes
2answers
57 views

How to show attribute table in the form

Is there any way to show the attribute table of a layer in a QtextBrowser or a QtableView on form? I did this but,(shows attribute table in a separate dialog) I have no idea, how to show it in my ...
0
votes
1answer
32 views

QGIS: Comparing 2 attribute tables to discern unmatched attributes

In QGIS, I am trying to compare two different attribute tables. One is simply the updated version of the other. Each feature has a unique identifier. How can I return the number of unmatched records? ...
0
votes
0answers
30 views

Points on map disappear when apply certain column

I am a linguist who studied some variables in New Zealand English. Now I wanted to map the proportion of certain variables onto a map. It has worked fine so war and I've been able to map quite a few, ...
1
vote
1answer
38 views

QGIS 2.2: Attributes table keeps crashing

I am currently working on an intensive project that requires me to edit the fields of literally thousands of line segments. While updating the shapefile, it crashed on me. Today, qgis has probably ...
0
votes
0answers
67 views

PyQgis: How can I “append” features to a Vector Layer instead of “stacking” them?

As I read data from a text file and add points to a QgsVectorLayer (as well as related attributes), each new record gets 'stacked' on top of the previous one in the Attribute Table (and within the ...
0
votes
1answer
77 views

generate massive shapefiles

I have a shapefile with 1475 records, and I want to generate a shapefile for each record. What can I do to generate them avoiding selecting and exporting each record to do that?
0
votes
1answer
37 views

Piechart of a text column from attribute table in qgis

I have this problem: I would like to create a pie chart from a column of a attribute table, and I would like to see this pie chart above the map. The column contains names not numbers (I think fields ...
1
vote
0answers
47 views

Merging shapefiles to one, rearrange columns?

I am trying to merge two shapefiles which both contain polygons representing properties in QGIS 2.2. One problem is that the names of some of the columns in the attribute table differ between the two ...
1
vote
2answers
81 views

Auto fill second column with predefined names depending on first column (QGIS)

I want to create a point layer. In the attribute table I want to have two columns. In the first column I want to type an abbreviation like A. Then I want the second column to be auto filled with ...
3
votes
1answer
104 views

QGIS - Is it possible to increase Output Field Name?

When creating a new Column, the default value for the length of the name is 10. Using the Field Calculator via the Model Builder, I want to include the names of regional areas into the columns which ...
1
vote
1answer
33 views

QGIS how to add string field

I have a few point shapefiles. I want to merge them, but first give each point a certain type according to shapefile. How do I add a String field, all with the same word? (changing the field type ...
1
vote
2answers
79 views

Open mail client when clicking feature in Attribute Table

One of the attributes/features of my layer contains an email address. I'd like to be able to open the default mail client by clicking on the mail address from the Attribute Table. After some initial ...
1
vote
1answer
95 views

extract shapefile attributes from raster colors

I have two layers: a shapefile with states and counties (shp) a raster file (with colors and some text and borders, but not a perfect map) (tiff) I want to use the colors in the raster file to ...
0
votes
0answers
47 views

QGIS 2.2 Changeing txt data in theme table not working

A week ago I upgrade from QGIS 2.0.1 to 2.2 and try to edit some simple point themes I made recently. To my surprise, QGIS 2.2 randomly - not allways, does not allow me to change text I type into text ...
2
votes
1answer
51 views

loss of attribute data when copying between layers

I am trying to copy points from one layer to another in QGIS 2.2 The problem I get is that all the attribute data from the copied points is missing when copied onto the new layer, the columns show ...
0
votes
0answers
13 views

Link/unlink buttions in the Attribute Table's Form View

Toggling the edit button, in the Form View/Table View, buttons for adding/deleting a record is available. Two additional buttons are also available (Fig. 1). From the look of the icons they perform ...
1
vote
1answer
56 views

Alias's in the Attribute Table's Column Preview/Column Filters

We've spent some time setting up alias's in Layers/Properties.../Fields (Fig. 1) for database fields displayed as the column headers in the Attribute Table (Fig. 2). Switching the layout in the ...
3
votes
1answer
64 views

How do I add a field to a table using the QGIS graphic modeler?

I was wondering if anyone could help as I'm struggling to get anything out of the QGIS graphic modeler. For info I have no programming skills whatsoever. I need to be able to add a new field to an ...
1
vote
1answer
39 views

Expression to create and populate column based on filtered fields

I wanted to create a column and populate it with data based on data from other fields. If column_1 contains fields which has similar string (eg. field_1 = "Country: UK", field_2 = "Country: US", ...
2
votes
1answer
187 views

How to adjust QGIS attribute table view column width using Python?

I'm programmatically opening the Attribute table via Python through a plugin. All of the columns have a default width, but some of the data that I'm using do not fit. It's not enough to be able to ...
2
votes
0answers
69 views

How to open QGIS attribute table in form view using Python?

I've got a plugin where I load some layers. On the last layer loaded I show the attribute table. I would like to select the view different from the table view (see image). How can I do this in Python? ...
0
votes
1answer
52 views

Why do field values change when exporting from QGIS?

Today I came across a very strange behavior of QGIS. Maybe someone knows what's going on? I have a table with two fields which are defined as Double, with a Length of 20 and a Precision of 0. Some ...
0
votes
3answers
66 views

How can I change more than one attibute at the same time?

I'm working in QGIS 2.0.1 Dufour. I started by cretaing a shape file form an AutoCad file. The problem is that in the AutoCad, my layers had symbols like: "~; รง; ^". As the QGIS does not support this ...
1
vote
3answers
92 views

How to add data to an attribute table?

I have a shape file (points) and would like to add points using the attribute table and not the Add Feature tool at the main screen. I went over the Qs here, but didn't find a similar problem to ...
0
votes
2answers
452 views

QGIS select features from attribute table using the “LIKE” operator

I created an expression with the help of the GUI in the QGIS attribute table of a vector (shapefile) layer of Native American ("Indian") reservations in the USA state of New Mexico. "NAME" LIKE ...