topic Re: Create a layer from a table and a layer using a Join in ArcGIS Pro Questions

Create a layer from a table and a layer using a Join

lmotta_ibama — Thu, 15 Sep 2022 20:58:22 GMT

Hi guys,

I would like create a layer, from a table , where the geometry field (Shape) come from a layer using a Join.

My table have a key, where can use with a layer with same field (key).

The 'Add Join' tool, get all field from layer, but, not add the geometry.

Have a tool in ArcGIS Pro for add the geometry in a table, to create a layer ?

I can use a SQL and the result i define how a layer ?

I have a lot of tables, and I need the geometries from a only layer.

A SQL can be this:

SELECT t.id_city, t.name_seller, t.total, l.Shape

FROM cities_salles t

INNER JOIN cities l ON t.id_city = l.id

Re: Create a layer from a table and a layer using a Join

RhettZufelt — Thu, 15 Sep 2022 22:34:36 GMT

Where is your geometry? In a table, feature class?

Basically, make/copy your feature class with the geometries, then use Join Field to add table to that copy of the feature class.

Re: Create a layer from a table and a layer using a Join

lmotta_ibama — Fri, 16 Sep 2022 13:23:23 GMT

Thanks RhettZufelt ,

I have a layer (feature class), that i would like use yours geometries to others tables.

All tables have a key, that join with the key of layer.

The "Join field" tool, add only attributes from the foreign table. This case, it add all attributes of all tables. The result a layer with a lot of attributes.

I would like use the geometries from the only a layer for all tables, then, I can work with each table with geometries from the same layer.

The idea is have a "Join Geometry" tool, then, we can do a Join from the fields (table and layer), that the geometries of layer will be add in table, promoting a table to layer.