Tag Info

New answers tagged

0

It is possible but not easy. you should write custom ArcObject code to disable any tool or command that exports feature data. And off course you should manage users with a custom user manager application to set their permissions (enable/disable feature export)


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 ...


0

I would try the following steps. In ArcCatalog, copy and paste the table in to the new ArcSDE db. Add the table to ArcMap, Open it, on the table window, Options Table export. Try using Model Builder to do it for you. Export your model to Python and try it. Then try all the steps again on a BIG server. Try running a Python script that just grabs the first ...


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 ...


0

For 10.1 details requirements can be found at here As esri staff kpeter says about comparison between ArcSDE for SQL Server Express and ArcSDE geodatabases licensed with ArcGIS Server Enterprise Yes, you can use SQL Server Express with Enterprise. As for "...it's supposed to work fine", there are no functional limitations that ArcGIS places on it, but ...


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), ...


0

If you are happy with Java then GeoTools provides SQLServer and Shapefile datastores that will allow you to do the conversion. But to be honest I'd use ogr2ogr, which is something like: ogr2ogr "MSSQL:server=.\MSSQLSERVER2008;database=geodb;tables=rivers;trusted_connection=yes" dst.shp



Top 50 recent answers are included