All Questions
Tagged with sql-server-spatial arcgis-desktop
12 questions
0
votes
1
answer
175
views
Create a Clone of existing Spatial DB on SQL Server instance
I have a spatial database on a SQL Server Instance. I want to create a copy of it in the same instance. I tried the following approaches:
Backing up the existing XYZ DB and restoring it with a new ...
- 75
1
vote
0
answers
341
views
Converting non-simple geometries to simple so ArcGIS Pro can display and process them
In SQL Server 2016 I'm using GEOMETRY::UnionAggregate to dissolve some polygons into larger ones. Here is a simplified example of my select:
select ta.TRANUM, GEOMETRY::UnionAggregate(pp.SHAPE) SHAPE ...
- 2,354
0
votes
1
answer
321
views
Unable to connect to SQL Server tables with 10.5 ArcMap but it works with 10.7
I have a requirement where I need to connect to the SQL Server which I have created using ArcCatalog 10.7.
I have a requirement where I need to now use 10.5 version. But when I attempt to connect to ...
- 23
0
votes
0
answers
253
views
ArcGIS Server and Microsoft SQL Server database connection
I have an ArcGIS Server and I need to register a Microsoft SQL Server database as a data storage. When I connect to database directly from ArcMap everything is fine, but when i'm trying to register a ...
- 309
1
vote
1
answer
115
views
Unable to select SQL Spatial table line feature
I have a table in a SQL database that has been spatially enabled with a geography column.
In ArcGIS it is a line feature and can be viewed in ArcMap with no issues and even published as a map service ...
- 469
2
votes
1
answer
504
views
Modify a polygon that WKT is POLYGON EMPTY
First of all, I'm not a GIS professional, just a developer using SQL spatial tools. I am inserting data in to ArcGIS feature class to be modified by users within ArcGIS desktop. For most cases, ...
- 131
1
vote
1
answer
410
views
Dealing with different MSSQL geometry types in ArcGIS for Desktop?
I have a Microsoft SQL Server 2008 spatial database holding both point and polygon geometry data types. Displaying the data with the software which captures the data is not a problem, but ArcGIS 10.3....
- 10.3k
2
votes
1
answer
945
views
MSSQL Spatial Query (View) is Slow in ArcMap
I created the following view in Microsoft SQL Server 2008 R2:
CREATE VIEW test AS
SELECT
p.id,
p.shape
FROM
p INNER JOIN r ON p.shape.STIntersects(r.shape) = 1
WHERE
r.Name = '...
- 333
2
votes
1
answer
718
views
Cannot see created SQL Server tables in ArcGIS
I have a MSSQL 2012 database that I can connect to from ArcGIS using 'Add Database Connection'. In this database I have a spatial table that I can see and open in ArcGIS, however when I create a table ...
- 125
0
votes
0
answers
203
views
ArcGIS Data Interopabality Extension and Exporting from Mapcom M4
I am exporting from Mapcom's M4 database into Geodatabase or Shapefile.
I have the ArcGIS Data Interopability extension and I was able to connect and export the Lines, Points, polys, etc.
When I ...
- 535
1
vote
3
answers
444
views
ST spatial queries to select multi-level location
I'm trying to write a query in SQL Server using 1 set of points and 2 sets of polygons. The polygons overlap, and I only want to select the points that fall inside of 1 polygon but not the other.
I ...
- 11
2
votes
1
answer
1k
views
Delete duplicate spatial point/points in mssql from a perticular location
I am working with a Spatial data which has a street intersection points....
I get the intersection points from spatial query on street/roads datain MMSQL . but in my case some streets/roads are multi ...
- 121