Hi Python experts, I am writing my first python script and would need some advice on how to read and manipulate a list. On my network drive, I have several folders named after Project and they belong to one or more Years. I have a FGDB feature class in which I have 2 desired columns FLYING, FILMNAME representing Year, Project respectively. For e.g., YearProject1960A1972B1980C1972D1980E1980F1960G1972H1972I1960J I would like to read all the rows and create one mosaic data set for each Year and add the Project into each Year's mosaic . e.g, 1960 will have A;G;J 1972 will have B;D;H To do this, I would like to get two lists 1. a list of unique Years - to create empty mosaics 2. a list of Projects per Year - to append airphoto folders to each mosaic Below is the code that does the first list. Any pointers on how to progress further would be much helpful. Thanks in advance. #import modules import os import arcpy from arcpy import env from datetime import datetime #assign variables in_fc = r 'C:\Working\airphoto.gdb\airphoto_index' fields = [ 'FLYING' , 'FILMNAME' ] gdb = 'C:\Working\images.gdb' sourceDir = "O:\\airphoto\\75dpi\\" in_mosaic = 'C:\Working\images.gdb\test' prjfile = arcpy . SpatialReference ( 3857 ) #create lists Years = [ ] Films = [ ] YearFilmString = [ ] FilmList = [ ] #read feature class columns and iterate through rows with arcpy . da . SearchCursor ( in_fc , fields ) as cursor : for row in cursor : #extract year from datetime field yearString = ( str ( row [ 0 ] ) [ : 4 ] ) Years . append ( yearString ) filmString = row [ 1 ] Films . append ( filmString ) uniqYears = sorted ( set ( Years ) ) uniqYearsList = list ( uniqYears ) #for each year, create one mosaic for i in uniqYearsList : x = "C:\Working\images.gdb\T" + i if arcpy . Exists ( x ) : print "mosaic already exists, skipping..." continue else : arcpy . CreateMosaicDataset_management ( gdb , i , prjfile , '' , '' , '' , '' ) print i , "mosaic created"

