Adding PostGIS to the PostgreSQL Server

With PostgreSQL 9.3 Database Server now running on my Ubuntu machine, the final things to do for now is to make the PostGIS Extensions available.

PostGIS is a layer, or more precisely: an extension, that adds geospatial capabilities to PostgreSQL. The installation is actually easy – if you have followed the appropriate steps in the previous post, you only need to issue one line:

sudo apt-get install postgresql-9.3-postgis

And that is it…let it run, then – just to be on the safe side – reboot the system.

Creating the Database

So far, we have been dealing with the Database Server, the backbone so to speak. With all bits and pieces in place now, it is time to create the actual database.

A first set of tables is dealing with Airfields – eventually, it will hold a list of historic airfields. So creating the database is easy – the standard SQL Command is

CREATE DATABASE [DatabaseName];

which, of course, can be extended by several parameters. This creates a database in any SQL-based RDBMS – but it does not make it “spatial”. With PostGIS installed, you can now connect to the database and issue the following SQL command:

CREATE EXTENSION postgis;

That makes the database “spatial”. Want to see? Take a look at the table definition below and note the “Coordinates” column definition – it says “geometry(Point, 4326)“.

01 - AIRFIRLDS Table“Geometry” is a spatial data type – I am not going to dig into the details now – let’s just stick to the fact that this spatial data type is what we have installed PostGIS for.

Converting the Coordinates

Remember my “Airfields” table – I have actually filled it (with a SQL Script, not manually) and it now contains round about 4000 records of European Airfields. The data contains information such as the Name of the airfield, the country, the type and – of course – longitude and latitude.

03 - Imported DataBut one thing easily forgotten is that longitude and latitude are just numbers – in the “spatial” world, they mean nothing. So one things that needs to be done is to create a “spatial” value that applications such as QGIS can work with. This value will be stored in the Coordinates column. The SQL Statement to perform the transformation is – at best – something to get used to, certainly something to nor forget (or your data will not be displayed).

UPDATE "Airfields" SET "Coordinates" = ST_SetSRID(ST_MakePoint("Longitude","Latitude"),4326);

What this does it to update the table “Airfields” and calculate the value for “Coordinates” using the values from “Longitude” and “Latitude“. Running the SQL Statement against the table produces the “spatial” values.

04 - Coordinates convertedMapping the Data – QGIS

Having data in a spatial database is one thing – the ability to do something with it is a completely other thing. One of the best – free! – GIS Programs I have come across is Quantum GIS – or short: QGIS.

02 - QGIS Splash Screen

In QGIS, it is quite easy to make use of the spatial data – two things I do:

  1. Register a plugin that provides me with access to Google Maps data (and other sources)
  2. Create a PostGIS Layer, pointing to my database table (or rather a view I have created from the table).

The result? Quite impressive, I would say – spatial data has never been so “accessible”… and that at no cost at all.

05 - Mapped DataNow it is time to improve on this…

Posted in Linux, Ubuntu | Tagged , , | Leave a comment

Installing PostgreSQL into an Ubuntu Server

In my previous post, I was showing you the installation of my Ubuntu 12.04.3 Server and I said I wanted it primarily to host a PostgreSQL Database.

Deciding on the Version of PostgreSQL

If you install PostgreSQL during the installation of Ubuntu, you will end up with a bundled PostgreSQL 9.1 installation. The current version at the time this article is written is PostgreSQL 9.3.1. You can always check the current state at the PostgreSQL Website.

So how do we get the latest version of PostgreSQL installed? Being a Windows user, I am used to download an installer and run it on my system – the LINUX world is different though, the installation in many cases is performed via the package manager… so let’s hope this also works for my installation… but before we do this, we make sure our Ubuntu Server is no longer using DHCP but a static IP Address…

Giving the Ubuntu Server a Static IP Address

Luckily, I have done this before – for my Raspberry Pi. But Linux is Linux and the way of assigning the static IP for the Ubuntu Server is the same… except for one thing: with the Raspberry installation, I got away without having to specify the DNS Name Servers – my Ubuntu needed that:

01 - Static IP Configuration

Once done, make sure the IP Address Configuration and routing works by pinging a well-known URL:

ping www.google.com

You should receive a return…

Installing PostgreSQL

