Microsoft SQL Server is a relational database server product by Microsoft. Its primary query languages are T-SQL and ANSI SQL.
1
vote
0answers
27 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 ...
-1
votes
0answers
21 views
Using regular expressions to split a string into multiple outputs [on hold]
Hopefully this is the right place to ask this question, apologies if it's not.
I have a string field containing 'multiple' values that I'd like to extract directly at the database (SQL Server 2008) ...
2
votes
0answers
15 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
19 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
61 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
58 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 ...
2
votes
1answer
82 views
SQL Server 2008 Distance and Performance Problem
I had been working on PostGIS to do some geographic processes and due to some reasons, I had to start to use SQL Server 2008.
I ported same code for SQL Server but performance is almost dying when I ...
3
votes
3answers
39 views
ArcSDE command registration issues
I have an ArcSDE 10.0 enabled SQL Server 2008 R2 database on a development server. We are using TeamCity to run continual deployment to this development server, which runs through the following steps:
...
7
votes
2answers
119 views
How to use the ESRI JS API to map SQL Server Spatial Types without ArcGIS Server
I have heard of people using the ESRI Javascript API to create webmaps with spatial data from SQL Server or other RDBMS's. From what I can tell, they are not using ArcGIS Server as a middleware. In ...
0
votes
1answer
71 views
How can i generate parcel extracts on demand through a webservice
Ok, i need to generate parcel extract documents on demand. The backend is Arcgis 9.3.1 on SQL server 2008. I would like to build a webservice (C# .Net) on the server that generates these extracts. My ...
0
votes
1answer
50 views
Do any of the SQL Server 2008 R2 SP 2 cumulative updates contain the MAXDOP spatial index fix?
I am troubleshooting ArcGIS 10.1 performance issues with SQL Server 2008 R2 SP 2 (10.50.4000) and the issue appears to be this MAXDOP issue:
...
0
votes
1answer
90 views
Import shp geography data to SQL Server from C#
I have a set of shape files that I am attempting to read in C#.
My question is not the tabular .dbf data but the geography data (i.e. polygons and lines). How would I insert this data into a ...
0
votes
1answer
37 views
geoserver problem to join sql-server table to a layer
i have a layer published on geoserver based on a connection to a postgres/postgis Table and i need to add another table existing on sql server to do a data jointure table to table in order to add ...
3
votes
1answer
66 views
Installing ArcGIS 10.1 on SQL Server 2008 R2 Cluster
We're running into some performance issues when accessing large enterprise geodatabases on a SQL Server 2008 R2 cluster. The database itself performs well and returns queries fine but presenting the ...
0
votes
0answers
54 views
Remove last 5 characters from Feature classes names
I need to remove the last 5 characters from all feature classes in a mssql database by removing the last 5 letters. I have MYSQLServer 2008 R, ArcGIS Server 10.0 Enterprise Standard, Arcsde 9.3 with ...
0
votes
1answer
28 views
layer from sqlserver database table
I'm new in ArcGIS. Is it possible to create a layer from a SqlServer table instead of a shapefile? in other words, is it possible to store layer data in a table in Sql Sever instead of a shapfile? ...
1
vote
0answers
37 views
Problem viewing SQL 2008 “Date” field
I am using ArcMap Basic 10.1 SP1 and I'm connected to a permitting database stored in a SQL Server 2008 R2 database.
I am trying to pull the tabular data over into my ArcGIS Desktop Project so that I ...
1
vote
0answers
24 views
Polygon not a valid geography instance
I am trying to create and insert data from ESRI shape files. This is one of the many features in the shape file, you can copy paste it and try it yourself:
DECLARE @g geography;
SET @g = ...
0
votes
0answers
13 views
gxp.plugins.FeatureEditor
I had configured with sqlserver 2008 and geoserver 2.3.1.the connection is ok with spatial data.
Question: i had used gxp.plugins.FeatureEditor. "Edit exiting feature" work but "Create new feature " ...
0
votes
1answer
53 views
Problem in filling table of ArcSDE feature class in SQL Server 2008?
I have an ArcSDE point feature class and I add it to ArcMap 10.
After that I add some points to it and fill every field for all points in the attribute table and Save Editing.
However, the SQL ...
0
votes
2answers
63 views
Need help in ArcGIS Desktop: Automate the task
I am using ArcGIS 10.1 desktop on Windows 7 and I want to run few task automatically.
Scenario: I have plane table from sql server contains lat,lon information. I have added that table in Arc Map ...
1
vote
0answers
75 views
ArcGIS 10.1 SDE database schema other than SDE or DBO
Just wondering if it's possible to apply a schema other than SDE or DBO to SDE feature or raster tables stored in an enterprise database on MS SQL Server 2008 R2.
I have got a new customise schema ...
3
votes
0answers
49 views
Geoserver WMST Date Format
There is table in SLQ-Server 2008 R2.
In this table i have date column with date format like this 2006-09-08 14:39:41.000. Now i make View from this table on Geoserver side but do nothing wiht date ...
0
votes
0answers
34 views
Why does my feature service allow add and delete but can't update attributes
I have published a FeatureService in ArcGIS 10.1. I connect to the service with this JSAPI sample: Using the Attribute Inspector. With this sample I can add features and I can move or delete ...
1
vote
0answers
72 views
Insert XY table data into SQL Spatial column
ArcGIS Server 10.1.1 SQL Server Standard 2012
Current workflow is user submits a table (text file) containing lat-long data (same spatial reference each time); SQL Server Integration services pushes ...
0
votes
2answers
93 views
How to learn ArcGIS Server? [closed]
I have SQL Server, ArcGIS Server Standard Enterprise 10.0 - and I am new to both.
How can I learn to use it. I want to learn ArcSDE but i am unable to understand it.
Is ArcSDE available with ArcGIS ...
2
votes
1answer
60 views
ArcExplorer - possible connect to a non-SDE database?
In ArcExplorer, I'm wondering if you can connect to a non-SDE database, like SQL Server, with geometry or geography columns?
1
vote
2answers
134 views
Plotting large numbers of objects on a chart using R and WKT format
I am retrieving thousands of geometry lines in WKT format from a Microsoft SQL Server database. I would like to plot all of those lines in one map, but I am having some difficulty with the code. How ...
2
votes
1answer
146 views
Reading OGC geometry data from SQL server using R
I would like to write a script in R that creates a map using OGC geometry data that is stored on a Microsoft SQL server. Is there a way to read OGC geometry data using a query passed from R?
Maybe ...
3
votes
1answer
125 views
Create polygons in ArcMap 10.0 from lat/long data pulled from SQL Server 2008 database
Forgive me if this is very basic, as I'm new to GIS work (though I've been a programmer for 10 years) and so I'm not really sure how to approach this, but here goes...
Can I take a table with ...
0
votes
1answer
313 views
How to import ArcGIS 10.1 File geodatabse to MS SQL Server 2012
Hello I´d like to import my File Geodatabase from ArcGIS 10.1 into MS SQL Server 2012.
I´ve never do it before, so I expect to do the import same way as import data from excel table.
Problem is ...
1
vote
1answer
58 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
2answers
244 views
ArcGIS Server Error: “Feature service requires a registered database”
I'm attempting to publish a feature service to ArcGIS server. I'm running SQL Server Express and ArcSDE. When I try to publish the service I get the error "00090: Feature service requires a registered ...
9
votes
2answers
255 views
How do I perform a 3 parameter geotransformation and projection in Sql Server 2012?
I have a table with latitude longitude (NAD27) columns in it. I compute two other columns, X and Y, representing Web Mercator (WGS84) location.
Currently I'm using a Arcmap to do this, by applying ...
0
votes
0answers
10 views
Does SqlGeography line preserve order?
I am using the SqlGeography type in C# to store and retrieve a line from an SQL database. The direction of the line, and therefore the order of the points is important. My question is if the ...
1
vote
1answer
79 views
PROBLEM SQL SERVER UNION of geography feature : FULLGLOBE result
I have some trouble with sql server 2012.
I store coordinates of french cities in my database as geography object (with ESRI 4326) and i want to make the UNION of some cities.
I have in result ...
0
votes
1answer
32 views
Unsupported WFS request in MapServer at Insert and Update
I'm created a WFS with MapServer (ms4w) and SQL Server DB. The wfs:GetFeature works fine. But I cann't get the wfs:insert/wfs:update to work, they return:
<?xml version="1.0" ...
2
votes
0answers
476 views
Which one is better ?SQL server 2012 or Oracle 11g
I want to learn a database server, SQL server 2012 or Oracle 11g . I surf in the internet to compare SQL server and Oracle for spatial data and found good websites such as gisboston.it was very ...
3
votes
1answer
123 views
add new SRID to sql server
Is it possible to add a new SRID to sql server 2012?
I've tried
insert into sys.spatial_reference_systems values (4938, 'GEOCCS["GDA94",DATUM["Geocentric Datum of Australia 1994",SPHEROID["GRS ...
0
votes
0answers
21 views
How to get sublinestring limited by two points?
Hi i have MS SQL_server R2 2008.
I have a linestring and two points on this line.
i want to get part o linestring limited by this points.
Its possible?
0
votes
1answer
89 views
how to make a join with sql server table
I have a question.
I'd like to join .shp to table by using AddJoin_management. But I'd like to make join to sqlserver table (not to *.dbf). Is it possible to do?
it should look something like this:
...
1
vote
2answers
51 views
Seek assistance with: SQL Server 2008 Query that takes values from a column in another table (or from a flat file)
I am given a list in MS Excel of 554 statistical units (called Primary Sampling Units or PSUs) from another department and have to query all 554 PSUs from a SQL Server 2008 Spatial database table ...
0
votes
0answers
92 views
SDE connection error
In my company we have a number of databases in an MS SQL instance. This morning only 1 database i generating following error when I try to do a direct-connect in ArcCatalog:
Failed to connect to ...
0
votes
1answer
60 views
Is it possible to create an “Empty” version of an SDE database?
Is it possible to create an "Empty" version of an SDE database? I have a large default SDE database that I would like to create an empty version for a new project. By "Empty" version I am referring ...
0
votes
0answers
63 views
Insertion Operation While Trying to Connect gvSIG with SQL SERVER
I am trying to create the insertion method in SQL SERVER using gvSIG and Eclipse, but am getting this error, here's the log ( I think the getinsertFeature gets an empty charsetname):
Exception in ...
2
votes
2answers
433 views
ArcGIS Server 10.1 and SQL Server 2012 SP1
We have just built and new ArcGIS/ArcSDE system with SQL Server 2012 SP1. We are experiencing very long periods (up to 2 minutes) just to connect to the database in Desktop. Desktop does connect and ...
0
votes
1answer
187 views
Filtering a Feature Class in using ArcGISDynamicMapServiceLayer
I'm using the following code in Flex to display all the features in a Feature Class defined in the "Data Layer".
var dataLayer:ArcGISDynamicMapServiceLayer= map.getLayer("Data Layers") as ...
0
votes
0answers
58 views
Retrieving ArcGIS:s Spatial Data into a Database
Background:
If you have created a vector map with lots of spatial data in geometry flat in with measurement kilometer. The following object that is used in the map will be point, line and polygon ...
2
votes
1answer
100 views
Connecting gvSIG with SQLSERVER
I am working for the first time with gvSIG and SQL SERVER, I want to connect gvsig with spatial database SQL SERVER.
I don't know how to, Is it by using a protocol and which one ? plz help me
1
vote
1answer
108 views
tools and ETLs for migrating data benchmarking - from shapefile to SQL SERVER
i need to migrate my shapefiles to my database SQL SERVER, and i don't know what's the best tool or ETLs to choose, i already tried FME Desktop and i succeded to load the shapefiles on my db, but ...
