nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

HuihuangYu

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.

Encontre mais publicações marcadas com

Accepted answers

All comments

Asrujit_SenGupta

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

JoshuaBixby

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?

HuihuangYu

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

HuihuangYu

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

JoshuaBixby

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.

HuihuangYu

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)

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.