{"id":"W4402351867","doi":"10.1109/ijcnn60899.2024.10651125","title":"GS-SQL: Modeling Spatial Semantics in Spatial Text-to-SQL","year":2024,"lang":"en","type":"article","venue":"","topic":"Data Management and Algorithms","field":"Computer Science","cited_by":0,"is_retracted":false,"has_abstract":true,"ca_institutions":"","funders":"Chongqing Municipal Education Commission; Ministry of Natural Resources","keywords":"Computer science; SQL; SQL/PSM; Programming language; Data definition language; Semantics (computer science); PL/SQL; Database; Query by Example; Information retrieval","routes":{"ca_aff":false,"ca_fund":true,"ca_venue":false,"about_ca":false,"invisible_to_affiliation_only":true},"retraction":null,"screen":null,"direct_labels":[],"prediction":{"model_version":"metacan-v3-hybrid-931329e0061c","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.002744767,0.001417581,0.0008159932,0.002404964,0.0006211222,0.003338707,0.002574224,0.001357483,0.004367913],"category_scores_gemma":[0.008548929,0.0006688811,0.002247935,0.002450297,0.001521844,0.008403293,0.00281636,0.001751387,0.001857072],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.001475824,"about_ca_system_score_gemma":0.002271658,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.007921009,"about_ca_topic_score_gemma":0.01030803,"domain_scores_codex":[0.997328,0.000666341,0.0004566507,0.0006461581,0.000775504,0.0001272253],"domain_scores_gemma":[0.9958988,0.001697461,0.0003828451,0.001215264,0.0006778882,0.0001276915],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"theoretical_or_conceptual","study_design_gemma":"not_applicable","study_design_scores_codex":[0.0008936951,0.0006064968,0.02342949,0.002623694,0.0003319445,0.001236668,0.003516131,0.2101618,0.02310621,0.3513841,0.09388513,0.2888247],"study_design_scores_gemma":[0.00008450944,0.0001224483,0.001643369,0.0001343605,0.00008135266,0.0003541555,0.0005570428,0.7194221,0.0184124,0.1733817,0.08572128,0.00008531704],"study_design_candidate":"not_applicable","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.01300349,0.00022543,0.9390146,0.0006138591,0.00005993071,0.0003787711,0.01243561,0.03266291,0.00160532],"genre_scores_gemma":[0.1723033,0.0004072946,0.7835488,0.000711644,0.00008491432,0.0005706968,0.03704521,0.002803481,0.00252476],"genre_candidate":"empirical","genre_consensus":null,"teacher_disagreement_score":0.007921009,"threshold_uncertainty_score":0.01574981,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.01877647370813558,"score_gpt":0.2581648012388266,"score_spread":0.2393883275306911,"validation_status":"score_only:v0-immature-baseline","note":"Baseline scores from an immature model (maturity gate not passed). Scores rank; they never assert a category."}}