The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
1answer
58 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
19 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
1answer
29 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
66 views

Layer relations via Python

Is it possible to, through Python, to create the relations that it's possible to create in Layers/Properties/Fields/Relations, and if so how? I first thought these were saved in the styles, but that ...
0
votes
1answer
53 views

How can I create Multiple joins over 5 tables in ArcGIS?

I have a relational database which uses the following relational schema to create a query: Parcel.IsBooked is joined to Bookinglocation.ID Bookinglocation.IsPartOf is joined to Bookingpage.id ...
1
vote
2answers
58 views

Labeling Many-to-many relationships ArcMap 10

please i have Many-to-many relationships in arcMap like : and i want to show labels in parcel using ArcMap 10 : field to show is : Zoning and Name - do you have any idea how to do it ? ...
3
votes
2answers
136 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 ...
0
votes
0answers
26 views

Selecting features through a many-to-one relationship

I want to select multiple counties based on the occurrence of a species present within them. I have a County polygon layer with CountyName as an attribute, a flat table called tblSpCnty with the ...
1
vote
2answers
565 views

How to fill attribute field of one feature based on calculation on attribute field of another feature

I would like to fill an Attribute field of a geodateabase table based on some calculations such as 'sum' over specific field of another Feature class. Is there an Approach to formulate it? while in ...
5
votes
1answer
144 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 ...
0
votes
0answers
59 views

How do the ADMINx_CODE & FEATURE_CODE fields in Geonames data describe a relationship between records?

I am trying to use Geonames data to augment data which we currently license from an online advertising broker. I want to use Geonames alternate names data to support synonyms of place names. To ...
1
vote
1answer
227 views

PostgreSQL/GIS table relations in QGIS 1.8.0

I am building a database in PostgreSQL 9.2 with the PostGIS 2.0 extension. The database consists of a schema called Water which contains water related geographic features (as example, boreholes and ...
1
vote
1answer
72 views

Using IRelationshipClass

I have three feature classes [CircuitSource(A),CircuitBreaker(B),Sub-Station(C)]. In the Geodatabase A and B has a 1:1 relationship based on a primary field namely 'FEEDERID'. C and B has a 1:many ...
1
vote
2answers
744 views

One Polygon Joining to Database with Many matching records

Using ArcMap 10.1. Is this possible to have one polygon and join to a database/excel with many matching records? I would like to have 1 polygon but match to 100 corresponding records in a table. When ...
1
vote
1answer
139 views

Maintain Relationship Between Feature Class and an Attribute Table After Recalculating Primary Key (Unique ID)

I have a feature class that has a unique id field. The field is populated using some basic code (using the Calculate Field tool in ArcGIS): def CalcGUID(): import uuid ...
2
votes
0answers
133 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?
6
votes
1answer
666 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 ...