Vector Q6 - Firefighting Carretera Query inconsistent results - Githubissues

opengeospatial / geoedge-plugfest

Repository for Geospatial to the Edge Interoperability Plugfest

http://www.github.com/opengeospatial/geoedge-plugfest

0 stars 2 forks source link

Vector Q6 - Firefighting Carretera Query inconsistent results #18

Open bermud opened 6 years ago

bermud commented 6 years ago

Different results were reported.

Summary

Client G sometimes reported 39 and other times 18.
Client L and Z consistently reported 39.
Client E consistently reported 18
Client C reported 18

GPK Apollo

Client L and Z: 39
Client J: 18
Client E: 18

JGPK upiter

Client L and Z: 39
Client G: 39
Client E: 18

GPK Rigel

Client L : 39
Client G: 18
Client E: 18

GPK Orion

Client L and Z: 39
Client G: 18
Client E: 18

WFS Janus

Client L: 39
Client J: 18

The Query to found 18 in Client E was:: select * from PR_GGDM_BUILDING_P where ADR NOT LIKE "%Carretera%" and FFN=845 AND OTH LIKE "(Zipcode:006%";

gramnation commented 6 years ago

Symbols are necessary in order to do wildcard matching with "LIKE" operator.
ADR NOT LIKE "%Carretera%" filters down to 18. ADR NOT LIKE "Carretera" filters down to 39, with many addresses containing "Carretera."