{"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":"codex-gemma-dda1882f352a","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.0003119467,0.0001448399,0.0001346309,0.000297065,0.00004645263,0.0007337122,0.0008888705,0.00003970641,0.00006576668],"category_scores_gemma":[0.0000178184,0.000127637,0.00004551992,0.0005602016,0.00001049069,0.0007691362,0.0008500008,0.0001402476,0.0006986053],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00003369576,"about_ca_system_score_gemma":0.00003807558,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.001611094,"about_ca_topic_score_gemma":0.0008632038,"domain_scores_codex":[0.9985632,0.00002277027,0.0002467955,0.0005164932,0.0003182163,0.0003325681],"domain_scores_gemma":[0.9993899,0.0000305138,0.00001362072,0.0004611864,0.00002235051,0.00008242594],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"design_other","study_design_gemma":"simulation_or_modeling","study_design_scores_codex":[0.000006184677,0.0001004217,0.0004519756,0.0001100755,0.00002672825,0.0003377579,0.000892359,0.02075246,0.0001438762,0.1196522,0.007582077,0.8499439],"study_design_scores_gemma":[0.0001190054,0.00003348243,0.0001465234,0.0000490374,0.000004483497,0.000002094046,0.00001855922,0.9893674,0.0001158063,0.002010655,0.007942433,0.0001905592],"study_design_candidate":"simulation_or_modeling","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.003647697,0.0000425345,0.985008,0.003127275,0.001127928,0.0001771137,0.0000044805,0.0003547013,0.006510283],"genre_scores_gemma":[0.9357864,0.00001651262,0.06124187,0.0005084718,0.000312986,0.00001030498,0.00001206204,0.00001492695,0.002096416],"genre_candidate":"methods","genre_consensus":null,"teacher_disagreement_score":0.9686149,"threshold_uncertainty_score":0.897939,"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."}}