<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>PostGIS query layer in ArcMap - Double values look like integers</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.5730.13" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=066540120-28062011><FONT
face="Eras Medium ITC" size=2>Could it be the Rounding settings in the Number
Format dialog? You can access the Number Format dialog by clicking the
[...] to the right of the word "Numeric" in the Field Properties
dialog.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=066540120-28062011><FONT
face="Eras Medium ITC" size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=066540120-28062011><FONT
face="Eras Medium ITC" size=2>-Rob</FONT></SPAN></DIV>
<DIV> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>Sheara Cohen<BR><B>Sent:</B> Tuesday, June 28, 2011 3:17 PM<BR><B>To:</B>
postgis-users@postgis.refractions.net<BR><B>Subject:</B> [postgis-users] PostGIS
query layer in ArcMap - Double values looklike integers<BR></FONT><BR></DIV>
<DIV></DIV><!-- Converted from text/plain format -->
<P><FONT size=2>Does anyone know why the values in a double field would appear
like integers when a PostGIS file is viewed as a query layer in
ArcMap?<BR><BR>In other words, I've added a PostGIS table as a query layer to
ArcMap, and when I open the attribute table, several fields only have integer
values (no decimal places) even though you can check the properties of those
fields and verify that they are indeed double. When the same table is viewed in
PGAdmin the values display with all their appropriate decimal
places.<BR><BR>What gives?<BR><BR>Thank you.<BR><BR>Sheara</FONT>
</P></BODY></HTML>