Access to Shape File

Completado Publicado Apr 26, 2004 Pagado a la entrega
Completado Pagado a la entrega

The program is supposed to read a MS Access table and convert it to a so-called shape file (description below). Access to the MS Access table is shared with another program, which continuously (every five minutes or so) adds a record to the table. The commissioned program needs to run contiously, "listening" to whether the MS Access table has been updated and then update its own shape file, which in turn is read by a third program.

The MS Access table consists of 29 fields, three of which have special importance. The x- and y-fields contain geographic coordinates, which play a crucial role in the shape file output. Then there is a field with data and time in string format, which needs to be reformatted to reflect the MS Windows date/time format on the host machine.

Now to the shape file itself. This is a proprietary but open format for geographic data, developed by a company called ESRI. In the attached files, you find a complete specification of the format. However, rather than writing an export module from scratch, you might want to use some of the public domain VisualBasic code samples that I attached as well. Shape files are actually a group of files that belong together. One is a binary file describing geometries (the x-, y-coordinates referred to above), another is a traditional dBase IV file containing all the other 27 fields of the original MS Access table. Then there are index files adhering to the same logic as dBase index files.

## Deliverables

Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

## Platform

The program is supposed to run on a Windows 2000 machine (which may be upgraded to XP soon, so XP compatibility is essential). One of the caveats is that both the input and the output files are shared with other programs. Also, if the machine fails, all programs have to be restarted manually. Your program then needs to re-parse the whole MS Access table (in case new records have arrived during downtime) and to write a new copy of the complete shape file. While I would like to keep the names of the MS Access table and resulting shape file constant, I would also like to play it safe and give the user the opportunity to set path and name of input and output files. The program should therefore display a small screen with two editable 'source' and 'target' lines and some indicator lights that say 'listening', 'synchronizing', 'problem reading', and 'problem writing'.

PHP

Nº del proyecto: #3188917

Sobre el proyecto

4 propuestas Proyecto remoto Activo Apr 29, 2004

Adjudicado a:

sandycreekc

See private message.

$85 USD en 10 días
(1 comentario)
1.9

4 freelancers están ofertando un promedio de $83 por este trabajo

keneto

See private message.

$85 USD en 10 días
(22 comentarios)
4.3
leadervw

See private message.

$76.5 USD en 10 días
(13 comentarios)
1.7
cppbobvw

See private message.

$85 USD en 10 días
(0 comentarios)
0.0