edwardchalstrey1 / seshat

This is the beginning of the Seshat Project code.
1 stars 2 forks source link

Overlay historical polities on modern country/state borders #17

Closed edwardchalstrey1 closed 12 months ago

edwardchalstrey1 commented 1 year ago

Overlay modern countries states/provinces with polities on the same map This should be a single Django template with the option to switch the basemap between the GADM shapes or OSM (or CartoDB)

edwardchalstrey1 commented 12 months ago

Some of the "provinces" (second level in the GADM dataset) are very small (making it slow to load) and there is a massive inconsistency across the globe too, which I think reduces the usefulness of this level

Screenshot 2023-12-04 at 16 57 44

edwardchalstrey1 commented 12 months ago

The code I used to populate the provinces table, which perhaps could be modified with some bespoke rules that don't treat all countries the same:

        INSERT INTO core_gadmprovinces (geom, "NAME_1", "ENGTYPE_1")
        SELECT 
            ST_Union(geom) AS geom,
            "NAME_1",
            "ENGTYPE_1"
        FROM 
            core_gadmshapefile
        GROUP BY 
            "NAME_1", "ENGTYPE_1";
edwardchalstrey1 commented 12 months ago

OSM boundaries