topic Re: Adding XY Coordinates from a table (.csv) file into ArcMap using Python in ArcGIS Online Questions

Adding XY Coordinates from a table (.csv) file into ArcMap using Python

ShalinR — Sat, 02 May 2020 03:20:35 GMT

I do not where I went wrong here. Please help me.

import arcpy
import fileinput
import string
import os
from arcpy import env
env.workspace = "P:\GEOG - Programming in GIS\Final project\Data"
env.overwrightOutput = True
outpath = "P:\GEOG - Programming in GIS\Final project\Data"
newfc= "Results/NewPtssss.shp"
arcpy.CreateFeatureclass_management(outpath, newfc, "Point")
infile = "P:\GEOG - Programming in GIS\Final project\Data\coordinates.txt"
cursor = arcpy.da.InsertCursor(newfc, ["SHAPE@"])
array = arcpy.Array()
for point in fileinput.input(infile):
if ":" in point:
x, y = string.strip().split(":")
array.add(arcpy.Point(x, y))
cursor.insertRow([arcpy.Point(array)])
fileinput.close()
del cursor

I get the following error:
Traceback (most recent call last):
File "P:/GEOG - Programming in GIS/XYToPoint_Practice.py", line 18, in <module>
cursor.insertRow([arcpy.Point(array)])
File "P:\ArcMap\Desktop10.7\ArcPy\arcpy\arcobjects\mixins.py", line 1122, in __init__
setattr(self, attr, value)
File "P:\ArcMap\Desktop10.7\ArcPy\arcpy\arcobjects\_base.py", line 89, in _set
return setattr(self._arc_object, attr_name, cval(val))
RuntimeError: Point: Input value is not numeric

Re: Adding XY Coordinates from a table (.csv) file into ArcMap using Python

DanPatterson_Retired — Sat, 02 May 2020 04:48:52 GMT

/blogs/dan_patterson/2016/08/14/script-formatting

Format your code so indentation can be checked and people can answer with respect to line numbers.

Re: Adding XY Coordinates from a table (.csv) file into ArcMap using Python

DanPatterson_Retired — Sat, 11 Dec 2021 21:57:51 GMT

pnt = "1.1:2.2"

coords = pnt.strip().split(":")

x, y = [float(val) for val in coords]‍‍‍‍‍

x, y
(1.1, 2.2)‍‍‍‍‍‍‍‍

For your immediate problem, you weren't splitting the point (pnt) into its constituent parts properly,

python's "split" returns a list of string values,

They need to be converted to 'float' values before you pass them on to arcpy's Point object.

Re: Adding XY Coordinates from a table (.csv) file into ArcMap using Python

ShalinR — Sat, 02 May 2020 14:30:48 GMT

Sorry about the formatting. Never previously posted a question of this nature. Thanks for the reply. So am I replacing the code example you provided for line 14?

Re: Adding XY Coordinates from a table (.csv) file into ArcMap using Python

Katie_Clark — Sat, 02 May 2020 16:09:05 GMT

One quick thing I'm not sure if you already noticed (it's not directly related to your error message), but you have a typo in the beginning....should be env.overwriteOutput, not env.overwrightOutput

Re: Adding XY Coordinates from a table (.csv) file into ArcMap using Python

ShalinR — Sat, 02 May 2020 17:50:25 GMT

Thanks for catching my mistake. So I ended up using another script, which I'm attaching to the reply, and I got no errors. But the problem now is that the point shapefile prints points nowhere near the shapefile of the state that I am trying to plot them onto.

Re: Adding XY Coordinates from a table (.csv) file into ArcMap using Python

ShalinR — Sat, 02 May 2020 17:55:31 GMT

Whoops, made a mistake with latitude and longitude, will let you know if that was the mistake I made.

Re: Adding XY Coordinates from a table (.csv) file into ArcMap using Python

ShalinR — Sat, 02 May 2020 18:05:23 GMT

That was it. All the points are where I needed them to be. Thanks for all your help Katherine Clark @Dan Patterson

Re: Adding XY Coordinates from a table (.csv) file into ArcMap using Python

JoshuaBixby — Sun, 03 May 2020 13:34:12 GMT

Please mark a reply as Correct or mark the thread as assumed answered to close it out. Also, make sure to mark Helpfuls for comments that were, well, helpful.