The PostgreSQL web site says installing PostgreSQL is as easy as issuing the following command:

apt-get install postgresql-9.3

But reality is a bit different – it is not that easy. As I mentioned earlier: the version of PostgreSQL bundled with this version of Ubuntu is Version 9.1 – and we need to tell the package manager, where to get the latest version from.

For my release of Ubuntu (12.04), this requires me to create the file /etc/apt/sources.list.d/pgdg.list with the following content:

deb http://apt.postgresql.org/pub/repos/apt/ precise-pgdg main

Afterwards, the repository signing key needs to be installed.

wget -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -

So you either know what you are doing – or you are just brave… or both.

02 - Getting the Repository KeyBut I think, an explanation is serving everybody: this is actually executing one command (wget) and piping the result into a second command (apt-key) which is executed under root privileges (sudo) and supposed to add a new repository key (-add).

If you would just execute the first command (wget), you would actually see the PGP Public Key Block displayed on screen (which is in the chain of commands then passed on).

03 - PGP Public Key BlockWith the Repository Key added, the last thing we need to do is making sure that the package manager information files are up to date.

sudo apt-get update

will update the package manager database. And with that, the following command will finally produce a result:

apt-get install postgresql-9.3

The new package is found and the package manager will request permission to install it.

04 - APT-GET WorkingSo let’s allow the installation and see what will happen…

05 - Postgre SQL 9-3 InstalledAfter a few minutes only, the software is installed and you can see the line

* Starting PostgreSQL 9.3 database server      [ OK ]

towards the very end of the output.

Allowing Access to the Server

The PostgreSQL Server is actually installed and even running – but that does not really help a lot because we cannot do anything with it (yet).

Facing the truth, from an end user perspective, I am still a Windows boy – so I would like to access my data from my Windows Desktop and also do the database administration from there. The tool of choice if pgAdmin which I have already installed. But before we can use it to connect to the database server, some more work has to be done.

Setting the PostgreSQL Server’s Admin-Password

By default, the standard admin user for the database server – postgres – does not have a password set. Thus, nobody can use this user for a remote connection.

In order to set a password, we need to start PSQL, the SQL Commandline Interface.

sudo -u postgres psql

This will create a new session and will take us into the PSQL environment:

06 - PSQLNoticed the new prompt? postgres=#? Issue the following PSQL Command to set the password:

\password postgres

Then, type the new password twice. You can leave the PSQL environment by issuing the \q or \quit command. Now, the postgres user has a password but we are still unable to connect remotely – and that is owed to the fact that, again by default, the database does not accept external connections.

Opening up for Network Access

This is handled via a configuration file – /etc/postgresql/[Version]/main/postgresql.conf is the file in question. Please note the exact path depends on the version of PostgreSQL installed!

07 - The PostgreSQL Config FileThe configuration file actually contains a ton of interesting settings but the one we are currently lookingafter is the listen_addresses entry. As you can see, it is currently set to “localhost”, meaning that the database will only accept local connections.  Let’s change this to “*” to allow listening on all network cards… and don’t forget to uncomment the line! Save the file after applying the change. But we still got work to do – we still cannot connect to the database 😉

Authentification

With the above change, we will be able to connect to the database but we would not be able to authenticate. This is handled with yet another configuration file: /etc/postgresql/[Version]/main/pg_hba.conf.

08 - The PostgreSQL Authentification FileNote the various “local” and “host” lines at the bottom? They define who can access which database from where and by which method. In order for me to remotely connect here, I will have to enable my own network. The line is question is

host    all    all    xxx.xxx.xxx.0/0   md5

where the xxx.xxx.xxx need to be replaced with the correct triplets of my IP Address Scheme.

09 - Authenticating my NetworkAfter all these changes, I don’t bother with bouncing specific services – I just reboot the entire Ubuntu box…

sudo reboot

Connecting pgAdmin III to the Database Server

The last thing to do now is to fire up the installation of pgAdmin III (see above) and connect to the server:

10 - pgAdmin Connect DialogIt uses the static IP Address we have defined first, the port we have seen in the configuration file, the user and the user password we have configured and the network in between to connect. If everything goes well, we will see the connection information in the pgAdmin screen:

11 - pgAdmin ConnectedHooray – Ubuntu 12 with PostgreSQL 9.3 and pgAdmin III up and running… now, we can start working with the database server!

