Hot answers tagged

1

SQL Server Spatial Tools is a CLR assembly that you can add to your database to assist with a number of operations that didn't come built in with the original release of SQL Server spatial objects. It has a set of functions to do similar operations as those found in Oracles SDO_CS. There is a projection example in the source code section, though it doesn't ...


1

GeoServer (by default) doesn't make primary keys available to the renderer as they are usually just a simple integer or UUID so are of no real use for rendering. There are two solutions to your issue add a serial column to your table for use as the primary key. ask GeoServer to expose primary keys for you.


1

To find the points distance (buffer) of another point there are two methods that could work: (note my data is stored in Colorado State Plane (feet) EPSG:2877 so I can use 5280 as the buffer distance) Use STIntersects: select points2.* from points1 as p1 , points2 as p2 where p2.shape.STIntersects(p1.shape.STBuffer(5280)) = 1 or STWithin: select ...


1

It's working: Go to "Database Connections" in the catalog window or ArcCatalog. Double click "Add Database Connection" a dialog box will open and authenticate as Database Administrator "sa" or using your windows authentication is the user part of sysadmin. Click OK, another dialog box will pop up asking you to provide a path to license file give it ...


1

I've done it long-hand. Using mod on the eastings and northings Select Easting - [Easting] % 1000 As Easting, Northing - [Northing] % 1000 As Northing, Count(*) As CountOf Into rpt_Counts From SP_Records Group By Easting - [Easting] % 1000, Northing - [Northing] % 1000 This gets me the basic result I want I then do a bit more manipulation which I ...


1

You may be getting this crash from one of the 3 reasons below: 1: SRID not set on Geometry Column. To check the SRID, I use the following SQL code SELECT *, GeometryColumn.STSrid FROM [DataBaseName].[dbo].[TableName] 2: Invalid Geometries in the Tables. To check the Invalid shapes, I use the following SQL SELECT * FROM [DataBaseName].[dbo].[TableName]...


1

I struggled with this too! I managed to solve the problem ogr2ogr -f MSSQLSpatial "MSSQL:server=Servername\SQL2012;database=DatabaseName;UID= username;PWD=password" C:\Pathto\shape.shp All you need to do is get rid of the [] and it should work...Hope this is still applicable to you.Just to show you I had the same issue here is a screensht of multiple ...



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