1
vote
0answers
34 views

Why do pgadmin III views show up as empty ArcSDE geodatabase tables in ArcCatalog? [on hold]

I have an SDE geodatabase connection set up in a server with data stored in a postgres database. I have successfully created views using pgadmin III but they show up as empty tables in ArcCatalog ...
2
votes
1answer
38 views

How to add ST_GEOMETRY column to an exitsting table that already has X Y columns

I have created and Oracle 11g geospatial geodatabase and have create an arcsde connection. I have been connected using arcmap, as a simple user (not sde or schema-user), who has all the proper rights ...
1
vote
1answer
19 views

Syntax to view permissions on Oracle table

I want to be able to see what permissions have been granted on a specific object in my Oracle geodatabase. What would my script look like? Thank you.
0
votes
1answer
42 views

Integrate geodatabase with other nonspatial databases in oracle 11g using ArcGis for Desktop 10.2

I have an oracle database namely xe which I have spatially enabled. using the Create Enterprise Geodatabase geoprocessing tool. The application I am going to implement has an already created ...
1
vote
2answers
50 views

Create an enterprise geodatabase - Administrator username and password are required

I am trying to create an enterprise geodatabase in oracle 11g, using the create enterprise geodatabase tool in arcmap 10.2. I have properly installed the oracle client needed and I am able to create ...
1
vote
1answer
25 views

Concurrency and lock challenge in Nonversioned editing in ArcMap

I use a non version SQLServer geodatabse with geometry type for spatial data storing.To do so,I have registered all layers in SDE repository and geodatabase and ArcMap shows all layers and edit them ...
2
votes
2answers
33 views

Using a selection tool will select everything

When I use the Selected Features tool and try to drag a box around a few small items it grabs everything. If i use the edit tool it will correctly select only features that are inside/intersect the ...
1
vote
0answers
16 views

Updated features from GDB after Check-out Replica created from ArcSDE GDB [closed]

I have created Check-out Replica from the main ArcSDE GDB. I have below questions. If GDB Admin update few things (Attribute or Spatial) after version was created, will it be reflected in the child ...
1
vote
1answer
58 views

Why does arcpy.TableToDomain_management require exclusive schema lock?

I'm talking about arcpy.TableToDomain_management, ArcGIS Server 10.2 It seems that this function requires exclusive SDE database schema lock. Something that we can't accept. We have ESRI domains but ...
1
vote
1answer
40 views

Replicate Geodatabase and append to main SDE database

I have my ArcSDE GDB on SQL Server 2005. This we are maintaining at our end at head office. Now we have installed ArcGIS editor license to regional offices. GIS technicians at regional offices can't ...
0
votes
0answers
32 views

What is the most efficient method for deleting row/features from a versioned FC in python?