Posted in Ubuntu | Tagged , , | Leave a comment

Installing Ubuntu Server – Version 12.04 LTS

One of the many things I have is much of data – and more is coming in every day. Currently, this data is stored in a variety of formats – and some of it is not accessible at all (e.g. only available in scanned images).

What I need is a real database – and it must be one that is able to store spatial data. It should not cost a great deal, should be well established and easy to maintain. Looking around, I came across three possible solutions:

  • MS SQL Server Express
  • mySQL
  • PostgreSQL

I finally decided for PostgreSQL, especially since one of the things I wanted to do with the data inside is working with Quantum GIS (or QGIS). And PostgreSQL (but also mySQL) integrates with that quite well.

The Operating System

If I go with PostgreSQL, I might as well be consequent and not install it on a Windows environment (which needs to be licensed) but on a LINUX environment – I have chosen Ubuntu Server, to be precise Ubuntu Server 12.04.3 LTS.

01 - VMWare ConfigurationFor my home operations (and ease of installation) I will install into a VMWare Workstation 10 environment.

Given that I have plenty of resources available, the new virtual machine gets 2 CPUs with 2 Cores each, 4 GB of RAM and a 50 GB HDD.

The associated files are stored on a QNAP connected via iSCSI – that will allow me to re-use the machine from other computers on my network. It also saves space on my local hard disks and I will get an impression on the performance.

The downloaded ISO Image for Ubuntu 12.04.3 Server 64 Bit is loaded into the virtual CD-ROM and the virtual machine is started.

02 - Ubuntu Language ScreenI will try to keep the installation in English so everyone can read the screens – next is the Ubuntu Installation Menu.

03 - Ubuntu Installation MenuFrom here, select “Install Ubuntu Server”, then select the Installation Language (which will also become the default language for the installed system) – I will install my system in English. Once the selections are done, the automated configuration starts and the first interaction is the host name of the computer.

04 - Host Name ConfiguraitonI change the host name of my system to “postgre” as this will be a PostgreSQL Server. Next, the installer is asking for the full name and user name of a new user. Ubuntu requires this, it will not allow you to log in using the default “root” user.

You will also have to provide a password for the new user and decide if the home directory will be encrypted (where I keep the standard of <No>).

The installer will determine the time zone, then guide you through the disk partitioning dialogs.

05 - Partitioning of DisksI decide to stick to the defaults (which is to allocate the whole of the available disk to the system) and once done, the installation of the base system is progressing.

06 - Base System InstallationEventually, the installer will ask for the HTTP Proxy configuration (if required) and update the package manager files. More software will be installed and the installer asks for the type of Update Configuration desired – which I leave at “No automatic updates”. I now get a choice to install some software packages by default – which I kindly deny although PostgreSQL is amongst the available packages.

07 - Software Installation ScreenThe reason is simple: Ubuntu comes with a packaged version of PostgreSQL 9.1 – and I am not sure I want that. Also, I would like to see how the “manual” install of the package works…

While the system is now completing the installation, it is time to take a look at the QNAP – especially the data transfers going on.

08 - QNAP iSCSI TransfersAt a mere 12 MB/s at the peak, the performance of the virtual machine does not seem to suffer from the iSCSI usage for this environment. And the 12 MB/s are the peak, not the average.

The Ubuntu installer finally comes to the point where it finds the installation as the only operating system on the target environment and consequently offers to write the Boot Loader information into the Master Boor Record of the first (and only!) disk.

09 - GRUB to MBRThat concludes the installation of Ubuntu Server – the system will now reboot and issue a login screen.

10 - LoginThis is the time to shut down the virtual machine and take a snapshot in VMWare Workstation… just to stay on the safe side of things.

This now provides a working (yet totally unconfigured) Ubuntu Environment for further experiments…

Posted in Linux, Ubuntu | Tagged , , | Leave a comment

Creating a Color Profile for a Messerschmitt Me 210

I am running a second web site, dealing with specific historic aspects of the Deutsche Luftwaffe during the years 1935 – 1945. Running such a site is difficult – just to quickly one is put into a corner nobody wants to be in: the intent of the site is not glorification but a historically correct discussion of specific events or pieces of information.

