[mapserver-users] Dynamic web maps using MS Access
Stepan Kafka
stepan.kafka@centrum.cz
Fri, 11 Oct 2002 10:04:39 +0200
This is a multi-part message in MIME format.
------=_NextPart_000_000E_01C2710D.9C8A0640
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
Hi Shaun,
there is not direct support for MS Access data in MS as I know. But you
may use mapscript to build application showing your data on the map. We use
this approach for points of interest stored in MySQL database at this site:
http://www.kutnahora.info. You can find also Perl example at MapServer test
suite http://maps.dnr.state.mn.us/mapserver_demos/tests/ - see live
earthquake mapping.
Stepan Kafka
Help Service Remote Sensing
tel: +420-327514118
mailto:kafka@email.cz
http://www.bnhelp.cz
-----Puvodní zpráva-----
Od: owner-mapserver-users@lists.gis.umn.edu
[mailto:owner-mapserver-users@lists.gis.umn.edu]za uživatele Shaun Kolomeitz
Odesláno: 11. ríjna 2002 0:34
Komu: mapserver-users@lists.gis.umn.edu
Predmet: [mapserver-users] Dynamic web maps using MS Access
Dear mapserver-users,
I have a mate who is interested in using mapserver to display a dynamic
(regularly updated) Access database.
We are only talking up to about 10 000 records so I thought he could do
something like -
1. Get Access to regularly write the tabular info out to a text file
(either as records are updated or at regular intervals)
2. Get a cron job to translate the text file to a shapefile and index it
3. My guess is that mapserver would then read the new data provided it
wasn't already involved in reading the file/indexes.
My concern is that using this approach there is a potential for file
contention/locking to stuff things up.
Is there a simpler approach that someone else can think of for using
dynamic data from Access to display using mapserver ?
(and yes I already asked whether he could drop Access and do it all in
mapserver - no go unfortunately).
I've searched the archives but there are no examples / suggestions for
dynamic mapping from MS Access (personally I'd rather use MySQL or POSTGIS).
TIA,
Shaun Kolomeitz
eBusiness Manager, Toowoomba City Council
Phone: 07 4688 6863
Mail to:S.Kolomeitz@toowoomba.qld.gov.au
-----------------------------------------------------------
This email message (and any accompanying file attachments) may contain
confidential or privileged information and is intended for the sole use of
the addressee(s) named above. If you are not the intended recipient, or the
person responsible for delivering this message to the intended recipient,
please notify Toowoomba City Council immediately and destroy any copies of
the original message. Any unauthorised review, use, alteration, disclosure
or distribution of this email (including any attachments) by an unintended
recipient is prohibited. While all care is taken, Council cannot guarantee
that this email message (and any accompanying file attachments) are free of
viruses. The Council accepts no responsibility for the content of any email
which is sent by an employee which is of a personal nature or which
represents the personal view of the sender.
------=_NextPart_000_000E_01C2710D.9C8A0640
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2600.0" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D555123907-11102002><FONT face=3DArial color=3D#0000ff =
size=3D2>Hi=20
Shaun,</FONT></SPAN></DIV>
<DIV><SPAN class=3D555123907-11102002><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D555123907-11102002><FONT face=3DArial color=3D#0000ff =
size=3D2> there is not direct support for MS Access =
data in MS=20
as I know. But you may use mapscript to build application showing =
your data=20
on the map. We use this approach for points of interest stored =
in=20
MySQL database at this site: <A=20
href=3D"http://www.kutnahora.info">http://www.kutnahora.info</A>. You =
can find=20
also Perl example at MapServer test suite <A=20
href=3D"http://maps.dnr.state.mn.us/mapserver_demos/tests/">http://maps.d=
nr.state.mn.us/mapserver_demos/tests/</A> -=20
see live earthquake mapping.</FONT></SPAN></DIV>
<DIV><SPAN class=3D555123907-11102002><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D555123907-11102002><FONT face=3DArial color=3D#0000ff =
size=3D2>Stepan=20
Kafka</FONT></SPAN><FONT face=3D"Times New Roman"><FONT size=3D2><SPAN=20
class=3D555123907-11102002><FONT face=3DArial color=3D#0000ff><FONT =
size=3D2><BR>Help=20
Service Remote Sensing<BR>tel: +420-327514118<BR><A =
href=3D"mailto:kafka@email.cz"=20
target=3D_blank>mailto:kafka@email.cz</A><BR><A =
href=3D"http://www.bnhelp.cz"=20
target=3D_blank>http://www.bnhelp.cz</A> =
</FONT></FONT></SPAN></FONT></FONT></DIV>
<DIV><FONT face=3D"Times New Roman"><FONT size=3D2><SPAN=20
class=3D555123907-11102002><FONT face=3DArial=20
color=3D#0000ff> </DIV></FONT></SPAN></FONT></FONT>
<DIV><FONT face=3D"Times New Roman"><FONT size=3D2><SPAN=20
class=3D555123907-11102002> </SPAN>-----Původn=ED =
zpr=E1va-----<BR><B>Od:</B>=20
owner-mapserver-users@lists.gis.umn.edu=20
[mailto:owner-mapserver-users@lists.gis.umn.edu]<B>za u=9Eivatele</B> =
Shaun=20
Kolomeitz<BR><B>Odesl=E1no:</B> 11. ř=EDjna 2002 =
0:34<BR><B>Komu:</B>=20
mapserver-users@lists.gis.umn.edu<BR><B>Předmět:</B> =
[mapserver-users] Dynamic=20
web maps using MS Access<BR><BR></DIV></FONT></FONT>
<BLOCKQUOTE=20
style=3D"PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px =
solid"><FONT=20
face=3DArial color=3D#0000ff size=3D2></FONT><BR><FONT =
face=3Dsans-serif size=3D2>Dear=20
mapserver-users,</FONT> <BR><BR><FONT face=3Dsans-serif size=3D2>I =
have a mate who=20
is interested in using mapserver to display a dynamic (regularly =
updated)=20
Access database.</FONT> <BR><BR><FONT face=3Dsans-serif size=3D2>We =
are only=20
talking up to about 10 000 records so I thought he could do something =
like=20
-</FONT> <BR><FONT face=3Dsans-serif size=3D2>1. Get Access to =
regularly write the=20
tabular info out to a text file (either as records are updated or at =
regular=20
intervals)</FONT> <BR><FONT face=3Dsans-serif size=3D2>2. Get a cron =
job to=20
translate the text file to a shapefile and index it</FONT> <BR><FONT=20
face=3Dsans-serif size=3D2>3. My guess is that mapserver would then =
read the new=20
data provided it wasn't already involved in reading the =
file/indexes.</FONT>=20
<BR><FONT face=3Dsans-serif size=3D2>My concern is that using this =
approach there=20
is a potential for file contention/locking to stuff things up.</FONT>=20
<BR><BR><FONT face=3Dsans-serif size=3D2>Is there a simpler approach =
that someone=20
else can think of for using dynamic data from Access to display using=20
mapserver ?</FONT> <BR><FONT face=3Dsans-serif size=3D2>(and yes I =
already asked=20
whether he could drop Access and do it all in mapserver - no go=20
unfortunately).</FONT> <BR><BR><FONT face=3Dsans-serif size=3D2>I've =
searched the=20
archives but there are no examples / suggestions for dynamic mapping =
from MS=20
Access (personally I'd rather use MySQL or POSTGIS).</FONT> =
<BR><BR><FONT=20
face=3Dsans-serif size=3D2>TIA,<BR>Shaun Kolomeitz<BR><BR>eBusiness =
Manager,=20
Toowoomba City Council<BR>Phone: 07 4688 6863<BR>Mail=20
=
to:S.Kolomeitz@toowoomba.qld.gov.au<BR>----------------------------------=
-------------------------<BR>This=20
email message (and any accompanying file attachments) may contain =
confidential=20
or privileged information and is intended for the sole use of the =
addressee(s)=20
named above. If you are not the intended recipient, or the =
person=20
responsible for delivering this message to the intended recipient, =
please=20
notify Toowoomba City Council immediately and destroy any copies of =
the=20
original message. Any unauthorised review, use, alteration, =
disclosure=20
or distribution of this email (including any attachments) by an =
unintended=20
recipient is prohibited. While all care is taken, Council cannot =
guarantee that this email message (and any accompanying file =
attachments) are=20
free of viruses. The Council accepts no responsibility for the =
content=20
of any email which is sent by an employee which is of a personal =
nature or=20
which represents the personal view of the sender.=20
</FONT></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_000E_01C2710D.9C8A0640--