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
0
votes
0answers
14 views

Can attachments uploaded to a related table in ArcGIS Pro be linked to other points without re-uploading?

I currently am uploading files to point features in ArcGIS Pro, these attachments are stored on a related table which is linked using gobal ID's. Since this linking is 1 to 1 is there anyway around ...
1
vote
1answer
14 views

Splitting lines: Options for managing IDs and related records

I have roads in a feature class (Oracle 10.3 geodatabase). Roads are split into separate lines where they intersect. This is an established business rule that cannot be changed. Each road has ...
1
vote
0answers
16 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 ...
0
votes
0answers
10 views

Appending site ID from feature class to related table in ArcGIS Online?

I have a hosted feature class in ArcGIS Online with two related tables. Users view the data through a web app. The feature class contains data equivalent to "Site ID". The users are most interested in ...
0
votes
0answers
20 views

Keeping temporal data in separate tables using ArcGIS Pro?

I am trying to set up a temporal layer as outlined here (Note, I'm using ArcGIS Pro instead of ArcMap): http://desktop.arcgis.com/en/arcmap/10.3/map/time/temporal-data-in-separate-tables.htm My data ...
2
votes
0answers
36 views

Possible bottleneck in QGIS 1:n relation?

I've set up a 1:n relation linking two layers of the same geopackage. That are about 200k polygons in parcels and 700k rows in owners (non spatial). Now it works as expected but it is painstakingly ...
1
vote
0answers
27 views

Creating ArcGIS Online webapp builder Cemetery search?

I created an ArcGIS Online webapp builder app for a cemetery project. I loaded a relationship class into ArcGIS Online that relates plot polygons to a table of interred individuals. It is a 1 to many ...
0
votes
1answer
35 views

Creating relationship class for many to many relationship

In Arcmap 10.7, I am trying to set up a relationship class that will link parcels to owners. The end goal is to be able select a parcel and see the owner, or multiple owners associated with it. Some ...
0
votes
1answer
32 views

1:n relations in label expressions & general syntax

I've got a colleague who wants to create a (concatenated) label based on a 1:n relation between some shapes and related tables. They asked me if this was possible in QGIS - and I think it should. I ...
4
votes
1answer
72 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 ...
0
votes
0answers
19 views

Related tables responding contextually to features when using ArcGIS Collector

I'm looking for the best way to design data for use in ArcGIS Collector as a means of inspecting infrastructure. The infrastructure can be limited to a handful of points, but the criteria for each ...
0
votes
0answers
49 views

ArcGIS Online popup displaying one to many relationship?

I'm using ArcGIS Online to create an inventory of Mobile Home Communities in a particular geographic region. I'm simply using the Edit tool to 'draw' a polygon around the perimeter of the community ...
0
votes
2answers
90 views

Displaying attribute value from related layer in QGIS Atlas?

I work on QGIS 3.4.4 Madeira. I have two related layers in my project :"towns" (polygon) and "interest points" (points), the common field is "town name". In the Atlas, my cover layer is "towns". I ...
2
votes
1answer
54 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 ...
3
votes
1answer
181 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 ...
2
votes
1answer
259 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 ...
0
votes
0answers
222 views

Web AppBuilder: configure pop up to show fields in related table using “custom attribute display”

I'm looking to configure a pop up that includes both field values from the layer being configured and field values from related tables. Relationship classes have been established between the layer ...
0
votes
1answer
55 views

How to push objectIds' array to RelationshipQuery's object in ArcGIS API JavaScript 4.9?

I need to push array of the object IDs to RelationshipQuery's object using executeForIds that generates the array. I also used executeRelationshipQuery that executes the query. I don't not why, but ...
1
vote
1answer
39 views

Copying attributed relationship with ArcPy?

Is there a way using arcpy to copy an attributed relationship and only the attributed relationship ? I can recreate a non attributed relationship with: arcpy.CreateRelationshipClass_management(arg1,...
2
votes
3answers
297 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 ...
0
votes
0answers
26 views

Showing joined and related non-spatial tables in feature forms

I have a polygon layer that is joined via a 1-to-1 relationship with an Access table (table A), and the access table is related via a 1-to-many relationship to another Access table (table B). When ...
1
vote
0answers
40 views

Best way to relate PostgreSQL table to layer [closed]

There is an online PostgreSQL database (non-spatial) with water monitoring data which is regularly being updated, in another side is a spatial layer of rivers (for example) which should be represented ...
2
votes
1answer
42 views

Transfer geometry from shapefile to related table?

We would like to contact our volunteers based on their geographic location. We settled on zip codes as a reasonable proxy for location, and now have a table with volunteer contact information and zip ...
0
votes
1answer
401 views

How to display related records in popup using ArcGIS Javascript API?

I am attempting to display related fields in a popup window. I've created a GraphicsLayer, consisting of features from the results of a QueryTask. Upon adding the features to the GraphicsLayer, I am ...
0
votes
1answer
223 views

Taking data from related table and populating feature attribute table in ArcGIS Desktop?

Our forester wants trees symbolized red if they haven't been trimmed, green if they've been trimmed. Trimming info is maintained in the Tree_Maint table, which is a one to many related table to our ...
0
votes
1answer
62 views

Making maps with geodatabase? [closed]

For my master’s thesis I’m using ArcMap to create maps based on a large historical dataset. I’m mapping individual movements over long periods of time. I’m struggling to design the database and figure ...
1
vote
2answers
77 views

Selective attributes not displaying in GeoCortex Essential Manager

I'm having trouble with Geocortex Essential Manager displaying the full set of attributes for a particular feature. Specifically, I have a parcels dataset and 4 related tables. I recently added a new ...
0
votes
0answers
71 views

Generating Mapbook with Dynamic Text based on Attributes from Related Table?

I have a series of individual parcels with multiple soil sample points on each parcel. I need a way to communicate the soil sample information to the landowners. There are about 500 parcels so I need ...
1
vote
0answers
61 views

Change polygon color over time by number of events in polygon

In ArcGIS Desktop 10.5.1, I have a layer of XY events with a date field, and a layer of polygons. I have spatial joined the points so that each event is associated with a polygon. I want to show the ...
1
vote
0answers
75 views

Symbology based on related table ArcMap10.5

I have a parcels layer and related table of water meters. I did labeling of water meters IDs and I pulled it from the related table through the script. Can I symbolize polygons based on related table ...
1
vote
1answer
86 views

Passing selection through relates in ArcGIS ModelBuilder?

I have a layer of facilities and a feature that has three related layers (Point, Area, Line). I'm trying to automate extracting data from the Line layer that's related to a selected set of facilities ...
1
vote
0answers
109 views

Creating points from a one to many relationship

I have created a one to many relationship within a geometric shapefile. Is it possible to to create points from the 'many' records in this shapefile as I would like to output the records into a ...
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 ...
1
vote
2answers
335 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 ...
3
votes
0answers
57 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. ...
1
vote
1answer
64 views

Finding all records related to selected records in ArcGIS Desktop using ModelBuilder?

I have two layers that are related. My current manual process is as follow; a. Add the layer 1 to the table of contents b. Open the attribute table then Switch selection to select all layer 1 ...
3
votes
1answer
38 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 ...
0
votes
2answers
94 views

Buffers based on table relationship using ArcGIS Desktop?

I have what seems like a trivial problem, but I can't come up with a solution. So I have two spatial tables (points) - Buildings ~1000 records (addresses; with a common field identifying the builder)...
2
votes
0answers
49 views

qgis One to Many Relationship [duplicate]

When I enter point id 1790 result join is only one input. I won from list all id_gm to be shown in atribute table of layer tacka6. Can this be done in Qgis? Solution https://www.youtube.com/watch?v=...
1
vote
1answer
75 views

Visualise in a map featured from a related table in ArcGIS

I have an attribute table of a shapefile with some related attributes tables linked to the original table. I would like to show in the map through Symbology > Categories > Unique values one of the ...
0
votes
0answers
39 views

ArcGIS 10.3 connecting to spreadsheets

I have feature classes of property parcels that are polygons. My client maintains data about the parcels in a google doc spreadsheet (online) and updates the information regularly. I am required to ...
1
vote
0answers
24 views

Edit a not geometric table via a flow WFS

I want to know if it is possible to modify a non-geometric table via a flow WFS in QGIS. I have a flow WFS in QGIS with a layer connected to a table on which we can add several recordings (relation 1-...
2
votes
1answer
32 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
1answer
94 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
335 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
148 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
311 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
273 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
391 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 ...