As one of my “bits of information” is a collection – and discussion – of Flight Logs of Luftwaffe pilots, aircraft of different types and units are “daily business”. Photos of the time are rare, photos of specific aircraft extremely rare and color photos almost non-existing. But they say “an image is worth a thousand words” – so I decided to make up my own color profiles and create them as needed… and here is a story of how one is developed.

The Tools

One of the very first things to decide is which tools to use – as I am going to work on color profiles (not 3D-Models!) I decided to use a vector drawing program, supported by a graphics program. Since both need to work together as we will later see, the choice was easy – I am using Adobe Illustrator and Adobe Photoshop. Both are not the cheapest choice but one that works extremely well. And Adobe’s new “Creative Cloud” makes the software affordable for a reasonable monthly price.

But having the tools alone does not help – a color profile requires a decent documentation of the aircraft in question. So books (and a scanner) come in handy.

First of all, a decent drawing of the aircraft at least from the side, better from three sides is required. You can find an example for the Messerschmitt Me 210 here.

A good library is required

One is the minimum, having different alternatives is better – especially when you are dealing with aircraft that have seen many variations. The Messerschmitt Me 210 I need a color profile for was flown by the Hungarian Airforce, therefore it would have been a Me 210 Ca-1 – the variant may or may not differ from the one I got the drawing for which is a Me 210 A-1.

Good books on the Messerschmitt Me 210 are

  • Heinz Mankau & Peter Petrick: Messerschmitt Bf 110 – Me 210 – Me 410, published by Aviatic Verlag, Oberhaching (ISBN: 3-925505-62-8)
  • George Punka: Aircraft Number 147 – Messerschmitt Me 210/410, published by Squadron/Signal Publications (ISBN: 0-89747-320-5)

Mankau describes the Ca-1 variant as being “the Hungarian-licensed version of the C-1” which in return is described as “being like the Me 210 A-1 but using 2 x DB 605B as engines.”

So in essence, the drawing available for the Me 210 A-1 should also be applicable to the Me 210 Ca-1.

Online Resources

Another good choice are various online resources – looking for drawings of the Me 210, I have come across a site that features plenty of aircraft drawings. However, one needs to be very careful with the copyrighted material…

For this particular aircraft, I was able to come up with two side views, one with the engine and outer wing part, one without – excellent for properly covering the otherwise hidden areas.

Creating the Aircraft in Adobe Illustrator

With the information at hand, the first step is to create a new drawing in Adobe Illustrator. Given my purely electronic use of the result, the choice of the physical paper dimensions is not really important but just in case, I am using A3 as paper size.

The initial layer is renamed to “Scale Drawing” and the aircraft drawing is imported, positioned and locked.

01 - Background drawin in Adobe IllustratorThe next step is to decide on how the aircraft is to be segmented and drawn – one has to keep in mind that the base drawing will be a “wire-frame” model, not filled with any coloring. It comes in handy to not deal with the aircraft “as one big block” but to segment it – it makes dealing with different aspects of the aircraft much easier if you know you are done with a one part and can hide it (also secure it by locking it) and – more importantly – it helps with the coloring later.

My current scheme (developed in two previous models) is to segment as follows:

  • the aircraft body without any attachments such as antennas or wheels,
  • the aircraft cockpit,
  • the aircraft inner wing without the engines (if it is not a single-engine aircraft),
  • the aircraft engine including the propeller,
  • the aircraft outer wing,
  • the landing gear (I usually have my color profiles “flying” so the only one that usually is needed is the tail wheel),
  • the aircraft armament (guns, cannons, etc.),
  • other items such as antennas, wiring, etc.

Drawing the Aircraft Body

You could start anywhere you want but for me, the aircraft body as the largest part always comes first. It also gives me the needed anchor points for other items later.

Drawing the body is easy – I add a new layer on top of the background layer, then use the Pen tool to roughly trace the outline. Also important (but my personal taste): in the first run, I don’t bother making my outline curved – I am just setting anchor points!

02 - Initial Anchor Points for AC Body

 

While this looks pretty good with the aircraft drawing underneath, you can see that I have not bothered to create the curves just yet – I only set the anchor points.

03 - Initial Anchor Points without CurvesSo next is making the curves – again, the Adobe Illustrator Pen too is the tool of choice, now used to turn the anchor points into curves.

