Tag Info

New answers tagged

0

inserted Table is a temporary rowset which may contains more than 1 row and this DML query simply assign one value to all records which are in it.maybe this lines help to make up this problem. Declare @RowCount as int Select @RowCount=Count(*) From [dbo].[AddressPointTest] Select ObJECTID,ROW_NUMBER() over(Order by OBJECTID) AS aID into #T1 From inserted ...


1

I implement STShidt function myself and use SQL Server CLR Integration to deploy it to SQL server. STShift implementation is: [SqlFunction] public static SqlGeometry STShift(SqlGeometry g, double xShift, double yShift) { var sqlGeometryBuilder = new SqlGeometryBuilder(); var shiftGeometrySink = new ShiftGeometrySink(xShift, yShift, ...


1

This documentation gives a pretty good description of what each node is for, and it confirms what you mentioned. The Database Server node is for creating the geodatabase and administrative tasks (for SQL Server Express), and the Database Connection node is for creating/editing/viewing data. A quick tour of setting up and using database servers Anyone ...


1

My experience has been that the Database Server node is explicitly for use of connecting to spatially enabled "Express" editions of RDBMS where as the Database Connection Node is used to conect to Enterprise RDBMS like SQL or Oracle (spatially enabled or not). What are Database Servers Quick Tour of Administering SDE gdbs


0

Loading and displaying GeoJSON with Leaflet has been pretty well detailed here: http://leafletjs.com/examples/geojson.html


0

Interestingly enough, when we created a new enterprise geodatabase in arccatalog and mapped each active directory user to this database in sql server, myuser was able to add a connection to both the new database and the original database in arccatalog. This has solved the problem, however the root of the initial problem still remains a mystery !


1

Thank you for your help! (Nathan helped me on the QGIS issue tracking page with the same advice he posted here and that mapBaker also posted). I added a unique int column to this table and then it loaded the layer with no problem. Thanks again.


1

If you only want to visualize the density, I recommend using the new Heatmap renderer as shown in the following screenshot:


1

This is because Geography is designed to handle coordinates in degrees (lat/long) and "knows" how to convert these into metres for your STDistance method. Geometry, however, assumes you are on a flat plane and therefore treats your map units as simple distances - so you are asking for all points within 5000 degrees of the centre and since that exceeds the ...



Top 50 recent answers are included