New answers tagged


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 ...


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 ...


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 ...


Here are few web-links which might be helpful:


The result being returned is the string 'EQUAL', not 'TRUE'. So this query returns the correct result : select a.g3e_fid , b.g3e_fid , SDO_GEOM.RELATE( SDO_CS.MAKE_2D( a.g3e_geometry), 'DETERMINE', SDO_CS.MAKE_2D( b.g3e_geometry), 0.1) "Relation" from gc_fbranch_s a, gc_fsplice_s b where a.g3e_fid = 53455168 and b.g3e_fid = 38274644 ...


May be you can change the styles in your published layers. layer(Menu on the left)---> select you published layers--->select publish --->Default Style--->change to polygon


What worked for me was to export the data in shapefile format. This can then be imported into a geodatabase if required. Note that exporting to shapefile will result in field names being truncated if they exceed 10 characters.

Top 50 recent answers are included