Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

0
votes
1answer
29 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 ...
5
votes
1answer
63 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
18 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
30 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
56 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
40 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
123 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
175 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
138 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
41 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
33 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
235 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
25 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
37 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
38 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
0answers
18 views

Enable time in related tables on ArcGIS Pro

Is there an option for user to enable time in related tables, then make a relationship class with another layer? Example: Tables I have: 1) Tax report from 2016 Parcel number, Tax revenue, year 1,...
0
votes
1answer
333 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
161 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
66 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
64 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
59 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
73 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
73 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
105 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
847 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
1answer
292 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
51 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
56 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
48 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
66 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
38 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
31 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 ...
3
votes
1answer
82 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
301 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
145 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
268 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
238 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
368 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 ...
4
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
45 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
230 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
85 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
151 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
67 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
154 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 ...