POST
|
From the RDBMS directly, you can use the following queries: To get a list of all tables registered with the geodatabase, use: select table_name from sde.TABLE_REGISTRY; To get a list of all layers (i.e., all GDB-registered tables which have a spatial column) within SDE, use: select table_name from sde.LAYERS; If you are wanting to know more spatial-specific information, the following Python script has worked for me (substitute your own info): import os, subprocess, arcgisscripting, string, sys, os gp = arcgisscripting.create(9.3) gp.workspace = r"C:\Users\User1\AppData\Roaming\ESRI\ArcCatalog\test.sde" server = 'server' def describeFeatures(sdeWorkspace,logWorkspace, logName,instance,user, psswd): logfile = open(os.path.join(logWorkspace, logName), 'w') datasets = gp.listdatasets("","") for dataset in datasets: gp.workspace = sdeWorkspace + os.sep + dataset for fc in gp.ListFeatureClasses(): args = ['sdelayer', '-o', 'describe_long', '-l', str(fc) + ',SHAPE','-i', instance, \ '-u', user, '-p', psswd, '-s', server] p = subprocess.Popen(args, stdout=subprocess.PIPE) output = p.stdout.read() logfile.write(fc) logfile.write(output) logfile.write("\n") print fc, output logfile.close() if __name__== "__main__": #connection to database sdeWorkspace = gp.workspace logName = "FeatureInfo.txt" logWorkspace = r"C:\Users\user1\Documents\python\DescribeFeatureClasses" instance = 'esri_metrorep' user = 'sde' psswd = 'sde' describeFeatures(sdeWorkspace,logWorkspace, logName,instance,user,psswd) Tanks a lot!
... View more
07-02-2013
09:18 AM
|
0
|
0
|
1519
|
POST
|
Hi! I'd like to know, how could I get a list of all my layers contents in SDE? Regards, Thanks in advance. aecalleja
... View more
06-28-2013
09:22 AM
|
0
|
3
|
2443
|
POST
|
I have developed some of applications on Flex 3 using API 1.3, now I'm going to migrate from ArcGIS 10 to ArcGIS 10.1 , so I need to know if it is probable that I will have trouble with some classes or functions included in the older API. Should I migrate my applications to API 3.3? Thanks in advance, Adriana C
... View more
05-23-2013
09:41 AM
|
0
|
1
|
330
|
POST
|
Hi everyone! I'm implementing a tool to load local shape files, it works like ShapeFiles widget from Flex Viewer, but I was wondering about the limit of the zip file, because when it has a huge amount of vertex it doesn't work, but about MB what's the size or the way to know if it works before the upload it. Regards, Thanks in Advance.
... View more
03-25-2013
12:46 PM
|
0
|
1
|
520
|
POST
|
Hi, I had the same issue and I was trying to change the identifyResult's spatialReference, finally I found that is better to not try that. I mean just use the widget and the bugs are least than before. Regards
... View more
03-12-2013
10:22 AM
|
0
|
0
|
361
|
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:23 AM
|