AnsweredAssumed Answered

Accessing shapefiles/dbfs within a geodatabase with python

Question asked by Carusot42 on Dec 30, 2014
Latest reply on Dec 30, 2014 by curtvprice

Like • Show 0 Likes0
Comment • 6

Hi folks,

I feel like there's a very simple answer to this because no matter how much I searched I couldn't find one, however I'm pretty much brand new to gdb's, have mostly just used shapefiles up until now and I'm having trouble getting python to access the table of/a shapefile within a geodatabase. Here is the script I'm writing currently, can someone give me some direction here?

import arcpy
# Set workspace
arcpy.env.workspace = "C:\Users\tmc18\Desktop\comp_orps\NYS_Wells.gdb"

# Define input feature layer & wells
orps09 = "C:\Users\tmc18\Desktop\comp_orps\centroids\madirps_point_Layer.lyr"
wells = "C:\Users\tmc18\Desktop\comp_orps\NYS_Wells.gdb\Madison_DEC_Well_Logs_3_14_14_MASTER_COPY.dbf"
wellshp = "C:\Users\tmc18\Desktop\comp_orps\NYS_Wells.gdb\Madison_DEC_Well_Logs_3_14_14_MASTER_COPY.shp"

# Define fields cursors will require
county = "County"

# Create search cursor
with arcpy.da.SearchCursor(wells, [county]) as cursor:
        for row in cursor:
                if county == "MADISON":
                        arcpy.SelectLayerByLocation_management(orps09, [within_a_distance, "1 km", add_to_selection])
                        cursor.next(row)
                else:
                        continue

I'm getting errors because within the gdb, the dbf and shapefiles don't exist. Since I see them there in ArcCatalog I thought it might work anyways, but obviously that is not the case.

Many thanks in advance for your help,

Tom

jrflannery Dec 30, 2014 8:42 AM

Correct Answer

Do you need an r in front of your file paths?

Like this:

wells = r"C:\Users\tmc18\Desktop\comp_orps\NYS_Wells.gdb\Madison_DEC_Well.dbf"

See the reply in context

No one else had this question

Outcomes

jrflannery Dec 30, 2014 8:42 AM

Do you need an r in front of your file paths?

Like this:

wells = r"C:\Users\tmc18\Desktop\comp_orps\NYS_Wells.gdb\Madison_DEC_Well.dbf"

Actions

Carusot42 @ jrflannery on Dec 30, 2014 8:50 AM

This did it. Thank you.

Actions

vangelo-esristaff

Dec 31, 2014 7:12 AM

Shapefiles are NOT stored within file geodatabases. Each is a different format. Data copied from a shapefile is manifested as a table in an FGDB.

You should not use a filesystem utility to place a shapefile in the ".gdb" directory of a file geodatabase. To copy the data into the FGDB, use ArcGIS or an application with the FGDB API access library enabled to create a new feature class table in the FGDB workspace. If you want to retain shapefile format, create a directory parallel to the .gdb (e.g., "NYS_Wells-shp"), and place the shapefiles there.

- V

2 people found this helpful

Actions

jrflannery Dec 30, 2014 9:35 AM

Thomas:

For future readers of your posted question.

From the great book Python Scripting for ArcGIS, by Paul Zandbergen, Chapter 4.14 - Working with Paths:

There are three correct ways to specify a path in Python:

Use a forward slash

“C:/EsriPress/Python/Data”

Use two backslashes

“C:\\EsriPress\\Python\\Data”

Use a string literal by placing the letter r before the string

r“C:\EsriPress\Python\Data”

1 person found this helpful

Actions

curtvprice

@ jrflannery on Dec 30, 2014 10:48 PM

There's also a nice article in the ArcGIS Desktop help.

Paths explained: Absolute, relative, UNC, and URL

Actions

xander_bakker Dec 30, 2014 5:59 PM

Dear Thomas Caruso ,

Although Joe Flannery may have answered your question and you are able to access your shapefile stored in the .gdb folder. this is not (and I repeat) *NOT* they way to solve your problem. As Vince Angelo indicates, you should NOT store shapefiles in the .gdb folder. It may corrupt the other data in the file geodatabase, Please, please, *PLEASE*, remove the files from the .gdb folder and store them elsewhere.

For a list of file extensions you will want to move to another folder, see: Shapefile - Wikipedia, the free encyclopedia or this old documentation: ArcGIS Desktop Help 9.2 - Shapefile file extensions

2 people found this helpful

Actions

6 Replies

jrflannery Dec 30, 2014 8:42 AM
Unmark Correct
Correct Answer
Do you need an r in front of your file paths?

Like this:
wells = r"C:\Users\tmc18\Desktop\comp_orps\NYS_Wells.gdb\Madison_DEC_Well.dbf"
Like • Show 0 Likes0
Actions
- Carusot42 @ jrflannery on Dec 30, 2014 8:50 AM
  Mark Correct
  Correct Answer
  This did it. Thank you.
  Like • Show 0 Likes0
  Actions
vangelo-esristaff Dec 31, 2014 7:12 AM
Mark Correct
Correct Answer
Shapefiles are NOT stored within file geodatabases. Each is a different format. Data copied from a shapefile is manifested as a table in an FGDB.

You should not use a filesystem utility to place a shapefile in the ".gdb" directory of a file geodatabase. To copy the data into the FGDB, use ArcGIS or an application with the FGDB API access library enabled to create a new feature class table in the FGDB workspace. If you want to retain shapefile format, create a directory parallel to the .gdb (e.g., "NYS_Wells-shp"), and place the shapefiles there.

- V
2 people found this helpful
Like • Show 1 Like1
Actions
jrflannery Dec 30, 2014 9:35 AM
Mark Correct
Correct Answer
Thomas:

For future readers of your posted question.
From the great book Python Scripting for ArcGIS, by Paul Zandbergen, Chapter 4.14 - Working with Paths:

There are three correct ways to specify a path in Python:

Use a forward slash
“C:/EsriPress/Python/Data”

Use two backslashes
“C:\\EsriPress\\Python\\Data”

Use a string literal by placing the letter r before the string
r“C:\EsriPress\Python\Data”
1 person found this helpful
Like • Show 0 Likes0
Actions
- curtvprice @ jrflannery on Dec 30, 2014 10:48 PM
  Mark Correct
  Correct Answer
  There's also a nice article in the ArcGIS Desktop help.
  Paths explained: Absolute, relative, UNC, and URL
  Like • Show 0 Likes0
  Actions
xander_bakker Dec 30, 2014 5:59 PM
Mark Correct
Correct Answer
Dear Thomas Caruso ,

Although Joe Flannery may have answered your question and you are able to access your shapefile stored in the .gdb folder. this is not (and I repeat) *NOT* they way to solve your problem. As Vince Angelo indicates, you should NOT store shapefiles in the .gdb folder. It may corrupt the other data in the file geodatabase, Please, please, *PLEASE*, remove the files from the .gdb folder and store them elsewhere.

For a list of file extensions you will want to move to another folder, see: Shapefile - Wikipedia, the free encyclopedia or this old documentation: ArcGIS Desktop Help 9.2 - Shapefile file extensions
2 people found this helpful
Like • Show 1 Like1
Actions

GeoNet

The Esri Community

Accessing shapefiles/dbfs within a geodatabase with python

Outcomes

Related Content

Recommended Content