<html>
<head>
</head>
<body style="line-height: normal; margin-left: 4px; margin-bottom: 1px; margin-top: 4px; margin-right: 4px; font-variant: normal">
<p style="margin-top: 0; margin-bottom: 0">
<font face="Comic Sans MS" size="3">All,</font> </p>
<br>
<p style="margin-top: 0; margin-bottom: 0">
<font face="Comic Sans MS" size="3">So, I'm trying to make an imagemap of line segments that are all only two vertices long. (two-point line strings) from postgres, I've verified this with to_NumPoints on both of the features described below. This same template process works fine with SHP files. I have to be missing something obvious.</font> </p>
<br>
<p style="margin-top: 0; margin-bottom: 0">
<font face="Comic Sans MS" size="3">Using this call(which grabs two of the segments):</font> </p>
<br>
<p style="margin-top: 0; margin-bottom: 0">
<font face="Comic Sans MS" color="#0000ff" size="3"><u><a href="http://gis.ci.stpaul.mn.us/datasets/DB/SAINT_PAUL/PUBLIC_WORKS/AVL/STREETS/trails_segments_public.map?mapext=555266.1928265226%20157102.55366815554%20577346.2664937055%20170723.37833297616&mapsize=924%20570&mode=nquery&searchmap=true&veh_id=2153&time_idx1=4/24/2012%209:55:00&time_idx2=4/24/2012%209:56:00"><i>http://gis.ci.stpaul.mn.us/datasets/DB/SAINT_PAUL/PUBLIC_WORKS/AVL/STREETS/trails_segments_public.map?mapext=555266.1928265226%20157102.55366815554%20577346.2664937055%20170723.37833297616&mapsize=924%20570&mode=nquery&searchmap=true&veh_id=2153&time_idx1=4/24/2012%209:55:00&time_idx2=4/24/2012%209:56:00</i></a></u></font><font face="Comic Sans MS" size="3"></font> </p>
<br>
<p style="margin-top: 0; margin-bottom: 0">
<font face="Comic Sans MS" size="3">and that generates this SQL: </font> </p>
<br>
<p style="margin-top: 0; margin-bottom: 0">
<font face="Courier" size="3">select "esn","veh_id","time_idx1","time_idx2","time_interval","time_diff_secs","dist","gps_speed1","gps_speed2","calc_speed","bearing",encode(AsBinary(force_collection(force_2d("the_geom")),'NDR'),'hex') as geom,"veh_id" from public.stmaint_trails_segments as t where the_geom && GeomFromText('POLYGON((555258.759391547 157102.553668156,555258.759391547 170723.378332976,577353.699928681 170723.378332976,577353.699928681 157102.553668156,555258.759391547 157102.553668156))',200068) and ( veh_id like '2153' AND time_idx1 > '4/24/2012 9:55:00' AND time_idx2 <'4/24/2012 9:56:00')</font> </p>
<br>
<p style="margin-top: 0; margin-bottom: 0">
<font face="Comic Sans MS" size="3">and SQL result:</font> </p>
<br>
<p style="margin-top: 0; margin-bottom: 0">
<font face="Courier" size="3">11031823;"2153";"2012-04-24 09:55:13-05";"2012-04-24 09:55:31-05";"00:00:18";"18";474.708833608277;15.9;18.9;17.9813952124347;356.698784312184;"0107000000010000000102000000020000009aec99afc035214144b128eb9c430341158476038a3521411f0e92496c520341";"2153"</font> </p>
<p style="margin-top: 0; margin-bottom: 0">
<font face="Courier" size="3">11031823;"2153";"2012-04-24 09:55:31-05";"2012-04-24 09:55:50-05";"00:00:19";"19";474.002298490239;18.9;13.1;17.0096518596976;359.825436952247;"010700000001000000010200000002000000158476038a3521411f0e92496c52034199201020873521413bbac5493c610341";"2153"</font> </p>
<br>
<p style="margin-top: 0; margin-bottom: 0">
<font face="Comic Sans MS" size="3">from this TEMPLATE:</font> </p>
<br>
<p style="margin-top: 0; margin-bottom: 0">
<font face="Courier" size="3"><popup class="VEHICLES" shape="poly" coords="[shpxy proj=image buffer=7px]"></font> </p>
<p style="margin-top: 0; margin-bottom: 0">
<font face="Courier" size="3"><title>ID: [veh_id]</title></font> </p>
<p style="margin-top: 0; margin-bottom: 0">
<font face="Courier" size="3"><item title="ESN:"> [esn]</item></font> </p>
<p style="margin-top: 0; margin-bottom: 0">
<font face="Courier" size="3"><item title="TimeStamp:"> [time_idx2]</item></font> </p>
<p style="margin-top: 0; margin-bottom: 0">
<font face="Courier" size="3"><item title="Speed (GPS):"> [calc_speed]</item></font> </p>
<p style="margin-top: 0; margin-bottom: 0">
<font face="Courier" size="3"><item title="Bearing:"> [bearing]</item></font> </p>
<p style="margin-top: 0; margin-bottom: 0">
<font face="Courier" size="3"><item title="Distance this segment:"> [dist]</item></font> </p>
<p style="margin-top: 0; margin-bottom: 0">
<font face="Courier" size="3"><item title="Time interval for this segment:"> [time_interval]</item></font> </p>
<p style="margin-top: 0; margin-bottom: 0">
<font face="Courier" size="3"></popup></font><font face="Comic Sans MS" size="3"></font> </p>
<br>
<p style="margin-top: 0; margin-bottom: 0">
<font face="Comic Sans MS" size="3">I get this as output: </font> </p>
<br>
<pre id="line1"><font face="Courier" size="3"><span><</span><span class="start-tag">imagemap</span><span>><</span><span class="start-tag">name</span><span>>Vehicles</</span><span class="end-tag">name</span><span>><</span><span class="start-tag">style</span><span> </span><span class="attribute-name">name</span><span>="<a class="attribute-value">VEHICLES</a>"><</span><span class="start-tag">title</span><span>><</span><span class="start-tag">attr</span><span> </span><span class="attribute-name">name</span><span>="<a class="attribute-value">background</a>" </span><span class="attribute-name">value</span><span>="<a class="attribute-value">#0A0A0A</a>"/><</span><span class="start-tag">attr</span><span> </span><span class="attribute-name">name</span><span>="<a class="attribute-value">fontWeight</a>" </span><span class="attribute-name">value</span><span>="<a class="attribute-value">bold</a>"/><</span><span class="start-tag">attr</span><span> </span><span class="attribute-name">name</span><span>="<a class="attribute-value">color</a>" </span><span class="attribute-name">value</span><span>="<a class="attribute-value">#FFFFFF</a>"/></</span><span class="end-tag">title</span><span>><</span><span class="start-tag">contents</span><span>><</span><span class="start-tag">attr</span><span> </span><span class="attribute-name">name</span><span>="<a class="attribute-value">background</a>" </span><span class="attribute-name">value</span><span>="<a class="attribute-value">#AFA</a>"/></</span><span class="end-tag">contents</span><span>></</span><span class="end-tag">style</span><span>><</span><span class="start-tag">popup</span><span> </span><span class="attribute-name">class</span><span>="<a class="attribute-value">VEHICLES</a>" </span><span class="attribute-name">shape</span><span>="<a class="attribute-value">poly</a>" </span><span class="attribute-name">coords</span><span>="<a class="attribute-value">368,520 368,519 368,519 368,519 368,518 368,518 368,517 367,517 367,517 367,516 367,516 367,516 366,516 366,515 366,515 366,515 365,515 365,514 365,514 364,514 364,514 364,514 364,513 363,513 363,513 362,513 362,513 362,513 361,513 361,513 361,513 360,513 360,513 360,513 359,513 359,513 358,513 358,514 358,514 357,514 357,514 357,514 357,515 356,515 356,515 356,515 356,516 355,516 355,516 355,517 355,517 355,517 354,517 354,518 354,518 354,519 354,519 354,519 354,520 354,520 354,520 355,539 355,540 355,540 355,540 355,541 355,541 355,542 356,542 356,542 356,543 356,543 356,543 357,543 357,544 357,544 357,544 358,544 358,545 358,545 359,545 359,545 359,545 359,546 360,546 360,546 361,546 361,546 361,546 362,546 362,546 362,546 363,546 363,546 363,546 364,546 364,546 365,546 365,545 365,545 366,545 366,545 366,545 366,544 367,544 367,544 367,544 367,543 368,543 368,543 368,542 368,542 368,542 369,542 369,541 369,541 369,540 369,540 369,540 369,539 369,539 369,539 368,520</a>"><</span><span class="start-tag">title</span><span>>ID: 2153</</span><span class="end-tag">title</span><span>><</span><span class="start-tag">item</span><span> </span><span class="attribute-name">title</span><span>="<a class="attribute-value">ESN:</a>"> 11031823</</span><span class="end-tag">item</span><span>><</span><span class="start-tag">item</span><span> </span><span class="attribute-name">title</span><span>="<a class="attribute-value">TimeStamp:</a>"> 2012-04-24 09:55:31-05</</span><span class="end-tag">item</span><span>><</span><span class="start-tag">item</span><span> </span><span class="attribute-name">title</span><span>="<a class="attribute-value">Speed (GPS):</a>"> 17.9813952124347</</span><span class="end-tag">item</span><span>><</span><span class="start-tag">item</span><span> </span><span class="attribute-name">title</span><span>="<a class="attribute-value">Bearing:</a>"> 356.698784312184</</span><span class="end-tag">item</span><span>><</span><span class="start-tag">item</span><span> </span><span class="attribute-name">title</span><span>="<a class="attribute-value">Distance this segment:</a>"> 474.708833608277</</span><span class="end-tag">item</span><span>><</span><span class="start-tag">item</span><span> </span><span class="attribute-name">title</span><span>="<a class="attribute-value">Time interval for this segment:</a>"> 00:00:18</</span><span class="end-tag">item</span><span>></</span><span class="end-tag">popup</span><span>><</span><span class="start-tag">popup</span><span> </span><span class="attribute-name">class</span><span>="<a class="attribute-value">VEHICLES</a>" </span><span class="attribute-name">shape</span><span>="<a class="attribute-value">poly</a>" </span><span class="attribute-name">coords</span><span>="<a class="attribute-value">368,500 368,500 368,499 368,499 368,499 368,498 368,498 368,497 367,497 367,497 367,496 367,496 367,496 366,496 366,495 366,495 366,495 365,495 365,494 365,494 364,494 364,494 364,494 364,493 363,493 363,493 362,493 362,493 362,493 361,493 361,493 361,493 360,493 360,493 360,493 359,493 359,493 358,493 358,494 358,494 358,494 357,494 357,494 357,495 356,495 356,495 356,495 356,496 355,496 355,496 355,496 355,497 355,497 354,497 354,498 354,498 354,499 354,499 354,499 354,500 354,500 354,520 354,520 354,521 354,521 354,521 354,522 354,522 354,523 355,523 355,523 355,524 355,524 355,524 356,524 356,525 356,525 356,525 357,525 357,526 357,526 358,526 358,526 358,526 358,527 359,527 359,527 360,527 360,527 360,527 361,527 361,527 361,527 362,527 362,527 362,527 363,527 363,527 364,527 364,526 364,526 364,526 365,526 365,526 365,525 366,525 366,525 366,525 366,524 367,524 367,524 367,524 367,523 367,523 368,523 368,522 368,522 368,521 368,521 368,521 368,520 368,520 368,500</a>"><</span><span class="start-tag">title</span><span>>ID: 2153</</span><span class="end-tag">title</span><span>><</span><span class="start-tag">item</span><span> </span><span class="attribute-name">title</span><span>="<a class="attribute-value">ESN:</a>"> 11031823</</span><span class="end-tag">item</span><span>><</span><span class="start-tag">item</span><span> </span><span class="attribute-name">title</span><span>="<a class="attribute-value">TimeStamp:</a>"> 2012-04-24 09:55:50-05</</span><span class="end-tag">item</span><span>><</span><span class="start-tag">item</span><span> </span><span class="attribute-name">title</span><span>="<a class="attribute-value">Speed (GPS):</a>"> 17.0096518596976</</span><span class="end-tag">item</span><span>><</span><span class="start-tag">item</span><span> </span><span class="attribute-name">title</span><span>="<a class="attribute-value">Bearing:</a>"> 359.825436952247</</span><span class="end-tag">item</span><span>><</span><span class="start-tag">item</span><span> </span><span class="attribute-name">title</span><span>="<a class="attribute-value">Distance this segment:</a>"> 474.002298490239</</span><span class="end-tag">item</span><span>><</span><span class="start-tag">item</span><span> </span><span class="attribute-name">title</span><span>="<a class="attribute-value">Time interval for this segment:</a>"> 00:00:19</</span><span class="end-tag">item</span><span>></</span><span class="end-tag">popup</span><span>></</span><span class="end-tag">imagemap</span><span>></span></font><span><font face="Courier"></font><font face="Comic Sans MS">Where the heck are all those COORD values coming from, shouldn't there only be four (4) point pairs per feature (or is it five, repeat last point)?Thanks</font></span><font face="Comic Sans MS" size="3">bobb</font></pre>
<br>
</body>
</html>