Tag Info

Hot answers tagged

2

I have used WFS-T through GeoServer to edit data on a MS SQL server before. It was through a Leaflet.js plugin, not through QGIS, but my experience should at least confirm that it works. I remember that there were some field types that GeoServer couldn't edit though, including UUID fields and possibly some types of Geometry (maybe it was Geography or ...


2

As an alternative to pymssql, you might consider using the arcpy.ArcSDESQLExecute class to execute your SQL statements. Something along the lines of (simplest form and untested): import arcpy sde = r"Database Connections\Connection-to-SDE.sde" sde_conn = arcpy.ArcSDESQLExecute(sde) sql = """CREATE TABLE tempIntersect_withNATA (ZIP varchar(max), ...


1

For apps I've been involved with, we use secured Feature Services (with the accounts used to secure the services coming from Active Directory - these are different than the accounts used to secure the ArcSDE layers in the geodatabase), in conjunction with a Proxy application, to control access to editable layers. An alternative to the Proxy application is to ...


1

This problem was caused by not correctly uploading shapefiles into a MS SQL database with the SharpGIS Shape2SQL tool. The Shape2SQL tool sets a constraint on the STSrid property of the geometry field (geom.STSrid) when it creates a database table. If you look at a table created by Shape2SQL in Microsoft SQL Server Manager, you will see a constraint called ...



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