Tag Info

New answers tagged

1

With ST_GEOMETRY and SDO_GEOMETRY you can use SQL in addition to ArcGIS Desktop to work with your data. Although with SQL, one should take many precautions (read the docs). To migrate from sde_binary to one of above, you have to reload all data into your database. Migrate Storage (Data Management)


0

The problem isn't an actual lack of minimum vertex count per entity type, but that there are likely coincident vertices causing improper construction. I would suggest to examine the shape or geometry columns of your data for coincident vertices within the same geometry. You can put together a script to loop through and identify these if you have many ...


0

No, ArcSDE is not capable of full-text search. but the databases through which it is used to connect are. Furthermore, the ArcSDE API exposes some of the database capability in functions to access XML column contents. I've never personally successfully configured a database to perform free-text search. I suspect there may be black magic involved, since I ...


1

After so many tries i was able to copy Export current personal gdb to xml workspace document and also export arcfm properties, then import xml workspace document and arcfm properties to arcsde. Before running geometric network dont forget to registered as version. use right click import/export from the ArcCatalog tree.


1

Use your DBMS tools to edit the SERVER_CONFIG system table, parameter named CONNECTIONS. The SERVER_CONFIG (sde_server_config in SQL Server and PostgreSQL) table contains initialization parameters and values that define how an enterprise geodatabase uses memory. The parameters and their default values are listed in the "Initialization parameters" ...


0

Per Documentation: With ArcSDE, putting a feature class in load-only mode disables updating of the spatial index while data is loading. In a File Geodatabase, putting a feature class or table in load-only mode disables updating of spatial and attribute indexes while data is loading. Taking the feature class or table out of load-only mode ...


5

Your question is a mélange of misinformation and cross-threaded topics, which makes it exceedingly difficult to answer. First off, there is no comparison of the "SDE API" and "MSSQL Native geodata format". ArcSDE is many things, including a code library for accessing data (not spatial data, all types of data, including geometry) in multiple SQL (and ...


1

First of all, both Copy and Import will honor any relationships. per the ArcGIS documentation: Any data dependent on the input is also copied. For example, copying a feature class or table that is part of a relationship class also copies the relationship class. The same applies to a feature class that has feature-linked annotation, domains, subtypes, ...


2

Like many GIS projects, there are a couple phases to this task. First, you must get to know your data. Once you know what you are working with, you can create your automation to achieve your goal. To standardize data, first you need to know all of your starting values. It looks like the field Street Type is the field in question in this particular exercise, ...


1

It isn't strictly required to alter the services or services.sde file with SQL-Server, and if you don't specify a port or mnemonic with the -i flag at step 1, then step 2 is completely unnecessary (since it's too late to change from the default of esri_sde 5151/tcp). In fact, best practice is to add non-standard services entries before sdeservice -o create. ...


1

5151 is the standard. you are welcome to select any port that is open by editing the services.sde file and adding it, or alternatively remove the comment mark # from the default entry. Help can be found on the esri website. 10.1 MS SQL Server help


1

You'll need to install the ArcObjects SDK to work with your enterprise geodatabases. If you have ArcGIS, the SDK is available to you as a separate install. You can find it either on your installation DVD (if you have one) or for download from the customer service site. Please see the links below for more info. ...


0

I imagine that these lines are actually composed of multiple line features (called an Aggregate in FME terminology, that the CAD format you're writing to doesn't support aggregates, and so FME writes them as a block so that the relationship is preserved. If you do want them as lines, and don't care about the relationship so much, insert a Deaggreator ...


1

Had an ‘Incorrect edit version type' message popup when attempting unversioned edits on feature classes within a feature dataset. The following solution may help out with those that come across the original issue (use with caution): Register the unversioned feature dataset causing trouble as versioned and then immediately unregister as versioned. When ...


0

@ Alex Tereshenkov Please see this script which takes into account the token generation for AGOL hosted features. import arcpy import json import urllib import urllib2 gtUrl = 'https://www.arcgis.com/sharing/rest/generateToken' gtValues = {'username' : 'yourUserName', 'password' : 'YourPassWord', 'referer' : 'http://www.arcgis.com', 'f' : 'json' } gtData ...


3

Give a quick read of this blog. It lays the ground work for what you want to do. You just need to replace FeatureSet with RecordSet. The following code uses a featureservice, and brings down the items as a table -- you keep saying table, so I assume you're talking items without geometry. If you actually mean features, change the returnGeo field to True, and ...


1

You run your model from ArcMap which is aware of the Database Connections folder present in Catalog window. However when you execute your code in an external Python file, the arcpy cannot find the Database Connections. You need to supply the .sde connection file stored somewhere on your disk. I always recommend use an .sde file even in models. You can find ...



Top 50 recent answers are included