Invoking Oracle Spatial from a Custom Command
Consider a requirement where the centroid of a set of points needs to be retrieved within a custom command. This can be achieved using the ‘GTDataProvider.DataContext.Execute‘-method:
Category Archives: Oracle
Sorting and merging geometries in Oracle Spatial
Consider a requirement where an unsorted set of geometries needs to be merged into a single geometry. Take for instance the following set of geometries where: a Red dot indicates the startpoint The arrow indicates the drawing direction The label “1-50” indicates the order of drawing and an identifier for the geometry Both of these… Read More »
SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT 3D bug workaround
The SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT function fails for 3D Compound line strings geometries as discussed over here. This is illustrated by the following sample: 2d: produces: While the same geometry in 3d is considered invalid: A Quick workaround for this is to convert the geometry to 2d: result: hope this helps, Stephan
Identifierviews
If you select a feature, GTech shows the selected feature in Feature Explorer. The right area of feature explorer shows attributes of the selected feature, the left area shows the identification of the selected feature. This will show something like ‘Feature name – Fid’ (G3E_FEATURENAME – G3E_FID), in the picture below you can read ‘Point… Read More »
A would like to have G/Technology development environment
Every time I do a G/Technology project I like to discuss how things need to be done. One aspect that always turns up is how limited you actually are as a GTech developer, due to Intergraph. If you or your teammates don’t know how a certain aspect works, your doomed. Even if you know how… Read More »
Transferring G/Technology databases for development purposes
If you are busy with a team developing all kinds of GTechnology enhancements, you will find yourself most of the time in Oracle, configuring metadata, creating PL/SQL code or otherwise. When all developers are sharing the same database, it is very likely that things get messed up and I therefore always like to have a… Read More »
Debugging Oracle PL/SQL from Visual Studio
I use TOAD for my day-to-day Oracle development, but I find it’s debugging experience very poor compared to Visual Studio. Using ODP.Net version 11 you can use Visual Studio to debug Oracle PL/SQL. Here’s how to do it. First you need to install ‘Oracle Data Access Components for Oracle Client 11.2.0.2.1’ or higher. You can… Read More »