我应该使用什么数据库最适合我的 GIS 应用程序？
我目前正在开发一个程序，不知道从哪里开始...
我正在使用 Visual C# 和 DotSpatial 框架来完成 GIS/GPS 方面的工作，但不确定后端数据库是什么使用。
我查看了 PostgrSQL 和 PostGIS，还查看了 MSSQL，因为它现在具有地理空间功能。
所以我想通过该软件实现以下目标： - 该软件既需要在办公桌上使用，也需要在远程使用系统的 GIS/GPS 端来跟踪用户的出行。 （即，当定位他们需要去的地方时 - 这是远程站点上的自定义数据）。单独使用 DotSpatial 相对容易做到这一点，不需要 DB。 - 他们有自定义表格，可以在现场捕获数据（文本、纬度/经度、照片）。 - 当他们回到办公室时，数据需要能够与主数据库同步 - 一旦系统更新，连接到系统的每个人都需要查看这些数据。
最终，如果这可以是一种 DMS，那就太好了。所以我也牢记这一点。
我应该使用单独的数据库来进行数据捕获，而将其他数据库用于主数据库，还是应该对两者使用相同的数据库？哪一个最容易配置？我希望在部署软件时安装能够顺利进行，而不必手动配置每台计算机。
顺便说一句，主要服务器是Windows 2008 Server。
任何帮助或建议将不胜感激。
I am currently in the process of developing a program and not sure where to go from here...
I am using Visual C# and the DotSpatial frawework in order to do the GIS/GPS side of things but am unsure of what back end database to use.
I have had a look at PostgrSQL with PostGIS and also had a look at MSSQL as this now has Geospatial capabilities.
So what I am trying to achieve is the following with the software:
- The software needs to be used both at the persons desk, but also remotely while using the GIS/GPS side of the system to track the users travelling. (i.e. when locating where they need to go - this is custom data on remote sites). This is relatively easy to do with DotSpatial alone and not DB is needed.
- They have custom forms that capture data (text, lats/longs, photos) while out on site.
- The data needs to be able to sync up with the main database when they are back in the office
- This data needs to be viewable by everyone connected to the system once the system is updated
Ultimately if this can be a type of DMS then that would be great. So I am keeping that in mind as well.
Should I use a seperate DB for the datacapture side of things and something else for the main DB or should I use the same for both? Which one is easiest to configure? I would prefer when deploying the software that the installation goes smootly and dont have to manually configure each machine.
The main server is Windows 2008 Server btw.
Any help or suggestions would be greatly appreciated.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
我每天都将 PostgreSQL 与 PostGIS 结合使用。尽管它是开源的，但它提供了非常好的功能和性能。
检查 SQL Server 2008 Spatial、PostgreSQL/PostGIS 1.3-1.4 之间的交叉比较， MySQL 5-6。这可以给你一个好主意
I use PostgreSQL with PostGIS on a daily basis. Although it is opensource it provides very good funcionality and performance.
Check this Cross Compare between SQL Server 2008 Spatial, PostgreSQL/PostGIS 1.3-1.4, MySQL 5-6. This could give you a good idea
我赞同 PostgreSQL/PostGIS 的建议。它运作良好，并得到社区的大力支持。我注意到 OpenStreetMap 也使用 PostGIS。事实上，如果您想使用他们的数据，您将会需要 PostgreSQL。
I second the recommendation for PostgreSQL/PostGIS. It works very well and is well supported by the community. I would note that OpenStreetMap uses PostGIS as well. Indeed, if you ever want to work with their data you'll be wanting PostgreSQL.