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
2
votes
1answer
110 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
416 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 ...
1
vote
1answer
160 views

Searching Related Tables in ArcGIS Online

The point of this project is to find the deceased's name in a cemetery so the public can find them easily. I have uploaded a shapefile of cemetery lots and a table of lot occupants (so I did a 1:Many ...
0
votes
1answer
376 views

Related Tables can be viewed in my webmap but not in Collector

I have a related table set up in an ArcGIS webmap. I can view the related data (1:M) just fine in the webmap. However, when I try to view the related data in Collector, there is nothing there. Is ...
2
votes
2answers
347 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 ...
-1
votes
1answer
455 views

ArcGIS Online Nonspatial Data [closed]

How is nonspatial data managed in ArcGIS Online? If I have a table that is not part of a join or relate, but standalone, can I edit it on a map? In collector? Through REST? It appears the only way to ...
1
vote
2answers
2k views

Performing Definition Query Based on Related Table?

I have a point dataset (SDE Feature Class) of locations in a city that receive inspections. I also have a table of data (File GeoDatabase Table) where there are many inspections for each point. I have ...
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-...
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 ...
1
vote
0answers
282 views

QGIS use relations in expressions (for symbol and print composer)

I have a shapefile layer a relation linking data from a csv file. This is a one to many relationship where a parcel could have multiple entries from the csv. How do I reference that data in ...
2
votes
0answers
104 views

Filtering on relate using ArcGIS Pro? [closed]

I've created a relate in ArcGIS Pro - joined a shape layer to a table on a key. ArcGIS Pro says it has gone through okay, and when I click on a feature I can go down into the information displayed and ...
0
votes
1answer
183 views

ArcGIS: Compare 'similar' values between multiple tables

I'm looking to see if there's some code out there I can manipulate, or if I can utilize a model to essentially compare field values between 3 or more tables. The two issues here are I have to ...
2
votes
0answers
81 views

Selecting rows of attributed relationship class (intermediate table) using relate table function [closed]

I have 2 classes: Owners Properties And 1 relation class (M-N) attributted In my ArcMAP (10.3.1) the intermediate table doesn't appear automatically (The table of relationed class appear). If I ...
1
vote
0answers
156 views

Symbology Collector app with related tables

I’m trying to make a collector layer with related tables. The symbology of feature class must be someting like: if {relatedtable.waarnemingen}date + 30 = Current_date() green dot, else red dot. I ...
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 ...
0
votes
1answer
43 views

How to link two rows in attribute table to the same polygon? [closed]

There are two rows in an attribute table. I want to link both rows to the same polygon. How can I do this?
2
votes
1answer
396 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
570 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 ...
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 ...
0
votes
1answer
207 views

Identifying the closest polygon to a point dataset

I have two large data sets one point and one polygon. What I was looking to do was identify which polygon is closest to each point. Hopefully I was looking for a automated process as the point data ...
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? ...
0
votes
1answer
119 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?
6
votes
1answer
763 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 ...
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 ...
-1
votes
2answers
3k views

Pop-up window for a related layer doesn't show the right values in ArcGIS online [duplicate]

In my ArcGIS online map, I have two layers (morminte and layer2) related in a one-to-many relationship. For an item from the morminte layer I can have 0, one or two corresponding values from layer2. ...
3
votes
1answer
653 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-...
0
votes
1answer
67 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
128 views

Automate multiple repetitive ArcGIS 10.2 Table Relates? [closed]

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 ...
1
vote
1answer
220 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 ...
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 ...
1
vote
1answer
683 views

Exporting contents of 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 ...
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 ...
0
votes
1answer
1k 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
269 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 ...
4
votes
1answer
984 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
258 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 ...
1
vote
1answer
191 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
143 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: http://www....
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
632 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
62 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 can't ...
1
vote
0answers
125 views

Plot Multiple Series from Related Table in One Chart [closed]

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
648 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 ...
1
vote
1answer
122 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 ...
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
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 ...
1
vote
1answer
166 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
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 ...
0
votes
1answer
311 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
774 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?...