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

[Simon Greener]

John,

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 ST_GeomFromText.

Regards
Simon

⁣Get BlueMail for Android ​

On 30 Jun 2020, 06:13, at 06:13, Regina Obe <lr at pcorp.us> wrote:
>I think ArcGIS has it’s own ST_Geometry format.  Is this in postgis
>geometry or ST_Geometry or some other thing?
>
> 
>
>From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On
>Behalf Of John Zhang
>Sent: Monday, June 29, 2020 4:02 PM
>To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
>Subject: [postgis-users] How to apply PostGIS spatial functionality on
>Feature classes in Enterprise GeoDB for Postgres?
>
> 
>
>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
>
> 
>
> 
>
>
>
>------------------------------------------------------------------------
>
>_______________________________________________
>postgis-users mailing list
>postgis-users at lists.osgeo.org
>https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200630/18db3dde/attachment.html>