[postgis-users] How to apply PostGIS spatial functionality on Feature classes in Enterprise GeoDB for Postgres?

John Zhang johnzhang06 at gmail.com
Tue Jun 30 08:20:31 PDT 2020

Many thanks to you Simon and Regina.



Regina points to something that needs resolving before you start.

What is the data type of the SHAPE column?

If it is PostGIS's geometry/geography you can read and process it
using pl/pgSql directly.

If it is something like sde.ST_Geometry you need to construct a
PostGIS geometry from it using ESRI's ST_AsText method and PostGIS's


⁣Get BlueMail for Android

On 30 Jun 2020, 06:13, at 06:13, Regina Obe <lr at pcorp.us
<https://lists.osgeo.org/mailman/listinfo/postgis-users>> wrote:
>*I think ArcGIS has it’s own ST_Geometry format.  Is this in postgis
*>*geometry or ST_Geometry or some other thing?

On Mon, Jun 29, 2020 at 4:01 PM John Zhang <johnzhang06 at gmail.com> wrote:

> Dear PostGISers,
> I have a need to perform certain spatial analysis to develop a stored
> function on a Feature Class(FC) using pl/pgSQL. The FCs use a Shape field
> to store spatial data. How can I apply PostGIS functionality on these
> FCs, for example, obtain a list of road segments of a known segment? Do I
> have to turn the FCs into spatial tables? If yes, will there be any
> negative impact on regular ArcGIS functionality?
> Your input will be much appreciated. Thank you!
> --
> Yours sincerely,
> John Zhang

Yours sincerely,

John Zhang
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200630/54900f38/attachment.html>

More information about the postgis-users mailing list