Sterling GIS/SI: DB Structure: Maps

Lately, there was a discussion about “Bulk download of SI Maps” on LinkedIn. I shared my experience – working on a migration project from GIS to SI we needed to download about 500+ maps, compile them with new MapEditor and upload them back. It would’ve taken a lot of time doing it manually, so I decided to get the maps from DB, compile them with MapEditor command line and then upload them into the new system.

Of course, maps should be stored in some kind of CVS – SVN, Git, etc. But we didn’t have this option – all the maps were on the GIS server.

I wrote a simple application on Java – it connected to Oracle DB, downloaded maps (see my SQL below), unzip them and then another application compiled the maps and ran unit tests (it’s a different story). Finally, another application uploaded compiled maps into the new system (now I know we could’ve used native or script, but back then I didn’t know about it).

So, here is an SQL to get the map in as a blob (Oracle)

select m.*, dt.DATA_OBJECT from map_versions mv, map m, DATA_TABLE dt 
  mv.map_name like '{here your map name, without extension}' 
  and m.map_name = mv.map_name 
  and m.map_version = mv.default_version 
  and m.UNCOMPILED_MAP = dt.data_id

so, there are two main tables – Map and Map_Versions. Maps and Txos are stored in DATA_TABLE.

Gennady Kim


5 thoughts on “Sterling GIS/SI: DB Structure: Maps

  1. guys, it’s just an idea, and it worked for me. All you need is to write a code in any language you know – Java, JS, VB, VBS, C# and so on – it doesn’t matter. All you need is connect to your DB, get the blob data, save it to disk and unzip.

    I don’t like sharing the whole solution (but I’m doing it as well) – here it’s more about the knowledge sharing, just to help smart people to find very quick and elegant solution to a problem. That’s the idea of this blog

  2. Hi Mr.Kim,
    Hope you’re doing good. Your blog and tutorials are so helpful for me. I follow your blog regularly to gain expertise on EDI . I work on Sterling Integrator 5.2 and light well frame work( FMI 2.9). I’ve to work on scenario where I’ve to get SI envelope two different documents ( EDI 820 and 831)together in same file (interchanges same). I can’t use batching as that will create 2 interchanges but keep them in same file.Could you please throw some light on how to achieve that?

    • hi there

      I’m not a big expert in BPs, but here if I’m not mistaken 2 options in SI – send documents immediately -OR- send them in batches, every X minutes. You probably should look into this. One more time, I cannot provide you with the exact solution – I’m not an expert in this area.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s