Difference between revisions of "Place database"

From Gramps
Jump to: navigation, search
m (To re-use your data stored in a flat database)
(To use existing place structure and data into Gramps)
(4 intermediate revisions by one other user not shown)
Line 1: Line 1:
  
 
==Place database used by Gramps==
 
==Place database used by Gramps==
If you want to use your own database, you don't care of licence to use, but what about to re-use existing databases ?
+
If you want to use your own database, you don't care about the licence to use, but what about when you re-use an existing database?
 +
 
 
See [[GRAMPS:Copyrights|Copyrights]].
 
See [[GRAMPS:Copyrights|Copyrights]].
  
 
==To create our place database==
 
==To create our place database==
Why not creating our own place database ?
+
Why not create our own place database?
Users sharing place information. It is possible on Gramps 3.0.1 and later :
+
 
 +
Users sharing place information. It is possible on Gramps 3.0.1 and later:
  
 
#Go on place View
 
#Go on place View
 
#Edit menu -> Column editor
 
#Edit menu -> Column editor
 
#Check Place Name, Zip, City, County, Country, Latitude, Longitude, Church Parish columns  
 
#Check Place Name, Zip, City, County, Country, Latitude, Longitude, Church Parish columns  
#go on Family Trees menu -> Export View ...
+
#go to menu {{man menu|Family Trees ->[[Gramps_4.2_Wiki_Manual_-_Settings#Export_View|Export View...]]}}
  
 
===To add a licence to use and to share it===  
 
===To add a licence to use and to share it===  
Line 23: Line 25:
 
  Free Documentation License".
 
  Free Documentation License".
  
[[Image:Heckert_GNU_white.png]]
+
[[Image:Heckert_GNU_white.png|right]]
  
 
==To use existing place structure and data into Gramps==
 
==To use existing place structure and data into Gramps==
Line 64: Line 66:
  
 
ex: if you don't use autofiling for number, (''<xsl:number value="postion()" format="1."/>'') generates ordered id for your place object.
 
ex: if you don't use autofiling for number, (''<xsl:number value="postion()" format="1."/>'') generates ordered id for your place object.
 +
 +
* Gramps csv
 +
 +
Since [[Template:Releases/4.2.1|Gramps 4.2.1]], [[Gramps_4.2_Wiki_Manual_-_Manage_Family_Trees:_CSV_Import_and_Export|CSV import/export]] provides a better place handling.
  
 
===Geonames===
 
===Geonames===
Line 82: Line 88:
  
 
*[[Place_completion_tool|Place completion tool]] brings the places in your Gramps database in accordance with the Gramps requirements: batch add country, county; look-up latitude-longitude; set description (title); ...
 
*[[Place_completion_tool|Place completion tool]] brings the places in your Gramps database in accordance with the Gramps requirements: batch add country, county; look-up latitude-longitude; set description (title); ...
'''DO NOT BETA TEST WITH YOUR RESEARCH DATA. EXPORT DATA FIRST TO HAVE A BACKUP, THEN RUN THE TOOL'''
+
{{man warn|DO NOT BETA TEST WITH YOUR RESEARCH DATA.|EXPORT DATA FIRST TO HAVE A BACKUP, THEN RUN THE TOOL}}
  
* [[Gramps_4.1_Wiki_Manual_-_Tools#Extract_Place_Data_from_a_Place_Title|Extract Place Data from Place Title]] (Tools-->Database Processing-->) attempts to extract city and state/province from a place title.
+
* [[Gramps_4.2_Wiki_Manual_-_Tools#Extract_Place_Data_from_a_Place_Title|Extract Place Data from Place Title]] {{man menu|Tools->Family Tree Processing->Extract Place Data from a Place Title...}} attempts to extract city and state/province from a place title.
''ONLY for United States of America, Canada, France, Sweden.''
+
{{man note|ONLY|for United States of America, Canada, France, Sweden.}}
  
 
[[Category:Places]]
 
[[Category:Places]]
 
[[Category:Documentation]]
 
[[Category:Documentation]]

Revision as of 07:50, 15 October 2015

Place database used by Gramps

If you want to use your own database, you don't care about the licence to use, but what about when you re-use an existing database?

See Copyrights.

To create our place database

Why not create our own place database?

Users sharing place information. It is possible on Gramps 3.0.1 and later:

  1. Go on place View
  2. Edit menu -> Column editor
  3. Check Place Name, Zip, City, County, Country, Latitude, Longitude, Church Parish columns
  4. go to menu Family Trees ->Export View...

To add a licence to use and to share it

Copyright (c)  YEAR  YOUR NAME.
Permission is granted to copy, distribute and/or modify this document
under the terms of the GNU Free Documentation License, Version 1.2
or any later version published by the Free Software Foundation;
with no Invariant Sections, no Front-Cover Texts, and no Back-Cover
Texts.  A copy of the license is included in the section entitled "GNU
Free Documentation License".
Heckert GNU white.png

To use existing place structure and data into Gramps

To re-use your data stored in a flat database

  • Data to gramps XML

Having a place database (txt, csv, xml, bd etc ...) which could be used on open-sources projects (licence)

Either to import data into gnumeric (save data on XML gnumeric), see XML to gramps XML, or:

  1. to assign one format per column (font size="8" for the first column, font size="10" for the second, etc ...)
  2. to order by name
  3. to create a new column (1 on the first line, 2 on the second, 3 on the third) then to use automatic filing from the first line to the last one with data.
  4. to save on XHTML
  5. On this new XHTML file, to work with "replace" function into your text editor (or grep, sed, awk)
  6. Generate a simple place table into gramps (with or without handle references)
 <?xml version="1.0" encoding="UTF-8"?>
 <!DOCTYPE database PUBLIC "-//Gramps//DTD Gramps XML 1.7.1//EN"
 "http://gramps-project.org/xml/1.7.1/grampsxml.dtd">
 <database xmlns="http://gramps-project.org/xml/1.7.1/">
<places>
    <placeobj id="P0001" type="City">
      <ptitle>A, B</ptitle>
      <pname value="A, B"/>
      <coord long="-81.2636738" lat="28.9005446"/>
      <placeref hlink="_c96587264d513cb56c90efab74d"/> # if need
    </placeobj>
    <placeobj handle="_c96587264d513cb56c90efab74d" id="P0099" type="country"> # if need ref.
      <ptitle>B</ptitle>
      <pname value="B"/>
    </placeobj>
</places>
</database>
  • XML to gramps XML

With XML flat database, to generate a new XML by using XSLT.

ex: if you don't use autofiling for number, (<xsl:number value="postion()" format="1."/>) generates ordered id for your place object.

  • Gramps csv

Since Gramps 4.2.1, CSV import/export provides a better place handling.

Geonames

Geonames licensed their data under a Creative Commons Attribution 3.0 License, provided "as is" without warranty or any representation of accuracy, timeliness or completeness.

You are free:
 * to Share — to copy, distribute and transmit the work
 * to Remix — to adapt the work
Under the following conditions:
 * Attribution. You must attribute the work in the manner specified by the author or licensor 
(but not in any way that suggests that they endorse you or your use of the work).

Creative Commons License
Creative Commons Attribution iconCreative Commons Share Alike icon

Database management

  • Place completion tool brings the places in your Gramps database in accordance with the Gramps requirements: batch add country, county; look-up latitude-longitude; set description (title); ...
Gnome-important.png
DO NOT BETA TEST WITH YOUR RESEARCH DATA.

EXPORT DATA FIRST TO HAVE A BACKUP, THEN RUN THE TOOL

Gramps-notes.png
ONLY

for United States of America, Canada, France, Sweden.