topic Re: Geometry reading from Sde GDB in Data Management Questions

Geometry reading from Sde GDB

ManojGarg — Thu, 24 May 2012 06:08:48 GMT

HI,

I need to get geometry from Sde Geodatabase (Oracle 11g) stored in BLOB and write into csv or XML to other system to progess specially line and polygon.

What is the best way to get the data out either in xml or csv including geometry column? This has to be done outside ArcMAP or Arccatalog.

I know inside ArcMap using Arc Object, we can write read geometry but that will be slow and have dependancy of ArcMap instance. Anyway other easier and faster way to read geometry..

Thanks Manoj

Re: Geometry reading from Sde GDB

VinceAngelo — Sat, 11 Dec 2021 22:08:16 GMT

There are an infinite number of XML formats -- did you have a particular DTD/XSD in mind?

I doubt it would be easier or faster, but it would be simple and fast to use 'sdequery' to dump
the data to ASCII (comma, tab, or pipe-delimited strings with Well-Known Text geometries).

D:\>sdequery

ArcSDE 10.0 Generic Query Tool           Thu May 24 07:05:22 2012
------------------------------------------------------------------------
sdequery  -h

sdequery [-C <column_list>] [-t <table_list>] [-w <'where clause'>]
         [-# <row_count>] [-l <table,column>] [-V <Version_Reference>] [-q]
         [-A] [-v] [-N] [-vI <feature_count>] [-d <Dumpfile_Reference>]
         [-B <buffer_distance>] [-P {UTM | ALBERS | LAMBERT | proj_code}]
         [-S <sampling_probability>] [-Q {ATTR | JFA | JSF | JSFA | V3}]
         [-L <query_logfile>] [-R <result_logfile>] [-O <Order-by clause>]
         [-a <alias_list>] [-Fn <method:[{TRUE | FALSE}:]shape_string>]
         [-E <minx,miny,maxx,maxy>] [-s <server_name>]
         [-i {instance | port#}] [-D <database>] [-u <DB_user_name>]
         [-p <DB_user_password>]

D:\>sdequery -t table -d table.txt,'|' -s server -u user -p userspassword ...

Line and polygon data tend to be very large in Well-Known Text, which will be the prime
contributor to runtime performance.

'sdequery' is part of the se_toolkit tool suite. I've got "to-do" tasks for SQL, CSV, and KML
export, but no time to do them in.

- V

Re: Geometry reading from Sde GDB

ManojGarg — Sat, 11 Dec 2021 22:08:18 GMT

Thanks Vangelo.. let me try this as well. No particular DTD/XSD as long as I can get complete geometry's .
I am using ESRI 9.3.1 SP2

There are an infinite number of XML formats -- did you have a particular DTD/XSD in mind?

I doubt it would be easier or faster, but it would be simple and fast to use 'sdequery' to dump
the data to ASCII (comma, tab, or pipe-delimited strings with Well-Known Text geometries).
D:\>sdequery

ArcSDE 10.0 Generic Query Tool           Thu May 24 07:05:22 2012
------------------------------------------------------------------------
sdequery  -h

sdequery [-C <column_list>] [-t <table_list>] [-w <'where clause'>]
         [-# <row_count>] [-l <table,column>] [-V <Version_Reference>] [-q]
         [-A] [-v] [-N] [-vI <feature_count>] [-d <Dumpfile_Reference>]
         [-B <buffer_distance>] [-P {UTM | ALBERS | LAMBERT | proj_code}]
         [-S <sampling_probability>] [-Q {ATTR | JFA | JSF | JSFA | V3}]
         [-L <query_logfile>] [-R <result_logfile>] [-O <Order-by clause>]
         [-a <alias_list>] [-Fn <method:[{TRUE | FALSE}:]shape_string>]
         [-E <minx,miny,maxx,maxy>] [-s <server_name>]
         [-i {instance | port#}] [-D <database>] [-u <DB_user_name>]
         [-p <DB_user_password>]

D:\>sdequery -t table -d table.txt,'|' -s server -u user -p userspassword ...
Line and polygon data tend to be very large in Well-Known Text, which will be the prime
contributor to runtime performance.

'sdequery' is part of the se_toolkit tool suite. I've got "to-do" tasks for SQL, CSV, and KML
export, but no time to do them in.

- V