Archive for ‘Databases’

August 12, 2013

Oracle 12c – Multi-Tenant Databases — #STEM, #Oracle

by C. Michael Eliasz-Solomon


Oracle 12c

Oracle’s newest database (version 12c) has many new features, the discussion of which are too big for a single blog article (or even a series of blogs). The substantial high-level bulleted list of new features is in the 12c New Features Manual . But the concepts and low level SQL language details show a much larger change then you might perceive.

Multitenant Database

The new paradigm shift, Multitenant Databases, will stop DBAs pretty quick, particularly in Windows where the installer creates a Container DB. Previous to 12c, all databases were Non-Container DBs. With 12c you can create a Non-Container DB or a Container DB. The Container DB can have zero, one, or more Pluggable DBs within. A Non-Container DB can never have a Pluggable DB. So that becomes an upfront database creation decision.

You can and you should read the Oracle Intro to Multitenant Databases .

I first relaized the Oracle Installer had created a container database for me when I went through the normal process of creating a database user using the same old techniques I always did and received an Oracle Error: ORA-65096. WHAM, I slammed right into the new paradigm without me even knowing it existed. The error description and the necessary action introduced to another part of the Multitenant Database paradigm: Comon User vs. Local User. That quickly led to Containers. Of course, with any new features, comes an array of new database schema tables like, v$pdbs for example. You will also probably use a new Sql*Plus command a LOT: SHOW CON_NAME to know what container (root or pluggable database) you are connected to. Some DBA commands must be done in the root container (CDB$ROOT). Your pluggable databases (in Windows) will be by default: PDB$SEED and PDBORCL. Every container database has precisely one seed pluggable database from which all pluggable databases are created from.

This paradigm shift will be  seriously disorienting feeling to long time DBAs, especially if were not aware this was coming. Fortunately, there are many DBA bloggers out there sharing their 12c experiences. They were a help for me to gather the necessary jargon. But it was not until I discovered that Oracle had created a tutorial on Multitenant Databases and I had spent an hour or two playing with the tutorial on my newly created sandbox database (on Windows) which was by default a Container DB. This tutorial is an excellent way to jump start your understanding of the new paradigm.

By the way, I think either the default should be a NON-CONTAINER DB (so you are backwards compatible) or the Oracle Intsaller needs to make it clear that a CONTAINER DB will require new DBA processes (i.e. a learning curve) and give you an OVERT option to create a NON-CONTAINER DB for backwards compatibility.


Read the Oracle Introduction to Multitenant Databases to understand the concepts. Then immediately work your way through the tutorial in a test database that is a Container DB. Ultimately, I think Container DBs are the way to go. I think this is what you want to do to implement a CLOUD or in a Virtualized Environment.

August 11, 2013

Pacanów Pomoc – #Genealogy, #Polish

by C. Michael Eliasz-Solomon

Stanczyk has been a bit busy this past week with Oracle 12c (database) !   So forgive me if I play a bit of catch-up on my genealogy.

I have analyzed the data from GENEALODZY.PL in their GENESZUKACZ database for Pacanów Births (1875-1908). So now I need some help (pomoc). In my notes column I have noted the ELIASZ that I have in my family  -or- my guess. The empty notes fields are ELIASZ that I need help with. If you are a genealogist with these people in your family tree then please email me your info and if possible any images of church records or family photos.



/ Rok


/ Akt

Imię Nazwisko    NOTES
1 1875 110  Wacław Eliasz in my tree; son of Wojciech Eliasz & Agnieszka Pyszkow; [image]
2 1876 109  Marianna Eliasz daughter of Ludwik & Elz. Miklaszewski
3 1878 59  Katarzyna Eliasz
4 1879 20  Roman Eliasz son of Ludwik & Elz. Miklaszewski
5 1880 52  Jan Eliasz son of Jozef Eliasz & Petronella Zwolski
6 1880 160  Jan Eliasz My grand-uncle Jan; son of Jozef Eliasz & Marianna Paluch
7 1881 28  Jan Eliasz Martin Eliasz’s  (& Julianna Odomski) son
8 1881 30  Julianna Eliasz
9 1881 130  Tomasz Eliasz son of Ludwik & Elz. Miklaszewski
10 1882 128  Wincenty Eliasz son of Jozef Eliasz & Petronella Zwolski
11 1882 157  Marianna Eliasz Martin’s  (Julianna Odomski) daughter
12 1882 185  Katarzyna Eliasz A Grand-Aunt
13 1883 25  Roman Eliasz
14 1884 33  Apolonia Eliasz Martin’s daughter
15 1884 71  Marianna Eliasz
16 1885 46  Józef Eliasz My Grandfather; Have Birth Record
17 1885 125  Marianna Eliasz
18 1886 189  Jan Eliasz
19 1886 238  Szczepan Eliasz
20 1888 104  Julianna Eliasz A Grand-Aunt
21 1888 123  Teofila Eliasz
22 1889 71  Józefa Eliasz
23 1889 109  Antoni Eliasz ??possibly son of Ludwik & Elzbieta  M.
24 1890 24  Katarzyna Eliasz
25 1890 149  Marianna Eliasz
26 1890 181  Stanisław Eliasz Martin’s son, dies in Detroit (Stanislaw Elyasz in October 1923)
27 1891 186  Stanisław Eliasz
28 1891 190  Franciszka Eliasz
29 1892 68  Wincenty Eliasz
30 1892 83  Władysław Eliasz My Grand-Uncle
31 1892 206  Marianna Eliasz
32 1893 143  Anna Eliasz
33 1893 237  Marianna Eliasz
34 1893 261  Agnieszka Eliasz ??? Agnieszka Marianna E. that marries S. Hajek (Cleveland) ???
35 1895 30  Marianna Eliasz
36 1895 230  Tomasz Eliasz My Grand-Uncle (Dorota’s grandfather); Have birth record
37 1896 164  Wacław Eliasz
38 1897 8  Julianna Eliasz
39 1897 236  Julianna Eliasz A Grand-Aunt
40 1898 103  Anna Eliasz
41 1899 63  Balbina Eliasz
42 1899 79  Zygmunt Eliasz ??? Zygmunt Elijasz son Jozef E. & Theresa Siwiec??? PROBABLY not since Zygmunt was born in Biechow in 1898 (April 19)
43 1899 185  Aleksander Eliasz
44 1900 163  Julianna Eliasz
45 1901 84  Marcin Eliasz
46 1901 100  Anna Eliasz
47 1901 161  Marianna Eliasz
48 1901 164  Martin Eliasz
49 1903 95  Stanisława Eliasz one of these three is Emilja daughter of Jan/Pelagia
50 1903 112  Helena Eliasz one of these three is Emilja daughter of Jan/Pelagia
51 1903 175  Janina Eliasz one of these three is Emilja daughter of Jan/Pelagia
52 1905 96  Julianna Eliasz
53 1906 71  Wojciech Eliasz
54 1906 77  Stanisław Eliasz
55 1906 141  Edward,Jan Eliasz son of Jan Eliasz  & Pelagia z Kedzierski ?
56 1907 11  Julian Eliasz
57 1908 67  Kazimiera Eliasz
58 1908 124  Michalina Eliasz
August 8, 2013

