# \[ANN\] GeoIDs.jl: a package to create a postgres/postgis database of TIGER county boundaries

**URL:** <https://discourse.julialang.org/t/ann-geoids-jl-a-package-to-create-a-postgres-postgis-database-of-tiger-county-boundaries/127778>\
**Category:** Geo\
**Tags:** package, announcement\
**Created:** [April 6, 2025, 11:54pm UTC](https://discourse.julialang.org/t/ann-geoids-jl-a-package-to-create-a-postgres-postgis-database-of-tiger-county-boundaries/127778 "2025-04-06T23:54:33Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![technocrat](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/technocrat/32/220947_2.png) [@technocrat](https://discourse.julialang.org/u/technocrat)\
**Post date:** [April 6, 2025, 11:54pm UTC](https://discourse.julialang.org/t/ann-geoids-jl-a-package-to-create-a-postgres-postgis-database-of-tiger-county-boundaries/127778/1 "2025-04-06T23:54:33Z")

</div>

[GeoIDs.jl](https://github.com/technocrat/GeoIDs.jl) provides a comprehensive solution for working with Census GEOID identifiers, particularly at the county level. The package enables you to:

- **Create and Manage Geographic Area Sets** : Define sets of counties for analysis

- **Track Changes Over Time** : Full version history for every geographic definition

- **Apply Set Operations** : Union, intersection, difference, and symmetric difference

- **Filter Spatially** : Select counties by latitude, longitude, distance, or bounding box

- **Back Up and Restore** : Export and import full version history

- **Access Census Data** : Integrate with TIGER/Line shapefilesprovides a comprehensive solution for working with Census GEOID identifiers, particularly at the county level. The package enables you to:

- **Create and Manage Geographic Area Sets** : Define sets of counties for analysis

- **Track Changes Over Time** : Full version history for every geographic definition.

The functionality helps deal with arranging and re-arranging sets of county GeoIDs rather than proliferating links in scripts. Sets can be created programmatically (such as all Florida counties south of latitude 29º degrees north). The repo includes the `cb_us_counties_2022_5M` source shapefiles are available locally. (The 2023 version has some oversimplified geometries, such as King County, WA, which has only 5 points, as compared to 2022, which has 252; the 500K file proved to be too detailed for rendering of more than a few geometries). A thorough setup guide to installing PostgreSQL and PostGIS is included and scripts take care of initialization of tables. This is intended for the single-user case and assumes only basic familiarity with command line utilities.

---

<div class="post-metadata">

**Author:** ![Raf](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/raf/32/3383_2.png) [@Raf](https://discourse.julialang.org/u/Raf)\
**Post date:** [April 7, 2025, 8:52am UTC](https://discourse.julialang.org/t/ann-geoids-jl-a-package-to-create-a-postgres-postgis-database-of-tiger-county-boundaries/127778/2 "2025-04-07T08:52:21Z")

</div>

Thats a very generic name for something quite specific… Have you considered CensusGeoIDS.jl? We share a namespace with many disciplines so keeping things specific helps the whole ecosystem to feel coherent.

---

<div class="post-metadata">

**Author:** ![lupemba](https://avatars.discourse-cdn.com/v4/letter/l/e5b9ba/32.png) [@lupemba](https://discourse.julialang.org/u/lupemba)\
**Post date:** [April 7, 2025, 8:59am UTC](https://discourse.julialang.org/t/ann-geoids-jl-a-package-to-create-a-postgres-postgis-database-of-tiger-county-boundaries/127778/3 "2025-04-07T08:59:48Z")

</div>

It can also be confused with the geiod which has a very different meaning. [Geoid - Wikipedia](https://en.wikipedia.org/wiki/Geoid)

---

<div class="post-metadata">

**Author:** ![technocrat](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/technocrat/32/220947_2.png) [@technocrat](https://discourse.julialang.org/u/technocrat)\
**Post date:** [April 7, 2025, 10:40am UTC](https://discourse.julialang.org/t/ann-geoids-jl-a-package-to-create-a-postgres-postgis-database-of-tiger-county-boundaries/127778/4 "2025-04-07T10:40:40Z")

</div>

Good suggestion should it ever come time to graduate to the registry.