如何将gis应用程序连接到像sql server这样的数据库? [英] How to connect gis application to database like sql server?

问题描述

我想构建一个关于巴厘岛艺术商店的简单gis桌面应用程序.我想制作类似google Earth的gis应用程序，因此，当用户单击商店位置时，它将出现有关商店的信息，例如名称，地址和电话号码.但是我不明白如何将地图与数据库连接起来，以便在单击商店的位置时可以显示商店的信息..谢谢您回答我的问题

I want to build a simple gis desktop application about art shop in Bali.. i want to make the gis application like google earth, so when user click the place of the shop, it will appear information about the shop like name, address, and phone number. but i don''t understand how to connect the map with the database, so that the information of the shop can appear if the place of the shop was clicked.. thank you for anwswer my question

推荐答案

我的猜测是，这将超出您的技能范围.

GIS是一个非常复杂的系统.如果已经构建了地图，则只需在鼠标下获取坐标，然后将这些坐标与数据库中的坐标进行比较.

如果数据库包含点，那么您将要在点周围包括一个缓冲区，因为人们精确点击该点的机会很小.如果是多边形，则只需要检查用户是否在多边形内单击即可.但是，如果它是一个复杂的多边形，则确定该多边形将非常困难.

我的建议是只创建一个KML并将其加载到Google Earth或在线创建Google Map，而不是尝试构建GIS.

但是，如果您真的想构建自己的GIS应用程序，那么请考虑订阅ESRI开发人员网络，这将为您提供已经为顶级GIS程序编写的API.然后，您只需为运行您的应用程序的任何计算机购买ArcEngine许可证.

My guess is that this is going to be way beyond your skills.

A GIS is an extremely complex system to build. If you have the map already built, then you would just have to get the coordinates under the mouse and then compare those coordinates with the coordinates in the database.

If the database contains points, then you''ll want to include a buffer around the points because the chances of the person clicking exactly on the point is pretty slim. If it''s a polygon, then you just need to check if the user clicked inside the polygon. But if it''s a complex polygon, determining that can be quite difficult.

My suggestion is to simply create a KML and load that into Google Earth or create a Google Map online instead of trying to build a GIS.

But if you really want to build your own GIS application, then look into getting a subscription to the ESRI developer''s network which will provide you with API''s already written for the top GIS program out there. Then, you''d just have to purchase an ArcEngine license for any machine running your application.

这篇关于如何将gis应用程序连接到像sql server这样的数据库?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！