Wordless Wednesday — #Oracle, #12c, #STEM, #GEEK

by C. Michael Eliasz-Solomon

Oracle 12c installed . Getting my #GEEK on this week.



August 7, 2013

Oracle v 12c … vs. Greenplum MPP — #STEM, #Oracle, #Greenplum, #BigData

by C. Michael Eliasz-Solomon

Studying up on Oracle v. 12c. As usual, there are many new features to recommend migrating or deploying to the new version of Oracle. Last blog, I talked about just a few: ILM, ADO, HEAT_MAP and how these buzz-worthy acronyms were related to compression inside the database. Before,  I get into today’s topic, I wanted to talk about  a bit more about the Automatic Data Optimization (ADO).

I failed to make clear yesterday, that the ADO, automatically relocates your cold data or compresses your data as it ages through its Lifecycle automatically. That is the magic. You define the policies and the database will relocate or compress a segment(s) or a row(s) to save space or to clear space on more expensive hard disk, by relocating to slower/less accessible disk storage media. Pretty nifty idea.

By the way, you may be wondering … 8i, 9i, 10g, 11g, 12c what is the pattern or meaning of these major release versions from Oracle.?  Well, “8i / 9i” were from the era, when Oracle was the “Internet” database (you know  like iPhone, or i-<Anything>). Then “10g / 11g” were to be the “Grid”. Grid never really achieved buzz-worthy status. Now we have “12c”. It should not surprise you that we are now in the “Cloud” era. So Oracle’s letters are for: Internet, Grid, and Cloud . Now you know.

That Cloud and yesterday’s ADO  will figure in today’s blog too. You see, I was recently asked about Greenplum. Could I use it? As is my wont, I took a step back and studied the question. Here is my answer.



MPP platform

MPP – RAC(aka Oracle parallel server)

Full SQL (Postgres)

Full SQL (Oracle, ANSI)


Compression since 11g, ADO/ILM 12c

B-Tree / BitMap Indexes

B-Tree / BitMap Indexes


JDBC/ODBC/OLE/Pro*C (etc.)

Parallel Query Optimizer

Parallel Query Optimizer

External Tables

External Tables

GreenPlum HD (HDFS)

External Tables using an HDFS

I believe that as an Oracle expert (28+ years from v2.0-11g inclusive), that I could effectively use Greenplum on a project. If you look at the above chart, I think you will see what I am about to explain.

Green is an MPP platform. Very nice acrhitecture. Oracle can sit on top of any architecture (MPP, SMP, or any cluster or Highly Available or Fault-Tolerant Failover set of servers) you can setup.

Both use FULL SQL.  That means ANSI compliance and with enhancements (POSTGRES for Greenplum and ORACLE, uh, for Oracle).

B-Tree and Bit Map Indexes for both — yawn old hat. Parallel Query Optimizer – been there, seen that for a while.

Greenplum has JDBC/ODBC/OLE interfaces. Oracle has those too, plus a full complement of Pro*C (or many other languages) embedded pre-compiled 3GL languages. Oracle is well supported by Shell Scripts like PHP or PERL that have their interfaces to Oracle. Slight advantage to Oracle. But the point is, Oracle professionals have done this for more than a decade.

External Tables too are a feature in both databases.  GreenPlum HD uses the External Table to provide HDFS access in GreenPlum via SQL or other in-database features. Now I had not previously thought to try and use HDFS with Oracle. But the External Table is precisely the feature I would use. Can it be done? A look at Oracle’s documentation answers that:


CREATE TABLE [schema.]table
   ( column datatype, ... )
                        DEFAULT DIRECTORY directory
                        ACCESS PARAMETERS
                            ( PREPROCESSOR HDFS_BIN_PATH:hdfs_stream access_parameters
                        ... )
                        LOCATION (file1,file2...)

So I recommend that companies fell free to utilize Oracle consultants on Greenplum databases. There is an awful lot of overlap that the Oracle specialist can leverage from his/her background and transfer to the Greenplum database.

Of course, for companies without Greenplum, it looks like you can use many of the same features already in Oracle including using HDFS filesystems with External Tables.

So get to that BigData, your friendly Oracle expert can help you.

July 28, 2013

FamilySearch.Org — #Genealogy, #STEM, #Database

by C. Michael Eliasz-Solomon

Dateline 22 Jul 2013 — FamilySearch.Org  New Database

FamilySearch.Org has some new databases (don’t they always — they are amazing). One in particular caught this jester’s eyes.

United States, National Register of Scientific and Technical Personnel Files, 1954-1970,

By training and long years in the field, Stanczyk is a STEM worker. So I was drawn to this database. But who did I know had a degree and was a professional in 1954-1970 ? How about one of my favorite authors … in a register of Science / Technical professional? Well, yes — if you thought of  Isaac Asimov .

So what data is in this database …

If click on the link, then query on Isaac Asimov, you will see:


July 14, 2013

A Bit of Blog Bigos … #Genealogy, #Polish

