Hot answers tagged

8

Fist about joins and relates. The former term is to "join" one table to another using some criteria, such as data common to the two tables. The later term is more a GIS term for how one spatial data relates to another, e.g. see ST_Relate and DE-9IM. One might join a table to another using a relate. So for your situation, "how to join non-spatial table to ...


7

First, let's clarify a couple of things. When you say that you want to add a table from MS SQL Server Management Studio 2012, what you really want to do is add a table from MS SQL Server. The management studio is simply the user interface for interacting with the database itself. Second, I am going on the assumption that this SQL Server database does not ...


7

ArcGIS makes frequent use of "registered rowid columns". These are INTEGER (32-bit) columns with non-zero positive values (1 - 2^31-1), which are defined to be NOT NULL, contain unique values, and are reproducible on subsequent queries ArcGIS uses these columns to maintain the relationship between rows in tables and the graphics in the map. Whenever ...


6

You've got a few options here. QGIS can natively open and process from CSV files so if your data is already in that format, you should be fine. Otherwise, you can export it to that format or install a plugin called "Spreadsheet Layers" from the Plugins Manager. There isn't really any major benefits between spreadsheet file types, just use what's simplest for ...


5

In ArcMap 10, use the MAKE QUERY TABLE. First, make sure the table and feature class are in the same geodatabase. The MAKE QUERY TABLE tool will create a feature layer so you'll have to use COPY to create a permanent feature class. You can then export this feature class to a shapefile.


5

Not automatically, but you can set up related tables, and from the Attribute Table you select Related Tables and it'll open the related table and select the matching records. Establish your Relate from Layer Properties > Joins & Relates tab (this only needs to be done once per Relate): Select a Feature from one of the Layers: From the Attribute Table ...


5

The help for ArcGIS is clear that you cannot do relates with Excel documents or any other document that does not support an ObjectID in the Fundamentals of ObjectID fields help. This help clearly states: "If your table lacks an ObjectID field, you won't be able to perform the following operations: Select the features in the layer on the map. Although you ...


5

You can use a sub-query in the definition query as long as the data is not versioned or archive enabled (then you have to query the default view). Since you have key fields already defined from your relate you can use something like: OBJECTID in (SELECT JOINIDFIELD FROM RELATEDTABLE WHERE INSPECTIONRESULT = 'Failed') Read more about sub queries here It ...


5

I've found out a solution. I've made rule-based filtering with expression: relation_aggregate( 'TownsInformationRelation', 'max', CASE WHEN "Source" = 'Wikipedia' THEN "Population" ELSE 0 END ) And also I've used filter: relation_aggregate( 'TownsInformationRelation', 'count', CASE WHEN "Source" = 'Wikipedia' THEN 'true' ELSE NULL END ) Thanks!


4

Starting in QGIS 2.2 (still in development) there will be a new feature that will allow to manage 1:n relations in a very fancy way. When you open a feature form with a relation, you will the feature attributes and the related atributes connected to it. In the following example the table "reaches" as a 1:n relation to a table "maintenances". For more ...


4

Another approach will be to show a PostGIS view in QGIS, using 'Instead of triggers' in Postgres for handling CRUD operations. Field widges on the view in QGIS, can ensure the correct input, when updating joined fields from QGIS.


4

Join the table with XY information to the table without it. From there, you can add permanent XY fields by exporting the joined data.. You can also do this by adding the XY fields first. Then joining the tables, and calculating the XY values using the joined XY fields. After you have done this, remove the join and you will have a XY fields for the table ...


4

If you want to understand the Dimensionally Extended nine-Intersection Model (DE-9IM) or Clementini Matrice, read Christian Stobl Dimensionally Extended Nine-Intersection Model (DE-9IM)(pdf). You can also read the explications in PostGIS: 4.3.6. Dimensionally Extended 9 Intersection Model (DE-9IM) The method allows to create spatial filters to find ...


4

Instead of a relate, have you tried joining the tables? Assuming QGIS handles relates and joins the same as ArcMap, you will not be able to query on the relate. Basically, a relate just defines a relationship within the map document, and does nothing to relate the tables in the geodatabase (such as a join). In order to query, a database relationship needs ...


4

