# Gramps vs. PostGIS vs. SpatialLite

**URL:** <https://gramps.discourse.group/t/gramps-vs-postgis-vs-spatiallite/5345>\
**Category:** Ideas\
**Tags:** uuid\
**Created:** [April 27, 2024, 3:13pm UTC](https://gramps.discourse.group/t/gramps-vs-postgis-vs-spatiallite/5345 "2024-04-27T15:13:45Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![emyoulation](https://yyz2.discourse-cdn.com/free1/user_avatar/gramps.discourse.group/emyoulation/32/67_2.png) [@emyoulation](https://gramps.discourse.group/u/emyoulation)\
**Post date:** [April 27, 2024, 4:09pm UTC](https://gramps.discourse.group/t/gramps-vs-postgis-vs-spatiallite/5345/2 "2024-04-27T16:09:29Z")

</div>

This is interesting.

You idea popped as I was wondering whether to add the [**Home Place**](https://gramps.discourse.group/t/display-gramps-places-in-relative-terms-of-here-now-who/2302) designation to **[GEPS 043](https://www.gramps-project.org/wiki/index.php/GEPS_043:_Improving_GEDCOM_support_for_Places): Improving GEDCOM support for Places**.

And noticed that while there is a proposal to add a UUID data element to the Gramps People model, there isn’t a similar UUID extension for the Place or Citation model. However, the existence of a UUID for People seems like a 1st step towards a harmonization/merge engine for Gramps.

I’ve begun using the GeoNames (wiki: [Geonames](https://www.gramps-project.org/wiki/index.php/Geonames); addon: [GeoName](https://www.gramps-project.org/wiki/index.php/Addon:GeoName), [PlaceCleanup](https://www.gramps-project.org/wiki/index.php/Addon:PlaceCleanupGramplet), [GetGov](https://www.gramps-project.org/wiki/index.php/Addon:GetGOV))

**PlaceCleanup** highjacks the Gramps PlaceID as a UUID. That is OK if I will only use the GeoNames gazetteer. But what happens if someone writes a plugin that leverages features an external database like [PostGIS](http://www.refractions.net/products/postgis/) or [SpatiaLite](https://www.gaia-gis.it/fossil/libspatialite/index) in the future? And such plugins might scrape data into Gramps (like **PlaceCleanup** ) or become more sophisticated (like @StoltHD suggests) and poll for live updates.

So how about UUIDs for the Core Objects in Gramps? Hopefully with more than a Name and Value tuple.

* * *

# Other Gazatteers

> [@Maria\_Babzien](#):
>
> _from [genealogy.net/gramps-L](https://discourse.genealogy.net/t/auf-der-suche-nach-einem-beispiel-fuer-eine-ortshierarchie-in-deutschland/823017/2)_  
> do you know [GOV :: The Historic Gazetteer](http://www.gov.genealogy.net/search/index) ?

---

_[View the full topic](https://gramps.discourse.group/t/gramps-vs-postgis-vs-spatiallite/5345)._