Jump to content

 
Photo

arcgis selection issue

- - - - -

  • Please log in to reply
2 replies to this topic

#1
lc500

lc500

    Contributor

  • Validated Member
  • PipPip
  • 11 posts
  • No Country Selected

I want to select a number of rows from an attribute table with the selection tool. The problem is that the information is in date format "6:00:00 AM" and it is not reading the information. Therefore I have to do it manually, and I have like 50,000 rows in the table which is impossible.

How can I get around this? I've tried just sorting by time in ascending order, which works, but it takes a million years. I've also tried using the selection by attributes, this doesnt work.

#2
frax

frax

    Hall of Fame

  • Associate Admin
  • PipPipPipPipPipPipPip
  • 2,295 posts
  • Gender:Male
  • Location:Stockholm, Sweden
  • Interests:music, hiking, friends, nature, photography, traveling. and maps!
  • Sweden

date format "6:00:00 AM"


Is this a string column? Can you try parsing the strings and convert them to proper date/time values? (using python, for instance)
Hugo Ahlenius
Nordpil - custom maps and GIS
http://nordpil.com/
Twitter

#3
Craig Jr

Craig Jr

    Contributor

  • Validated Member
  • PipPip
  • 15 posts
  • Gender:Male
  • Location:Cold Spring, NY
  • United States

I want to select a number of rows from an attribute table with the selection tool. The problem is that the information is in date format "6:00:00 AM"

You can try querying from the attribute table with # instead of " as you would with a string field. Example: #05/15/2012#




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

-->