04 - Corrections madeNow that does not look too bad for now – next section on is the aircraft’s cockpit…

The Aircraft’s Cockpit Section

While the aircraft body was straight forward, the cockpit section is a bit more difficult and that is because of the different materials used: first of all, the aircraft needs the cockpit frame as a separate entity because it needs coloring later. Next, the glass needs to be modeled and this, too, will receive a coloring (and transparency). Finally, the interior (at least as much as it is visible) needs to be created.

The upper part of the cockpit is currently included in the path of the Body – the lower part of the cockpit is not present. What basically needs to happen is adding a new layer – labeled “Cockpit”. Next, I will include the lower cockpit area where body and cockpit meet. Finally, I will cut the upper part from the body to complete the cockpit and at the same time include the lower part of the cockpit into the body.

Some may now ask why on earth I had included the canopy into the body in the first place – the answer is simple: Adobe Illustrator provides a smooth curving across the entire path and this is easier than creating a matching curving in two separate paths.

06 - Cockpit and Body separatedNow it is time to finish the cockpit: the frame needs completion and the glass areas need to be cut out as separate forms to allow a different and transparent coloring. First, I create the missing outlines of the glass elements.

07 - Glass AreasI now need to cut out the glass areas and duplicate the borders of the glass areas into the frame of the cockpit area – basically, I need the inner lines twice.

This comes down to adding missing anchor points at the intersections, cutting and joining paths and applying corrective actions. The end result is a cockpit frame…

08 - Cockpit Frame… and an area for the glass…

09 - Cockpit Glass… and both combined and with the aircraft body visible already give a nice view of the aircraft. Now on to the wing.

The Wing – a problem by itself

In my two previous color profiles, the wing had been the most difficult area to work out. Mainly because several areas are obscured and the structure itself, given the direct view from the side, is rather narrow. Minor mistakes in the original drawing result in clearly visible problems in the model. This time is different as I have two identical drawing, one with and one without the outer part of the wing an engine.

10 - Body with Cockpit and inner WingIt is now up to us – complete the aircraft body with the missing inner lines for all kinds of openings, rudder, and plating or add engine and outer wing first. I’ll opt for completing the body.

11 - Body with inner Lines completedNow, that starts to look promising… up next is the enging.

The Engine and Outer Wing

Adding the engine does not really hold anything new – again, a new layer is added, named “Engine” and again, a part of the engine will be obscured by another element, the outer wing.

Also, adding the engine requires the switching of the background image – so far, I have been working with one that did not show engine and wing but a full view of the aircraft’s body. That is now changing. To avoid confusion, I am also hiding several (actually all) vector layers I have created so far.

12 - Engine and Outer Wing Background ImageAs it turns out, creating the engine (in one layer) and the outer wing part (in a different layer) is easiest when you do it together – they share some path segments anyway. When showing the other vector layers, the previously added thin lines of the body will “shine through” the new engine block (and wing) so I have decided to fill both with pure White.

13 - Engine and Outer Wing - Colored WhiteSo far so good – next are the inner thin lines of both, engine and outer wing. Also the oil cooler is missing. And finally the exhaust and filter. As well as the horizontal stabilizer…

14 - All Major Parts assembledAlthough the aircraft is not entirely done yet, we have enough to start adding some base color – and start with the aircraft body.

Applying a Paint Scheme – Hungarian Air Force

In Adobe Illustrator, I select the aircraft body’s outline and copy it – then I switch over to Adobe Photoshop. There, I am creating a new document with the size of the clipboard. Inserting the aircraft’s body information as Path, I end up with the outline of the Messerschmitt Me 210 in Adobe Photoshop.

Looking at samples from the various sources I mentioned before, the Hungarian Me 210 was painted in a scheme composed of the colors RLM 74/75 and RLM 76. The latter one serves as my base paint for now.

15 - Photoship Body Base PaintSaving the file in Adobe Photoshop to a PSD File, I switch back to Adobe Illustrator, creating a new layer named “Color Scheme”. I copy the Aircraft’s body outline once more, inserting it into the new layer and at the same position´.

I also drag and drop the Texture PSD File from the Windows Explorer into Adobe Illustrator. Both objects should be positioned to match up.

