Convert dbf to numpy array

Discussion created by Dolichonyx on Dec 15, 2011
Latest reply on Dec 16, 2011 by csny490

Like • Show 0 Likes0
Comment • 3

I need to use Python to convert a data table in .dbf format generated by ArcGIS 10 to a Numpy array.

Is there a simple way to do this? Forgive me if this is a naive question, but I was unable to find anything on the help pages.

Thanks!

Outcomes

3 Replies

csny490 Dec 15, 2011 2:04 PM
I don't have an example, but basically you would have to use a search cursor to loop through the fields and records.

http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//002z0000001q000000
Like • Show 0 Likes0
Actions
Dolichonyx Dec 16, 2011 6:08 AM
Thanks! I'm still pretty new to Python, so never would have found that.
Below is the code that I came up with:

from numpy import *
import arcpy

rows = arcpy.SearchCursor("Z://Code//EX2_near.dbf","","","","")

currentIN_FID = ""
currentNear_FID = ""
currentNear_Dist = ""
newdata = []

# Iterate through the rows in the cursor
#
for row in rows:
rowN = [row.IN_FID, row.NEAR_FID, row.NEAR_DIST]
newdata.append (rowN)

print newdata
datatwo = array([newdata])
Like • Show 0 Likes0
Actions

csny490 Dec 16, 2011 7:06 AM

Yep -

Also, if you wanted to "variabalize" the field names (use the field names as varaibles) it would look like:

from numpy import *
import arcpy
rows = arcpy.SearchCursor("Z://Code//EX2_near.dbf","","","","")
currentIN_FID = "IN_FID" 
currentNear_FID = "NEAR_FID"
currentNear_Dist = "NEAR_DIST"
newdata = []
# Iterate through the rows in the cursor 
for row in rows: 
   rowN = [row.getValue(currentIN_FID), row.getValue(currentNear_FID), row.getValue(currentNear_Dist)]
   newdata.append (rowN)
del row, rows #be sure to delete the cursor objects, otherwise a lock on the table will persist!!!
print newdata
datatwo = array([newdata])

Actions

GeoNet

The Esri Community

Convert dbf to numpy array

Outcomes

Related Content

Recommended Content