如何从压缩的ESRI shapefile数据源中提取地址信息? [英] How can I extract the address information from a Compressed ESRI shapefile datasource?

问题描述

当我从网站下载zip文件时，它包含具有以下扩展名的文件:

When I download the zip file from the website it contains files with the following extensions:

.dbf .prj .sbn .sbx .shp .shp.xml .shx

.dbf .prj .sbn .sbx .shp .shp.xml .shx

这是我下载或购买的转换器的通用数据文件格式吗? 我认为这是某种映射数据文件，但我所需要的只是它包含到我们现有数据库中的地址.

Is this is a common data file format that I download or purchase a converter? I think this is some kind of mapping data file but I all need are the addresses it contains to push into our existing database.

专门与编程有关.如何为这组文件或仅包含实际信息的.dbf文件设置.NET数据源?

Specifically and related to programming. How can I setup a .NET Datasource to this group of files or just the .dbf file that actually contains the information?

推荐答案

非常感谢提供信息的每个人.我发现了一个正是我所需要的CodePlex C#项目.我确实必须做一个小修改，然后将其发布回项目讨论板上，该修改是针对"F"的未知列类型的.但是命令行程序DBF2CSV可以通过dbf文件很好地创建格式良好的csv.在使用Excel几分钟后，我准备将其导入到我们的MySQL数据库中.

Much thanks to everyone who provided information. I found a CodePlex C# project that was exactly what I needed. I did have to make one small modification which I posted back on the project discussion board which was for an unknown column type of "F". But the command line program DBF2CSV worked beautifully to create a well formated csv from the dbf file. After a few minutes with Excel I had it ready to import to our MySQL database.

以下项目具有一个命令行程序，该程序会将DBF文件转换为CSV http://www.codeplex.com/fastdbf

The following project has a command line program that will convert a DBF file to CSV http://www.codeplex.com/fastdbf

这篇关于如何从压缩的ESRI shapefile数据源中提取地址信息?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！