trying to extract data from a .gdb folder

[robmerritt]

Hi

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?

[AsrujitSengupta]

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.

[robmerritt]

Thanks Asrujit

I click browse for more and navigate to that folder but I cant
find any mxd to open?

[AsrujitSengupta]

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).

[ParthaGhosh__GISP · Accepted solution]

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.

[robmerritt]

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

[robmerritt]

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?