ST_Length returns the length of an ST_LineString or ST_MultiLineString.
sde.st_length (ln1 sde.st_geometry) sde.st_length (mln1 sde.st_geometry)
A local ecologist studying the migratory patterns of the salmon population in the county's waterways wants the length of all stream and river systems within the county.
The waterways table is created with the ID and name columns, which identify each stream and river system stored in the table. The water column is a multilinestring because the river and stream systems are often aggregates of several linestrings.
CREATE TABLE waterways (oid integer, name varchar(128), water sde.st_geometry);
INSERT INTO waterways VALUES ( 1111, 'Genesee', sde.st_multilinestring ('multilinestring ((33 2, 34 3, 35 6), (28 4, 29 5, 31 8, 43 12), (39 3, 37 4, 36 7))', 0) );
The query returns the name of each system along with the length of the system generated by the ST_Length function.
SELECT name, sde.st_length (water) "Length" FROM WATERWAYS; NAME Length Genesee 27.6437123
SELECT name, sde.st_length (water) AS "Length" FROM waterways; name Length Genesee 27.6437123