Microsoft SQL Server is a relational database server product by Microsoft. Its primary query languages are T-SQL and ANSI SQL.
3
votes
2answers
365 views
Can I fix 'qodbc3:unable to execute statement' when querying SQL Server 2008?
I was testing features of QGIS and its really cool.I tried to query each table using right click and query but I can't query sql server 2008 database :
Error:
An error occured when executing the ...
6
votes
1answer
63 views
ArcSDE : Cascading Subtypes in ArcGIS 10/SQL Server
I'm currently creating an ArcSDE DB on an SQL Server. It is designed to complete species survey, with information from the field.
In order to help themselves, they asked me to implement a particular ...
2
votes
1answer
38 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
1answer
56 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
142 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 ...
5
votes
0answers
274 views
Geoserver with SQL server consuming all my CPU
This question is long please bear me and my problem.
SQL Server Query profiler
The Sample Query from profiler that geoserver is running that corresponds to SLD I am using and not the SQL SERVER view I ...
3
votes
0answers
126 views
Geoserver WMS-T backend problems
I've been trying to set up a few timed WMS layers in GeoServer. They're simple enough, of the form
ID(PRIMARY KEY) REGION DATE VALUE
so for every region and date you have some value, e.g. the ...
3
votes
0answers
233 views
Ogr2Ogr exported this boundary 90 degrees incorrectly
I've got some GEOGRAPHY data in my Sql Server 2008. I wish to export it as a shapefile (so I can import it into QGIS) and when I do, it's rotated 90 degrees to the left.
Command line
C:\>ogr2ogr ...
2
votes
0answers
245 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 ...
2
votes
0answers
53 views
Critera for geometry or geography
What criteria do you need to take account to before you choose geometry or geography map?
Is there a book or page about it?
2
votes
0answers
211 views
Ogr2ogr: Unable to open datasource problem
I downloaded the Precints shapefile from the City of Boston's data hub, and I'm trying import it into SQLServer (I'm running the Express verson). I've already created the database in the SQLServer ...
2
votes
0answers
167 views
Store elements of Imap into BLOB fields using IPersistStream
I have an IMap (include elements: text, line) and I want to store it into a field of a table in SQL, so I can load it again later. I used below codes, but I got an the error :
public class Test
{
...
2
votes
0answers
333 views
View in ArcSDE 10.1 Problem
I have created a view by joining a feature layer and 2-3 other tables in ArcSDE database using help from
James Richard Post. The view gets created fine in both SQL Server 2008 and also in SDE. In ...
2
votes
0answers
237 views
Is it acceptable to store OSGB36 data as geometry in SQL Server?
I've set myself a project of getting some geo data into SQL Server but before I get started doing any of the big jobs I wanted to see if I was on the right track.
All of my data is for the UK and is ...
2
votes
0answers
114 views
How to compress enterprise geodatabase with stored procedure?
I'm looking for a stored procedure in ArcSDE for SQL Server which performs geodatabase compression to include it in our daily maintenance plan. Is there any such thing in ArcSDE 10.0?
2
votes
0answers
213 views
How to get WKT from SHAPE column in the ArcSDE geodatabase?
I have an ArcSDE geodatabase running on top of SQL Server 2008. A table for a feature layer was added from ArcCatalog. The SHAPE column is a type of int which was automatically converted from ...
2
votes
0answers
334 views
Use MS SQL Server to convert MGRS to Lat Long
Below is the SQL for converting Military Grid Reference System (MGRS) to decimal Latitude and Longitude. It is very accurate, but not perfect. If you can make it work 100%, it is yours, but PLEASE ...
2
votes
0answers
228 views
Can a spatial View in ArcSDE be viewed in ArcCatalog?
Can a spatial view in ArcSDE created by "sdetable create view" command be viewed as feature class in ArcCatalog, or is it just another plain table?
I have a feature class table and an attribute table ...
2
votes
0answers
178 views
Updating SDE point feature classes with SQL SERVER 2008 R2
I am contacting you in hope that you can help me resolve an issue using SQL Server 2008 R2 to push updates to a SDE point feature class.
We are using a C# app that uses ArcGIS Runtime to edit the ...
2
votes
0answers
362 views
OGR VRT MSSQL example
I'm trying to import vector data into SAGA GIS from a SQLExpress 2008 server.
Firstly is this possible?
I would have thought using an OGR VRT layer would have been the way to do it, I've attached a ...
1
vote
0answers
32 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 ...
1
vote
0answers
35 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 ...
1
vote
0answers
46 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 ...
1
vote
0answers
142 views
MSSQL spatial layer import error
I am currently working on a project in which spatial data are stored in a Microsoft SQL Server 2008 database. The tables which hold the spatial table contain 3 rows and are:
RoomId - BIGINT,
...
1
vote
0answers
185 views
How to build a Query Layer in ArcMap 10.1 using columns of two different databases?
As you may know, to create a Query Layer in ArcMap 10.1, it is required to specify a connection to a concrete database and then, define the access to the tables and columns in the SQL Query ...
1
vote
0answers
43 views
SQL server 08 Limitations
The Soil SURvey GeOgraphic (SSURGO) database is a set of very large and complicated shapefiles. We want to load all of the shapefiles for the US into a national SQL database.
Are there import ...
1
vote
0answers
76 views
Need to create custom map based the spatial Database
I need to create a custom map in .net 2008 c# webapplication based the spatial database(sqlserver 2008) without using any third party tools
For example in sqlserver 2008 i am create a map using this ...
1
vote
0answers
34 views
Using SQL replication to replicate Geodatabases
Basically, with a gdb hosted from SQL/SQL Express, are we beholden to ArcGIS's replication process? Can you use SQL's replication instead?
Please let me know if I need to elaborate on this further.
1
vote
0answers
169 views
Cannot join feature layer with SQL Server table with query built in it in ArcMap
I need to join a feature layer with a SQL Server View with a common field in ArcMap. The View was successfully added to ArcMap as data table with some query built on it from Query Builder.
When I ...
1
vote
0answers
84 views
Acceptable Reduce() amounts for google maps zoom levels?
I'm using SQL Server Spatial to return large polygons to Google Maps for display. Given that google maps has a zoom scale of 1 - 20, I would like to reduce my polygons (reduce function uses the ...
1
vote
0answers
87 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 ...
1
vote
0answers
370 views
Converting Lon Lat to UTM Zone 32N in C# with SQLSpatialTools
I have a set of coordinates; Lon 9.42221521, Lat 56.44978001 and I want to convert them to UTM Zone 32N coordinates. I found the SQLSpatialTools library to do the conversion but I need some help. When ...
1
vote
0answers
225 views
Connecting uDig with Sql server 2008
I tried to connect uDig with Sql server 2008 but could not do it the following error poped that it missed imageio ext and jdbc driver for sql server. I added it to jre/ext/lib (both of them). Now the ...
1
vote
0answers
292 views
How to transform Lambert to WGS84 in SQL Server?
Need to create a SQL view of calculated Lat/Lon values from an existing SQL view of County Coords.
Loaded up SQL Server Spatial Tools and registerd CLR types. Lambert generated a resource error.
-- ...
1
vote
0answers
225 views
T-SQL with SDE and Web Map ArcGIS Server 10 MSSQL 2008
I need to build a system whereby the user of a web map (the standard web map that ArcGIS Server Manager builds) can edit a feature class's attributes. The attribute will be a 'Comments' field. The ...
1
vote
0answers
228 views
Is it possible to create an updateable spatial view?
1- I have encountered a problem relating with sde commands for creating sde_ view and also sde_table . I used appropriate codes but an error massage occured during execution.
the related codes:
...
0
votes
0answers
10 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
0answers
37 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 ...
0
votes
0answers
27 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 ...
0
votes
0answers
8 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 ...
0
votes
0answers
18 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
0answers
75 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
0answers
49 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 ...
0
votes
0answers
74 views
SqlGeography STArea for CW and CCW polygons
I'm using a SqlGeographyBuilder to make a simple polygon (with SRID of WGS84). When I add the vertices CW and call the STArea() method, The area would be very large. When I add the vertices CCW and ...
0
votes
0answers
59 views
What kind of unit of measurement for scale does SQL Server 2012 Spatial use?
What kind of unit of measurement for scale does SQL Server 2012 Spatial use?
0
votes
0answers
39 views
Anyone have a sample MS SQL query for Census Block to State Legislative District matching?
I'm new to spatial queries. Does anyone have a sample MSSQL 2008 query that would match a Street/City/Zip with the CA State Senate and Assembly Districts? All I need to do is return the Legislator's ...
0
votes
0answers
43 views
Replace query not changing in pgadmin iii, but other queries working?
Upon adding a database to my postgres pgadmin iii server I attempted a replace query in the sql gui, and it worked. However I put in the wrong value to replace and whenever I try to do so again to fix ...
0
votes
0answers
63 views
Coordinates move in sql server insert
When I insert a row in TableA in sql server I use this for the geometry column:
geometry::STPolyFromText('POLYGON((x1,y1,x2,y2,x3,y3,x4,y4,x1,y1))', 3007)
You can find the definition for ...
0
votes
0answers
197 views
How to display points on map as a graphic using C#?
I have created map using ArcGIS Server in C#. I need to display points as a graphic.
my database consists of points lat lon values,
xval yval txnid attr1 attr2
...
0
votes
0answers
183 views
How to search a PostCode in a Radius using sql server 2008 GeoGraphy
I followed this blog http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/sql-server-2008-proximity-search-with-th and did everything which was guided and I am glad things went fine, my table ...
