Labelling using python - Accessing other tables

RemiBrisson — Fri, 02 May 2014 09:29:15 GMT

Hi all, I have a labelling quiz for you.

I have a point FC that identifies islands. Each point has a code to identify the island uniquely. There are no duplicates.

I also have a table (excel at this point) that stores info on bird colonies inventories (island where it is located (code)20, date inventoried, other info...).

The codes for the islands in the point FC and table are the same. There is a one to many relationship between the FC and the table.

I need to label each island with all the years that a colony was inventoried on it. Some will have one year displayed, others two, others several...

1978

1978
1986

1986

1999

1978
1986
1999
2009

etc.

I tried joining the tables but I only get the first year that's found in the table for each point. Now I'm thinking: can I use a python script in the labelling expression that will access my table and parse it to create my labels and return them?

I bet I'm missing something simple here...

Thanks for your time

Remi

Re: Labelling using python - Accessing other tables

ChrisPedrezuela — Fri, 09 May 2014 02:33:58 GMT

I think what you can do since you have a one is to many relationship, to join it properly follow the link below,

http://resources.arcgis.com/en/help/main/10.1/index.html#//0017000000v9000000

Regards,
Thanos

topic Labelling using python - Accessing other tables in Mapping Questions

Labelling using python - Accessing other tables

Re: Labelling using python - Accessing other tables