Aller au contenu

C01 Insert Cities And Iris

Insert cities and IRIS from geojson file and IGN WFS.

Command

Bases: BaseCommand

Source code in back/iarbre_data/management/commands/c01_insert_cities_and_iris.py
class Command(BaseCommand):
    help = "Insert cities geojson file"

    @staticmethod
    def _insert_iris(qs_city: QuerySet) -> None:
        """Use IGN WFS to download IRIS and insert them in a table
        Args:
            qs_city (QuerySet): Query set that correspond to one or multiple cities.
        """
        for city in qs_city:
            print(f"Dowloading IRIS for city: {city.name}.")
            params = {
                "SERVICE": "WFS",
                "VERSION": "2.0.0",
                "REQUEST": "GetFeature",
                "TYPENAMES": IRIS_TYPENAME,
                "OUTPUTFORMAT": "application/json",
                "SRSNAME": f"EPSG:{SRID_DB}",
                "CQL_FILTER": f"code_insee='{city.code}'",
            }
            response = requests.get(IRIS_WFS_URL, params=params, timeout=60)
            response.raise_for_status()
            codes = []
            for feature in tqdm(response.json()["features"]):
                code, name, geom = iris_from_feature(feature)
                codes.append(code)
                Iris.objects.update_or_create(
                    city_id=city.id,
                    code=code,
                    defaults={"geometry": geom, "name": name},
                )
            remove_stale_iris(city, codes)

    @staticmethod
    def _insert_cities(data: str) -> None:
        """Insert cities from a GEOJSON file.
        Args:
            data (str): path to the GEOJSON containing cities geometry.
        """
        lm = LayerMapping(City, data=data, mapping=mapping_city)
        lm.save()
        for city in City.objects.all():
            city.tiles_generated = False
            city.tiles_computed = False
            # Remove accents from city name and replace hyphens with spaces
            if city.name:
                city.name = unidecode(city.name).replace("-", " ").strip()
            city.save()

    def handle(self, *args, **options):
        """Insert cities from geojson file and IRIS from IGN WFS."""
        logger = logging.getLogger(__name__)
        self._insert_cities(data="file_data/communes_gl_2025.geojson")
        print("Removing duplicated cities...")
        remove_duplicates(City)
        logger.info("Duplicate removal complete.")
        qs_city = City.objects.all()
        self._insert_iris(qs_city=qs_city)
        print("Removing duplicated IRIS...")
        remove_duplicates(Iris)

handle(*args, **options)

Insert cities from geojson file and IRIS from IGN WFS.

Source code in back/iarbre_data/management/commands/c01_insert_cities_and_iris.py
def handle(self, *args, **options):
    """Insert cities from geojson file and IRIS from IGN WFS."""
    logger = logging.getLogger(__name__)
    self._insert_cities(data="file_data/communes_gl_2025.geojson")
    print("Removing duplicated cities...")
    remove_duplicates(City)
    logger.info("Duplicate removal complete.")
    qs_city = City.objects.all()
    self._insert_iris(qs_city=qs_city)
    print("Removing duplicated IRIS...")
    remove_duplicates(Iris)