Difference between revisions of "Place database"

From Gramps
Jump to: navigation, search
(To use existing place structure and data)
(To use existing place structure and data)
Line 37: Line 37:
 
[[Image:CC some rights reserved.png|70px|Creative Commons License]]<br />[[Image:Cc-by new white.png|24px|Creative Commons Attribution icon]][[Image:Cc-sa white.png|24px|Creative Commons Share Alike icon]]
 
[[Image:CC some rights reserved.png|70px|Creative Commons License]]<br />[[Image:Cc-by new white.png|24px|Creative Commons Attribution icon]][[Image:Cc-sa white.png|24px|Creative Commons Share Alike icon]]
  
 
+
===To re-use your data stored in an other falt database===
Data sounds good for computer (many codes) and could be used for generating a database :
 
  
 
# having a place database (txt, csv, xml, bd etc ...) which could be used on open-sources projects (licence)
 
# having a place database (txt, csv, xml, bd etc ...) which could be used on open-sources projects (licence)

Revision as of 07:48, 6 August 2008

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 ? See Copyrights.

To create our place database

Why not creating our own place database ? Users sharing their place informations. 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 on Family Trees menu -> 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

Geonames licensed their 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

To re-use your data stored in an other falt database

  1. having a place database (txt, csv, xml, bd etc ...) which could be used on open-sources projects (licence)
  2. to import data into gnumeric (save data on XML gnumeric)
  3. to assign one format per column (font size="8" for the first column, font size="10" for the second, etc ...)
  4. to order by name
  5. 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.
  6. to save on XHTML
  7. to work with "remplace" function on your text editor (or grep, sed, awk)
  8. with XML flat database, I 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.