topic Re: trying to extract data from a .gdb folder in Geodatabase Questions https://community.esri.com/t5/geodatabase-questions/trying-to-extract-data-from-a-gdb-folder/m-p/836892#M4496 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #1f497d; font-family: 'Calibri','sans-serif'; font-size: 11pt;">Thanks Asrujit</SPAN></P><P><SPAN style="color: #1f497d; font-family: 'Calibri','sans-serif'; font-size: 11pt;"> </SPAN></P><P><SPAN style="color: #1f497d; font-family: 'Calibri','sans-serif'; font-size: 11pt;">I click browse for more and navigate to that folder but I cant<BR />find any mxd to open?</SPAN></P></BODY></HTML> Sun, 28 Sep 2014 14:52:48 GMT robmerritt 2014-09-28T14:52:48Z trying to extract data from a .gdb folder https://community.esri.com/t5/geodatabase-questions/trying-to-extract-data-from-a-gdb-folder/m-p/836890#M4494 <HTML><HEAD></HEAD><BODY><P>Hi</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>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?</P></BODY></HTML> Sun, 28 Sep 2014 02:30:34 GMT https://community.esri.com/t5/geodatabase-questions/trying-to-extract-data-from-a-gdb-folder/m-p/836890#M4494 robmerritt 2014-09-28T02:30:34Z Re: trying to extract data from a .gdb folder https://community.esri.com/t5/geodatabase-questions/trying-to-extract-data-from-a-gdb-folder/m-p/836891#M4495 <HTML><HEAD></HEAD><BODY><P>If its a folder with an extension of '.gdb' (example: <STRONG>test.gdb</STRONG>), then it is a <STRONG>File Geodatabase</STRONG>. You will have to use ArcGIS Desktop to connect to it and view the data inside it or query etc.</P></BODY></HTML> Sun, 28 Sep 2014 08:06:24 GMT https://community.esri.com/t5/geodatabase-questions/trying-to-extract-data-from-a-gdb-folder/m-p/836891#M4495 AsrujitSengupta 2014-09-28T08:06:24Z Re: trying to extract data from a .gdb folder https://community.esri.com/t5/geodatabase-questions/trying-to-extract-data-from-a-gdb-folder/m-p/836892#M4496 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #1f497d; font-family: 'Calibri','sans-serif'; font-size: 11pt;">Thanks Asrujit</SPAN></P><P><SPAN style="color: #1f497d; font-family: 'Calibri','sans-serif'; font-size: 11pt;"> </SPAN></P><P><SPAN style="color: #1f497d; font-family: 'Calibri','sans-serif'; font-size: 11pt;">I click browse for more and navigate to that folder but I cant<BR />find any mxd to open?</SPAN></P></BODY></HTML> Sun, 28 Sep 2014 14:52:48 GMT https://community.esri.com/t5/geodatabase-questions/trying-to-extract-data-from-a-gdb-folder/m-p/836892#M4496 robmerritt 2014-09-28T14:52:48Z Re: trying to extract data from a .gdb folder https://community.esri.com/t5/geodatabase-questions/trying-to-extract-data-from-a-gdb-folder/m-p/836893#M4497 <HTML><HEAD></HEAD><BODY><OL><LI>ArcMap &gt; Window &gt; ArcCatalog&gt;Right Click on Folder Connection "Folder Connection" &gt;Connect to</LI><LI>Folder <IMG alt="GDB_Connection-1.jpg" class="jive-image image-1" height="238" src="https://community.esri.com/legacyfs/online/16154_GDB_Connection-1.jpg" width="452" /></LI><LI>Select the folder where your .GDB file is stored. Click OK<IMG alt="GDB_Connection-2.jpg" class="jive-image image-2" height="194" src="https://community.esri.com/legacyfs/online/16155_GDB_Connection-2.jpg" width="454" /></LI><LI>Now the folder contains GDB is connected to ArcCatalog</LI><LI>Expand the .GDB file and see the content <IMG alt="GDB_Connection-3.jpg" class="jive-image image-3" height="206" src="https://community.esri.com/legacyfs/online/16156_GDB_Connection-3.jpg" width="454" /></LI><LI>Drag and drop the contents of the GDB file to ArcMap window to visualise the data.<IMG alt="Untitled.jpg" class="image-4 jive-image" height="215" src="https://community.esri.com/legacyfs/online/16157_Untitled.jpg" width="462" /></LI></OL></BODY></HTML> Sun, 28 Sep 2014 15:06:27 GMT https://community.esri.com/t5/geodatabase-questions/trying-to-extract-data-from-a-gdb-folder/m-p/836893#M4497 ParthaGhosh__GISP 2014-09-28T15:06:27Z Re: trying to extract data from a .gdb folder https://community.esri.com/t5/geodatabase-questions/trying-to-extract-data-from-a-gdb-folder/m-p/836894#M4498 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>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).</P></BODY></HTML> Sun, 28 Sep 2014 18:56:46 GMT https://community.esri.com/t5/geodatabase-questions/trying-to-extract-data-from-a-gdb-folder/m-p/836894#M4498 AsrujitSengupta 2014-09-28T18:56:46Z Re: trying to extract data from a .gdb folder https://community.esri.com/t5/geodatabase-questions/trying-to-extract-data-from-a-gdb-folder/m-p/836895#M4499 <HTML><HEAD></HEAD><BODY><P>Wow thanks Partha!</P><P></P><P>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</P></BODY></HTML> Mon, 29 Sep 2014 01:04:23 GMT https://community.esri.com/t5/geodatabase-questions/trying-to-extract-data-from-a-gdb-folder/m-p/836895#M4499 robmerritt 2014-09-29T01:04:23Z Re: trying to extract data from a .gdb folder https://community.esri.com/t5/geodatabase-questions/trying-to-extract-data-from-a-gdb-folder/m-p/836896#M4500 <HTML><HEAD></HEAD><BODY><P>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?</P></BODY></HTML> Thu, 02 Oct 2014 16:44:38 GMT https://community.esri.com/t5/geodatabase-questions/trying-to-extract-data-from-a-gdb-folder/m-p/836896#M4500 robmerritt 2014-10-02T16:44:38Z