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.

27 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
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 ...
2
votes
0answers
46 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 ...
2
votes
0answers
124 views

Copying Features from One ArcMap window to another, without losing Related Tables

In our current workflow we are working in a Personal Geodatabase with few features and related tables , many persons will be working in different schemes. When we need to merge these schemes\Pgdb to ...
1
vote
2answers
35 views

Performing one-to-many join with address and crime data using ArcMap

Goal: I want to show the police calls coming from a parcel on ArcMap. So if you click on the parcel, it will show all the calls for the year. I want to join the address attribute from the parcel data ...
1
vote
0answers
20 views

Making chart with related table using ArcGIS Pro

I have a feature class with some locations of drills. I also have a table with data how deep the drill went and some more technical data in it. I used relate on the feature class to connect the ...
1
vote
0answers
21 views

n:m relations of lines including directions

For trail planning and route signalization projects, I am looking for a solutions which allows me to connect "physical" trail segments (available as .gdb from authorities) with overlaying routes, ...
1
vote
0answers
20 views

Joining my spreadsheet data to my geodatabase file is not including all matching records

I have a map with roads, trails, and site gdb layers, and I have an Excel spreadsheet that I have imported with a list of the permitted companies for each of the designated roads and trails. I would ...
1
vote
1answer
20 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
37 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 ...
1
vote
0answers
63 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
81 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
0answers
114 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 ...
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-...
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 ...
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 ...
1
vote
0answers
332 views

QGIS Relation Manager

I have a PostgreSQL database with a one-to-many relationship. Here is a reduced example: CREATE TABLE buildings.building ( objectid serial NOT NULL, building_no character varying(40) NOT NULL, ...
0
votes
1answer
29 views

Finding point from Layer B that matches point from Layer A using search radius

I have two point shapefiles of trees from two different surveys. I want to verify if data from Survey A matches data from Survey B. I want to create a search radius of 10m around each tree from ...
0
votes
0answers
55 views

Using related records added on Collector (for ArcGIS) to update original feature class values and symbology

I currently use Collector for ArcGIS to carry out tree inspections. The design consists of two parts - a feature class layer which contains a point for each tree including data such as its species, ...
0
votes
0answers
29 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 ...
0
votes
0answers
15 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
26 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 ...
0
votes
0answers
21 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
117 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
1answer
535 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
0answers
78 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 ...
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 ...
0
votes
1answer
459 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 ...