ThomasG77

import os
import tempfile
import shutil
import argparse
from pathlib import Path

parser = argparse.ArgumentParser()
parser.add_argument("path", type=str,
                    help="Provide path to a qgs or qgz file")
args = parser.parse_args()

ThomasG77

Miniconda install recipe for GDAL

Take miniconda from https://docs.conda.io/en/latest/miniconda.html#latest-miniconda-installer-links and execute either the sh file or the pkg file

Add channel for GDAL

conda config --add channels conda-forge
conda config --set channel_priority strict

ThomasG77

Path issue when migrating CommonJS to ES6

Context: migrating to ES6 syntax because some upcoming deps ES6 based (want to avoid transpiling)

Command used to fail

Root of the repo myrepo then running

In CommonJS cli

ThomasG77

import fs from 'fs'
import got from 'got'
import gdal from 'gdal-async'
import { pipeline } from 'stream/promises'

const url = 'https://github.com/deldersveld/topojson/raw/master/countries/germany/germany-regions.json'
const fileName = url.substring(url.lastIndexOf('/') + 1)

const downloadStream = got.stream(url)
const fileWriterStream = fs.createWriteStream(fileName)

ThomasG77

{
  "name": "order-service",
  "version": "0.0.2",
  "lockfileVersion": 2,
  "requires": true,
  "packages": {
    "": {
      "name": "order-service",
      "version": "0.0.2",
      "license": "ISC",

ThomasG77

wget -N -P data/ http://files.opendatarchives.fr/professionnels.ign.fr/adminexpress/ADMIN-EXPRESS-COG_3-1__SHP__FRA_WM_2022-04-15.7z
cd data
7z e ADMIN-EXPRESS-COG_3-1__SHP__FRA_WM_2022-04-15.7z CHFLIEU_COMMUNE.* COMMUNE.* -r
ogr2ogr -overwrite \
        -f GeoJSON \
        -dialect SQLite \
        -sql "SELECT \"INSEE_COM\", CASE WHEN chf.geometry IS NULL THEN 'c' ELSE 'm' END AS t, CASE WHEN chf.geometry IS NULL THEN PointOnSurface(\"COMMUNE\".geometry) ELSE chf.geometry END AS geometry FROM \"COMMUNE\" LEFT JOIN 'CHFLIEU_COMMUNE.shp'.\"CHFLIEU_COMMUNE\" chf ON chf.\"ID_COM\" = \"COMMUNE\".\"ID\"" \
        chflieu_commune.geojson \
        COMMUNE.shp \
        -lco RFC7946=YES \

ThomasG77

wget https://sig.ville.gouv.fr/Atlas/qp-politiquedelaville-shp.zip
unzip qp-politiquedelaville-shp.zip

ogrinfo QP_METROPOLEOUTREMER_WGS84_EPSG4326.shp -dialect SQLite -sql "SELECT count(*) FROM \"QP_METROPOLEOUTREMER_WGS84_EPSG4326\" WHERE NOT IsValid(geometry)"

ogr2ogr out.shp QP_METROPOLEOUTREMER_WGS84_EPSG4326.shp -dialect SQLite -sql "SELECT \"CODE_QP\", \"NOM_QP\", \"COMMUNE_QP\", CASE WHEN NOT IsValid(geometry) THEN ST_MakeValid(geometry) ELSE geometry END AS geometry FROM \"QP_METROPOLEOUTREMER_WGS84_EPSG4326\""

ogrinfo out.shp -dialect SQLite -sql "SELECT count(*) FROM out WHERE NOT IsValid(geometry)"

ThomasG77

SIREN et autres traitements autour dont la validation VIES (TVA intracommunautaire)

Formule SIREN vers TVA intracommunautaire

Approche Python

COUNTRIES = {
    "AT": "Autriche",
    "BE": "Belgique",

ThomasG77

import os
from osgeo import gdal

# gdal.UseExceptions()
# gdal.SetConfigOption('CPL_DEBUG', 'ON')

# Create a test CSV
file = "test.csv"
with open("test.csv", "w") as csv:
    csv.write("latitude,longitude\n")

ThomasG77

Encadrement des loyers

A propos

• https://www.ecologie.gouv.fr/encadrement-des-loyers

• https://www.journaldunet.fr/patrimoine/guide-de-l-immobilier/1202345-encadrement-des-loyers-calcul-et-villes-concernees/

• https://www.ecologie.gouv.fr/encadrement-des-loyers-8-epci-candidats-lencadrement-des-loyers