<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{mso-style-priority:99;
mso-style-link:"Plain Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.5pt;
font-family:Consolas;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.PlainTextChar
{mso-style-name:"Plain Text Char";
mso-style-priority:99;
mso-style-link:"Plain Text";
font-family:Consolas;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoPlainText>In a shapefile, especially routes, you can have user defined measures (m-values, usually in miles), they might not be same when you measure the two dimenstional line, from start to end vertices of any feature. These shapefiles would have begin and end post fields as attributes.<o:p></o:p></p><p class=MsoPlainText>It is not the case for any shapefiles with line types since two dimensional measures deviate from real distance from point a to point b. Moreover they would not be in miles.<o:p></o:p></p><p class=MsoPlainText>I was asking if I import a shapefile of “polyline M” into PostGIS would I be able to get measure in miles given a point or would I be able to get points given a measure in miles? Orelse there is different mechanism in PostGIS<o:p></o:p></p><p class=MsoPlainText>to the same job. If so how it is done. I know there are few methods to retrieve a mile point or a measure give a point in PostGIS. Doesn’t this require calibrating the route, first, like I found out in this link (<a href="http://www.faunalia.com/lrs">http://www.faunalia.com/lrs</a>). Sorry for not being very clear in my previous question. I thought people might have confounded this situation and can easily understand it. Please let me know if still do not understand or help me if you can.<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>Date: Tue, 21 Aug 2012 21:12:04 -0400<o:p></o:p></p><p class=MsoPlainText>From: "Paragon Corporation" <<a href="mailto:lr@pcorp.us">lr@pcorp.us</a>><o:p></o:p></p><p class=MsoPlainText>Subject: Re: [postgis-users] created linear referencing system<o:p></o:p></p><p class=MsoPlainText>To: "'PostGIS Users Discussion'"<o:p></o:p></p><p class=MsoPlainText> <<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>><o:p></o:p></p><p class=MsoPlainText>Message-ID: <527D56A990434161A53D6CA92B3D9ED9@O><o:p></o:p></p><p class=MsoPlainText>Content-Type: text/plain; charset="us-ascii"<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>Muni,<o:p></o:p></p><p class=MsoPlainText> <o:p></o:p></p><p class=MsoPlainText>Not sure what you are asking and maybe others have a similar problem<o:p></o:p></p><p class=MsoPlainText>understanding. That might be why you haven't received an answer.<o:p></o:p></p><p class=MsoPlainText> <o:p></o:p></p><p class=MsoPlainText>What do you mean by linear reference capable? All spatial data that is of<o:p></o:p></p><p class=MsoPlainText>linestrings can be linearly referenced. Are you talking about a specific<o:p></o:p></p><p class=MsoPlainText>tool you are using?<o:p></o:p></p><p class=MsoPlainText> <o:p></o:p></p><p class=MsoPlainText>when you load your data from shape file to PostGIS, the data is still the<o:p></o:p></p><p class=MsoPlainText>same. If it had linestrings before, it should still have linestrings.<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText> _____ <o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>From: <a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a><o:p></o:p></p><p class=MsoPlainText>[<a href="mailto:postgis-users-bounces@postgis.refractions.net">mailto:postgis-users-bounces@postgis.refractions.net</a>] On Behalf Of Melpati,<o:p></o:p></p><p class=MsoPlainText>Muni<o:p></o:p></p><p class=MsoPlainText>Sent: Tuesday, August 21, 2012 4:07 PM<o:p></o:p></p><p class=MsoPlainText>To: <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><o:p></o:p></p><p class=MsoPlainText>Subject: [postgis-users] created linear referencing system<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>Hi,<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>I have asked this question before and could not get straight answer. I have<o:p></o:p></p><p class=MsoPlainText>a shape file which Linear reference capable. How to import such data?<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>If I load the data using shape file loader, would the imported data is<o:p></o:p></p><p class=MsoPlainText>linear reference capable. If not how to recreate linear referencing system<o:p></o:p></p><p class=MsoPlainText>on imported data?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>