Visited Germany’s first Spatial Database, Size 26 kiloStones

Last week, I had the chance to visit Bavaria’s (and so also Germany’s) oldest Spatial Database. It’s buried deep below Munich, and contains all the geo information about Bavaria in scale 1:5000 and some in 1:2500. It was introduced in 1808 and was in use until 1950. That’s also the current state of the data.

Each of the 26,000 official maps is painted in oil and mirror-invertedly on polished lime sand brick. Each “page” is 1m x 1m (3.2ft x 3.2ft) in size, 4-6cm (2-3in) thick and the weight of each stone “disk” is approximately 70kg (154lbs). That makes it 26 Kilostones in size, with a dump size of 1,820,000 kg or 3,968,000 lbs.

They were the master “files” for a lithography process, which was the standard for master map reprinting over one and a half century.

I hope you are more grateful in future, when you do your next database export and complain that you have to bring it over to the other DBA team on a jump drive. It could have been a column of trucks …

LithographieKataster1

The Tablespace

 

LithographieKataster2

Block headers

LithographieKataster3

Raw Data

 

LithographieKataster4

Block Dump

Haul on
Martin Klier




You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “Visited Germany’s first Spatial Database, Size 26 kiloStones”

  1. JOSE ANTONIO Says:

    Hi

    We are working with Tibco EMS configured databases and gives the following error:
    ERROR: Failed to refresh lock for store ‘$ sys.meta’ [errstr = com.tibco.tibems.tibemsd.internal.db.EMSDataStoreLockException: Can not refresh WHEN NOT locked]
    The server also secuandario the error occurred:
    Failed to refresh lock for store ‘$ sys.meta’ [errstr = com.tibco.tibems.tibemsd.internal.db.EMSDataStoreLockException: Can not refresh WHEN NOT locked]

    Can you tell us why this problem happens?.

    Gracias

Leave a Reply