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 <[email protected]> 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:[email protected]] On >Behalf Of John Zhang >Sent: Monday, June 29, 2020 4:02 PM >To: PostGIS Users Discussion <[email protected]> >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 >[email protected] >https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