16 - Body and TextureFinally, with both objects selected, I choose Clipping Mask -> Make from the menu. This ensures that the texture part is clipped by the form of the path.

17 - Clipping Mask Aircraft BodyFrom that point on, the Adobe Photoshop file is linked to the Adobe Illustrator file – you should not move or rename the Photoshop file from that point on.

An interesting side-effect of that link is the automatic update – if you change the texture in Adobe Photoshop, Adobe Illustrator will recognize the change and apply it automatically. Back in Photoshop, I am now applying a layer of RLM 75, a medium gray, to the upper area of the fuselage.

18 - Photoshop Body with additional RLM 75As soon as I save the file on Adobe Photoshop and switch over to Adobe Illustrator, I am asked if I want to update the texture file – confirming the update, my aircraft’s paint scheme is applied automatically.

19 - Updated Texture in Adobe IllustratorNext on the aircraft body is the Hungarian national colors – the Hungarian Air Force had them painted very dominantly on the aileron. Given their nature – three squares with straight-forward coloring – I have decided to create those in Adobe Illustrator rather than pain them in Photoshop.

The easiest way is to create a new layer, copy the aircraft body into the new layer, use the rest of the layers to properly place three rectangles that mark the stripes of the Hungarian flag and then use the Pathfinder tool to create a new form by using the overlapping areas. Finally, the remaining forms are filled with the respective RGB colors.

20 - The Hungarian ColorsThe same way, the base coloring for the engine (upper surface in RLM 75, underside in RLM 76) and the lower part of the wing (RLM 76) needs to be applied. Both become two new Adobe Photoshop texture files.

When bringing them back into Adobe Illustrator to apply the Clipping Masks, you need to make sure though that the clipping mask is one path – in my case, the engine outline was composed of one unclosed path and one closed area so I had to create a combined path first using the Pathfinder tool. Also, you will have to place the layers more cleverly than for the body: the engine body is White to cover the underlying body areas – this needs to remain, otherwise the body will shine through.

The whole process takes a bit of fiddling around but the good thing is that once it is set up and you need to fine-tune the coloring, you are mostly dealing with Photoshop. As long as you keep the linked file the same, you can do anything you want – including working with different Photoshop layers that you can hide or show and even those settings will carry over to Adobe Illustrator.

21 - All painted except the CockpitSo if things don’t work out the first time, don’t worry – corrections are not too bad the way both tools interact.

Speaking of “corrective actions” – there is one big error to fix on the aircraft: the cockpit section does not yet have its horizontal bracings yet. So let’s rework the cockpit area. But before doing so, there is one more important aspect to mention – and that is keeping control of your files altogether.

Version Control

There is nothing worse than losing work – one way to do so is to forget to save when Adobe Illustrator decides to crash on you – happened twice (the crash) while I was working on the Me 210. There is no native auto-save feature built-it so you either have to find a different way or remember to save your work frequently.

The other way of losing your work is by saving… sounds funny? Not necessarily if you keep in mind that saving a file means overwriting the previous version. Like in the situation I am in now: I have a well-modeled cockpit area and I am going to make a major change. As soon as I save, the old “version” is overwritten – what if I ever have to go back?

Well, one way certainly would be to do a “Save as…” but that will create a ton of files with different naming and I would not be able to do this for the Photoshop files as their name is linked to the Illustrator file. So my solution is to use a Content Management System (or better: a Revision Control System). My files are stored in a Subversion Repository which allows me to keep the history of my development and always only work with one file (but always also be able to retrieve any previous version I might need).

Corrective Actions – the Model

As mentioned above, my cockpit section requires some rework. My files are securely stored in Subversion and I am free to re-work the cockpit as needed. So here is the original cockpit section.

22 - Original Cockpit SectionAs you can see from the underlying window, there is a horizontal stabilizer that I forgot to put in. Also, the middle section’s top area is not entirely made of glass – there is a metal area in the upper left part of it.

The horizontal bar is easily put it. I just draw a rectangle where the bar needs to go (and make sure that both ends are well within the existing structure).

23 - Horizontal Stabilizer put inNext, I use the Pathfinder tool in Adobe Illustrator to merge both areas and form one path from them.

24 - Merged AreaI can now to the same for the central section of the cockpit, making it a 50-50 structure of glass and metal. Finally, the glass and the new frame need to be worked out so every glass part is also available as closed area for coloring. Finally, the cockpit frame needs an Adobe Photoshop texture.

