AnsweredAssumed Answered

trying to extract data from a .gdb folder

Question asked by merrittr on Sep 27, 2014
Latest reply on Oct 2, 2014 by merrittr

Like • Show 0 Likes0
Comment • 6

i downloaded a gdb from a Canadian government site hoping to be able to extract some of the data. To my surprise the gdb shows up as a folder when the zip file is unzipped. How can I extract data from this database ....is there a way to query it?

partha.ghosh Sep 28, 2014 8:06 AM

Correct Answer

ArcMap > Window > ArcCatalog>Right Click on Folder Connection "Folder Connection" >Connect to
Folder
Select the folder where your .GDB file is stored. Click OK
Now the folder contains GDB is connected to ArcCatalog
Expand the .GDB file and see the content
Drag and drop the contents of the GDB file to ArcMap window to visualise the data.

See the reply in context

No one else had this question

Outcomes

6 Replies

asengupta-esristaff Sep 28, 2014 1:06 AM
Mark Correct
Correct Answer
If its a folder with an extension of '.gdb' (example: test.gdb), then it is a File Geodatabase. You will have to use ArcGIS Desktop to connect to it and view the data inside it or query etc.
Like • Show 0 Likes0
Actions
- merrittr @ asengupta-esristaff on Sep 28, 2014 7:52 AM
  Mark Correct
  Correct Answer
  Thanks Asrujit
  
  I click browse for more and navigate to that folder but I cant
  find any mxd to open?
  Like • Show 0 Likes0
  Actions
  - asengupta-esristaff @ merrittr on Sep 28, 2014 11:56 AM
    Mark Correct
    Correct Answer
    You can choose which data you would like to preview and add it accordingly in ArcMap. Then you can save that Map Document as an MXD for future use.
    
    Considering that you only had that folder in the zipped file, it seems that only the data was provided and not a pre-created Map Doc(MXD).
    Like • Show 0 Likes0
    Actions
partha.ghosh Sep 28, 2014 8:06 AM
Unmark Correct
Correct Answer
1. ArcMap > Window > ArcCatalog>Right Click on Folder Connection "Folder Connection" >Connect to
2. Folder
3. Select the folder where your .GDB file is stored. Click OK
4. Now the folder contains GDB is connected to ArcCatalog
5. Expand the .GDB file and see the content
6. Drag and drop the contents of the GDB file to ArcMap window to visualise the data.
Like • Show 0 Likes0
Actions
- merrittr @ partha.ghosh on Sep 28, 2014 6:04 PM
  Mark Correct
  Correct Answer
  Wow thanks Partha!
  
  now that I have the data in there is there a way to extract it into a csv ...what I am looking for is to get the metadata attached tp points into a sql database
  Like • Show 1 Like1
  Actions
  - merrittr @ merrittr on Oct 2, 2014 9:44 AM
    Mark Correct
    Correct Answer
    is there a way to use python to mine the data out into a csv file with the end goal of importing it into a MSSQL database?
    Like • Show 1 Like1
    Actions

GeoNet

The Esri Community

trying to extract data from a .gdb folder

Outcomes

Related Content

Recommended Content