The short answer is no, not without accessing arcobjects. You would need to install comtypes module to access the interface that would return that information.


4

First option is: First open Plugins | Settings and enable Show also experimental plugins Now you can install Select by relationship plugin Now set up two relations in Project --> Properties --> Relations First is: Name: sc (or whatever) Referenced Layer: species_distributions Referenced Field: county Referencing Layer: speciescounty Referencing ...


3

ideally, you'd want to move your data into the DBMS as a Feature Class and then create a relationship class in ArcMap. Using SDE, you can load Shapefiles into MSSQL and setup relationships in ArcMap just like you have in SQL, then ArcMap would understand the Relationships. Here's a good place to start: http://resources.arcgis.com/en/help/main/10.2/#/...


3

You are describing what the OGC world calls a complex feature. GeoServer supports this through the App Schema plugin - see this tutorial for a (fairly) clear introduction to this.


3

I have only done this kind of thing with SQL Server but this link has some techniques that should help you accomplish what you want with PostGres. How to concatenate strings field in postgresql The steps you would need to carry out would be: Create a View in the database (using the techniques described in the link) that returns a table with two fields, ...


3

The code block in Field Calculator can be used to gather/aggregate statistics within multiple features of the specified feature class. However, it's not really practical when dealing with multiple feature classes. The easiest method would probably be to generate a table of the 'sum' statistics you want using the Summary Statistics tool and then join this ...


3

Within an attribute table a geometry (be it single or multi-part) only ever has a one-to-one correspondence with its attributes. Consequently, to meet your one-to-many requirement I think you will need to use a Relate (or a Relationship Class) to a second table: Relates defined in ArcMap are essentially the same as simple relationship classes defined ...


3

If i got you,you have common field among tables so better to use Join command and export the result to get a combined feature(composite). This will not add geometry to the composite but only features' attributes only. N.B.If you are working with lot of data then take different approach, i mean you need to use RDBMS where you will link both table using ...


3

Use a colour scale, getting darker for each additional person buried in a plot. ColorBrewer is a great place to look for good colour schemes. I imagine most would just be one person, but ones that are darker indicate the presence of multiple people. If your problem is how you associate cemetary plots and a table of people buried therein, then you need to ...


3

Besides creating the relations in spatialite (by adding reference constraints) you need to inform QGIS about that relations. If I recall well, that is done in the Projects properties, relations tab. Once you add all layers relations to the project, you can set the relation widget in feature form and attribute table. So for each feature you can see and edit ...


3

I would recommend saving your excel spreadsheet to a csv, export the CSV to a dbase in a file geodatabase, add a text field to the dbase and use the field calculator to concatenate the multiple fields into one standardized unique-identifying string. In the field calculator, you can use the Python parser with the expression str(!field1!) +"-"+ str(!field2!) + ...


3

I ended up using the Intersect tool (similar to the ultimate QGIS answer in the post I linked to). For those who, like me, appreciate some hand-holding: Opened Intersect tool (ArcToolbox>Analysis Tools>Overlay>Intersect) For Input, selected both polygon shapefiles (left other options as-is); after running, the new feature was added to my map and saved to ...


3

If you are only interested in counts, then you can just perform a Summarize on the 1880 residence county field in the individual data table. This will produce a table of unique counties and a count of records (individuals) for each county. Then, join the summarized table to your 1880 counties feature class. Symbolize using graduated colors to create a ...


3

I was able to achieve what I think you are after as follows: First, I set the layer relations in project properties as seen in this screenshot: The attribute table of the 'Towns' vector layer looks like this: The attribute table of the non-spatial 'TownsInfo' Layer looks like this: I entered the following expression in the Label Expression Generator: ...


2

I did the following: dojo.map(response, function (result){ if (result.layerName === 'mylayer') { var relInfo = ''; // create a new InfoTemplate, and set the title var template=new esri.InfoTemplate('Template','${*}'); template.setTitle('myTitle'); // create the RelationshipQuery myFeatureLayer.queryRelatedFeatures(relQuery, ...


2

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 select the related table This is definitely possible - I remember writing a script to do it years ago. In my case I generated a new standalone window and ...


Only top voted, non community-wiki answers of a minimum length are eligible