Skip to main content
Geographic Information Systems

Return to Question

code formating + tag
Source Link
JGH
JGH
  • 43.1k
  • 3
  • 46
  • 93

I've got a table which it has a geometry column filed by some point (ex. "POINT Z (116.309627 39.991285 148)""POINT Z (116.309627 39.991285 148)"). now I want to select point's id from the table. I wrote follow sql Code but I force an error (ERROR: Operation on two GEOMETRIES with different SRIDs SQL state: XX000).

select id from database where (point_lat_lon = 'POINT Z (116.309627 39.991285 148)');

ERROR: Operation on two GEOMETRIES with different SRIDs SQL state: XX000

select id from database
    where (point_lat_lon = 'POINT Z (116.309627 39.991285 148)');

I've got a table which it has a geometry column filed by some point (ex. "POINT Z (116.309627 39.991285 148)"). now I want to select point's id from the table. I wrote follow sql Code but I force an error (ERROR: Operation on two GEOMETRIES with different SRIDs SQL state: XX000).

select id from database where (point_lat_lon = 'POINT Z (116.309627 39.991285 148)');

I've got a table which it has a geometry column filed by some point (ex. "POINT Z (116.309627 39.991285 148)"). now I want to select point's id from the table. I wrote follow sql Code but I force an error:

ERROR: Operation on two GEOMETRIES with different SRIDs SQL state: XX000

select id from database
    where (point_lat_lon = 'POINT Z (116.309627 39.991285 148)');
Source Link
Arash m
Arash m
  • 55
  • 1
  • 2
  • 7

How to select from geometry column in postgresql?

I've got a table which it has a geometry column filed by some point (ex. "POINT Z (116.309627 39.991285 148)"). now I want to select point's id from the table. I wrote follow sql Code but I force an error (ERROR: Operation on two GEOMETRIES with different SRIDs SQL state: XX000).

select id from database where (point_lat_lon = 'POINT Z (116.309627 39.991285 148)');