Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I would like to be able to have the upstream invert at the top of the main and the downstream at the bottom.

<---Down Label---------------------------------------------Up Label--->
share|improve this question

The GEOMTRANSFORM keyword can be used to add symbols to the start and the end points.

Have a look at the tricks section where arrows are added to the start and end of a line.


As a simpler (and perhaps more flexible) alternative, you can create a point layer in your map file with no symbology that dynamically reads the end points of the line. You can even create your dynamic start and end labels in the query.

The SQL example below works with SQL Server 2008, but if you are using a different database you should be able to use a similar syntax.

DATA "GEOM FROM (SELECT MyID, GEOM.STStartPoint(), 'Start' as Label FROM MyLines 
      UNION ALL SELECT MyID, GEOM.STEndPoint(), 'End' as Label
      FROM MyLines) as points USING UNIQUE MyID USING SRID=4326"

As a plus you can then switch labels on and off by showing/hiding the layer.

share|improve this answer
but can I label these symbols? – Nathan W Nov 8 '11 at 10:35
Is it fixed text? Or is it different for u/s d/s and per feature? – geographika Nov 8 '11 at 17:01
different per feature. – Nathan W Nov 8 '11 at 22:13

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.