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
1
vote
0answers
197 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, ...
1
vote
1answer
24 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
45 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

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 ...
1
vote
0answers
71 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
87 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
116 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
1answer
126 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 ...
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
322 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
159 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
129 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
240 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 ...
1
vote
0answers
128 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
0answers
339 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
131 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?
0
votes
2answers
100 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)...
0
votes
2answers
4k 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. ...
0
votes
1answer
316 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
66 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 ...
0
votes
1answer
75 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 ...
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?
0
votes
1answer
68 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 ...
0
votes
1answer
149 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....
0
votes
1answer
367 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 ...
0
votes
1answer
90 views

How I can make a child table appear in the parent table of attributes in QGIS?

I used "relate" to connect a many to one child table to a parent table (addresses to land parcels, one parcel can have several parcels) and I see it in the "form view but it is not ...
0
votes
1answer
17 views

How to join/relate points to polygons by field

I am using ArcMap with a basic license. I have a layer of polygon parcels and a layer of point turnouts. The turnouts deliver water to the parcel, but are not located within the parcel. My parcels ...
0
votes
1answer
28 views

Will my join remove my relate?

I have spatial data that has an existing related table with photo info. I have data from another separate table that I want to join and then field calculate to add to my spatial data, then I would ...
0
votes
1answer
101 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 ...
0
votes
1answer
193 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 ...
0
votes
1answer
213 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 ...
0
votes
1answer
223 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 ...
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 ...
0
votes
1answer
221 views

How can I reformat xml data with fme?

I am reading xml data with FME 2014 and attempting to rebuild a relational database model. I have an xml object "element " which has an m:m relationship with object "type". The xml looks like this... ...
0
votes
0answers
32 views

Combining fields from different related tables to configure an ArcGIS Field Maps Form

I am trying to create forms for field data collection in ArcGIS Field Maps. I have four different related tables which are related to four different feature layers. I would like to create one form ...
0
votes
0answers
16 views

Making one-to-many polygon interactive map using ArcGIS Pro

I have a polygon shapefile of all war zone. Each war zone has a list of allies and rivals. In which case it is a one-to-many relationship. The goal is to make an interactive map that will allow you to ...
0
votes
1answer
46 views

Performing many to one join in QGIS

I have read https://docs.qgis.org/2.18/en/docs/user_manual/working_with_vector/attribute_table.html#creating-one-or-many-to-many-relations and also many to one join in QGIS but I can't seem to be able ...
0
votes
0answers
36 views

Relationship Class Table displays empty table

I'm trying to link 2 tables together using relationship classes (pre-defined within this datamodel). I've uploaded a picture which might be clearer, but here is the process I'm trying: Table named ...
0
votes
0answers
25 views

How best to relate historical testing data to a shapefile?

I am tasked with bringing what has historically been only tracked in Excel into a shapefile. I am using ArcMap, but also have QGIS installed on my computer What these shapefiles will include is ...
0
votes
1answer
38 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
1answer
682 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
86 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
41 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
253 views

Order members of OSM multipolygon relations

Im writing an importer for OSM files. Now i'm importing the relations with multipolygoins. The documentation says The order of the relation members does not matter (but properly sorted member lists ...
0
votes
1answer
892 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 ...
-1
votes
1answer
537 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 2
3