I have created quite often (in posgis) points using two variables from the table (LAT,LON) and setting the desired SRID.I am trying to do something similar now with Oracle SQL developer but I keep getting errors when I try to display this as a layer in geoserver.This is what I try:
SELECT ID, CO_NAME, ADJUSTMENT_FACTOR, MDSYS.SDO_GEOMETRY(null,2100,SDO_POINT_TYPE(24.004632439599,24.004632439599,NULL),NULL,NULL) AS GEOM FROM CENTRAL_OFFICESInstead of the variables LAT and LNG I have just put two random numbers. Moreover I want to ask how is possible to view in a readable format the generated geometry. Something like: ST_ASTEXT of postgis.
أكثر...
SELECT ID, CO_NAME, ADJUSTMENT_FACTOR, MDSYS.SDO_GEOMETRY(null,2100,SDO_POINT_TYPE(24.004632439599,24.004632439599,NULL),NULL,NULL) AS GEOM FROM CENTRAL_OFFICESInstead of the variables LAT and LNG I have just put two random numbers. Moreover I want to ask how is possible to view in a readable format the generated geometry. Something like: ST_ASTEXT of postgis.
أكثر...