I am new to PostGIS and QGIS. I am trying to convert geom to geog and then cast it back to geom in order to buffer my streets by 1,000 ft with this query:
SELECT a.gid, (st_buffer(a.geom::geography,304.8)::geometry) as geom, a.street_ext FROM public.orangeburgroads a JOIN public.orangeburg b ON st_within(st_centroid(a.geom), b.geom) LIMIT 1000;
And here is what I am getting:
Does anyone have a clue why I am getting this result?
FYI orangeburg is a municipal boundary and orangeburgroads is a street center-line file.