Microsoft SQL Server is a relational database server product by Microsoft. Its primary query languages are T-SQL and ANSI SQL.
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 ...
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
0answers
26 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
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
138 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
1answer
33 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 ...
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
227 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
2answers
46 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 ...
3
votes
2answers
363 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 ...
2
votes
1answer
447 views
How to insert DateTime null using IRowBuffer
I am using IRowBuffer/IFeatureBuffer to insert fields to SQL Server 2008 DB.
When inserting a field I am using:
public void SetValue(IRowBuffer buffer, string field, object value)
{
int ...
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 ...
3
votes
3answers
140 views
What Application for Vector and Cartesian Coordinate System
Goal:
Visualize a picture in SQL server 2012 spatial data based on geometry
Problem:
In order to display a vector picture I need to retrieve X, Y coordinate (cartesian coordinate system) and ...
1
vote
0answers
33 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 ...
2
votes
1answer
37 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?
0
votes
2answers
81 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 ...
1
vote
2answers
102 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
114 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 ...
9
votes
2answers
243 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 ...
3
votes
2answers
179 views
Visualize Spatial Data in Reporting Service
Is it possible to visualize a piece of geographical map from SQL server Spatial data (geometry, not geography) in a report from reporting service? If yes, how should it be done in a course of action.
...
0
votes
1answer
20 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" ...
1
vote
2answers
40 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 ...
3
votes
1answer
97 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
165 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
48 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
124 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 ...
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 ...
4
votes
1answer
69 views
How can I overwrite a geodatabase in AcrGIS server 10 with SQL Server SDE, using xml workspace?
I want to transfer a geodatabase from my development server to my client's production server. We are using SQL Server, but in different versions. Hence I cannot use Backup/restore or detach/attach. ...
2
votes
0answers
234 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
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 ...
4
votes
1answer
197 views
What licenses are needed for ArcGIS Server and SDE (vs a FOSS setup)?
Does anyone know where I could find a cost breakdown for an ESRI/Microsoft GIS server and database setup?
I'm trying to figure out all the costs associated with an ArcGIS Server/SDE sitting on top of ...
2
votes
1answer
72 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
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?
5
votes
1answer
595 views
ArcSDE 10 on SQL Server 2008 R2 Cluster 64bit or 32bit
I am looking for Tips an Tricks on installing ArcSDE on SQL Server 2008 R2 Cluster. Our IT division would like to have all the databases on their new 2008 cluster.
I've only done standard install ...
0
votes
1answer
63 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:
...
12
votes
5answers
3k views
Use arcgis with SQL Server 2008 as a backend
I'm wondering how best to use arcgis] and sql 2008 together. At the moment we run manual imports and exports between sql 2008 and arcgis 10 shape files. With sql 2008 having a geography data type I ...
13
votes
15answers
1k views
What GIS editors work with GIS data that is stored in SQL-Server
If I store my vector GIS data in SQL-Server, what editors can I use to edit the GIS data?
0
votes
0answers
73 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 ...
2
votes
2answers
344 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 ...
2
votes
1answer
195 views
STIntersects - Update field to give me count of points in polygon
I have a points layer (dbo.ptLayer)
Around 1M points
Spatial Geometry Type (dbo.ptLayer.geom)
No spatial index just yet, but will create one once data gathering complete.
I have a polygon layer ...
0
votes
1answer
54 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
46 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 ...
3
votes
2answers
125 views
Several questions about using spatial data?
If you have spatial data for SQL server, can you use the spatial data (both geometry and geography) in another application for instance ESRI ArcGIS?
Is spatial data a standard that every GIS ...
3
votes
2answers
156 views
migrate PostGIS spatial data to MsSql spatial data
am trying to migrate PostGIS geometry to SQL server Spatial data. which ETL i have to use. it's the first time i'll work with SQL server Spatial.
is there any Data ETL model that do this migration. ...
1
vote
1answer
80 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 ...
2
votes
3answers
917 views
SQL Server Geometry to geography conversion
I have imported a number of Shape files from the ordnance survey using shape2SQL
these have been imported as geometry however i would like to convert them to Geography and specifically to srid 4326
...
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 ...
2
votes
1answer
87 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
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
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 ...
