Latest Contributions by jaykapalczynski

How do you start reading the CSV File from the second line...I have a header... ... View more

Yes as I parse the CSV I set the Hour and Minute to Variables... Hour Minute 16       2 This results in 4:02:00 PM when I run it in ArcGIS with the formula above. ... View more

OK I think I am making great progress with you help Brittney....THANKS A TON....This is what I have.... IF I go into the csv file and remove the header field names I get it to import fine. If I keep the header there I am getting errors because of field types etc...I cant seem to get it to start on the SECOND line of the CSV file.... import arcpy   fc = r'C:\Users\tjv36463\Desktop\Bear Collar\BearLocationImports.gdb\BearCollar'         #Insert cursor for the Bikes feature class #cursor = arcpy.da.InsertCursor ("bikes",["X", "Y","Address","SHAPE@XY"]) cursor = arcpy.da.InsertCursor (fc,["CollarSeri", "Year", "Julianday", "Hour", "Minute", "Activity", "Temperatur", "Latitude", "Longitude", "HDOP", "NumSats", "FixTime", "Date", "_2D_3D", "SHAPE@XY"])     #Read through each line of the csv, but skip the first row because it is the header #The count variable skips of the first row count = 0 for ln in open (r"C:\Users\tjv36463\Desktop\Bear Collar\rangedate_D032491_20160822124644.csv", 'r').readlines():       #if count > 0:     lineSplit = ln.split(",")     print lineSplit           #Each line in the csv is a string, so turn it into a list so you can reference each column         #lineSplit = ln.split(",")         #print lineSplit           #Use index positions to get the right column from the csv         #Make sure the data is the correct type (i.e. X and Y need to be numbers, not strings)     CollarSeri = long(lineSplit[0])     Year = str(lineSplit[1])     Julianday = str(lineSplit[2])     Hour = str(lineSplit[3])     Minute = str(lineSplit[4])     Activity = str(lineSplit[5])     Temperature = str(lineSplit[6])     Latitude = float(lineSplit[7])     Longitude = float(lineSplit[8])     HDOP = str(lineSplit[9])     NumSats = str(lineSplit[10])     FixTime = str(lineSplit[11])     _2D_3D = str(lineSplit[12])     Date = str(lineSplit[13])  # working with Date Time http://stackoverflow.com/questions/1521906/how-to-specify-date-and-time-in-python     shapeVal = (Longitude, Latitude)           #Insert the values from csv into feature class         #The order of the fields here, matches the order of the fields in line 4     cursor.insertRow ([CollarSeri, Year, Julianday, Hour, Minute, Activity, Temperature, Latitude, Longitude, HDOP, NumSats, FixTime, Date, _2D_3D, shapeVal])       count += 1   del cursor print ("done") ... View more

I modified your code a bit to this...I am getting an error.... I am a bit confused with the SHAPE@XY  I am using that when I index the variables and when I add it to the Feature Class....but there is no field for shapeXY.... Any thoughts?  THANKS again for you help. >>> ================================ RESTART ================================ >>> <da.InsertCursor object at 0x0000000007000C30> Traceback (most recent call last): File "C:/Users/tjv36463/Desktop/Bear Collar/ImportBearData.py", line 28, in <module> CollarSerialNumber = int(lineSplit[0]) NameError: name 'lineSplit' is not defined import arcpy   fc = r'C:\Users\tjv36463\Desktop\Bear Collar\BearLocationImports.gdb\BearCollar'   #Insert cursor for the Bikes feature class #cursor = arcpy.da.InsertCursor ("bikes",["X", "Y","Address","SHAPE@XY"]) cursor = arcpy.da.InsertCursor (fc,["CollarSerialNumber", "Year", "Julianday", "Hour", "Minute", "Activity", "Temperature", "Latitude", "Longitude", "HDOP", "NumSats", "FixTime", "2D/3D", "Date", "SHAPE@XY"])   #Read through each line of the csv, but skip the first row because it is the header #The count variable skips of the first row count =0 for ln in open (r"C:\Users\tjv36463\Desktop\Bear Collar\rangedate_D032491_20160822124644.csv", 'r').readlines():       if count > 0:         #Each line in the csv is a string, so turn it into a list so you can reference each column         lineSplit = ln.split(",")           #Use index positions to get the right column from the csv         #Make sure the data is the correct type (i.e. X and Y need to be numbers, not strings)        # xVal = float(lineSplit[0]   # yVal = float(lineSplit[1] # addVal = lineSplit[2]  # shapeVal = (xVal, yVal)   CollarSerialNumber = int(lineSplit[0]) Year = int(lineSplit[1]) Julianday = int(lineSplit[2]) Hour = int(lineSplit[3]) Minute = int(lineSplit[4]) Activity = int(lineSplit[5]) Temperature = int(lineSplit[6]) Latitude = float(lineSplit[7]) Longitude = float(lineSplit[8]) HDOP = int(lineSplit[9]) NumSats = int(lineSplit[10]) FixTime = int(lineSplit[11]) _2D_3D = int(lineSplit[12]) Date = str(lineSplit[13])   shapeVal = (Longitude,Latitude)             #Insert the values from csv into feature class         #The order of the fields here, matches the order of the fields in line 4         #cursor.insertRow([xVal, yVal, addVal, shapeVal]) cursor.insertRow ([CollarSerialNumber, Year, Julianday, Hour, Minute, Activity, Temperature, Latitude, Longitude, HDOP, NumSats, FixTime, _2D_3D, Date, shapeVal])   count += 1   del cursor ... View more

Brittney...thanks for you reply So  in you table/csv file example you have  3 fields correct?  Xval, Yval and an address Correct? "bikes" is you variable to the csv file location correct? cursor = arcpy.da.InsertCursor ("bikes",["X", "Y","Address","SHAPE@XY"])         xVal = float(lineSplit[0])         yVal = float(lineSplit[1])         addVal = lineSplit[2]         shapeVal = (xVal, yVal) ... View more

Do I need to import into a table and then create an event layer then append to Feature class? ... View more

I have a CSV file I dont think I can use SHAPE@XY.  DO I use the two XY FIelds somehow in the script? ... View more

How does it know what fields my XY Coordinates are in? Add fields like this?   #search ....snip   (csv, ['SHAPEXY'], [date], [field1], [field2]) as cursor:   ...snip # Insert ....snip   (fc, ['SHAPEXY'], [date], [field1], [field2]) as cursor:   ...snip ... View more