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
0answers
29 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
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
50 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
43 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
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 ...
1
vote
1answer
30 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 ...
1
vote
1answer
54 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
60 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
54 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
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
1answer
55 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
34 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
96 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
32 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
50 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
63 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
25 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
43 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
43 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
39 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
63 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
75 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
68 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
22 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
101 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
265 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
164 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
74 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
53 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
261 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
672 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
173 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
46 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
231 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
67 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
196 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
107 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
179 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
47 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
85 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
300 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
402 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
272 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
99 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
323 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
310 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
98 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 ...