classified_has_child not downloaded correctly?

[KonradHoeffner]

SELECT
{suffix("?parent")} AS ?parent_suffix
{suffix("?child")} AS ?child_suffix
{{
 ?child ?p ?parent.
 ?p rdfs:subPropertyOf hito:subClassifiedOf. 
}}

classified_has_child.sql

Shouldn't there be much more?

\echo FILL TABLE classified_has_child
DELETE FROM classified_has_child;
INSERT INTO classified_has_child(parent_suffix,child_suffix) VALUES
(E'WhoDhiCivilRegistrationAndVitalStatistic',E'WhoDhiCertifyBirthEvent'),
(E'WhoDhiCivilRegistrationAndVitalStatistic',E'WhoDhiCertifyDeathEvent'),
(E'WhoDhiCivilRegistrationAndVitalStatistic',E'WhoDhiNotifyBirthEvent'),
(E'WhoDhiCivilRegistrationAndVitalStatistic',E'WhoDhiNotifyDeathEvent'),
(E'WhoDhiCivilRegistrationAndVitalStatistic',E'WhoDhiRegisterBirthEvent'),
(E'WhoDhiCivilRegistrationAndVitalStatistic',E'WhoDhiRegisterDeathEvent'),
(E'WhoDhiClientHealthRecords',E'WhoDhiLongitudinalTrackingOfClientsHealthStatusAndServices'),
(E'WhoDhiClientHealthRecords',E'WhoDhiManageClientsStructuredClinicalRecords'),
(E'WhoDhiClientHealthRecords',E'WhoDhiManageClientsUnstructuredClinicalRecords'),
(E'WhoDhiClientHealthRecords',E'WhoDhiRoutineHealthIndicatorDataCollectionAndManagement'),
(E'WhoDhiClientIdentificationAndRegistration',E'WhoDhiEnrolClientForHealthServicesclinicalCarePlan'),
(E'WhoDhiClientIdentificationAndRegistration',E'WhoDhiVerifyClientUniqueIdentity'),
(E'WhoDhiEquipmentAndAssetManagement',E'WhoDhiMonitorStatusOfHealthEquipment'),
(E'WhoDhiEquipmentAndAssetManagement',E'WhoDhiTrackRegulationAndLicensingOfMedicalEquipment'),
(E'WhoDhiFacilityManagement',E'WhoDhiAssessHealthFacilities'),
(E'WhoDhiFacilityManagement',E'WhoDhiListHealthFacilitiesAndRelatedInformation'),
(E'WhoDhiHealthFinancing',E'WhoDhiManageBudgetAndExpenditures'),
(E'WhoDhiHealthFinancing',E'WhoDhiRegisterAndVerifyClientInsuranceMembership'),
(E'WhoDhiHealthFinancing',E'WhoDhiTrackAndManageInsuranceReimbursement'),
(E'WhoDhiHealthFinancing',E'WhoDhiTrackInsuranceBillingAndClaimsSubmission'),
(E'WhoDhiHealthFinancing',E'WhoDhiTransmitOrManageIncentivesToHealthcareProviders'),
(E'WhoDhiHealthFinancing',E'WhoDhiTransmitRoutinePayrollPaymentToHealthcareProviders'),
(E'WhoDhiHealthWorkerActivityPlanningAndScheduling',E'WhoDhiIdentifyClientsInNeedOfServices'),
(E'WhoDhiHealthWorkerActivityPlanningAndScheduling',E'WhoDhiScheduleHealthcareProvidersActivities'),
(E'WhoDhiHealthcareProviderCommunication',E'WhoDhiCommunicationAndPerformanceFeedbackToHealthcareProviders'),
(E'WhoDhiHealthcareProviderCommunication',E'WhoDhiCommunicationFromHealthcareProvidersToSupervisor'),
(E'WhoDhiHealthcareProviderCommunication',E'WhoDhiPeerGroupForHealthcareProviders'),
(E'WhoDhiHealthcareProviderCommunication',E'WhoDhiTransmitNonroutineHealthEventAlertsToHealthcareProviders'),
(E'WhoDhiHealthcareProviderCommunication',E'WhoDhiTransmitRoutineNewsAndWorkflowNotificationsToHealthcareProviders'),
(E'WhoDhiHealthcareProviderDecisionSupport',E'WhoDhiProvideChecklistAccordingToProtocol'),
(E'WhoDhiHealthcareProviderDecisionSupport',E'WhoDhiProvidePromptsAndAlertsBasedAccordingToProtocol'),
(E'WhoDhiHealthcareProviderDecisionSupport',E'WhoDhiScreenClientsByRiskOrOtherHealthStatus'),
(E'WhoDhiHealthcareProviderTraining',E'WhoDhiAssessCapacityOfHealthcareProvider'),
(E'WhoDhiHealthcareProviderTraining',E'WhoDhiProvideTrainingContentToHealthcareProviders'),
(E'WhoDhiHumanResourceManagement',E'WhoDhiListHealthWorkforceCadresAndRelatedIdentificationInformation'),
(E'WhoDhiHumanResourceManagement',E'WhoDhiManageCertificationregistrationOfHealthcareProviders'),
(E'WhoDhiHumanResourceManagement',E'WhoDhiMonitorPerformanceOfHealthcareProviders'),
(E'WhoDhiHumanResourceManagement',E'WhoDhiRecordTrainingCredentialsOfHealthcareProviders'),
(E'WhoDhiPrescriptionAndMedicationManagement',E'WhoDhiReportEffectsAdverseDrug'),
(E'WhoDhiPrescriptionAndMedicationManagement',E'WhoDhiTrackClientsMedicationConsumption'),
(E'WhoDhiPrescriptionAndMedicationManagement',E'WhoDhiTransmitOrTrackPrescriptionOrders'),
(E'WhoDhiPublicHealthEventNotification',E'WhoDhiNotificationOfPublicHealthEventsFromPointOfDiagnosis'),
(E'WhoDhiReferralCoordination',E'WhoDhiCoordinateEmergencyResponseAndTransport'),
(E'WhoDhiReferralCoordination',E'WhoDhiManageReferralsBetweenHealthAndOtherSectors'),
(E'WhoDhiReferralCoordination',E'WhoDhiManageReferralsBetweenPointsOfServiceWithinHealthSector'),
(E'WhoDhiSupplyChainManagement',E'WhoDhiManageInventoryAndDistributionOfHealthCommoditiesStockLevelsOf'),
(E'WhoDhiSupplyChainManagement',E'WhoDhiManageOfCommodities'),
(E'WhoDhiSupplyChainManagement',E'WhoDhiMonitorColdchainSensitiveCommoditiesLicensedDrugs'),
(E'WhoDhiSupplyChainManagement',E'WhoDhiNotifyHealthCommodities'),
(E'WhoDhiSupplyChainManagement',E'WhoDhiRegisterAndHealthCommoditiesProcurement'),
(E'WhoDhiSupplyChainManagement',E'WhoDhiReportCounterfeitOrSubstandardDrugsByClients'),    
(E'WhoDhiTelemedicine',E'WhoDhiConsultationsBetweenRemoteClientAndHealthcareProvider'),
(E'WhoDhiTelemedicine',E'WhoDhiConsultationsForCaseManagementBetweenHealthcareProviders'),
(E'WhoDhiTelemedicine',E'WhoDhiRemoteMonitoringOfClientHealthOrDiagnosticDataByProvider'),
(E'WhoDhiTelemedicine',E'WhoDhiTransmissionOfMedicalDataToHealthcareProvider'),
(E'WhoDhiLaboratoryAndDiagnosticsImagingManagement',E'WhoDhiCaptureFromDigitalDevices'), 
(E'WhoDhiLaboratoryAndDiagnosticsImagingManagement',E'WhoDhiTrackBiologicalSpecimens'),
(E'WhoDhiLaboratoryAndDiagnosticsImagingManagement',E'WhoDhiTransmitDiagnosticOrdersDiagnosticResults'),
(E'WhoDhiLaboratoryAndDiagnosticsImagingManagement',E'WhoDhiTransmitToHealthcareProviderAndTrack')ON CONFLICT DO NOTHING;

