topic Re: UpdateCursor - Python GP Tool Help in Python Questions

UpdateCursor - Python GP Tool Help

AndrewLamers1 — Mon, 25 Mar 2019 16:23:37 GMT

Re: UpdateCursor - Python GP Tool Help

JoeBorgione — Mon, 25 Mar 2019 16:37:51 GMT

What is the relationship between the table and feature class? It sounds like if you were to join the table to the feature class through item that is the relationship? Perhaps you could clarify? If there is a possibility for a join, I would refer you to Richard Fairhurst's https://community.esri.com/blogs/richard_fairhurst/2014/11/08/turbo-charging-data-manipulation-with-python-cursors-and-dictionaries

Re: UpdateCursor - Python GP Tool Help

AndrewLamers1 — Mon, 25 Mar 2019 17:09:41 GMT

Thanks for the link, I'll check that out.

There is no relationship between the two, the points will be collected via Collector and the table is pre-populated with budget information. I want to push the quantities from the points into the table based on item name AND matching column name (which is captured in the user entry).

Re: UpdateCursor - Python GP Tool Help

JoeBorgione — Mon, 25 Mar 2019 17:16:27 GMT

There is no relationship between the two...

I want to push the quantities from the points into the table based on item name AND matching column name

It sounds to me like there is a relationship between the two, but you know your data better than I do....

Re: UpdateCursor - Python GP Tool Help

AndrewLamers1 — Mon, 25 Mar 2019 18:21:37 GMT

Sorry, I meant there isn't relationship within the database, i.e. no relationship class, not a related table.
There is a relationship in that the table is a summary of pre-populated budgeting information (not included in the point layer) and is to be updated with the quantities logged within the point feature class.

Re: UpdateCursor - Python GP Tool Help

JoshuaBixby — Tue, 26 Mar 2019 01:47:34 GMT

I have a FGDB containing 2 feature classes (1 table, 1 point).

For future reference, tables are tables, not feature classes: feature class| Definition - Esri Support GIS Dictionary

[ESRI software] In ArcGIS, a collection of geographic features with the same geometry type (such as point, line, or polygon), the same attributes, and the same spatial reference.

Beyond knowing you have a table and a feature class, it is unclear what you are trying to do because the term "table" appears to be referencing the table and feature class. It is helpful if you describe the structure of each, e.g., feature class A has fields x, y, z; and table B has fields m, n, and y.