topic Re: How to create a shp with specific attributes from txt file in Python Questions

How to create a shp with specific attributes from txt file

KONPETROV — Sat, 11 Dec 2021 20:19:30 GMT

Hi, i have the following code:

import arcgisscripting
gp = arcgisscripting.create()
input = "c:/Borders/home.txt"
inSep = "."
output = "c:/Borders/outtext.txt"
gp.CreateFeaturesFromTextFile(input, inSep, output, "#")

And my point txt is in that form:

Point

0 8674596.8 9856351.9 100.967430980

End

But the point i am getting doesn't have the third column. Why is that happening?

Re: How to create a shp with specific attributes from txt file

OwenEarley — Sun, 31 May 2015 22:44:13 GMT

Have you tried putting in a zero for the m value?

The documentation states that if the z and m values are not provided then they will be assigned a null value but the tool may be expecting none or both to be specified.

Would be a simple test:

Point

0 8674596.8 9856351.9 100.967430980 0.0

End

Re: How to create a shp with specific attributes from txt file

DanPatterson_Retired — Mon, 01 Jun 2015 00:03:19 GMT

the 3rd column is the z value if the first is an id. You have to creat pointZ file if you want the z values within the point. I would suggest that you create the point with X and Y and assign the z as a field.

Also, separating by space would be smarter than a period

also see other suggestions here arcgis desktop - Creating shp from txt files using ArcPy? - Geographic Information Systems Stack Exchange in case someone is just starting to research a solution

Re: How to create a shp with specific attributes from txt file

KONPETROV — Mon, 01 Jun 2015 02:19:00 GMT

the last column is just a value for the specific point not a z or an m value. Can't that be?

Re: How to create a shp with specific attributes from txt file

KONPETROV — Mon, 01 Jun 2015 02:21:39 GMT

unfortunately nothing changes

Re: How to create a shp with specific attributes from txt file

KONPETROV — Mon, 01 Jun 2015 02:53:25 GMT

this is an iteresting code i 've found from (http://gis.stackexchange.com/questions/149240/creating-shp-from-txt-files-using-arcpy?noredirect=1#comment218408_149240 ) but for some reason is not working for my data. I am posting it here:

import arcpy, os # Read txt file tmp = [line.split() for line in open(r'C:\temp\txtfile.txt')] """ Clean txt file and prepare for Insert Cursor Needs to be in the following format for this example: [('60.9090909091', ('347172.2', '4269952.7')), ('85.7334909091', ('337172.8', '4278952.4')), ('123.909673091', ('344572.3', '4547952.2')), ('456.467809091', ('347532.8', '8777952.8'))] """ row_values = [] for t in tmp: row_values.append((float(t[3]), (float(t[1]), float(t[2])))) # Define the shapefile shp = r'C:\temp\points.shp' # Define spatial reference and create shapefile. Factory code for NAD83 UTM 15N is used here sr = arcpy.SpatialReference(26915) arcpy.CreateFeatureclass_management (out_path = os.path.dirname(shp), out_name = os.path.basename(shp), geometry_type = "POINT", spatial_reference = sr) arcpy.AddField_management(shp, "Field1", "DOUBLE") # Use InsertCursor to update rows cursor = arcpy.da.InsertCursor(shp, ['Field1','SHAPE@XY']) for row in row_values: cursor.insertRow(row) # Clean up del cursor

Re: How to create a shp with specific attributes from txt file

OwenEarley — Mon, 01 Jun 2015 05:09:41 GMT

With the old gp.CreateFeaturesFromTextFile tool you are limited to just creating points with id, x, y, z and m values. I wouldn't bother using this old tool - getting the sample you found to work is a much better option.

Re: How to create a shp with specific attributes from txt file

OwenEarley — Sat, 11 Dec 2021 20:19:32 GMT

This example assumes the text file is comma separated (X, Y, Value). You will also need to change the spatial reference id and output field name to suit your needs:

import arcpy, os

# read data from file (x, y, custom value)
row_values = []
with open(r'G:\Temp\GeoNet\Script\test.txt') as f:
    for line in f:
        tmp = line.split(',')
        row_values.append((float(tmp[0]),float(tmp[1]),float(tmp[2])))

# Define the shapefile
shp = r'G:\Temp\GeoNet\Script\pts.shp'

# Define spatial reference and create shapefile.
sr = arcpy.SpatialReference(28355)
arcpy.CreateFeatureclass_management (out_path = os.path.dirname(shp), out_name = os.path.basename(shp), geometry_type = "POINT", spatial_reference = sr)
arcpy.AddField_management(shp, "DataField", "DOUBLE")

# Use InsertCursor to update rows
cursor = arcpy.da.InsertCursor(shp, ['SHAPE@X','SHAPE@Y','DataField'])
for row in row_values:
    cursor.insertRow(row)

# Clean up
del cursor

Re: How to create a shp with specific attributes from txt file

SepheFox — Mon, 01 Jun 2015 05:43:43 GMT

Maybe I'm missing something here, but can't this just be done by using the Create XY Event Layer (ArcGIS Help 10.1)? You would need to export to a shapefile after, of course.

Re: How to create a shp with specific attributes from txt file

KONPETROV — Mon, 01 Jun 2015 17:27:53 GMT

works excellent thank you Mr. Earley

Re: How to create a shp with specific attributes from txt file

KONPETROV — Mon, 01 Jun 2015 17:32:45 GMT

I could do that also Ms Fox, but i don't know what the first line of my txt should be, also the last column is not z or m value but a value i just need for each point

Re: How to create a shp with specific attributes from txt file

SepheFox — Mon, 01 Jun 2015 17:55:35 GMT

Hi Kon, The first line of your text would just be the field headings (x, y, value). A z or m value is not required. The tool converts your xy values to points, and maintains the other value fields as required. I just did a quick test of made up data of 3 points. It worked great. This was a simple notepad file with tabs between values:

Re: How to create a shp with specific attributes from txt file

KONPETROV — Sat, 11 Dec 2021 20:19:35 GMT

Ms Fox just to try it, i brought my data to that form

x,y,value
674596.8 9856351.9 100.967430980

and although the text in ArcMap has correctly put each number in x,y,value column when it comes to make x,y event layer i get an 000212 error. I tried the same with comma(,) and a space also but was the same.

Re: How to create a shp with specific attributes from txt file

OwenEarley — Sat, 11 Dec 2021 20:19:38 GMT

Make sure that the delimiters are the same for your column headings and values, for example use commas:

x,y,value  
674596.8,9856351.9,100.967430980

Re: How to create a shp with specific attributes from txt file

SepheFox — Mon, 01 Jun 2015 23:25:46 GMT

Well, I can see in your code snippet, you used comma separators for the first line, and then space or tab for the subsequent line. They would need to be the same. As I said, I used tab with no difficulties at all. The error description states:

"Verify that you have entered the correct parameters for this operation and that the data contained in the X and Y fields is in the correct format. The fields must be numeric to be displayed. For example, if the coordinate value is stored in degrees/minutes/seconds in a field (for example, -120 13 58), you need to convert the values to decimal degrees and store them in a numeric field. In addition, some characters in field names are not supported, such as dashes (for example, x-coord for the field name), spaces, and brackets. Before adding x,y data, you should edit the field names to remove these characters. For example, you can use the underscore character instead of the dash character in field names. For more information, see the Make XY Event Layer tool help." so you should make sure you don't have any of these issues first.