1
vote
1answer
43 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 ...
0
votes
1answer
34 views

Error using 'Join attributes by location' via Python

Trying to run a simple script using qgis:joinbylocation but getting either errors or it's not processing correctly. I don't want to take a summary of the attributes, just the attributes of the first ...
0
votes
0answers
14 views

how to join 1second GPS data with dGPS using much shorter time interval?

for one of our measurements we rented a dGPS with a portable "rover". I have now our measurements from our device which also contain data from built-in GPS (1 second sampling rate) + also the dGPS ...
1
vote
0answers
26 views

Create a non spatial index on an attribute in QGIS before joining two layers

I’m using QGIS 2.0.1 on Windows 7. I’m trying to join a .dbf which contains no spatial data to a shape file containing spatial data. Ideally I’d like to create an attribute index on the join field in ...
0
votes
1answer
66 views

query / filter on attribute tables with external tables joined

i tried to do some queries on joiend table fields ... i've got/found some answers concerning version 1.8 - which result in "use select + export to create a combined dataset" so i just did some tests ...
0
votes
0answers
50 views

Batch join non-spatial csv to shape files

I have 173 point shape files from soil testing and 173 non spatial csv files with lab ressults (one csv for each shape file) that need joining. The files are located in a library with folders named ...
1
vote
1answer
39 views

Problem with QGIS 2.2 joins between shp and csv

Didn't see question like this asked, so... I've joined csv to shp file and everythings seems ok. I've modified attribute form so that fields from joined csv appears in there. So far so good- it's ...
1
vote
1answer
59 views

When I join a table to a shapefile and then export it the titles of the columns are transformed to data1, data2

I'm using QGIS 2.0.1 The table is in an excel format that i import through "add vector" and the shapefile is a polygone I join the attributes by right clicking the polygone-->properties-->join Then ...
4
votes
2answers
237 views

Spatial join - many to one

I'm trying to do a spatial join that takes the attributes of multiple polygons and applies them to a single polygon in another layer. The data is currently in a geodatabase, but can be exported to shp ...
1
vote
0answers
42 views

How to create a 1:n join and concatenate text attributes?

I have 2 polygon layers A and B. I would like to join the attributes from B into A for all the polygons from B that intersect A and for text attributes, i would like them concatenate. But apparently ...
0
votes
1answer
188 views

Problem with MMQGIS in QGIS V. 2.0.1 - Attribute Join from CSV File

I've been trying to use the Attribute Join from CSV File function in MMQGIS, but it does not seem to work in Version 2.0.1. I've tried to join the same CSV and Shape files using V.2.0.1 running under ...
3
votes
1answer
92 views

Field calculator uses wrong fields when working with joined data

I am having an issue in qgis table joins. i have a joined a csv file to a sqlite database and common id is used for join. the join is displays correctly in attribute table. the attributes in sqlite ...
0
votes
0answers
54 views

export spatial information from table that is joined to a shapefile in QGIS 2.0

I have a table with data values per district for different years. The table looks like this: district name / year / value. The same district is thus present in the data multiple times for different ...
2
votes
2answers
272 views

Table join with .csv file results in null fields after join

Similar to questions already asked about .dbf files, I'm attempting to join .csv files to a .gdb or shapefile coverage in QGIS. The tables as added to QGIS prior to the join look fine, but after the ...
0
votes
0answers
97 views

Best way to join and handle multiple attributes related to the same feature

this is not going to be a question, I'm just trying to find some advice. Suppose I have a point shape file (for example just 2 point, actually I have many more points) representing water control ...
1
vote
1answer
145 views

Join Tables related by a composite primary key in qgis

I have two tables, one has the geometry and other has attributes. The table with geometry has unique number primary key, and 4 columns admin1,admin2,admin3,featureid. Table two is a csv file has the ...
0
votes
0answers
33 views

Search an attribute and highlight corresponding polygon from a “joined-in” layer [QGIS/PostGIS]

Using QGIS 1.8.0, Postgis 2.1.0, and still new to all that. As the headline points out, I have a list of samples, which are found within areas (no point (GPS) coordinates). With a search query I ...
1
vote
1answer
305 views

keep the same field headers after joining a table to a shape file in QGIS

I noticed that after joining a table to a shape file the headers of each fields in the table used for the join are changed by QGIS and they are attributed to a different name. For instance, i had a ...
4
votes
1answer
140 views

QGIS 2.0.1 linking table issue, MSSQL 2008 database

I'm trying to link tables in QGIS 2.0.1 and MSSQL 2008 database. I can link them but when I try to open the attribute table QGIS throws an error and shuts down creating a *.dmp file. I saw that ...
1
vote
2answers
295 views

Join excel attributes to shape attribute

I am wondering if there is a way to join the attributes from excel tables to shapes in Qgis. I have abbreviations in the shape and want to add the associated complete names from excel file by ...
1
vote
4answers
91 views

Add only unique features from another shapefile

I've got a problem that I am sure at least one of you have dealt with. I'm new to a company that makes use of a rather large database of point data. For whatever reason, the woman who was here before ...
2
votes
0answers
92 views

QGIS - How to avoid -2147483648 value from imported CSV?

I am attempting to join a spreadsheet containing all the CIA Factbook Country Comparison Data (many columns) to the existing Natural Earth world countries shapefile. I followd the tutorial here, but ...
0
votes
0answers
181 views

