I created a point shapefile by converting a raster into points. The default fields generated were FID, Shape, POINT_ID, and GRID_CODE.
I added two new fields "X_location" and "Y_location". I generated the values for these two newly added fields by calculating geometry. Further, I extracted the corresponding NDVI and LST values for the points in the shapefile.
Now the problem is, when I apply the "Select by attributes" option, I can select values for the fields POINT_ID or GRID_CODE. But when the same is applied for the X_location, Y_location, NDVI or LST field, it doesn't work.
More specifically saying, I applied the following query.
Select by attributes--> Chose method as "Create new selection"--> "POINTID"--> Get Unique values--> "POINTID"= (Some value chosen from the retrieved value list)--> Apply. This query worked. But when the same was applied with a different field like "X_location", "Y_location", NDVI or LST, it selected nothing! Even after selecting a value from the list (after clicking "get unique values"), it showed, "0 out of 2799326 selected". I was only changing the field and getting the new unique values for the same field!
I made sure that the value I wanted to select, was present in the table. Also, in the ArcCatalog, in the file properties, I checked for index and there any index was not present. So I made new ones. Still it did not help.
Where exactly I am doing wrong?