I have great appreciation for importance of different points of view ever since my student times in AIESEC organization.

In my previous blog I showed how to produce the ASCII map from world shapes loaded into SAP HANA. The Earth is shown the way we used to see it on maps. And by “we” I mean us living in Europe – in the middle of the universe, thanks to the Greenwich being a prime meridian.

But it was not always be like that. The Greenwich Meridian as the international standard for zero degrees longitude has been agreed at The International Meridian Conference held in 1884. Before that different nations had their own reference systems. I used to live in Poland not far from the Warsaw meridian monument, which was erected 4 years before the conference.

Looking even further into the ancient times – before America was known to people in Eurasia. Then the center of the world was somewhere around Arabian Peninsula, like on this Ptolemy’s world map from c. 150 (source: Wikipedia). By the way, the most significant contribution of Ptolemy’s maps is the first uses of longitudinal and latitudinal lines!

Yet even today not all maps use Greenwich as their middle line. While living in Silicon Valley I discovered some America-centric maps. They made absolute sense for me by showing proximity of Asia to California – something that is not that obvious when looking at the Eurocentric maps.

The center of such maps was defined by either 75° West (which is close to Washington meridians) or by 98° West (which is close to the geographic center of the contiguous United States).

(source: 1-World Globes & Maps)

So, I need to make my ASCII map calculation procedure more flexible. Here is the ASCII_MAP_FLAT_FLEX SQLScript procedure I came up with. Comments and suggestions for improvements are welcome!

create procedure "NATURAL_EARTH"."ASCII_MAP_FLAT_FLEX" (IN resolution INT, IN primeMeridian FLOAT DEFAULT 0.0, IN northUp INT DEFAULT 1)
 loopLon, loopLat, calcLon, calcLat FLOAT;
 meridianShift INTEGER;
 stringSurface, pointSurface STRING;
    IF northUp <> 1 THEN northUp := -1; END IF;
    if resolution > 1000 THEN resolution := 1000; END IF;
    IF resolution < 20 THEN resolution := 20; END IF;
    loopLat := 90;
    WHILE loopLat>=-90 DO
        loopLon := -180;
        calcLat := loopLat * northUp;
        stringSurface := '';
        WHILE loopLon<=180 DO
            calcLon := loopLon * northUp;
            select new st_point('POINT ('||:calcLon||' '||:calcLat||')', 1000004326).ST_CoveredBy(SHAPE) into pointSurface FROM "NATURAL_EARTH"."NE_EARTH";
            stringSurface := concat (stringSurface, pointSurface);
            loopLon := loopLon+360/resolution;
        END WHILE;
        meridianShift := mod(primeMeridian*northUp +360, 360) * resolution/360;
        stringSurface := concat (right(stringSurface, resolution-meridianShift), left(stringSurface, meridianShift+1));
        INSERT INTO "NATURAL_EARTH"."DRAW_EARTH" VALUES (:calcLat, :stringSurface);
        loopLat := loopLat-360/resolution;

Now, when calling the procedure you can define the meridian, which defines the center of the ASCII map. Here for the map with Washington meridian as prime (parameter primeMeridian):

 SELECT replace(replace("SSTRING", '0', ' '), '1', '*') as "ASCIIMAP" FROM "NATURAL_EARTH"."DRAW_EARTH";

And the result is:

But then last year I had a chance to visit Australia for the first time. Being down under helped me to discover the story of McArthur’s “Universal Corrective Map of the World“. In a nutshell the story is “Who told you the North pole is on the top, and not on the bottom of the Earth?” Have you ever asked the same question?

(source: Of maps and math and Buckminster Fuller)

That’s why in the procedure above I introduced as well an optional parameter northUp. By default is it equal to 1, meaning the north is on top. Any other value will produce a map with the South pole being up. So, let’s have a look at the world from the perspective of my Australian colleagues.

 CALL "NATURAL_EARTH"."ASCII_MAP_FLAT_FLEX"(RESOLUTION => 180, primeMeridian => 158, northUp => 0);
 SELECT replace(replace("SSTRING", '0', ' '), '1', '*') as "ASCIIMAP" FROM "NATURAL_EARTH"."DRAW_EARTH";

As well the prime meridian has been set to 158° East to make it Australia-centric.

Want to find how world looks like when you home is the center of the Earth? Just try this code above and play with other parameters 🙂

Or read the next part, if interested in non-rectangular projections.

-Vitaliy, aka @Sygyzmundovych

To report this post you need to login first.


You must be Logged on to comment or reply to a post.

  1. Robert Russell

    Hi Vitaliy,


    Thank you for sharing and interesting perspective with a “different point of view”. I have been working with natural earth data set for a long time and to be honest I didn’t think about other starting points other than prime meridian!  I really like your opening line to this blog and made me think about other points of view to the world:) . Also you have started me on a bit of a mission to replicate what you have done with the ASCII art, and I will share my results when I get to the end of this work.


    Thank you






Leave a Reply