topic Re: Creating dbf in Python in Python Questions

Creating dbf in Python

MelissaTalley — Tue, 11 Oct 2011 02:10:42 GMT

I currently have a python script that I'm using in the middle of a model which performs matrix algebra from an output of my model (a .txt file) and another .txt file.

I need to use the resulting array of the matrix algebra in my model. The best way I can think of to do this would be to create a .dbf file that I would join to my original shapefile. Is there a way to accomplish this? I know I can create a text file from the array, but I can't seem to find a way to import this into my model.

Re: Creating dbf in Python

KimOllivier — Tue, 11 Oct 2011 03:35:24 GMT

A text file can be loaded as a table, you would need to have a valid header and it helps a lot if you also have a schema.ini file with an entry to define field types, otherwise they all default to char fields 255 wide.

Re: Creating dbf in Python

MelissaTalley — Wed, 12 Oct 2011 01:37:20 GMT

Thank you! I will try this. I know how to create the table in Python, but what tool would I use to load the table from the text file in Model Builder?

Re: Creating dbf in Python

Jasonvan_Warmerdam — Sun, 12 Dec 2021 16:27:21 GMT

Using the arcpy module for Arc 10 you can use the following two functions to convert a text file back to a shapefile:

#Variable that is assigned an input folder location
workspace = 'C:/folderPath'

#Variable that is assigned a string name. This will be what your exported shapefile will be called.
newLayer = 'layerName'

#Create the new Event Layer. The arguments 'x','y' and 'z' are the header names associated with your lat,lon and elevation respectively
arcpy.MakeXYEventLayer_management('textFile.csv', 'x', 'y', newLayer, '', 'z')

# Process: Feature Class To Shapefile (multiple)
arcpy.FeatureClassToShapefile_conversion('layerName', workspace)