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 <[email protected]> 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
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
