topic Re: How to load U.S. national address database use arcGIS? in ArcGIS Pro Questions

How to load U.S. national address database use arcGIS?

HuihuangYu — Thu, 21 Mar 2019 04:17:02 GMT

hey guys, I am totally new here. I am looking for an addressed database of U.S.A for my project. Glad to see that there is one provided by transportation.gov:"National Address Database | US Department of Transportation ". Anyone can download it after agree the disclaimer.

However, after I downloaded it, I found the content is not recognisable to me. It is a .gbd folder which contains lots of a0000*.* files. I tried to search online to understand them and it brings me to here. It looks like artGIS should have the capability to read those files. however, after I downloaded the ArcGIS Pro, I even get lost further.

Can any expert help me out here? I really appreciate it.

Re: How to load U.S. national address database use arcGIS?

Asrujit_SenGupta — Sun, 24 Mar 2019 05:16:17 GMT

The *.gdb is a File Geodatabase. You can access the data inside that File geodatabase using ArcGIS Desktop or ArcGIS Pro.

What is a file geodatabase?—Help | ArcGIS Desktop

Connect to a database—ArcGIS Pro | ArcGIS Desktop

Different methods can be used to access different databases associated with a project. File geodatabases and connections to enterprise databases are stored on the file system. If you connect your project to a folder in which these databases are stored, you will see them in the folder.

Connect to a folder—ArcGIS Pro | ArcGIS Desktop

Re: How to load U.S. national address database use arcGIS?

JoshuaBixby — Sun, 24 Mar 2019 14:16:00 GMT

Since you seem to be completely unfamiliar with ArcGIS and its data formats, what structure are you looking for the data to be in, and what program do you plan on using it in?

Re: How to load U.S. national address database use arcGIS?

HuihuangYu — Sun, 24 Mar 2019 23:53:56 GMT

hey Joshua,

thanks a lot for your reply. yes, i am totally new to the software and its data format. i am hoping the data can be somehow exported or transferred to a format that could work with RDBMS. idealy MySQL.

looking forward to hear back from you.

cheers,

Huihuang

Re: How to load U.S. national address database use arcGIS?

HuihuangYu — Mon, 25 Mar 2019 00:04:23 GMT

hey Asrujit,

thanks for your reply. As Joshua said, i am completely unfamiliar with ArcGIS and its data formats, so i could not understand how to use it. i actually had added the database and also can see the records by click View Metadata -> Table. however, i am still confused. is there actually only one table? Is this "table" the same as the table concept of RDBMS? can we somehow export or transfer this table to be something that can be import to any RDBMS? Even just a csv file could help.

cheers,

Huihuang

Re: How to load U.S. national address database use arcGIS?

JoshuaBixby — Mon, 25 Mar 2019 14:21:02 GMT

Since it doesn't seem like you are interested in using spatial tools, e.g., ArcGIS, PostGIS, QGIS, etc..., to work with this data; I suggest you look into GDAL: GDAL - Geospatial Data Abstraction Library to simply convert from the file geodatabase format to MySQL.

Re: How to load U.S. national address database use arcGIS?

HuihuangYu — Tue, 26 Mar 2019 04:44:48 GMT

hey Joshua,

thank you very much for your suggestion. could i please hire you to do this job for me? you need to also provide me the detail instruction of how you do it. so that even i can follow the instruction to repeat it. could you please contact me via huihuang.yu@gmail.com to send me a quote of the cost?

thanks a lot.

Huihuang (Marc)

Re: How to load U.S. national address database use arcGIS?

JoshuaBixby — Tue, 26 Mar 2019 13:47:14 GMT

Sorry Marc, I am not available for side work at the moment. Using Google or some other search engine, you should be able to sort out the conversion within a day. There are lots of tutorial and forum questions/answers on using GDAL to convert data.