topic Re: Problem with double field type in postgis database in Data Management Questions

Problem with double field type in postgis database

MilosIlic — Mon, 16 Dec 2013 07:45:45 GMT

I have connection to PostGis database through ArcSDE, and all double type numeric fields are cutting numbers after comma. For example, instead 255,11 i have in my field 255. Does anyone know how can i fix this problem?

Re: Problem with double field type in postgis database

WilliamCraft — Mon, 16 Dec 2013 13:58:26 GMT

I have connection to PostGis database through ArcSDE, and all double type numeric fields are cutting numbers after comma. For example, instead 255,11 i have in my field 255. Does anyone know how can i fix this problem?

Can you please be more specific about the issue you're seeing? You should also provide the version of ArcSDE, ArcGIS, etc. you are using along with the exact version of the RDBMS. With regard to the issue you're facing, it seems like you indicate that the fields in question are numeric (DOUBLE, to be specific)... then you mention "255" and "11"; are you saying that 255 is your precision and 11 is your scale? If you explore the tables directly from a database management tool, do you see the same behavior as you see from ArcGIS Desktop?

Re: Problem with double field type in postgis database

MilosIlic — Mon, 16 Dec 2013 19:00:44 GMT

Sorry, i am using arcgis desktop 10.0 and arcsde also 10.0...in my database i have point feature class with field type double where i
store the height of point. So, as i said field is double with lenght 38 and precision 8.
When i mention "255.11", that was just example, if i create new point and want to type "255.11" in the table i can see only "255".
When i approach to table through pgadmin i also see the same as in table from ArcMap and ArcCatalog view.

Kind regards

Re: Problem with double field type in postgis database

WilliamCraft — Mon, 16 Dec 2013 19:35:04 GMT

Ok, now I see more of what you're saying. At the PostgreSQL level, what version of the RDBMS are you using and which PostgreSQL data type are you using for that field?

http://www.postgresql.org/docs/9.1/static/datatype-numeric.html
http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//002p0000006p000000

If you said DOUBLE in ArcGIS, then it's probably a NUMERIC data type in PostgreSQL. Are you certain that your precision and scale in PostgreSQL are set to 38 and 8, respectively?

Re: Problem with double field type in postgis database

MilosIlic — Mon, 16 Dec 2013 20:19:23 GMT

Yes the field in NUMERIC(38,8), when you create field double in ArcCatalog, it's automatically create numeric field on postGis level.
For RDBMS i am not sure, and don't know how to check that.