Microsoft SQL Server is a relational database server product by Microsoft. Its primary query languages are T-SQL and ANSI SQL.
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
1answer
110 views
How can I relate between street and city in OSM imported data into SQL?
I've used OSM2MSSQL to fill db with 2 cities streets. Now I have the following tables in my DB :
tNode
tNodeTag
tRelation
tRelationMember
tRelationTag
tTagText
tWay
tWayCreation
tWayTag
How ...
1
vote
2answers
113 views
SQL Server STpointfromText comes from PHP into javascript as garbage
Sorry for the sloppy title.
Here's the scenario - I have a table in SQL Server 2008 R2
It has a geographyColumn, created thusly:
add geographyColumn as ...
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,
...
2
votes
2answers
166 views
Can we use procedures in a Query layer (ArcGIS Desktop 10.1 & Server 10.1)?
I have one basic question that.. Can we use procedures in Query layer (ArcGIS Desktop 10.1)??
Currently I am using query layer for ArcGIS Desktop 10.1 and its working fine . My DBA person told me ...
1
vote
0answers
186 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 ...
6
votes
3answers
247 views
Insert points into SQL Server?
I am collecting X and Y values from a web service (Twitter) via a python script. In the long run, this will run over a period of months and I intend on stopping at around the 6 million point mark.
...
3
votes
0answers
128 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 ...
2
votes
1answer
150 views
How to force sql server to use the spatial index?
I'm beginner with SQL Server (2012). I created a spatial index, and I'm trying to force SQL Server to use that index to solve the query.
Here's what I have:
DECLARE @g geography
SET @g = ...
5
votes
1answer
155 views
Can you synchronize tables between ArcSDE(MSSQL) and PostgreSQL(PostGIS) regularly?
I have spatial tables in ArcSDE 10.1 (MSSQL 2008 R2) geodatabases and need to update the same spatial tables in PostgreSQL 9.1(PostGIS 2.0.1) geodatabases. Basically I use my ArcSDE environment for ...
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
1answer
127 views
Live update (the database & Map) possible in ArcGIS Server 10.1?
I am using sql server data base contains lat/lon values and using this information I have created the shape files and published on server..
When I get the update say 100 records then I need to ...
2
votes
0answers
212 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 ...
3
votes
2answers
174 views
Is it possible to load features into ArcSDE without using ArcObjects?
I have a SDE geodatabase in MS SQL Server, where geometries are stored in MS SQL's native geometry types, rather than the ArcSDE Binary.
It seems like it would be relatively easy to create new ...
7
votes
0answers
64 views
How can I automatically split a spatial layer to a grid [duplicate]
Possible Duplicate:
Divide vector in equal smaller parts in QGIS or similar
I am a software engineer and the company I work for has a project that needs some spatial data manipulation in ...
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
{
...
0
votes
1answer
422 views
Shapefile to MSSQL with ogr2ogr fails to make connection
I am using ogr2ogr from OSGeo4W on my Windows 7 box to import a shapefile into a SQL Server database on one of my servers. I was able to successfully complete the conversion using shp2sqlserver, but I ...
2
votes
1answer
113 views
How to create a network with all the track points
I have created a sample network through the use of gps visualizer. Than I used the ogr2ogr function to import this data in my database.
Now I have a table which holds all the track points of these ...
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
1answer
294 views
Ogr2Ogr doesn't work with QGIS 1.8
I'm trying to use Ogr2Ogr.exe to import some shapefiles. It came installed with QGIS 1.8. When I try and run it, i get the following error:
C:\Program Files (x86)\Quantum GIS Lisboa\bin>ogr2ogr ...
1
vote
1answer
428 views
How to save a vector layer from QGIS to Sql Server 2008 or 2012?
using QGIS, i've loaded up some administrative boundary data of New Zealand. I wish to now import this vector data from QGIS into my Sql Server 2012.
Is there any way to do this with QGIS ...
0
votes
0answers
198 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
1answer
82 views
What is the best way to sum the area from a number of polygons in .NET/SQL Server?
I have an Mapbasic/.NET application that read data from SQL Server 2008 R2. I have a table with polygons and need to sum up the area of a subset of the polygons. This should work dynamic so the user ...
1
vote
3answers
190 views
How to save a QGIS workspace with database link for offline use?
Is it possible to save current workspace of QGIS for offline usage like in mapinfo? My workspace has link to database. and when I reopen workspace unlink in mapinfo it can't open it.
3
votes
2answers
367 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
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 ...
0
votes
0answers
185 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 ...
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 ...
3
votes
1answer
123 views
Has anyone been successful using the CAST function in ArcMap 10 with ArcSDE 10
I would like to use the CAST function in the definition query property of a layer and/or in the label class sql query window.
This was the most promising link that I've found, including the two links ...
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
2answers
246 views
Distances and areas in Google projection
I have a mapping website used to capture polygons using OpenLayers in Google projection (900913) and storing them in sql server 2008 as geometry. The SRID on the sql geometry column is set to 900913. ...
2
votes
1answer
280 views
SQL Server 2008 Spatial Index Nearest Neighbour
I am trying to query geopoints for nearest neighbour, Whether I use spatial index or not, I always get similar times and it takes about 6 seconds. How can I speed this query up?
Here is my query:
...
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
3answers
923 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
...
0
votes
1answer
101 views
QGIS crashing if a record has no geolocation [closed]
I have several tables in my scqlserver database that have records that may or may not have geolocation information (eg defined polygon or point feature). If I have such a layer in my qgis project ...
1
vote
2answers
569 views
Convert spatial Geographic data from sql server 2008 to Json
Is there any example to convert spatial data (point,line,polygon) stored as geographic in sql server 2008 into Json and display data using Arcgis Javascript Api 3.0.I have tried converting geographic ...
5
votes
1answer
302 views
STGeomFromText not working on large polygons
I'm using Microsoft.SqlServer.Types to do intersections on polygons.
SqlChars scFullSwath = new SqlChars(new SqlString(fullSwath));
SqlGeography fullSwathGeom = ...
3
votes
2answers
598 views
How can i select a polygon in MS SQL 2008
I am very new to MS SQL 2008. I got a task to select a polygon from the polygon layer by giving the X-Y coordinates. I already got the script for PostgreSQL for the same thing, but i need it for MS ...
2
votes
1answer
3k views
How to import shape file into SQL Server 2008 R2 using only SQL scripts?
I am trying to import some shape files into SQL Server 2008 R2. I found this useful tool called Shape2SQL however I am not sure how I can import shape file directly using only SQL scripts as this is ...
4
votes
2answers
410 views
Why does ST_Area(g.geom) + ST_Area(p.geom) - ST_Area(ST_Union(g.geom,p.geom)) produce negative result when using ST_Overlaps(g.geom, p.geom) = true?
I have two set of shape data. Let's say file gov.shp contains list of post codes and their boundaries. File post.shp contains list of government area name and their boundaries. I want to find out the ...
1
vote
1answer
217 views
Determine if GPS coordinate in Canada
I have GPS tracking solution and most my customers in US. My reverse-geocoding solution pretty basic:
Table with US ZIP database
Procedure in SQL Server where I search for city/state closest to ...
5
votes
1answer
173 views
BigInt data type in SQL Server mapped as Text in ArcMap
I have a table in a SQL Server 2008 database containing a BIGINT data column. When I tried to import it into ArcMap 10, it automatically converted as Text of 8 length. This caused the records that ...
2
votes
1answer
1k views
Insert Geography data into SQL Server 2008
Can someone guide me to or give me an example on how would one go about insert/query Geography data in Sql Server 2008 ( Polygon with 4 points and Point in specific) using C# EF or Linq2Sql.
I've ...
1
vote
2answers
1k views
ArCGIS Server 10/10.1 And Sql Server 2008
Is there any compulsion that SQL server 2008 and ArcGIS server 10/10.1 should be installed on same server machine and is it possible to install SQL server 2008 and ArcGis server on separate server ...
0
votes
0answers
26 views
Relates in two schemas SQL [closed]
I have 02 schemes in the same instance of SQL server 2008. SDE-DBO
I can make relation ship class between them. not work for me
2
votes
2answers
418 views
ArcGIS Server simple link with SQL Server database
I am using ArcGIS Server 10 to create Rich Internet Application with embeded Maps.
Basicaly, I created an Optimized Map Service on ArcGIS Server, from an MXD file (produced with Arc Map). I have ...
0
votes
0answers
22 views
Reproject geographic data SQL Server [duplicate]
Possible Duplicate:
Is it possible to reproject spatial data using SQL Server?
It is possible to repreoject a table (geography type) which has the 4326 SRID into a new SRID?
2
votes
1answer
813 views
Feature Class To Geodatabase => ERROR 000210: Cannot create output
error messages:
Executing: FeatureClassToGeodatabase E:\jags20120321.mdb\ch_cs "Database Connections\Connection to localhost.sde" "Database Connections\Connection to localhost.sde"
Start Time: Sat ...
