[Mapserver-users] Update shape file on-the-fly

Tue Jan 13 06:35:10 PST 2004

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C3D9E2.72AA1010
Content-Type: text/plain;
	charset="iso-8859-1"

Hi,
my application using MS SQL-Server as DBMS for the data.
In a table 'tbl_Plants' I'm storing the XY coordinate of my entity that are
Radio/TV emitter (points).

Usually my local application export the data in .txt file and ArcView import
the text file and create the Events Layer to display the georeferenced
features.

Now I'm starting to develop intranet application to manage the data with ASP
pages, and represented the data with MapServer.
Just for the sample, I've create the static shape file of the DB entity
using ArcView.
Using MAP mode for MapServer in <img... > tag I can show the correct map and
point in the right position.
For the background I'm using TIFF raster layers.

NOW, when the application change the entity coordinate via ASP page, but now
the DB and the shape file ARE NOT linked and the shape file report the old
position of the entity.

This will be a distributed application an the remote user must be-able to
change the entity coordinate and see the new position immediately.

Q.:
How can I update the shape file on-the-fly without use manually ArcView to
regenerate the correct shape file?

Dott. Davide Prati 
A.R.P.A. della Lombardia 
Dipartimento di Varese 
Via Campigli, 5 
21100 - VARESE 
Tel. 0332-327705 
Fax 0332-313161 

------_=_NextPart_001_01C3D9E2.72AA1010
Content-Type: text/html;
	charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">

<META content="MSHTML 5.00.3700.6699" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2><SPAN 
class=093530514-13012004>Hi,</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=093530514-13012004>my application using 
MS SQL-Server as DBMS for the data.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=093530514-13012004>In a table 
'tbl_Plants' I'm storing the XY coordinate of my entity that are Radio/TV 
emitter (points).</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN 
class=093530514-13012004></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=093530514-13012004>Usually my local 
application export the data in .txt file and ArcView import the text file and 
create the Events Layer to display the georeferenced 
features.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN 
class=093530514-13012004></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=093530514-13012004>Now I'm starting 
to develop intranet application to manage the data with ASP pages, and 
represented the data with MapServer.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=093530514-13012004>Just for the 
sample, I've create the static shape file of the DB entity using 
ArcView.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=093530514-13012004>Using MAP mode for 
MapServer in <img... > tag I can show the correct map and point in 
the right position.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=093530514-13012004>For the background 
I'm using TIFF raster layers.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN 
class=093530514-13012004></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=093530514-13012004>NOW, when the 
application change the entity coordinate via ASP page, but now the DB and the 
shape file ARE NOT linked and the shape file report the old position of the 
entity.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN 
class=093530514-13012004></SPAN></FONT> </DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=093530514-13012004>This will be a 
distributed application an the remote user must be-able to change the entity 
coordinate and see the new position immediately.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN 
class=093530514-13012004></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN 
class=093530514-13012004>Q.:</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=093530514-13012004>How can I update the 
shape file on-the-fly without use manually ArcView to regenerate the 
correct shape file?</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN 
class=093530514-13012004></SPAN></FONT> </DIV>
<DIV> </DIV>
<P><B><FONT face="Comic Sans MS" size=2>Dott. Davide Prati</FONT></B> <BR><FONT 
face="Comic Sans MS" size=1>A.R.P.A. della Lombardia</FONT> <BR><FONT 
face="Comic Sans MS" size=1>Dipartimento di Varese</FONT> <BR><FONT 
face="Comic Sans MS" size=1>Via Campigli, 5</FONT> <BR><FONT 
face="Comic Sans MS" size=1>21100 - VARESE</FONT> <BR><FONT face="Comic Sans MS" 
size=1>Tel. 0332-327705</FONT> <BR><FONT face="Comic Sans MS" size=1>Fax 
0332-313161</FONT> </P>
<DIV> </DIV></BODY></HTML>

------_=_NextPart_001_01C3D9E2.72AA1010--