I am using the code below:<div><br></div><div><b>Select name, acreage, ST_Area(ST_Transform(geom, 26986))/43560 as acres from ss.fields</b></div><div><br></div><div>and getting these results.  </div><div><br></div><div><br>

</div><div><table style="color:rgb(0,0,0);font-family:arial,tahoma,verdana,helvetica,sans-serif,serif;font-size:13px"><tbody><tr><th class="data" style="background-color:rgb(230,230,204);font-size:smaller">name</th><th class="data" style="background-color:rgb(230,230,204);font-size:smaller">

acreage</th><th class="data" style="background-color:rgb(230,230,204);font-size:smaller">acres</th></tr><tr><td class="data1" style="background-color:rgb(243,243,233);margin:4px;font-family:arial,tahoma,verdana,helvetica,sans-serif,serif;padding:0px;font-size:smaller;text-align:left;white-space:nowrap">

H 01</td><td class="data1" style="background-color:rgb(243,243,233);margin:4px;font-family:arial,tahoma,verdana,helvetica,sans-serif,serif;padding:0px;font-size:smaller;text-align:left;white-space:nowrap"><div style="text-align:right">

15.79</div></td><td class="data1" style="background-color:rgb(243,243,233);margin:4px;font-family:arial,tahoma,verdana,helvetica,sans-serif,serif;padding:0px;font-size:smaller;text-align:left;white-space:nowrap"><div style="text-align:right">

1.50398045317257</div></td></tr><tr><td class="data2" style="background-color:rgb(230,230,204);margin:4px;font-family:arial,tahoma,verdana,helvetica,sans-serif,serif;padding:0px;font-size:smaller;text-align:left;white-space:nowrap">

H 02</td><td class="data2" style="background-color:rgb(230,230,204);margin:4px;font-family:arial,tahoma,verdana,helvetica,sans-serif,serif;padding:0px;font-size:smaller;text-align:left;white-space:nowrap"><div style="text-align:right">

29.02</div></td><td class="data2" style="background-color:rgb(230,230,204);margin:4px;font-family:arial,tahoma,verdana,helvetica,sans-serif,serif;padding:0px;font-size:smaller;text-align:left;white-space:nowrap"><div style="text-align:right">

2.76480120804097</div></td></tr><tr><td class="data1" style="background-color:rgb(243,243,233);margin:4px;font-family:arial,tahoma,verdana,helvetica,sans-serif,serif;padding:0px;font-size:smaller;text-align:left;white-space:nowrap">

H 03</td><td class="data1" style="background-color:rgb(243,243,233);margin:4px;font-family:arial,tahoma,verdana,helvetica,sans-serif,serif;padding:0px;font-size:smaller;text-align:left;white-space:nowrap"><div style="text-align:right">

31.95</div></td><td class="data1" style="background-color:rgb(243,243,233);margin:4px;font-family:arial,tahoma,verdana,helvetica,sans-serif,serif;padding:0px;font-size:smaller;text-align:left;white-space:nowrap"><div style="text-align:right">

3.04337512685165</div></td></tr><tr><td class="data2" style="background-color:rgb(230,230,204);margin:4px;font-family:arial,tahoma,verdana,helvetica,sans-serif,serif;padding:0px;font-size:smaller;text-align:left;white-space:nowrap">

H 04</td><td class="data2" style="background-color:rgb(230,230,204);margin:4px;font-family:arial,tahoma,verdana,helvetica,sans-serif,serif;padding:0px;font-size:smaller;text-align:left;white-space:nowrap"><div style="text-align:right">

34.71</div></td><td class="data2" style="background-color:rgb(230,230,204);margin:4px;font-family:arial,tahoma,verdana,helvetica,sans-serif,serif;padding:0px;font-size:smaller;text-align:left;white-space:nowrap"><div style="text-align:right">

3.30710750534269</div></td></tr><tr><td class="data1" style="background-color:rgb(243,243,233);margin:4px;font-family:arial,tahoma,verdana,helvetica,sans-serif,serif;padding:0px;font-size:smaller;text-align:left;white-space:nowrap">

H 05</td><td class="data1" style="background-color:rgb(243,243,233);margin:4px;font-family:arial,tahoma,verdana,helvetica,sans-serif,serif;padding:0px;font-size:smaller;text-align:left;white-space:nowrap"><div style="text-align:right">

111.6</div></td><td class="data1" style="background-color:rgb(243,243,233);margin:4px;font-family:arial,tahoma,verdana,helvetica,sans-serif,serif;padding:0px;font-size:smaller;text-align:left;white-space:nowrap"><div style="text-align:right">

10.6322788992474</div></td></tr></tbody></table></div><div><br></div><div><br></div><div><br></div><div>I have another program where I am importing the acreage data from and I just wanted it to match up in postgis well in case I ever wanted to calculate it myself.  It seems that I am almost there, but I am a decimal off and I can't understand that.  </div>

<div><br></div><div>Also I am not very familiar with the 26986, but I used it because I saw it used for sqare feet somewhere else.  Should I be using anything else?  <br><br>Thanks,<br><br>DC<br>
</div>