[mapserver-users] Dynamic web maps using MS Access

[Stepan Kafka]

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 at email.cz
http://www.bnhelp.cz

 -----Puvodní zpráva-----
Od: owner-mapserver-users at lists.gis.umn.edu
[mailto:owner-mapserver-users at lists.gis.umn.edu]za uživatele Shaun Kolomeitz
Odesláno: 11. ríjna 2002 0:34
Komu: mapserver-users at 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 at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20021011/0b89ede1/attachment.html