0
votes
0answers
15 views

Select polylines that are having mutual points from another table with condition

I am struggling with this MapInfo SQL (or T-SQL) query too long so I need little help :) I have two tables: PIPES with polylines CHECK_NODES with points that represents starting and ending points ...
0
votes
0answers
85 views

Methods to calculate Viewshed analysis

Does anyone know an algorithm to calculate Viewshed analysis? I calculated them in ArcGIS, MapInfo and SAGA GIS. I wish to calculate Viewshed analysis using algorithm or methods which I can use in ...
0
votes
1answer
76 views

Viewshed calculation using SQL

Can i calculate viewshed in MS-SQL server? Viewshed analysis is Raster operation. I have elevation value vector observation as point vectors. Are there any methods to calculate Viewshed (using ...
1
vote
1answer
129 views

How to share *.sql files between ArcGIS and MapInfo?

In Denmark many municipalities have the same provider of public data. These data are pushed to a local database – often a SQL Server. The DBMS layout is the same for all municipalities. When I create ...
2
votes
1answer
867 views

How to use non-native spatial data from MS SQL Server with ogr2ogr?

I have some tables in MS SQL Server (2012) with WKT string columns. I want to export these data to a MapInfo tab file. Currently I am using the following command: ogr2ogr -f "MapInfo File" ...
0
votes
1answer
158 views

What is the best way to sum the area from a number of polygons in .NET/SQL Server?

I have an Mapbasic/.NET application that read data from SQL Server 2008 R2. I have a table with polygons and need to sum up the area of a subset of the polygons. This should work dynamic so the user ...
2
votes
3answers
310 views

How to save a QGIS workspace with database link for offline use?

Is it possible to save current workspace of QGIS for offline usage like in mapinfo? My workspace has link to database. and when I reopen workspace unlink in mapinfo it can't open it.
1
vote
0answers
115 views

Making donut without updating id in MapInfo

I wont to make a donut out of an polygon in MapInfo. I store my data in Sql Server 2008 R2 and access it as a linked table. In SQL Server the Id-column is an Identity column that is used to as a ...
4
votes
4answers
629 views

update spatial data from excel to ms-sql server 2008

I have 1000's of data with 50's of column. It is point data. The data is in MS-SQL server.Now each day I need to load 100's of data similar in structure. How can I achieve it ? I tried to append ...
0
votes
1answer
279 views

Where does MapInfo store its error and log files?

I am having errors opening a table with spatial co-ordinates in Microsoft SQL and my question in gis.stackexchange is here. I want to know where are the error and log files of Mapinfo stored. I ...
19
votes
8answers
6k views

What are the best databases for storing spatial data? Pros and Cons

A couple of days ago I installed the demo of spatialware 4.9 from MapInfo into my SQL Server 2005 install and loaded all the larger dataset into it. I was quite impressed with the performance vs the ...