Tag Info

New answers tagged

0

Have you tried using the newer pg_dump command line tools on your PostgreSQL 8.3 (you can run it from the 64-bit server and have it back up the 32-bit). It's been a while since I've done that, but that often works better than using the older tool.


2

There are a number of issues raised by your question. First off, there's only one database involved. Databases can have multiple user schemas, and each connection is to a schema in a database. User schemas can create multiple feature datasets, which are not equivalent to databases (your problem description is very confusing in this regard, since "owner", ...


0

I know this post is a little old but I though I would share my answer since I was faced with the same issue. The following script SHOULD copy all tables, feature classes and relationships not in a dataset and also will copy over all datasets including the feature classes, topology, etc withing the dataset. import arcpy, os def ...


2

We use FME Workbench via the ArcGIS Data Interoperability Extension, which comes with our ESRI Enterprise License Agreement. Using FME gives us the ability to: Promote from Dev to QA to Prod instances of ArcGIS Ensure Field names and Field Types are consistent between environments Provide an accessible tool for our non-GIS-using DBA to run an ETL to our ...


0

If the preference is to remove specific SDE user locks, there is a way to do this via arcpy. I prefer this approach because it doesn't require that you jump onto the database server to perform an sde command. I can disconnect any unwanted locks, then perform data updates all in one script/process. Example from the above link is very useful: import arcpy ...


0

This is the code that works :) import arcpy mxd = arcpy.mapping.MapDocument(r"N:\\5-Processes\\Resources\\DynamicData\\SourceMXD\\Copies for GDTEST\\Test\\Data_CCTV.mxd") tables = arcpy.mapping.ListTableViews(mxd) for t in tables: t.replaceDataSource("C:\\Users\\ferencek\\AppData\\Roaming\\ESRI\\Desktop10.2\\ArcCatalog\\sde_appreader (SDE_LIVE) ...


1

You've got a few issues here. For one, there's no "ListTables" method in arcpy.mapping. There's arcpy.mapping.ListLayers and arcpy.mapping.ListTableViews? I've cleaned up the code a bit. # generally - don't end lines with semicolon in python import arcpy mxd = arcpy.mapping.MapDocument(insert_path_here) tables = arcpy.mapping.ListTableViews(mxd) for t in ...


0

It is possible! What you need first is a versioned feature class. To be bried, I assume you already know how to create versions and edit them, say using ArcMap or Arcpy. Unfortunately, there is no pre-packaged way to do it in JSAPI (AFAIK in 3.12), however, you can easily create geoprocessing services in Python that will do it though Arcpy and are accessible ...


0

We ended up having our dba go in and delete these orphaned locks from the table_locks table through the SQL backend. No further issues so far.


0

I'll start by saying this issue is a great candidate for a support call if that's available to you. However, you can get a better idea of what's happening on your own with the following: Orphaned locks can be caused by application crashes or critical errors during some geodatabase operations. There is also an ArcGIS server bug in 10.1 when applying ...


0

Some of ArcSDE operations are pretty heavy and it is mentioned in the documentation. ESRI is improving it. Check out cursors for example (classical vs arcpy.da). One big con I can think right off the bat is that how you manage mutual exclusion and load balancing on your connection(s). Also, you may run into transactional issues, locks, etc. Note that ...


0

If you have the Oracle client installed on your system then you can suffice with just the database and port number. No host required.


1

This seems to have been a issue with SQL Server for some time now. Not sure why they don't allow it. If you change your update statement to something like this, it should work. UPDATE [dbo].[MyFeatureClass_evw] SET [dbo].[MyFeatureClass_evw].[Status] = ( SELECT A.[Status_2] FROM [dbo].[MySDEDataTable] AS A WHERE ...


4

The term "SRID" is overloaded in the GIS realm. In most contexts it refers to the coordinate reference system (CRS) of spatial data, but in Esri use, it really does refer to the spatial reference system, which is a combination of CRS with the X, Y, Z, and M offsets, X/Y, Z, and M scaling factors, the precision (HIGH or BASIC), the cluster tolerances (which ...


1

The database will accept any value for the x,y, and srid. The srid is just like the .prj file and is just metadata about what coordinate system the data should be. Esri stores this coordinate system metadata in the sde_spatial_references table. You would be able to store GCS coordinates in a projected srid. Your data just wouldn't line up with properly ...



Top 50 recent answers are included