topic Make XY Event Layer not taking .CSV info in Transportation Questions

Make XY Event Layer not taking .CSV info

Anonymous User — Thu, 11 Apr 2013 22:23:14 GMT

Original User: SStrand

I have a project going that requires an input XY to be mapped as a point before buffered. The XY point is in a .csv file and using the Make XY Event Layer results in an empty data set no matter what I do. I thought maybe it had something to do with the environments, hence why it is split into two at the moment.

the csv file has the following:

X_FIELD, Y_FIELD
33.8, 118

Python:

    #Env 1
    env.workspace = "I:\InfoRequest"
    InfoRequestNum = arcpy.GetParameterAsText(1)
    loctable = "I:\InfoRequest\XYLocation.csv"
    sitelocfeat = "XYLOC" + InfoRequestNum
    sitelocfeature = "XY_Loc_" + InfoRequestNum
    locgdbtable = "XYLocation"

    #Import table to InfoRequestGDB
    arcpy.TableToGeodatabase_conversion([loctable], "I:\InfoRequest\InfoRequest.gdb")

    #Env 2
    env.workspace = "I:\InfoRequest\InfoRequest.gdb"

    arcpy.MakeXYEventLayer_management(locgdbtable, "X_FIELD", "Y_FIELD", sitelocfeat)
    arcpy.FeatureToPoint_management(sitelocfeat, sitelocfeature)

Re: Make XY Event Layer not taking .CSV info

RDHarles — Fri, 12 Apr 2013 11:48:59 GMT

Any reason you're not going directly from the .csv file to a layer when using arcpy.MakeXYEventLayer_management ?
Simply use the MakeXYEventLayer tool to create a layer from the .csv file and then export the layer to your FGDB.

Re: Make XY Event Layer not taking .CSV info

Anonymous User — Fri, 12 Apr 2013 13:04:48 GMT

Original User: SStrand

I was doing that in the beginning and was ending up with an empty data set, so I tried bringing it into the GDB as a table first (what the code is showing) and that table is empty as well.

Any reason you're not going directly from the .csv file to a layer when using arcpy.MakeXYEventLayer_management ?
Simply use the MakeXYEventLayer tool to create a layer from the .csv file and then export the layer to your FGDB.

Re: Make XY Event Layer not taking .CSV info

RDHarles — Sun, 12 Dec 2021 05:30:09 GMT

Strange.
Can you post a snippet of your csv table?
I just made a "fake" csv file like this and tried it and it worked fine:

X_FIELD, Y_FIELD, Stuff
-88.472, 40.987, Mom
-87.5435, 33.0, Dad

p.s. Here's the code...

import arcpy
arcpy.MakeXYEventLayer_management("xyEvent.txt", "X_FIELD", "Y_FIELD", "XYlayer")
arcpy.CopyFeatures_management("XYlayer", "XY.gdb/POIs")

Re: Make XY Event Layer not taking .CSV info

Anonymous User — Fri, 12 Apr 2013 15:13:02 GMT

Original User: SStrand

Mine looks exactly like yours, except I don't have a "stuff" type string field.

Maybe my issue is the " " which you have but I don't, though that seems like it would throw a code, not create the actual tables and points with empty data.

Re: Make XY Event Layer not taking .CSV info

RDHarles — Fri, 12 Apr 2013 17:03:29 GMT

Another issue I see is that your slashes are incorrect.

You need to use:
1.) forward slashes = /
2.) double backslashes = \\
3.) raw string = r"I:\InfoRequest"

Re: Make XY Event Layer not taking .CSV info

Anonymous User — Mon, 15 Apr 2013 14:52:46 GMT

Original User: SStrand

Thanks rdharles for the help, I've got it taking the X Y now.

But..now the XY point isn't displaying on the map properly...on to the next issue!