I am using the code below: *Select name, acreage, ST_Area(ST_Transform(geom, 26986))/43560 as acres from ss.fields*
and getting these results. name acreageacres H 01 15.79 1.50398045317257 H 02 29.02 2.76480120804097 H 03 31.95 3.04337512685165 H 04 34.71 3.30710750534269 H 05 111.6 10.6322788992474 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. 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? Thanks, DC
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users