Make XY Event Layer not taking .CSV info

Question

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)

Originals.jpg

Mosaic.jpg

PeterMacKenzie2_2-1643238487581.png

PeterMacKenzie2_1-1643238415300.png

Anonymous User · Answer

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!

RDHarles · Answer

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"

Anonymous User · Answer

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.