The process of connecting two or more datasets having one-to-many or many-to-many relationships based on a common attribute.

learn more… | top users | synonyms (1)

0
votes
1answer
19 views

Select related feature among layers

Is it possible in ArcGIS 10.x that if I select a feature in one layer it will also select the related feature in another layer?
3
votes
1answer
45 views

in QGIS how to add (join?) another table to a layer

Very new so bear with me. I have QGIS loaded with a TIGER/Line Shapefile at the Block level for a County, and need to join other detailed CENSUS data various tables (which also have a Block ID to ...
0
votes
0answers
15 views

One to Many link that can be queried

I'm at my wits end, having looked through a number of posts and tried several options. At this point I'm just looking for confirmation that I cannot do what I am trying to do without ArcGIS or using a ...
3
votes
3answers
52 views

Querying through Relations

Right now I am stumped on how to get two layers to interact. I have one layer that is just a map with town borders, with attributes for town codes. My other layer are data for businesses, wages for ...
2
votes
1answer
65 views

Add/Remove Relate using ArcPy without ArcGIS Pro?

I am trying to add a relate between 2 feature classes so that I can use the area of the related table to update a field in the original table. I found that ArcGIS Pro ...
0
votes
1answer
31 views

Auto-selecting records in all spatial and non-spatial joined/related tables by selecting only “parent” spatial record in ArcGIS for Desktop?

(1) I have a layer of pipes with related spatial and non-spatial data linked via joins and relates. Is there a way of selecting the top/parent record and then having ArcGIS auto-select all related ...
1
vote
0answers
88 views

Automate multiple repetitive ArcGIS 10.2 Table Relates?

I have a situation where multiple users will be creating many file gdb's in ArcGIS 10.2 using just the basic license. The data format is standardized and will have a feature layer with point data and ...
0
votes
0answers
67 views

Creating Query Layer with 1:M relationship in ArcGIS?

I am trying to create a query layer in ArcGIS which contains 1:M relationship, When i execute query i am getting blank feature class. My query is as below SELECT a.Industrialcode, a.Industrialname, ...
1
vote
1answer
79 views

Communicate relation between two table

At this time, I'm able to create a relation (1:M) between two table or geometries. After, I user Identify tool to exploit the relation. It is only possible to use this feature when your Identify tool ...
3
votes
3answers
131 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
85 views

How to export the contents of a QGIS relation?

I have created a 1:many relation in QGIS 2.10.1 with Project Properties>Relations. When I select a map feature with the Identify Features tool, a Feature Attributes window (widget?) appears. How do ...
3
votes
1answer
63 views

Showing multiple burials in same grave for Cemetery GIS?

I am an intern creating a Geodatabase for a municipal cemetery. The one lot can hold up to 3 people (2 people, 1 cremation) two people at the most. How would I show that information on the map ...
0
votes
0answers
59 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 ...
1
vote
1answer
42 views

Sort related objects in Identify window of ArcMap 10.2?

I have a table Points related to a table Events. The event table contains the fields Point-ID, Event type and Year. The two tables are related to each other. If I choose a number of points with the ...
2
votes
1answer
143 views

Show relations in HTML popup in ArcMap

Is it possible to include information about relations in the HTML popup in ArcMap? I have two tables, one with points (Columns: ID, Name) and one with events about those points (Columns: PointID, ...
1
vote
2answers
82 views

OpenStreetMap boundary relation lost when exporting to spatialite with ogr2ogr?

I am currently working in map for a province of Papua New Guinea. In OpenStreetMap (OSM) I have recently updated and added new relations for boundaries of admin_level=5 and admin_level=6, which were ...
0
votes
0answers
99 views

How to relate a Spatial and Non Spatial table in PostGIS to be visualized in QGIS

first of all I'm quiet new in PostGIS. I'm working in pgadminIII with postGIS. I have in one database two tables. See the two tables SQL Pane. CREATE TABLE gw_body_characterisation2 ( ...
0
votes
1answer
51 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
1answer
66 views

Write CSV table for join self in ArcGIS for Desktop?

I wonder how I would write a table for a join which I want to perform. Right now I wrote a .txt File, tab-seperated. The headerline only contains letters. Here is the problematic table: ...
1
vote
0answers
44 views

Can I define a style for one layer, taking into account a defined relationship with another? (QGIS 2.8)

I have two sets of data. A large set of lines with a line_ref field, and a small data-only (no geometry) table with a matching line_ref field (let's say for argument's sake that the data-only table ...
1
vote
1answer
152 views

ArcMap not respecting advanced sort in related tables?

ArcMap 10.2.2 doesn’t respect the advanced sort in related tables, I couldn’t figure out why the ArcMap doesn’t respect the advanced sorted values when the sorted table is related to other feature ...
1
vote
1answer
40 views

Is there an out-of-the-box way to manage 1:n data in QGIS?

I think an image explains the question best: What I basically want to do is select the object, view its attributes and from there call the second table to view/edit/add status entries. Since I ...
1
vote
0answers
63 views

Plot Multiple Series from Related Table in One Chart

I'm trying to figure out how to plot multiple line series/charts in one chart in a popup window from attributes in a related table using the Javascript API. It seems like the only way to create a ...
1
vote
4answers
94 views

Labels based on spatial location

Here is what I would like to do. I have a polygon feature class called Subdivisions and a point feature class called Inspection. If I label all the Subdivisions my map becomes too congested. I only ...
0
votes
0answers
32 views

How to show an overview of all Joins and Relations in ArcMap Project?

Is it possible to get an overview of all Joins and Relations between my Tables and Files in ArcMap 10.1? Right now I have to right-click on every file to see how it is connected to another file. It ...
1
vote
1answer
63 views

Force ArcMap to respect the attribute table entries in the relationship tabs

Is there any method to force ArcMap to respect the attribute table entries in the relationship tabs? I have a table named “aaa” which is related to a feature class “communities”, the values in the ...
2
votes
0answers
48 views

QGIS one-to-many labels

The one-to-many relations in QGIS is OK with forms, works great. But how to labels or chart data with this one-to-many relations? Martin
2
votes
1answer
46 views

Working with related table

I tried to dissolve smaller features into larger (from unit to district) with field in related table. I can easily see the related records of related (many) table but unable to dissolved the features ...
1
vote
1answer
82 views

Editing related objects in ArcMap?

Using ArcCatalog, I created a relationship with the following parameters: Origin Table: Owner // a table Destination Table: Parcel // a feature class Relationship Type: Composite Message Direction: ...
2
votes
1answer
110 views

The best practice to join\relate\connect 4 feature class together

What is the The best practice to join\relate\connect communities\UMP\BuiltUP\Admin boundaries, Could you please consider the following scenario: I have a feature class with a name “community “ ...
0
votes
1answer
87 views

copy related table data into a single field in an attribute table

I have a featureclass of cities and a separate table of city administrators (multiple administrators for each city) and related contact info. What I need to do is consolidate all city administrator ...
2
votes
1answer
168 views

Regarding spatial relationships, what is the Dimensionally Extended 9 Intersection Model (DE-9IM)? [duplicate]

In plain English what is the Dimensionally Extended nine-Intersection Model (DE-9IM)? What is the meaning of each row/column in the matrix? How can I use that information to build a relation ...
2
votes
1answer
372 views

Limitations of iterate row selection in ArcGIS ModelBuilder?

inb4 using real script ;), I'm looking for some advice on arc's model builder. The iterate row selection in Arc's model builder allows you to make multiple table views based on field groupings of a ...
2
votes
1answer
215 views

QGIS 2.2.0 Valmiera

One to many joins Unable to export as WKT geometry I'm trying to perform a one-to-many join between a postcode dataset (shapefile) and a csv txt dataset of addresses. I have multiple addresses per ...
0
votes
2answers
82 views

Creating vice versa multipoint feature within ArcGIS for Desktop?

The help says about a multipoint feature: Sometimes, you need to create a feature that has more than one physical part but only references one set of attributes in the database. These are called ...
1
vote
1answer
714 views

One to Many relation in ArcGIS for Desktop?

I'm working on ArcMap, and I have a one to many relation between a building column and the residents in the building. The attribute table for the building has these columns: id,label,number. I ...
5
votes
2answers
1k views

How to set up an ArcMap Relate with a table from MS SQL Server 2012

This is my first time working with data directly from MS SQL Server 2012, and I'm unsure whether I can use it in a Relate in ArcMap. I have a table in MS SQL Server, which I brought into ArcMap via ...
1
vote
0answers
201 views

QGIS Relation Manager

I have a PostgreSQL database with a one-to-many relationship. Here is a reduced example: CREATE TABLE buildings.building ( objectid serial NOT NULL, building_no character varying(40) NOT NULL, ...
0
votes
1answer
71 views

How can I reformat xml data with fme?

I am reading xml data with FME 2014 and attempting to rebuild a relational database model. I have an xml object "element " which has an m:m relationship with object "type". The xml looks like this... ...
3
votes
1answer
404 views

How to build a relational database system with 4 tables in arcgis desktop?

I have been given data from an working online application which consists of a relational model. My aim is to recreate the model using Arcgis Desktop. I have the table "elements" containing Point ...
0
votes
1answer
89 views

Order members of OSM multipolygon relations

Im writing an importer for OSM files. Now i'm importing the relations with multipolygoins. The documentation says The order of the relation members does not matter (but properly sorted member lists ...
0
votes
0answers
413 views

How to select records in a table based on attributes in related table

I am using ArcMap 10.1 and Python I have a list of addresses to geocode, but I want to thin the list because I only need a specific area of the addresses. I have a layer containing the streets in ...
0
votes
1answer
129 views

Layer relations via Python

Is it possible to, through Python, to create the relations that it's possible to create in Layers/Properties/Fields/Relations, and if so how? I first thought these were saved in the styles, but that ...
1
vote
1answer
240 views

Adding XY coordinates from a point feature class to a one to many related table in ArcGIS 10.0

I have a point feature class with a one-to-many relate to a table. I would like to add the XY coordinates of each point in the feature class to the related table where the ID field matches. Of course, ...
0
votes
1answer
60 views

How can I create Multiple joins over 5 tables in ArcGIS?

I have a relational database which uses the following relational schema to create a query: Parcel.IsBooked is joined to Bookinglocation.ID Bookinglocation.IsPartOf is joined to Bookingpage.id ...
3
votes
1answer
57 views

What is the OGC way of representing Related features?

I have a point shapefile of Persons (The point is located at the registered address of the person) and a polygon shapefile of parcels. There is an owner_id attribute in the parcels shapefile, which ...
1
vote
2answers
94 views

Labeling Many-to-many relationships ArcMap 10

please i have Many-to-many relationships in arcMap like : and i want to show labels in parcel using ArcMap 10 : field to show is : Zoning and Name - do you have any idea how to do it ? ...
3
votes
2answers
359 views

How to handle PostgreSql 1:m relationship data by using “Data-Driven Input Mask” QGIS plugin?

I have 1:m relationship tables in my PostgreSql. I like to show the main table attributes as well as the relational table attributes (like grid rows) in QGIS attribute-edit-form. What are the entries ...
0
votes
0answers
33 views

Selecting features through a many-to-one relationship

I want to select multiple counties based on the occurrence of a species present within them. I have a County polygon layer with CountyName as an attribute, a flat table called tblSpCnty with the ...
1
vote
2answers
2k views

How to fill attribute field of one feature based on calculation on attribute field of another feature

I would like to fill an Attribute field of a geodateabase table based on some calculations such as 'sum' over specific field of another Feature class. Is there an Approach to formulate it? while in ...