Tag Info

Hot answers tagged

2

We use SQL Spatial native data for 90% of our spatial analysis. Our catch is we have to edit the data in a Geodatabase then use FME Workbench (through our Data Interoperability Extension that comes with our ESRI enterprise license agreement) to move the data into SQL Server as native spatial data. [EDIT] The ability to edit spatial data within ArcMap gives ...


2

Here is a T-SQL way to dynamically add a set of users to a database and grant them permissions NOTE I have no way of testing this at the moment, so there may be syntax errors and test it in an environment where it can't cause harm. USE TestDatabase; --Make sure you have the right database DECLARE @sql VARCHAR(MAX) = ''; SELECT @sql = @sql + 'CREATE USER ...


2

In SQL Server 2008 there is no reprojection from one coordinate system to another, which is probably what you were expecting to happen automatically, when you put 27700 inside the STGeomFromText function. EPSG:27700 is the British National Grid, which is a projected coordinate system, ie, it is in meters and on a Cartesian plane. The geography datatype, ...


2

If your data is stored in your SQL Server database as native spatial data, you can certainly do this. Assuming your territories (T) and sub-territories (ST) have attributes for their name and/or type, my suggestion would be along the lines of: Create a view (a dynamic table in your database) that joins your two polygons together using a join, where the ...


2

Further to Russell's Answer It's unfortunate that you have you locations stored in the wrong data type. The easiest way to get an accurate distance between your is to cast the geometries as geographies. You will need to confirm the the Lat is stored in the Y and the Long is stored in the X of the geometry, otherwise you will most likely end up with ...


2

It's kludgy, but you could query point geometries into geography SELECT Geography::STPointFromText('POINT(' + CAST(geomcol.STX AS Varchar(20)) + ' ' + CAST(geomcol.STY AS Varchar(20)) + ')', 4326).STDistance(...)


1

This function requires SQL Server Syntax for the mm/dd/yyyy format. PlannedDate = CONVERT(DATE, GETDATE())


1

It appears that you are asking if it is possible to use ArcGIS middleware to edit a SQL database without purchasing ArcGIS server. With your existing set of tools, it is possible if you are fairly experienced with SQL Server. The cleanest way to go about this is to manage it almost all through SQL. You will want your own homegrown versioning because you ...



Only top voted, non community-wiki answers of a minimum length are eligible