[Data Error] Set plot elevations

[dlebauer]

Dataset

elevation values at Maricopa and Ashland Bottoms are sometimes 0. Need to fix this, elevation for plots can assume flat fields.

Suggested Correction

update sites set geometry = st_geometryfromtext(replace(st_astext(st_force3d(st_force2d(geometry))), ' 706', ' 353.00'), 4326) where city = 'Maricopa' and st_zmax(geometry) = 706;
update sites set geometry = st_geometryfromtext('POLYGON Z ((-111.9747967 33.0764953 353,-111.9747966 33.0745228 353,-111.9750963 33.074485715 353,-111.9750964 33.0764584 353,-111.9747967 33.0764953 353))', 4326) where id = 6000000001;
update sites set geometry = st_geometryfromtext(replace(st_astext(st_force3d(st_force2d(geometry))), ' 0', ' 353.00'), 4326) where city = 'Maricopa' and st_zmax(geometry) = 0;

update sites set geometry = st_geometryfromtext(replace(st_astext(st_force3d(st_force2d(geometry))), ' 0', ' 313.00'), 4326) where city = 'Ashland' and st_zmax(geometry) = 0;
commit;

[dlebauer]

fixed