Here's another of many ways: cursor = [ # rows in your geodatabase [ '1960-01-01' , 'A' ] , [ '1972-01-01' , 'B' ] , [ '1980-01-01' , 'C' ] , [ '1972-02-01' , 'D' ] , [ '1980-02-01' , 'E' ] , [ '1980-03-01' , 'F' ] , [ '1960-02-01' , 'G' ] , [ '1972-03-01' , 'H' ] , [ '1972-04-01' , 'I' ] , [ '1960-03-01' , 'J' ] ] d = { } # empty dictionary # with arcpy.da.SearchCursor(in_fc,fields) as cursor: # for row in cursor: for row in cursor : if row [ 0 ] [ : 4 ] not in d : d [ row [ 0 ] [ : 4 ] ] = [ row [ 1 ] ] else : d [ row [ 0 ] [ : 4 ] ] . append ( row [ 1 ] ) print d # {'1960': ['A', 'G', 'J'], '1972': ['B', 'D', 'H', 'I'], '1980': ['C', 'E', 'F']} for k in d . keys ( ) : # access years and films print k print d [ k ] ''' 1960 ['A', 'G', 'J'] 1972 ['B', 'D', 'H', 'I'] 1980 ['C', 'E', 'F'] '''

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Using SearchCursor to read two columns and process

Thiru_P

Hi Python experts, I am writing my first python script and would need some advice on how to read and manipulate a list.

On my network drive, I have several folders named after Project and they belong to one or more Years.

I have a FGDB feature class in which I have 2 desired columns FLYING, FILMNAME representing Year, Project respectively.

For e.g.,

Year	Project
1960	A
1972	B
1980	C
1972	D
1980	E
1980	F
1960	G
1972	H
1972	I
1960	J

I would like to read all the rows and create one mosaic data set for each Year and add the Project into each Year's mosaic .

e.g, 1960 will have A;G;J 1972 will have B;D;H

To do this, I would like to get two lists

1. a list of unique Years - to create empty mosaics

2. a list of Projects per Year - to append airphoto folders to each mosaic

Below is the code that does the first list. Any pointers on how to progress further would be much helpful. Thanks in advance.

<SPAN class="comment token">#import modules</SPAN>
<SPAN class="keyword token">import</SPAN> os
<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">from</SPAN> arcpy <SPAN class="keyword token">import</SPAN> env
<SPAN class="keyword token">from</SPAN> datetime <SPAN class="keyword token">import</SPAN> datetime

<SPAN class="comment token">#assign variables</SPAN>
in_fc <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'C:\Working\airphoto.gdb\airphoto_index'</SPAN>
fields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'FLYING'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'FILMNAME'</SPAN><SPAN class="punctuation token">]</SPAN>
gdb <SPAN class="operator token">=</SPAN> <SPAN class="string token">'C:\Working\images.gdb'</SPAN>
sourceDir <SPAN class="operator token">=</SPAN> <SPAN class="string token">"O:\\airphoto\\75dpi\\"</SPAN>
in_mosaic <SPAN class="operator token">=</SPAN> <SPAN class="string token">'C:\Working\images.gdb\test'</SPAN>
prjfile <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>SpatialReference<SPAN class="punctuation token">(</SPAN><SPAN class="number token">3857</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token">#create lists</SPAN>
Years <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
Films <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
YearFilmString <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
FilmList <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="comment token">#read feature class columns and iterate through rows</SPAN>
<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>in_fc<SPAN class="punctuation token">,</SPAN>fields<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#extract year from datetime field</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; yearString <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">(</SPAN>str<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Years<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>yearString<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; filmString <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Films<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>filmString<SPAN class="punctuation token">)</SPAN>
uniqYears <SPAN class="operator token">=</SPAN> sorted<SPAN class="punctuation token">(</SPAN>set<SPAN class="punctuation token">(</SPAN>Years<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
uniqYearsList <SPAN class="operator token">=</SPAN> list<SPAN class="punctuation token">(</SPAN>uniqYears<SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token">#for each year, create one mosaic</SPAN>
<SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> uniqYearsList<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; x <SPAN class="operator token">=</SPAN> <SPAN class="string token">"C:\Working\images.gdb\T"</SPAN><SPAN class="operator token">+</SPAN>i
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Exists<SPAN class="punctuation token">(</SPAN>x<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"mosaic already exists, skipping..."</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">continue</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>CreateMosaicDataset_management<SPAN class="punctuation token">(</SPAN>gdb<SPAN class="punctuation token">,</SPAN>i<SPAN class="punctuation token">,</SPAN>prjfile<SPAN class="punctuation token">,</SPAN><SPAN class="string token">''</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">''</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">''</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">''</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN>&nbsp; i<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"mosaic created"</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp; <SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Najděte více příspěvků označených jako

Accepted answers

RandyBurton

Here's another of many ways:

cursor <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN> <SPAN class="comment token"># rows in your geodatabase</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">[</SPAN> <SPAN class="string token">'1960-01-01'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'A'</SPAN> <SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> 
&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">[</SPAN> <SPAN class="string token">'1972-01-01'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'B'</SPAN> <SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">[</SPAN> <SPAN class="string token">'1980-01-01'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'C'</SPAN> <SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> 
&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">[</SPAN> <SPAN class="string token">'1972-02-01'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'D'</SPAN> <SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> 
&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">[</SPAN> <SPAN class="string token">'1980-02-01'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'E'</SPAN> <SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> 
&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">[</SPAN> <SPAN class="string token">'1980-03-01'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'F'</SPAN> <SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> 
&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">[</SPAN> <SPAN class="string token">'1960-02-01'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'G'</SPAN> <SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> 
&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">[</SPAN> <SPAN class="string token">'1972-03-01'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'H'</SPAN> <SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">[</SPAN> <SPAN class="string token">'1972-04-01'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'I'</SPAN> <SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">[</SPAN> <SPAN class="string token">'1960-03-01'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'J'</SPAN> <SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">]</SPAN>

d <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="punctuation token">}</SPAN> <SPAN class="comment token"># empty dictionary </SPAN>

<SPAN class="comment token"># with arcpy.da.SearchCursor(in_fc,fields) as cursor:</SPAN>
<SPAN class="comment token">#&nbsp;&nbsp;&nbsp; for row in cursor:</SPAN>
<SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">not</SPAN> <SPAN class="keyword token">in</SPAN> d<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; d<SPAN class="punctuation token">[</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; d<SPAN class="punctuation token">[</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">print</SPAN> d
<SPAN class="comment token"># {'1960': ['A', 'G', 'J'], '1972': ['B', 'D', 'H', 'I'], '1980': ['C', 'E', 'F']}</SPAN>

<SPAN class="keyword token">for</SPAN> k <SPAN class="keyword token">in</SPAN> d<SPAN class="punctuation token">.</SPAN>keys<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>&nbsp; <SPAN class="comment token"># access years and films</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> k
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> d<SPAN class="punctuation token">[</SPAN>k<SPAN class="punctuation token">]</SPAN>
<SPAN class="string token">'''
1960
['A', 'G', 'J']
1972
['B', 'D', 'H', 'I']
1980
['C', 'E', 'F']
'''</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

All comments

Thiru_P

Thanks Dan Patterson‌ for your help. I could not mark two entries as Correct Answers. I am choosing to go with dictionary approach in this case. Once I finish my script, I will add it here so it might benefit someone else.

This is what I love about GeoNet. I am not alone when it comes to learning. Hopefully, I can share my python expertise when I learn enough. Regards, Thiru

DanPatterson_Retired

year <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'1960'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'1972'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'1980'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'1972'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'1980'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'1980'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'1960'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'1972'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'1972'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'1960'</SPAN><SPAN class="punctuation token">]</SPAN>
Project <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'A'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'B'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'C'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'D'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'E'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'F'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'G'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'H'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'I'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'J'</SPAN><SPAN class="punctuation token">]</SPAN>
a <SPAN class="operator token">=</SPAN> np<SPAN class="punctuation token">.</SPAN>array<SPAN class="punctuation token">(</SPAN>list<SPAN class="punctuation token">(</SPAN>zip<SPAN class="punctuation token">(</SPAN>year<SPAN class="punctuation token">,</SPAN> Project<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
keys <SPAN class="operator token">=</SPAN> sorted<SPAN class="punctuation token">(</SPAN>list<SPAN class="punctuation token">(</SPAN>set<SPAN class="punctuation token">(</SPAN>year<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
out <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> keys<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; idx <SPAN class="operator token">=</SPAN> np<SPAN class="punctuation token">.</SPAN>where<SPAN class="punctuation token">(</SPAN>a<SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">==</SPAN> i<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; vals <SPAN class="operator token">=</SPAN> a<SPAN class="punctuation token">[</SPAN>idx<SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>tolist<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; out<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN>i<SPAN class="punctuation token">,</SPAN> vals<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; 

out

<SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'1960'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'A'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'G'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'J'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'1972'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'B'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'D'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'H'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'I'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'1980'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'C'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'E'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'F'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

easier when the dtypes are the same

RandyBurton

Should you need unique items sorted:

<SPAN class="keyword token">for</SPAN> k <SPAN class="keyword token">in</SPAN> d<SPAN class="punctuation token">.</SPAN>keys<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"{}: "</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>k<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> sorted<SPAN class="punctuation token">(</SPAN>set<SPAN class="punctuation token">(</SPAN>d<SPAN class="punctuation token">[</SPAN>k<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> i<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN>

<SPAN class="comment token"># results</SPAN>
<SPAN class="comment token"># 1974:&nbsp; 2775 2983 2985 3004 3005 3006 3008 3021 27027</SPAN>
<SPAN class="comment token"># 1970:&nbsp; 2183</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

RandyBurton

Using set on a list will give unique elements:

d = {'1974': [3005, 3008, 3008, 3008, 3008, 3005, 3005, 3005, 3005, 3008, 3008,
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3006, 3006, 3004, 3004, 3004, 3004, 3004, 3004, 27027, 2775, 3021,
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3021, 3005, 3005, 3008, 3008, 3008, 3008, 3008, 3005, 3005, 3008,
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3008, 3008, 3006, 3006, 3004, 3004, 3004, 3021, 3021, 2775, 3005,
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3008, 3005, 3005, 3004, 3004, 3004, 3005, 3005, 3005, 3005, 3005,
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3008, 3008, 3008, 3005, 3005, 3005, 3005, 3005, 3005, 3008, 3008,
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3008, 3008, 3008, 3006, 3004, 2985, 3021, 2775, 3005, 3005, 3005,
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3008, 3008, 3008, 3008, 3008, 3005, 3005, 3005, 3005, 3005, 3006,
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3004, 3004, 3004, 3004, 3005, 2983, 3021, 3021, 27027, 2775, 2775,
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3005, 3005, 3005, 3004, 2983, 2983, 3005, 3005, 3008, 3008, 3008,
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3008, 3008, 3008, 3005, 3005, 3005, 3005, 3005, 3005, 3005, 3005,
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3008, 3006, 3006, 3004, 3004, 3004, 3004, 3004, 3004, 3008, 3005,
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2985, 2985, 2983, 3021, 3021, 2775, 3005, 3005, 3008, 3008, 3005,
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3008, 3008, 3008, 3008, 3004, 3004, 2983, 3005, 3005, 3005, 3005,
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3008, 3008, 3008, 3008, 3008, 3005, 3005, 3006, 3006, 3006, 3006,
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3004, 3004, 3004, 2985, 3005, 3005, 3005, 3005, 3005, 3008, 3008,
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3008, 3008, 3008, 3008, 3008, 3008, 3005, 3005, 3005, 3005, 3005,
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3005, 3008, 3006, 3006, 2985, 2985, 2985, 2985, 3021, 3021, 3021,
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 27027, 3021],
&nbsp;&nbsp;&nbsp;&nbsp; '1970': [2183, 2183, 2183, 2183, 2183, 2183, 2183, 2183]}

for k in d.keys():
&nbsp;&nbsp;&nbsp; print k, set(d<K>)

# 1974 set([3008, 2983, 2985, 3021, 27027, 2775, 3004, 3005, 3006])
# 1970 set([2183])
‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></K>

DanPatterson_Retired

a = np.array(list(zip(Years, Films)), dtype = [('Years', '<i4'), ('Films', 'U2')])

you made years a string so the dtype should be 'U4' or its equivalent if using python 2.7.

Similarly your 'Films' is now a number and would need to be '<i4'.

If that isn't the case, post a list of the way that each is ie string or number

Thiru_P

Hi Randy, thanks for the reply. I tried your code. It works but I have got duplicate Projects.

<SPAN class="comment token">#import modules</SPAN>
<SPAN class="keyword token">import</SPAN> os
<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">from</SPAN> arcpy <SPAN class="keyword token">import</SPAN> env
<SPAN class="keyword token">from</SPAN> datetime <SPAN class="keyword token">import</SPAN> datetime
<SPAN class="keyword token">import</SPAN> numpy <SPAN class="keyword token">as</SPAN> np

<SPAN class="comment token">#assign variables</SPAN>
in_fc <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'C:\Working\airphoto.gdb\airphoto_index'</SPAN>
fields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'FLYING'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'FILM'</SPAN><SPAN class="punctuation token">]</SPAN>
gdb <SPAN class="operator token">=</SPAN> <SPAN class="string token">'C:\Working\images.gdb'</SPAN>
sourceDir <SPAN class="operator token">=</SPAN> <SPAN class="string token">"O:\\airphoto\\75dpi\\"</SPAN>
in_mosaic <SPAN class="operator token">=</SPAN> <SPAN class="string token">'C:\Working\images.gdb\test'</SPAN>
prjfile <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>SpatialReference<SPAN class="punctuation token">(</SPAN><SPAN class="number token">3857</SPAN><SPAN class="punctuation token">)</SPAN>
d <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="punctuation token">}</SPAN>
<SPAN class="comment token">#create lists</SPAN>
Years <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
Films <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
YearFilmString <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
FilmList <SPAN class="operator token">=</SPAN> set<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token">#read feature class columns and iterate through rows</SPAN>
<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>in_fc<SPAN class="punctuation token">,</SPAN>fields<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#extract year from datetime field</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> str<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">not</SPAN> <SPAN class="keyword token">in</SPAN> d<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; d<SPAN class="punctuation token">[</SPAN>str<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; d<SPAN class="punctuation token">[</SPAN>str<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN> d

<SPAN class="string token">'''
for k in d.keys():
&nbsp;&nbsp;&nbsp; print k
&nbsp;&nbsp;&nbsp; print d<K>
'''</K></SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Result:

'1974': [3005, 3008, 3008, 3008, 3008, 3005, 3005, 3005, 3005, 3008, 3008, 3006, 3006, 3004, 3004, 3004, 3004, 3004, 3004, 27027, 2775, 3021, 3021, 3005, 3005, 3008, 3008, 3008, 3008, 3008, 3005, 3005, 3008, 3008, 3008, 3006, 3006, 3004, 3004, 3004, 3021, 3021, 2775, 3005, 3008, 3005, 3005, 3004, 3004, 3004, 3005, 3005, 3005, 3005, 3005, 3008, 3008, 3008, 3005, 3005, 3005, 3005, 3005, 3005, 3008, 3008, 3008, 3008, 3008, 3006, 3004, 2985, 3021, 2775, 3005, 3005, 3005, 3008, 3008, 3008, 3008, 3008, 3005, 3005, 3005, 3005, 3005, 3006, 3004, 3004, 3004, 3004, 3005, 2983, 3021, 3021, 27027, 2775, 2775, 3005, 3005, 3005, 3004, 2983, 2983, 3005, 3005, 3008, 3008, 3008, 3008, 3008, 3008, 3005, 3005, 3005, 3005, 3005, 3005, 3005, 3005, 3008, 3006, 3006, 3004, 3004, 3004, 3004, 3004, 3004, 3008, 3005, 2985, 2985, 2983, 3021, 3021, 2775, 3005, 3005, 3008, 3008, 3005, 3008, 3008, 3008, 3008, 3004, 3004, 2983, 3005, 3005, 3005, 3005, 3008, 3008, 3008, 3008, 3008, 3005, 3005, 3006, 3006, 3006, 3006, 3004, 3004, 3004, 2985, 3005, 3005, 3005, 3005, 3005, 3008, 3008, 3008, 3008, 3008, 3008, 3008, 3008, 3005, 3005, 3005, 3005, 3005, 3005, 3008, 3006, 3006, 2985, 2985, 2985, 2985, 3021, 3021, 3021, 27027, 3021],

'1973': [2618, 2618, 2618, 2618, 2618, 2618, 2618, 2618, 2618, 2618, 2618, 2618, 2618, 2618, 2618, 2618, 2618, 2618, 2618, 2618, 2618],

'1972': [2626, 2626, 2626, 2626, 2626, 2626, 2626, 2626, 2626, 2626, 2626, 2626, 2626, 2626, 2626, 2626, 2626, 2626, 2626, 2626, 2626, 2626, 2626, 2626, 2626, 2626, 2626, 2626, 2626, 2626, 2626, 2626, 2626, 2626, 2626, 2626, 2626, 2626, 2626, 2626, 2626, 2626, 2626, 2626, 2626, 2626, 2626, 2626, 2626, 2626, 2626, 2626],

'1970': [2183, 2183, 2183, 2183, 2183, 2183, 2183, 2183]}

I am trying to get unique values for each key. e.g.,

'1974': [3008, 3005, 3006, 3004, 27027, 2775, 3021, 2985, 2983]

Thiru_P

Dan's method:

<SPAN class="comment token">#import modules</SPAN>
<SPAN class="keyword token">import</SPAN> os
<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">from</SPAN> arcpy <SPAN class="keyword token">import</SPAN> env
<SPAN class="keyword token">from</SPAN> datetime <SPAN class="keyword token">import</SPAN> datetime
<SPAN class="keyword token">import</SPAN> numpy <SPAN class="keyword token">as</SPAN> np

<SPAN class="comment token">#assign variables</SPAN>
in_fc <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'C:\Working\airphoto.gdb\airphoto_index'</SPAN>
fields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'FLYING'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'FILM'</SPAN><SPAN class="punctuation token">]</SPAN>
gdb <SPAN class="operator token">=</SPAN> <SPAN class="string token">'C:\Working\images.gdb'</SPAN>
sourceDir <SPAN class="operator token">=</SPAN> <SPAN class="string token">"O:\\airphoto\\75dpi\\"</SPAN>
in_mosaic <SPAN class="operator token">=</SPAN> <SPAN class="string token">'C:\Working\images.gdb\test'</SPAN>
prjfile <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>SpatialReference<SPAN class="punctuation token">(</SPAN><SPAN class="number token">3857</SPAN><SPAN class="punctuation token">)</SPAN>


<SPAN class="comment token">#create lists</SPAN>
Years <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
Films <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
YearFilmString <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
FilmList <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="comment token">#read feature class columns and iterate through rows</SPAN>
<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>in_fc<SPAN class="punctuation token">,</SPAN>fields<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#extract year from datetime field</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; yearString <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">(</SPAN>str<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Years<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>yearString<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; filmString <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Films<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>filmString<SPAN class="punctuation token">)</SPAN>
keys <SPAN class="operator token">=</SPAN> sorted<SPAN class="punctuation token">(</SPAN>list<SPAN class="punctuation token">(</SPAN>set<SPAN class="punctuation token">(</SPAN>Years<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
a <SPAN class="operator token">=</SPAN> np<SPAN class="punctuation token">.</SPAN>array<SPAN class="punctuation token">(</SPAN>list<SPAN class="punctuation token">(</SPAN>zip<SPAN class="punctuation token">(</SPAN>Years<SPAN class="punctuation token">,</SPAN> Films<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> dtype <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Years'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'<i4'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Films'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'U2'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
out<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> keys<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; kv <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>i<SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; idx <SPAN class="operator token">=</SPAN> np<SPAN class="punctuation token">.</SPAN>where<SPAN class="punctuation token">(</SPAN>a<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Years'</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">==</SPAN> i<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; vals <SPAN class="operator token">=</SPAN> a<SPAN class="punctuation token">[</SPAN>idx<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Films'</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; kv<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>vals<SPAN class="punctuation token">.</SPAN>tolist<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; out<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>kv<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN> out<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Thiru_P

Hi Dan, tried this. I am getting empty list for the Projects.

[['1944', []], ['1948', []], ['1956', []], ['1957', []], ['1958', []], ['1959', []], ['1962', []], ['1963', []], ['1964', []], ['1968', []], ['1969', []], ['1970', []], ['1972', []], ['1973', []], ['1974', []], ['1976', []], ['1977', []], ['1978', []], ['1979', []], ['1980', []], ['1981', []], ['1982', []], ['1983', []], ['1984', []], ['1985', []], ['1986', []], ['1988', []], ['1989', []], ['1990', []], ['1991', []]]

Here's a subset of my FILMS list-

5042, 2985, 2985, 2985, 2985, 3021, 3021, 3021, 4095, 4095, 4095, 4095, 3604, 2020, 3930, 2004, 798, 798, 2584, 2593, 3825, 3825, 2618, 27027, 572, 798, 798, 798, 798, 1317, 1317, 1317, 3825, 890, 890, 798, 798, 3614, 1317, 1317]

I suspected it might be due to array data type U2 being wrong. Tried substituting with string equivalent S10. Did not work. I got an empty list for the Projects.

Will post the python code as a reply to the original question.

RandyBurton

Here's another of many ways:

cursor <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN> <SPAN class="comment token"># rows in your geodatabase</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">[</SPAN> <SPAN class="string token">'1960-01-01'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'A'</SPAN> <SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> 
&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">[</SPAN> <SPAN class="string token">'1972-01-01'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'B'</SPAN> <SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">[</SPAN> <SPAN class="string token">'1980-01-01'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'C'</SPAN> <SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> 
&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">[</SPAN> <SPAN class="string token">'1972-02-01'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'D'</SPAN> <SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> 
&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">[</SPAN> <SPAN class="string token">'1980-02-01'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'E'</SPAN> <SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> 
&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">[</SPAN> <SPAN class="string token">'1980-03-01'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'F'</SPAN> <SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> 
&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">[</SPAN> <SPAN class="string token">'1960-02-01'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'G'</SPAN> <SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> 
&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">[</SPAN> <SPAN class="string token">'1972-03-01'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'H'</SPAN> <SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">[</SPAN> <SPAN class="string token">'1972-04-01'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'I'</SPAN> <SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">[</SPAN> <SPAN class="string token">'1960-03-01'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'J'</SPAN> <SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">]</SPAN>

d <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="punctuation token">}</SPAN> <SPAN class="comment token"># empty dictionary </SPAN>

<SPAN class="comment token"># with arcpy.da.SearchCursor(in_fc,fields) as cursor:</SPAN>
<SPAN class="comment token">#&nbsp;&nbsp;&nbsp; for row in cursor:</SPAN>
<SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">not</SPAN> <SPAN class="keyword token">in</SPAN> d<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; d<SPAN class="punctuation token">[</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; d<SPAN class="punctuation token">[</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">print</SPAN> d
<SPAN class="comment token"># {'1960': ['A', 'G', 'J'], '1972': ['B', 'D', 'H', 'I'], '1980': ['C', 'E', 'F']}</SPAN>

<SPAN class="keyword token">for</SPAN> k <SPAN class="keyword token">in</SPAN> d<SPAN class="punctuation token">.</SPAN>keys<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>&nbsp; <SPAN class="comment token"># access years and films</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> k
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> d<SPAN class="punctuation token">[</SPAN>k<SPAN class="punctuation token">]</SPAN>
<SPAN class="string token">'''
1960
['A', 'G', 'J']
1972
['B', 'D', 'H', 'I']
1980
['C', 'E', 'F']
'''</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

DanPatterson_Retired

year <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">1960</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1972</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1980</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1972</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1980</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1980</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1960</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1972</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1972</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1960</SPAN><SPAN class="punctuation token">]</SPAN>
Project <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'A'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'B'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'C'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'D'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'E'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'F'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'G'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'H'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'I'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'J'</SPAN><SPAN class="punctuation token">]</SPAN>

keys <SPAN class="operator token">=</SPAN> sorted<SPAN class="punctuation token">(</SPAN>list<SPAN class="punctuation token">(</SPAN>set<SPAN class="punctuation token">(</SPAN>year<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
a <SPAN class="operator token">=</SPAN> np<SPAN class="punctuation token">.</SPAN>array<SPAN class="punctuation token">(</SPAN>list<SPAN class="punctuation token">(</SPAN>zip<SPAN class="punctuation token">(</SPAN>year<SPAN class="punctuation token">,</SPAN> Project<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> dtype<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'year'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'<i4'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'project'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'U2'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

out <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> keys<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; kv <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>i<SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; idx <SPAN class="operator token">=</SPAN> np<SPAN class="punctuation token">.</SPAN>where<SPAN class="punctuation token">(</SPAN>a<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'year'</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">==</SPAN> i<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; vals <SPAN class="operator token">=</SPAN> a<SPAN class="punctuation token">[</SPAN>idx<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'project'</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; kv<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>vals<SPAN class="punctuation token">.</SPAN>tolist<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; out<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>kv<SPAN class="punctuation token">)</SPAN>

out

<SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">1960</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'A'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'G'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'J'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">1972</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'B'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'D'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'H'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'I'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">1980</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'C'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'E'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'F'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

EDIT

line 0 ADD the following line

import numpy as np

Sorry... been doing a lot of array programming lately so I found this the quickest.

Get the unique years (line 4)

Take your year and projects and form an array (or a list of lists). (line 5)

Then extract the projects for each year in the keys (line 8).

kv is just a small list to append the project list.

do what you want with the list of lists... you could make a dictionary if needed

Thiru_P

Hi Dan, it works fine. All the mosaics (T1960, T1972..) are created with prefix "T" just because, the mosaic names cant start with a number.

I have not figured out how to construct the list of films (projects) for each year and this is where I need help from.

I was reading your List Comprehension posts (Great contributions, btw) and could not figure how I can apply it.

Do I use array or dictionary?

DanPatterson_Retired

What happens? anything? no errors or output?

arcpy.CreateMosaicDataset_management(gdb,i,prjfile,'','','','')

do you want the year to be the name (ie 'i') or do you want 'T' in front of the year, since you test 'x' to see if it exists.

Thiru_P

Thanks, Dan. I copied and pasted partial code. My bad. Checked it. I have updated the snippet now.

DanPatterson_Retired

what message did you get... or what happened when you ran the script?

Lines 30-on need to be dedented since you would want to create th mosaic dataset after you have assembled all the parts not while you are within the searchcursor

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.