Revisions to Getting the length of line inside polygon

community site url

Source Link

edited Nov 13, 2013 at 19:23

SELECT ST_Length(ST_Intersection(line,polygon))

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))

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

SELECT ST_Length(ST_Intersection(line,polygon))

deleted 79 characters in body

Source Link

edited Jun 12, 2012 at 11:34

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)) 
FROM lines 
WHERE road = "Road 7" AND ST_Intersects(line, polygon)

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)) 
FROM lines 
WHERE road = "Road 7" AND ST_Intersects(line, polygon)

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))

Source Link

created Jun 12, 2012 at 11:25

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)) 
FROM lines 
WHERE road = "Road 7" AND ST_Intersects(line, polygon)

Return to Answer