Home
The Legacy and Technical Architecture of Microsoft TerraServer
Microsoft TerraServer was a pioneering web-based spatial database service launched in 1998 that revolutionized the way the general public accessed geographical imagery. Historically hosted at terraserver.microsoft.com, it represented one of the most significant demonstrations of large-scale database scalability in the early internet era. Created by Microsoft Research, the project served as the world's first massive online atlas, offering high-resolution aerial and satellite imagery years before the advent of Google Earth or Bing Maps.
As of March 2016, Microsoft Research Maps (the final iteration of TerraServer) was permanently shut down. However, its technical contributions—particularly in the realm of image tiling and spatial data warehousing—remain the foundational standards for modern web mapping applications.
What was Microsoft TerraServer?
TerraServer was originally conceived as a joint research project between Microsoft, the United States Geological Survey (USGS), and various commercial imagery providers like Aerial Images (later Sovereign). Its primary purpose was not merely to provide a public map, but to act as a "proof of concept" for Microsoft’s enterprise software stack.
In the late 1990s, the tech industry was skeptical about whether relational databases could handle petabyte-scale or even terabyte-scale multimedia data. Microsoft launched TerraServer to prove that Windows NT Server and SQL Server could scale to meet the demands of the world's largest and most complex data sets. At its peak, it was recognized by the Guinness World Records as the largest database on the internet, housing over 5 terabytes of compressed imagery data.
The Technological Infrastructure of 1998
To appreciate the scale of TerraServer, one must understand the computing landscape of 1998. At a time when home computers were typically equipped with 2GB to 4GB hard drives and internet access was largely restricted to 28.8 or 56 kbps dial-up modems, building a 5TB online image repository was an engineering feat of immense proportions.
Hardware Configuration and Scalability
The physical infrastructure of TerraServer was a testament to late-90s enterprise power. The system was housed in eight large cabinets. According to technical reports from Microsoft Research (MSR-TR-98-17), the primary compute node was a Compaq AlphaServer 8400. This machine was equipped with:
- Processors: Eight high-performance Alpha CPUs.
- Memory: Multiple gigabytes of RAM, which was extraordinary for the era.
- Storage: A StorageWorks array consisting of 324 individual disks.
- Configuration: The storage was organized into RAID 5 sets, providing approximately 2.3 terabytes of usable, fault-tolerant space from nearly 3 terabytes of raw disk.
This hardware was designed to handle thousands of simultaneous users browsing the web via standard protocols. The use of Alpha architecture, which was later acquired by Compaq and eventually HP, provided the 64-bit processing power necessary to index billions of rows in a SQL database.
Software Stack and the SQL Breakthrough
The software heart of TerraServer was Microsoft SQL Server. Before TerraServer, most large-scale image repositories relied on specialized file systems or object-oriented databases. Microsoft’s goal was to show that a "general-purpose" relational database could manage spatial data just as effectively.
The database design departed from traditional data warehousing in three key ways:
- Concurrency: It was designed for millions of public users rather than a few hundred corporate analysts.
- Access Patterns: Users typically extracted only a few records (tiles) per session.
- Record Size: Unlike classic numeric records of less than 1KB, TerraServer records were relatively large image blobs (approximately 10KB each).
The metadata and the actual image bytes were both stored within the SQL database. This allowed the system to utilize SQL Server's robust backup, restore, and indexing capabilities for the entire dataset, rather than managing a fragmented collection of files on a disk.
How TerraServer Pioneered Image Tiling
Perhaps the most lasting legacy of TerraServer is the concept of "tiling." If you use Google Maps or any modern mobile navigation app today, you are interacting with a system that owes its logic to the TerraServer architecture.
Converting Internet-Unfriendly Data
Geospatial imagery, particularly from the USGS, was originally stored in massive files known as Digital Ortho Quadrangles (DOQ). These files were "internet-unfriendly"—they were too large to be downloaded over a 28.8 kbps connection and required specialized software to view.
The Microsoft team developed a process to "scrub" and "tile" this data. They divided the massive images into millions of small, 200x200 pixel JPEG or GIF tiles. Each tile represented a specific geographic area at a specific resolution.
Spatial Indexing and the Gazetteer
To make the data searchable, the team built a "Gazetteer"—a database of place names, coordinates, and landmarks. When a user searched for "San Francisco," the system would:
- Look up the latitude and longitude in the Gazetteer.
- Translate those coordinates into the Universal Transverse Mercator (UTM) projection system.
- Query the SQL database for the specific tile IDs associated with those coordinates.
- Deliver the small image tiles to the web browser to be reassembled on the user's screen.
This "tile server" approach ensured that the user only downloaded the exact pixels they were viewing, making the experience fluid even on slow connections.
The Data: USGS and the Cold War Thaw
The content of TerraServer was as revolutionary as its technology. It provided the first free public access to high-resolution satellite and aerial imagery.
USGS Digital Ortho Quadrangles (DOQ)
The majority of the US coverage came from the USGS. These were grayscale, 1-meter resolution aerial photos. At this resolution, individual cars could be seen on streets, though it was not detailed enough to identify individuals. This level of transparency was unprecedented for the general public in the 1990s.
The Russian Connection: SPIN-2
One of the most fascinating aspects of TerraServer was its inclusion of Russian satellite data. Following the end of the Cold War, regulations regarding high-resolution imagery were relaxed. Microsoft partnered with Sovinformsputnik to resample declassified Russian military satellite imagery (SPIN-2) into 1.56-meter resolution tiles. This allowed users in the West to view imagery of major world cities that had previously been state secrets.
Evolution and Name Changes: The Path to MSR Maps
The history of the service is often clouded by a split that occurred in 2000.
TerraServer vs. TerraServer.com
In 2000, Microsoft and its partner, Aerial Images, went in different directions. Aerial Images retained the domain name "TerraServer.com" for their commercial business, focusing on selling high-resolution imagery. Microsoft moved its research project to a new domain, eventually known as TerraServer-USA.
To avoid consumer confusion, Microsoft eventually rebranded its service to Microsoft Research Maps (MSR Maps). While the commercial TerraServer.com continued to operate as a business, the Microsoft-hosted version remained a free public resource for educational and research purposes.
Integration with Other Microsoft Technologies
TerraServer wasn't an island; it was integrated into other Microsoft products. It provided the imagery backend for early versions of Encarta (Microsoft’s digital encyclopedia) and laid the groundwork for the eventual launch of Virtual Earth, which later became Bing Maps.
Why did terraserver.microsoft.com shut down?
By the mid-2010s, the world had moved far beyond the original vision of TerraServer. Several factors led to its retirement in March 2016:
- Technological Obsolescence: The original code base, written for Windows NT and early SQL Server versions, was difficult to maintain in a cloud-centric world.
- Modern Competitors: Google Maps and Google Earth, launched in 2005, offered color imagery, 3D terrain, and a vastly superior user experience. TerraServer’s grayscale USGS maps looked antiquated by comparison.
- The Rise of Bing Maps: Microsoft had already launched Bing Maps (formerly Virtual Earth) as a consumer-facing product. Maintaining a separate, research-heavy map service became redundant.
- Resource Allocation: Microsoft Research shifted its focus toward artificial intelligence, machine learning, and quantum computing, moving away from the "Spatial Data Warehouse" experiments of the late 90s.
The Enduring Legacy of the Project
Though the servers are no longer humming, the impact of Microsoft TerraServer is visible in almost every digital map we use today.
The "Golden Standard" for Web Mapping
TerraServer proved that the web browser could be a viable platform for complex geospatial presentation. It established the "Tile-Pan-Zoom" interaction model that is now universal. Before TerraServer, digital mapping was the domain of specialists using expensive GIS software. After TerraServer, mapping became a utility for the masses.
Database Architecture
The project demonstrated that relational databases (RDBMS) could store and serve blobs of binary data at scale. This paved the way for modern cloud databases that handle everything from photos on social media to massive streaming video libraries.
Open Data Advocacy
By providing free access to USGS data, TerraServer helped foster a culture of open geographic data. It showed government agencies the value of making public-domain imagery easily accessible to the tax-paying public, a trend that continues today with initiatives like OpenStreetMap and NASA's Worldview.
Frequently Asked Questions (FAQ)
Can I still access images from terraserver.microsoft.com?
No, the service was officially discontinued in March 2016. The original website no longer serves map data. Users seeking similar imagery should use Bing Maps, Google Earth, or the USGS EarthExplorer.
Is TerraServer.com the same as Microsoft TerraServer?
No. While they shared a common origin, TerraServer.com is a separate commercial entity that sells satellite imagery. Microsoft's project was a research endeavor that later became MSR Maps.
What happened to the 5 terabytes of data?
Most of the data used by TerraServer was sourced from the public domain (USGS). While the TerraServer database itself is offline, the source imagery remains available through various government archives and modern mapping platforms.
Did TerraServer influence Google Earth?
Yes, indirectly. TerraServer pioneered the server-side tiling and database indexing techniques that later companies like Keyhole (which Google acquired to create Google Earth) refined and expanded with 3D capabilities.
Summary
Microsoft TerraServer was a landmark achievement in the history of the internet. By successfully managing what was then the world's largest database and serving it to millions of users via slow dial-up connections, Jim Gray and his team at Microsoft Research proved the scalability of the Windows software stack. While it eventually succumbed to the rapid pace of technological innovation, its "tiling" architecture remains the silent engine behind every GPS device and map application in use today. It was the first project to truly put "the world at your fingertips," transforming the earth's surface into a searchable, navigable digital archive.
-
Topic: The Microsoft TerraServer™https://www.ics.uci.edu/~wscacchi/DBM-EC/Course/TerraServer-98.pdf
-
Topic: Microsoft TerraServer: A Spatial Data Warehousehttps://ptabdata.blob.core.windows.net/files/2017/IPR2017-01616/v26_Ex1032%20-%20Barclay,%20Tom,%20et%20al.%20Microsoft%20TerraServer%20A%20Spatial%20Data%20Warehouse.PDF
-
Topic: Microsoft TerraServer: A Spatial Data Warehousehttps://archive.org/download/acm-digital-library-2020_20200719/fulltext/278.zip/10.1145%2F342009.335424.pdf