global latatude/longitude 2

[SamP]

I have a requirement to create/load an 8i NT DB with the geographical location of every point on earth. <br>
Sounds more dramatic than it is. Degrees, minutes, and seconds are what I have to store. All data is on <br>
CD in ASCII format. I need to figure out how to design the tables & import the data. Will be used for <br>
very heavy OLTP application. Any conceptual or design ideas/experience would be very helpful.

 

[carp]

SamP -<br>
You might want to investigate Oracle's Spatial Data option. I don't know too much about it, but I DO know it was designed precisely for this kind of situation. My understanding is it allows you to do things like store latitude, longitude, and elevation as one piece of data.

 

[rick24]

Where can I go on the

http://www to

give them an address and they would give me the latatude/longitude for that address. Then I could pull up a pix of say address. Any information as to where I could find this service? Thanks Rick Fields

 

[listener22]

ms used to have something similar to demo its ability(?)
to handle databases of terrabyte sizes.
try

http://www.terraserver.microsoft.com

or search for microsoft terrabyte demo/project. Jim

oracle, vb

 

[RobertSBoyle]

Hi SamP, it really depends on what you want to do with the data once you have loaded it. We use spatial data without using the spatial option supplied with ORACLE. The spatial option can be useful, but the time and training that may be involved might not be worthwhile depending on what you want to do.

Cheers
Robert