Microsoft SQL Server is a relational database server product by Microsoft. Its primary query languages are T-SQL and ANSI SQL.
2
votes
1answer
19 views
Edit SQL Server table (not registered with geodatabase) with arcpy
I am trying to update some rows in a SQL Server database table (not registered with geodatabase) with arcpy.da.UpdateCursor. However, when running the deleteRow(), I get the error return without ...
0
votes
0answers
12 views
post instlacion ArcSde 10 "error creating Arcsde direct Connection (-9)
I installed SQL sever 2008'm doing the post installation used ArcSDE 10
these are the steps I am doing in post installation of ArcSDE 10
complete installation.
SDE Schema.
put the name of my ...
2
votes
1answer
35 views
Options for getting data from SQL Server into Leaflet app?
I have polygon data in SQL Server 2012 that I need to get onto a Leaflet application - we're not talking thousands of polygons, but simplified U.S. counties where only one state will be displayed at a ...
3
votes
0answers
16 views
Why does QGIS 2.0 and SQL Server say Data source name not found and no default driver specified?
I've just started using QGIS 2.0 after using 1.8 for sometime. However I'm having an issue getting a SQL Server connection, I'm using the same settings as as used in 1.8 but I keep gettting an error ...
0
votes
0answers
26 views
SQL Server query, simillar to Symmetrical Difference in ArcMap
i have two tables with geometry data in SQL Server. How can I get all geometry differences with spatial query? I tried:
select k.geom.STSymDifference(r.geom).ToString() from table1 k, table2 r
But ...
3
votes
1answer
46 views
Is there a method in SQL Server (2008 or 2012) that will return the equivalent of the Esri LabelPoint for geometry?
I'm looking for a method that is equivalent to the Esri LabelPoint for SQL Server Geometry (or fairly close). Does it exist by a different name? Or is there an after-market implementation?
I found ...
1
vote
0answers
103 views
ArcGIS 10.1 & SQL Server 2012
We currently updated to SQL Server 2012 and now we are encountering a slower performance when connecting to the geodatabase on SQL Server 2012.
Here are the things that we tried to fix the issue:
- ...
1
vote
0answers
43 views
Importing Census TIGER Shape Files to SQL Server 2012?
I've been doing my research on how to import shape files into Microsoft SQL Server 2012. and am still unable to figure out how to do it after hours of playing around with it. I'll document what I've ...
1
vote
1answer
16 views
Error in GUID fields using “Simple Data Loader”
I have a replicated table in my SQL Server (PE_AMB_ANP), that table has a field named "rowguid" (rowguid is auto generated)
When I try yo load data, the field appear matched with 'none', but when the ...
1
vote
1answer
61 views
Postgis functionalities in Microsoft SQL Server
I'm using Postgresql 8.4, Postgis 1.5 for My GIS works.
Planning to change my Database to Microsoft SQL Server 2012.
Can we use all the Postgis functionalities in Microsoft SQL Server 2012. Please ...
0
votes
0answers
35 views
STIntersects and STContains fails on parameter
I am new to GIS and using GIS in SQLServer, so apologies if this is a rudimentary question, but I cannot find the answer so far. I am trying to use STIntersects() or STContains to determine what ...
0
votes
0answers
18 views
Is there a way to force ArcCatalog to use a specific tessellation scheme for a SQL Server spatial index?
If I Recalculate a spatial index from ArcCatalog, the tessellation scheme is always set to "Geometry Grid". Even when the previous index was Geometry auto grid. ArcCatalog always changes it back.
...
6
votes
1answer
106 views
ArcGIS 10.2 Query Layer on SQL Server performance
I'm using a Query Layer on SQL Server in ArcMap. The Query Layer executes instantly in in SQL Server but but takes so long to draw in ArcMap that the system appears unresponsive for about 10 minutes ...
1
vote
1answer
62 views
How can I use a sub-query in where statement of a query in ArcGIS 10.2 Map service?
I'm migrating my ArcGIS map services from version 10.0 to 10.2. It uses ArcSDE to manage spatial data in a SQL Server database. I was able to create the map service and everything seems OK. However ...
0
votes
2answers
208 views
How to use Sharpmap to display spatial data from MS SQL Server 2008
Can anyone show me a step by step example on how to use Sharpmap to display MS SQL server spatial data using C# as the programming language?
Please note I have exploit some of the example online but ...
6
votes
2answers
65 views
Define projection at the record level
Hopefully this isn't too dumb a question, but is it possible to define projection at the record level, instead of a whole layer or table? I want to create a "project" database for all the work my ...
3
votes
2answers
62 views
Can't open ArcCatalog Database Connection SQL database Tables with field names greater than 31 characters
I am using SQLEXPRESS as a test environment. My issue: I have a database connection in ArcCatalog to a SQL database. Some tables in the SQL database have field names greater than 31 characters and ...
2
votes
1answer
58 views
How to Display Pie Chart when clicking on point feature in map?
I want to display pie charts from MS SQL Server database data.
When I click on a point in the map, I wish to see a pie chart over the point.
Can you please tell me how to implement such pie charts?
...
1
vote
0answers
45 views
QGis 2.01 Fedora 19 vs Windows SQL-Server Access
i just installed QGis 2.01 on Ubuntu / Fedora 19 / windows 8, configured ODBC-support for Fedora 19 and created ODBC-DSNs on the windows machine and the Fedora machine to the same SQL-Server 2012 ...
1
vote
2answers
96 views
Import Zip codes into qgis
I have a list of zip codes (nearly thousands) which I want to show in qgis. After researching I found that I need to geocode them first into Lat/Long then I can use them to create a layer for qgis.
I ...
0
votes
0answers
13 views
Multi-user editing with ArcGIS for Desktop Standard/Advanced with SQL Server Express? [duplicate]
According to this Esri page multi-user editing is available with ArcGIS for Desktop Standard and Advanced.
Does this mean someone could just buy a couple ArcGIS for Desktop Standard licenses and ...
0
votes
0answers
26 views
What is this ArcSDE 10 for SQL server 2008 Enterprise sp2 64bit setup error?
I setup ArcSDE 10 for SQL Server 2008 Enterprise SP2 64 bit but error.
I'm using:
ArcSDE 10 for SQL server 64 bit;
Sql Server 2008 Enterprise SP2 64 bit;
Window Server 2008 Enterprise SP1 64 bit;
...
2
votes
2answers
80 views
Convert polygons to KML file
I have a set of polygons out of which I want to make a KML file, my table schema is as follows :
CREATE TABLE [dbo].[utilitygeo](
[ID] [int] NOT NULL,
[PolygonID] [varchar](8000) NULL,
...
-1
votes
1answer
142 views
SQL to get points within a certain distance
I am new to using spatial data types in sql server. I have managed to create a column of Approx 50,0000 geometry points (from x,y data) and would like to find out which (count number of) points are ...
0
votes
0answers
36 views
Can I create a table showing all the Srid values for all the tables in my DB?
Hi I can identify the current SRID of one table (at a time) in my database, but I was wondering if there was a way to bring back a single table that would tell me all the datasets that do not ...
2
votes
1answer
64 views
How to construct geographies from WKTs
I am using a SQL Server 2012 database. I have noticed that geometries and geographies interpret WKTs differently. For instance, if I construct a square polygon, clockwise:
DECLARE @geom ...
1
vote
1answer
275 views
Implementing geometry_columns table in SQL Server for QGIS
We are using QGIS 1.8 and Sqlserver 2008.Following http://hub.qgis.org/issues/8525 solution we have created table geometry_columns. since we already have lots of table how do I fill this table ...
1
vote
1answer
301 views
Importing shapefiles to SQL Server
I often use the brilliant SQL Server 2008 Spatial Tools to import shapefiles into SQL Server 2008. This works absolutely fine but it leaves me wondering, how do Microsoft expect end users of SQL ...
3
votes
2answers
291 views
How to preserve non-ASCII characters in ogr2ogr import?
I want to import a list of international place names and their locations into a SQL Server database using ogr2ogr.
The source data is a CSV file encoded in UTF-8.
I've prepared a five-record sample ...
1
vote
1answer
56 views
SQL Server STRelate equivalent of Oracles SDO_RELATE(…mask=anyinteract)
In Oracle Spatial, we are running checks on a graph. The Check should provide Nodes, which are marked as endnodes (Attribute "EDGEDEGREE" equals 1) but are in fact located somewhere along an edge. We ...
0
votes
0answers
41 views
using Arcgis silverlight viewer, how to autoload a layer of Lat/Long points stored in MS SQL 2008
I use Arcmap to register a layer into ArcGIS server whose source data is spatial points stored in MS SQL 2008. Everything works fine until a new entry is added into the database table, it doesn't ...
2
votes
0answers
86 views
Spatial Precision for Editing in Multiple GIS Clients
I have something I'd like to discuss, I'll try to explain it first, why it's important, and I'll explain how ArcGIS handles the issue, which I think is a good way to handle it. Finally I'd like to ...
0
votes
1answer
257 views
ArcGIS for Server 10.1 (including ArcSDE) and SQL Server 2012 problem with Create Enterprise-Geodatabase
i have the following server system:
-Windows Server 2008R2
-SQL Server 2008 (SDE10 Enterprise Geodatabaees) and SQL Server 2012 on the the same machine
-ArcSDE Application Server 10
First - Is that ...
5
votes
1answer
100 views
What exactly does the ArcGIS Server service do? SQL Server service?
What is the purpose of the ArcGIS Server service? It's not used at all to do a direct connect to an SDE database, right? That would just use the SQL Server service?
While we are on the ArcGIS Server ...
2
votes
0answers
53 views
What is the MS SQL Spatial syntax for counting points within polygons? [duplicate]
All,
What I'm trying to do is this:
Count points within polygons
There are thousands of points and maybe 2 dozen polygons
Get a list back of the 2 dozen polygons by name and the count of points ...
0
votes
0answers
101 views
Upgraded ESRI .NET ADF application (9.3 to 10.1) intermittently missing service issue
I also asked this question on the ESRI forum but I'm not sure if anyone will see it through the tumbleweeds over there.
I had an application based on the .NET Web ADF originally built in 9.3. The ...
2
votes
1answer
95 views
Entity Framework & Sql Server 2012 spatial
I'm struggling to find any concrete performance of Entity Framework paired with SQL server 2012.
We're looking at storing nearly a million points in a database an right now the most common scenario ...
2
votes
1answer
145 views
How to convert Geometry type column to degree Minutes Second in SQL Server 2008 R2
I have shape column of type geometry and I want to convert X and Y coordinates into Degree Minutes Second format using SQL query and i am using sql server 2008 R2.
Currently I got Lat and long using ...
1
vote
1answer
135 views
SQL 2012 - How can I convert MultiLineString to Geography?
I have a Geometry LineString that I wish to convert to Geography.
Since the Geometry isn't valid , When I use MakeValid on it, SQL convert it to MultiLineString and than the Geography creation is ...
1
vote
0answers
96 views
How to connect to MSSQL-Server using Geoserver?
I have Geoserver on Ubuntu 13.04. On another machine I have MS SQL-Server 2008 R2. Now I want to connect it together. Google says that its possible to connect to SQL-Server from Ubuntu using ODBC ...
0
votes
0answers
47 views
New/Imported Raster dataset given dbo schema in SDE geodatabase
I have an Esri ArcSDE geodatabase (10.1) on SQL Server with a custom database scheme called "GC" which is used to host all the project datasets.
In ArcCatalog, a SDE connection file was created with ...
1
vote
1answer
234 views
Why does ogr2ogr SHP import error out trying to create a database?
All,
Can anyone tell me what the error is with OGR2OGR when trying to import a .SHP into MSSQLSPATIAL?
ERROR 1: MSSQL Spatial driver doesn't currently support database creation.
Please create ...
2
votes
1answer
126 views
Detecting invalid WKT in text column in SQL Server
I've got a whole load of WKT data in a SQL Server table, of which I'm trying to detect the validity.
I'm currently doing a query like this:
UPDATE f SET
f."CurrentGeomValid" = ...
0
votes
0answers
56 views
Why does importing data through MSSQL provider throw this error?
(Sorry for the awful title, but I will refine if we can figure this out...)
I've imported data through drag 'n drop without using the geometry_columns name specifically - the default name when ...
1
vote
0answers
277 views
Why can't QGIS connect to MS SQL Server?
All,
Up until yesterday, QGIS connected to my SQL Server 2012 database no problem.
However, yesterday I installed SQL Server Management Studio (SSMS), and the SQL Server Client tools, and now I get ...
1
vote
0answers
83 views
SQL Server geography.Intersects Yields Unexpected Results (arch shape)
I've coupled ESRI's ArcGIS with SQL Server 2008 R2 in an attempt to allow users to search for geographical points using a polygon (with ArcGIS' drawing toolbar). I've run up against an issue that's ...
2
votes
0answers
124 views
Publish ESRI Feature Services from spatial view on ArcGIS Server 10.1
I have a feature class layer and a handful of non spatial plain tables in a 10.1 SDE geodatabase on MS SQL Server. What I want to achieve is to publish a feature service from ArcGIS Server so as for ...
1
vote
1answer
82 views
GeoServer using GeoWebcache and SQL Server whats the process?
I'm using GeoWebCache and GeoServer to tile cache a layer of data from a SQL Server database. If I seed the cache and I send a tiled WMS request what occurs?
Does GeoServer make a call to SQL Server ...
1
vote
2answers
402 views
How do you create and use a SQL Server spatial view in ArcMap?
All,
(using SQL Server 2012, ArcMap 10.1)
I have created a SQL spatial statement to test out how a) the union function works, and b) how creating a view of this data will work with ArcGIS.
a) the ...
1
vote
2answers
175 views
Why do I get wrong length using STLength on MultiLineString?
I have 2 MultiLineString representing the a route (first is driving there and the second is the return way) .
MULTILINESTRING ((34.787315938035292 31.318235314177119, 34.788431415005249 ...
