Difference between revisions of "Geonames"

From Gramps
Jump to: navigation, search
m (format)
Line 1: Line 1:
[[Category:Developers/General]]
+
This is intended to be a place to discuss place names in GRAMPS.
 
 
==GEONAMES==
 
 
 
This is intended to be a place to discuss place names in Gramps.
 
  
 
===Work already done===
 
===Work already done===
Line 23: Line 19:
 
So the computer application will think in reverse to us, preferring to start with a country, then finding the names of the places sub-ordinate to it, and so on. Accordingly, the database setup needs to reflect this. As an example:
 
So the computer application will think in reverse to us, preferring to start with a country, then finding the names of the places sub-ordinate to it, and so on. Accordingly, the database setup needs to reflect this. As an example:
  
{| class="wikitable" style="margin: 1em auto 1em auto" table border="1"
+
{| {{prettytable}}
 
|-
 
|-
 
!place#!!parent#!!level!!place!!long!!lati
 
!place#!!parent#!!level!!place!!long!!lati
 
|-
 
|-
!1!! 0|| 0|| USA|| W100.00|| N39.00
+
|1!! 0|| 0|| USA|| W100.00|| N39.00
 
|-
 
|-
!6!! 1|| 1|| California|| W119.300|| N36.000
+
|6!! 1|| 1|| California|| W119.300|| N36.000
 
|-
 
|-
!7!! 6|| 2|| Los Angeles|| W118.230|| N34.05
+
|7!! 6|| 2|| Los Angeles|| W118.230|| N34.05
 
|-
 
|-
!8!! 7|| 3|| Beverley Hills|| W118.400|| N34.07
+
|8!! 7|| 3|| Beverley Hills|| W118.400|| N34.07
 
|-
 
|-
!25!! 8|| 4|| 135 Copley Place|| W118.4224|| N34.0767
+
|25!! 8|| 4|| 135 Copley Place|| W118.4224|| N34.0767
 
|-
 
|-
 
|}
 
|}
Line 44: Line 40:
  
 
A well-designed database could derive from a GEDCOM using the correct structure:
 
A well-designed database could derive from a GEDCOM using the correct structure:
 
+
<pre>
0 INDI @987@<br>
+
0 INDI @987@
1 BIRT<br>
+
1 BIRT
2 DATE 23 JUN 1967<br>
+
2 DATE 23 JUN 1967
2 PLAC Beverley Hills, California, USA<br>
+
2 PLAC Beverley Hills, California, USA
3 MAP<br>
+
3 MAP
4 LATI N34.05<br>
+
4 LATI N34.05
4 LONG 118.230<br>
+
4 LONG 118.230
 +
</pre>
  
 
but in practical use, the last 3 lines can be left out, and the 2 PLAC information linked to a lookup "places" table to prevent bloating the GEDCOM with repeat information.
 
but in practical use, the last 3 lines can be left out, and the 2 PLAC information linked to a lookup "places" table to prevent bloating the GEDCOM with repeat information.
  
Not all applications adhere to this pattern. TMG expects you to enter the data in this format:<br>
+
Not all applications adhere to this pattern. TMG expects you to enter the data in this format:
DDMMSSCDDDMMSSC<br> where the first seven characters represent the latitude and the last eight
+
* DDMMSSCDDDMMSSC  
characters represent the longitude. DD is degrees, MM is minues and SS is seconds. The "C" is the compass heading (NSEW)
+
where the first seven characters represent the latitude and the last eight characters represent the longitude. DD is degrees, MM is minutes and SS is seconds. The "C" is the compass heading (NSEW)
  
 
TMG exports the lat/lon data as the last portion of the PLAC record, like this:
 
TMG exports the lat/lon data as the last portion of the PLAC record, like this:
  
1 BAPM <br>
+
<pre>
2 DATE 23 JUN 1935 <br>
+
1 BAPM
2 PLAC St Columba's Church, 2340 W. Lehigh Avenue,<br>
+
2 DATE 23 JUN 1935
Philadelphia, Philadelphia Co, Pennsylvania, USA,<br>
+
2 PLAC St Columba's Church, 2340 W. Lehigh Avenue,
395945N0751013W<br>
+
Philadelphia, Philadelphia Co, Pennsylvania, USA,
 +
395945N0751013W
 +
</pre>
  
 
It really needs to look like this:
 
It really needs to look like this:
  
