[cx-oracle-users] Fetching Coordinates by using SDO_UTIL.GETVERTICES

[Moritz L. <mor...@go...>]

Hi,

I want to fetch coordinates from my Oracle database (11g Locator). I will
try it with the intern function SDO_UTIL.GETVERTICES().

*My sql query looks like:*
*"""SELECT a.id <http://a.id> , t.x, t.y, t.z, d.Classname FROM   building
a, THEMATIC_SURFACE b, SURFACE_GEOMETRY c,
TABLE(SDO_UTIL.GETVERTICES(c.geometry))t, OBJECTCLASS d  WHERE
 a.grid_id_500 = 2728 AND a.id <http://a.id> = b.BUILDING_ID AND
b.LOD2_MULTI_SURFACE_ID = c.ROOT_ID AND c.GEOMETRY IS NOT NULL AND
b.OBJECTCLASS_ID = d.ID""")*

Afterwards I create the json:

* for id,x,y,z, classname in cursor: result.append({
"building_nr":id,"geometry": { "type":"polygon","coordinates":[x,y,z],},
"polygon_typ":classname,})*

* But of course I get only one Point:*

[{'building_nr': 1314867, 'geometry': {'type': 'polygon', 'coordinates':
[(3500936.67, 5394350.72, 439.17400000000004)]}, 'polygon_typ':
'BuildingWallSurface'}, ...



The problem is I get only one point geometry.

But for example there exists 5 points for this wall surface. I need all
points with the same building_nr (id)!

Can I iterate over x,y,z ?



-- 
*Moritz Liebelt, B. Sc.*

Murgstraße 19
76437 Rastatt
E-Mail: mor...@go...