New answers tagged

0

As Vince suggested, the query needed to return ST_Geometry, not ST_Point: SELECT OBJECTID, SDE.ST_GEOMETRY (SDE.ST_ASTEXT (SDE.ST_STARTPOINT (SHAPE)),300049) AS START_POINT FROM ENG.ROAD This SQL does not work for multi part lines. If you need to work with multi-part lines, my guess is you'll have to figure something out with the line string ...


0

I migrated all my datas from Oracle to PostGIS. The result is outstanding. I can now load and visualize everything on the fly. I assume PostGIS is handling spatial datas with much more efficiency, or QGIS is shaped for PostGIS.


1

We did have similar issue with Oracle Spatial. In our case we need to adding more permissios for geom-columns (or whatever column you use to store geometries). GRANT UPDATE ("GEOM") ON "MYSCHEMA"."MYTABLE" TO "OTHERSCHEMA_USER"; It seems that other GIS desktop applications are not so strict. More information from QGIS Developer email list.


1

As Aileen said, Oracle has no specific concept of an EMPTY geometry as differentiated from a straight NULL geometry. All spatial operations involving NULL geometries behave according to the regular rules for NULLs in relational algebra - put simply: anything combined with NULL is NULL. I just realized that there is specific syntax in the WKT notation to ...


3

This is the question/response I got from oracle's spatial expert in Europe in 2014. q: Does oracle have the concept of an empty geometry? If so can you give me an example? Would this be a valid way of creating an empty point? SDO_GEOMETRY(2001, NULL, SDO_POINT_TYPE(NULL, NULL, NULL), NULL, NULL) My initial reaction was there is no such thing as an empty ...


0

I don't work with QGIS but I assume it is able to take advantages of the spatial indexing provided by the database, i.e. only load those features that are in your current viewport. This happens on the fly. There is no need to design anything for that. Maybe you need to tick a box in your table definition in QGIS to say "use spatial index". But I would ...



Top 50 recent answers are included