I'm trying to delete all records from a feature class in SDE and then append new data using python. My dataset is versioned in SDE. I've tried Truncate Table (doesn't work with versioned tables), ...
2
votes
1answer
57 views

Python script fails on stand alone but works in ArcMap as a toolbox

I have a fresh install of ArcGIS Server and ArcGIS for Desktop both 10.2, latest patches applied. The data is served in this application from a PostgresSQL enterprise geodatabase. The problem is that ...
1
vote
1answer
55 views

Model Builder or a python script for pulling SDE data in a single GDB file

Would like to know if Model Builder or a Python Script would be better for pulling dozens of fc from ArcSDE into a single .gdb file ? The tool will need to be run on a regular basis.
2
votes
0answers
25 views

ArcGIS Publisher PMF Version Compatibility

Does anyone know of version compatibility issues of creating a PMF? Or links to that documentation? I have not seen anything from Esri. I have asked Esri Support, and will update with their response. ...
2
votes
1answer
76 views

Update Attribute based on spatial location

I want to spatially (Spatial Join) update few fields, not all, from another feature class. Is there any way to select and update few fields instead of all the fields from the other layer and ...
2
votes
1answer
65 views

RuntimeError: Field is not editable when using InsertCursor on ArcSDE geodatabase with ArcFM installed?

We are running ArcGIS Desktop 10.1 SP1, and also have ArcFM installed. I have this simple code: workspace = "C:\\my.sde" arcpy.env.workspace = workspace edit = arcpy.da.Editor(arcpy.env.workspace) ...
0
votes
0answers
34 views

Connect to PostgreSQL from ArcMap 10.2 failed [duplicate]

I have a database server PostgreSQL and Postgis. I want to connect to database from ArcMap 10.2 , I tried Add Database Connection from arcmap menü. I typed my connection informations and clicked ...
4
votes
1answer
41 views

Update value in domain and same should reflect in attribute field

I have a SDE GDB, where i have no. of domains created. we have created domain for state names, which is used by all feature classes to update their respective state name. Now i have discovered that ...
1
vote
1answer
111 views

How to create an SQL Persisted Computed Column which values are derived from spatial column

Our GDB is using the SQL native GEOMETRY data storage type (SQL 2012 Standard) and the spatial reference for this uses a unit of square feet. I want to create a (persisted) computed column which will ...
1
vote
2answers
106 views

Exporting lists of Feature classes and fields from SDE

I'm using matt wilkies' arcplus module http://gis.stackexchange.com/a/5943/16793 to export a list of feature classes within an SDE database to a text file. I've also written a tool to write field ...
0
votes
0answers
27 views

Web Editing Versioned Enterprise GDB

I would like to implement a web editing environment where edits are posted to a version of a database (delta tables) not too default. The idea behind this is so that any edits made through a web app ...
1
vote
1answer
66 views

Cannot create new spatial database connection in ArcCatalog?

I have searched a lot in the net, but i just found Add Spatial Database Connection fails? here. However, I cannot see the confirmed answer. I want to know if anyone has found the solution? my ...
1
vote
1answer
55 views

ArcMap 10.2.1 issues diffferent SQL than 10.0 for “Select by location”?

I have a large point layer and I'm doing a "Select by Location" to select all points that intersect a specific selected polygon from a polygon table. In ArcMap 10.0 the SQL that was executed was ...
0
votes
4answers
56 views

Populate a field from another field with a conditional

I am working in SDE geodatabase where I have a feature class 'Mange_Waste' and "Q1", "Q2" are two fields. I wanted to use python script for populating "Q2" from "Q1" with a condition. Like, if the ...
1
vote
0answers
83 views

Changing default precision and scale of number fields in ArcSDE geodatabase table?

After I change the precision and scale for my short, long, float, and double field types when creating a table in ArcMap SDE geodatabase, ArcMap will reset my precision and scale to default values. ...
1
vote
1answer
41 views

Select parcels from SDE layer using table list and exporting to shapefiles

Using a table of county fips codes and state name, I need to select from a large parcel layer stored in SDE and export to individual shapefiles based on the fips code and state name from the table. ...
1
vote
1answer
210 views

The create feature task could not be completed. the coordinates or measures are out of bounds

I'm trying to create a layer based on a feature class, in ArcMap (I've created a geodatabase from Arcatalog and linked it to PostgreSQL). The feature class that I've created is registered as ...
0
votes
1answer
48 views

ArcGIS Feature Class Extent Changing

I've been having a problem with the extents of feature classes in our SDE here at work. Our database is divided into feature datasets that have various feature classes in them. The problem is as ...
2
votes
2answers
157 views

How to copy selected features from one sde feature class to another with different attributes using Arcpy?

I am new to Arcpy scripting, I need help on copying the features to SDE feature class. My Scenario: We have 2 Geo databases running on Oracle 11g ArcSDE 10.2 . I have been asked to write the python ...
2
votes
1answer
58 views

Can you run GIS Squirrel next to SDE?

My company has SDE to run our webmapping system. We want our arcbasic license users to be able to edit this data without dropping 30k for 6 users on upgrading to standard. Can we run squirrel next ...
0
votes
1answer
39 views

Identifying inserts, updates, deletes, and conflicts between a parent and child version in ArcSDE with ArcPy

I'm looking for a way to identify records that have changed between the present and the last time a version was reconciled. It would also be great to be able to identify conflicting records. Ideally ...
1
vote
0answers
198 views

Using arcpy.CopyFeatures_management results in a 000210 using a database connection that does not contain saved credentials

Currently have a problem running CopyFeatures_management in ESRI's ArcGIS 10.1 The following shows two Enterprise Geodatabase connection files. One includes the username and password and the other ...
0
votes
0answers
77 views

Prevent self-intersecting loops when exporting polygon layer from ArcSDE to File Geodatabase?

I am using ArcGIS 10.1. The source data is housed in an ArcSDE instance that does not allow self-intersections. When I export this data to a file geodatabase and run check geometry ...
1
vote
1answer
110 views

ArcSDE/SQL Server Permissions

