Requêtes Appellations APICarto

search-communes.sql

SELECT
    ST_AsGeoJSON(appellation.geom) AS geom,
    ST_AREA(ST_INTERSECTION(input_geom, appellation.geom)::geography) / 10000 AS area,
    appellation,
    id_uni,
    ST_CONTAINS(input_geom, appellation.geom) AS contains
FROM
    (
        SELECT
            communes.insee,
            input.geom AS input_geom
        FROM
            communes,
            (SELECT ST_SetSRID(ST_GeomFromGeoJSON('%s'), 4326) geom) input
        WHERE ST_Intersects(communes.geom, input.geom)
    ) AS matching_communes,
    appellation
WHERE matching_communes.insee = appellation.insee;