AnsweredAssumed Answered

Combining polygons by date fields

Question asked by paulbritten on Aug 12, 2014
Latest reply on Aug 20, 2014 by paulbritten

I have an interesting problem.  I have been asked to create a set of polygons using dates.  Below is an example table showing the data.  As you can see the table is sorted by start year.

 

What I have to do is generate a set of polygons each time the start year, month and day changes.  So the first polygon will just contain the first row of data.  The second polygon will contain both the first and second and so on.

 

There is also another element to this.  Each row of data has an end year, month and day.  If a row has an end year of 2300 then that row will stay in the output once it has been added.  If there is an end year that does not equal 2300 then that row will not be included in future versions of the output.

 

data.jpg

So is there anyone who can help?  I have about two hundred tables like the one above. Would like a model builder solution.

 

Thanks in anticipation.

 

Paul

Outcomes