topic Re: Export Features based on Unique Value in a Field (date value) in Geoprocessing Questions

Export Features based on Unique Value in a Field (date value)

ChristopherBlinn — Fri, 08 Apr 2011 04:36:19 GMT

Hello All,

I am trying to figure out a way to select records from a shapefile (a specific date in (m)m/(d)d/yyyy format, (m) and (d) only for double digits) and export the selection to create a new shapefile. The issue is I have over 400 of these dates, and rather than selecting each one individually, right clicking the layer, exporting the data, wash, rinse repeat, I'd like to figure out a way to do this like an iteration in modelbuilder.

I read over this post: http://forums.arcgis.com/threads/27764-Model-Iterator-for-Date-Ranges

It sounds similar to what I am doing except I only have one field for a date, and I just need to select and extract features with similar dates. Also, I am a newbie with modelbuilder and I don't really mess with python, so the script in the forum above is like reading a different language.

Any help is appreciated and thank you in advance!

Best,
Chris

Re: Export Features based on Unique Value in a Field (date value)

ChristopherBlinn — Fri, 08 Apr 2011 04:50:48 GMT

I should add that I am using ArcGIS 10.0 SP1

Re: Export Features based on Unique Value in a Field (date value)

ChristopherBlinn — Fri, 08 Apr 2011 05:21:55 GMT

Here is the model I have started. I can't seem to get the SQL correct for it to work.

"DATE_" = Value

I have also tried:

"DATE_" = %Value%

Re: Export Features based on Unique Value in a Field (date value)

ChristopherBlinn — Fri, 08 Apr 2011 05:47:31 GMT

I fixed the issue, my SQL needed to say:

DATE_ = date '%Value%'