Questions tagged [relates]

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

Filter by
Sorted by
Tagged with
11
votes
6answers
14k views

Creating duplicate features based on many-to-one conversion of related table?

I need to create duplicate features (in this case parcels), using a related table to populate ID fields. In essence, I need to use a related table of parcel owners to create duplicate parcels, each ...
8
votes
1answer
1k views

Automatically display related records for selected feature in tablewindow with ArcObjects

Is there a way through ArcObjects to automatically display the related table(s) for the selected feature in ArcMap in the attribute window (tablewindow) without the user having to click on it and ...
7
votes
2answers
3k 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 ...
7
votes
1answer
2k views

Summing Attributes from a Related Table?

I have a line feature class representing road segments, with each road segment having a unique ID. This feature class has an attribute of average observed daily traffic counts. I have another table ...
6
votes
1answer
761 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 ...
6
votes
1answer
214 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 ...
6
votes
1answer
2k views

ArcGIS JS API Relationship Queries

Has anyone ever put the results of a RelationshipQuery() into a map.infoWindow that's been replaced with a dijit.popup? Here's the workflow: User clicks a point, and all identify results are put ...
5
votes
1answer
449 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 ...
5
votes
4answers
2k 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 ...
4
votes
2answers
622 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 ...
4
votes
1answer
2k views

How to relate Non-Spatial table to Spatial table in two different Postgis DBs?

I need to relate a Non-spatial table to Spatial table, but both are in different database. Spatial_table(dbname:dist) gid district_name district_code geom Non_Spatial(dbname:census) ID ...
4
votes
2answers
4k views

One-to-Many table relate viewed through ArcGIS Server

I want to create a Table Relate with a one-to-many relationship between a layer and a non-spatial table based on a common field. My question is, if I publish this data to ArcGIS Server, will an ...
4
votes
1answer
113 views

Labeling polygons with the number of related table entries in QGIS

Using QGIS 3.6.1 I have a layer with areas and a table with entries related to the areas: A relation is defined like this: What I would like to achieve is to label the areas with the number of ...
4
votes
1answer
982 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, ...
3
votes
4answers
3k 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 ...
3
votes
1answer
418 views

Selecting through one-to-many relationship

I'm trying to make a species distribution project where I can select a species from a non-spatial list of species and the selection would highlight (select) all the counties to which the species has ...
3
votes
1answer
84 views

Can a Relate within an MXD be detected programmatically using ArcPy?

I would like to know if it is possible detect relates in an MXD using arcpy. Similar problem as the question below, but for relates instead of joins. Detecting Join programmatically using ArcPy? ...
3
votes
1answer
175 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 ...
3
votes
2answers
2k views

Creating a Collector map that allows new records to be added to a related table while not allowing spatial features to be created or deleted?

I am trying to create inspection maps for Collector that are very similar to what can be found at this link: https://blogs.esri.com/esri/arcgis/2015/02/18/related-tables-exploring-new-ways-to-use-...
3
votes
1answer
1k views

QGIS managing relationships

Coming from an ESRI background I'm used to ESRI geodatabases (.mdb or .gdb). In those databases, I could create feature classes, tables and relationships between them. Every time I loaded a feature ...
3
votes
1answer
209 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 ...
3
votes
1answer
292 views

Adding table to ArcGIS MapServer so layers and tables can be associated?

I'd like to add tables to my MapServer. I want it to include both feature layers and tables which enables me to associate the layers with the relevant tables and retrieving the necessary fields of the ...
3
votes
1answer
73 views

Get Attributes from 1:n relation in QGIS as Expression to use in Atlas

I need to set up way signs for something like a "hiking-GIS". In the first step I made a network analysis (using QNEAT3) to find the distance from the signs ("Way Signs") to the available destinations ...
3
votes
1answer
39 views

Display records on map from SQL Statement across a relate

