<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:st1="urn:schemas-microsoft-com:office:smarttags" 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 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="City"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="Street"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="address"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>PostGIS is a spatial extension for
PostgreSQL (<a href="http://www.postgresql.org/">http://www.postgresql.org</a>)
rather than MS-SQL Server. I’d suggest you need to ask on either an
MS-SQL or an ASP/Javascript coding site for help, but without more information
it’s impossible to determine exactly what the problem you’re
experiencing is.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Kind regards,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Mark.<o:p></o:p></span></font></p>
<div>
<p><font size=2 color=navy face="Times New Roman"><span style='font-size:10.0pt;
color:navy'>------------------------<br>
WebBased Ltd<br>
<st1:Street w:st="on"><st1:address w:st="on">17 Research Way</st1:address></st1:Street><br>
<st1:place w:st="on"><st1:City w:st="on">Plymouth</st1:City></st1:place><br>
PL6 8BT<br>
<br>
T: +44 (0)1752 797131<br>
F: +44 (0)1752 791023<br>
<br>
<a href="http://www.webbased.co.uk">http://www.webbased.co.uk</a> <br>
<a href="http://www.infomapper.com">http://www.infomapper.com</a><br>
<a href="http://www.swtc.co.uk">http://www.swtc.co.uk</a> <br>
<br>
This email and any attachments are confidential to the intended recipient and
may also be privileged. If you are not the intended recipient please delete it
from your system and notify the sender. You should not copy it or use it for
any purpose nor disclose or distribute its contents to any other person.</span></font><o:p></o:p></p>
</div>
<div style='border:none;border-left:solid blue 1.5pt;padding:0cm 0cm 0cm 4.0pt'>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <b><span
style='font-weight:bold'>On Behalf Of </span></b>simflex<br>
<b><span style='font-weight:bold'>Sent:</span></b> 25 May 2006 14:16<br>
<b><span style='font-weight:bold'>To:</span></b>
postgis-users@postgis.refractions.net<br>
<b><span style='font-weight:bold'>Subject:</span></b> [postgis-users]
displaying a specific extent of the map</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>Greetings
all,<br>
<br>
First time user of this forum.<br>
<br>
We use a sql server db to store data including x, y values. and using ASP on
the front end to retrieve data<br>
<br>
Currently, we are do have a summary report laid out thus:<br>
<br>
incident id first name last name
incident type, incident location<br>
<br>
1
John
Doe
vehicular amber street<br>
...<br>
...<br>
<br>
Our issue arises because we want to be able to click on incident id to zoom
directly to the extent of the map where the incident occurred.<br>
<br>
so far, we are struggling with this. any ideas would greatly appreciated.<br>
<br>
Here is what we have got so far:<br>
<br>
<br>
<script><br>
function zoomToExt ent(box) {<br>
box_array = box.split(" ");<br>
minx = box_array[0]*1;<br>
miny = box_array[1]*1;<br>
maxx = box_array[2]*1;<br>
maxy = box_array[3]*1;<br>
width = (maxx - minx) + 200;<br>
height = maxy - miny;<br>
centerx = minx + (width / 2.0);<br>
centery = miny + (height / 2.0);<br>
lonlatPt = map.mcsToLonLat(centerx, centery);<br>
lon = lonlatPt.getX();<br>
lat = lonlatPt.getY();<br>
map.zoomWidth(lat, lon, width, 'FT');<br>
}<br>
</script><br>
<%<o:p></o:p></span></font></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>Set
cn=Server.CreateObject("ADODB.Connection")<br>
nID = Request("RecordID")<br>
'response.write nID<br>
'response.end<o:p></o:p></span></font></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>cn.Open
"Driver={SQL Server};" & _<br>
"Server=haoi;" & _<br>
"Address=haoi,1433;"
& _<br>
"Network=DBMSSOCN;" & _<br>
"Database=incidentsDB;" & _<br>
"Uid=sa;" & _<br>
"Pwd="<o:p></o:p></span></font></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>SQL =
"select incident_LOC, id,minlat,minlon,maxlat,maxlon from Incidents where
id =" & nID<br>
Set rs = cn.Execute( SQL )<br>
'response.write SQL<br>
'response.end<br>
%><br>
<div align="center"><br>
<table><br>
<%<br>
cnt = 0<br>
Do Until cur.EOF<br>
cnt = cnt + 1<br>
incidentlocation = cur(0).Value<br>
recnum = CLng(cur(1).Value)<br>
ileft = CLng(cur(2).value) - 250<br>
ibottom = CLng(cur(3).Value) - 250<br>
iright = CLng(cur(4).Value) + 250<br>
itop = CLng(cur(5).Value) + 250<o:p></o:p></span></font></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>
; tan = ileft & " " & ibottom & " " &
iright & " " & itop<o:p></o:p></span></font></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>%>
<tr><br>
<td><br>
<a href="#" onClick="zoomToExtent('<%=tan%>');return
false;"><br>
<font size="-1"><%=incidentlocation%></font><br>
</a><br>
</td><br>
</tr><br>
<%<br>
cur.MoveNext<br>
<st1:place w:st="on">Loop</st1:place><br>
%><br>
</table><br>
<%<br>
if cnt = 0 Then<br>
%><br>
<Center><B>No results</center><br>
<%<br>
End If<br>
rs.Close()<br>
cn.Close()<br>
%><o:p></o:p></span></font></p>
</div>
</div>
</body>
</html>