ããã«ã¡ã¯
ç§ãããšã¯ã»ã«ãããã¹ããšãã£ã¿ã®çœ®ææ©èœãªã©ã§å¯Ÿå¿ããã»ãã
ç¶æ³ã確èªã§ããããã®ã§ã¯ãªãããšæããŸãã
ãšã¯ã»ã«ã§ã®äœæ¥ã¯ã
ãã»ãšã¯ã»ã«ãéãã Ctrl+A ã§å
šã»ã«éžæããæžåŒãæšæºããæååã«å€æŽ
ãã»QGIS ã®å±æ§ããŒãã«ãéãã Ctrl+A ã§å
šå°ç©éžæãã Ctrl+C ã§ã³ããŒ
ãã»ãšã¯ã»ã«ã«è²Œãä»ã
ã§äœçœ®æ
å ±ä»ãã§è»¢èšã§ããŸãããšã¯ã»ã«é¢æ°ãªã©å©çšããç®çã®æäœãã§ããã
ãã¿ãåºåãããã¹ããã®åœ¢åŒã§ä¿åãã QGIS ã«èªã¿èŸŒãŸããããšãã§ããŸãã
ïŒãããšã¯ã»ã«ã«è²Œãä»ãããã®ã«äœçœ®æ
å ±ãä»äžãããªãå Žåã¯ã¡ãã¥ãŒããŒã®èšå®â
ããªãã·ã§ã³âããŒã¿ãœãŒã¹ã®ãå°ç©ã®ã³ããŒãããWKT ãžãªã¡ããªãã確èªïŒ
次ç¹ã§ããã£ãŒã«ãåã¯ãã£ãŒã«ãèšç®æ©ã®ããã£ãŒã«ããšå€ãããå
¥åè£å©ã
å©çšã§ãããããå©çšãããšãããšæããŸãã
ãã ããå€ã« NULL ã®å Žåã¯ãé£çµçµæã NULL ã«ãªããã coalesce é¢æ°ã
ããŸããã»ããããã§ãããããããäžæŠãã£ãŒã«ãåã®éžæå
¥åãè¡ã£ãã®ã¡
ããã¹ããšãã£ã¿ã®çœ®ææ©èœãªã©ã䟿å©ã§ããäŸãšããŠ
coalesce("field1",'') || ' ' || coalesce("field2",'') || ' ' || coalesce("field3",'')
å¯èªæ§ãäœãããŸããã£ãŒã«ãé ãå
éšæ§é ãé¢ä¿ããã®ãã«ã©ã é ãšã¯äžèŽãã
ããŸãããããããŸããããã©ãããŠãäžçºã®åŒã§ããããå Žåã¯åè¿°ã®åŒãæååãšããŠ
çæãããããªåŒãäœããããã« eval é¢æ°ãé©çšããäžèšã®ãããªæ¹æ³ããããŸãã
ãããã«ããã®ã§ãæååãªãã©ã«ãéè²ã«ããŠããŸãã
空çœåºåãã§é£çµããããã«ãªã£ãŠããŸãããåºåãæåãå€ãããå Žåã¯
é»è²èæ¯ã®ç®æãå€æŽããŠãã ããã
eval(
  'coalesce("'
  ||
  array_to_string(map_akeys(attributes()), '",'''') || '' '' || coalesce("')
  ||
  '",'''')'
)