[GIS] How to create buffer around point having projection 4326

buffercoordinate systemlatitude longitudepostgis-2.0

I am trying to create buffer (in meters) around point(long lat alt) which is in projection 4326 with below code. But it is not giving expected output.

SELECT ST_AsTEXT(ST_Buffer((ST_GeomFromText('POINT(78.385333 17.433293 0)', 4326)),63.763271854));

But if i convert point to geography it is giving correct result.

SELECT ST_AsTEXT(ST_Buffer((ST_GeomFromText('POINT(78.385333 17.433293 0)', 4326))::geography,63.763271854));

What this st_buffer doing with geography datatype. Without converting it to geography how can i do that? I am new to postgis.

Best Answer

The basis for the PostGIS geographic type is a sphere.

The basis for the PostGIS geometry type is a plane. (same link)

Thus, when you run ST_Buffer on a EPSG:4326 geometry, the output is given in degrees of lat/lon. On the other hand, when you do the same for EPSG:4326 geography, you get result in meters.

What you can do (besides using geography type) is projecting your data into the "better" CRS than EPSG:4326 (i.e. national grid system).

Related Solutions

[GIS] find location details within circle buffer

STBuffer and STIntersects are the functions you want I think. This is an example of getting the location records within a 10m buffer around the point:

select * from locations where shape.STIntersects(geography::STPointFromText('POINT(32.113, -81.3225)', 4326).STBuffer(10))=1

Where 4326 is the SRID (assuming the data is in WGS84) and 'shape' is the name of the spatial column

[GIS] How to convert MultiLines to MultiPolygons using Postgis

You have to use ST_DUMP first to split the multilines into seperate lines, buffer those and then collect them into a multi again:

UPDATE rivers
  SET poly = p.npoly
  FROM  (
    SELECT ST_MULTI(ST_COLLECT(ST_BUFFER((q.dump).geom,1) ORDER BY (q.dump).path)) as npoly    
    FROM (
     SELECT ST_DUMP(lines) AS dump from rivers   where id = 1
          ) as q
          ) as p
   where id = 1

Best Answer

Related Solutions

[GIS] find location details within circle buffer

[GIS] How to convert MultiLines to MultiPolygons using Postgis

Related Question