Problème avec le service WFS

[paulemilechilin]

Bonjour,

Nous rencontrons des problèmes avec le service WFS (Web Feature Service) sur certains contenus de Feature. En particulier, une erreur 500 se produit lors d'une requête GetFeature.

Après investigation, il semble que l'erreur soit liée à certains champs contenant des dates. Voici un exemple de GeoJSON posant problème :

{
"d": "31/12/2024",
"d_revert": "2024/12/31",
"d_hyphen": "31-12-2024",
"d_hyphen_revert": "2024-12-31"
}

Ces valeurs de dates semblent être à l'origine du dysfonctionnement.

Le geojson :

{"type":"FeatureCollection","features":[{"type":"Feature","properties":{"city":"Madrid","populationTotal":3158645,"men_population":1565462,"women_population":1593183,"size":123.32,"gml_id":0,"d":"31/12/2024","d_revert":"2024/12/31","d_dot":"31.12.2024","d_dot_revert":"2024.12.31","d_hyphen":"31-12-2024","d_hyphen_revert":"2024-12-31"},"geometry":{"coordinates":[[[-4.179285703826338,40.923654904216136],[-4.179285703826338,39.854702882162854],[-2.867582595494383,39.854702882162854],[-2.867582595494383,40.923654904216136],[-4.179285703826338,40.923654904216136]]],"type":"Polygon"},"id":0},{"type":"Feature","properties":{"city":"Lisbon","populationTotal":684321,"men_population":250462,"women_population":433859,"size":682.122,"gml_id":1,"d":"14/12/2024","d_revert":"2024/12/14","d_dot":"14.12.2024","d_dot_revert":"2024.12.14","d_hyphen":"14-12-2024","d_hyphen_revert":"2024-12-14"},"geometry":{"coordinates":[[[-9.58593001383855,39.09938297130117],[-9.58593001383855,38.30619812209761],[-8.49696082876909,38.30619812209761],[-8.49696082876909,39.09938297130117],[-9.58593001383855,39.09938297130117]]],"type":"Polygon"},"id":1},{"type":"Feature","properties":{"city":"London","populationTotal":84512,"men_population":43385,"women_population":41127,"size":546.01,"gml_id":2,"d":"14/04/2024","d_revert":"2024/04/14","d_dot":"14.04.2024","d_dot_revert":"2024.04.14","d_hyphen":"14-04-2024","d_hyphen_revert":"2024-04-14"},"geometry":{"coordinates":[[[-0.6669828061986891,51.73210899535533],[-0.6669828061986891,51.291318504012],[0.2437891463815447,51.291318504012],[0.2437891463815447,51.73210899535533],[-0.6669828061986891,51.73210899535533]]],"type":"Polygon"},"id":2},{"type":"Feature","properties":{"city":"Brussels","populationTotal":123866,"men_population":50000,"women_population":73866,"size":945.18,"gml_id":3,"d":"02/08/2024","d_revert":"2024/08/02","d_dot":"02.08.2024","d_dot_revert":"2024.08.02","d_hyphen":"02-08-2024","d_hyphen_revert":"2024-08-02"},"geometry":{"coordinates":[[[4.107439822369599,51.0383564534371],[4.107439822369599,50.64902758900169],[4.691135144743498,50.64902758900169],[4.691135144743498,51.0383564534371],[4.107439822369599,51.0383564534371]]],"type":"Polygon"},"id":3},{"type":"Feature","properties":{"city":"Berlin","populationTotal":9535422,"men_population":4437570,"women_population":5097852,"size":730.84,"gml_id":4,"d":"11/02/2024","d_revert":"2024/02/11","d_dot":"11.02.2024","d_dot_revert":"2024.02.11","d_hyphen":"11-02-2024","d_hyphen_revert":"2024-02-11"},"geometry":{"coordinates":[[[12.901961259961581,52.76260294272387],[12.901961259961581,52.01778498965189],[14.043677728727062,52.01778498965189],[14.043677728727062,52.76260294272387],[12.901961259961581,52.76260294272387]]],"type":"Polygon"},"id":4}]}

[glegal]

Bonjour,
J'ai importé le fichier geojson ci-dessus dans examind et publié la couche sur un wfs.

les requetes getFeature suivantes fonctionne bien:

• http://localhost:8080/examind/WS/wfs/default?SERVICE=WFS&REQUEST=GetFeature&VERSION=1.1.0&TYPENAME=test
• http://localhost:8080/examind/WS/wfs/default?SERVICE=WFS&REQUEST=GetFeature&VERSION=1.1.0&TYPENAME=test&outputformat=application/json

de toute façon avec le store geojson, les champ contenant des dates sont traité comme des strings.

pouvez vous me dire/fournir:

• quel est le store d'origine (geojson, base de données postgis, shapefile) ?
• la requete qui provoque l'erreur.
• la stack trace de l'erreur.

[paulemilechilin]

• Le store d'origine est une base postgis
• La requête qui me donne l'erreur : https://gis.eop.promethee.digital/examind/WS/wfs/EOP_WFS?SERVICE=WFS&REQUEST=DescribeFeatureType&VERSION=2.0.0&TYPENAMES=layer-bf0cb6c1-2fca-4424-9549-abf1993c35aa
• Voici l'erreur que j'ai dans Examind : 15:33:28 [ERROR] org.constellation.admin.conf - An error has occured: unexpected type:class java.time.LocalDateTime

Pardon en re-testant j'ai remarqué que c'est le DescribeFeatureType qui pose problème et non le GetFeature

[paulemilechilin]

J'ai retesté avec un geojson plus simple et toujours l'erreur :
{"type":"FeatureCollection","features":[{"type":"Feature","properties":{"date":"2024-12-05T12:00:00Z"},"geometry":{"coordinates":[[[2.259051952920686,48.937727197230885],[2.259051952920686,48.7875485631819],[2.5280360330603173,48.7875485631819],[2.5280360330603173,48.937727197230885],[2.259051952920686,48.937727197230885]]],"type":"Polygon"},"id":0}]}

[glegal]

quand vous parler de geojson, vous avez un outils qui prend un geojson et le rentre dans une table postgis?
car je ne vois pas le lien entre le json et la table postgis.

Sinon, la version du store postgis actuel a un bug avec les colonnes de type timestamp. c'est corrigé dans la prochaine version de SIS depuis un moment, mais il faut attendre une montée de version.
Cela est actuellement en cours et devrait être fait bientôt (probablement vers la fin/ debut d'année)

[paulemilechilin]

Oui j'insère mon geojson dans une base postgis