How to get the length of a line inside a polygon

Question

How can I get the length (brown marked part) of the "Road 7" inside the red polygon?

a busy cat

My start:

SELECT ST_Length(way) FROM lines WHERE road = "Road 7" AND ST_Intersects(line, polygon)?

With that, I get only the total length :( Someone has an idea?

underdark · Accepted Answer · 2012-06-12 11:34:05Z

up vote 8 down vote accepted

It's necessary to calculate the actual intersection, e.g. http://postgis.refractions.net/docs/ST_Intersection.html

SELECT ST_Length(ST_Intersection(line,polygon))

edited Jun 12 '12 at 11:34

answered Jun 12 '12 at 11:25

underdark♦
29.1k444126

You beat me to it. +1 this should do it. – GIS-Jonathan Jun 12 '12 at 11:26

1 Answer