by C. Michael Eliasz-Solomon

Stanczyk has been a bit busy since the 4th of July! So forgive me if I play a bit of catch-up on my blog.

bigos_huntersstewA bit of bigos (recipe) !!

Let me point out that in June the Polish Archive completed their latest update on: ♥ .

Unfortunately, it did not include anything from the old wojewodztwo: Kielce (now in SwietoKrzyskie). See the image of the drop down menu below (not full listing but to give you an idea on what is in and how that is somewhat limited for researchers like Stanczyk. I hope another phase will commence soon!



Meanwhile on:

♥ – They added the death records from 1875-1908 for Pacanow parish to their Geneszukach database. Previously they had added the Birth and Marriage records. These are transcription / indexes, not actual church record images such as you find in their Metryki database.

Still I have found dozens of Eliasz (and … Gawlik, Gronek, Hajek, Kedzierski, Leszczynski, Major, Paluch, Wlecial, Zasucha, etc.) that I was previously unaware of. Now I will need to get the actual images in order to make sense of these indexes and the new people in order to add them to the family tree.

Enjoy the bigos. Smaczne (delicious)!

June 2, 2013

Polish Vital Records On-line — A Survey #Genealogy, #Polish

by C. Michael Eliasz-Solomon


Stanczyk is a bit uncertain. It seems like every day there are some new vital records indexes or even actual register scans themselves made available from congregations all over the Central European — Jewish, Catholic (Roman & Greek), Orthodox, Lutheran/Evangelical lands that make up Poland or a land that was once within the Polish-Lithuanian Commonwealth (the 1st Republic) or any of the variations between those times. So I thought I would step back and take stock of what was available. Yes, I know this will be out of date by tomorrow. But here is a quick & dirty, handy reference list of where to go looking. Clip & Save.

Cut— — — — — — — — — —

Poland – Archives & Genealogical Societies

AGAD Księgi metrykalne – Eastern Borderlands (Ukraine, Russia Jewish Pale, etc.) —

(scans by Sygn.: )

Prussian Poland Parishes

BASIA - – State Archives in Poznan, the Wielkopolska Genealogical Society (WTG “Gniazdo”) project.

Poznan Marriage Project –

Pomorskie Towarzstwo Genealogiczne -

All Poland & Eastern Borders (PTG)

GeneSzukacz  / Geneteka (indexes, some scans) –      &

METRYKI (parish register scans)–

Szukajwarchiwach (Poland’s National Archives online) -

This is the latest project and is shooting to have 5.8 Million records by the end June (this month) scanned and on-line by Polish Archive or National Museum.

Jewish Record Indexing (JRI) –

The venerable project with new life provides indexes to registered users (free) and then you can purchase the actual church record. Great for Jewish Pale & Russian Poland, plus so much more. –,list,4,1 (AP GRODZISK). Archive in Grodzisk Mazowiecki (Russian Poland parishes near Warsaw).

Family Search.Org 

Besides the 5 parishes below, you might want to have a look at holdings for:

Austria, Germany, Russia & Ukraine

Poland, Częstochowa Roman Catholic Church Books, 1873-1948 Browse Images 14 Feb 2013
Poland, Gliwice Roman Catholic Church Books, 1599-1976 Browse Images 14 Feb 2013
Poland, Lublin Roman Catholic Church Books, 1784-1964 99,510 14 Feb 2013
Poland, Radom Roman Catholic Church Books, 1587-1966 18,916 21 Apr 2013
Poland, Tarnow Roman Catholic Diocese Church Books, 1612-1900 1,002,155 6 Jan 2012

Did I miss any? Email Me … Proszę !

Other (Inne) – from Valerie Warunek (PGSM). Database of Indexed church records (birth/urodzenia, marriage/malzenstwa,  death/zgony) from Lubelskie wojewodztwo. No scans (skans), but it does have record (akt) #’s.

May 21, 2013

Pacanow 1875-1908 Index

by C. Michael Eliasz-Solomon

St. Martin -  Pacanow Church about 1918

St. Martin – Pacanow Church about 1918

Stanczyk, has been sifting through the Index created on in their Geneszukacz database. Alright, only the Births Index, so far.

I see they have a total of nearly 7,300 people from those years (1875-1908) in their Birth Index. From Adam … Żyp . There were 58 ELIASZ in their index.Notice they used ELIASZ and not ELIJASZ. I found that interesting. They removed ‘J’ when they produced the index. Was that an error? Or was the indexer an expert? Because, in my heart of hearts, I believe the name (at least back to 1690) was ELIASZ.

It was only since 1869 when the Russian Empire forced Poland to keep records in Russian (Cyrillic) that the ‘J’ appeared from the Russian character ‘я’ (Ya) that ELIASZ became элияшъ .  элияшъ is transliterated in a Latin alphabet as ‘Elijasz’.

I only wanted to mention this as while I believe the translated properly produced the index with respect to ELIASZ; You will need to realize that finding the record in Russian/Cyrillic, you will need to look for a different translation (i.e. ELIJASZ/элияшъ) in the indexes and the actual church records.

So now I have an index of ELIASZ born in Pacanow in the years 1875-1908. Now what? I compared the list of 58 with what I already had/knew. I saw an overlap of 22 people. So I have 36 new ELIASZ to resolve and add into the family tree. My options are:

  1. Write to Pacanow parish and request specific records (since I have year, Akt#),  
  2. Write to Polish National Archive (again with detailed info),
  3. Hire a genealogist in Poland,
  4. Go on a genealogical tour to Poland.

The year range 1875-1908 is not completely in LDS microfilm. Although 1875-1884 is in LDS MF #’s:

1192351 Item 10,    1192352 Items 1-2,   1807621 Items 8-11,    1807622 Items 1-3

So doing research in a local Family History Center or at the Family History Library (Salt Lake) is not an option for the remaining 36. So I now have better options for remote research.

My List of 58 ELIASZ.

May 19, 2013 – Geneszukacz Database, Pacanow 1875-1908 — #Polish, #Genealogy, #Pacanow

by C. Michael Eliasz-Solomon

Genealodzy_plOn  Stanczyk  saw that they have an updated GENESZUKACZ database.

My ancestral village, PACANOW, was indexed for BIRTHS (1875-1908). I was able to verify it was correct with my grandfather (whose Birth Record I have) and a few others. I also found some I did not know about !!!   I only wish they had the images (like in METRYKI database). Thank you: Wojciech Liśkiewicz (who I think was the indexer)!

Later in the day they(he) also added MARRIAGES(1875-1908) too.



See Also:

Domagala, Hajek, Kedzierski, Odomski, Paluch, Poniewierski, Siwiec, Wlecial, Wojtys, Zasucha, Zdziebko, Zwolski

May 12, 2013

♥ Happy Mothers Day ♥ — #Genealogy, #German, #Croatia, #Vespek

by C. Michael Eliasz-Solomon


Stanczyk, was not intending to write a blog post today. I hope Genealogy Moms are having a wonderful day today  … too.

Yesterday, I was researching on On a lark, I thought I would look at Croatia. In particular at Tenje. I did that because my maternal grandmother, Roza Göttler (aka Gottler/Goettler/Gettler). From her ship manifest, I knew her to come from Tenje (which was Austria-Hungary, then Jugoslavia, now presently Croatia). This explains the ever changing ethnicity throughout the US Federal Censuses. I did indeed find Gottlers in Tenje. I did not find my grandmother’s parents or my grandmother … unfortunately the years available online would not meet my needs. But something unusual happened. I found other affiliated family names: Eisenbeiser and Elter. So I am now convinced that Tenje (the Roman Catholic records) is where I will find my maternal grandmother.

That was so uplifting, on a lark, I thought I’d search for my maternal grandfather’s village. His was a bit of a problem too. Differing country names (like Roza Gottler), but his village name changed often too, so even though I had ship manifest, Declaration of Intent, and finally a Petition for Naturalization, I was still uncertain where he was from. I was pretty sure he was from the same area as Roza Gottler. My paternal grandparents were both married once, before they married each other and had my mother. So my grandfather emmigrated alone and my grandmother emmigrated with her first husband (John Reiner). Over the years, I developed many clues which I collected even though they did not fit together. This weekend, the clues came together! These stray clues allowed me to verify that the records I was viewing were my own family. What a gift on Mother’s Day weekend. I found both of her family parents’ families  this weekend!

It turns out that my grandfather was born in Sarvas (now in Croatia) and in the same district as Tenje. So all those sources: Sawas is from Ship Manifest , then  Storvish is from Declaration of Intent, and  Dowash is from the Petition for Naturalization. The first Vespek birth record I found spelled the village as Starvas. These are all the same place! Some were slightly misspelled. Now I can see it. So in the same FamilySearch project in two different villages I found my maternal lines. Some direct lines, some indirect branches, others are affiliated families.

So I have set a fairly high level of confidence in these findings. As such, I believe I have found my Great-Grandfather Vendelin Vespek’s birth record. This is not 100% certain and I have to find 1 or 2 missing pieces to make it a 100% certain. For those who are second (or 3rd) cousins researching in the Vespek family tree pay attention to the remainder and download the image at the top.


Croatia, Church Books, 1516-1949 Roman Catholic (Rimokatolička crkva), Sarvas

Corresponding LDS MF #’s – 1739003 Items 4-5,  1739004 Items 1-7

Sarvaš Births (Rođeni) 1847-1865  [for Vespek, Kasper, Kantner, Fechtig, Emert, Platz, Zorn]

URL: FamilySearch Sarvas, Croatia  [image 66 of 298]

Birth 8th / Baptism 9th – November – 1858

Vendelin son of Vendelin Vespek & Catherine Kaschper (aka Kasper)
born in Sarvas, House #43

Godparents:  Tobias Jobst & Joanna Kreines

See Also …

Tenje (Osijek) – [for Gottler, Eisenbeiser, Elter]

URL:  Tenje


Even though most of the records are in Latin, there are still records in Croatian.So for my Polish genealogy researchers, I would hasten a tip. As I was doing this I saw month names that were close to month names for Polish. Croatian is a Slavic language (albeit Southern Slav). So when I saw LISTOPAD (Croatian), I was immediately thinking NOVEMBER (in English), because LISTOPAD in Polish = November in English. But in Croatian, LISTOPAD = October. Surprise!

From Google Translator:

January, February, …, December – (English)

Sijecanj, Veljaca, Ozujak, Travanj,  Svibanj, Lipanj, Srpanj, Kolovoz, Rujan, Listopad, Studeni, Prosinca – (Croatian)

April 30, 2013

Michigan, Death Certificates, 1921-1952 — #Genealogy, #Michigan

by C. Michael Eliasz-Solomon

Stanczyk, was overjoyed at the announcement of the newest database:

Michigan, Death Certificates, 1921-1952

The URL / Link is: [bookmark it]


They just published it 29 April 2013 [after some issues were discussed]. No your eyes are not playing tricks, the website has had a makeover recently. It may be a unsettling if you have not visited the site in a while, but persevere, it is worth it.

Hurry and grab your dead relatives in case any controversy causes this database to disappear!


April 23, 2013

FamilySearch Indexing: They Reached A Billion

by C. Michael Eliasz-Solomon

FamilySearch Indexing reached their first billion records online. Congratulations FamilySearch!

logo.gif FamilySearch Indexing: Thanks A Billionopen.aspx?ffcb10-fe561074726701757613-fde81c797d6506787c167670-fe6315707166057a711d-fe5a17707266007a701d-fe2c13767767017b761770-ffcf14&d=10026

Thanks A Billion

The winners
Thank you for contributing to the billion! We did it! We reached a major milestone of one billion records indexed and arbitrated since the launch of FamilySearch indexing in September of 2006. We are grateful for the many volunteers who dedicate their time and efforts to make these records freely available for online research. Languages

Deutsch Italiano
Español Русский
Français Português
日本語 Polski
Nederlands Svenska

BillionsBadge_EN.pngKenneth B. (California, United States), Brittney S. (Idaho, United States), and April R. (Alberta, Canada) were the lucky ones to index and arbitrate the billionth record! They will receive a FamilySearch backpack stuffed with FamilySearch goodies. We also want to thank all the volunteers who have contributed to the billion records with a FamilySearch indexing badge. You can download your free badge at

It took us seven years to reach the first billion. How long do you think it will take us to reach the next billion? The advances of technology and the dedication of our volunteers have increased the speed in which we can process and deliver records for publication. Join the global effort to make the next billion records available for family history research. Start indexing now!


FamilySearch indexing is the largest free collection of online resources for family history research. With billions of historical records, powerful search tools, family trees, and an active community, helps everyone discover, preserve, and share their family history.You received this message because you are a registered volunteer with FamilySearch indexing, signed up to receive e-mails, or received this as a forward. The original was sent to mike.

If you have questions, comments, or concerns, please contact FamilySearch at support.

LDS Logo

I have been an intermittent contributor to this and other genealogy indexing projects. Doing RAOGK helps others and because of the interconnectedness of our family trees, it may ultimately help our own families. Congratulations again to FamilySearch!

March 24, 2013

Gazetteers, Maps, and Genealogy — #Polish, #Genealogy, #Maps, #Gazetteer

by C. Michael Eliasz-Solomon

Block_Stanczyk, has been busy revisiting the Metryk (metrical, vital records) images from of the various parishes/synagogues [hereafter I just use ‘parish’ as shorthand for ‘parish/synagogue’]. As my blog, Waiting For Polish Archives 2.4 M Scans (March 18th, 2013), indicated, I have been exhausting the possibilities for Biechow & Zborowek parishes in the Buski (Busko-Zdroj) powiat. The images are clearer, so I am replacing my existing images with these much better images. In some cases, I have found that the images of the Polish paragraph format provide me with additional details over what may have been available via only a Latin Box format copy that I might have previously had. At the very least, I have corrected a few mistakes of translation due to unreadable portions from prior microfilm I have read from/taken pictures of. So I strongly encourage others to make this effort.

I have been using the Metryk database and looking at the images/scans. Sometimes you have to look at dozens of images because there is NO index. But most of the collection (post 1812) have indexes. If you see SKU (that means index/skorowidz of births/urodziny), likewise  for SKM (for marriage), and SKZ (for death) indexes. Sometimes indexes spread across multiple pages, so you may see SK1, SKa (names begining with the letter ‘A’) or SKU1, etc. SO use these indexes to look for your family names, then just load up the scan of the akt (record) number for your ancestor — no need to search  through a multitude of images.

I have also used Geneszukacz as another kind of index to search for family names. These indexes are nice because I can catch ancestors getting married (or dying or giving birth) in another parish that I might not have known to check. If this previously unknown parish is one that has scans, then I go directly to the year/event for that parish and go to the akt specified in Geneszukacz!

So that is all great and I exhort you to do this.

But these new, previously unknown parishes. Where are they? How far away from the ancestral village are they? That is when I need a gazetteer (check out Stanczyk’s Gazetter page) or a map. If you have not been to the Polish War Map Archive (Archiwum Map Wojskowego), then today’s blog is your reason to do so. I have a map on my wall of my ancestral villages. The map’s name is: STOPNICA_PAS47_SLUP32. In fact, I use their MAP INDEX, 1:100,000 scale map tiled in squares ( Please NOTE these map images are from about 4MB to 7MB in size. Make sure you are at a Free WiFi cafe where you can use a high-speed and the large band-width for the map images you download.

When you see, PAS think ROW and when you see SLUP think COLUMN. This is a big Cartesian Grid (or computer types can think 2d-array). It turns out that STOPNICA_PAS47_SLUP32 has: Biechow, Pacanow, Ksiaznice, Zborowek, Swiniary, Szczucin, Beszowa, Olesnica, and STOPNICA. In fact, that one map has many more parishes than those that I enumerated. I have a small snippet of the Map Index below (you can click on the image and it will take you to the actual map index):


So I found an ELIJASZ ancestor in Koniemloty parish getting married, who was from PACANOW parish. Now from the Metryk web app, I knew Koniemloty was in STASZOW powiat. So I go to the Map Index and look at the grid near STOPNICA (P47_S32) and voila, STASZOW is the box due north of STOPNICA in PAS46_SLUP32. If you cannot locate you powiat that way, then you must drop back to (an interactive map that I have raved about before) and look for KONIEMLOTY (do not need to use diacriticals) to get the relative feel that it is north or east (or north-east). So any way, STASZOW_PAS46_SLUP32 is the map for KONIEMLOTY parish. Notice PAS46 is one row less than PAS47 (of STOPNICA). PAS decreasing is going north, PAS increasing is going south. Going east from STASZOW, we see the SLUP increases to SLUP33  (SANDOMIERZ) or going west the SLUP decreases to SLUP31 (PINCZOW). So now you can now work  with the Map Index using the cardinal directions by adding/subtracting to/from the rows/columns.

P.S. Since this is the Passover (Pesach) / Easter (Wielkanoc) season, let me honor my wife (Tereza) by pointing out that her paternal grandfather, Benjamin Solomon, had as a birth village, Proskuriw (aka PŁOSKIRÓW, Хмельницький/Khmelnitski – now in Modern Ukraine). This village is shown in the lower right-hand corner of my map snippet (PAS51_SLUP44).

March 19, 2013

Polish State Archives – Numbers — #Genealogy, #Polish, #Archives

by C. Michael Eliasz-Solomon

Polish State Archives (Archiwum)

The Polish State Archives via the National Digital Archives (NAC) recently announced the plans to release 2.4 Million scans of metrical book records online. In order to use this database ( you will need to know the Archive’s number of the Regional State Archive that you are interested in (i.e. the Archive that has the data/scans of your ancestral village).

Stanczyk could not locate such a list. So this jester created one. Knowing that the IZA had a drop down menu of Archives,  I went there. Sure enough it had the archives … and the archive’s number. But it was a drop down menu and I could not copy/paste from the drop down menu. How could I get the data?

I put on my propeller beanie and it occurred to me that the HTML of the web page would have that data for the menu. So I looked at the page source and voila. After some editing to remove HTML tags I built the required list for all of to use with the new 2.4 Million records in

The list is below. One note, I notice that the list is out of date in the sense that there are regional archives that no longer exist. For example, I know to my own pain, that the Kielce regional state archive (Kielce Panstowe) office (oddzial) in Pinczow  (#23 in the list) was closed and the records moved to Kielce (the main office, #21). So please take note of this, as I am sure it happened to other offices as well.

Here is the PDF of the listed parishes/synagogues being scanned (for March):’ASC1_02_2013v.3.pdf

Archive Number List

1 Archiwum Glówne Akt Dawnych (1)
2 Archiwum Akt Nowych (2)
4 Archiwum Panstwowe w Bialymstoku (4)
5 Archiwum Panstwowe w Bialymstoku Oddzial w Lomzy (5)
6 Archiwum Panstwowe w Bydgoszczy (6)
8 Archiwum Panstwowe w Czestochowie (8)
9 Archiwum Panstwowe w Elblagu z siedziba w Malborku (9)
10 Archiwum Panstwowe w Gdansku (10)
11 Archiwum Panstwowe w Kaliszu (11)
12 Archiwum Panstwowe w Katowicach (12)
13 Archiwum Panstwowe w Katowicach Oddzial w Bielsku-Bialej (13)
14 Archiwum Panstwowe w Katowicach Oddzial w Cieszynie (14)
15 Archiwum Panstwowe w Katowicach Oddzial w Gliwicach (15)
16 Archiwum Panstwowe w Katowicach Oddzial w Oswiecimiu (16)
17 Archiwum Panstwowe w Katowicach Oddzial w Pszczynie (17)
18 Archiwum Panstwowe w Katowicach Oddzial w Raciborzu (18)
20 Archiwum Panstwowe w Katowicach Oddzial w Zywcu (20)
21 Archiwum Panstwowe w Kielcach (21)
22 AP w Kielcach Oddzial w Jedrzejowie – Oddzial zlikwidowany, akta przeniesione do AP K… (22)
23 AP w Kielcach Oddzial w Pinczowie – Oddzial zlikwidowany, akta przeniesione do AP Kie… (23)
24 Archiwum Panstwowe w Kielcach Oddzial w Sandomierzu (24)
25 AP w Kielcach Oddzial w Starachowicach – Oddzial zlikwidowany, akta przeniesione do A… (25)
26 Archiwum Panstwowe w Koszalinie (26)
27 Archiwum Panstwowe w Koszalinie Oddzial w Slupsku (27)
28 Archiwum Panstwowe w Koszalinie Oddzial w Szczecinku (28)
29 Archiwum Narodowe w Krakowie (29)
30 Archiwum Narodowe w Krakowie Oddzial w Bochni (30)
31 Archiwum Narodowe w Krakowie Oddzial w Nowym Saczu (31)
33 Archiwum Narodowe w Krakowie Oddzial w Tarnowie (33)
34 Archiwum Panstwowe w Lesznie (34)
39 Archiwum Panstwowe w Lodzi (39)
41 Archiwum Panstwowe w Lodzi Oddzial w Sieradzu (41)
42 Archiwum Panstwowe w Olsztynie (42)
45 Archiwum Panstwowe w Opolu (45)
48 Archiwum Panstwowe w Piotrkowie Trybunalskim (48)
49 Archiwum Panstwowe w Piotrkowie Trybunalskim Oddzial w Tomaszowie Mazowieckim (49)
50 Archiwum Panstwowe w Plocku (50)
51 Archiwum Panstwowe w Plocku Oddzial w Kutnie (51)
52 Archiwum Panstwowe w Plocku Oddzial w Leczycy (52)
56 Archiwum Panstwowe w Przemyslu (56)
58 Archiwum Panstwowe w Radomiu (58)
59 Archiwum Panstwowe w Rzeszowie (59)
60 Archiwum Panstwowe w Rzeszowie Oddzial w Sanoku (60)
61 AP w Rzeszowie Oddzial w Skolyszynie – Oddz. zlikwidowany, akta przeniesione do AP Rz… (61)
62 Archiwum Panstwowe w Siedlcach (62)
63 Archiwum Panstwowe w Suwalkach (63)
64 Archiwum Panstwowe w Suwalkach Oddzial w Elku (64)
65 Archiwum Panstwowe w Szczecinie (65)
66 Archiwum Panstwowe w Gorzowie Wielkopolskim (66)
67 Archiwum Panstwowe w Szczecinie Oddzial w Miedzyzdrojach (67)
68 Archiwum Panstwowe w Szczecinie Oddzial w Stargardzie Szczecinskim (68)
69 Archiwum Panstwowe w Toruniu (69)
71 Archiwum Panstwowe w Toruniu Oddzial we Wloclawku (71)
72 Archiwum Panstwowe Warszawy (72)
73 Archiwum Panstwowe Warszawy Oddzial w Grodzisku Mazowieckim (73)
75 Archiwum Panstwowe Warszawy Oddzial w Lowiczu (75)
76 Archiwum Panstwowe Warszawy Oddzial w Mlawie (76)
78 Archiwum Panstwowe Warszawy Oddzial w Otwocku (78)
79 Archiwum Panstwowe Warszawy Oddzial w Pultusku (79)
82 Archiwum Panstwowe we Wroclawiu (82)
83 Archiwum Panstwowe we Wroclawiu Oddzial w Jeleniej Górze (83)
84 Archiwum Panstwowe we Wroclawiu Oddzial w Kamiencu Zabkowickim (84)
85 Archiwum Panstwowe we Wroclawiu Oddzial w Legnicy (85)
86 Archiwum Panstwowe we Wroclawiu Oddzial w Lubaniu (86)
88 Archiwum Panstwowe w Zamosciu (88)
89 Archiwum Panstwowe w Zielonej Górze z siedziba w Starym Kisielinie (89)
90 Archiwum Panstwowe w Zielonej Górze Oddzial w Wilkowie (90)
91 Archiwum Panstwowe w Zielonej Górze Oddzial w Zarach (91)
93 Archiwum Panstwowe w Gdansku Oddzial w Gdyni (93)
307 Muzeum Pierwszych Piastów na Lednicy (307)
309 Archiwum Uniwersytetu Mikolaja Kopernika w Toruniu (309)
324 Stowarzyszenie Archiwum Solidarnosci (324)
325 Zarzad Oddzialu Zwiazku Sybiraków w Lodzi (325)
327 Glówna Biblioteka Lekarska im. Stanislawa Konopki (327)
701 Instytut Józefa Pilsudskiego w Ameryce (701)
702 Polski Instytut Naukowy w Nowym Jorku. Biblioteka i Archiwum im. A. Jurzykowskiego (702)

March 18, 2013

Waiting For Polish Archives 2.4 M Scans …

by C. Michael Eliasz-Solomon

PTG_Metryk_SwietoKrzyskie -

Stanczyk reported on 11 February 2013 , that the Polish Archives would be posting 2.4 Million scans of church/synagogue metric books on the Internet. The first phase which is due to be complete in March (this month) does not include any scans from Kielce Archive, which means that there will not be metric book scans of my ancestors in the first phase (Let’s be hopeful for something in June).

Well what can you do if your ancestors are from SwietoKrzyskie (the area from the old wojewodztwo Kielce)?

The website (polish website – some English user interface available) has a project called the Metryk project. Their Genealogical Society’s members are scanning metryk records from churches/synagogues. Once the scans are in place, they then index the image into their Geneszukacz databases that are searchable by Name, Event Type (B/M/D), Place. So you have two options Search Geneszukacz by index or scan the available images in Metryk (images are of Latin, Polish, or Russian language church records).

So what is available for SwietoKrzyskie? That information is shown in the above image. For this jester, I go to Buski (aka Busko-Zdroj).  There are, as of March 18th, 2013 a total of five parishes that have some scanned records (metryk / aktow).


You can see the five parishes in the image are:

Biechow,  Busko-Zdroj,  Dobrowoda, Gnojno,  Zborowek.

The right most column gives the years for which there are scanned records. For my research, Biechow and Zborowek were the most helpful. What I noticed was the Biechow images were much better than the images that the LDS had microfilmed. See my inventory of Biechow  records blog article (19 July 2011).

In fact, I was able to read some records better than previously and correct some of my translations. By the way, if you are researching the same area as Stanczyk, then just click on the Powiat buski image and it will take you to the website for that Buski powiat. So whether you have seen these images before or not, I would encourage you to look again at these quality images in the Metryk Project.

Hey PTG, can you guys PLEASE scan and index: Pacanow,  Swiniary,  Szczucin, and Stopnica parishes too?

I hope the Polish National Archives will be scanning records in the Kielce Archive for June proszę (please)?

March 13, 2013

The Many [Mis]Spellings of Pacanow … — #Genealogy, #Slavic, #Pacanow

by C. Michael Eliasz-Solomon

One of the difficulties of locating records or data on a Polish (or Czech, Russian, Lithuanian, Ukrainian, etc.) ancestor is the many ways a name can be spelled, misspelled, mistranscribed, indexed, etc. in a database. This is why you have to be creative when trying to locate your data.

Here is an example (from my paternal grandfather’s birthplace): Pacanow. That is the English rendering. In Poland it would be written as Pacanów. Now diacriticals aside, how many possible ways can I find Pacanow in Ellis Island (probably similarly for as well)? OK, you asked …

Bacanow Pacanszka
Pacanam Pacanu
Pacanan Pacauow
Pacananska Pacona
Pacanaw Paconon
Pacanciv Paconow
Pacani Pacunow
Pacanica Paczanow
Pacanin Pacznow
Pacannon Paeanow
Pacanoer Paezanov
Pacanon Paezanov
Pacanoro Paezanow
Pacanoska Pasanov
Pacanou Pasanow
Pacanov Pasonaw
Pacanow Pazanoz
Pacanowa Pocanaer
Pacanowe Pocaniz
Pacanowic Pocanoa
Pacanowka Pocanor
Pacanowka Pocanow
Pacanowki Preanon

Those are the ones I have found so far. That is 47 combinations! Now admittedly reading the handwriting from those ship manifests is difficult even when I am pretty sure what is being written;  So I can feel for the transcribers / indexers who harvest the data and do the data entry into some database.

Now, no searching by American Soundex,  Daitch-Mokotoff Soundex, or even Beider-Morse phonetic matching or even using wild-card searches, not even if you had regular-expression searches (like Oracle databases have) would I have found all of those. I do not know what to tell you to do. Be creative and persistent. Look at adjacent letters on a keyboard (for mis-typings) as data is entered. Look for letters that are swapped (i.e.  Eliasz vs. Elaisz) — mistyped or dyslexic. Just keep looking. I found ‘Bacanow’, because I said what might an handwritten letter ‘P’ look like to somebody? Of course, ‘R’ and ‘B’ suggested themselves to  my mind. No ‘Racanow’, but sure enough out popped a ‘Bacanow’. So you never know.

Now Stanczyk mentioned Pacanow, because I thought I was being slick and said, “What if I cannot think of all the ways a NAME can be misspelled?”. My answer was, “I know, I’ll just search on everybody coming over from the village of P-A-C-A-N-O-W.” Of course, as you might have guessed now I had a meta-problem because now I had to come up with all of the ways that Pacanow could appear. Well like the riddle, “How many licks does it take to get to the center of a Tootsie-Pop?”, I have an arbitrary answer … 47.


I now have two spreadsheets. My first spreadsheet is my work-in-progress on the ZASUCHA of Niagara Falls SNA. The second spreadsheet I have is a rather large spreadsheet of all of the names from Pacanow (and truth be told Biechow, Piestrzec, Wojcza, …) and all of the surrounding villages that came through Ellis Island that I have found so far [plus a few mis-matches].

January 26, 2013

RootsMagic iPhone/iPad App — #Genealogy #Software #Review, #RootsTech

by C. Michael Eliasz-Solomon

RootsMagicAppThis jester has been a big proponent of Ubiquitous Genealogy – i.e. genealogy is portable and everywhere. I have used the Ancestry App for a long while and am well satisfied. They use a concept of synching the App with  your tree and their website. Now that the kinks are worked out, I am well satisfied. There are also MyHeritage and Heredis  Apps too. These do not synch over the “air”. You need to use your iTunes application on your desktop/laptop to move files into the App’s “sandbox” via synching your iPhone/iPad with the laptop/desktop over the iPhone/iPad cable. Tethered synching is ok but a hindrance.

Ok so the new App on the block is an offering called RootsMagic.   Stanczyk likes the Roots Magic laptop application as a full blown offering for working on your genealogy and documenting the tree and finding data on the Internet and keeping track of to-do lists, publishing your tree on CD/Web and all sorts of work that you do when your research spans years (or decades) – does anyone ever finish their genealogy? Its modern and uses Universal Character sets (so us Slavic Researchers can use our slashed Ł’s  or Cyrillic  Я’s) and other features that the Internet Genealogists have grown up with.  So I was hopeful when I received an email from Roots Magic touting their iOS offerings – Its free!

The App starts with the familiar Roots Magic splash screen that you may have grown accustomed to from the laptop application. You are then presented with a list of files from their sandbox (ugh, tethered synching). Once you select a file to work with, your family tree is presented in a Pedigree form (with three generations visible on iPhone/ four generations on iPad). At the top left is a green/white button with three lines (see image)  that will allow you to pick a particular person with whom you wish to work upon. At the bottom of the screen are four buttons:

Files,   Views,   Lists,   Tools

Files – Lets you select the family tree file you want to on from your Device or from DropBox (a cloud-based file storage service). It also has HELP (files??) which tell you how to use your Device or DropBox to get a file loaded into the App. Sadly,  the RootsMagic app does not read standard gedcom (ged)  files. It only reads files with rmgc extension (i.e. created by Roots Magic laptop application). However, it does load their database extremely fast from those rmgc files.

Views – Lets you choose to view the data in a PEDIGREE tree  or a FAMILY tree or in a DESCENDENTS outline  or in the detailed FACTS (events), NOTE, direct family members of the current INDIVIDUAL. I prefer working in FAMILY (as seen in image) view mode, then switching to INDIVIDUAL view mode for any details on that person. Clicking on NOTE really gives you access to NOTE(S), SOURCE(S), and MEDIA for that individual (and a BACK button at the top to return to INDIVIDUAL view mode).

Lists – This just gives a list of your: Sources, To-Dos, Research, Media, Addresses, Repositories, Correspondences, and PLACES. I liked places (which showed that this jester really needs to make his Places (Locations) conform to some kind of standard).

Tools – Date Calculator, Relationship Calculator, Soundex Calculator, and Calendar. Unimpressive to say the least. Lest you get your hope up, the Calendar tool only displays the Calendar for a Month/Year of your choice [I did not verify the Julian/Gregorian boundary to see if it calculates a proper month calendar for dates before 1582]. It was not worth the effort as I did not see why I would want to see what day  June 3rd, 1700 would fall on (Thursday) if you are eyes are young or your glasses are a good prescription to read the day name. Otherwise, you not notice the day names on an iPhone  [perhaps a black font, instead of gray, would give better contrast]. The Soundex is only American Soundex – why not Daitsch-Mokotoff or Bieder-Morse codes too? Really, we Slavic researchers get short shrift in the software world.  Never fear, just create a desktop icon of Steve Morse’s Soundex page to see all three Soundex/Pattern Matching methods for your family names.

iPad vs iPhone

For some reason the iPad interface treats the buttons (Files, Views, Lists, Tools) differently on the iPad. That was a bit confusing until I got used to the difference. Rotating the iPad to landscape, also brings the Surnames/Search view along side whatever view you are in. The Calendar is a bit easier to see on the iPad, but I’d still like to see the day name text in black (or at least a MUCH darker gray).

UbiquitousGenealogyThe app is strictly for viewing your family tree (et. al.). There are no tools for modifying the tree for re-import into the desktop application. Shortcomings aside, it is still a very good first effort by Roots Magic. If you have the Roots Magic laptop application, then download the free app for your smartphone or tablet and go Ubiquitous. If you do not have the Roots Magic laptop application and do not have a way to get your ged converted to Roots Magic format (rmgc) then do NOT bother to download the app – you will not be able to use it.

P.S.  Do you spell  “DESCENDENT”  – as  D-E-S-C-E-N-D-E-N-T   or    D-E-S-C-E-N-D-A-N-T ?  Both spellings are correct, but I guess I use “DESCENDANT” all of the time and so the Roots Magic use startled me.

I also would love to see the REUNION app (the Mac Software vendor) make their iOS App free or low-cost – then I’d review it here too. I am a BIG Apple eco-system fan and as such have used REUNION Mac software for a very LONG time. I would be remiss not to mention that REUNION App does exist, but its cost is a bit steep relative to the other iPhone genealogy APPs in this article.

September 2, 2012

Genealogy Volunteerism – FamilySearch Indexing — #Genealogy, #Volunteerism, #RAOGK

by C. Michael Eliasz-Solomon

Yesterday’s blog, I mentioned briefly one project that I was a volunteer for at the PGSA. Today, Stanczyk wanted to mention that genealogical volunteerism can be a Random Act Of Genealogical Kindness (RAOGK).

Of course, I know that the original RAOGK web site is currently offline (due to the unfortunate demise of the founder). Well there are many ways to be RAOGK genealogist. You can volunteer for a local genealogical society. You can help by answering an email or a questions in a forum or a Yahoo Group or a Tweet from Twitter or a question on a Facebook Group. But, did you know that Family Search has a volunteer umbrella organization for all kinds of Genealogy Indexing projects? Well, they do. They have a computer app, FamilySeaching Indexing or a smartphone app (iPhone & Android) and they have many projects spanning all sorts of locales that may be of interest to you or your family.

My picture below is my modest contribution, across a number of projects so far in 2012. Why not give it a try yourself?


Get every new post delivered to your Inbox.

Join 476 other followers

%d bloggers like this: