topic python script for using values from one table to add to another in Python Questions

python script for using values from one table to add to another

KatayounMesgarian — Fri, 01 Feb 2013 08:49:43 GMT

Hi there,

I have got question about how to write a script to grab information from one attribute table and add them to another one. to be more specific,, there are two layers, a point layer with start and end shotpoint IDs (and of course Easting & Northing) and another one which is basically the same data in line format that connect the start point to end point to present track lines, what I need to do is to take these shotpoint IDs from point layer and add them to each single line. I was thinking of using join but it didnt worked out. Is there anyone know how to do it?

thanks a lot
Katy
[ATTACH=CONFIG]21295[/ATTACH]

Re: python script for using values from one table to add to another

markdenil — Fri, 01 Feb 2013 11:31:20 GMT

You write that join didn't work; was that a table join or a Spatial Join?
The two are quite different animals.

Spatial Join is likely what you want to use.

Re: python script for using values from one table to add to another

KatayounMesgarian — Fri, 01 Feb 2013 12:52:39 GMT

You write that join didn't work; was that a table join or a Spatial Join?
The two are quite different animals.

Spatial Join is likely what you want to use.

thanks for the reply.

I did use Spatial join, but that still needs some manual editing. I am looking for a way that I can get the information all automatically.