The process of connecting two or more datasets based on a common attribute or spatial location.

learn more… | top users | synonyms

-1
votes
1answer
29 views

JoinField General Function Failure[featureclasName]

I am trying a simple joinfield in arcpy and i keep getting the error: Execute error: ERROR 999999: Error execution function General function failure [AA] failed to execute JoinField Below are ...
4
votes
1answer
52 views

Conditional Spatial Join?

I need to join two layers (a fishnet grid and land cover). I'd like the join to occur only if the the land cover occupies 50% or more of each fishnet grid (See image below). Can anybody provide an ...
0
votes
0answers
18 views

How to load data from a CSV file into ArcGIS Pro?

I'm very new to GIS mapping and I have some polygons loaded into ArcGIS Pro. I need to associate some data that is currently stored in Excel with each polygon e.g. population density, average rent. I ...
1
vote
0answers
32 views

How to show two layers at the same time in Qgis

I have a question about Qgis layers. I want to see two layers at the same times. one is lines which are boundary lines and the other is polygon which are district. when i was surfing about this ...
3
votes
3answers
61 views

How to Join two feature classes without common attribute

I have two shapefiles of essentially the same objects however, one shapefile has terrible spatial data but great attribute data and the other is the reverse. What I'm looking to do is essentially a ...
1
vote
1answer
394 views

Join and Calculate vb.net

Im trying to join an excel table to a shapefile and then calculating those fields using vb.net. The code I have written has no errors, but won't work when I try it in ArcGIS 10.1 and I'm out of ideas. ...
0
votes
0answers
15 views

Using Join with a Raster File

I would like to add a new field to a raster file. Then, I would like to add the new field content. Can I do this with a join of attributes? I know that a raster file can be reclassed. But there ...
0
votes
0answers
22 views

Fail in searches on the joined table data

When a table is joined to a standalone table, the searches on the joined table data return a fail. Is there another way to solve this inconvenient without save the layer with joined table under a new ...
1
vote
2answers
66 views

One-to-many join in QGIS

I am looking for a possibility to make a one-to-many table-join in QGIS. I have a shapefile with postal codes and would like to join them with survey results (more than one). In other words, there ...
1
vote
0answers
26 views

Join tables in QGis 2.01. Dufour

I performed a "join" going to the properties option in a shapefile (in this case is just a table), in order to join the attributes from another shapefile that has a field in common, specifically ...
2
votes
0answers
26 views

Can joined tables be served by QGIS Server WFS?

I'm trying to figure out whether it's just me, or if I'm forgetting a setting. I have a shapefile which I make available for WFS-requests. Now I added a join (to a MySQL table). I tried playing ...
2
votes
2answers
65 views

QGIS joins 2 FIELDS

I have an excel with 4 columns (Region; District; village; number of cases) Have a shapefile with dots for villages with many columns including (Region ; District ;Village) I want to plot the cases ...
0
votes
0answers
38 views

Join tables with duplicate values

I have two sets of data: list of parcel numbers and locations which I am interested in Address database for the county (shapefile) In dataset 2 there can be multiple instances of the same parcel ...
0
votes
0answers
45 views

What is the function for Joins and Relates?

I was writing a script to do a Join based on Spatial location. I don't want to do a spatial join as it will have all the fields of the layer that is joined to the target layer. I want only the fields ...
0
votes
0answers
40 views

Assigning one-to-many polygon to .csv data in ArcGIS for Desktop?

So I am currently working with two separate files. One is a polygon feature class detailing a specific countries' subdistricts. These subdistricts are identified using a specific alpha-numeric code. ...
1
vote
0answers
21 views

Nearest neighbour / spatial join with attribute condition

I have 2 point format datasets I wish to schematically join (manholes & gullies). I am content that I can join them by nearest proximity alone using e.g. NNJoin plugin. What I would like to do ...
1
vote
1answer
16 views

Table join not displaying in createLayer function in cartodb.js