I'm using ArcMap and I have a One-to-Many relate between two tables, one table contains polygons, and the other has additional data. Multiple records in the additional data table relate to a single ...
3
votes
1answer
648 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 (http://pro.arcgis.com/en/pro-...
3
votes
1answer
1k 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 ...
3
votes
1answer
234 views

Does QGIS preserve Feature Class Relationships (1to1 or 1to many or Many to many relationships)?

Does QGIS preserve Feature Class Relationships (1to1 or 1to many or Many to many relationships) and can the related attributes be clicked and viewed through the identify feature tool?
3
votes
0answers
43 views

QGIS 3 embedded forms - zoom or pan to child features

I have two tables and a relation defined on them via an 'in-between-table' (many-to-many relationship) like this: This gives me nice embedded forms like shown below: What I would like to achieve is ...
3
votes
0answers
72 views

Copy features with their related tables [closed]

I have two file geodatabases with identical schema that have a feature class and four related tables. I need to copy features from one to the other with the information from all of the related tables. ...
3
votes
0answers
138 views

QGIS one-to-many labels [closed]

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?
2
votes
3answers
446 views

QGIS: relations in label expressions

In my project I have a many-to-one relationship. For example I have a vector layer "Towns" and a data layer "TownsInfo". Each town record consists of "Name" and "Id". Each TownsInfo record consist ...
2
votes
1answer
1k views

Relating shapefile to excel table in ArcMap?

I have successfully joined a point shapefile to .CSV file in ArcMap 10.0, and the type of the fields which are related in the two files are the same(text, length:255). But when I remove join and ...
2
votes
1answer
773 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 matrix?...
2
votes
1answer
36 views

many-to-many relate on two polygon layers in ArcMap?

I'm using ArcMap 10.3. (Fairly new to GIS in general!) I have two polygon shapefiles - school district and council districts - where the polygons overlap irregularly (meaning a school district can ...
2
votes
2answers
342 views

Copy and paste values from selected features to a table in ArcMap?

I am trying to find a more efficient way to select features from a polygon feature class and copy over their GUIDs to a separate table in ArcMap. I have a layer of pavement polygons and I would like ...
2
votes
1answer
564 views

Auto populating field in attribute table, using several fields of record information from another table?

I have an attribute table with one field that needs to be populated, but because there are thousands of records, I would like to know a way that it can be done somewhat automatically. The information ...
2
votes
1answer
239 views

Joining\relating\connecting 4 feature class together?

How can I join\relate\connect communities\UMP\BuiltUP\Admin boundaries? Could you please consider the following scenario: I have a feature class with a name “community “ which I consider it the ...
2
votes
2answers
1k views

One-to-Many Spatial Join in QGIS

I am trying to join attributes from 2 shapefiles. 1 shapefile is a polygon layer indicating police precincts and the second is a point layer with crime statistics for each police station. The police ...
2
votes
2answers
482 views

Feature Service related table not showing up in Survey 123 form

Using Arcmap 10.3.1 I have published a featured service using My Hosted Services with a related table. I have confirmed the relation was working before publishing the service and can see the related ...
2
votes
1answer
393 views

Populating Fields in Table with GUIDs from Feature Class?

Is there a way to add GUIDs from a feature class to a table based on specific attributes? I have a large maintenance record table that is tied to specific points through the GUID of that point. I have ...
2
votes
1answer
1k 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
2answers
1k views

Performing relate in ModelBuilder for one to many relationship?

I'm not sure how to do this as I don't' think there are any ModelBuilder tools for this task. I'm not real savvy with Python but basically I want to relate field1 in table A to field2 in table B with ...
2
votes
1answer
66 views

What differences exist between relates and relationship class in a geodatabase? [closed]

I am doing a project for my class and I was just wondering what differences exist between relates and relationship class in a geodatabase? And why and when would you use a relationship class over a ...
2
votes
1answer
408 views

Exporting one to many relation in QGIS to new shapefile?

I am using QGIS 3.4.1-Madeira. I have a base layer map that represents areas as polygons. I have created a CSV file with many entries of different NGO projects, and each one is coded with the ID of ...
2
votes
1answer
109 views

Identifying attributes from related tables

I've created a relationship class and created a 1-m relationship between my feature class and table. When identifying the results in ArcGIS 10.2 it returns the details using the "OBJECTID" field. Is ...
2
votes
1answer
411 views

Filtering CSV layer attribute table in QGIS Print Composer?

I have a Map content with attribute table and a related attribute csv table, linked with a common field. When preparing a printing table I'd like to add both tables to my layout, filtering them with ...
2
votes
1answer
48 views

Relating a table to a point layers and exporting results in model builder?

Here are the data that I'm working with: Table: Standalone table from an OLE DB connection with a MS Access db 10,800 records with non-distinct account IDs Divided into 300 different categories ...
2
votes
1answer
152 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 ...
2
votes
1answer
631 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 ...
2
votes
1answer
70 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 ...