25 - Finished Cockpit with GlassBut that coloring is incorrect – the aircraft now gets a bit tricky: the canopy area is a mix of RLM 75 and RLM 76 (latter one being the lighter gray) and the RLM 75 area continues into the main part of the body. But using Adobe Photoshop and different layers for the coloring, even this pain scheme is easily applied.

26 - Cockpit and Body with RLM75 and RLM76Corrective Actions – the Coloring

We have already seen a bit of the coloring being reworked in the past few steps. But now, it is time to take things a but further but that, I am afraid, takes us deeper into Adobe Photoshop. Remember: once the actual texture file has been applied, all changes made to it in Adobe Photoshop are automatically carried over to the Adobe Illustrator drawing. And that will now play out quite strongly…

Remember the initial coloring of the body? I have to admit: I have taken a very easy approach to not add complexity at that time. But now, I am at a point where things need to get a bit more into detail.

Initially, I had selected the outline of the aircraft’s body and pasted it into Adobe Photoshop as a new Path – the disadvantage is, that this one will vanish when you close and re-open the document. Instead, it is better to paste the outline as Smart Object, which will create a new Adobe Photoshop Vector layer. This one remains with the document and should immediately be locked.

Next, I applied all coloring to the base layer of the Adobe Photoshop document. It would be better to do that in a separate layer as well (not necessarily but for example if you would try the difference between different shades.

27 - Adobe Photoshop with Body TextureNotice the layers (German: “Ebenen”) on the right? There is an RLM76 Base Coloring layer… now I think my RLM76 is a bit to “greenish” but RLM76 seems to have come in variants… so let’s try the two more “grayish” ones… just adding a separate layer and then handling the visibility in Photoshop makes the Adobe Illustrator work change.

28 - Adobe Photoshop LayersAs you can see in the Adobe Photoshop Layer tool, I am now working with several layers, some of them being visible, others not.

This way, I can control the texture and experiment with the colors without ruining work done before.

Also important: for the final usage in Adobe Illustrator, you need to hide the Vector-Smartobject (the outline), otherwise you will end up with duplicate lines.

Another advantage of the use of layers is that they can easily be moved. Think about the RLM74 layer (this is the one holding the dark gray section around the cockpit): it might be perfectly shaped but a bit out of position in the final rendering – how cool is it to just move the layer around without messing up any other parts of the texture?

Eventually, one will find out that it is quite difficult to find “the correct coloring” for the aircraft: the theories which colors have been used and what exactly they have looked like are as unified as the weather forecast for next month… so at the end of the day, I have decided to settle on a color scheme that seems “reasonable” – and there is the result:

29 - Me 210 Ca-1 Paint SchemeAnd yes, there has been another correction applied – the incorrectly placed “bent” in the upper aircraft body (which was present in the Me 210 A-0) was removed.

Final touches

You have seen most of the techniques applied by now – there are some finishing touches that remain open like the Hungarian Air Force markings, antennas, exhausts, guns, horizontal stabilizer, cockpit interior… and finally some light effects to prevent the drawing from looking too flat…

31 - Applying Final TouchesGiving it all a Frame

Coming to an end, the last remaining item to be done now is to add a decent frame to the aircraft drawing – presentation is everything…

32 - Me 210 Ca-1 ZO+55Some closing Comments

It is almost surreal but despite these aircraft not being older than 70 years, it is hard to get a definite “this is how she looked” type of drawing. With respect to the model itself, the aircraft frame: that is well documented… plenty of photos and drawing out there but hey, even there the trouble starts: if there had been different variants of an aircraft, which one is the correct one? How does that particular variant differ from another one? You may find all the information required in the literature – but you need to crosscheck them all because the book you are looking at might have that small error itself…

The coloring is an entire nightmare – believe it or not, the interpretation of the defined RLM Colors used by the Luftwaffe are as different as day and night. Unfortunately, very few color photos exist – those that exists had seven decades to fade the colors – plus the film use to take the image may have been exposed to heat, cold, etc. – so all in all, an assumption on the colors can be made – but that is it. A definite “this is what she looked like” is impossible – but a whole-heartedly “this is what she might have looked like!” is quite possible.

Finally, there is the level of detail – every artist is applying a different one – some want to draw every single item, no matter how small or how hidden it is – others tend to focus on the overall image. Neither one of them is right or wrong, this is artwork in the best possible sense and artwork is always an interpretation of the artist… so forgive me (and anyone else trying to put out color plates, scale models, etc.) if you would have done it differently – this is the way I did it and I can only encourage you to enjoy… provide feedback, constructive and encouraging and I will adapt as I see it fit…..

Posted in Allgemein | Leave a comment

About Geocaching & a well-travelled Trackable

You may have heard about Geocaching – that is the activity that makes grown-up men walk in the countryside without their better halfs having to push them. Basically, you get yourself a GPS, an account on www.geocaching.com and start hunting for “hidden treasures” in your favorite area. And there are plenty these days – if I check the map of caches around my hometown, this is what I am getting:

01 - Caches around HomeBut besides finding hidden caches, there is another fun activity and this has to do with so called Trackables. A Trackable is an item that you attach an ID to (so people that find it accidentally can get an idea of what it is and people that know what it is can get it’s Travel Bug ID.

Next, you place the Trackable in any cache you find that is large enough to hold it… and wait. Somebody else will pick it up and place it in the next cache and so on… but by placing a Trackable in a cache, you also “log” its new location – and everyone (hopefully) can follow the item on a map automatically maintained by the web site.

Many years ago, in 2005, I have sent out three Trackables – only one of them has survived the dangers of the open world. Another one was lost in a flooding in England, yet another one just disappeared. But one – I named it HEINER-7 in reference to the radio call-sign of the Darmstadt Police – has made it…

02 - HEINER-7The little Police Car – Polizei in German – has made quite a bit of a trip: I dropped it off in a Cache named “Bernd Rosemeyer Memorial” (Cache Code GCGWFY) March 26, 2007. It was quickly picked up and made its way to several caches in southern Germany.

Later that year, in September 2007, it was picked up and taken to England where it spent a bit of time – primarily because it was “kept out of the loop” for about 6 months. After it was “returned to active duty”, it made its way through other caches in Southern England and was finally taken to Switzerland.

03 - Touring EnglandThere, it went through several caches until it was taken ti the Mediterranean Island of Crete in 2011.

04 - SwitzerlandCrete turned out to be a one-stop event – it was picked up and taken back to Germany, into the area of Cologne. Again, touring the area around the Ruhrgebiet for a bit, it eventually made its way to France.

05 - CologneIt was southern France first, then later the eastern parts of the country. Eventually, in August 2012, it was taken back to Germany, this time to Brandenburg, close to the border of Poland.

Around this time, I had decided to try and “call it back” – I updated the mission description on the site attached to the Trackable and despite the fact that is made a little detour through Poland, Lithuania and Latvia, people started to pick up the new mission which was “to return home”.

07 - LatviaBut Geocachers are frequent these days and it was soon returned to Germany – to Munich this time. But returning home was not easy – from Munich, the little car travelled to Saxony and the up to the Baltic Sea until it arrived in the city of Hamburg in May 2013.

From there on, things were coming to an end – despite another little detour to Austria, people really started to look up the Travel Bug’s (TB’s) mission and instead of dropping it in Austria, they returned it back home 🙂

Finally, on September 21, 2013, it was dropped in a Geocache near Heppenheim, some 60 Kilometers from my home. It remained there until mid October when I was in the city of Speyer and – on my way home – stopped over to retrieve it from the Cache (which I had a hard time finding but hey, I knew (or at least hoped) my TB was there…)

All in all, the little Police Car travelled roughly 18.000 Kilometers in the hands of friendly Geocachers – thank you to everyone who supported this Trackable or any other of the many in the Caches of the World.

08 - Full MapThis one will now retire to my shelf and remain there – it has seen it’s share of travelling. I have others running and we will see if they will have similar stories to tell.

Finally, I would like to share a set of photos taken by other Geocachers while the TB was in their hands.

09a - My initial Photo 09b - Chasing Green Italian Job TB 09c - On Patrol in Gloucester 09d - Airport Bern 09e - Highway Patrol Sissach 09f - In Düsseldorf 09g - France09h - Hamburg

Posted in Allgemein | Tagged | Leave a comment