PyQGIS joining a dbf to a shapefile

I am trying to join a shp and dbf file using the PyQGIS API. The code I'll use is below: from PyQt4.QtCore import * vector1 = QgsVectorLayer("path to dbf file", "test1", "ogr") id1 = vector1.id() ...
2
votes
1answer
58 views

After joining data from csv file to shapefile, why are all values zero in categorized renderer?

I have joined data from a csv file to my shapefile. The attribute table shows a successful join. I have converted the variable of interest to INTEGER. But when I go through Style to categorize the ...
2
votes
0answers
676 views

QGIS: After performing a table join, all the fields are “NULL”

Within QGIS, I joined .dbf table containing population data to a shapefile of Census tracts. The join field is called GISJOIN in both the target table and the shapefile's table, and this attribute ...
2
votes
1answer
159 views

QGIS join data not transferring

I'm reanalyzing data from a VA Late Woodland Palisaded Village. The site is mapped in CAD and exported as a shapefile. QGIS brings up the 1059 features as polygons. I am using a CSV file for the ...
2
votes
1answer
503 views

Joining table to shapefile with pyQGIS

Joining shapefiles is a relatively straightforward proess in QGIS using 'add vector join' in the layer properties menu. I can add a csv file as a vector layer, as well as a shapefile, and join the two ...
1
vote
1answer
101 views

Join attributes by date in Qgis

I learned (thanks!) to use the join feature built into the layer properties, but in my case it doesn't work because data do not match perfectly. Infact shape refers to geotagged photos, csv is a log ...
0
votes
1answer
47 views

How to use classified styles with joined layers?

I am trying to set a color range based on this tutorial In LAYER PROPERTIES for "new", in JOINS, I have joinlayer - data-join joinfield - GEO_ID2 targetfield - GEOID10 Where "new" is my shapefile ...
4
votes
1answer
140 views

How do “join field” and “target field” work?

New user. This should be simple, but I can't figure out how to perform this basic join in QGIS. (It works in Cartographica.) My shapefile (IL_BNDY_County_Py) has two fields/columns in its attribute ...
0
votes
0answers
56 views

Adding a new attribute to shapefile from Excel sheet [duplicate]

I have a shapefile in QGIS and I needed to add a attribute to the attribute table. The problem is that I have the information I need to add in an Excel file. How can I add the information from the ...
1
vote
3answers
440 views

Why does QGIS not detect the CSV/DBF column headers?

I am trying to import a csv or dbf into qGIS so I can perform a join on a shapefile. However, qGIS is not detecting the first row as header names. I know I've done similar joins before and there's ...
2
votes
0answers
668 views

How to join data from a CSV to a shapefile using QGIS

I'm new to GIS and new to StackedExchange. I need help joining a CSV of Accessibility data to a LSOA shapefile in QGIS. The process explained here does not work for me and I don't know why. The ...
0
votes
0answers
432 views

How to do a spatial join if QGIS 1.8 keeps crashing?

I am trying to perform a simple spatial join (adding polygon data to points) in QGIS 1.8: target vector: points join vector: polygons take attributes of first located feature keep all records ...
5
votes
1answer
361 views

How do I avoid text field truncation when saving a table join?

Using QGIS I've joined tabular text data (all in fields of less than 255 characters) to a shapefile via a CSV file. All looks good in the joined table but when I save to a new shapefile to make the ...
7
votes
2answers
1k views

Trouble with graduated symbols after joining shapefile with csv file

I have successfully joined data from a csv file to a shapefile in QGIS but for some reason I am having trouble symbolizing my data. I want to use a graduated symbology however this option is not ...
2
votes
3answers
558 views

vector tool missing when install QGIS 1.7.4 on new computer

I installed QGIS version 1.7.4 a few months ago. Under the menu Vector > Data Management Tools I have two options to make a join: 'Join Attributes' and 'Join attributes by location' (see screenshot). ...
1
vote
1answer
540 views

Join attribute table

I am using QGIS 1.7.3 on Mac and when I try to use the tool "join" in the properties toolbox, I have no possibility to add a name for either the file or the field used to join tables. Has anyone ...
6
votes
1answer
1k views

Join attributes of point and line layer by location (closest distance) in QGIS

My problem is the following: i have a line shp (target layer) and a point shp (join layer). the second one (point layer) holds an attribute which i want to join with a line layer based on closest ...
11
votes
2answers
7k views

How to join external tables with a shapefile's attribute table in QGIS?

I need to join a .csv table into an attribute table of a shapefile. I wanted to do this with QGIS and i don't seem to find anyway of doing it. I know that the mmqgis plugin does it, but my shapefile ...
12
votes
3answers
4k views

How to join attributes from nearest point in QGIS?

I have two layers with points, call them A and B, each with different attributes. For each point in A I want to join all the attributes from the nearest point in B. Ideally this would also include ...
7
votes
5answers
7k views

How to join multiple records to single feature?

apologies for what I'm guessing is a really easy problem to solve. GIS user, not programmer here. I'm trying to create a join/relate in QGIS where I have a shapefile of buildings and to that I would ...
15
votes
4answers
7k views

Join non-spatial CSV to spatial data in QGIS

I have a csv which has postcode data in a field, but it is non-spatial e.g. no Easting and Northing. I have a shapefile with postcode in a field and some additional data. I want to join the csv with ...