问题描述
当我从网站下载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 CSVhttp://www.codeplex.com/fastdbf
这篇关于如何从压缩的ESRI shapefile数据源中提取地址信息?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！