Skip to main content
Solved

st_geometry to (esri shape column) p


outlook
Contributor
Forum|alt.badge.img+3

Hi All,

 

I want to update geometry  column (esri SDE) from postgresql writer. 

What I need to do ? 

esri keeps the point value  like. 

2D000000010000000100040001000000110000000101000090D1D3C2A00380A6E4AFBA0880A8D6B90700000000

 

I can reading from the postgresql as  sde.asText / asBinary    but I can not write 

Best answer by nielsgerrits

I have not tried but I guess it is technically possible. What is the reason you do not want to use the SDE reader / writer?

View original
Did this help you find an answer to your question?

6 replies

nielsgerrits
VIP
Forum|alt.badge.img+54

When you want to write to SDE you need the Esri Geodatabase (ArcSDE Geodb) writer.


outlook
Contributor
Forum|alt.badge.img+3
  • Author
  • Contributor
  • March 21, 2024

I want to write directly to postgresql. I am wondering  posibility..


nielsgerrits
VIP
Forum|alt.badge.img+54
  • Best Answer
  • March 22, 2024

I have not tried but I guess it is technically possible. What is the reason you do not want to use the SDE reader / writer?


outlook
Contributor
Forum|alt.badge.img+3
  • Author
  • Contributor
  • March 24, 2024
nielsgerrits wrote:

I have not tried but I guess it is technically possible. What is the reason you do not want to use the SDE reader / writer?

postgresql’s writing performans better than the sde writer. Especially for bulk update. 
I am using the postgresql for attribute update. But what I need to update geometry&attribute, it is updating very slowly.

Than I am wondering posssibility directly using the postgresql db.


nielsgerrits
VIP
Forum|alt.badge.img+54

I think this can be split in 2 parts:

  • The how to technically. I have never tried updating the geometry column, but if I google a bit it looks like it is doable.
  • The SDE integrety. You probably need to update the spatial index and the spatial extent of the featureclass, as this is done by SDE when you do a update using the SDE writer.

hkingsbury
Celebrity
Forum|alt.badge.img+53
  • Celebrity
  • March 25, 2024

I’d be really cautious about writing to the underlying SDE database. There are a whole heap of additional steps SDE undertakes (especially if the featureclass is versioned and/or archived). As @nielsgerrits alluded to you’ll need to update indices. I also think there is a separate table that keeps track of objectids


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings