How do I create a spatial view that generates dynamic point geometry of the start point and end point of a line feature class?
I have successfully made a similar view that is a buffer of a line feature class with this SQL:
SELECT OBJECTID, SDE.ST_BUFFER(SHAPE, 1) AS LINE_BUFFER FROM ENG.ROAD
I thought I'd be able to use similar SQL to generate start points of lines using the PointN function:
SELECT OBJECTID, SDE.ST_POINTN(SHAPE, 1) AS START_POINT FROM ENG.ROAD
The view creates successfully, however it only creates a tabular view, not a spatial view. What have I done wrong?
I'm also unsure how to get the end point index position, but I'm not even thinking about that yet.