Graph discrepancies from KW Panels

[fritosxii]

For definition, KW Panel compliant refers to a HazardEvent that has hasName and hasKWGEntity defined, or a Place that has hasKWGEntity and hasPlaceType defined (hasName is optional currently on Place entities because the main graph has many non named places)

Here is the Google Sheets spreadsheet that lead me to the following conclusions: https://docs.google.com/spreadsheets/d/1enzC86uybXngr6BBtf-Vi8NGfcwHVgvHWQOvlEgqGUw/edit#gid=934262946

Hazards

1. There are some hazards that are only HazardEvent, and don't have a specific type like Tornado. Should we include these entities?
   • https://staging.knowwheregraph.org/graphdb/resource?uri=http:%2F%2Fstko-kwg.geog.ucsb.edu%2Flod%2Flite-resource%2Fhazard.1182714.5432781
2. There are also random entities that aren't of type HazardEvent, but have a specific hazard type. Should we ignore these?
   • https://staging.knowwheregraph.org/graphdb/resource?uri=http:%2F%2Fstko-kwg.geog.ucsb.edu%2Flod%2Flite-resource%2Fhazard.100056.599517
3. For extra context, there are 1000+ NOAAWildfires in the graph, but only 1 is actually attached to HazardEvent:
   • https://staging.knowwheregraph.org/graphdb/resource?uri=http:%2F%2Fstko-kwg.geog.ucsb.edu%2Flod%2Flite-resource%2FNOAAWildfire
4. Lastly I should note that these 1000+ fires are not KW Panel compliant, while the one fire that is a HazardEvent has the expected data:
   • https://staging.knowwheregraph.org/graphdb/resource?uri=http:%2F%2Fstko-kwg.geog.ucsb.edu%2Flod%2Flite-resource%2Fhazard.1180930.5434012
5. Hurricane and Earthquake also have the same issue of having 1000s of records, but none of them are HazardEvents, and none are KW Panel compliant:
   • https://staging.knowwheregraph.org/graphdb/resource?uri=http:%2F%2Fstko-kwg.geog.ucsb.edu%2Flod%2Flite-ontology%2FHurricane
   • https://staging.knowwheregraph.org/graphdb/resource?uri=http:%2F%2Fstko-kwg.geog.ucsb.edu%2Flod%2Flite-ontology%2FEarthquake
6. hasImpacted is connected to several fires, but all those fires are not KW Panel compliant, and seem to only have hasImpacted as a property
   • https://staging.knowwheregraph.org/graphdb/resource?uri=http:%2F%2Fstko-kwg.geog.ucsb.edu%2Flod%2Flite-ontology%2FhasImpacted
7. affectedAreaInAcres and damageToCropsInDollars are also present but only attached to entities that are not KW Panel compliant:
   • https://staging.knowwheregraph.org/graphdb/resource?uri=http:%2F%2Fstko-kwg.geog.ucsb.edu%2Flod%2Flite-ontology%2FaffectedAreaInAcres
   • https://staging.knowwheregraph.org/graphdb/resource?uri=http:%2F%2Fstko-kwg.geog.ucsb.edu%2Flod%2Flite-ontology%2FdamageToCropsInDollars

Places

8. sfWithin and sfTouches do not point to any KW Panel compliant Place entities.
   • https://staging.knowwheregraph.org/graphdb/resource?uri=http:%2F%2Fstko-kwg.geog.ucsb.edu%2Flod%2Flite-ontology%2FsfWithin
   • https://staging.knowwheregraph.org/graphdb/resource?uri=http:%2F%2Fstko-kwg.geog.ucsb.edu%2Flod%2Flite-ontology%2FsfTouches
9. sfContains has the same problem, but there is 1 valid relation
   • https://staging.knowwheregraph.org/graphdb/resource?uri=http:%2F%2Fstko-kwg.geog.ucsb.edu%2Flod%2Flite-ontology%2FsfContains
   • https://staging.knowwheregraph.org/graphdb/resource?uri=http:%2F%2Fstko-kwg.geog.ucsb.edu%2Flod%2Flite-resource%2Fcensus.USCensusMSA.31000US29820.2019
10. sfOverlaps has the same problem, but there are 27 valid relations

• https://staging.knowwheregraph.org/graphdb/resource?uri=http:%2F%2Fstko-kwg.geog.ucsb.edu%2Flod%2Flite-ontology%2FsfOverlaps

11. impactedBy does not point to any KW Panel compliant HazardEvent entities.

• https://staging.knowwheregraph.org/graphdb/resource?uri=http:%2F%2Fstko-kwg.geog.ucsb.edu%2Flod%2Flite-ontology%2FimpactedBy

Place Year Data

12. For this I am going to let the Google Sheets above speak for itself
13. For the 2018-2022 data, these properties exist and work, but some of them just aren't present in KWG Lite (so I assume they also are not in the main graph)
14. For the Jan2021-Dec2021 temperature properties, they all exist and have data, but are all attached to climate divisions that do not have a hasKWGEntity property, and therefore are not KW Panel compliant. Here's an example from 1 of those properties:

• https://staging.knowwheregraph.org/graphdb/resource?uri=http:%2F%2Fstko-kwg.geog.ucsb.edu%2Flod%2Flite-ontology%2FminMonthlyTemperatureInCelsiusDec2021

[cogan-shimizu]

@antreac Can you please narrow down which queries are causing these problems? For example, which queries construct a HazardEvent but don't have subtype?

[fritosxii]

@antreac Can you please narrow down which queries are causing these problems? For example, which queries construct a HazardEvent but don't have subtype?

Please note this issue is still in progress. I will comment again when it is finalized

[fritosxii]

Ok @antreac , I've completed this issue description so go ahead, and let me know if you have any questions.

[antreac]

I have updated the construct-queries.md document so it will be available once Cogan merge the pull request, after that please let me know if there are any more questions. I will check the issues mentioned above and reach out to you with questions. @fritosxii

[shirlysteph]

Issue 1

I have included a new predicate in the graph to capture the specific hazard/disaster type of the HazardEvent. So for e.g. the example pointed above in issue 1 is now a Winter Storm.

[cogan-shimizu]

Is this consistent across all HazardTypes, i.e., there are no more subclasses to HazardEvent?