[KonradHoeffner]

Those are all features that support functions, they shouldn't be in that table at all but instead in feature_supports_function. And the features that have subfeatures need to be included instead, find out why that doesn't work.

[KonradHoeffner]

Move feature-function pairs to feature_supports_function

Added in 119322718a74625d0795132eb1362df86265c772.

[KonradHoeffner]

Include subfeatures

In https://github.com/hitontology/csv2rdf, the property hito:subFeatureOf is used. The ontology defines:

###  http://hitontology.eu/ontology/subFeatureOf
:featureClassifiedComponent rdf:type owl:ObjectProperty ;
                    rdfs:subPropertyOf :subClassifiedOf ;
                    rdfs:domain :FeatureClassified;
                    rdfs:range :FeatureClassified;
                    rdfs:label "subfeature of"@en .

There is a mismatch between the URI on the one hand, and the comment and label on the other hand. The problem lies in https://github.com/hitontology/ontology/commit/508f231c6ad57631a51a69b73544e1dc8c9bba51, hito:subFeatureOf is the correct one.

I corrected that in the ontology and uploaded the new hito.ttl in the SPARQL endpoint conductor interface. https://hitontology.eu/ontology/subFeatureOf is now defined. Rerunning the download script now includes subfeatures.

[KonradHoeffner]

All the subFeatures and support entries are now in the database.