Map database

  • Thread starter Thread starter Dean
  • Start date Start date
D

Dean

Is it possible or feasable to scan maps and have each page as a seperate
page/form in a db, be able to put some place names etc. as referance points
and have a search facility to find them.

I have copied a map and OLE, pasted and linked in onto a form some the size
of the file is horendous. If I have the size of the map set to STRETCH it's
too small to be able to see then CROP I can't move around to see the bits
that are off the page!!

Does anyone know of a program that already exists to do this sort of thing
or is it possable in Access and what sort of knowledge would I need to be
able to do it?

All and any helpful replies would be appreciated.

Regards Dean
(e-mail address removed)

www.dkso.co.uk/

http://homepage.ntlworld.com/dkso
 
---------- "Dean said:
Is it possible or feasable to scan maps and have each page as a seperate
page/form in a db, be able to put some place names etc. as referance points
and have a search facility to find them.

I have copied a map and OLE, pasted and linked in onto a form some the size
of the file is horendous. If I have the size of the map set to STRETCH it's
too small to be able to see then CROP I can't move around to see the bits
that are off the page!!
Click to expand...

Dean,

this is theoretically possible, but basically it is not recommended to
store images in a DB. A much better solution is to store the path
+file name as a hyperlink. To make this user friendly, you could have
a button to open the standard Windows File open dialog in order to
search and select the image file.

For place names and reference points you could have a table related to
the main table in a many-to-1 relation (1 record main table containing
the map path would 'own' several records with place names).
Does anyone know of a program that already exists to do this sort of thing
or is it possable in Access and what sort of knowledge would I need to be
able to do it?
Click to expand...

I'd guess you don't want to reinvent a wheel called navigation system
:-)

Depending on what is the purpose of your DB, look for keyword GIS
(Geographical Information System). I don't know details, but there are
all kinds of variations for this. They are systems specifically
designd to store and handle for ex coordinates, with features like
zooming.

Best regards
Emilia

Emilia Maxim
PC-SoftwareService, Stuttgart
http://www.maxim-software-service.de
 
What you are describing is a GIS (graphical information system) program.
This has a user interface where you can include a map and a database style
table to keep track of the points you specify on the map. You can do
searches and other query type of procedures on the data. Just do a search
in Google for GIS.

Also, Excel has a mapping feature. It takes data you put in excel then
instead of making a chart, it shows a map and adds your data to the map. It
might be possible to do what you want using this feature.

Kelvin
 
Plenty of dedicated programs to do this already. For home use, there are
Fugawi and Oziexplorer, to name just two. Oziexplorer is my favourite. See
http://www.oziexplorer.com

Almost all hold the maps as separate image files, due to the problems of
storing large images within the db itself.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
Thanks to you all. Very useful info and very much appreciated.
I'll certanly look into the suggested programs.

Thanks again
Dean
 
Back
Top