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

[John Zhang]

Many thanks to you Simon and Regina.


--------------------------------------------

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