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
11
votes
6
answers
16k
views
Creating duplicate features based on many-to-one conversion of related table?
I need to create duplicate features (in this case parcels), using a related table to populate ID fields. In essence, I need to use a related table of parcel owners to create duplicate parcels, each ...
- 161
8
votes
1
answer
1k
views
Automatically display related records for selected feature in tablewindow with ArcObjects
Is there a way through ArcObjects to automatically display the related table(s) for the selected feature in ArcMap in the attribute window (tablewindow) without the user having to click on it and ...
- 81
7
votes
2
answers
3k
views
How to set up an ArcMap Relate with a table from MS SQL Server 2012
This is my first time working with data directly from MS SQL Server 2012, and I'm unsure whether I can use it in a Relate in ArcMap.
I have a table in MS SQL Server, which I brought into ArcMap via ...
- 20.9k
7
votes
1
answer
3k
views
Summing Attributes from a Related Table?
I have a line feature class representing road segments, with each road segment having a unique ID. This feature class has an attribute of average observed daily traffic counts. I have another table ...
- 8,238
6
votes
1
answer
1k
views
in QGIS how to add (join?) another table to a layer
Very new so bear with me. I have QGIS loaded with a TIGER/Line Shapefile at the Block level for a County, and need to join other detailed CENSUS data various tables (which also have a Block ID to ...
- 319
6
votes
1
answer
265
views
What is the OGC way of representing Related features?
I have a point shapefile of Persons (The point is located at the registered address of the person) and a polygon shapefile of parcels.
There is an owner_id attribute in the parcels shapefile, which ...
- 40.8k
6
votes
1
answer
2k
views
ArcGIS JS API Relationship Queries
Has anyone ever put the results of a RelationshipQuery() into a map.infoWindow that's been replaced with a dijit.popup?
Here's the workflow:
User clicks a point, and all identify results are put ...
- 223
5
votes
1
answer
485
views
How to build query expression to display text from one-to-many relationship in ArcMap?
I have two tables in an enterprise geodatabase stored in PostgreSQL and accessed via ArcSDE:
parcel and person
1 or + parcel can have 1 or + person (relationship is pll_person)
I can display all ...
- 615
5
votes
4
answers
3k
views
How to Join two feature classes without common attribute
I have two shapefiles of essentially the same objects however, one shapefile has terrible spatial data but great attribute data and the other is the reverse. What I'm looking to do is essentially a ...
- 137
4
votes
4
answers
4k
views
Querying through Relations
Right now I am stumped on how to get two layers to interact. I have one layer that is just a map with town borders, with attributes for town codes. My other layer are data for businesses, wages for ...
- 87
4
votes
1
answer
2k
views
How to relate Non-Spatial table to Spatial table in two different Postgis DBs?
I need to relate a Non-spatial table to Spatial table, but both are in different database.
Spatial_table(dbname:dist)
gid
district_name
district_code
geom
Non_Spatial(dbname:census)
ID
...
- 504
4
votes
2
answers
688
views
How to handle PostgreSql 1:m relationship data by using “Data-Driven Input Mask” QGIS plugin?
I have 1:m relationship tables in my PostgreSql. I like to show the main table attributes as well as the relational table attributes (like grid rows) in QGIS attribute-edit-form.
What are the entries ...
- 495
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
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
4
votes
2
answers
4k
views
One-to-Many table relate viewed through ArcGIS Server
I want to create a Table Relate with a one-to-many relationship between a layer and a non-spatial table based on a common field.
My question is, if I publish this data to ArcGIS Server, will an ...
- 3,478
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
4
votes
1
answer
1k
views
Show relations in HTML popup in ArcMap
Is it possible to include information about relations in the HTML popup in ArcMap?
I have two tables, one with points (Columns: ID, Name) and one with events about those points (Columns: PointID, ...
- 495
4
votes
0
answers
163
views
One-to-many labels in QGIS [closed]
The one-to-many relations in QGIS is OK with forms, works great.
But how to labels or chart data with this one-to-many relations?
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 ...
3
votes
2
answers
134
views
Building a WFS whose features hold lists of records
I've got two tables in a PostgreSQL/PostGIS database:
UTM (geom geometry(Polygon,25830),utmcode character varying(6))
Species (species_name character varying(50), utmcode character varying(6), ...
- 3,000
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
1
answer
101
views
Can a Relate within an MXD be detected programmatically using ArcPy?
I would like to know if it is possible detect relates in an MXD using arcpy.
Similar problem as the question below, but for relates instead of joins.
Detecting Join programmatically using ArcPy?
...
- 1,831
3
votes
1
answer
193
views
Showing multiple burials in same grave for Cemetery GIS?
I am an intern creating a Geodatabase for a municipal cemetery.
The one lot can hold up to 3 people (2 people, 1 cremation) two people at the most.
How would I show that information on the map ...
- 31
3
votes
2
answers
117
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 ...
- 31
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 ...
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
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
3
votes
1
answer
214
views
Failed attempt to relate a .csv file of 400 records to a single record in a point data layer
I have the Provincial Groundwater Monitoring Network as a point feature of 39 monitoring wells which includes an attribute for WELL ID. Each monitoring well then has a corresponding .csv file with 400 ...
- 31
3
votes
1
answer
301
views
Adding table to ArcGIS MapServer so layers and tables can be associated?
I'd like to add tables to my MapServer. I want it to include both feature layers and tables which enables me to associate the layers with the relevant tables and retrieving the necessary fields of the ...
- 87
3
votes
1
answer
427
views
Get Attributes from 1:n relation in QGIS as Expression to use in Atlas
I need to set up way signs for something like a "hiking-GIS". In the first step I made a network analysis (using QNEAT3) to find the distance from the signs ("Way Signs") to the available destinations ...
- 8,137
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
3
votes
1
answer
1k
views
Add/Remove Relate using ArcPy without ArcGIS Pro?
I am trying to add a relate between 2 feature classes so that I can use the area of the related table to update a field in the original table.
I found that ArcGIS Pro (http://pro.arcgis.com/en/pro-...
- 379
3
votes
1
answer
2k
views
How to build a relational database system with 4 tables in arcgis desktop?
I have been given data from an working online application which consists of a relational model. My aim is to recreate the model using Arcgis Desktop.
I have the table "elements" containing Point ...
- 10.1k
3
votes
1
answer
258
views
Does QGIS preserve Feature Class Relationships (1to1 or 1to many or Many to many relationships)?
Does QGIS preserve Feature Class Relationships (1to1 or 1to many or Many to many relationships) and can the related attributes be clicked and viewed through the identify feature tool?
- 31
3
votes
0
answers
148
views
Enforce that all "Enforce expression constraints" of child tables are valid before I can save the parent feature
In QGIS 3.16 I set up a relation between two tables.
In the child-table I set a constraint-expression and checked "Enforce expression constraints".
If I add one or more features to the child-...
- 541
3
votes
0
answers
165
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 ...
- 14.3k
3
votes
0
answers
149
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
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 ...
2
votes
2
answers
657
views
Joining table to feature class based on two or more fields using ArcMap
I have a table and I would like to join it to a polygon feature class but based on two columns. As in if the polygon has the same values in in column A and column B it will join. If the table has the ...
- 109
2
votes
1
answer
1k
views
Regarding spatial relationships, what is the Dimensionally Extended 9 Intersection Model (DE-9IM)? [duplicate]
In plain English what is the Dimensionally Extended nine-Intersection Model (DE-9IM)?
What is the meaning of each row/column in the matrix?
How can I use that information to build a relation matrix?...
- 11.4k
2
votes
2
answers
639
views
Using ArcPy search cursor to relate .csv and .shp
I am using ArcMap 10.6.1.
I'm trying to write a script that relates data from a .csv file to a utility pole shape file. Basically, we want the script to iterate through the pole # fields in each table ...
- 67
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
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
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
2
votes
1
answer
249
views
Joining\relating\connecting 4 feature class together?
How can I join\relate\connect communities\UMP\BuiltUP\Admin boundaries?
Could you please consider the following scenario:
I have a feature class with a name “community “ which I consider it the main ...
- 1,044
2
votes
2
answers
2k
views
Performing relate in ModelBuilder for one to many relationship?
I'm not sure how to do this as I don't' think there are any ModelBuilder tools for this task. I'm not real savvy with Python but basically I want to relate field1 in table A to field2 in table B with ...
- 721
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
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
1k
views
Limitations of iterate row selection in ArcGIS ModelBuilder?
inb4 using real script ;), I'm looking for some advice on arc's model builder.
The iterate row selection in Arc's model builder allows you to make multiple table views based on field groupings of a ...
- 65
2
votes
1
answer
183
views
Automatically changing field entry in related table when entering it in feature class?
I am working to try and develop a code or process that I can run that will allow me to automatically change an XY field in a related table when I change an associated XY field. Let me explain our ...
- 21