topic Re: Write floating point value to SDE/PostGIS in Python Questions

Write floating point value to SDE/PostGIS

BerendVeldkamp — Fri, 11 Nov 2011 09:21:14 GMT

Hi,

I'm trying to insert a new row into an SDE/PostGIS database, using Python. The field is defined as numeric(38,8) in PostgreSQL, and as double in ArcCatalog. The decimal symbol in windows' language settings is set to '.'

Here's some sample code:

featureClass = "Database Connections\Connection to sde\sde.schema.featureclass"
rows = arcpy.InsertCursor(featureClass)
row = rows.newRow() 
row.value = 1.88
rows.insertRow(row)

This results in a value '1' in the table. I also tried float(1.88) and '1.88' but these also result in 1. Setting the value to '1,88' results in 188.

How can I solve this?

Best regards,
Berend Veldkamp

Re: Write floating point value to SDE/PostGIS

AntonioSergio — Wed, 23 May 2012 11:26:07 GMT

Hi Berend,

I'm having the same problem!

How you solve that?

Best Regards,

António Sérgio

Re: Write floating point value to SDE/PostGIS

BerendVeldkamp — Wed, 23 May 2012 12:23:35 GMT

Hard to say, one year afterwards 😉

I seem to remember we never found a fix, but decided to ignore it because the decimals weren't significant anyway (in our case).
I would suggest you contact you local ESRI representative, it might be a bug. Who knows?

Re: Write floating point value to SDE/PostGIS

AntonioSergio — Wed, 23 May 2012 12:28:25 GMT

Thanks Berend

Re: Write floating point value to SDE/PostGIS

AntonioSergio — Fri, 25 May 2012 14:13:43 GMT

Hi Berend,

We made some tests and it seems that the problem is from ArcGIS Desktop side: if we change the Desktops Windows 7 Regional Settings from Portuguese (Portugal) format to English (United States), the decimal part of numbers is displayed,

Best Regards,

António Sérgio