topic Re: Joins (ShapeFIle X Database) in Developers Questions

Joins (ShapeFIle X Database)

klebervaz — Mon, 23 Feb 2015 14:25:05 GMT

Hi Gys,

I have a ShapeFile whith all information displayed on the map. I connected a database (Oracle) with non-spatial data to make some joints, I realized that in option (Join and Relates) can only make only a join shapefile with database.

How could these joins shapefile with data bank unreferenced?

That would be the best solution?

Attached

Re: Joins (ShapeFIle X Database)

XanderBakker — Mon, 23 Feb 2015 15:10:49 GMT

You can join multiple tables to a featureclass, one join each step, but the fields will be visible in the attribute table of the featureclass. To make them permanent, you could export the featureclass to another featureclass.

BTW: the image does not really indicate what you are trying to join...

Re: Joins (ShapeFIle X Database)

klebervaz — Mon, 23 Feb 2015 15:49:30 GMT

Thank you for your attention

If you can give me an example of how to do my joins

I'm trying to join as shows the attached file.

Re: Joins (ShapeFIle X Database)

XanderBakker — Mon, 23 Feb 2015 17:24:36 GMT

You will need a field that exists in both the input features class a in the tables you want to join. Assuming you have that you can:

right click on the featureclass in the TOC, select Joins and Related, Join...

In the dialog that follows:

Select the field (1) in the featureclass you want to use for the join, select table (2) you want to join to join featureclass and select (3) the field in the table you want to use for the join

Click OK.

Repeat this process for all the tables you want to join.

If you observed the properties of the feature layer you will see that there are multiple joins.

Next use the export option to make the joins permanent:

right click on the feature class in the TOC
Select Data, Export data
Specify the output location and name and click OK
A new feature class will be created with the tables joined to it.

If you just want to retrieve the related information and not create a permanent output, you can consider using a relate instead.

Re: Joins (ShapeFIle X Database)

klebervaz — Mon, 23 Feb 2015 18:36:45 GMT

When I try to execute the second query tool for responding, it can be a performance problem?

follows the image

Not responding

Re: Joins (ShapeFIle X Database)

JoeBorgione — Mon, 23 Feb 2015 20:21:36 GMT

Just a guess it might be that you are trying to join a large number of table records to your feature class; sometimes Not Responding is ArcGIS telling you "this is going to take a while"

Perhaps you could explain what you are trying to join and why a join is what you want to do. Or at least explain your final goal is with the data and this analysis..

Re: Joins (ShapeFIle X Database)

klebervaz — Tue, 24 Feb 2015 14:31:39 GMT

Thank you for your help.

I need to join the data the database (Oracle) into a shapefile to show more accurate information in my map according to my SQL QUERY Labels

Example: Display number of patients per year.

This information only exists in the database (Oracle)

Follow the image:

Re: Joins (ShapeFIle X Database)

XanderBakker — Tue, 24 Feb 2015 16:18:30 GMT

Could you please include the images you want to share, as image and not attach them as word documents?

To do this use the Insert Image button:

In the popup, select the file (probably from your computer) and click on Insert image:

That would make it a lot more efficient to read...

Thanks, Xander

Re: Joins (ShapeFIle X Database)

klebervaz — Tue, 24 Feb 2015 17:49:50 GMT

Sorry

Re: Joins (ShapeFIle X Database)

XanderBakker — Tue, 24 Feb 2015 18:16:19 GMT

OK, so you have some geographic feature (might be hospital or a administrative unit) and you have joined the number of patients from Oracle to that geographic feature, right? Is the cardinality 1:1?

If this is the case you can just label the field that was joined, without the need to define a SQL Query. The SQL Query is used to be able to define a label class per group of features that match a certain condition (the SQL query).

Read more on this here: ArcGIS Help (10.2, 10.2.1, and 10.2.2)

Re: Joins (ShapeFIle X Database)

klebervaz — Tue, 24 Feb 2015 18:41:49 GMT

Thanks for the support!

This I already managed to do, The problem is when I try to join with other table to present different situations in the map, ArcMap stops working

I wonder if there is another way to fazzer this?

Re: Joins (ShapeFIle X Database)

klebervaz — Fri, 24 Apr 2015 14:17:26 GMT

Thanks,

I solved the problem