swmm_vw_vertices

SELECT link,

    round((st_x((dp).geom))::numeric, 2) AS x_coord,

    round((st_y((dp).geom))::numeric, 2) AS y_coord,

    state,

    hierarchy,

    obj_id

   FROM ( SELECT swmm_vw_conduits.name AS link,

            st_dumppoints(swmm_vw_conduits.geom) AS dp,

            st_npoints(swmm_vw_conduits.geom) AS nvert,

            swmm_vw_conduits.state,

            swmm_vw_conduits.hierarchy,

            swmm_vw_conduits.obj_id

           FROM tww_app.swmm_vw_conduits) foo

  WHERE (((dp).path[1] <> 1) AND ((dp).path[1] <> nvert));