nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

copying values from string type column to double column

klabine

Essentially I am trying to get xy coordinates from a CSV. I have already converted the CSV to DBase and added 2 new double fields for LAT and LONG. But the original latitude and longitude values are in string type fields and contain "NA" values for some of the coordinates. I can remove the NA fields using a cursor because they are useless for plotting xy coordinates but I still am unable to copy the coordinate data from the string type columns to the new double type columns.

I have also tried the 2 following cursors as well

and regardless of what I do I receive the following error:

ExecuteError: ERROR 999999: Error executing function.
The value type is incompatible with the field type. [LAT]

Trouver plus de publications taguées avec

Accepted answers

DonMorrison1

Have you tried to explicitly convert the string to a double before writing it? For instance in your 2nd example:

row[1] = float(row[0])

All comments

klabine

Once I remove the weirdly formatted lat and long values it wont work using float but will work without so I have just done the following:

Thanks for your help!

klabine

I realize now that some of my data is incorrectly inputted (see below) and therefor I get this error : "ValueError: invalid literal for float(): 3.745.562.167". I can easily remove the incorrect data now, but the code will actually be used by people without gis experience and unfortunately these error will probably occur in future data. Is there a way to delete these error value rows within my cursor?

(still new to python, thanks for your help!)

DonMorrison1

Have you tried to explicitly convert the string to a double before writing it? For instance in your 2nd example:

row[1] = float(row[0])

danretired

Code formatting ... the Community Version - Esri Community

lat = "45.0"

float(lat)
45.0

You have to "float" text representations of numbers

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.