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)

1
vote
1answer
35 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
39 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
45 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
37 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
53 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
32 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
71 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
28 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
40 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
53 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
24 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
38 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
37 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
35 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
56 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
64 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
64 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 ...
0
votes
0answers
18 views

Appending data from relate into single attribute table row using ArcGIS for Desktop?

I have a featureclass of cities and a separate table of city administrators and related contact info. What I need to do is consolidate all city administrator info into the attribute table of the ...
1
vote
1answer
87 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
217 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
141 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
70 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 ...
0
votes
0answers
48 views

How to access data from a table that has been related?

I have a data driven page table that I am trying to associate with route line data. The object of this exercise is to print the associated data on the data driven page AS or LIKE a data driven page ...
1
vote
1answer
186 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 ...
4
votes
2answers
548 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
153 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
41 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
191 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
62 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
153 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
100 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
151 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
57 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
42 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
81 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
283 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
30 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
1k 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 ...
1
vote
3answers
357 views

Table Relate Spatial and Tabular data in QGIS 2.0

I am self taught in GIS, so I apologize ahead of time for my noobness. In ArcGIS you have two options to associate data in a table to spatial data. Based upon my understanding, the first is Join ...
5
votes
1answer
251 views

How to build query expression to display text from one-to-many relationship in ArcMap?

I have two tables in an enterprise geodatabase stored in PostgreSQL and accessed via ArcSDE: parcel and person 1 or + parcel can have 1 or + person (relationship is pll_person) I can display all ...
0
votes
0answers
90 views

How do the ADMINx_CODE & FEATURE_CODE fields in Geonames data describe a relationship between records?

I am trying to use Geonames data to augment data which we currently license from an online advertising broker. I want to use Geonames alternate names data to support synonyms of place names. To ...
2
votes
2answers
299 views

SQL Server STRelate equivalent of Oracles SDO_RELATE(…mask=anyinteract)

In Oracle Spatial, we are running checks on a graph. The Check should provide Nodes, which are marked as endnodes (Attribute "EDGEDEGREE" equals 1) but are in fact located somewhere along an edge. We ...
1
vote
1answer
292 views

PostgreSQL/GIS table relations in QGIS 1.8.0

I am building a database in PostgreSQL 9.2 with the PostGIS 2.0 extension. The database consists of a schema called Water which contains water related geographic features (as example, boreholes and ...
1
vote
1answer
97 views

Using IRelationshipClass

I have three feature classes [CircuitSource(A),CircuitBreaker(B),Sub-Station(C)]. In the Geodatabase A and B has a 1:1 relationship based on a primary field namely 'FEEDERID'. C and B has a 1:many ...
0
votes
1answer
118 views

Automatically changing field entry in related table when entering it in feature class?

I am working to try and develop a code or process that I can run that will allow me to automatically change an XY field in a related table when I change an associated XY field. Let me explain our ...
1
vote
0answers
95 views

Copying Features from One ArcMap window to another, without losing Related Tables

In our current workflow we are working in a Personal Geodatabase with few features and related tables , many persons will be working in different schemes. When we need to merge these schemes\Pgdb to ...
3
votes
1answer
188 views

Failed attempt to relate a .csv file of 400 records to a single record in a point data layer

I have the Provincial Groundwater Monitoring Network as a point feature of 39 monitoring wells which includes an attribute for WELL ID. Each monitoring well then has a corresponding .csv file with 400 ...
1
vote
2answers
287 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 ...
1
vote
2answers
1k views

One Polygon Joining to Database with Many matching records

Using ArcMap 10.1. Is this possible to have one polygon and join to a database/excel with many matching records? I would like to have 1 polygon but match to 100 corresponding records in a table. When ...
0
votes
0answers
113 views

Silverlight chart binded to a related table service

I am new to programming - I am using Silverlight 4.0 with ESRI API 2.4. I would like to do the following: Create a chart on a popup/maptip/infowindow when the user click on the feature in the web ...