I am trying to build on the cartodb tutorial to develop a map of fibre networks in Africa. The example works fine when my SQL select is very simple i.e. var layerSource = { ...
3
votes
1answer
35 views

ArcGIS converting list of enumeration in single field of s-57 data?

Im storing s-57 data in an MDB which is being symolised via a layer. Some attributes in s-57 data can be a list of enumerations and I want to find a way to show the actual values the enumeration ...
3
votes
1answer
3k views

Why can't I use a Join in a model?

I'm trying to build a model using Model Builder in ArcGIS 10.1 that starts off by joining two shapefiles together based on a common field. I would like to make this open ended (not hardcoded) so I can ...
0
votes
4answers
37 views

ModelBuilder - Iterate through tabels to join and export and keep original field names

I am trying to iterate through an excel with over 200 sheets and join each to a ZIP code layer. I then need to symbolize each of those the three different ways and save that to a layer file. In order ...
1
vote
1answer
36 views

Joining Excel file with CityGML file using FME?

I want to join a excel file with a CityGML file with FME. i want to join the excel file with the geometry of the CityGML file. all attributes should join this file which settings should i choose ...
1
vote
1answer
28 views

Joining table to a near table

I calculated the distances between one set of xy coordinates and another set of xy coordinates. So my near table has the ID variables, distance and rank. However, when I join the near table to the ...
1
vote
0answers
147 views

Can Virtual Fields be used for a rendering style?

In QGIS 2.6, creating a virtual field for a layer and adding up 2 integer fields work fine. I get the correct results and I can use that field for styling. However, when doing a Joins with 2 layers ...
1
vote
1answer
49 views

QGIS feature subsets are incompatible with table joins. Bug?

When using QGIS 2.8.2, I am unable join a table to a layer that has a feature subset (Layer Properties > General > Feature Subset). For example, creating a feature subset on a layer prior to joining ...
1
vote
1answer
65 views

Working w/ Shapefiles Containing 50,000 to 300,000 Features

I work daily with shapefiles that are quite large in number of features using ArcGIS. Sometimes I am able to perform operations (joins, selections, exports, etc) on these shapefiles (though they do ...
0
votes
0answers
42 views

What is corrupting my layer file?

I'm trying to save layer files from a colleague's mxd. As usual I right clicked on the layer and saved as layer file. Simple - but no - the layer files can't be opened. I get this message "Adding ...
2
votes
1answer
65 views

How to conduct an inner join with QGIS?

My QGIS (2.8.2) joins always result in an outer join. How do I create an inner join with QGIS?
1
vote
4answers
75 views

Create Statewide Hydrologic Soil Group Map

This may be better for Engineering? Not sure. Background: Previously I have downloaded SSURGO soil data for the state of Pennsylvania by downloading each county and merging the shapefiles. I then ...
1
vote
1answer
42 views

Problems when joining large shapefiles to excel table

I began with a shapefile of 330,000 features, each having already been geocoded (not that it matters I don't think). I attempted to join this shapefile to an excel spreadsheet but of course, Arc ...
0
votes
1answer
21 views

Join line segments sharing a common attribute, using GDAL

I'm having trouble rendering a shapefile consisting of trail routes broken down into many short segments. So I'd like to combine them into a small number of line features, which share a NAME and touch ...
0
votes
0answers
23 views

csvsql SQLite --insert causes ID to change

I have a question that stems from a solution provided in this Question: Join a CSV file to shapefile using gdal/ogr? I've been using this to do joins successfully but for some reason, I have a field ...
0
votes
0answers
22 views

Export Joined table an Feature layer based on a query

I have a table and a layer joined fine, I am trying to export the end result into a file geodatabase, the export is fine if I specify specific name, other than that it exports the original layer data. ...
1
vote
2answers
307 views

How to join a File Geodatabase table with only one record of Feature Class

I've a Geodatabase containing a Featureclass and some File Geodatabase Tables. Each File Geodatabase Table is actully about the only one record of a featurClass. Can We Join these File Geodatabase ...
0
votes
1answer
46 views

ArcGIS Route Analysis

I have a pipe network that is a imported CAD file converted to lines showing complete runs of pipe in a system. I also have a Access database imported to ArcGIS set up as a relate to my Pipe line ...
0
votes
1answer
121 views

MapInfo SQL: Selecting all columns from one table, some cols from second table?

I'm fairly adept with the SQL Select in MapInfo, but I'm running into something that's got me a bit stumped. I've got data in two tables that have a few columns in common. I want to join the tables ...
0
votes
1answer
53 views

Why aren't my hyperlinks saving in ArcGIS 10.2

I have a polygon layer and I have a joined table with a link to an excel document for each polygon. Under the "Display" tab in layer properties I check the "Support Hyperlinks using field:" box and ...
0
votes
0answers
35 views

Problem in “Add Join” function in modelbuilder

I'm having an error when I run the model in Add Join (3). Add Join (2) runs well, but when it's running Add Join (3) it fails with Error 999999. I think it's because it already runned Add Join (2) and ...
0
votes
0answers
21 views

Adding values from a text file to a gridded area on my map [duplicate]

I have a .txt file with comma seperated values. Each individual value corresponds to a cell in my grid. The first value in the .txt file corresponds to the cell in the first column and first row of my ...
1
vote
1answer
53 views

Joining Parcel/Building Attributes Based on Coordinates

GIS noob here: I downloaded a building footprint shape file for a city and imported it as a vector layer in QGIS. I was hoping to see street address information in the attribute table, but there was ...
1
vote
1answer
54 views

Adding data from a table to a grid in ArcGIS

I have a table with 720 rows and 156 columns. I have a grid with 720 rows and 156 columns. I would like to assign the values from the table to the corresponding values in the grid. I am a beginner to ...
1
vote
2answers
42 views

Spatial Join returning max value and unique ID

Using ArcGIS 10.3 I have a dataset containing polylines of a pipe network, along which I have a polygon layer representing a burst every 50m. The burst layer contains a value (p) and a unique ID (the ...
0
votes
0answers
18 views

Join based on approximate area

I am trying to join information from a table to information from a feature class based on "approximate area". I have drawn (on-the-fly) building footprints, multiple footprints per parcel. I have ...
1
vote
1answer
566 views

arcpy JoinField_managment RuntimeError

My script is supposed to pull weekly flu data from a department of health website, parse it for that week, and then push the data up to our ArcSDE server so that it can be displayed on our Web Mapping ...
0
votes
0answers
39 views

google earth xml export

i would like to ask a question that pertains to exporting xml to be used in a google earth .kml file. my map incorporates daily specials for local businesses. i am joining two tables to accomplish ...
2
votes
2answers
2k views

Join multiple fields to table and export new table as join field name using ArcGIS Geoprocessing?

I am bit new to geoprocessing and ModelBuilder. I am using join field tool to join table (info tables/.dbf) to one a shape file. I am trying to use ModelBuilder, as there are around 100 tables (each ...
1
vote
1answer
37 views

why the values are NULL if I join the csv table to a point shp file [closed]

So my problem is all values are NULL if I join my csv-table to a point-shape-file. (QGIS) Why? I tried so much thing but I can not find and handle the problem. I have customer names in the csv, ...
0
votes
1answer
43 views

Exporting KML from QGIS with relation (one-to-many) table as popup

Here is a challenging one for someone. I have two tables in QGIS. Holes (parent) - Which contains the borehole locations. Strata (child) - which has many rows that contain the strata for each ...
0
votes
0answers
50 views

Multiple LEFT JOIN in PostgreSQL

I got a "nice" problem with a query in PostgreSQL with a multiple join SELECT DISTINCT "Monitoraggio_L001_L008_2015_aprile"."ID", "Monitoraggio_L001_L008_2015_aprile"."Ordine", ...
2
votes
1answer
518 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 ...
1
vote
2answers
49 views

What is the strategy to add attributes to shapefile when the number of records are not the same?

I'm trying to add attributes (in excel format) to an existing shapefile using ArcGIS, but the number of records between the two are not the same; there are some records in one file but not in the ...