0

I just run spatial join on two big tables I have. for some reason, one of the columns has changed its values- for example, on the original input layer I had this value. :

72145367277699000

the datatype of this is 'real' , column ID_Agri field ID_Agri

and on the output join layer it changed to:

72145400000000000

enter image description here Does anyone know what makes this difference.

  • Please Edit the question to specify the datatype of the column. It looks like a 32-bit float (single), which can only store 6-7 significant digits. – Vince May 30 at 12:10
  • Datatype is a property of every field. – Vince May 30 at 12:18
  • 1
    It is not safe to store ID values in floating-point representation, especially those whose formatted width exceeds the theoretical maximum of double precision, much less single precison. – Vince May 30 at 13:32
  • so how can I solve it? how can I change the way it is stored? is that the reason it happens? – Reut May 30 at 17:11
  • Copying the IDs into text field would work. The values and data type will not change in the Spatial Join. – klewis May 30 at 18:40

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.