[postgis-users] Line Segment inside polygon

[Obe, Regina DND\MIS]

I'm trying to match street segments to political districts.  Basically what
political district a street segment falls into.  The way the political
districts are cut, they are cut along the center line of the street
segments.

When I use truly_inside .. I get the right answer for the most part - except
for the situation where the street segment is part of the border of a
political district polygon - in which case the centerline - really sits in
both districts.  (one side of the street is really in one district and the
other side of the street is in another district)

My first hunch is to break this line into 2 parallel lines(representing each
side of the street) where the middle line is what I currently have (the
center line)

	______________

	- - - ----- - - - - -  -

	______________


I assume I need to use the translation function of some sort, but since this
is all new to me, I'm a bit lost.  Note that my street segments may not be
straight lines (but most are only composed of 2 - 6 points)