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

2020-06-30 Thread John Zhang
s-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 wrote: > Dear PostGISers, > > I have a need to perform certain spatial analysis to develop a sto

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

2020-06-29 Thread John Zhang
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

Re: [postgis-users] How to sql scripts in a file?

2020-04-23 Thread John Zhang
r: > curs.execute(open(sqlF,'r').read()) > > So that if no exception has been raised, the transaction is committed. In > case of exception the transaction > is rolled back. Also the cursor is then properly closed, without affecting > the transaction. > > Giusep

[postgis-users] How to sql scripts in a file?

2020-04-23 Thread John Zhang
sfully. However, the code above runs quietly without any issues raised but NO results was worked out. In the sql file, there are scripts to DROP FUNCTION IF EXISTS and CREATE OR REPLACE FUNCTION. Your input to shed light on it would be much appreciated. Thank you -- Yours sin