1 BAPM<br>
+
<pre>
2 DATE 23 JUN 1935<br>
+
1 BAPM
2 PLAC St Columba's Church, 2340 W. Lehigh Avenue,<br>
+
2 DATE 23 JUN 1935
Philadelphia, Philadelphia Co, Pennsylvania, USA<br>
+
2 PLAC St Columba's Church, 2340 W. Lehigh Avenue,
3 MAP<br>
+
Philadelphia, Philadelphia Co, Pennsylvania, USA
4 LATI N39.9958<br>
+
3 MAP
4 LONG W75.1703<br>
+
4 LATI N39.9958
 +
4 LONG W75.1703
 +
</pre>
  
 
===Discipline===
 
===Discipline===
Line 88: Line 89:
  
 
===Google Group===
 
===Google Group===
 +
There is an interesting forum at http://groups.google.com.au/group/geonames?lnk=sg
  
There is an interesting forum at http://groups.google.com.au/group/geonames?lnk=sg
+
[[Category:Developers/General]]

Revision as of 05:39, 22 June 2009

This is intended to be a place to discuss place names in GRAMPS.

Work already done

There is an existing ISO (ISO-3166) that is used as the baseline for geonames. This provides general guidance for abbreviations (eg 2 or 3 character codes, the US 'fips' definitions) for countries.

There are still some confusions in the list - eg, the United Kingdom/Great Britain tangle.

You can see the list at http://www.geonames.org/countries/

Storage methods

When we think about places, we tend to think of them in our own situation. So, I might live at 135 Copley Place, Beverley Hills, Los Angeles, California, USA. (I don't). I think of them, in order, as Address, Suburb, City, State and Country. Other places use different nomenclature - county, province, prefecture, arondisment...to name just a few.

In the world of databases, parsing an address like the one above would be most inefficient - if it could be done at all. It is better to use the database and its strengths to assist us.

So, I would prefer to think of all those geographic descriptors as "levels", starting with the country (we can all agree on that, I think) as the base level - Level 0 - and then moving on to Level 1 etc. Having defined our Level 0, all Level 1s are therefore sub-ordinate to it. You can, of course, have as many 'Level 0's as you need.

So the computer application will think in reverse to us, preferring to start with a country, then finding the names of the places sub-ordinate to it, and so on. Accordingly, the database setup needs to reflect this. As an example:

place# parent# level place long lati
1!! 0 0 USA W100.00 N39.00
6!! 1 1 California W119.300 N36.000
7!! 6 2 Los Angeles W118.230 N34.05
8!! 7 3 Beverley Hills W118.400 N34.07
25!! 8 4 135 Copley Place W118.4224 N34.0767

Other places in Los Angeles would "share" the first 3 rows in the table, but then start a new branch.

GEDCOM

A well-designed database could derive from a GEDCOM using the correct structure:

0 INDI @987@
1 BIRT
2 DATE 23 JUN 1967
2 PLAC Beverley Hills, California, USA
3 MAP
4 LATI N34.05
4 LONG 118.230

but in practical use, the last 3 lines can be left out, and the 2 PLAC information linked to a lookup "places" table to prevent bloating the GEDCOM with repeat information.

Not all applications adhere to this pattern. TMG expects you to enter the data in this format:

  • DDMMSSCDDDMMSSC

where the first seven characters represent the latitude and the last eight characters represent the longitude. DD is degrees, MM is minutes and SS is seconds. The "C" is the compass heading (NSEW)

TMG exports the lat/lon data as the last portion of the PLAC record, like this:

1 BAPM
2 DATE 23 JUN 1935
2 PLAC St Columba's Church, 2340 W. Lehigh Avenue,
Philadelphia, Philadelphia Co, Pennsylvania, USA,
395945N0751013W

It really needs to look like this:

1 BAPM
2 DATE 23 JUN 1935
2 PLAC St Columba's Church, 2340 W. Lehigh Avenue,
Philadelphia, Philadelphia Co, Pennsylvania, USA
3 MAP
4 LATI N39.9958
4 LONG W75.1703

Discipline

If there is a problem with this, it is that you might need to edit all the geonames in your family file. The strength of the process depends on strict adherence (and identical spelling) to the table structure.

Old place names

If you are going to add Google maps with references from, say, geonames.org, then the old names for places won't be found. The easiest solution to this is to add the old names as notes, but map them with their current names.

However, you should be able to hand-edit. For example, say you know a small place, now vanished from the face of the earth, outside Vienna where someone was born. You study maps, derive the co-ordinates to be 48.055026 16.513064 (it's just a ploughed paddock). You should be able to give the proper name for the place that is long-gone, and add the co-ordinates yourself.

Google Group

There is an interesting forum at http://groups.google.com.au/group/geonames?lnk=sg