I am try create materialized views in Oracle listing a
linestring vertices with their longitude and latitude in separate columns. So I know I would need to count the vertices in each polygon or linesegment but I am not having any luck on either task.
I am trying to get a loop to work to count the vertices in each object but it's not working.
for nn in 1..(nn-1) loop select OBJECTID, SDE.st_x (SDE.st_pointn (sde.st_exteriorring (SHAPE), nn)) as X, SDE.st_y (SDE.st_pointn (sde.st_exteriorring (SHAPE), nn)) as Y from (SELECT sde.st_numpoints (shape) as nn from dual, SDW.trpBridge_test), SDW.trpBridge_test order by objectid; end loop;