0

I am facing issue to get lat/lon from point table. I have two point table with different spatial reference and I am able to get lat/lon from nce_gis_table while I apply same query to another point table with name nce_north_gis_table, I am getting following error

ERROR: Argument to Y() must be a point SQL state: XX000

Getting error

I am able to get lat/lon from nce_gis_table

Improve this question
3
  • 3
    check if your 'nce_north_gis_table' geometry is a Point Geometry.
    – Marco Reliquias
    Commented Nov 8, 2022 at 10:27
  • 2
    Please do not present your SQL solely as a picture. This forces anyone who would attempt to reproduce it to type it all in again.
    – Vince
    Commented Nov 8, 2022 at 10:31
  • Yes nce_north_gis_table is a point table
    – kawish abbas
    Commented Jan 30, 2023 at 8:05

1 Answer 1

Reset to default
0

if your geometry of 'nce_north_gis_table' is not a Point Geometry, you could put the "ST_Centroid()" function before calling the "Y()" function, that way you 'force' the point geometry

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.