I have an enterprise geodatabase with about 20 users. Each user has a corresponding schema. When in Arc Catalog, if only the owned schema box is checked in SQL Management studio I receive a ...
1
vote
0answers
133 views

Running python script outside of Arcmap's python console

My codes works fine in Arcmap's python windows. But when I try to run it in a command promt windows, It says that; ERROR 000837: The workspace is not the correct workspace type. But it works fine ...
4
votes
2answers
179 views

How to transfer attributes to thousands of local points from ArcSDE feature class with millions of polygons?

I have a set of points and a huge feature class with topographic information (OS MasterMap for who knows it). I'm talking millions of polygons huge. I want to transfer attributes of the polygons to ...
4
votes
3answers
107 views

Preparations for a transition to ArcSDE [closed]

So I'm a GIS Intern for a city government, we are preparing to purchase ArcSDE and implement it to our current GIS setup. I'm curious as to what should be done before it is purchased. Our GIS consists ...
3
votes
1answer
191 views

What is the correct order for compressing, rebuilding indexes and updating statistics in ArcGIS?

I want to script out the compressing, rebuilding of indexes and updating statistics on our SDE databases, but I want to make sure I have the correct order for these to run. What would be the correct ...
0
votes
1answer
168 views

How to fix spatial reference error on CopyFeatures ArcGIS tool?

When I run the CopyFeatures tool to copy features from an ArcSDE geodatabase to another empty ArcSDE geodatabase (no features, no tables), I get the following result: The error message is about the ...
2
votes
1answer
53 views

How to stop transfer of large raster into arcsde geodatabase

I have just realised that I will not have enough space on my harddrive to accomodate a raster which is being copied into an arcsde geodatadatabase. I am afraid, that if I stop the process in ...
1
vote
1answer
339 views

Why does copying ArcSDE datasets and features in Python give ERROR 000732 & 000735?

Go easy, I'm new to python I keep getting a kick back that says this: ERROR 000732: Input Features: Dataset 'Database Connections\Wyoming.sde\Supporting_MT_DBO_Geology' does not exist or is not ...
2
votes
0answers
129 views

Issues importing feature class to SDE SQL Server 2012

I have received an error indicating there could be issues with my geometry when attempting to import a feature class into SDE. I ran the check geometry tool. No issues. I have removed all fields ...
0
votes
1answer
65 views

How to force deletion of corrupt ArcSDE Raster?

ArcSDE 9.3 / ArcGIS Server 10.0 / ArcCatalog Advanced 10.0 After an unsuccessful attempt at creating a mosiac, ArcCatalog refuses to allow deletion of the corrupt Raster file. The Mosiac creation ...
1
vote
1answer
146 views

Not enough memory in the file group “Primary”: SDE Database error with MSSQL

I got this error message whilst trying to load data into a raster in ArcMap 10.0. Underlying DBMS error [Microsoft SQL Server Native Client 10.0: Eine neue Seite für die sde-Datenbank konnte nicht ...
2
votes
1answer
247 views

Installing ArcGIS 10.1 on Win7 64 bit

Just reformatted my PC with Win7 64bit to try and take advantage of 64-bit python processing. However I'm not sure what to do here: Our office runs ArcGIS 10.1, TOAD and SDE for Oracle. Toad ...
1
vote
1answer
60 views

Analyze Datasets (Data Management) - what is the output?

I recently completed a Analyze Datasets procedure on my ArcGIS 10.1 SDE. However, I could not find a tangible output to review. Does anyone know where I can find the output?
0
votes
2answers
70 views

database using arcgis [closed]

i want to know, can arcgis software do the database such as oracle or ms access?? for example, create own database and form?? and can the database in arcgis read the programmer program such as from ...
1
vote
1answer
203 views

Why does FeatureClassToFeatureClass field mapping create shapefile with no attribute values on local machine from ArcSDE?

I have inherited taking over and supporting and ArcSDE GIS database. We have a process that we must do every 6 months to export certain features from the ArcSDE database into shape files so that they ...
1
vote
1answer
299 views

How to edit PostgreSQL geodatabase table using ArcPy?

I'm trying to update a table using a python script and it's not working. The table resides in a postgres geodatabase and is versioned. I have also verified my user permissions (I'm the admin). The ...
1
vote
0answers
50 views

Is there a way to prevent losing metadata when generating a spatial view in ArcSDE 10.1?

When generating a spatial view in ArcSDE using a script, any previous metadata is dropped when the old view is dropped. Thus, any edits to metadata on the view, are lost. Is there a way to keep the ...