ã“ã“ギコï¼: PostGIS：çƒé¢åº§æ¨™ç³»ã«å¯¾å¿œã™ã‚‹ã‚‰ã—ã„＆ãã®ä»–雑話題PostGISãŒ1.5ã‹ã‚‰ã€çƒé¢åº§æ¨™ç³»ã«å¯¾å¿œã™ã‚‹ã¿ãŸã„ã§ã™ã€‚ PostGIS does Geography - Postgres OnLine Journal OpenGeo : Geodetic Types Paul Ramsey: PostGIS gets Spherical (Directors Cut) ã“ã‚Œã¾ã§ã®PostGISã§ã®Geometryデータ型ã§ã¯ã€å¹³é¢åº§æ¨™ç³»ã§ã‚ã£ãŸãŸã‚ã€çµŒåº¦ãƒ»ç·¯åº¦ã§ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã™ã‚‹ã¨è·é›¢æ¼”ç®—ã®é–¢æ•°ã¨ã‹ã‚‚ãã®åº§æ¨™ç³»ä¸Šã§ã®ä¸‰å¹³æ–¹ã®å®šç†æ¼”ç®—ã«ãªã£ã¦ã—ã¾ã„ã€çƒé¢ä¸Šã®2点ã¨ã—ã¦çµæžœã‚’mã§è¿”ã—ã¦ãれるよã†ãªã“ã¨ã¯ã‚ã‚Šã¾ã›ã‚“ã§ã—ãŸã€‚ distance_sphereã€distance_spheroidã®ã‚ˆã†ãªé–¢æ•°ã‚‚ã‚ã‚Šã¾ã—ãŸãŒã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’効ã‹ã›ãŸæ¼”ç®—ã¯ã§ãã¾ã›ã‚“ã§ã—ãŸã—ã€ã“ã‚Œã¾ã§ã®PostGISã§çƒé¢ä¸Šè·é›¢ã§ã®æ¤œç´¢ç‰ã‚’è¡ŒãŠã†ã¨ã™ã‚‹ã¨ã€åœ°å›³æŠ•å½±æ³•ç‰ã®çŸ¥è˜ã‚’駆使ã—
ã“ã“ギコï¼: GoogleMapsã¨é€£å‹•ã—ãŸã„ãªã‚‰PostGISã®ä»–ã«mysqlã¨ã„ã†é¸æŠžè‚¢ã‚‚出ã¦ããŸã€€ã‚ã¨ã‚¸ã‚ªãƒ¡ãƒ‡ã‚£ã‚¢ã‚µãƒŸãƒƒãƒˆé–¢è¥¿ã‚‚
{{#tags}}- {{label}}
{{/tags}}