<html>
<head>
<!-- Template generated by Exclaimer Signature Manager Exchange Edition on 06:09:06 Monday, 13 November 2017 -->
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<style type="text/css">P.ImprintUniqueID {
MARGIN: 0cm 0cm 0pt
}
LI.ImprintUniqueID {
MARGIN: 0cm 0cm 0pt
}
DIV.ImprintUniqueID {
MARGIN: 0cm 0cm 0pt
}
TABLE.ImprintUniqueIDTable {
MARGIN: 0cm 0cm 0pt
}
DIV.Section1 {
page: Section1
}
.ExternalClass * {
LINE-HEIGHT: 100%
}
</style>
</head>
<body>
<p class="ImprintUniqueID"></p>
<div>if you use relative to direction of travel, you'll need separate line features for each segment & direction to be able to work it out.<br>
<br>
Instead of using direction of travel you can use degrees to angle relative to direction of linestring (which is pretty much fixed), so +-90, 90/180 and for points on the centreline you can use an artificial value of (say) -999<br>
<br>
Or geographic (compass) direction, ie: degrees expressing NSEW relative to the road, which is totally fixed, being absolute & independent rather than relative..<br>
<br>
Brent Wood<br>
<br>
Programme leader: Environmental Information Delivery<br>
NIWA<br>
DDI: +64 (4) 3860529<br>
<br>
</div>
<br>
<table class="ImprintUniqueIDTable" style="BORDER-COLLAPSE: collapse" cellspacing="0" cellpadding="0" border="0">
<tbody>
<tr>
<td style="FONT-SIZE: 18pt; FONT-FAMILY: Arial; COLOR: #333333" valign="top"><font style="font-family:Calibri;font-size:12pt;color:#1F497D;font-weight:normal;">Brent Wood</font></td>
</tr>
<tr height="2">
<td height="1"><font style="font-family:Calibri;font-size:10pt;color:#1F497D;">Principal Technician - GIS and Spatial Data Management</font><br>
<font style="font-family:calibri;font-size:10pt;color:#1F497D;">Programme Leader - Environmental Information Delivery</font></td>
</tr>
</tbody>
</table>
<table class="ImprintUniqueIDTable" style="HEIGHT: 1px; BORDER-COLLAPSE: collapse; WIDTH: 96.43%" height="1" cellspacing="0" cellpadding="0" border="0">
<tbody>
<tr>
<td><font style="font-family:Calibri;font-size:10pt;color:#1F497D;">+64-4-386-0529</font><font style="font-family:Calibri;font-size:10pt;color:#1F497D;"> |
</font><font style="font-family:Calibri;font-size:10pt;color:#1F497D;">301 Evans Bay Parade, Greta Point, Wellington</font><font style="font-family:Calibri;font-size:10pt;color:#1F497D;text-decoration:none;"> |
</font><span style="font-family:Calibri;font-size:10pt;color:#0066CC;text-decoration:underline;"><a href="http://www.niwa.co.nz" title="" target="" style="font-family:Calibri;font-size:10pt;color:#0066CC;text-decoration:underline;"><span style="font-family:Calibri; font-size:10pt; color:#0066CC; text-decoration:underline;">www.niwa.co.nz</span></a></span></td>
</tr>
</tbody>
</table>
<table class="ImprintUniqueIDTable" style="BORDER-COLLAPSE: collapse; PADDING-BOTTOM: 5px; PADDING-TOP: 5px" height="76" cellspacing="0" cellpadding="0" width="500" border="0">
<tbody>
<tr>
<td style="WIDTH: 541px" height="66" valign="top" width="475" align="left"><a href="http://www.niwa.co.nz" target=""><img width="538" height="66" style="border: 0px Solid ; " src="cid:imagea23780.JPG@4d1ee7fd.44827d88" alt="NIWA"></a></td>
</tr>
</tbody>
</table>
<table class="ImprintUniqueIDTable" style="HEIGHT: 1px; BORDER-COLLAPSE: collapse; WIDTH: 96.43%" height="1" cellspacing="0" cellpadding="0" border="0">
<tbody>
<tr>
<td><font color="#1f497d" size="2" face="Calibri">To ensure compliance with legal requirements and to maintain cyber security standards, NIWA's IT systems are subject to ongoing monitoring, activity logging and auditing. This monitoring and auditing service
may be provided by third parties. Such third parties can access information transmitted to, processed by and stored on NIWA's IT systems.</font></td>
</tr>
</tbody>
</table>
<table class="ImprintUniqueIDTable" style="BORDER-COLLAPSE: collapse" cellspacing="0" cellpadding="0" width="500" border="0">
<tbody>
</tbody>
</table>
<div>________________________________________<br>
From: postgis-users [postgis-users-bounces@lists.osgeo.org] on behalf of Zizi Jama [mazizi.jama@gmail.com]<br>
Sent: Monday, November 13, 2017 03:13<br>
To: postgis-users@lists.osgeo.org<br>
Subject: [postgis-users] Adding a position (direction) attribute to a point feature<br>
<br>
I have a a point feature (representing street signs).<br>
<br>
I would like to do the following:<br>
<br>
1. add street segment name to the point feature (I will create a buffer around my street segment and perform a spatial join)<br>
<br>
2. add on which side of the street segment is the point feature located (options are left, right, centre), this is where I stuck - what would be the best approach to deal with my use case<br>
<br>
[Inline image 1]<br>
Thank you in advance for your suggestions.<br>
<br>
Regards,<br>
<br>
Zizi<br>
<br>
</div>
<br>
<br>
<br>
<p></p>
</body>
</html>