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.
168
questions
4
votes
1
answer
418
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 ...
- 14.3k
1
vote
2
answers
1k
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 ...
- 19
2
votes
1
answer
169
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 ...
- 29
4
votes
1
answer
1k
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 ...
- 41
3
votes
1
answer
1k
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
1
answer
153
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 ...
- 143
1
vote
1
answer
82
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,...
- 1,674
3
votes
3
answers
1k
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 ...
1
vote
0
answers
102
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
1
answer
120
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 ...
- 23
1
vote
1
answer
989
views
Displaying 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 ...
- 5,757
1
vote
1
answer
2k
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 ...
- 41
0
votes
1
answer
81
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 ...
- 129
1
vote
2
answers
186
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 ...
- 29
0
votes
0
answers
107
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 ...
- 91
1
vote
0
answers
99
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
1
answer
105
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 ...
- 11
1
vote
1
answer
316
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 ...
- 31
1
vote
0
answers
124
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 ...
3
votes
2
answers
3k
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 ...
- 41
2
votes
2
answers
1k
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 ...
- 203
3
votes
0
answers
148
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. ...
- 43
0
votes
1
answer
491
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 ...
- 5
3
votes
1
answer
47
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 ...
- 41
0
votes
2
answers
106
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)...
- 651
2
votes
0
answers
58
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=...
- 29
1
vote
1
answer
201
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 ...
- 25
0
votes
0
answers
50
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 ...
- 315
1
vote
0
answers
25
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
1
answer
53
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 ...
- 175
2
votes
1
answer
132
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
1
answer
611
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
1
answer
236
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 ...
- 65
1
vote
1
answer
568
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 ...
- 152
2
votes
2
answers
539
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,387
-1
votes
1
answer
660
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,300
3
votes
3
answers
4k
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 ...
- 31
3
votes
2
answers
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-...
- 140
2
votes
1
answer
55
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
...
- 29
1
vote
0
answers
448
views
QGIS use relations in expressions (for symbol and print composer) [closed]
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 ...
- 1,565
2
votes
0
answers
148
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 ...
- 852
0
votes
1
answer
252
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 ...
- 117
2
votes
0
answers
92
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 ...
- 31
1
vote
0
answers
162
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 ...
- 73
2
votes
1
answer
2k
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
1
answer
44
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?
- 1
2
votes
1
answer
734
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 ...
- 21
2
votes
1
answer
952
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 ...
- 140
4
votes
1
answer
2k
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 ...
- 941
0
votes
1
answer
230
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 ...
- 11