I'm trying to calculate percentages of land cover in census blocks using the field calculator.
I have one field (Block_SF) that is the total square footage of the census block and another field (Imp_SF) that is the square footage of impervious surface in each block.
There is a third field (Imp_Pct) that I would like to use to calculate the percent of coverage in each block that is impervious surface.
The math is fairly simple - impervious sf divided by total square foot should yield a decimal that I can use as the percentage. However, when I use field calculator to do so, the results are always either a zero or a one, which seems to indicate that it is rounding to the nearest integer. I've tried different formats for the column - short integer and long integer - and have gone into the numeric values and made sure the decimal points were as many as four. Still the same result.
Any idea what I'm missing to get the decimal values I'm looking for?