Skip to main content
added 6 characters in body
Source Link
Kadir Şahbaz
  • 78k
  • 57
  • 257
  • 404

SELECT round((ST_Area(ST_PolyFromText("POLYGON((27.55858717457406 76.6309398865454,27.493737501738696 76.6305965637915,27.49130108815994 76.67728845832275,27.496173861399882 76.69376795051025,27.516576256439183 76.69720117804931,27.536366008597625 76.69273798224853,27.55858717457406 76.6309398865454))"))* 10000000) /0.8587,3)

SELECT
  round(
    (
      ST_Area(
        ST_PolyFromText(
          "POLYGON((27.55858717457406 76.6309398865454,27.493737501738696 76.6305965637915,27.49130108815994 76.67728845832275,27.496173861399882 76.69376795051025,27.516576256439183 76.69720117804931,27.536366008597625 76.69273798224853,27.55858717457406 76.6309398865454))"
        )
      ) * 10000000
    ) / 0.8587,
    3
  )

SELECT round((ST_Area(ST_PolyFromText("POLYGON((27.55858717457406 76.6309398865454,27.493737501738696 76.6305965637915,27.49130108815994 76.67728845832275,27.496173861399882 76.69376795051025,27.516576256439183 76.69720117804931,27.536366008597625 76.69273798224853,27.55858717457406 76.6309398865454))"))* 10000000) /0.8587,3)

SELECT
  round(
    (
      ST_Area(
        ST_PolyFromText(
          "POLYGON((27.55858717457406 76.6309398865454,27.493737501738696 76.6305965637915,27.49130108815994 76.67728845832275,27.496173861399882 76.69376795051025,27.516576256439183 76.69720117804931,27.536366008597625 76.69273798224853,27.55858717457406 76.6309398865454))"
        )
      ) * 10000000
    ) / 0.8587,
    3
  )
Source Link

SELECT round((ST_Area(ST_PolyFromText("POLYGON((27.55858717457406 76.6309398865454,27.493737501738696 76.6305965637915,27.49130108815994 76.67728845832275,27.496173861399882 76.69376795051025,27.516576256439183 76.69720117804931,27.536366008597625 76.69273798224853,27.55858717457406 76.6309398865454))"))* 10000000) /0.8587,3)